You can configure the Accounts Receivable Balance Report to view all transactions contributing to your current debtors account balance as at a specific date, helping ensure accurate point-in-time reconciliation with your accounting package. This improves your retail operations by providing clear visibility into outstanding account customer balances and promotional voucher handling, with properly configured receivables tracking typically achieving better accounts receivable management and faster period-end reconciliation.
Setting up accounts receivable balance reporting involves understanding account customer sales classification, promotional voucher inclusion options, and general ledger asset account movement to help retail operators focus on the right balance verification tasks, ensuring your retail strategy consistently drives better financial accuracy outcomes.
The Accounts Receivable Balance Report details all transactions that contribute to the current balance in your Accounts Receivable account as at a specific date.
- Account sales includes all sales made to an Account Customer, even if they are sold as "Cash and Carry". These will all move through your debtors account in your accounting package.
- Your Accounts Receivable sales will move through a General Ledger Asset account, not your linked control account for Trade Debtors.
- Sales are flagged at the time they are committed. If a customer has their account terms removed, any sales created prior will continue to be considered account customer sales.
To use the Accounts Receivable Balances Report:
- Navigate to: Reports > Accounting Reports > Accounts Receivable Balances Report
- Select the As At Date i.e. the date you would like to see the balance for
- Select whether to Include Promotional Vouchers in the balance
Promotional Vouchers issued via the Customer Activity Report are "Unpaid", and will be uploaded to the Accounts Receivable account for manual handling. - Update the remaining Filters as required
- Click Search
- The results will be displayed grouped by Order Number
For more information on these figures please refer to the Accounting Integration articles.