تخطَّ إلى المحتوى
Export119 Docs

Trial balance & reports

هذا المحتوى غير متوفر بلغتك بعد.

Financial reports on Export119 run live off the GL — no batch posting, no month-end “close” step that builds reports. Open them any time and they reflect the current state.

Trial Balance

Section titled “Trial Balance”

/financial-reports/trial-balance lists every active account with its Dr − Cr balance. Sortable by Balance only (code order is locked so the type-hierarchy stays intact).

The balance formula is type-agnostic: SUM(debit) − SUM(credit) per account, regardless of whether the account is naturally debit-normal (assets, expenses) or credit-normal (liabilities, equity, revenue). Credit-normal accounts naturally show negative balances in the trial balance — that’s correct, not a bug.

Balance Sheet

Section titled “Balance Sheet”

/financial-reports/balance-sheet groups accounts by type with subtotals:

  • Assets — Cash, Bank, AR, Inventory, Due-from-consignors, etc.
  • Liabilities — AP, Tax Payable, Customer Deposits, Investor Capital Payable, etc.
  • Equity — Owner’s Capital, Retained Earnings, OBE, Drawings (contra).

The footer asserts Assets = Liabilities + Equity. If they don’t balance, you have a data-integrity issue — investigate before doing anything else.

Profit & Loss

Section titled “Profit & Loss”

/financial-reports/profit-and-loss groups Revenue and Expenses by period:

  • Period selector — Month-to-date, Quarter-to-date, Year-to-date, custom range, All time.
  • Gross margin widget — Revenue − COGS.
  • Profit by sale currency — useful when you sell in multiple currencies; shows the cars-sold profit broken down per sale currency.

The P&L respects the period lock — if you’re looking at a closed month, you’re seeing immutable numbers.

Counterparty Balances

Section titled “Counterparty Balances”

/counterparty-balances is the AR/AP aging report:

  • Per-counterparty net balance (positive = AR, negative = AP).
  • Aging buckets: Current, 1–30 days overdue, 31–60, 61–90, 90+.
  • Drill-down to per-counterparty ledger with all rows tagged to that party.

For stakeholder counterparties (owners, investors, directors), the drilldown surface reframes as an Equity Statement with PDF/Excel export.

Period lock

Section titled “Period lock”

/financial-reports/period-lock lets an admin close a fiscal period. Once closed:

  • GL posts dated in the closed period are rejected at the chokepoint.
  • Existing rows in the period are immutable.
  • Reports run against the locked period return frozen numbers.
  • Editing the underlying source (invoice, vault tx, fx exchange) fails with a clear period-lock error.

To re-open, an admin clicks Unlock. There’s no audit-trail penalty, but unlocked → modified → re-locked rows show the timestamp delta.

Export

Section titled “Export”

Trial Balance, Balance Sheet, P&L, and Counterparty Balances all support Excel export (per the existing finance-report Excel pattern). Counterparty drilldowns additionally support PDF export with embedded fonts (IBM Plex Sans Arabic for RTL).

Section titled “Related”