Skip to main content

Payments Made

Payments Made captures details of financial transactions, including date, amount, customer, and payment method.

Add this job

Data

Sample Data

Open in new tab -

Data headers

HeaderDescription
payment_numberPayment number
bill_numbersBill numbers associated with the payment
vendor_idVendor ID
vendor_nameVendor name
payment_modePayment mode
descriptionDescription of the payment
dateDate of the payment
reference_numberReference number for the payment
amountAmount of the payment
bcy_amountAmount in base currency
unused_amountUnused amount
bcy_unused_amountUnused amount in base currency
is_paid_via_print_checkIndicates if the payment is made via check
paid_through_account_nameAccount name through which payment is made
check_idID of the check used for payment
check_numberCheck number
check_statusStatus of the check
currency_codeCurrency code
exchange_rateExchange rate
payment_idID of the payment
paid_through_account_idID of the account used for payment

Filtration options

This job can restrict the data that is visible in spreadsheets. Use the following parameters to restrict the data.

ParameterOptions
start_dateSelect bills with billing date on or after start_date. Format - YYYY-MM-DD
end_dateSelect bills with billing date on or before end_date. Format - YYYY-MM-DD