Recording an Advanced Payment from a Customer

Recording an Advanced Payment from a Customer

There are times when a customer (debtor) may pay in advance for goods being delivered or services being provided, i.e. you may receive an advance payment before anything is done to earn the payment.

For the purposes of illustration, we will use agistment income paid in advance. A customer has paid $3,300 for agistment in advance.

To record an advanced payment in Cashbook:

  • Click on the Debtors toolbar icon
  • Click on the Setup tab
  • Unapplied Payments Account - select and account from the drop-down list. e.g. 001 Agistment Received
Note: Unapplied Payments Account are used as a default account when the system creates a credit note for advance payments, etc. So select an account that is most commonly related to payments in advance.
  • Make sure Customer Receipting is set to Optional or Compulsory
    • If Compulsory is selected, this will be the only available method of recording payments from customers.
    • If Optional is selected, a receipt can be recorded using any of the 3 methods. (Preferred Choice)
  • Click on the Close button to exit
 
  • Still in Debtors
  • Click on the Receipts tab
  • Click on the Add button
    • Enter receipt information
    • Tick the Single receipt banked to check box to added transaction to Cashbook
    • Select a bank account from the drop-down list
    • Enter Bank Date
    • Click OK to save
Note: If the payment amount exceeds the total of outstanding invoices (e.g. in the case of a deposit paid), the system will prompt to create a credit adjustment note which will show the customer's balance as a credit amount. The account allocation (including any GST amount) for the credit note is taken from the default setting for "Unapplied Payments Account" as per the Debtors / Setup tab.
  • Click Yes to the following Confirm message:
 
  • Click on the Invoices tab 
    Note: Credit Notes are entered as a negative amount

 To apply invoice to Credit Note:

  • Click on the Cashbook toolbar icon
  • Click on the Add button
  • Click Yes to Confirm message: 'Do you want to enter transactions for "Working Account", in company file "Company ABC"?'
  • Click on the Receipt (deposit) radio dial
  • Enter date of invoice
  • In the Received From text box, either type in / select customer name or click on the Invoices button
  • Tick the checkboxes in the column next to the respective credit note and invoice to apply
  • Make sure the Amt Paid amount of the Credit Note is the same amount as the Invoice (Note: Credit Note amount is negative.)
  • Click OK to save
 
Cashbook transaction should look like this:

 
  • Click on the Debtors toolbar icon
  • Click on the Invoices tab
  • Click on the Unpaid Invoices radial dial
  • The balance of the Credit Note remains as a Credit Note for that customer
 
  • Click on the Debtors toolbar icon
  • Click on the Reports tab
  • Click on the Statements radial dial
  • Select a date range (e.g. 01/07/2017 - 31/08/2017)
  • Select Customer/s
  • Tick Include Paid invoices, etc
  • Click on the Print button
 
For Example: - $3300 + $2156 + $ 2926 = $1782


Article ID 1992