How to show Payments / Deposits paid on Customer Tax Invoice

Sue Jones
Sue Jones Member Posts: 67 ✭✭
edited July 2020 in Accounts Hosted
Just wonder if there is a way to show Each Payment / Deposit paid on the Customer Tax Invoices besides the lump sum figure when Balance Due is selected in the Footer Section when Customising the Invoice template?

Comments

  • Peter Darrell
    Peter Darrell Member Posts: 6
    edited February 2018
    I spent hours on that a few months back, I can't even find anything on it or any data fields that would work either. Even google come up a blank.
  • Acctd4
    Acctd4 Accredited Partner Posts: 3,366 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert
    edited September 2019

    Hi Sue & Peter

    You can add the "Payments/Credits" field to the template (on the "Footer" tab of the template's "Additional Customisation" window, above the "Balance Due") which will show the total payments applied.

    Unfortunately, individual payments can't be automatically displayed on an invoice.  However, you could create a report for this, modify it & memorise for re-use when required.  To find the relevant transactions:
    • Go to the "Advanced" tab of your "Find" screen (Edit > Find in the toolbar menu)
    • In the Filter box, select "Name" & enter/select the applicable customer in the dropdown list
    • Again in the Filter box, select "Transaction Type" & (assuming all your customer payments have been entered via this) select "Payment" from the dropdown list.
    • If applicable, select the "Date" filter also & modify accordingly
    • Scroll down in the Filter box & select "Detail Level" then select the "Summary only" option
    • Once you have the payments summarised, click on the "Report" button to turn your search into a report.  (If necessary, you can then tweak this report further by clicking on the "Modify Report" button & editing the display & text formats.  You can give it a meaningful name via the "Header/Footer" tab)
    Hope that helps :) 


    Shaz Hughes Dip(Fin) ACQ NSW, MICB

    *** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***

    * Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *

    Accounted 4 Bookkeeping Services

    Ballajura, WA

    shaz@accounted4.com.au

    https://accounted4.com.au

    (NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)
  • Aleisha_8341887
    Aleisha_8341887 Member Posts: 25
    edited July 2020
    You could also just add each payment onto a description line of the invoice (using text only, not affecting the amounts columns) so it is there for easy reference for the customer.