How to upload cash entry file in Banking
Now you can upload a cash sheet where your cash receipt and payment entries will be processed, we have also attached the sample excel in the article for reference.
Follow the Steps
- Bank Statement Sample Excel Sheet can be used for regular Bank Statement, Cash Entries, Loan Statement, Credit Card.
Download Sample Sheet
![1.png](https://strapi.suvit.io/uploads/1_3f7f3ca819.png)
- Go to → Explore Now under Data Entry Automation
- Bulk Upload → Banking → Download Sample file
Sample Excel Sheet
![cash _3.png](https://strapi.suvit.io/uploads/cash_102031_a40aaa0f00.png)
- Copy and Paste your required data.
- Date & Debit & Credit Amount are three minimum required fields.
- Use DD-MM-YYYY for Date format & Number Format for Amounts.
Step 1: Import
![2.png](https://strapi.suvit.io/uploads/2_bd415c877f.png)
- Click on Import Button to import
Step 2: Select File
![3.png](https://strapi.suvit.io/uploads/3_3812a796ff.png)
- Click on the SEE ALL option to see all ledgers and select "Cash" Ledger and then upload your Cash Excel sheet.
OR
- Select your Bank and Upload the document