Bank Account Management > Manage >

Bank Statements > Reconciliation

 

         

 

 

Overview

Bank Statements - Reconciliation allows you to reconcile your bank account transactions for the selected statement period. You can also add a note on the Notes tab and add attachments on the Attachments tab.

 

This Help page contains the following sections:

Reconciliation Page

Reconcile To Bank Statement

Reconcile to General Ledger

Reconciliation Report

Finalize Reconciliation

 

 

Reconciliation Page

On the main Reconciliation tab all Checks, Voids, Withdrawals, and EFTs are on the left and Deposits are on the right.

 

For both sections the following columns are displayed:

 

Item #

Amount

Date

Description

 

Click any column header to sort the grid (e.g., click the Date header to sort the grid by the Date column).

 

You can reconcile items one of three ways: entering item numbers, importing electronic bank statements, or manually marking items as cleared.

 

Entering Item Numbers

 

Enter the Item # and Amount of the item you want to mark as cleared and click Reconcile Item. This marks the item as cleared.

 

Import Electronic Bank Statement

 

Click the Import Electronic Bank Statement link. Click the Choose File button and select your import file. The program accepts the .OFX, .QIF, .QFX, and Excel formats. Click Import and all items that match (ItemDate and Amount or ItemNumber and Amount) in the imported file are marked as cleared.

 

The file can have any name, but it must contain the following columns: Date (or ItemDate), Check # (or Check Number or ItemNumber), Description (optional), and Amount.

 

 

Mark Items as Cleared

 

Place a check next to items in either section of the page to mark them as cleared.

 

 

Reconcile to Bank Statement

The Reconcile to Bank Statement area contains the following fields:

 

Statement Date: This is the date you entered when creating or updating the selected statement period.

Opening Balance: This is the calculated opening balance or the entered opening balance if this is the first statement period for this bank account.

Net Activity: The net dollar amount based on items marked as cleared from both sides of the reconciliation page.

Calculated Ending Balance: This calculated figure should match the Statement Ending Balance you entered when creating or updating the selected statement period.

Statement Ending Balance: This is the figure you entered when creating or updating the selected statement period. It should match the Calculated Ending Balance.

Out of Balance By: The dollar difference between the Statement Ending Balance and Calculated Ending Balance.

 

The Reconcile to Bank Statement area at the bottom left of the page keeps track of your progress as you reconcile. When you are finished reconciling the Out of Balance By field should show zero. The Statement Starting Balance and Calculated Ending Balance fields should match the amounts shown on your current bank account statement.

 

 

Reconcile to General Ledger

The Reconcile to General Ledger area contains the following fields:

 

Statement Period: Select the General Ledger year and period from which to reconcile.

General Ledger Balance: This is the current balance of the currently selected bank account as of the selected Statement Period, including unposted journals.

Outstanding Items: This is the amount total of all outstanding items posted to the selected Statement Period or before. This also includes any items manually added in Bank Account Management. Marking an item as cleared removes it from this total.

General Ledger Calculated Ending Balance: This is the General Ledger Balance adjusted by the total of the Outstanding Items field. (This includes amounts from other bank accounts that are in the same fund and are marked inactive.)

General Ledger Out of Balance By: This is the Statement Ending Balance minus the General Ledger Calculated Ending Balance.

Reconciled Items from after the Statement Period: This is the total of all items marked as cleared that were posted to a future General Ledger period.

 

 

Reconciliation Report

Click the View Reconciliation Report button to display a preview of your Reconciliation Report. The first page of this report contains a Bank Statement Current Summary which displays the Opening Balance, Deposits, and Checks & Withdrawals along with an Ending Balance.

 

Next on the report are your Cleared Items with columns for Item #, Date, Description, and Amount. The Ending Balance is displayed at the bottom of this section of the report.

 

The final section of the report are your Outstanding Items with the same columns. At the bottom of the report are your General Ledger Balance, Total Outstanding items, General Ledger Calculated Ending Balance, Statement Balance, and General Ledger out of Balance By amounts.

 

You can navigate the pages, export to several formats (e.g., PDF, Excel, Word), and Print. Click the Close Report button to return to the Reconciliation page.

 

 

Finalize Reconciliation

Click the Apply and Finish Later button to save your changes and return to the Reconcile Bank Statement page, the Finish button to finalize the reconciliation, the Reset link to undo all changes since the last time the page was updated, or the Cancel link to discard all changes and return to the Reconcile Bank Statement page.

 

If the Statement Ending Balance and Calculated Ending Balance fields do not match you are prompted that you are not in balance for the statement. Click OK to continue finalizing the statement or Cancel to return to the Reconciliation page and make corrections.

 

If you click the Finish button and finalize the reconciliation, manually entered outstanding items no longer show up for that reconciliation date.

 

Resuming Your Work

 

If you need to pause the reconciliation process and come back later click the Apply and Finish Later button. As long as you do not create another reconciliation date for the next period and start making changes you can always come back into your current statement period and continue your work without repercussions.

 

Compiled on 6/22/2018 8:21:40 AM