FAQs»Month End/Year End»A/P Reconcile Bank Statement U…
  • RSS Feed

Last modified on 5/24/2016 5:17 PM by User.

A/P Reconcile Bank Statement Using Single Account

At the end of every month follow these procedures to balance the system checkbook against the actual bank statement. Please see the document "Task 20 - Check Account" for term explanations and how transactions are automatically entered.  The document "Transition to Computer Using a Single Account" should be followed before using this document.  Another helpful document is “Checkbook Out of Balance”.

NOTE: If using the Payroll Module:

  •  If Payroll checks come out of the same checking account as A/P checks, part of the payroll process is to post the payroll checks to A/P.  This is done in A/P System Management (Task 32), Post Payroll to Checks File (Sub-task 6).  This must be done for each payroll for the month being balanced before starting the reconciling to the bank statement process.
  • The payroll taxes are NOT posted to the A/P checking account automatically.  It doesn’t matter how the payroll taxes are being paid (i.e. check, EFT, etc), they need to be posted as a voucher in A/P if the taxes are being paid from the A/P checking account.  If they are taken out of a different checking account a Manual Journal entry will need to be entered and posted into the General Ledger Module.  

 

  • Print a check file from the first day of the month until the last day of the month being reconciled.
    • Accounts Payable (Module 3)
      • Check Account (Task 20)
        • Print Selected Check Records (Sub-task 4)
          •  The first screen that appears is the printer information screen. Select a printer.  The system then prompts:
            •  Please enter - starting TRX #: - ending TRX #:  Press ENTER for All
            • starting date: Use the first date of the month being reconciled as the starting date.
            • ending date: Type in the last day of the month being reconciled.
  • Check off the deposits on the computer’s check account report that are also on the bank statement. Make sure that ALL the deposits on the bank statement are checked off.  This includes the credit card deposits, wire deposits and EFT deposits.  Make sure they are for the same amount. IF THEY ARE FOR A DIFFERENT AMOUNT: don’t change the amount of the deposit.  Make a notation & then enter a new transaction into Task 20 check account for the difference. It will need to be dated during the month you are working on & have a clearance date for the month you are working on.  This will be a #2 Misc. charge from bank or a #5 Lost check / redeposit.  A manual journal entry will need to be made for this difference.

  • Check off the checks and EFT’s on the computer’s check account report that are also on the bank statement. Make sure that ALL the checks & EFT’s on the bank statement are checked off.  Make sure they are for the same amount.  IF THEY ARE FOR A DIFFERENT AMOUNT: don’t change the amount of the check or EFT.  Make a notation & then enter a new transaction into Task 20 check account for the difference.  It will need to be dated during the month you are working on & have a clearance date for the month you are working on.  This will be a #2 Misc. charge from bank or a #5 Lost check / redeposit.  A manual journal entry will need to be made for this difference.

  • On the bank statement circle, in red pen, any service charges, NSF checks charged back to the account, deposit ticket charges--anything that would not have been vouchered in A/P.  Also anything that has not already been manually entered.

    • All of these transactions need to be posted into the G/L Module as a manual journal entry.  Anything that didn’t go through A/R, A/P or P/R needs to be entered into the G/L with a manual journal entry.

  • Enter new check records

    • Accounts Payable (Module 3)

      • Check Account (Task 20)

        • Enter New Check Record (Sub-task 1)

          • Enter the items that are circled in red pen on the bank statement using the appropriate code.

          • Trx #: Use the appropriate code. (C/C Charge, Misc. Charge, Bad Ck/CC NSF Coll/Ck/CC NSFLost ck, Electronic Funds Transfer.)

          • Date: Type in the date that the bank uses.

          • Appl Area: This is a 3-character notation. It is user-defined, alphanumeric field. 

          • Written to:

            • This is the vendor # for A/P checks.

            • This is the employee # for P/R checks.

          • Clearance date: Type in the last day of the month that is being balanced.

          • Trx amount: Type in the amount of the transaction, no decimals.

          • Batch #: Press the ENTER key for the transaction….nothing needs to be entered. This field is filled in automatically during Voucher Entry & Editing or Voucher payment preparation.

          • Division #: Enter in the Division number.

  • Clear the deposits.

    • Accounts Payable (Module 3)

      • Check Account (Task 20)

        • Change Existing Check Record (Sub-task 2)

          • The system prompts:  

            • "Are you putting in clearance dates? (Y/N):" defaults to N for NO. Type in Y for YES.

            • “Please enter division #:” Type in the division # that you are reconciling, or the ENTER key for ALL.

            • "Please enter clearance date:" Type in the last day of the month that is being balanced.

          • At the bottom of the screen, the following message appears:

            • “To clear deposits (TRX=0), do not enter a deposit date, just press ENTER.  The system will then scroll the deposits for you to match with your bank receipts.  The same for EFT's (TRX=8).”

            • “For checks, enter the check number.”

            • TRX's 6 & 7 amounts must be reset after reconciling.”

            •  “To clear checks within a selectable range of dates/check #'s, press TAB.”

          • The cursor is at "Any change?______" Press the ENTER key, and the cursor will then go to TRX #.

            • Press ENTER at TRX #, and a zero will appear for deposit. The cursor will go to TRX date.

            • Press ENTER at TRX date, and the oldest deposit will be brought up.

            • The system will then prompt:

              • Clearance date xx/xx/xx"(The clearance date entered before will appear.)

              • “Clearing deposit" message also appears.

            • The system then prompts:

              •  Clear this transaction? (Y/N):” The default is Y for YES, press the ENTER key.

                • Y for “Yes, clear this transaction”. (The record WILL be cleared). If you do not want to clear this deposit, then type N for “No, do not clear this transaction” (The record WILL NOT be cleared).

          • After that deposit is dealt with, the cursor will go back up to TRX #. If the ENTER key is pressed, then the next deposit will be brought up automatically. You can scroll through all of the deposits, each time saying Y or N to clear the transaction.

  • Clear Cancelled Checks:

    • Accounts Payable (Module 3)

      • Check Account (Task 20)

        • Change Existing Check Record (Sub-task 2)  If still in subtask 2 you will not be asked  “Are you putting in clearance dates?”.  If you went out of subtask 2 and are prompted with the question again, answer Y.

        • The system prompts:  

          • "Are you putting in clearance dates? (Y/N):" defaults to N for NO. Type in Y for YES.

          •  “Please enter division #:” Type in the division # that you are reconciling, or ENTER key for ALL.

          • "Please enter clearance date:" Type in the last day of the month being balanced.

        • At the bottom of the screen, the following message appears:

          • “To clear deposits (TRX=0), do not enter a deposit date, just press ENTER.  The system will then scroll the deposits for you to match with your bank receipts.  The same for EFT's (TRX=8)”.  

          • “For checks, enter the check number.” 

          • TRX's 6 & 7 amounts must be reset after reconciling.”

          • “To clear checks within a selectable range of dates/check #'s, press TAB.”

        • After typing in the clearance date, when the cursor is at “Any change?”,  press the TAB key.  The system will prompt –

          •  Please enter range type desired:    D=date range,      N=check number range”

          • If D=date range is selected the system will prompt:

            • “Please enter –      starting date:  -  ending date:”

            • If ALL of the checks from 12/01/xx through 12/15/xx are to be clearing, enter the dates.  The system will clear the checks and then exit Task #20 - Check Account.

          • If N=check number range is selected the system will prompt:

            • “Please enter – starting check number:  -    ending check number:”

            • It will clear ALL of the checks in the range provided regardless of the check date.  The system will clear the checks and then exit Task #20 - Check Account.

        • Checks do not have to be put into numerical order.

        • The system prompts:    TRX #: Type in the check #.

        • The check will appear on the screen.  Press the enter key at the prompt “Clear this transaction? (Y/N):” The default is Y for YES, press the ENTER key.  The check will be cleared.

  • Print check records

    • Accounts Payable (Module 3)

      • Check Account (Task 20)

        • Print Selected Check Record (Sub-task 4)

          • Choose a printer, then answer system prompts as follows:

            • Please enter - starting TRX #-ending TRX#: Press ENTER for ALL.

            • Starting date: Type in the first day of the month that is being balanced.

            • Ending date: Type in the last day of the month that is being balanced

  • Read the report:

    • ​A. The "NEW BANK BALANCE" amount on the report MUST equal the ending bank statement balance.  .  If it does not equal the bank statement ending balanceSTOP, do not proceed further.  Something was cleared incorrectly, or not cleared at all.  See document Checkbook Out of Balance”.

    • B. The "OUT OF BALANCE" amount MUST be zero.  If it does not equal zero STOP, do not proceed further.  Refer to the document titled:  “Checkbook Out of Balance” in the AP section.
    • BOTH OF THESE CONDITIONS (A & B)  MUST BE MET BEFORE CONTINUING!!
    • Take the “New Bank Balance” and ADD in the “Uncleared Deposits”, SUBTRACT the “Uncleared Checks”. This figure should match the "CHECKBOOK BALANCE" on the report.
      • Note: The “CHECKBOOK BALANCE” will be the new trx type #6 in step 10 below.
      • SPECIAL NOTE: The CHECKBOOK BALANCE should match the G/L account balance for this checking account.
    • Save this report.  Two reports may be printed.  One may be kept with the cancelled checks, the other put in a permanent binder.  They should be labeled boldly with red pen , for example: “September 20xx Bank Statement Balance – Comerica #1”.

  • Erase records:

    • NOTE: The checking account MUST be balanced with the bank statement before ANY records is erased!  Also, the “OUT OF BALANCE” MUST BE ZERO BEFORE ERASING.

      • Accounts Payable (Module 3)

        • Check Account (Task 20)

          • Erase Selected Check Records (Sub-task 5)

            • Answer system prompts as follows:

              •  “Are you sure you want to erase old records?” (YES/NO): YES

            • Choose a printer, and then continue with system prompts:

              • “Please enter - purge cutoff date” Enter the last day of the month just balanced.”

              •  “Do you want to purge uncleared records?” Answer N for NO. The only records to be purged are the ones just cleared.”

            • A purge report will be printed.  This report may be saved along with the checking account reports above.

  • Change the trx type #6 Checkbook and #7 Bank Balance in the computer NOTE: NEVER change either one of these unless you have balanced.

    • Accounts Payable (Module 3)

      • Check Account (Task 20)

        • Change Existing Check Records (Sub-task 2)

          • Answer system prompts as follows:  "Are you putting in clearance dates? (Y/N):" Defaults to N for NO.

          • The cursor will be at TRX #. Enter 6 (Your checkbook balance).

          • The cursor will be at TRX date. Press the ENTER key. The checkbook balance from the previous month should appear on the screen.

          • Change field #2 (TRX date) to the first day of the new month.

          • Change field #6 (Amount) to the amount of the new checkbook balance.  Look for the “CHECKBOOK BAL:” figure on the report printed in Step 8.  The report should have been read and balanced in Step 9.

          • When the cursor is at TRX # again, enter 7 (Bank's checkbook balance).

          • The cursor should go to TRX date. Press the ENTER key. The bank balance from the previous month should appear on the screen.

          • Change field #2 (TRX date) to the first day of the new month.

          • Change field #6 (TRX amount) to the amount of the new bank statement balance.  Look for the “NEW BANK BALANCE:” figure on the report printed in Step 8 (This should also be the bank statement ending balance).  This report was read and balanced in Step 9.

  • Print selected check records:

    •  Accounts Payable (Module 3)

      • Check Account (Task 20)

        • Print Selected Check Records (Sub-task 4)

          • After choosing a printer, answer system prompts as follows:

            • Please enter – starting TRX# - ending TRX#: Press ENTER for ALL

            • Starting date: Type in the first day of the month just reconciled.

            • Ending date: Type in the last day of the month just reconciled.

            • This report will give you a list of just the un-cleared transactions: deposits, checks, EFT’s, etc… for the month just reconciled, with totals in the UNCLEARED DEPOSITS & UNCLEARED CHECKS.  The rest of the totals are meaningless. This may be saved with the reconciliation reports. 

  • Print selected check records:

    • Accounts Payable (Module 3)

      • Check Account (Task 20)

        • Print Selected Check Records (Sub-task 4)

          • After choosing a printer, answer system prompts as follows:

            • Please enter - starting TRX # - ending TRX#: Press ENTER for ALL

            • Starting date: Type in the first day of the new month.

            • Ending date: Type in the last day of the new month.

          • This step provide an up-to-date checkbook balance. Make sure the “OUT OF BALANCE:” amount is zero.  If it is not zero, the amount entered in trx type #6 or # may have been wrong.  See the document “Checkbook Out of Balance”.

 

