Connected cash flow forecasting software removes the data transfer: the exports, the pasting, the re-keying of balances, invoices, bills and recurring items that a spreadsheet forecast needs every week. It does not remove the judgement. Deciding when a slow customer will pay, adding the commitments nobody has invoiced yet and reviewing the result all stay with the finance team, and how much of the transfer work disappears depends on which accounting platform you connect.

"Forecasting software that reduces manual data entry" is a crowded phrase. Sales teams use it for pipeline forecasting, large finance functions use it for FP&A planning platforms, and both make the same promise. Here it means cash flow forecasting for a business running on Xero or QuickBooks Online, where the manual entry is ledger data being moved into a spreadsheet by hand. If that is how your forecast starts each week, this one is for you.

What "reduces manual data entry" means for a cash flow forecast

A spreadsheet cash forecast has a maintenance loop that every guide to the subject describes the same way. Carry the opening balance forward, list the cash expected in and out for each period, calculate the closing balance, add a column for what actually happened, and revise the periods ahead. The Welsh Government's business guidance puts the cadence at "ideally at least once a week", and the closing balance "carries over to become the opening balance for the next month". None of that is data entry. It is the forecast.

The data entry is everything that has to happen before that loop can run when the spreadsheet is not connected to the ledger: getting the bank lines, the open invoices and the bills out of Xero or QuickBooks Online and into the workbook, in the right cells, every time. When forecasting software says it reduces manual data entry, it is claiming to take over some or all of that transfer. The useful question is which parts, because the claim covers several different things.

Across the tools that connect to Xero or QuickBooks Online, "automation" is used for eight distinct jobs: importing ledger data on a schedule; syncing the chart of accounts and mapping accounts to forecast lines; projecting future lines from history; learning expected payment dates from payment behaviour; replacing forecast lines with reconciled actuals; generating tax lines; consolidating entities and converting currencies; and sending alerts or scheduled reports. No tool does all eight, and none claims to generate scenarios on its own. The rest of this page says which of them a connected forecast does for a finance team of three to six, and on which platform, using Float as the example because its help centre documents each one.

The manual steps a connected forecast removes

Below is a typical weekly refresh of a disconnected spreadsheet forecast, written from how finance teams describe it rather than from any professional body's list, because no professional body publishes one. Beside each step is what happens once the forecast reads the ledger directly.

Counting the ten steps above, on Xero eight happen without anyone typing, the tie-out in step 9 becomes a check, and the expected dates in step 7 are applied from payment history with the exceptions handled by hand. On QuickBooks Online six happen without typing, recurring items in step 6 are entered once and then roll forward, and the expected dates and the tax line stay with the team. That is the page's own count of the steps it listed, not a measurement of hours, because no professional body or statistics office has measured the time a small finance team spends maintaining a spreadsheet forecast, and any figure that claims to would be a guess.

What the transfer steps cost is not only time. Audits of operational spreadsheets found errors in 0.9 to 1.8 per cent of formula cells, and in inspection experiments reviewers caught around 60 per cent of the errors planted for them, results from specific studies of business spreadsheets and student inspectors rather than a rate for your workbook. Every paste and re-key is one more place for that class of error to enter, and a connection removes the class rather than the individual mistakes.

What is automatic on Xero, and what is automatic on QuickBooks Online

The two platforms do not give a forecasting tool the same material, and a page that says "connects to Xero and QuickBooks" without saying what differs is hiding the part a QuickBooks user most needs. From Float's help centre, this is the position as at September 2026.

Two things in that table deserve a sentence each. Purchase orders and quotes are not imported from either platform, and they are precisely the ledger's record of money the business has agreed to spend or receive before a bill or invoice exists, so that part of the forecast is entered by the team on both platforms. And the last row is deliberate: Float shows on the side panel the date the balance is due to cross a threshold you set, but it does not send alerts, schedule reports or distribute anything. Exports to PDF and CSV, and presentation mode, are started by a person.

The connection is one-way, and what that means on each platform

Data flows from the accounting platform into the forecast and never back. Float reads the ledger and does not write to it, so nothing set in the forecast can alter your books, and if a due date or expected date is changed in Xero or QuickBooks Online it overwrites the date set in Float on the next import. That is why the team's additions belong in expected dates and budgets rather than in the ledger.

Underneath, the two platforms enforce this differently. Xero publishes read-only permissions, so a tool that asks only for those cannot post anything, and a user can see that on the consent screen when the connection is authorised. QuickBooks Online has a single accounting permission that covers reading and writing, so on QuickBooks the read-only behaviour is a property of how the tool is built rather than a permission the platform enforces. Float's connection is one-way on both; the difference is only in what the platform itself guarantees, and it is worth knowing when the IT manager asks.

