banking

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?
Yes
No
Thank you for your feedback!
Want a feature?
Suggest


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

Books

VAT ready accounting
software for small
businesses.