My bank statement contains negative values in the amount column. Can I import that in Zoho Books?

Yes, you can import bank statements to Zoho Books even if the statement contains negative values. Here’s how:

  • Go to the Banking module on the left sidebar.

  • Select your bank account from the list.

  • Click the Import Statement button on the top-right corner to import.

  • Upload a file from your desktop or choose a file from Documents.

  • Based on your statement’s template, select the Amount Column Type.

Field Description
Double Column Choose this if your import file has two different columns for deposits and withdrawals.
Single Column and Amount type Choose this if your import file has a single column indicating a debit (withdrawal) or a credit (deposit) transaction and a separate column for the amount.
Single Column with Negative Values Choose this if your import file has just one column where positive values indicate deposits and negative values indicate withdrawals.

Enter all the other necessary details to finish importing your statement.

Was this document helpful?
Thank you for your feedback!
Want a feature?

Switch to smart accounting software. Switch to Zoho Books.   Start my free 14-day trial Explore Demo Account


Online accounting software
for small businesses.