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

Bank Reconciliation Report

How to view Bank Reconciliation Report in SwilERP (RetailGraph)


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

      • Create Bank Reconciliation of Accounts

        How to Do Bank Reconciliation in SwilERP Software What is bank reconciliation? Bank Reconciliation is an essential process in accounting in which organizations match their bank statements with the transactions recorded in their general ledger. ...

      • View Cash and Bank Books of Accounts

        How to view Cash and Bank Books in SwilERP What is Cash and Bank Book? The Cash Book is a record of the receipts and payments of cash, and it is a book of original entries as well as a ledger account. Similarly, the Bank Book records all the receipts ...

      • Adjustment Report

        How to View Adjustment Report in SwilERP Software What is Adjustment Report? The adjustment report provides information about the inventory adjustments you make in the software. The adjustments you make to on-hand product quantities, including the ...

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