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??
Bank Reconciliation - Outstanding Cheques Report
Moderators: Moderators, Tech Support
-
tborgal
- Posts: 863
- Joined: Thu Jun 03, 2004 4:55 pm
- Location: New England Bible Church, Andover, MA
- Contact:
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.
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.
Tom
I got it to work...sort of!
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.
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.