Check Register report balance <> cash balance

mafmctr · Post by **mafmctr** » Thu Sep 22, 2005 9:44 am

The ending balance on the Check Register report does not agree with the trial balance amounts for the cash account...in fact it is way off. The unreconciled totals agree with the bank reconciliation report so it appears that the reconciled total amounts must be wrong. Any suggestions?

Matt · Post by **Matt** » Thu Sep 22, 2005 9:52 pm

You are correct--these two amounts should agree. Do you have multiple funds? If so, you will need to add up the amounts in the trial balance checking account for all of the funds to compare to the Check Register Report. Are the ending dates you are running the two reports for the same? If not, this will cause a difference since you're not comparing for the same points in time. Are there post-dated checks posted to your records? If so, you will need to change the date when running the check register report to include the post-dated dates. These are a few reasons I have found why these two reports won't agree. In the end you should be able to get the two to agree.

mafmctr · Post by **mafmctr** » Fri Sep 23, 2005 9:49 am

Yes...we have multiple funds. I've totaled the cash account across all funds and it agrees with the consolidated balance sheet cash amount...just not to the check register total. I've run into the date problem too...they do agree with the balance sheet and there are no posted dated transactions.

What is the source table for the check register report? Does it only look at the transaction table?

tborgal · Post by **tborgal** » Sat Sep 24, 2005 8:22 am

I have had a problem with unreconciled transactions before the previous fiscal year. Previous to version 9 they got lost from the check register. Don't know if this is still a problem with V9 however, also with this problem you can not reconcile with the Bank Statement.

Matt · Post by **Matt** » Sat Sep 24, 2005 1:35 pm

The source record for the check register is the same detail transaction file that is used to build the Journal report and update the trial balance. However, the problem I sometimes run into in trying to balance the check register report to the other Fund Accounting reports is that the check register report keys in on the posting date, whereas most of the other Fund Accounting reports key in on the posting month. Thus, if you have transactions that say have a posting date of September 1, but posted to the month of August in Fund Accounting, you would have to be sure to run the check register report through Sept. 1 in order to get it to balance to the August trial balance amount.

mafmctr · Post by **mafmctr** » Sun Sep 25, 2005 11:30 am

I found the problem! There were several transactions that were posted with a date of "01/26/3000". Not sure how they were missed but I fixed them and now the report is back in balance. Thanks.

Matt · Post by **Matt** » Sun Sep 25, 2005 3:26 pm

Great! It's a good thing you found them--you would have been out of balance for a long, long time!