How to view, print, or export a bank reconciliation report in SwilERP Software

Bank Reconciliation Report

How to view Bank Reconciliation Report in SwilERP


In this article, we'll discuss how to view a bank reconciliation report in SwilERP. For this, we have to know what bank reconciliation is.

What is a bank reconciliation?

A bank reconciliation statement summaries banking and business activity that reconciles an entity’s bank account with its financial records. Once the user has passed all the entries related to Bank, the Bank reconciliation process has started. Through this process, the user can put a clearance date per the Bank Statement so that the user can confirm in the record. The cheques deposited or issued to any party will be cleared per the bank records.

What does mean by bank reconciliation?

The bank reconciliation report compares the ending balance of a bank statement as of the statement date. This report will show all transaction types with the bank date, amount, balance and Dr/Cr entries.

Start with Login in SwilERP Dashboard to initiate the process

  1. Go to the Reports> Account Reports> Bank Reconciliation Report
Reference image:
SwilERP Dashboard Window

Process to view the report

A new window of bank reconciliation report will appear in the next slide. Follow the below-mentioned steps:
  1. Select the Date Range "From" to "To," in which date range you'll see the report.
  2. Select Bank Account from the drop-down list.
  3. Click on the View option.
  4. After that, you'll see the Bank Reconciliation Report in the below screen.
Reference image:



Users can view the following details:
  1. Types of Transaction: The summary data of bank transactions will show in this column.
  2. SeqNo: Transactions' sequence numbers are visible in this column.
  3. Bank Date: You can view the bank date in this column.
  4. Amount: Total amount to transaction visible here.
  5. Balance: You can view the balance amount in this column.
  6. Cr/Dr: Natures of transaction are visible in this column.
Reference image: 


How can you analyze bank reconciliation?

In this section, you can analyze your bank reconciliation transaction. You can find this report similar to the pivot table, in which you can view the bank details.
  1. Go to the Analysis section.
  2. Select the details as same as you selected in the Home section.
  3. Click on the View option.
  4. After that, Choose fields to add to report. Tick-mark on the options; then, they will automatically field in the below-given areas.
  5. You can also Drag fields between below-given four areas: Filter, Columns, Rows, Values.
  6. The data reflect in the Analysis Grid section.
Reference image:



  1. Click on the Chart tab to view the report in chart format.
  2. Here you'll see the report's chart along with reflected every detail.
Reference image:



  1. You can also view the report in Raw Data, where you can find every detail.
  2. Click on the raw data and there you will sales transaction report. Reference image:
Reference image:


To Print and Preview the report

  1. First, select the File Format as bank reconciliation report.
  2. Click on the Print or Preview option to take printout of the report.


To export the file in excel format

  1. Go to the Display section.
  2. Click on the ''T'' button, and there, you'll see the options to convert your report into an excel file.

Reference image: