Most Indian banks allow you to download a transaction statement in CSV or Excel format from net banking. Log in to your bank’s net banking portal, go to the statements or account history section, select the date range (typically the last month or the full period since the last import), and download in CSV format. Convert Excel files to CSV before importing. Zoho Books accepts standard CSV files with columns for date, transaction description, debit amount, and credit amount.
In Zoho Books, go to Banking, select the account, and click Import Statement. Upload the CSV file. The column mapper screen shows Zoho Books field names on the left and your CSV column headers on the right. Match each Zoho Books field (Transaction Date, Description, Debit Amount, Credit Amount) to the corresponding CSV column. Click Import. Zoho Books processes the file and shows a preview. Confirm to complete the import.
If you import a statement twice, Zoho Books may create duplicate transactions. To prevent this, use consistent date ranges: always import from the day after your last import date. Zoho Books also uses a duplicate detection mechanism that flags transactions with the same date, amount, and description as potential duplicates, but it is not always perfect. Track your last import date carefully, particularly when multiple people have access to the banking module.
Statement import in Zoho Books is the process of uploading a CSV or OFX file exported from your bank to import all bank transactions into Zoho Books at once, used when a direct bank feed is not available for your bank.
Go to Banking, select the account, click Import Statement, and upload the CSV file. Map the CSV columns to Zoho Books fields, then click Import and review the imported transactions.
Aaxonix is a certified Zoho implementation partner based in Pune. Architecture-first, no surprises.