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
| Report | What it answers | Typical reader |
|---|---|---|
| General Ledger | Every posting, by account, with the document it came from. | Accounting |
| Trial Balance | Account balances at a date. Debits equal credits by construction. | Accounting |
| Cash Position | Bank and cash balances now, with receivables due and payables owed over the coming period. | Management, Accounting |
| Profit & Loss | Revenue, cost of sales and gross profit, then operating expenses and net income. | Management |
| AR Aging | Open receivables by customer in current, 1–30, 31–60 and 60+ day buckets. | Accounting |
| AR (customer) profitability | Revenue, cost and margin per customer over a period. | Management |
| AP Aging | Unpaid vendor costs by vendor, in the same aging buckets. | Accounting |
| AP Outstanding | What you still owe each vendor, bill by bill. | Accounting |
| Tax report | Tax collected and payable for a period, named for your country: SST in Malaysia, PPN in Indonesia, VAT elsewhere. | Accounting |
| Network Partners | Business done with your partner network over a period. | Management |
| Data exports | The 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:
- 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.
- 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
Open Reports and choose the report
Reports are listed with a short description of each.
Set the period and filters
A date or a date range, and where relevant a customer, vendor or account.
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.