Weekly Cash Flow Report from Xero: Watching Cash by the Week, Not the Month

The September management accounts arrive in the second week of October. Cash at 30 September is $212,000, up on August. Revenue is on budget. Nothing to see.

Except that on Thursday 17 September, the day before payroll, the operating account held $9,400. The owner spent that afternoon moving money out of the tax account and asking two suppliers to wait until Monday. Their biggest customer had paid a week late. By the 30th it had all washed through.

Month-end is one day out of thirty. A weekly cash flow report shows the other twenty-nine, and it's how most owner-managed businesses actually watch cash. This post covers why cash runs in weeks, what Xero's own reports give you, and what a weekly cash report built from Xero data should show.

Why cash runs in weeks

Profit is a monthly idea. Accruals, depreciation and the management accounts all run by month, and for profit that's right.

Cash doesn't. For companies of certain industries like F&B and retail, it moves to a weekly rhythm set by a handful of fixed dates:

• Payroll goes out on the same day every week or fortnight, and it's usually the biggest single payment.
• Supplier runs happen on a set day, often weekly.
• Customers pay when they pay. Card takings settle daily, and there's a time lag between when the company makes money vs when it actually gets it.
• Tax, rent and loan repayments fall on fixed dates. When two of them land in the same week as payroll, that's the trough.

A month adds all of that up and tells you where it ended. The lowest point, usually the day before payroll or the supplier run, disappears into the total. A month is also too long to act on: by the time September's report says cash was tight, October's payroll has gone.

A week is short enough to do something about. Chase the debtor, hold a supplier payment, draw on the overdraft before you need it rather than after. That's why owners check the bank app on Monday morning. A weekly cash flow report is that habit written down, with last week explained and the next few weeks laid out.

Where native Xero stops

Xero holds every transaction a weekly cash report needs. Its own reports just aren't laid out for the job.

Every week is a date range you type in. The Cash Summary will run for any range, so last week is one report away, and you can set earlier periods beside it. But every Monday someone sets the dates again. A request on Xero's product ideas board for a "last week" option on Account Transactions, from someone tired of changing the dates for their weekly reporting, has sat on the board since September 2024.

It's laid out by account, not by what the cash was for. The Cash Summary groups cash by the chart of accounts: income and expense accounts, then working capital and other balance sheet movements. An owner thinks in five or six lines: customers, payroll, suppliers, tax, loans, drawings. Payroll alone can sit across wages, a payroll tax liability and a pension or CPF liability, and a loan repayment splits into interest in one section and principal in another.

It doesn't show each bank account week by week. The question is usually about one account: does the operating account have enough for Friday? The Bank Summary gives each account's opening balance, money in, money out and closing balance, one date range at a time. Neither report shows the lowest balance during the week, which is the number that matters on payroll Thursday.

It only sees what's been entered. Xero's reports run on the balance in Xero, which is made of transactions someone has entered or reconciled. A line on the bank feed that nobody has dealt with yet isn't in any report. On a Monday morning, last Thursday and Friday are often still waiting on the reconcile screen, so last week looks quieter than it was.

The forward view stops at what's booked. Xero's short-term cash flow projection, included on every plan, draws the next 7 or 30 days from the balance in Xero and the invoices and bills already entered. Xero Analytics Plus looks further ahead and adds predictions based on past transactions. It's a useful dashboard, but it only knows what's in Xero or has happened before. Repeating amounts can be added, but not quarterly ones: a request for quarterly repeats, for BAS and super, has been marked "Submitted" since 2025. And there's no record of last Monday's projection to compare with what actually happened.

What hitting the wall looks like

The owner who reads the bank app. A 20-person contractor checks the balance every morning and gets management accounts every month. The accounts say the business is fine. The real worry is the fortnight when payroll lands and a progress claim is paid late, and that needs the next few weeks with who owes what, the same data that drives a proper AR ageing report.

The bookkeeper's Monday email. For each client: export Account Transactions for the bank accounts, paste them into the weekly cash spreadsheet, recategorise 200 lines, type the balances in from the bank app because Friday isn't reconciled yet, and send it by ten. An hour per client, every week. Scheduling a report only helps once the report exists.

The restaurant group's finance manager. Card takings settle daily, suppliers are paid weekly, rent monthly and payroll fortnightly, and every venue is its own Xero file. The weekly cash view is one export per venue and a merge, the same problem as multi-entity reporting on a weekly clock. There's more on that world in F&B reporting from Xero.

What a good weekly cash flow report looks like

