The General Ledger (G/L) Reconciliation report is extremely useful for locating posting errors. The report displays imbalances between the various sub-journals and your general ledger. Your general ledger is the information that appears on your balance sheet or income statement. So, if the G/L Reconciliation report shows value in Differences column for your general bank, the figure that appears on your balance sheet will not be the same figure as your bank journal or your bank reconciliation.
To locate the error, run the reconciliation report on a date half way between now and your last closed month. If nothing shows up in the Differences column, the error occurred closer to today’s date. If a difference is displayed, the error occurred closer to the closed month. Repeat, cutting the time in half until you have located the date the error occurred.
Assume you are looking for a $250 error in the general bank. Run your general bank journal on the error date, and examine each $250 entry, making sure it was entered properly. You can also check for general ledger adjustments. This could also be two errors, $350 positive and $100 negative.
Maintaining your general ledger in balance on a regular basis can save you a lot of work. Having to go back and open closed months to correct errors takes extra time. I recommend placing the G/L Reconciliation button on your End of Month/Year Quick Step page, and using it before you do your monthly bank reconciliations.
Be aware that if you have never done a G/L Reconciliation, and you have 10 or 15 years of data, you will not be able to correct some of the older errors using conventional methods. Upgrades to the PCLaw program cut off access to some older entries.
In addition to helping my regular clients, I am happy to assist anyone on a consultancy basis, if they need help correcting errors in their General Ledger Reconciliation report, or anything else.
As always, I invite your comments and suggestions for future posting topics. Next week – End of Month (EOM) Reports.
Clyde
I don't know but sometimes even Tech Support is not able to fix G/L Recon Diffs - and I am from outside Canada. I had one of my offices that had Differences and they related to Nov/Dec 2010. The errors were such that even running VDI, undoing Bank Recs/multiple T-G Transfers, etc (done on backed up data) could not help. So on to PCLaw Support and after several days, hours on phone and working with 3 Engineers together, everything failed and they were not able to fix from the back end and the advice given was to pass a G/L Adjustment to Control account - omg!
ReplyDeleteHAM
Clyde McDonald said...Yes, finding the error is half the battle. For instance, I just fixed an error on a trust to general payment. However, this payment did not appear on the trust bank journal, general bank journal, accounts receivable report, or the client ledger. It did appear on the invoice journal and payment allocation journals. Once you find the error, then PCLaw Support can reverse it, because now you can provide them with an Entry Number.
ReplyDeleteThe ledger errors are usually paired i.e. A/R error and General Bank error for the same amount. As a last resort, you can do reversing adjustments (not G/L Adjustments) on both errors, posting to Suspense, and they will cancel each other out. A simple G/L Adjustment would not fix the error above, as it involves an individual invoice.
Clyde