AGRIS Customer Documentation
How to Print a Backdated Reconciliation Report
The Bank Reconciliation Report does not have the ability to go back in time to print a reconciliation for another month.
It always prints (current bank balance less unreconciled transactions regardless of the dates you use) to get the Reconcile Balance Total.
If you are wanting to go back to get a Reconciliation Report from last December, for example, you have to run a series of reports.
These four reports will equal what a reconciliation report would have equaled back on Dec 31st:
Bank Register for current month to get current account balance
(bank Register for current date)Active Bank Recon report now
(Bank Reconciliation Report with blank dates)Plus/minus reconciled transactions since Dec 31st.
(Cancelled Transaction Register for Status Code X to X and Date Reconciled after Dec 31st)Plus/minus voids since Dec 31st
(Bank Register for Status code V to V for Trx Date after Dec 31st)
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
should equal what the Bank Reconciliation Report run in December would have been.
Another option is to go back to a copied dataset that does not have everything reconciled.
Print the bank recon from that copied dataset.
Example of a Bank Recon Report run in the month (June 2020) it was reconciled:
Example of reports used to back into a Bank Reconciliation Report run in June 2020
Bank Register $65,976.01
plus currently outstanding checks $10,000.00
less currently outstanding withdrawals $ 0.00
plus checks reconciled after 6/30/20 $15,073.99
less deposits reconciled after 6/30/20 $ 50.00
Plus checks voided after 6/30/20 $ 0.00
less deposits voided after 6/30/20 $ 1,000.00
= = = = = = = = = = = = = = = = = = = = = = = = =
Backed into 6/30/22 reconciled Bal $90,000.00 which matches the original report run on 6/30/20 above.
Bank Register for Current Month
Bank Reconciliation Report for current date:
Plus/Minus Transactions Reconciled AFTER 6/30/20.
Plus/Minus Voided Transactions AFTER 6/30/20
3820 Mansell Road, Suite 350 ✦ Alpharetta, GA 30022 ✦ www.GreenstoneSystems.com
© 2011 - 2024 Cultura Technologies LLC. All Rights Reserved Worldwide. Products and company names mentioned herein may be trademarks or registered trademarks of their respective owners.