supplier remittance

GJBGJB Member Posts: 5
edited September 2019 in Accounts Hosted
Is it possible to generate a report for a supplier which shows the original invoice amount and credit applied? I have a major supplier who has requested that not only we send a remittance but also original value, any credit allocated and paid amount?


  • Acctd4Acctd4 Accredited Partner Posts: 929 ✭✭✭
    edited September 2019

    Hi GJB

    If you apply the supplier credit in the same transaction as recording the "Pay Bill" payment, the Credit will actually be listed on the Remittance.

    Alternatively, you can generate & tweak the Supplier Balance Detail report (under Reports > Suppliers & Payables):

    • In the Supplier Balance Detail report, click on "Modify Report"
    • On the Display tab, click on "Advanced" & select the "Gross" tax basis option, then "OK"
    • Select/enter the date range of the bills paid/credits allocated.  You can also add/remove columns in the "Columns" list, according to the data you want displayed (eg Debit, Credit etc)
    • On the Filters tab, select Name & enter/select the applicable Supplier
    • To list Bills & Credits only (without Bill Payments - as per a Remittance Advice), select Transaction Type then Multiple Transaction Types in the dropdown list.  Tick Bill & Bill Credit, then click "OK"
    • On the Header/Footer tab if preferred, you can enter a more specific title (in the "Report Title" field)
    • Lastly once you've customised the report to exactly what you want, Click on "Memorise" to save it for future re-use when all you will need to do is change the date range for the applicable bill/credit transactions :)

    Shaz Hughes Dip(Fin) ACQ NSW, MICB

    Reckon Accredited Partner (AP) Bookkeeper * Regd BAS Agent (No: 92314 015) *

    ICB-Certified Bookkeeper * Seasonal Tax Consultant since 2003

    Accounted 4 Bookkeeping Services

    Ballajura, WA

    0422 886 003

    [email protected]

Sign In or Register to comment.