If the NEW BANK BALANCE does NOT EQUAL the BANK STATEMENT:

  • Make sure the report was run for the correct date range.
    • Starting date: Should always be the same date as the last bank and checkbook balances in the computer.
    • Ending date: The last day of the month being balanced.
    • EXAMPLE:  If January is being balanced, and the checkbook and bank balances in the computer are dated 01/01/xx, the beginning date of the report should be 01/01/xx.
  • Look for a transaction that equals the amount you are off.

  • Check all the miscellaneous charges and additions. Make sure they are all dated correctly, for the correct amount and cleared correctly.

  • Check the "ACCOUNT REDUCTION". This should equal the "debits" on the bank statement. The debits on the bank statement are the checks and charges.

    • If the "ACCOUNT REDUCTION" is less than the "debits" on the bank statement, then there is a check or charge that was not cleared.

    • If the "ACCOUNT REDUCTION" is more than the "debits" on the bank statement, then a check or charge was cleared that should not have been cleared.

  • Check the "ADDED TO ACCOUNT". This should equal the "credits" on the bank statement. The credits on the bank statement are the deposits.

    • If the "ADDED TO ACCOUNT" is less than the "credits" on the bank statement, then there is a deposit that was not cleared.

    • If the "ADDED TO ACCOUNT" is more than the "credits" on the bank statement, then a deposit was cleared that should not have been cleared.

NOTE:  Most of the time you have to actually take the computer printout and put it next to the bank statement and very carefully check off each transaction.  Make sure each transaction on the bank statement is cleared on the computer printout and make sure it is for the correct amount.