Skip to main content

Trial Balance Raw Data

The Trial Balance in Zoho Books is a financial report that lists the balances of a company's general ledger accounts at a specific point in time. It ensures that debits equal credits, serving as a preliminary step in preparing financial statements.

Add this job

Data

Sample Data

Open in new tab -

Data headers

HeaderDescription
accountName of the account
account IdIdentifier for the account
monthReporting month in MMM YYYY format
opening balanceInitial balance of the account for the month
debitTotal debits during the month
creditTotal credits during the month
net debitNet debits considering opening balance
net creditNet credits considering opening balance
closing balanceBalance at the end of the month

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