Checking Account Report

When printing this report, the "starting date" should always be the same as the date of the beginning and ending TRX #'s prompted by the system.

Below are the names of the TITLES on the report (note:  not all titles may appear on the report.  It depends on the information available from the system for the report.  The appearance of the various titles can change based on that information)

• UNCLEARED TRX, NOT IN TOTALS: This is at the end of each data line dated for a previous month. This is NOT included in the "PREV BANK BAL:" total. This IS included in the "PREV CHECKBOOK BAL:" total.
• CHECKS PRINTED: Number of checks on the report.
• DEPOSITS MADE: Number of deposits on the report.
• PAID OUT: Total of the checks on the report, which are subtracted from the totals.
• OTHER PAID OUTS: Total of the other types of transactions, which are subtracted from the totals, i.e. 1=CC charge from bank, 2=Misc.charge from bank, and 3=Bad check/CC.
• DEPOSITED: Total of the deposits on the report, which are added to the totals.
• OTHER DEPOSITS: Total of the other types of transactions, which are added to the totals, i.e. 4=Collected bad/redeposit, 5=Lost check/redeposit.
• PREV CHECKBOOK BAL:  This is the $ amount in the computer for transaction #6=Your checkbook balance (under "Optional TRX # Type" in Sub-task 1 or 2 of Task 20). The date that the computer has for this transaction appears on the report. This date should be the same as the #7 Bank's checkbook balance. It should also be the first date of the month.
• CHECKBOOK BAL:  This is the sum of everything on the report, cleared or not, i.e. PAID OUT:, OTHER PAID OUTS:, DEPOSITED:, OTHER DEPOSITS:, and the PREV CHECKBOOK BAL:.
• CHECKS CLEARED:  Number of transactions that are subtracted from the "PREV BANK BAL:" with a clearance date.
• DEP CLEARED:  Number of transactions that are added to the "PREV BANK BAL:" with a clearance date.
• ACCOUNT REDUCTION:  Sum of transactions that are subtracted from the "PREV BANK BAL:" with a clearance date.
• ADDED TO ACCOUNT:  Sum of transactions that are added to the "PREV BANK BAL:" with a clearance date.
• BANK BAL CHANGE:  Sum of the "ACCOUNT REDUCTION:" and the "ADDED TO ACCOUNT:".
• PREV BANK BAL: Is the transaction #7 Bank's checkbook balance. This should be the same as the last bank statement ending balance. The date them computer has for this transaction prints on the report. This should be the same as the #6 Your Checkbook balance. This should also be the first date of the month.
• NEW BANK BALANCE:  This total is derived at by taking the "PREV BANK BAL:" subtracting the "ACCOUNT REDUCTION: and adding the "ADDED TO ACCOUNT". When reconciling the bank statement this should balance to the bank ending balance.
• UNCLEARED DEPOSITS:  Is the sum of all the transactions that are added to the account without a clearance date.
• UNCLEARED CHECKS:  Is the sum of all the transactions that are subtracted without a clearance date.
• RECONCILIATION AMT:  This total is derived by taking the "NEW BANK BALANCE:" amount and adding "UNCLEARED DEPOSITS:" amount, then subtracting "UNCLEARED CHECKS:" amount.
• OUT OF BALANCE: This is the difference between the "RECONCILIATION AMT:" and the "CHECKBOOK BAL:" This should always be zero. 
  • ​If there is an amount that is "OUT OF BALANCE:", means data from a previous month has been altered.  NEVER change data from a previous month, i.e. add, change, or delete. When this is done, it means that the amount that was entered into the computer for the transaction type #6 Checkbook balance is no longer correct.

  • ​See document titled: "Checkbook Out of Balance" for help in fixing an out-of-balance condition.