Bank Transactions
This job fetches all transactions made in your bank account from zoho books. If you want to get all transactions, you can use fetch account transactions
Add this jobData
Sample Data
Open in new tab -Data headers
| Header | Description |
|---|---|
| date | Date of the bank transaction |
| account_name | Name of the bank account |
| currency | Currency of this transaction |
| amount | Amount transacted. +ve number means money is added to this account. -ve amount means moneys is taken from this account. |
| reference_number | Reference number |
| payee | Name of the customer/vendor |
| transaction_type | Can be - card_payment, customer_payment,expense, transfer_fund, vendor_payment |
| account_type | type of the account. Can be - bank, credid_card, payment_clearing, |
| debit_or_credit | debit or credit |
| source | Source of this transaction - manually_added, bank_feed, csv |
| status | Status of this tranaction. Can be - categorized, 'manually_added', matched |
| transaction_id | zoho books id of this transaction |
| account_id | zoho books id of the related account |
| customer_id | zoho books id of the related customer/vendor |
| ym | Year month of the entry in YYYY-MM format .e.g 2023-10 |
Filtration options
This job can restrict the data that is visible in spreadsheets. Use the following parameters to restrict the data.
| Parameter | Options |
|---|---|
| start_date | Select transactions with billing date on or after start_date. Format - YYYY-MM-DD |
| end_date | Select transactions with billing date on or before end_date. Format - YYYY-MM-DD |
| account_id | Select transactions related to a particular account. Account id is the id of the account from zoho books. |
| customer_id | Select transactions related to a particular contact (either customer or vendor). Customer id is the id of the customer or vendor from zoho books. |
| status | Select transactions by status. Options: All,Categorized, Matched, Manually added and Uncategorized |
| source | Select transactions by source. Options: All,API, Bank feeds, CSV and Manually added |
| account_type | Select transactions by account_type. Options: All,Bank, Cash, Credit card and Payment clearing |
| transaction_type | Select transactions by transaction_type. Options: All,Card payment, Customer payment, Credit card,Deposit,Expense,Expense refund,Interest income,Payment refund,Refund,Transfer fund,Vendor payment and Vendorpayment refund |