In order to accurately create this report, you will need to filter the report on just the account(s) that your bank is set up to track cash in (this is the account being referred to as the General Ledger Cash account). In order to do this, you will need to know which account this is. In order to locate your GL cash account number, follow these steps:
1. Go to Banks>Edit Account Details
2. On the Banks Tab, locate the Cash Account in the "Default Cash Account" Column. If your bank is set up to track cash in multiple funds, please note that you will have to run this report on those accounts.
ex. Let's say your database has 3 funds: Fund 01, Fund 02 and Fund 03 and the first segment in your account number string represents the fund. If your bank is set up to track cash in Multiple Funds, and the default cash account is 01-1000-00, you will need to filter your General Ledger report on account numbers 01-1000-00, 02-1000-00 and 03-1000-00
3. Once you have located your cash account numbers, write them down
4. Click Save and Close to close out of your bank
Once you have located your General Ledger Cash Account(s), you are ready to begin creating your General Ledger report. Follow the steps below to create this report:
1. Go to General Ledger>Reports>Account Reports>General Ledger report>New
2. On the General Tab, select <Include all accounts> in the Templates field
3. While still on the General Tab, select <Specific range> in the Date field. In the Start date field, enter the start date for the period for which you are reconciling. In the End date field, enter the statement end date for the period in which you are reconciling.
ex. If you are reconciling for May 2014, you would enter 5-1-14 in the Start date field and 5-31-14 in the End date field
4. Select the Filters tab
5. On the Filters tab, change the Account Column from "All" to "Selected"
6. Enter the Cash Account number(s) (steps on how to find the Cash Account numbers can be found in section A, above)
7. Click OK
8. While still on the Filters tab, make sure you have selected None in the Include column beside Not Yet Posted Transactions
9. Make sure all other filters are set to All
10. Click Preview
11. Compare the transactions on this report to the transactions on your bank statement report to find the cause of your out of balance