Report: Bank Reconciliation

The Bank Reconciliation report assists you with reviewing and managing the bank reconciliation process.

To ensure that the Bank Reconciliation printed report matches the bank statement you are trying to reconcile, you should save the Bank Reconciliation form in the Bank Center before attempting to print the report.

The Bank Reconciliation report is also available as a Quick Report from the sidebar menu on the Bank Center. The Quick Report provides a means of quickly accessing a list of cleared and open transactions for an in-progress bank reconciliation. This should help you to isolate errors that keep the reconciliation from balancing properly.

Bank Reconciliation Statement

Statement of Open Transactions

Report Selections

When the report is accessed from a Quick Reports menu, some selections are pre-filled by default. You can change default entries as needed.

Report Selections

What is this?

Bank

Select the desired bank account from the list.

You must first select a bank account from the list before the Report Type is available for selection.

Report Type

What is this?

Bank Reconciliation Statement

Select this option to print a report of the cleared items and balances on the reconciliation statement.

The list fills with statements sorted by Status = Unposted and then by Status = Posted in descending date order.

The label in the list reflects:

Statement Ending Date
Ending Balance
Description
Status Posted, Y/N

Only one statement per bank account can exist with status Unposted.

Include Open Items

Mark this box if you want the report to include open (uncleared) transactions.

Statement of Open Transactions

Select this option to print a report of all open (uncleared) transactions.

The Statement of Open Transactions reports items posted on or before the Through Date you select for the report and which are STILL OPEN on the day you run the report.

For example, a check posted on 1/25/09. The check wasn't cleared on a 1/1/09 to 1/31/09 Bank Reconciliation Statement. It did clear on 2/15/09 and was cleared on the 2/1/09 to 2/28/09 Bank Reconciliation Statement. If you run a Statement of Open Transactions today (4/1/09) with a Through Date of 1/31/09, the check is not reported because it is no longer open as of today.

Description

Accept the default description, or enter a new one that describes the report you are requesting.

Print Cover Page

Allows you to include a cover page listing the selected options included in the report. This option defaults as unchecked.

Report Field

Bank Reconciliation Statement

Report Fields

Description

Header Information

Prints general information such as the report title, name of the bank, division, date range for the reconciliation and status posted or unposted.

Description

The bank reconciliation Description appears above the bank and GL balances.

Totals Section

This section of the report lists all of the bank and GL balance information.

For a detailed explanation of these fields, please see the Reconciling a Statement > Reconcile Bank Statement and GL Bank Account section of the Bank Reconciliation topic.

Cleared Receipts

Lists all cleared receipts.

Cleared Receipts

What is this?

Date

Deposit date.

Ref #

Internal system reference number for the deposit.

Description

Deposit description.

EFT

Prints "EFT" for EFT deposits, otherwise this field is blank.

Amount

Deposit amount.

References	What is this?
Adjusted	* Prints if an adjustment is entered as part of the reconciliation process Also prints the memo description, if entered with the adjustment.
Adjust Memo

Cleared Disbursements

