QuickBooks Online deposits in a live spreadsheet
Add the Deposits table to a sheet as a data source named deposits and its 9 columns become names your formulas, pivot tables and charts use. Sheets reads it from your QuickBooks Online company each time the sheet opens or refreshes.
Formulas on this table
=data.deposits.sum(total) Total total. Adds up the Total column over every row of Deposits.
=data.deposits.sum(total, account, A2) Total per account. With a account in A2, the total for that one. Fill it down next to a list of them.
=list.deposits(account) Every account, once. Spills the distinct account values down the column: the row labels for the formula above.
=data.deposits.sum(total, date, ">=2026-01-01") Since a date. Only rows whose Date is on or after 1 January 2026. Criteria such as ">=", "<" and "<>" work as in any spreadsheet.
=data.deposits.count(id, account, "<>") Rows with a account. Counts the rows whose Account is not empty.
Columns
| Column | In formulas | Type |
|---|---|---|
| ID | id | Text |
| Date | date | Date |
| Account | account | Text |
| Account ID | account_id | Text |
| Total | total | Number |
| Currency | currency | Text |
| Memo | memo | Text |
| Created at | created_at | Date and time |
| Updated at | updated_at | Date and time |
Other accounting tables
Your deposits, live
Invoices, bills, customers and the chart of accounts become tables that formulas, pivot tables and charts read directly. Your numbers stay current without exporting.