Accounting Reports

Every report in this module is computed on demand from the invoices, payments, credit and debit notes, vendor costs 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#

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 vendor costs recorded against jobs, converted at the job'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 Aging and overdue invoices#

AR Aging groups open receivables by how long they have been outstanding, per customer, so you know where collection effort goes. Overdue invoices is the working list: each invoice past due, days late, amount and the customer contact. Both link straight to the invoice and to the customer's statement of account.

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.