Statement past due dates seem incorrect

Question

I do not think the ageing is working correctly on my customer statements. How are the past due dates calculated?

 

Answer

The past due date calculation, and hence the columns for which outstanding invoices are placed in the statement days past due footer, are determined by two things:


  1. The ageing reports setting. These can be found by navigating to Edit > Preferences > Reports & Graphs > Company Preferences > Ageing reports


This will determine whether the statements are aged from the due date of the invoice, or the invoice date itself.

The Ageing Reports setting also affects A/P and A/R ageing reports.

  1. The statement period from and to dates (if using the statement period option) or the statement date (if using the all open transactions as of statement date option).


Field

Purpose

Statement date

The date noted on the statement. This generally should be the same as the period to date.The statement date has no bearing on the ageing calculations when the statement period option is selected.

Statement period [option]

From (date)

Lists all transactions (invoices, payments and credits) from this date. Prior dated transactions will appear as balance forward.

Statement period [option]

To (date)

Determines the date of the last transactions shown on the statement when the statement period option is selected.

This date directly affects the ageing as it is essentially an "as at this day" date. For example, if the customers invoice is due on April 30, and this date is April 30, the customers invoice is NOT overdue "as at this day" and will show as a current invoice on the statement.

All open transactions as of the statement date [option]

Lists all open invoices, their original amount and balances up to and including the statement date.

Include only transactions over x days past due date

Limits the number of transactions shown on the statement based on how many days the invoice is overdue when using the all open transactions as of the statement date option.

How did we do?

Dealing with Suppliers that are also Customers.

The account does not exist when selecting an account for a Bill or Write Cheque

Related Articles

Activity Statements
Due Date appears beside my invoices on the statement?
Creating customer statements
Powered by HelpDocs (opens in a new tab)

Powered by HelpDocs (opens in a new tab)