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.
Journal details
Click into any journal to see the underlying daily entries Sequence generated.
- 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:| Source | Description |
|---|---|
| Invoice | Recognition driven by an issued invoice. |
| Billing schedule | Recognition driven by a billing schedule (used for unbilled-revenue scenarios). |
| Credit note | Reversal or rebuild from a credit note. |
| Standalone | A manual journal posted via the dashboard, not tied to a Sequence document. |
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.- Sequence (generic CSV)
- Xero
- QuickBooks
- NetSuite
A general-purpose CSV format suitable for any GL system. Columns:
| Column | Notes |
|---|---|
Journal Number | Sequence-generated identifier. |
Date | ISO 8601 date. |
Narrative | Explanation of the journal, including lock-shift notes. |
Product name | Product associated with the journal. |
Customer ID | Sequence customer ID. |
Customer name | Customer’s legal name. |
Direction | DEBIT or CREDIT. |
Ledger account name | E.g., Billed Revenue, Deferred Revenue, Recognized Revenue. |
Amount | Positive amount; the sign comes from the Direction column. |
Invoice ID | Source invoice ID, if applicable. |
Invoice number | Invoice number, if applicable. |
Xero ledger account code | Included only when the Xero integration is enabled. Resolved per-entry from the product’s Xero mapping. |
Sign convention
Sequence’s internal ledger uses an explicitDirection (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.
Async download flow
For larger reports, generation runs in the background:Click Export
Pick the format (Sequence, Xero, QuickBooks, or NetSuite) and the filters you want, then start the export.
Generation begins
Sequence begins assembling the report. The dashboard shows a “Generating…” state. You can navigate away from the page while this runs.
Email arrives
When the report is ready, Sequence sends an email containing a signed link to download the file. The link is also surfaced inside the dashboard.
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.
Integration workflow
Review
Read the journals in Sequence for accuracy. Pay particular attention to credit note reversals and any entries with lock-shift narratives.
Aggregate (optional)
If your GL prefers monthly totals over daily granularity, group entries in a spreadsheet before import.
Reconcile
Tie exported amounts back to ledger balances. The deferred revenue and waterfall reports reconcile to the journal report. See Deferred revenue for the reconciliation guide.
Manual adjustments
Any Sequence-generated journal can be selected for manual adjustment, to correct errors or recognize revenue not captured automatically.
- 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.