Add Transactions

Add Transactions Manually

You can add transactions manually to record any income, expense, or payments made in the Banking module. If you are unable to fetch feeds from your bank, you can also import bank statements to record offline or past transactions for your bank or credit card accounts.

To add a transaction manually:

• Log in to your Zoho ERP organisation.
• Go to the Banking under Accounting Module from the left sidebar.
• Select the bank for which you want to add a transaction.
• Click Add Transaction from the modular bar of your account details page.
• Select an option from the Money Out tab to record payments to vendors, purchases, transfers, or other expenses.
• Select an option from the Money In tab to record customer payments, sales, refunds, deposits, or other income.
• Enter the necessary details and click Save.

Once recorded, the transaction will be labeled as Manually Added.

Import Bank Statements

You can manually import bank statements for your bank and credit card accounts. Supported file formats include CSV, TSV, OFX, QIF, and CAMT.053.

To import bank statements:

• Log in to your Zoho ERP organisation.
• Go to the Banking under Accounting Module from the left sidebar.
• Select the bank for which you want to import bank statements.
• Click Import Statement from the modular bar of your account details page.
• Upload a file from your desktop or select one from Documents.
  • By default, the character encoding is UTF-8 (Unicode).

• Select the bank account to add the statement.
• Choose the Amount Column Type:
  • Double Column: Two separate columns for deposits and withdrawals.
  • Single Column and Amount Type: One column for debit/credit type and another for the amount.
  • Single Column with Negative Values: One column with positive values for deposits and negative for withdrawals.
• Select the Character Encoding and File Delimiter, then click Next.

• Map the imported file headers to Zoho ERP fields. The best matches will be auto-selected.

• Preview your import details to check for errors or unmapped fields. Click Previous to make edits if needed.
• Click Import.

Once the import is complete, your transactions will be updated for your bank in Zoho ERP.

Auto-Forward Bank Statements

You can enable auto-forward for your bank statements to send emails with attachments from your bank to Zoho ERP automatically and add them directly to the relevant bank account.

To auto-forward bank statements:

• Log in to your Zoho ERP organisation.
• Go to the Banking under Accounting Module from the left sidebar.
• Select the bank for which you want to import bank statements.
• Click Bank Statement from the modular bar of your account details page.

Forwarded statements will appear under Bank Statements From Inbox.

• Click Add to Bank.
• If the file is in CSV, TSV, OFX, QIF, or CAMT.053 format, you’ll be redirected to the Import Statements page.
• On the Import Statements page, select the bank account to add the statement.

The file will be pre-populated.

• Now, select the Amount Column Type:
  • Double Column: Two columns for deposits and withdrawals.
  • Single Column and Amount Type: One column for debit/credit type and another for the amount.
  • Single Column with Negative Values: One column where positive values indicate deposits and negative values indicate withdrawals.
• Choose Character Encoding and File Delimiter, then click Next.

• Map the imported file headers with Zoho ERP fields and click Next.

• Preview the import details to check for errors or unmapped fields. Click Previous to make any edits.
• Click Import.

Undo Last Import

If you’ve uploaded the wrong bank or credit card statement, or uploaded the same statement twice, you can undo your last import.

To undo last import:

• Log in to your Zoho ERP organisation.
• Go to the Banking module from the left sidebar.
• Select the bank for which you want to undo last imported bank statements.
• Select Undo Last Import.
• Preview the transactions that will be deleted and click Undo Import.