We would be glad to assist.
Bob
[email protected]

Hi. I'd like to hear what you have to say. So far I made sure there are no unposted transactions. There was an interest income transaction in 2012 for the exact amount I am off, but it appears to have been done correctly. I have not been able to view the GL activity as it was in 2012 and the system will only allow me to go back 2 years in GL detail. The GL and Adjusted bank balance are in synch, so I am more concerned with just correcting the register balance and less with figuring out how and when it happened. Thanks

Has the register balance always been out of balance or is something recent? I could be the bank balance is wrong.

I'm the new Asst Controller and started looking deeper into the bank recs. The Bank Balance is correct, and the adjusted Bank Balance is correct and ties to the correct General Ledger Balance. The register has been out of balance for the past two years, for the exact same amount (over $89.57). I did see that an interest income amount identical to the difference posted in October of 2012 but appears to be a correctly processed transaction, but I don't have easy access to the prior recs over 2 years old. So, I'm hoping to somehow reduce the register balance by $89.57 without changing the adjusted bank balance or the GL. The dollar amount is too small to spend more time trying to trace back the original cause. Thanks.

Joe,

You can always make an entry (either addition or subtraction) to the register by going into Cash Management > Edit Register. Enter a deposit/withdrawal/adjustment for the amount you need to bring the register into balance, and when completing the entry, choose the off-setting debit or credit GL account to be the same as that of the bank account. That will increase or decrease your register balance as of the date of your entry as well as make a net zero entry to the cash account's GL account.

Hope that helps.

Art Minds
Consultant

Hi Joe,

We also have a comprehensive guide to reocnicling Cash Management to make sure you stay in balance with both the General Ledger and your bank statements.

See the article Cash Management Reconciliation Information to get started.

Thanks!