Scribd Logo
Upload

Welcome to Scribd!

  • 38 views

    Creditors Oustanding Statement

    Uploaded by

    Dilan Maduranga Fransisku Arachchi
    This document contains a creditors outstanding statement for Sri Lankan Catering as of March 31, 2017. It lists amounts owed to four creditors - Golden Star, Korapathra, Swahaney, and AASL - including invoice numbers, dates, due dates, currencies, and original/outstanding amounts. It provides subtotals for each creditor and grand totals for all creditors in both USD and LKR currencies. Debit notes and credit notes are included and payments made are shown against outstanding invoices.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd

    Creditors Oustanding Statement

    Uploaded by

    Dilan Maduranga Fransisku Arachchi
    38 views4 pages
    This document contains a creditors outstanding statement for Sri Lankan Catering as of March 31, 2017. It lists amounts owed to four creditors - Golden Star, Korapathra, Swahaney, and AASL - including invoice numbers, dates, due dates, currencies, and original/outstanding amounts. It provides subtotals for each creditor and grand totals for all creditors in both USD and LKR currencies. Debit notes and credit notes are included and payments made are shown against outstanding invoices.

    Original Description:

    kbbk

    Copyright

    © © All Rights Reserved

    Available Formats

    XLS, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains a creditors outstanding statement for Sri Lankan Catering as of March 31, 2017. It lists amounts owed to four creditors - Golden Star, Korapathra, Swahaney, and AASL - including invoice numbers, dates, due dates, currencies, and original/outstanding amounts. It provides subtotals for each creditor and grand totals for all creditors in both USD and LKR currencies. Debit notes and credit notes are included and payments made are shown against outstanding invoices.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    38 views4 pages

    Creditors Oustanding Statement

    Uploaded by

    Dilan Maduranga Fransisku Arachchi
    This document contains a creditors outstanding statement for Sri Lankan Catering as of March 31, 2017. It lists amounts owed to four creditors - Golden Star, Korapathra, Swahaney, and AASL - including invoice numbers, dates, due dates, currencies, and original/outstanding amounts. It provides subtotals for each creditor and grand totals for all creditors in both USD and LKR currencies. Debit notes and credit notes are included and payments made are shown against outstanding invoices.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    of 4

    SRILANKAN CATERING

    CREDITORS OUSTANDING S

    Creditor Name All


    Creditor Code
    45
    Creditor Invoice Invoice Due Currency Original Invoice Payment
    Name Number Date Date Amount
    Golden Star 23500 2-Nov-16 17-Dec-16 USD 25,000 -
    Golden Star CN 12 2-Nov-16 USD (5,000)
    Golden Star 23555 3-Dec-16 17-Jan-17 USD 45,000
    SUB TOTAL 65,000 -

    Korapathra 234 2-Dec-16 16-Jan-17 USD 35,000 5,000


    Korapathra 451 2-Jan-17 16-Feb-17 USD 26,000 -
    Korapathra DN 101 2-Jan-17 16-Feb-17 USD 1,350 -
    SUB TOTAL 192,350 5,000

    Swahaney 12181 2-Oct-15 16-Nov-15 USD (50,000) (50,000)


    Swahaney 12282 2-Nov-16 17-Dec-16 USD 75,000 -
    Swahaney 12325 2-Dec-16 16-Jan-17 USD 550 -
    SUB TOTAL 25,550 (50,000)

    AASL 356 2-Oct-15 16-Nov-15 LKR 2,500,000


    AASL 124 2-Nov-16 17-Dec-16 LKR 7,560,000
    10,060,000 -

    Grand Total USD 282,900 (45,000)


    Grand Total LKR 10,060,000 -

    '---------Summary--------''
    Creditor Invoice Invoice Due Currency Original Invoice Payment
    Name Number Date Date Amount
    Golden Star USD 65,000 -
    Korapathra USD 192,350 5,000
    Swahaney USD 25,550 (50,000)
    257,350 5,000

    AASL USD 10,060,000 -


    10,060,000 -

    Points to be noted
    02. DNs and CNs to be shown.
    03. Payments made to be shown for invoices only if outstanding as at the date of aging report.
    04. Original invoice amount to be shown against the outstanding amounts.
    05. The above statement should be in one report with no extra rows or spaces.
    06. Grand total and a summary to be shown as mentioned above.
    07. Creditors name and period should be able to be selected. All creditors should apprear when selecting ''all''
    08. All the above rows and columns should be shown separately and format should not be changed.
    09. This statement should be able to be converted excel and PDF.
    10. This statement should be able to be sent to credtopr via email from Oracle.
    N CATERING LIMITED
    USTANDING STATEMENT

    Period as at 03/31/2017

    Total Outstanding 1-30 Days 31-60 Days 61-90 Days 91-180 Days 181-360 Days 361+ Days
    Amount Past Due Past Due Past Due Past Due Past Due Past Due
    25,000 25,000
    (5,000) (5,000)
    45,000 45,000
    65,000 - 45,000 20,000 - - -

    30,000 30,000
    26,000 26,000
    1,350 1,350
    187,350 - 117,350 70,000 - - -

    (50,000) (50,000) -
    75,000 75,000
    550 550
    25,550 - 550 75,000 (50,000) - -

    2,500,000 2,500,000
    7,560,000 7,560,000
    10,060,000 10,060,000 - - - - -

    277,900 - 162,900 165,000 (50,000) - -


    10,060,000 10,060,000 - - - - -

    ------Summary--------''
    Total Outstanding 1-30 Days 31-60 Days 61-90 Days 91-180 Days 181-360 Days 361+ Days
    Amount Past Due Past Due Past Due Past Due Past Due Past Due
    65,000 - 45,000 20,000 - - -
    187,350 - 117,350 70,000 - - -
    25,550 - 550 75,000 (50,000) - -
    252,350 - 162,350 90,000 - - -

    10,060,000 10,060,000 - - - - -
    10,060,000 10,060,000 - - - - -
    electing ''all''

    You might also like