Settings and activity
1 result found
-
64 votes
Thanks for sharing your idea, and sharing how an invoice report which includes the account, date paid, method of payment would be useful, Donald.
Make sure you share your idea with any colleagues that this could benefit so they can add their vote too!
We will keep an eye out on the traction this idea receives in the community. Thanks
An error occurred while saving the comment
I'd like to add a slightly different requirement to this request.
We have many clients and users who need to report on customer receipts and allocations, but the current reporting options do not provide the detail required.
The closest report we have found is the Account Movement Report, however it still does not solve the problem because it reports the bank transaction reference rather than the allocation details linked to the transaction.
What is needed is a report that is driven by the Payment Date and not the Invoice Date.
For example, if an invoice was issued in October 2025 but only paid in April 2026, the transaction should appear on the April 2026 report because that is when the payment was received.
The report should include:
Contact / Customer Name
Invoice Number
Invoice Date
Payment Date
Amount Allocated to the Invoice
Total Payment Amount
Payment Reference (where applicable)
Most importantly, the report should show the allocation of the payment.
For example, if a customer pays R15,000 and that payment is allocated as follows:
INV-1001 = R5,000
INV-1025 = R7,000
INV-1038 = R3,000
The report should show each allocation line individually while still linking them back to the original payment transaction.
This would also be extremely valuable for debt collection and accounts receivable users. In many organisations these users do not have access to the bank account or the bank reconciliation screen, yet they still need visibility of payments received and how those payments were allocated against customer invoices.
At present there is no simple way for these users to produce a report showing cash received during a specific period together with the invoice allocations that make up that receipt, without being granted access to banking functions.
This is a common requirement for debtors analysis, collections, audit support, cashflow reporting, customer account reconciliations, and management reporting. Existing reports provide pieces of the information, but not the complete picture in a single report.