# Paid Invoice Showing as Due in Aged Receivables **URL:** \ **Category:** Uncategorized\ **Created:** [August 25, 2016, 1:59am UTC](https://forum.manager.io/t/paid-invoice-showing-as-due-in-aged-receivables/6775 "2016-08-25T01:59:53Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![Peta](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/peta/32/4048_2.png) [@Peta](https://forum.manager.io/u/Peta)\ **Post date:** [August 25, 2016, 1:59am UTC](https://forum.manager.io/t/paid-invoice-showing-as-due-in-aged-receivables/6775/1 "2016-08-25T01:59:53Z")
I’ve just noticed that two invoices that have been paid in full have a balance due showing on the Aged Receivable Report. When I click on the link to see which invoice the amount is due on it shows as being fully paid. The invoices are in a foreign currency. I thought this might have to do with Foreign Exchange but the amount ‘due’ is not exactly the same as the Foreign Exchange amount showing in the Customer account. Please help. ![](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/f/f8a560c79f9ea3d3688a5fe34492463f65b1bdd7.png) ![](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/3/3550dafb799eee71e32de84c3d22db215637dde7.png) ---
**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:** [August 25, 2016, 2:24am UTC](https://forum.manager.io/t/paid-invoice-showing-as-due-in-aged-receivables/6775/2 "2016-08-25T02:24:07Z")
I bet if you look at the invoice in question, you’ll find that the `Due Date` field is empty. See the trouble report I filed recently on exactly this issue, which @Lubos has not responded to yet: > [@Aged Receivables report breaks if no Due Date is entered](https://forum.manager.io/t/aged-receivables-report-breaks-if-no-due-date-is-entered/6749): > > There’s a problem with the Aged Receivables report. Invoices that are created without a Due Date all seem to come up under an “Overdue” column, even if they were just created. I would think that an invoice without a Due Date would always be current (“Coming Due”), by definition. Here is an example. The $127.16 invoice has a due date that hasn’t arrived yet, while the $600.00 invoice has no due date: [image] In the Aged Receivables report, the $127.16 invoice appears appropriately as Coming D… (If your invoice’s `Due Date` is not empty, then you’ve likely identified another issue with the same report.) ---
**Author:** ![Peta](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/peta/32/4048_2.png) [@Peta](https://forum.manager.io/u/Peta)\ **Post date:** [August 25, 2016, 2:42am UTC](https://forum.manager.io/t/paid-invoice-showing-as-due-in-aged-receivables/6775/3 "2016-08-25T02:42:08Z")
Thanks Jon, I thought you’d resolved that for me but… no luck sorry. Both of the invoices definitely have a Due Date ![](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/5/537958b5e1c17f7e9cbf2727048ffac2bc1ea037.png) ---
**Author:** ![dalacor](https://avatars.discourse-cdn.com/v4/letter/d/7bcc69/32.png) [@dalacor](https://forum.manager.io/u/dalacor)\ **Post date:** [August 25, 2016, 8:04am UTC](https://forum.manager.io/t/paid-invoice-showing-as-due-in-aged-receivables/6775/4 "2016-08-25T08:04:53Z")
See if you have any foreign exchange gains/losses on the profit and loss. I have had this issue before with foreign exchange and it was always down to a missed exchange rate somewhere along the line. ---
**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:** [August 25, 2016, 9:39am UTC](https://forum.manager.io/t/paid-invoice-showing-as-due-in-aged-receivables/6775/5 "2016-08-25T09:39:35Z")
On which date was this invoice paid and for which date is this report generated for? ---
**Author:** ![Peta](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/peta/32/4048_2.png) [@Peta](https://forum.manager.io/u/Peta)\ **Post date:** [August 25, 2016, 12:14pm UTC](https://forum.manager.io/t/paid-invoice-showing-as-due-in-aged-receivables/6775/6 "2016-08-25T12:14:27Z")
The first invoice (balance showing $64.72) was paid on 3 May. The second invoice (balance showing $ was paid on 21 July. The report was generated for today’s date, it’s actually saved to be current every time I run it but just to be sure I created a new report and the amounts are still showing as outstanding. ---
**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:** [August 25, 2016, 12:30pm UTC](https://forum.manager.io/t/paid-invoice-showing-as-due-in-aged-receivables/6775/7 "2016-08-25T12:30:14Z")
Then this is a bug. Under no circumstances should paid invoice show in aged receivables report if it was paid by the date of the report. Any chance you could send me your accounting file to `lubos@manager.io` ? ---
**Author:** ![Peta](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/peta/32/4048_2.png) [@Peta](https://forum.manager.io/u/Peta)\ **Post date:** [August 25, 2016, 12:41pm UTC](https://forum.manager.io/t/paid-invoice-showing-as-due-in-aged-receivables/6775/8 "2016-08-25T12:41:34Z")
On it’s way now. Thanks for your help 🙂 ---
**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:** [August 26, 2016, 2:24am UTC](https://forum.manager.io/t/paid-invoice-showing-as-due-in-aged-receivables/6775/9 "2016-08-26T02:24:15Z")
Alright, the issue was that Manager didn’t really dig deep enough to calculate exchange gains (losses) on each invoice individually. But I don’t really want Manager to go this far as there are really no benefits (other than having aged receivables and aged payables report to show correct figures in base currency). So the best idea I could come up with is to simply show invoice balances on aging reports in their currency. ![](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/f/ff4e1dedd5796753cc4762f34c0d1fd5281a1853.png) Perhaps this is even better approach as seeing how much customer owes in foreign currency is more practical anyway. This update is in the latest version (16.8.80) ---
**Author:** ![Peta](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/peta/32/4048_2.png) [@Peta](https://forum.manager.io/u/Peta)\ **Post date:** [August 27, 2016, 10:27pm UTC](https://forum.manager.io/t/paid-invoice-showing-as-due-in-aged-receivables/6775/10 "2016-08-27T22:27:10Z")
Brilliant, thank you. I think that’s a great idea and, yes it is a great idea and very useful to show the Aged Receivables in the customers base currency. ---
**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:31pm UTC](https://forum.manager.io/t/paid-invoice-showing-as-due-in-aged-receivables/6775/11 "2023-01-18T15:31:37Z")