# Overdue column on customer statement not calculating properly **URL:** \ **Category:** Uncategorized\ **Created:** [March 14, 2016, 11:12pm UTC](https://forum.manager.io/t/overdue-column-on-customer-statement-not-calculating-properly/5039 "2016-03-14T23:12:52Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Jon](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/jon/32/1915_2.png) [@Jon](https://forum.manager.io/u/Jon)\ **Post date:** [March 14, 2016, 11:12pm UTC](https://forum.manager.io/t/overdue-column-on-customer-statement-not-calculating-properly/5039/1 "2016-03-14T23:12:52Z")
The `Overdue` column on the `Customer Statement` `Unpaid Invoices` report is not always calculated correctly. If the Statement date (the one you enter in the `Until` field and which is printed on the statement itself) is chosen as today’s date, the calculation is correct. If the Statement date is chosen as any other day (e.g., tomorrow or next week or the first of last month), the `Overdue` column still reflects the number of days overdue through today, rather than through the date that appears on the statement. In other words, it should be:       `Overdue` = `Statement Date` - `Due Date` Instead, it currently is:       `Overdue` = `Today's Date` - `Due Date` Sometimes there is a need to run a set of statements in advance, such as when doing an advance print-and-envelope-stuff run. At any rate, since the only date shown on the Statement is the Statement date, the `Overdue` column should be based on Statement date. This also matters if I ever need to regenerate a previous Statement, as invoices that weren’t even past due yet appear to have been. (The ageing of the receivables in the table on the top of the statement, on the other hand, correctly reflects the Statement date.) ---
**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\ **Post date:** [March 14, 2016, 11:39pm UTC](https://forum.manager.io/t/overdue-column-on-customer-statement-not-calculating-properly/5039/2 "2016-03-14T23:39:03Z")
Thanks. Fixed. [https://forum.manager.io/t/fixed-overdue-column-in-customer-statement-and-supplier-statement-16-3-7/5040](https://forum.manager.io/t/fixed-overdue-column-in-customer-statement-and-supplier-statement-16-3-7/5040) ---
**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\ **Post date:** [January 18, 2023, 3:34pm UTC](https://forum.manager.io/t/overdue-column-on-customer-statement-not-calculating-properly/5039/3 "2023-01-18T15:34:17Z")