The Aged Receivable report in MoneyWorks accounting software

Software: MoneyWorks #accounting software

The aged receivables report (not Cashbook) provides a summary of outstanding sales invoices by age of invoice. The report can base the ageing on:

Manually: As done by the Age Receivables command (page 144). You normally do this after printing your statements (usually at the end of each month).

Calculated: The ageing is calculated “on-the-fly” when the report is printed. This is independent of any manual ageing. Calculated ageing can be done for 7 days, 14 days, 30 days and by period. When calculated by days, the transaction date of the invoice is used, whereas the period of the invoice is used for ageing by period. Retrospective reports can be done when ageing is calculated by period.

— MoneyWorks v7 User Guide page 167 — Aged Receivables

The Aged Receivable Report (Accounts Receivable Ageing report) shows a list of unpaid sales invoices and credit notes. The accountant uses it as a tool to determine which invoice is overdue for payment.

On 10 April 2016, which is for the accounting period April, you invoiced the customer with a 30 days payment terms.

On 5 May 2016, you print an Aged Receivable report with perimeter set to age by the period. The outstanding invoice, which is from the previous accounting period, is categorised as one month due.

Aged Receivable

If the perimeter of the Aged Receivable report has changed to age by 30 days, the outstanding amount is considered as current since the reporting date is before the invoice due date.

Comments are closed.