How to View and Export Cash Book and Bank Book in SwilERP Pharmacy Software

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 and payments made through the bank. The Cash/Bank Book in SwilERP is a two-in-one report where you can see both the cash and the bank transactions on the same screen but in separate sections. 

In SwilERP, users can view cash and bank book details in following report types: 
  1. Voucher Detail
  2. Month Wise
  3. Day Wise 
  4. Account/Voucher Wise
Follow the below-given steps to view cash and bank book details


Open SwilERP dashboard in Accounts section

  1. Go to the Reports> Cash and Bank Book.
Accounts sectionSwilERP Dashboard Window

View Cash and Bank Book 

  1. Select the Date Range from where you want to view the details.
  2. Select the Day Book Type from the drop down list or you can create new day book from the master. 
  3. Now, select the Report Type from the given options. 
  4. Tick-Mark on the options of ''Month wise total'' and ''Day wise total'', as per your requirements. 
  5. There is an also option of Select and Filter the Accounts. 
  6. Click on the View option.
Cash and Bank BookCash and Bank Book Window
In this option, users can view following details:
  1. All the Transactions under Cash and Bank will show here.
  2. Users can view Entry Date wise transaction. 
  3. The account name of all transactions is shown along with their reference number.

  4. Users can view GST no in the same window. 

  5. You can view the Tax details to match the data with GST. 

  6. Voucher Amount of every transactions are also available.

details tabDetails Tab

Export in Excel Format

With SwilERP, users can easily export cash and bank book in excel format. Also share this report with someone in excel format, follow the below-given steps to know the process. 

  1. Go to the Display option.
  2. Click on the "T" tab, and select the excel option to convert your report in excel format. 
Export in Excel FormatConvert Into Excel Format



      • Related Articles

      • View Day Book of Accounts

        How to View Day Book of Accounts in SwilERP (RetailGraph) What's the meaning of Day Book? A daybook serves as a primary record, documenting transactions by date as they unfold, subsequently transferred to a ledger and summarized into financial ...
      • 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 ...
      • 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 Day Book of Accounts

        How to view Day Book of Accounts in SwilERP What's the meaning of day book? The Day Book lists all transactions made on a particular day and, by default, displays all the transactions for the same day. Users can view particular date wise details in ...
      • Create Master of Day Book

        How to Create Day Books Master in SwilERP Master of Day Books A day book is a book of original entries in which an accountant records transactions by date as they occur. Also, Day Book shows the details of daily transactions to match with the GST and ...