Financial Reports and External Exports

Open Reporting & Exports → Financial Reports. Select a report, complete its filters, and choose Run Report. Most reports require Branch and From/To or As Of; some require Account, Dimension, fiscal period, plan/scenario, allocation, or multi-branch selection. Export downloads the current filtered result in the offered method.

Money columns use the report/branch currency. Empty results usually mean no posted activity matches the scope, a required filter is missing, or the source is unposted—not that data was deleted.

Ledger and Sales Reports

Report	Question answered	Key filters and columns
Trial Balance	Do account debit/credit totals balance?	Branch, date range; account, debit, credit, balance. Total debit must equal total credit.
General Ledger	Which posted lines changed accounts?	Branch, range, optional account/dimension; date, entry, account, description, debit, credit.
Account Statement	How did one account reach its closing balance?	Required account and range; opening balance, dated debit/credit, running and closing balance.
Daily Sales Journal	How were sales, discounts, taxes, rounding, and receivables posted?	Branch/range; source, entry, account, description, debit, credit.
Sales Tax Summary	What output tax was posted by tax code?	Branch/range/tax; debit, credit, balance.
Cash/Card Clearing	What moved through a selected cash/card account?	Account/range; opening, debit, credit, net movement, running/closing balance.
Purchase Journal	What purchase receipt, bill, payment, and credit activity posted?	Branch/range/supplier/source; date, reference, debit, credit.

Payables, Inventory, and Margin Reports

Report	How to read it
Supplier Payables Aging	Each supplier bill balance is placed in Current, 1–30, 31–60, 61–90, or Over 90 days as of the selected date. Total balance is still owed.
Inventory Valuation	Quantity × average/unit cost gives value by ingredient as of the date. Historical results depend on frozen valuation layers.
COGS Summary	Debit/credit/balance of COGS accounts from order-stock deductions and reversals.
Food Cost	Net sales minus COGS gives gross margin; COGS ÷ net sales gives Food Cost %.
Stock Variance	Non-inventory side of waste, spoilage, samples, and adjustments; investigate unexpected gains/losses.
Inventory Costing Audit	Effective method, quantity/value, FIFO layers, and standard cost variance.
Landed-cost Analysis	Component allocation to receipt layers by basis/share/amount and workflow status.
Inventory Provision Report	Carrying value, recoverable value, provision, and status; posted provision should agree with allowance evidence.

Operational Control Reports

Report	Operational balance compared with GL
Operational Finance Reconciliation	Combined COD, provider/driver payable, gift card, deposit, payroll, and gratuity controls.
COD Clearing Reconciliation	Outstanding driver/provider COD against clearing accounts.
Delivery Payables	Confirmed provider fees and approved driver earnings against payables.
Gift Card Liability	Active and expired-pending-breakage gift-card balances against liability.
Customer Deposit Liability	Reservation deposit balances against customer-deposit liability.
Payroll Liabilities	Employee net pay, tax, social security, deductions, and employer contributions against GL.
Tips and Service Charges	Collected/paid/payroll-exported gratuity against employee liability.

Status is Reconciled, Difference, Missing Mapping, or Not Applicable. A difference is operational balance minus GL balance. Fix source, mapping, timing, or duplicate/missing posting and rerun; do not force the report total.

Planning and Dimension Reports

Report	Purpose and important columns
Budget vs Actual	Budget, posted actual, and variance by month/account/dimension. Confirm fiscal year and approved budget scope.
Scenario Comparison	Scenario A, Scenario B, and variance cell by cell. Compare approved/locked like-for-like versions.
Dimension Profit and Loss	Revenue, COGS, expense, and profit for each dimension value plus Unassigned.
Dimension to GL Reconciliation	Dimension amount + unassigned amount should equal GL total; Difference should be zero.
Allocation Audit	Frozen source amount, destinations, difference, rule, period, and lifecycle status.

Group and Statutory Statements

Report	How to interpret it
Multi-branch Trial Balance	Aggregates posted base-currency debit, credit, and balance for selected branches; no ownership/eliminations.
Multi-branch Profit and Loss	Revenue, COGS, expenses, and net income across selected branches; not statutory consolidation.
Multi-branch Balance Sheet	Assets, liabilities, equity, current earnings, and accounting-equation difference; no ownership/eliminations.
Statement of Cash Flows	Opening cash + operating + investing + financing = closing cash. Review unclassified accounts and reconciliation difference.
Statement of Changes in Equity	Opening equity + direct movements + current net income = closing equity. Review reconciliation difference.

For governed ownership, translation, eliminations, and top-side adjustments use Consolidation Runs.

Unexpected Results Checklist

1. Confirm branch/entity, currency, date basis, and end date.
2. Remove optional account/dimension filters and rerun.
3. Check whether source transactions are Draft, pending, voided, or in a closed/different period.
4. Open Posting Logs for failed, blocked, or skipped events.
5. Confirm mappings and account/dimension effective dates.
6. Compare operational source, linked journal, General Ledger, and control report.
7. For historical inventory or FX, confirm valuation layers and approved effective rates.

External Exports

Open Reporting & Exports → External Exports. Create a profile with branch scope, name, type (QuickBooks CSV, Xero CSV, or Generic Ledger CSV), delimiter, include-header option, and Active.

Choose Generate External Export, select profile and date range. Batch status is Pending, Completed, or Failed. The list/detail shows profile, branch, format, range, file name, finish/download times, batch count, and creation date. Download retrieves a completed file.

An external export does not mark journals as transferred in the destination system and does not import changes back. Protect exported files because they contain financial details.

Attachments

When an Accounting screen exposes an evidence attachment control, select the branch, target type/record, classification, and file. Classifications are Receipt, Supplier Invoice, Supplier Credit Note, Deposit Slip, Bank Statement, Reconciliation Document, Payroll Payment Proof, Journal Evidence, and Other.

Attachment lifecycle and security checks are system-managed. A file can be Active, Archived, Deleted, or Quarantined, and its scan result can be Pending, Clean, Infected, Skipped, or Failed. Only use the available authorized view, download, archive, or delete actions; a quarantined or unsafe file must not be downloaded. Archiving an attachment never removes posted transaction history.