Reports & Group · 20 of 26

Accounting Reports

Accounting Reports

General Ledger, Trial Balance, Cash Position, P&L, AR and AP aging, customer profitability and your country's tax report, computed live from source transactions.

On this page (10)

Every report in this module is computed on demand from the invoices, payments, credit and debit notes, booking charges and expenses recorded elsewhere in Routel. There are no manual journal entries to make and nothing to "close" before a report is right. If a transaction is saved, the reports already include it.

The reports

ReportWhat it answersTypical reader
General LedgerEvery posting, by account, with the document it came from.Accounting
Trial BalanceAccount balances at a date. Debits equal credits by construction.Accounting
Cash PositionBank and cash balances now, with receivables due and payables owed over the coming period.Management, Accounting
Profit & LossRevenue, cost of sales and gross profit, then operating expenses and net income.Management
AR AgingOpen receivables by customer in current, 1–30, 31–60 and 60+ day buckets.Accounting
AR (customer) profitabilityRevenue, cost and margin per customer over a period.Management
AP AgingUnpaid vendor costs by vendor, in the same aging buckets.Accounting
AP OutstandingWhat you still owe each vendor, bill by bill.Accounting
Tax reportTax collected and payable for a period, named for your country: SST in Malaysia, PPN in Indonesia, VAT elsewhere.Accounting
Network PartnersBusiness done with your partner network over a period.Management
Data exportsThe underlying records, exported for your external accountant or your own analysis.Accounting

Route performance (volume, revenue, cost and margin per lane) lives with pricing now, on the Route Analytics tab of Routes.

General Ledger

The ledger lists postings by account and date. Each line links back to its source: an invoice, a payment, a note, a vendor cost or an expense. Filter by account, by period, or by partner. Because nothing is posted by hand, the ledger is an audit trail as much as a report.

Trial Balance

Balances for every account at a chosen date. Use it to check the books tie out before sharing statements with your accountant. It always balances, because every posting in Routel is a matched debit and credit.

Cash Position

What you have and what is coming:

  • Bank and cash balances from recorded payments and expenses.
  • Receivable in the next 30 days, from open invoices by due date.
  • Payable in the next 30 days, from unpaid vendor costs and outstanding expenses.

This is the report most owners ask the assistant for on a Monday morning.

Profit & Loss

Two levels of profit, on one page:

  1. Gross profit: revenue from customer invoices minus cost of sales, which is the cost (AP) lines recorded on bookings, converted at each line's exchange rate.
  2. Net income: gross profit minus operating expenses recorded in Expenses & Payroll: salaries, rent, utilities, commissions, currency exchange differences and your own categories.

Run it for any period. Compare months side by side to see whether margin or overheads moved.

AR and AP Aging, and AP Outstanding

AR Aging groups open receivables by how long they have been outstanding, per customer, so you know where collection effort goes. AP Aging does the same for unpaid vendor costs, by vendor, so you can see what you owe and for how long. AP Outstanding is the working list of vendor bills still to pay. All three link straight to the invoice, vendor cost or partner statement of account.

Tax report

A period summary of tax collected on invoices and payable on costs, laid out for your filing and named per country: the SST report in Malaysia, the PPN report in Indonesia, the VAT report where VAT applies. It is not a substitute for your tax advisor, but it saves rebuilding the numbers from the ledger by hand.

AR (customer) profitability

Revenue, vendor cost and margin per customer for a period, sorted by margin. Use it to see which accounts are worth the effort and which need a price review at renewal.

Running a report

  1. Open Reports and choose the report

    Reports are listed with a short description of each.

  2. Set the period and filters

    A date or a date range, and where relevant a customer, vendor or account.

  3. Read, drill in, or export

    Figures link to their source documents. Reports can be exported for your external accountant.

Through the assistant

Any report can be requested conversationally: "Show AR aging", "P&L for August", "Customer profitability for Q3", "What's our cash position?". Reports are read-only, so they run immediately without a confirmation step. See AI Assistant.

Currencies

Reports are presented in your base currency (for example MYR). USD invoices and costs are included at the exchange rate recorded on the transaction, and exchange differences at settlement appear as a currency exchange expense or gain. The Group view shows every branch side by side, consolidated in USD. See Invoicing.

Who can do this

Accounting, Management and Admin can run all reports. Reports are Finance territory — Sales and Pricing work in Quotations, not this module.