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:






      • Related Articles

      • Bank Reconciliation Process

        How to Do Bank Reconciliation Process in SwilERP (RetailGraph) Bank Reconciliation is an essential process in accounting in which organizations match their bank statements with the transactions recorded in their general ledger. Preparing a bank ...
      • How to Add Bank Account Details

        How to Add Bank Account Details in SwilERP If you want to keep track of your transactions, you can add a Bank Account in SwilERP. This will allow you to receive automatic bank feeds and easily reconcile vouchers and bank account data. You can also ...
      • Cash and Bank Book Entry

        Cash and Bank Book Entry in SwilERP (RetailGraph) Cash and Bank Book is day book type register report. We use Cash and Bank Book to see transactions in detail or summarized view for cash and bank accounts. It is used for Cash accounts and Bank ...
      • Month Wise Profit Report

        How to View Month Wise Profit Report in SwilERP What is Month Wise Profit Report? Every business wants to know its profit report in terms of profitability for a specific duration. A month-wise profit report helps you to find out the month-wise profit ...
      • Product Wise Purchase Report

        How to View Product Wise Purchase Report in SwilERP (RetailGraph) What is a Product Wise Purchase Report? This report will show all the transactions made in the Purchase section. When buyers want to view how many total products are in their store, ...