Reporting
List average daily balances (v1)
Retrieve the average daily balance of each account of one company over a window of calendar days, such as a calendar quarter.
GET
List average daily balances
The balance of each day is the balance at the close of that day, as
account_balances reports it for that date, in the company’s base currency. Every posted entry counts on its date, adjusting entries included. A day with no posted entries keeps the balance of the day before it, so a weekend or a holiday carries the balance of the previous business day. The average is the sum of the daily balances divided by the number of calendar days in the window.
Rows are paged by limit and offset and ordered by account number. Accounts with no activity are included with a zero average, and inactive accounts are included. Each average is rounded on its own, so the sum of several rows can differ by a few cents from the average of their summed daily balances.
Additional validations
- Fails with
404if the company is not in your organization or your API key cannot read it.