Checking Window - Reconcile Cash Tab

Top  Previous  Next

It is important to keep your Checkbook records in agreement with those of the bank.  Balancing your Checkbook, or reconciling cash, is important because errors can sometimes be made by your bank or yourself upon recording cash transactions.  For this reason, it is strongly recommended that you reconcile cash each month.


To reconcile cash you will need your most recent bank statement.  Click on the Pay Bills and Checkbook button on the tool bar to open the Checking Window, and then click on the Reconcile Cash Tab.


checking-rec ckbk window


The first step is to identify the Checking Account you wish to reconcile.  Select the desired Checking Account on the Account menu.  Next, enter the date of the bank statement in the Bank Statement Ending Date field.  The date will be shown on the statement itself.  Click the Start è button and Design Manager will display the Checks and Deposits information for this Account.


Clearing Checks:

The Checks Grid contains all of the Checks that you have written that were dated on or before your statement date.  Checks that have been reconciled in an earlier month will not be shown.  The bank will have indicated which Checks it has processed when you receive the bank statement.  Find each of these Checks in the Checks Grid and click the Clear (Clr) column to indicate that the bank has reported that Check as cleared or processed.  As Checks are marked as cleared, the total amount of all cleared Checks will be displayed in the Total Cleared Checks field.


Clearing Deposits:

The bank statement will similarly list the Deposits you have made.  Find the Deposits on the Deposits Grid and mark as cleared each of the Deposits on the bank statement.  As Deposits are marked as cleared, the total amount of all cleared Deposits will be displayed in the Total Cleared Deposits field.


As individually clearing Checks and Deposits may be tedious when numerous entries are involved, it may be found useful to use the Clear Checks and Deposits Window by clicking the Clear button to quickly mark entries cleared based on a variety of criteria.  If the majority of your Checks and Deposits clear in a banking period, you can use the Clear Checks and Deposits Window to mark all entries on both the Checks and Deposits Grids as cleared.  Then simply unclear the entries not on your bank statement.  This process may be faster then clearing each Check and Deposit manually!


Service Charges:

You may also have received service charges from the bank.  They will also be listed on the bank statement.  To enter these charges you should click the Service Charges è (Service Chg è) button to the left of the Service Charges field.  The Service Charges Window will appear.


service chrg window

Click the Add button to the right of the Service Charges Grid to display the Service Charges Distribution Window on which you may enter the dollar amount of the service charge as well as the General Ledger Expense Account to which it should be recorded.  As you enter these charges the total amount will be updated in the Net Service Charges field.  When you have entered all of the charges, this number should agree with the dollar amount of service charges on your bank statement.  Click OK on the Service Charges Window and you should see the service charge amount appear in the Service Charges field on the Reconcile Cash Tab.  The check entry on the Checks Grid for the service charge will also be marked as cleared.



You may also have compounded interest in the cash account.  To record any interest, click the Interest button beneath the Deposits Grid.  Doing so will display the Cash Receipt - Miscellaneous Window configured for entering the interest.


interest cr window


The Deposit Slip Number (Deposit Slip No.) will be recorded as "INT" and the Name and Transaction Description will together be displayed as "Bank Interest for account XXXXX".  Input the Date the interest was deposited into your account, the Amount of the interest, and the proper General Ledger Offset Account Number to record the interest into the respective fields.  Bank interest is usually a Revenue Account.  Click the OK button when you have properly input the interest information.  Mark the deposit entry for the interest as cleared on the Deposits Grid.


Your bank statement may include a total for the checks and service charges and a total for the deposits and interest that it is reporting.  If so, you can assess your work by comparing the total for the Checks in the Total Cleared Checks field.  The total number of cleared Checks will precede the Total Cleared Checks field.  You should also compare the total for the deposits to the Total Cleared Deposits field.  Again, the total number of cleared Deposits will precede the Total Cleared Deposits field.  If the totals in Design Manager do not match the totals shown on the bank statement, then one of the following problems may have occurred:


1.You may have neglected to click the Clear column for one of the Checks or Deposits shown on the statement.  In the same vein, it is also possible that you accidentally cleared a Check or Deposit that was not listed on your statement.  If so, you can remove the check mark from the Clear column by clicking it again.


2.You have a Check or a Deposit with an amount that differs from the amount that the bank is reporting.  Look at each Check and Deposit that you have cleared and make sure that its amount matches that shown on the bank statement.  If you find a difference, you can correct it in Design Manager if the transaction has been entered erroneously or else you will need to contact your banking institution if they are in error.


3.You failed to enter a Check or Deposit at all.


4.You entered the wrong Bank Statement Ending Date.


When your Total Cleared Deposits, Total Cleared Checks, Interest, and Service Charges all agree with your bank statement, you are ready for the final step.  Click the Reconcile button in the lower left corner of the Reconcile Cash Tab.  The Reconcile Cash Window will appear.


reconcile cash window


Enter the ending balance from your bank statement into the Bank Statement Balance as of <Ending Date> field.  The ending balance should be taken from the statement itself.  After entering the number, press the Tab key to indicate that you are finished typing.  Design Manager will then deduce the Calculated Book Balance by including any outstanding deposits and subtracting outstanding checks to indicate the amount that should be in your Checking Account according to the bank.  The Calculated Book Balance will be compared to the current balance of the Checking Account in Design Manager in the Computer Balance as of <Ending Date> field.  Any difference will be shown in the Difference field at the bottom of the window.


If everything is in agreement and the Difference is zero, it is recommended to click the Print button to print a copy of the reconciliation for your records.  Then you can click the OK button at the bottom of the window to indicate that the reconciliation is complete and correct.  A message stating "Are you sure that you want to accept this reconciliation?  By pressing Yes, all cleared checks and deposits will drop from the reconciliation and it will be ready for the next month's bank statement."  Click Yes to process the reconciliation.  Clicking No will not process the reconciliation but will retain the cleared setting for  all Checks and Deposits.


If the Difference is not zero, you will need to re-examine your work, so press Cancel to exit the Reconcile Cash Window.  If all of the common reconciliation issues above have been examined, be sure that you are entering the proper ending balance from your statement!


Additional Functions:

Bank File:  Click the Bank File button to access the On-Line Banking File Window where a .qif file from your banking institution can be loaded into Design Manager to assist in reconciling your monthly bank statement.


History:  Click the History button to display the Reconciliation History Window where past bank statement reconciliations can be reviewed, reprinted, or even deleted.