Xero manual journals in a live spreadsheet
Add the Manual journals table to a sheet as a data source named manual_journals and its 7 columns become names your formulas, pivot tables and charts use. Sheets reads it from your Xero organisation each time the sheet opens or refreshes.
Formulas on this table
=list.manual_journals(status) Every status, once. Spills the distinct status values down the column: the row labels for the formula above.
=data.manual_journals.count(id, status, "<>") Rows with a status. Counts the rows whose Status is not empty.
Columns
| Column | In formulas | Type |
|---|---|---|
| ID | id | Text |
| Date | date | Date |
| Narration | narration | Text |
| Status | status | Text |
| Amounts are | amounts_are | Text |
| On cash basis reports | on_cash_basis_reports | Yes / no |
| Updated at | updated_at | Date and time |
Other accounting tables
Your manual journals, live
Invoices, bills, bank transactions and your monthly profit and loss become tables that formulas, pivots and charts read directly, in your base currency.