How to bulk upload bank entries (transactions) along with bank charges?

Bulk uploading bank entries allows you to record multiple bank transactions at once, including transactions with bank charges, saving time and reducing manual errors.

Let’s see how you can bulk upload bank entries on Refrens.

Firestly, Go to Accounting > Voucher Book > Bulk Upload Vouchers:

Once you click on Bulk Upload Vouchers, a pop-up form will appear. 

Click on download sample file format.

Your sample sheet will have the following field:

• Voucher Index number:Add a Number series for each individual transaction 
• Voucher Book: Add Type of voucher i.e. Payment Voucher book, Receipt voucher book
• Voucher Date: Add Date of Transaction (Date Format : DD-MM-YYYY)
• Notes: Add Narration/ transaction reason
• Account: Add the account name according to the type of transaction (Things to keep in mind: While adding Account enter the exact name which is already created through chart of accounts)
• Amount: Add amount of based transaction 
• CR/DR: Add nature of transaction 
• Remark: Add additional remarks for transactions 

Let's say you have the following transactions you want to upload:

Transactions 1: Payment Made with Bank Charges to ABC Pvt. Ltd .

Here's what the Journal Entry will look like for this:

ABC Pvt. Ltd.                            Dr            1000
Bank Charges                           Dr                50
       To HDFC Bank                       Cr                         1050

Transaction 2: Payment Received with Bank Charges from XYZ Pvt. Ltd.

Here's what the Journal Entry will look like for this:

HDFC Bank                              Dr            1950
Bank Charges                          Dr                50
       To XYZ Pvt. Ltd.               Cr                              2000

Here's how you can add these two transactions in the sample file:

Once you have updated all the data in the sample file, simply upload it from the Bulk Upload Voucher option as discussed earlier.

That's it!

If you still have any questions, feel free to reach out to us on chat support. We would be more than happy to assist you!

Updated on: 27/02/2026