4.5 KiB
GL-001 Exposure Notes
Executive summary
Tryton already provides a strong General Ledger foundation:
- account-level opening, movement and closing balances;
- date or period filtering;
- journal filtering;
- posted-only option;
- drill-down from accounts to detailed move lines;
- base-currency balance information at line level;
- party drill-down for party-required accounts.
The main gap is that the target GL-001 report is specified as a complete detailed report, grouped by account and transaction currency, with initial and ending balance columns on each transaction line and a rich audit column set.
Tryton's current General Ledger is split between:
- an account summary view or report, represented by
account.general_ledger.account; - a line drill-down view, represented by
account.general_ledger.line.
It does not expose the target output as one flat, export-ready detailed report.
Main exposure conclusion
The target GL-001 specification is broader than the current Tryton standard General Ledger output.
Tryton covers the accounting foundation and several filters, but the target report requires an additional reporting layer that flattens account summary and detailed lines into a single exportable dataset, with transaction-currency grouping, initial and ending balance columns, audit metadata and normalized document references.
Areas already covered or substantially supported
| Area | Exposure result |
|---|---|
| Date range | Covered through from_date and to_date |
| Journal filter | Covered in the GL account context |
| Entity | Covered through current company context |
| Base-currency balances | Covered at account and line level |
| Account-level opening / movement / closing | Covered in the account summary |
| Drill-down to move lines | Covered |
| Running balance | Covered in base currency at line level |
| Party drill-down | Available for party-required accounts |
Areas requiring additional design or implementation
| Area | Exposure result |
|---|---|
| Flat detailed report | Not exposed as a single export-ready dataset |
| Account and transaction-currency grouping | Missing or partial |
| Transaction-currency filter | Missing as an explicit GL parameter |
| Initial and ending balances by account and transaction currency | Missing |
| Transaction-currency ending balance per line | Missing |
FX rate exposure for currency_rate |
Rate date and precision not yet mapped |
| Rich audit columns | Raw ingredients exist, but not exposed in normalized GL output |
| Document, voucher and reference mapping | Requires functional arbitration |
| Dedicated XLSX export | Not identified |
| Wide detailed PDF | Not covered by the standard printable GL |
Sign convention exposure
The target GL-001 convention is:
- debit amounts displayed as positive amounts;
- credit amounts displayed as positive amounts, following the current Tryton convention;
- ending balances calculated using debit-positive and credit-positive logic: initial balance plus debit minus credit.
Tryton currently exposes base debit and credit as positive numeric columns and computes balance as debit - credit. For transaction currency, Tryton stores a signed amount_second_currency.
The export layer should preserve Tryton's positive debit and positive credit convention for GL-001.
Export exposure
The target report requires:
- CSV;
- XLSX;
- PDF including all detail columns.
Tryton may support list exports through the standard UI and printable reports through .fodt templates, but the source analysis did not identify a dedicated flat General Ledger XLSX export or a wide detailed PDF matching all target columns.
Controls exposure
Tryton supports important base-currency controls:
- posted accounting moves are balanced in company currency;
- account start, debit, credit and end balances support reconciliation;
- Trial Balance reuses the same account model, helping base-currency reconciliation.
The main remaining control gap is transaction-currency reconciliation by account and currency, including initial balance, movement and ending balance.
Initial balances must follow the account type: balance sheet accounts use the account balance up to the day before date_from, while profit and loss accounts use only the movement balance from the start of the fiscal year through the day before date_from.
The new GL-001 currency_rate field also requires a conversion-control rule: for non-base-currency lines, exported transaction-currency amounts, base-currency amounts and the displayed FX rate should reconcile within the agreed rounding precision.