Bank Reconciliation module

The Bank Reconciliation module provides a summary of deposits, fees accrued while conducting business, and a list of chargebacks and adjustments that occurred within a date range. Amounts for each (deposits, fees, and chargebacks) are listed in both Canadian (CAD) and US (USD) currencies. 

Why use this module

This module will help you determine:

Module customization

The module results can be customized in the following ways: 

Module options

The report's Options popup has options to change the search criteria to search by date or payment type, as well as to toggle different currencies on or off.

This module also features options which can change the type of data displayed on the report. These options include: 

To use the options:

  1. Click the Options button at the top of the Bank Reconciliation screen. The Options popup appears. 

  2. Set your options as follows:

  3. Select how you would like to search for results:

  1. Select which sections you would like to see on the report under the Payment Type heading:

  1. Select which currencies you'd like to see on the report:

  1. When finished selecting the report options, click the Apply button. 

In our example above, we are going to display results grouped by payment type in Canadian funds only, and are going to exclude Fees from the report output. Here's a screenshot of what that report will look like:

Run the report

  1. From the main menu, under the Reports section, click Bank Reconciliation. The Bank Reconciliation module screen appears.

  2. (Optional) Set the report options as described in the Report options section above. Once finished, proceed to the next step. 

  3. In the report screen, select the account(s) on which you  wish to report. 

  4. Enter a date range for the report in the Start Date and End Date field. 

  5. Click the View button. The report generates and the results appear on the screen.

Available dates for the report

The report is able to be run for a date range of 366 days, up to two years in the past. 

View deposits

The Deposits section is split into deposits in Canadian (CAD) and American (USD) currencies. This section is dynamic, and can display information about the payment date, merchant, chain, and store number, transaction description, settlement, retained, and payment amounts, and the bank account to which the funds were deposited.  

View Fees

The Fees section is split into sections for fees processed in Canadian (CAD) and American (USD) currencies. This section is dynamic, and can display information about the payment date, merchant, chain, and store number, transaction description, the transaction and tax amounts, and the bank account from which the fees are extracted.  

The Fees section of the Bank Reconciliation report displays details about fees associated with processing transactions and conducting business.

In addition to viewing the results in a report, you can view the details of the fees charged. In the Fees section, click the + symbol in the View Details column. The Fee Details screen opens and displays information about the fees incurred while conducting your business. 

Note:   Fees appearing here are presented as a single charge. This single charge represents the aggregated total of the component charges. For example, a single charge titled 'Moneris Fees' might incorporate any hardware and peripherals you have ordered within the date range, as demonstrated in the example below.

The Fee Details screen displays details about the fees incurred while conducting business.

View chargebacks and adjustments

The Chargebacks and Adjustments section is split into chargebacks and adjustments processed in Canadian (CAD) and American (USD) currencies. This section is dynamic, and can display information about the payment date, merchant, chain, and store number, a chargeback/adjustment description, card type and reason code, case ID, payment amounts, and the bank account to which funds were deposited. 

The Chargebacks and Adjustments section of the Bank Reconciliation report shows chargebacks and adjustments that occurred during the date range.