Bank Setup for upload statement

Bank Setup for upload statement

First we have to do one time setup for bank statement configuration. Example below is statement of HDFC Bank.
 
image.png
 
We have to make proper formatting and remove all header and footer details. And make it as simple as below,
 
image.png
 
Now go to Menu > Cash & Bank Management >Setup > Configure bank statement import format - It will open Bank List, select the bank which you want to configure.
 
Debit/Credit Column Format: There are three option, you can select as given in bank statement.
1> If in bank statement there is two separate column for DEBIT and CREDIT amount then select as “Deposit-Withdrawal”
2> If in bank statement there is two column like CR/DB and AMOUNT then select as “Dr-CR”
3> If in bank statement there is only one column AMOUNT with - and + sign for debit credit then select as “+/-ve”
 
image.png
 
Date Format: Select Date format which is set in bank statement transaction date format in excel.
 
image.png
 
Column Configuration: You must enter exact column name as given in bank statement excel. Other columns like Value Date, Closing Balance you can ignore OR you can delete from the excel.
 
image.png
 
(Note: This above is one time setup for bank statement)
    • Related Articles

    • How to upload the Bank Statement?

      Before the upload bank statement, please make sure your upload file is in proper formatted. Example below is statement of HDFC Bank, We have to make proper formatting and remove all header and footer details. And make it as simple as below, Few ...
    • How can we do manual reconciliation without upload bank statement?

      Sometime we have only 10-15 transactions in bank statement, in that case if you don’t want to upload statement and reconcile all entries manually. Go to Menu > Cash & Bank Management > Bank Reconciliation > Bank Reconciliation Statement - It will ...
    • Uploading Bank Statement & Booking Bank Receipt From Bank Reconciliation Form

      Lets us learn How to upload bank statement into the system. After uploading the bank statement. how to book receipts from the bank reconciliation page. Video With Timestamp 0:00 Upload Bank Statement 0:21 Bank Reconciliation Page 0:54 Check Duplicate ...
    • Uploading Bank Statement & Booking Bank Receipt From Bank Reconciliation Form

      Lets us learn How to upload bank statement into the system. After uploading the bank statement. how to book receipts from the bank reconciliation page. Video With Timestamp 0:00 Upload Bank Statement 0:21 Bank Reconciliation Page 0:54 Check Duplicate ...
    • What happens if any user tries to upload same statement again?

      Here if user uploads same bank statement again, then system will show you the message like below, Let’s Say, User already upload statement from date 1 to 12 and after few days he try to upload statement again for date 10 to 20.... here for date 10, ...