Tell us in plain English and we'll match it to a workbook in the Lyros library.
The Lyros workbook library is a set of 25 ready-to-use Excel workbooks for Australian small and medium businesses and the people who run their numbers: owners, finance leads and bookkeepers. Each covers a real finance job, from a 13 week cash flow forecast and a monthly management report pack to budget vs actual, aged receivables, GST and BAS timing and working capital. Every workbook downloads as a real .xlsx file, free, no sign-up. Prefer to describe what you need in plain English? Use the finder above.
If you would rather have the numbers and the narrative prepared for you each month, that is the CFO advisory work Lyros does: talk to us about monthly management reporting.
Setup register for the chart of accounts your bookkeeper will load into your software.
A clean chart of accounts is the foundation of everything downstream. Most businesses inherit a chart that has grown organically over years, with duplicate accounts, dead codes, and inconsistent naming.
Maps each supplier to a default account, GST treatment, and approval rule.
We use chart-of-accounts mapping to supplier codes to automate the rule for what account each incoming invoice maps to in the accounting software.
Step-by-step close checklist with sign-off, ageing, and reconciliation gates.
Month-end close drifts when the checklist lives in someone's head.
Quarterly review of account balances, posting hygiene, and lookup mappings.
A quarterly check on the integrity of your accounting file.
Monthly P&L pack with headline, monthly trend, quarter comparison, wages, and working capital.
The headline workbook for monthly reporting to a leadership team or board.
One-page board read-out plus detail, cash position, and commentary.
Where the management reporting pack is built for an internal leadership team, the board pack is built for a board of directors who want governance-grade reporting with a longer narrative.
Side-by-side actuals and budget with monthly and YTD variance.
A side-by-side actuals and budget view with monthly and year-to-date variance.
Walk-the-bridge from prior-month and YTD variance drivers to current actuals.
Builds on the budget vs actual workbook to show what actually drove the variance month by month. Useful when leadership ask why we are behind and the answer is not one large item but five small ones compounded.
Department-level P&L rollup with variance to budget per cost centre.
For businesses with multiple departments or cost centres, this rolls each department's P&L up into a consolidated variance view.
Driver-based scenario flex (base, upside, downside) for forward 12 months.
Driver-based forecast with base, upside, and downside scenarios across the next twelve months. Building this from scratch is harder than it looks.
Per-entity trial balances with eliminations and combined consolidated P&L and BS.
Where a group has multiple entities and the accounting software does not consolidate them automatically (or does it poorly), this workbook accepts a trial balance per entity and produces a combined consolidated profit and loss and balance sheet with intercompany eliminations.
Forward 13-week cash flow with inflows, outflows, and opening and closing balances.
Forward thirteen-week cash flow forecast with inflows, outflows, and opening and closing balances. The standard tool for businesses under cash pressure, but useful for every business at month-end.
Daily cash position split by bank account with reconciliation to the GL.
Daily cash position split by bank account with reconciliation back to the general ledger.
Cash impact of upcoming BAS payments and refunds across the next four quarters.
Models the cash impact of upcoming BAS payments and refunds across the next four quarters.
DSO, DPO, DIO, and cash conversion cycle trend with rolling 12-month chart.
Calculates days sales outstanding, days payable outstanding, days inventory outstanding, and the resulting cash conversion cycle over a rolling twelve-month window.
Customer-level ageing buckets with follow-up tier and priority for the credit team.
A customer-level ageing bucket with follow-up tier and priority for the credit team.
Heatmap of customer ageing exposure, concentration, and top-debtor drill-down.
Where the chase list is operational, the analysis is strategic. A heatmap of customer ageing exposure, concentration risk, and drill-down on the top debtors.
Asset register with WDV opening, additions, disposals, depreciation, and closing balances.
Asset register with written-down-value opening, additions, disposals, depreciation, and closing balances.
Quarterly lodgement and payment register with due dates, amounts, and status.
A quarterly lodgement and payment register with due dates, amounts paid, and lodgement status.
Common FBT triggers screened against transactional data with exposure estimate.
Common fringe benefits tax triggers screened against transactional data with an exposure estimate.
Period-end leave balance and accrued wages liability per employee.
Period-end leave balance and accrued wages liability per employee. The accounting software calculates leave balances, but the period-end accrued wages number rarely appears anywhere cleanly.
Ranked customer revenue with year-on-year and concentration share.
Ranked customer revenue with year-on-year change and concentration share. The accounting software shows top customers by revenue; what it does not show is concentration risk.
Account-level revenue decomposition between prior and current quarter.
Decomposes the change in revenue and gross margin between a prior quarter and the current quarter by individual revenue account.
Ranked supplier spend with ABN-based dedup and year-on-year change.
Ranked supplier spend with ABN-based deduplication and year-on-year change.
Payroll cost as a share of revenue over time, by department.
Payroll cost as a share of revenue over time, broken down by department. One of the simplest leading indicators of operating health: if the ratio creeps up while revenue is flat, you are heading into trouble.
Yes. Every workbook in the library is free to download, with no sign-up. Describe what you need in the finder above or pick one from the catalogue, and the real Excel file downloads straight away.
Yes. The library is built for Australian small and medium businesses, with GST and BAS handled the way the ATO timing actually works. The GST and BAS workbooks treat GST as held in trust during the quarter rather than as a quarterly operating cost.
Microsoft Excel and your figures from your accounting software. The workbooks are working files: you supply the data on the data sheet and the reporting and analysis tabs do the rest. No add-ins or subscriptions are required.
Tell the finder what you need. If it is not built yet, Lyros builds workbooks in-house, so you can request it by email at chris@lyros.com.au or talk it through on a 15-minute call.