Export accounting CSV files

Open Finance → Reports → Accounting export, set the company date range, then download each file you need and select Download field mapping. Keep the mapping document with the files you share. The four downloads are independent: income, expenses, payments, and sales_tax.

Every file is UTF-8 CSV with English headers, comma separators, CRLF line endings, ISO dates (YYYY-MM-DD) in the company's time zone, and money in major units with exactly two decimal places, a decimal point, and no currency symbol. The currency column identifies the currency code, such as USD. Quoted text can contain commas or newlines. User-supplied text beginning with spreadsheet formula characters is escaped with a leading apostrophe. The first line is always a header, including when no records match.

The inclusive from/to range applies separately to each file's event date. Dates are resolved in the company's configured timezone, including daylight saving changes. Rows are sorted by date and UUID. Each file is limited to 10,000 rows; shorten the period if a larger download fails.

income.csv and expenses.csv

These files contain one row per non-deleted income or expense entry. They include open, partially paid, paid, and canceled entries; recurring projections are excluded until they become actual entries. An entry with multiple installments appears once. income is filtered by the income date and expenses by the expense date. Neither date proves a formal invoice was issued.

id

Stable import key income:<entry UUID> or expense:<entry UUID>. Use it to reconcile repeated exports.

source_id

UUID of the income or expense entry.

number

Human-readable entry number, if assigned.

issue_date

Income or expense date as a calendar day in the company's time zone; this is the file's period basis.

description

Current entry description.

category

Current financial category name, if assigned.

amount

Current entry amount in major currency units.

currency

Company currency code.

status

Current PENDING, PARTIALLY_PAID, PAID, or CANCELED status.

payments.csv

This file contains one row per recorded payment, including partial receipts, payments to suppliers, direct category payments, and reversals. A reversal has its own id, references the original in original_payment_id, and has negative amount columns. direction remains INFLOW or OUTFLOW on both the original and reversal; apply direction and the signed amount together. Do not add base_amount and discount_amount to amount: amount is the actual cash movement, while the discount is forgiven principal.

id

Stable import key payment:<Settlement.id>.

original_payment_id

payment:<reversalOfId> on a reversal; blank otherwise.

source_kind

INCOME, EXPENSE, or DIRECT_CATEGORY.

source_id

UUID of the parent income or expense entry, or of the category for a direct payment without an entry.

installment_id

Related Installment.id, if any.

payment_date

Payment date as a calendar day in the company's time zone; this is the file's period basis.

direction

INFLOW means receipt; OUTFLOW means payment.

entry_type

PAYMENT or REVERSAL.

method

Stored payment method enum, such as CREDIT_CARD, BANK_TRANSFER, CHECK, or CASH.

base_amount

Principal applied to the installment; signed negative on reversal.

discount_amount

Forgiven principal; signed negative on reversal, but never cash.

interest_amount

Late interest; signed negative on reversal.

fine_amount

Late fee; signed negative on reversal.

amount

Actual cash amount (base − discount + interest + fine), signed negative on reversal.

currency

Company currency code.

sales_tax.csv — US only

This file has one row per sales tax event recorded on a US rental. INVOICED plus ADJUSTED rows describe billed tax and taxable base; RECEIVED plus REVERSED rows describe net received tax and taxable base. The taxable_base and tax columns are signed amounts in major currency units. A row's event_date comes from an operational timestamp and is not a tax return period or an accountant-approved recognition date. The tax ledger currently has no historical backfill.

id

Stable import key sales_tax:<SalesTaxLedgerEntry.id>.

source_type

Source type used to prevent duplicate tax rows.

source_id

Source record ID or event key used to prevent duplicate tax rows.

rental_id

Related Rental.id.

installment_id

Stored installment ID, if present. It may refer to an installment from a payment schedule that was later replaced.

settlement_id

Related payment ID on payment-related rows, if present.

event_date

Date of the tax event as a calendar day in the company's time zone; this is the file's period basis.

event_type

INVOICED, RECEIVED, REVERSED, or ADJUSTED.

taxable_base

Signed taxable base.

tax

Signed sales tax.

currency

Currency recorded on the fact, ordinarily USD.

envelope_revision

Revision number of the sales tax snapshot saved on the rental.

Reimport and reconciliation

Use id as the deduplication key for each file. A later edit can change the amount, category, or status of an entry with the same ID. Decide with your accountant whether a reimport updates an existing record or requires a correction entry. For payments, retain the original and reversal as separate rows even when they fall in different export periods. Do not add the four files together: the payment and tax rows refer to activity on income and expense entries; they are not additional income or expense.

Deleted entries are excluded from income and expenses, but their earlier payments and tax rows may still appear in payments and sales_tax. This export does not include bank statements, projected recurring entries, attachments, formal invoice PDFs, account opening balances, or a chart of accounts. A bank export or a ledger movement is not an accounting invoice.

This CSV is an accountant handoff, not native QuickBooks synchronization. We have not verified an import into any QuickBooks product or version with sales tax configured. Test the exact QuickBooks product and version your accountant uses with the fictional sample, confirm the field mapping and totals, and obtain your accountant's decision on tax jurisdiction, accounting basis, classification, and recognition dates before routine import.