A debtor ageing report can hide a changed invoice date

The debt suddenly looks younger

Suppose a customer asks for an invoice to be reissued with a corrected project reference. Accounts cancels the original and creates a new entry. At the next debtor review, the amount appears in the current column instead of the overdue column.

The report has changed, but the reason for the change needs checking. A newer system date should not silently rewrite the business's understanding of how long the account has been outstanding.

Recover the document trail

Find the original invoice, the correction request, the replacement and any credit or cancellation entry. Record what changed and why. Distinguish an administrative correction from a change to the amount or agreed payment terms.

Do not delete the earlier history to make the account look tidy. The reviewer needs to see how the replacement connects to the original transaction.

Check the contractual position separately

Read the relevant agreement and correspondence before deciding which due date applies. A reissue may have different consequences depending on the facts; the accounting software's ageing calculation cannot settle that question by itself.

Where the customer disputes the due date or a correction affects a formal payment process, seek appropriate advice. Avoid asserting that every reissue either resets the clock or leaves it unchanged.

Show both dates in the review

Keep the system invoice date alongside the original issue date and the due date being used for follow-up. Label any unresolved timing question. That lets management distinguish genuine current trading from older accounts that have moved columns.

business.gov.au's record-keeping guidance includes sales, invoices and payments among the records businesses should retain. Linking the documents makes those records more useful when the ledger presentation changes.

Source: business.gov.au: Record keeping

Check the total as well as the age

Make sure the original and replacement have not both remained collectible in the working debtor balance. Conversely, confirm that a credit has not removed the amount without the replacement being recorded.

Ask the bookkeeper to verify the accounting treatment. Keep any correcting entry traceable rather than editing the review spreadsheet to force a desired total.

Review recent reissues first

Filter the debtor list for invoices cancelled and reissued during the last reporting period. Match each pair, explain the reason and flag changes to ageing or amounts for the next review.

Use the corrected picture to plan follow-up. A reliable debtor review shows what changed in the documents and what remains uncertain, rather than letting a fresh invoice number make an old problem disappear.