Manage Bank Statements

The Manage Bank Statements page lets you create and edit bank account statement periods for reconciling your bank statements.

Bank Statement Grid

Existing statements display in the grid with columns for Statement Date, Opening Balance, Ending Balance, Out of Balance By, Note, and Setup.

To work with statements in the grid:

1. Double-click an existing statement or click the Edit icon to edit it.
2. Click the Add New Statement link to add a new statement.

Note: To delete a statement date, click the Delete icon. All items reconciled for that statement become available for reconciliation again.

Reconcile Bank Statement

To set up a statement period for reconciliation:

1. Click the Edit icon.
2. In the Reconcile Statement Setup window, enter the Statement Date.
3. Enter the Statement Ending Balance. If this is the first statement date for the currently selected bank account, also specify the Statement Beginning Balance. When adding a new statement, the Statement Date must be after the date of the last finalized statement.
4. Click OK to reconcile your statement period, or Cancel to return to the Manage Bank Statements page.

Note: To un-finalize a statement date, remove the check from the Finalized option when editing an existing reconciliation. This also makes manually entered outstanding items available for reconciliation on that statement again. A security option named Update Finalized controls which users can finalize or uncheck the Finalized button. This option is located on the Security Setup > Task Roles > Update page.

Reconciliation Page

The Reconciliation page lets you 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.

On the main Reconciliation tab, all Checks, Voids, Withdrawals, and EFTs (Electronic Fund Transfers) are on the left, and Deposits are on the right. Both sections display the following columns:

• Item #
• Amount
• Date
• Description

Note: Click any column header to sort the grid (for example, click the Date header to sort by date). Click the up or down arrow to toggle between ascending and descending order.

You can reconcile items in three ways: by entering item numbers, by importing an electronic bank statement, or by manually marking items as cleared.

Entering item numbers:

1. Enter the Item #.
2. Enter the Amount of the item you want to mark as cleared.
3. Click Reconcile Item to mark the item as cleared.

Importing an electronic bank statement:

1. Click the Import Electronic Bank Statement link.
2. Click Browse to select the file (QIF, OFX, QFX, or XLSX).
3. Click Import. A Statement Import Report displays the items in the file that were found/cleared, followed by the items that were not found/cleared.

Note: When the Amount and either the ItemNumber or Date match between the import file and the Reconciliation page, items are marked as cleared. Items with Type = Void are not reconciled.

The Excel file (XLSX) must include the following columns:

• ItemNumber (or Check # or CheckNumber)
• Amount
• Date (or ItemDate)
• Description (optional)

Marking items as cleared:

1. 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: The date entered when creating or updating the selected statement period.
• Opening Balance: 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: A calculated figure that should match the Statement Ending Balance entered when creating or updating the statement period.
• Statement Ending Balance: The figure entered when creating or updating the 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.

Note: The Reconcile to Bank Statement area at the bottom left of the page tracks your progress as you reconcile. When you finish, the Out of Balance By field should show zero, and the Statement Starting Balance and Calculated Ending Balance fields should match the amounts on your current bank account statement.

Reconcile to the General Ledger

The Reconcile to General Ledger area contains the following fields:

• Statement Period: Select the General Ledger year and period to reconcile from.
• General Ledger Balance: The current balance of the selected bank account as of the selected Statement Period, including unposted journals. Includes the ending balances from the same account number in other funds, if they do not exist in BAM or are marked inactive in BAM.
• Outstanding Items: Outstanding items posted to the selected Statement Period or before. Also includes items created in Bank Account Management > All Items, as they are not linked to a General Ledger period. If there is a value in Reconciled Items from after the Statement Period, it is subtracted from this total.
• General Ledger Calculated Ending Balance: The General Ledger Balance minus the Outstanding Items.
• General Ledger Out of Balance By: The Statement Ending Balance minus the General Ledger Calculated Ending Balance.
• Reconciled Items from after the Statement Period: The total of all items marked as cleared that were posted to a future General Ledger period.

Reconciliation Report

1. Click the View Reconciliation Report button to display a preview. The first page contains a Bank Statement Current Summary showing the Opening Balance, Deposits, Checks & Withdrawals, and Ending Balance.
2. Navigate the pages, export to several formats (PDF, Excel, Word), or click Print.

The next section lists your Cleared Items with columns for Item #, Date, Description, and Amount. The Ending Balance displays at the bottom of this section.

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

Click Close Report to return to the Reconciliation page.

Finalize Reconciliation

To finalize or pause the reconciliation:

1. Click Apply and Finish Later to save your changes and return to the Reconcile Bank Statement page.
2. Click Finish to finalize the reconciliation.

Click the Reset link to undo all changes since the page was last updated, or the Cancel link to discard all changes and return to the Reconcile Bank Statement page.

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

Note: Manual Items are transactions created under View > All Items and are not linked to General Ledger:

• Manual Items show on Bank Statements when the Item Date is less than or equal to the Bank Statement Date.
• When Manual Items are reconciled, they show on that Bank Statement and all previous Bank Statements.

Note: If you need to pause the reconciliation process and return later, click Apply and Finish Later. As long as you do not create another reconciliation date for the next period or make changes, you can return to your current statement period and continue your work without repercussions.

Updated June 17, 2026 06:56