Ten finance reports from your own books, and the twelve-month cashflow forecast with WIP, Xero ageing, bank lines and overheads.
Pages: Reports · Cashflow Forecast
Reports is ten finance reports built from your own claims, costs, budgets and variations — never from Xero. Every one ends with an Inputs — what is counted footnote saying exactly what it counted and left out, and exports to Excel with the same columns, summary and footnote. Cashflow Forecast is the business-wide money view: a twelve-month forecast built on the ledger, WIP and margin across every live job, Xero's aged debtors and creditors, the bank lines and what each settles, and the overheads that feed the forecast. Both are for the owner and whoever does the books.
| Report | Answers |
|---|---|
| Project profit & loss | Revenue recognised, cash received, actual and forecast cost, gross and forecast margin for one job. |
| Company profit & loss | Every job's revenue and direct cost, less overheads — net profit, breakeven and the margin you need. |
| Aged receivables | Who owes you, bucketed by how far past due, from your claims. |
| Aged payables | What you owe suppliers and subbies, on the terms you set per cost type. |
| Retention schedule | Retention held per project, released at PC and final, outstanding. |
| Claims register | Every progress claim and retention release with its work value, GST, total and what has been paid. |
| Bills register | Every bill, one row each. |
| Cash position | Receivable against payable. |
| GST | GST collected on claims against GST paid on bills for the BAS period, on your basis, with what to set aside. |
| Taxable payments (TPAR) | What you paid each contractor in a financial year, with a fix list and the ATO file. |
Base refuses to hand over a file the ATO would reject and shows the fix list instead.
The Cashflow Forecast tab shows twelve months of Income, Unraised (the rest of each live contract, not yet billed — shown dashed on the chart and never in net), Bills & orders, Labour & ret., Overheads, Net and the Balance (or Running net when there is no opening balance), one row per month with the jobs in it. The tiles above give the totals, the twelve-month net, and the Low point with the opening balance and its source. A red banner names the months the balance goes below zero. What this forecast counted under the table lists every input it counted, assumed or could not see. Finance settings → opens the terms, bank balance and GST settings it is built on.
WIP & Margin shows every live job's revised contract, actual and forecast cost, % done, over/under billing and margin, with the totals above and a weekly Margin trend once two snapshots exist. Under-billed means your own cash is funding the job. A job with no budget is excluded from the totals and flagged. Pricing intelligence fills in as jobs are closed out with an outcome: win rate by the margin you quoted at, and how much margin survived to the end.
Month-end WIP journals: press Draft last month to draft the journal that posts each job's over or under billing to Xero (work done unbilled to WIP with revenue recognised, billings in excess deferred), once every live job has closed the month. Press Post to Xero on a drafted journal; it auto-reverses on the first of the next month. The WIP accounts must be mapped on the Xero card first, and the posting goes through Money → Decide when it is over a limit.
Money In / Out reads Xero live: owed to you, you owe, the net position and the bank balance, then Money in — owed to you and Money out — you owe, worst first, by bucket. If Xero is not connected the tab says so.
Bank lines lists what the bank moved and what each line settles — a claim, a bill, a payment run, an overhead, a transfer — with the unexplained count and totals above. Press Pull now for the latest. On a line, press Match (or Change), choose what it settles, pick the document, add a note and press Record. A match is a reading of what the bank did; the document's paid state stays the ledger's own. Confident matches are proposed on Money → Decide.
On Business Overheads, press Add Overhead and enter the name, category, amount, frequency, optional dates and notes; the monthly equivalent is shown. Or press Import CSV with a chart-of-accounts or P&L export; review the categories and frequencies in the preview, remove what does not belong, and press Import N items. Toggle an overhead off to keep it without counting it.