What still needs a person after the connection is made

The steps below are the finance team's half of the forecast. They are the reason the forecast is worth reading.

Reconciling, daily or at least weekly. Only reconciled transactions reach the forecast, and the opening position is the reconciled ledger balance, not the bank-feed balance. A fortnight of unreconciled lines is a fortnight the forecast cannot see. Float's own guidance is to reconcile every day, or at least every week, and the discipline sits with whoever runs the ledger. For the accounts behind that, see what Xero gives your cash flow forecast and what your finance team adds.

Expected dates for the exceptions, and on QuickBooks Online for most invoices. A due date is not a cash date. In the UK Department for Business and Trade's 2025 research, 42 per cent of businesses with 10 to 49 employees were experiencing late payment issues at the time of the survey, and the department's 2025 statistics on large payers put their median time to pay at 32 days with 15 per cent of invoices paid late. In Australia, the Payment Times Reporting Regulator's latest cycle, covering July to December 2025, found 68.5 per cent of invoices to small suppliers paid on time and the slowest five per cent taking 55 days. Payment behaviour is a fact about your customers that the ledger does not hold. On Xero, Smart Expected Dates applies each customer's average days late as invoices import, and the team handles the exceptions: a promise to pay, a dispute, a part payment. On QuickBooks Online the team sets expected dates for anything the platform does not already carry. Either way, an overdue invoice with no expected date is assumed to be paid today and flagged in the app, which is why the overdue list is the first thing to work through each week.

Commitments the ledger has not seen. A signed contract not yet invoiced, a purchase order not yet billed, a hire agreed for next month, a tax bill not yet assessed. These enter the forecast as budgets: repeating, one-off, auto or linked. Budgets can be pasted in from a spreadsheet grid, in the base forecast, but there is no file import, so an existing model moves across as its assumptions rather than as a file. Our guide to alternatives to spreadsheets for cash flow planning covers the migration.

Retiring budgets. A repeating budget keeps projecting until a person stops it, and an auto budget keeps tracking history after the thing it tracked has ended. The forecast does not know the contract finished.

Placing new accounts. A new ledger account with activity appears in the forecast on the next sync, but it appears on its own. Someone decides which group it belongs in, or it sits unplaced.

Tax on QuickBooks Online. VAT and GST forecasting is automatic for Xero users in the UK, Australia and New Zealand. QuickBooks Online users enter the payment as a repeating budget on the statutory date, and corporation tax is a one-off budget on its due date for everyone.

Scenarios. No tool builds scenarios unprompted. A hire, a lost customer or a price rise is a layer the team adds on top of the base forecast and switches on or off.

The review. Refreshing the data is automatic. Reading the variance, deciding which misses are timing and which are amount, and deciding what to do about the balance in week nine is the job. The reporting that follows the review is the subject of our guide to automating cash flow reporting.

Checking an automation claim for yourself

Four things worth raising on a demo call. The answers are specific enough that you can tell quite quickly whether the vendor has looked.

Start with the import list, one per platform. What arrives from Xero and what arrives from QuickBooks Online are different lists, and a vendor who gives you the same list for both has not checked. Repeating templates, draft invoices, manual journals: in or out?

Then the sync. "Live" and "real-time" usually describe the screen recalculating rather than the data arriving, so ask for the schedule instead. Float's is once a day at an hour you set, with a manual sync whenever you want one, and the forecast is only ever as current as the last reconciled transaction.

Expected dates are where the answers vary most. Putting an invoice on its due date is not the same as working out when that customer pays, and which of those you get depends on the platform. If a vendor says the tool predicts payment dates, ask which platform that works on and how much history it reads.

Last, what the tool writes back to your ledger. Nothing should. On Xero you can check that yourself: the platform publishes read-only permissions, and the consent screen shows which ones a tool has asked for. QuickBooks Online has a single accounting permission covering both reading and writing, so there you are relying on the vendor to say plainly that their tool never sends a write.

How Float fits

Float is a cash flow forecasting tool built around exactly this division of labour. It connects to Xero or QuickBooks Online in about three minutes with no CSV exports and no manual entry for the connection itself, imports once a day at an hour you choose with on-demand sync, and reads the ledger without writing to it. From Xero it imports bank accounts, credit cards, invoices and bills including those awaiting approval, repeating invoice and bill templates, draft invoices if you switch that on, transactions and journals; from QuickBooks Online it imports bank accounts, credit cards, invoices and bills, transactions and journals. Neither import includes purchase orders, quotes or estimates, tracking categories or classes.

