Report: Bank Reconciliation

This feature, or some fields and options described, might not be available depending on your settings, security rights, or platform package.

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

To insure 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.

This report is accessible from any center or form with a Toolbox menu. Selecting Toolbox > Reports takes you to the Reports - All list, where you can make your selection.

Click Bank Reconciliation. This opens the Report - Bank Reconciliation selection form. Make your selections, pull down the File menu and select to:

Print
Print Preview
Create CSV to export the report to the program of your choice.
Preview Cover Page

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

Check 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.

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.

Totals

Individual totals of the items listed below, plus an overall Total Open Transactionsfor receipts, disbursements, and journal entries as of the specifiedThroughdate.

Receipts
Disbursements
Journal Entries

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.

My Vertafore Support | Vertafore University | NetVU Network | Vertafore.com

© 2015 Vertafore, Inc. and its subsidiaries. All Rights Reserved. Vertafore, the Vertafore design, AMS360, Vertafore Producer Advantage, Producer Plus, AgencyEDGE, ReferenceConnect, BenefitPoint, Engage, and WorkSmart are registered trademarks of Vertafore, Inc. or its subsidiaries. Third party marks belong to their respective holders. AMS360 Classic Help updated 5/18/2016 10:58 PM