Statements - Show actual outstanding amount instead of as at date
Addition option of show customer statement "actual" outstanding instead "as at" date.
Eg, Our customer ABC need us to furnish a Outstanding statement that as at 30 June 2023, and there is 4 invoice unpaid. Happen that 15 July 2023the customer pay the 3 invoices only. Customer request us to send the statement show the 1 unpaid invoice dated 30 June 2023 but it still shows 4 outstanding, how can we show the the one unpaid invoice in the statement.
Ideal additional option of show date 30.6.23 and show the one 1 unpaid invoice only. Kindly advice.
Yen Khai Lim
shared this idea
-
kelly zhen
commented
Please improve how the Outstanding Statement works. When selecting an “as at date,” the statement should show only invoices that remain unpaid and any unallocated credits as of that date.
Example 1 (Credit Note shown when it should not be):
When generating an Outstanding Statement as at 16 Feb 2026, a credit note dated 16 Feb 2026 (CN-8789) appears on the statement even though it was already allocated to an invoice dated 20 Jan 2026. This credit is not truly outstanding, but it still appears because its issue date falls within the selected range.Example 2 (Payments showing as £0 when invoices are already paid):
When generating an Outstanding Statement as at 2 Feb 2026, several invoices appear with Payments = £0, even though those invoices were already paid on 11 Feb 2026 in the customer account. This makes it look like the invoices are unpaid when they are actually settled.This behaviour is confusing because an Outstanding Statement should reflect only balances that remain unpaid at the selected date, not all transactions whose issue, reconciliation, or allocation dates fall within the range. Showing full transaction history belongs in the Activity Statement, while the Outstanding Statement should be a clean list of unpaid invoices and unallocated credits only.
Currently, the only workaround is exporting invoice reports to Excel and manually removing unrelated credits or paid invoices, which is time-consuming and prone to mistakes.
Improving this would make statements clearer and more accurate for users and their customers.