Lists all cleared disbursements (checks and EFT's).

Cleared Disbursements

What is this?

Date

Check or EFT date.

Ref#

Internal system reference number for the transaction.

Description

Transaction description.

EFT/Check#

EFT

EFT prints if the disbursement was by electronic funds transfer.

Check#

The check number prints if the disbursement was a check, and the check is printed (or posted for handwritten checks).

If the check has not been printed yet, the check number is unassigned.

Amount

Disbursement amount.

References	What is this?
Adjusted	* Prints if an adjustment is entered as part of the reconciliation process. Also prints the memo description, if entered with the adjustment.
Adjust Memo

Cleared Journal Entries

Lists cleared journal entries.

Cleared Journal Entries

What is this?

Date

Journal entry date.

Ref#

Internal system reference number.

May indicate Not Assigned for journal entries entered as part of the unposted bank reconciliation statement.

Description

Transaction description.

Amount

Adjustment amount.

References	What is this?
Adjusted	* Prints the memo description, if entered with the adjustment.
Adjust Memo

* Service Charge

Total service charges entered as part of the Bank Reconciliation process.

If a service charge is entered through the Financial Center > Journal Entries and cleared in the reconciliation, it is reported in Cleared Journal Entries.

Service Charge	What is this?
Date	Date of the service charge.
Ref#	Internal system reference number for the transaction.
Description	Transaction description.
Amount	Service charge amount.

* Interest Earned

Total earned interest entered as part of the Bank Reconciliation process.

If interest is entered through the Financial Center > Journal Entries and cleared in the reconciliation, it is reported in Cleared Journal Entries.

Interest Earned	What is this?
Date	Date of the interest income
Ref#	Internal system reference number for the transaction.
Description	Transaction description.
Amount	Interest earned amount.

Totals

Individual totals of the items listed below plus an overall Total Cleared Items.

Cleared Receipts
Cleared Disbursements
Cleared Journal Entries

Include Open Items

If Include Open Items is checked when ordering this report additional pages print listing open (uncleared) receipts, disbursements, and journal entries and the total of open items as of the Ending Statement Date.
Open Receipts
Open Disbursements
Open Journal Entries
The column names for the Open (uncleared) items are exactly the same as for the Cleared receipts, disbursements and journal entries.

See the Report Fields > Statement of Open Transaction sub-section in this topic for additional information.

Statement of Open Transactions

Report Fields

Description

Header Information

Prints general information such as the report title, name of the bank, division, and through date.

Receipts

Lists all open receipts.

Field	What is this?
Date	Deposit date.
RefNo	Internal system reference number for the deposit.
Description	Deposit description.
EFT	Prints "EFT" for EFT deposits, otherwise this field is blank.
Amount	Deposit amount.

Disbursements

Lists all open disbursements (checks and EFT's).

Field	What is this?
Date	Check or EFT date.
RefNo	Internal system reference number.
Description	Transaction description.
EFT/Check#	EFT EFT prints if the disbursement was by electronic funds transfer. Check# The check number prints if the disbursement was a check, and the check is printed (or posted for handwritten checks). Not assigned in this field indicates that the check is posted but not yet printed.
Amount	Disbursement amount.

Journal Entries

Lists open journal entries.

Field	What is this?
Date	Journal entry date.
RefNo	Internal system reference number.
Description	Transaction description.
Amount	Journal entry amount.

Tools

Individual totals of the items listed below, plus an overall Total Open Transactions for receipts, disbursements, and journal entries as of the specified Through date.

Receipts
Disbursements
Journal Entries

CSV Columns

Bank Reconciliation Statement

CSV Columns

Description

Header

The header rows are the first three rows of the CSV file, including a blank row.

Columns	What is this?
AgencyName	Name of the agency.
ExportDate	The date the report was exported, typically the current system date, unless you are looking at a printed report.
ReportType	"Report Bank Reconciliation"
BankAccountName	Bank name.
GLNumber	General ledger number for the selected bank account.
DivisionName	Name of the division associated with the bank account.
BeginningDate	Statement beginning date.
EndingDate	Statement ending date.
BeginningBalance	Statement beginning balance.
EndingBalance	Statement ending balance.
* ServiceCharge	Bank service charge entered on the statement.
* InterestEarned	Bank interest entered on the statement.
Status	Posted or Unposted.
Description	Report description.
GLBalDate	General ledger balance date.
GLBankBal	Bank balance per the general ledger, as of the GLBalDate.
ClearConvStmt	Conversion amount cleared on this statement.
OpenConvAmt	Amount of conversion open items.

Detail Rows

These are the detail rows of the Bank Reconciliation Statement report.

Columns	What is this?
ClearedState	Cleared or Open.
TranType	Check, receipt or journal entry.
Date	Transaction date.
Ref#	System assigned reference number.
Description	Transaction description.
EFT/Check#	EFT, the check number, or the words "not assigned". prints. (If the check has not been printed yet, the check number is unassigned.)
Amount	Transaction amount.

Statement of Open Transactions

CSV Columns

Description

Header

The header rows are the first three rows of the CSV file, including a blank row.

Column	What is this?
AgencyName	Name of the agency.
ReportDate	The date the report was exported, typically the current system date, unless you are looking at a printed report.
ReportType	"Bank Reconciliation Statement".
BankAccountName	Bank name.
GLNumber	General ledger number for the selected bank account.
DivisionName	Name of the division associated with the bank account.
ThroughDate	Selected Through Date.

Detail Rows

These are the detail rows of the Statement of Open Transactions report.

Column	What is this?
TranType	Check, receipt or journal entry.
Date	Transaction date.
Ref#	System assigned reference number.
Description	Transaction description.
EFT/Check#	EFT, the check number, or the words "not assigned", prints. (If the check has not been printed yet, the check number is unassigned.)
Amount	Transaction amount.

[* As of Version 23R2, the "Interest Earned" and "Service Charge" sections, as well as the "Adjust Link," no long appear on the bank reconciliation statement. Instead, use the New Journal Entry button ,located in the bank reconciliation statement, to enter any adjustments.]