The automation on top of the import is the part the table above set out: actuals filling budgets as they reconcile, auto and linked budgets from reconciled history, consolidation across entities with currency conversion, and a threshold date on the side panel. For Xero users, Smart Expected Dates applies each customer's payment history as invoices arrive, and VAT or GST is forecast automatically in the UK, Australia and New Zealand. QuickBooks Online users set expected dates and the tax line in Float, and carry recurring items as repeating budgets.

What Float does not do is also on the page: it does not send alerts or scheduled reports, it does not import a spreadsheet file, and it does not generate scenarios. The Xero and QuickBooks Online pages list what syncs on each, our guide to setting up automated cash flow forecasting with Xero covers the setup sequence, and built-in cash flow planners versus dedicated forecasting tools is the page to read if you are still deciding whether the platform's own planner is enough.

Frequently asked questions

Is there forecasting software that reduces manual data entry?

Yes. Cash flow forecasting software that connects to Xero or QuickBooks Online removes the export, paste and re-key steps by importing reconciled transactions, balances, invoices and bills on a schedule. Float imports once a day at an hour you choose, with on-demand sync. What it does not remove is the judgement: expected payment dates for the exceptions, commitments not yet invoiced, and the weekly review stay with the finance team.

What data entry is left after connecting Xero or QuickBooks Online?

After connecting, the team still enters budgets for anything not yet in the ledger, sets expected dates where the platform's date is wrong or missing, retires budgets whose cost has ended, places new accounts in the layout, and builds scenarios. On QuickBooks Online the team also enters recurring items as repeating budgets and the VAT or GST payment as a budget, because repeating templates do not sync and automatic tax forecasting is Xero-only.

Does forecasting software import recurring invoices and bills?

It depends on the platform. Float imports repeating invoice and bill templates from Xero, so a monthly retainer appears in the forecast before the individual invoice exists. QuickBooks Online recurring invoices and bills do not sync to Float, so they are set once as repeating budgets, which then roll forward on their own.

Can forecasting software predict when customers will pay?

On Xero, Float's Smart Expected Dates applies each customer's average days late, from three to twelve months of your own payment history, to new invoices as they import; the date is applied once, never recalculated, and can be overridden. On QuickBooks Online, expected dates set in the platform import and any others are set in Float. On either platform, an overdue invoice with no expected date is assumed to be paid today and flagged in the app.

Is the sync real-time?

No, and no connected forecasting tool reading an accounting ledger is. Float imports automatically once a day at an hour you choose in company settings, and a manual sync pulls the latest data when you have just updated the ledger. The forecast recalculates instantly after a sync, but the data is as current as that sync and the reconciliation behind it.

Does the tool change anything in my accounting platform?

No. The connection is one-way: Float reads the ledger and does not write to it, and a change to a due date or expected date in Xero or QuickBooks Online overwrites the date set in Float on the next import. On Xero the read-only permission is enforced by the platform and visible on the consent screen; on QuickBooks Online, whose single accounting permission covers reading and writing, it is a property of how Float is built.

Can I import my existing spreadsheet forecast?

Not as a file. Float's Spreadsheet Data tool lets you paste budgets from a spreadsheet into a grid, in the base forecast, with the numbers stripped of symbols and commas. The ledger data comes from the connection; what moves across from the old model is the assumptions the ledger does not hold.

Does automation mean I can stop reconciling?

The opposite. Only reconciled transactions reach the forecast, and the opening position is the reconciled ledger balance rather than the bank-feed balance, so unreconciled lines are cash movements the forecast cannot see. Float's guidance is to reconcile daily, or at least weekly. The connection removes the transfer work; it makes the reconciliation discipline matter more, not less.

Who can see and change the forecast?

Float has four user roles: an owner, admins who can edit everything and manage users, editors who can edit everything but not users, and viewers with read-only access. Two-factor authentication is mandatory for Xero-connected accounts and recommended for all. Support access to your account is a setting you switch on and off yourself.

What does connected cash flow forecasting software cost?

Pricing depends on the size and structure of the business, including how many entities you connect. Current plans and what each includes are on the Float pricing page, and every plan starts with a free trial, so you can see which of the ten steps disappear with your own ledger before paying anything.

If your forecast still starts with an export button, connect your ledger and count the steps that go. Start a free Float trial and Float will import your Xero or QuickBooks Online data in about three minutes, or book a demo and we will walk through your current refresh with you.