Page 1 of 1

Bank Reconciliation - Outstanding Cheques Report

Posted: Wed Feb 28, 2007 4:46 pm
by showtyme
This may not be the brightest question:

Is there an outstanding cheques report? I didn't think of this at all throughout the year, cause I always balanced on more or less my first crack at it. Now there seems to be some error in the last couple of months, and I don't know why this is (it may have something to do with cheques issued after I'd done the Bank rec in December), so I'm trying to recreate what is actually outstanding. When I look at the Bank rec, all I see is the cheques and entries that cleared, not the cheques that are outstanding. Is there an easier way than manually creating a list each month of all outstanding items??

Posted: Thu Mar 01, 2007 12:01 pm
by tborgal
What version are you using. In some of the older versions if there is an outstanding check that was posted before the previous year it will not show up in the reconciliation process.

I just checked and the process to look for uncleared checks is the same back to V8. Go to Accounting>Fund Accounting>Reports>Check Register. There you can select Unreconciled and put in a start date of at least 01/01/2005. This should let you know if there is an outstanding check that may not be included in the reconciliation.

I am not sure if this is an issue in V9 forward or not.

Posted: Thu Mar 01, 2007 2:17 pm
by Zorak
In versions prior to 9, there was an Unreconciled Transactions report in Fund Accounting.

v9 and 10 only have a checkbox option on the Check Register report to include only unreconciled transactions.

I got it to work...sort of!

Posted: Wed Mar 14, 2007 5:05 pm
by showtyme
I understand how to print the outstanding items relating to cheques written this year...

The situation that we had, and ended up spending far too much time having to figure out was how to print ALL the outstanding cheques. We had some cheques that had been outstanding at the end of 2005/06 and therefore those didn't show up in the "Unreconciled Transactions" report. As a result, this report didn't reconcile to the unreconciled items portion of the Bank Statement.

To me (and this is only my opinion), the Bank rec report should include the items that remain unreconciled. This is a more important report to me when I have to look back to each individual month for any accounting information. If I wanted to see what cleared, I can look at the Bank Statement.

Is there any way of making the Bank Rec print only outstanding items to that point??

Again, these are just my preferences.