Journal reports

Journal reports export every recognition movement Sequence has generated, in formats designed for direct import into Xero, QuickBooks, NetSuite, or a generic GL system.

​

Monthly journal reports

For each month, Sequence assembles a summary that combines all the revenue subledger journals for the period. By default, the report shows one journal per customer, product, and invoice combination. On a monthly invoice cadence, this maps roughly to one journal per invoice line item group. The report includes daily journal entries. Once exported, you can group them into monthly buckets or keep the daily granularity, depending on your accounting system’s preference.

​

Journal details

Click into any journal to see the underlying daily entries Sequence generated. The detailed view shows:

• Daily recognition amounts.
• The source transaction (invoice, billing schedule, credit note, or standalone manual journal).
• Account movements (deferred to recognized, billed to deferred, and so on).
• The recognition method that produced the entry.
• The narrative, including any note Sequence added when a posting date was shifted to respect an account period lock.

​

Source field

Every journal carries a Source that explains where the entry originated: The Source field is available on the API response and as a filter in the dashboard, so reconciliation by source is straightforward.

​

Filters

The report supports the filters most relevant to month-end close:

• Date range: from / to (inclusive).
• As of date: what the journal report looked like as of a specific historical date.
• Currency: one currency per report, since each ledger is currency-scoped.
• Journal type: system-generated or manual.
• Customer, product, invoice, or credit note: scoped subsets for targeted reconciliation.
• Exclude fully recognized: hides journals whose recognition is fully complete by the as-of date.

​

Export formats

Sequence supports four export formats. Pick the one that matches your downstream system.

​

Sign convention

Sequence’s internal ledger uses an explicit Direction (Debit or Credit). When generating the Xero export, the amount is signed according to each Xero account’s normal balance:

• Debiting a debit-normal account produces a positive amount.
• Crediting a credit-normal account produces a positive amount.
• Crediting a debit-normal account produces a negative amount.
• Debiting a credit-normal account produces a negative amount.

This mirrors what Xero expects on import, so journals load without manual sign correction.

​

Async download flow

For larger reports, generation runs in the background: The streaming endpoint remains available for small reports that complete in time, but the async flow is the recommended path for monthly close exports on accounts of any meaningful size. How long generation takes depends on the volume of journals in the report.

​

Spreadsheet row limits

Large date ranges can produce CSVs that exceed Excel and Google Sheets’ row limits (~1M rows). A full calendar year of daily journals on a high-volume account can hit this. If you hit the limit:

• Narrow the export to a quarter or month at a time.
• Aggregate to monthly granularity before exporting.
• Load the CSV into a database or BI tool (DuckDB, BigQuery, ClickHouse) for analysis.

​

Push journals to Xero

If your account has the Xero integration enabled, you can post recognition journals straight to Xero from this page, instead of exporting a CSV and importing it by hand. Open the ⋯ menu in the top right and choose Push to Xero, then pick the periods to push. Each period shows a sync status, and re-pushing only posts what has changed. See Posting revenue recognition journals to Xero in the Xero integration guide for the full flow: account setup, journal posting mode, sync statuses, and currency handling.

​

Analysis report

Before pushing, you can produce an analysis report to review how your revenue splits out. Open the ⋯ menu and choose Generate analysis report. It gives you a breakdown of your recognized revenue that you can check before the journals land in Xero.

​

Integration workflow

​

Manual adjustments

Any Sequence-generated journal can be selected for manual adjustment, to correct errors or recognize revenue not captured automatically. Common adjustment cases:

• Correction entries: fix recognition timing or amounts.
• Manual recognition: handle complex scenarios not automated.
• Reclassifications: move revenue between accounts.
• One-off adjustments: account for unique business events.

All manual adjustments are tracked separately, marked as Standalone in the Source field, and retain a full audit trail.

​

Activity log

Successful revenue recognition runs for invoices and credit notes are written to the account’s activity log. This provides a chronological record of what was recognized and when, separate from the journal entries themselves.