I need help to find a way to know which checks were still outstanding on a specific past date. I’m running on Odoo 8 (but this question also applies to Odoo 13 since I’m upgrading right now) and I use the bank account reconciliation module in Odoo’s accounting. So I import my bank statements in Odoo and reconcile my accounting records with my bank statements.
Example :
Let’s say I have to pay $500 to one of my suppliers. So, on December 1st 2018, I sign a $500 check and send it by regular mail and create the proper accounting records in Odoo’s Accounting. But then, the check gets lost in the post system and my supplier never receives it.
On March 1st 2019, I want to verify if there are some checks that weren’t ever deposited by my suppliers or were lost (because I’m a good person and I want to make sure that my suppliers get paid in due time). I can easily obtain that information by using filters and by looking for non-reconciled items in Odoo’s accounting. I’ll find the $500 check record and I’ll see that it doesn’t have any reconciliation number (which means it’s not reconciled with my bank account and thus not deposited by my supplier). I’ll then be able to call my supplier and verify if he’s never received my check.
But if, on March 1st 2019, I want to know which checks were still non-reconciled on January 1st 2019 (a past date), it seems that I don’t have any way to do it. I cannot use the same filter as I did above. Filtering by non-reconciled items wouldn’t work because the check could have ben deposited on February 15th and would then appear as reconciled with my bank account on March 1st 2019. So it seems there is no way for me which checks were still outstanding on a past date.
Any idea?
Thank you very much for your help! It is much appreciated.
P.S. : English isn’t my mother tongue, so if anything above wasn’t clear, please do not hesitate to tell me!