Customer Payments
This job fetches customer payments from zoho books.
Add this jobData
Sample Data
Open in new tab -Data headers
| Header | Description |
|---|---|
| date | Date of the payment |
| payment_number | Payment number |
| payment_mode | Payment mode. Can be - Bank Remittance, Cash, Razorpay, Bank Transfer |
| customer_name | Name of the customer |
| invoice_numbers | Invoice numbers for which full or part of the payment has been attributed to |
| amount | Amount |
| unused_amount | Amount that is not knocked off against an invoice |
| description | Description associated with the transaction. Usually the bank statement remarks |
| reference_number | Reference number of the transaction according to the bank |
| tax_amount_withheld | Amount withheld by the payee |
| bcy_amount | Amount in base currency |
| bcy_unused_amount | Balance in base currency |
| tax_account_name | Tax account name to which amount withheld is attributed to |
| created_time | Time this payment was created in zoho books |
| last_modified_time | Time this payment was updated in zoho books |
| exchange_rate | exchange rate |
| customer_id | zoho books id of the customer related to this payment |
| payment_id | zoho books id of the payment |
| tax_account_id | zoho books id of the tax account related to this payment |
| 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 bills with billing date on or after start_date. Format - YYYY-MM-DD |
| end_date | Select bills with billing date on or before end_date. Format - YYYY-MM-DD |