1. The weeks are defined once. Pick the day your week ends and number the weeks. Every report reads the same calendar, and if you also trade on a 4-5-4 calendar, they're the same weeks.
2. Every bank account, every week. Opening, money in, money out and closing for each account, in its own currency, plus the total. And the lowest daily balance in the week, not just the closing one.
3. Your categories, not the chart of accounts. Customer receipts, payroll, suppliers, tax, financing, drawings, each mapped once from accounts and contacts. Transfers between your own accounts are netted out, so they don't show up as money in and money out.
4. It says how complete each week is. Each account shows the date it's reconciled to, so a week the bookkeeper hasn't finished is flagged rather than passing as a quiet one.
5. Thirteen weeks in one row. Past weeks actual, coming weeks forecast, side by side. More on that below.
6. Every number traces back. "Why were supplier payments so high in week 42?" should take one look at the payments behind the figure, not an investigation.
7. It arrives on Monday morning without anyone having to run it.

Rolling a 13-week cash flow from Xero

The 13-week cash flow is the standard shape for a reason. A quarter is long enough to see the next payroll-and-tax week coming and short enough to forecast honestly. Built from Xero, it works best as one row of weeks that rolls forward every Monday.

Here's a slice of one, run on Monday 19 October. Figures in thousands.

Three things happen every Monday:

• The week just closed turns from forecast to actual. Last Monday, the week to 18 October was forecast at 75 in. It came in at 61, because one customer's 14 slipped into the following week. That variance is the most useful line in the report: it shows where your assumptions are wrong, customer by customer.
• The forecast weeks update from Xero. New invoices and bills land in the week they're expected to be paid, based on how each customer actually pays rather than the due date.
• A new week 13 appears at the end. Payroll, rent, tax and loan repayments come from a schedule held once, so the new week arrives already holding what's known.

The week to 1 November is the one to watch. Payroll, the quarter's GST and rent land together, taking cash to 65 at the close and 58 on the worst day. Seeing that on 19 October leaves two weeks to chase receipts or move a payment. Seeing it in the October accounts leaves none.

The forecasting logic itself, from collection profiles to scenarios, is covered in why Xero can't tell you next month's cash. The weekly report is what keeps that forecast honest, because every Monday it's checked against a week that really happened.

The workarounds, ranked

1. The bank app and a good memory. The default, and fine while there's one account and one person who knows every payment. There's no history, no forward view and nothing to hand to anyone else.
2. Xero's Cash Summary or Bank Summary, run every Monday. Exact, because they're Xero's own numbers. They're also in the chart-of-accounts layout, one range at a time, and short wherever the bank feed isn't reconciled.
3. A weekly cash analysis spreadsheet. Export Account Transactions for the bank accounts, add a week column, map accounts and contacts to categories, pivot. It handles weeks and your categories, and it's where most businesses end up. It breaks when the export columns change or a new account appears, the forecast weeks are typed in by hand, and it belongs to whoever built it.
4. A cash forecasting add-on. Good at the forward view and at scenarios. Check whether it shows actual weeks beside forecast ones, whether its categories can be yours, and whether it copes with several organisations.
5. A build on the Xero API. Pull bank transactions and payments, bucket them by week and lay the forecast on top. It's the only route that is exact, repeatable and in your layout, and it's real engineering: the API has no Cash Summary, its Profit and Loss steps by month, quarter or year, and its Bank Summary takes one date range per call. More in building on the Xero API.

Where Cheetah fits

Most of the weekly cash work we do at Cheetah starts with the spreadsheet someone updates every Monday. We encode what it does: the week calendar, the bank accounts, how each account and contact maps to your categories, and the schedule of payroll, rent, tax and loan payments. The report then pulls bank transactions, invoices and bills from Xero, marks how far each account is reconciled, rolls the 13 weeks forward and shows last week's actuals against what was forecast.

It arrives in Google Sheets with plain formulas and an Excel download, and it can run on a schedule, so it's in your inbox before the Monday meeting. If you run several organisations, they sit side by side and in total.

If your week starts with a bank app and a spreadsheet, it might be worth a conversation.

The short version

Month-end cash is one day. The weeks in between are where payroll, supplier runs and late customers collide, and where owner-managed businesses actually run short. Xero holds every transaction you need, but its own reports run one date range at a time, in the chart-of-accounts layout, only as complete as the reconciliation, and its projection only knows what's booked. A weekly cash flow report fixes the frame: every account, every week, in your categories, thirteen weeks rolling, and checked against last week's forecast every Monday. For the reporting layer underneath it, see Xero Custom Reports: 4 Ways to Build Them in 2026.