Skip to content
StatementClear
Start a free trial

Your OptiPay facility has no Xero feed. Import the movement report as one.

OptiPay's Xero integration runs one way: it reads your receivables ledger so the platform can fund against invoices. No bank feed exists for the facility, so advances, collections, fees and charges never reach Xero. StatementClear posts the availability movement report in as live feed lines.

An OptiPay facility moves money constantly - advances drawn down, debtor payments collected, fees and charges deducted inside the account - and none of it reaches Xero on its own. So every month someone exports the movement report and rebuilds the facility in the books by hand. StatementClear turns that same export into a live bank feed in Xero, deduped, balance-checked and ready to reconcile.

Start a free trial

14 days, no card. Connect Xero and post a real statement before you decide anything.

Why your OptiPay facility has no Xero feed

OptiPay lists a Xero integration, but it works in the other direction: it connects your receivables ledger so the platform can fund against your invoices - data flows out of Xero, not in. No bank feed exists for the facility itself, so the advances, collections, fees and charges moving through your OptiPay account never arrive in Xero on their own.

OptiPay's exports are built for running your facility, not your bookkeeping. The platform tracks availability - the headroom left to draw - alongside the actual movements, and its availability movement report comes out as a spreadsheet whose columns don't line up with what Xero's importer expects: charges sit in their own columns rather than as signed amounts, and there is no running balance to check against. StatementClear handles real OptiPay exports today: map the columns once - there is an "all money out" option built for charge-only files like these - direction is applied from your organisation's perspective rather than the funder's, a sign-flip check catches a reversed mapping before anything posts, and the mapping is remembered so next month's upload just works.

The manual way, every month

  • Log in and export a statement (and hope the format didn't change)
  • Reformat columns, dates and signs until Xero's importer accepts it
  • Upload the CSV into the right account and pray nothing doubled up
  • Eyeball the balance, fix what broke, repeat next month

And after all that, it still isn't a feed - it's a one-off import you'll redo next month.

The StatementClear way: a real feed

Upload the statement and it posts into Xero as a live bank feed through Xero's Bank Feeds API - deduped, balance-checked and ready to reconcile. Not another file to import. Converters hand you a CSV; this arrives in Xero the way a bank feed does.

  1. Step 1

    Connect Xero

    Link your org and pick the account that is missing transactions.

  2. Step 2

    Upload your OptiPay statement

    PDF, CSV or Excel - whatever you can export. Map the columns once and we remember the mapping.

  3. Step 3

    We check it first

    Duplicates are skipped, the running balance is verified, and sign errors are caught before anything posts.

  4. Step 4

    It lands as a feed

    Clean lines arrive in Xero through the Bank Feeds API, ready to reconcile.

Questions about OptiPay and Xero

The money side. OptiPay's integration reads your invoice ledger so the platform can fund against it - it does not put anything back. The facility account itself, with its advances, collections, fees and charges, has no feed, so nothing lands in Xero to reconcile. StatementClear supplies that missing feed from the platform's own export.

With a mapping step built for exactly this file. Pick the date, description and amount columns, choose "all money out" for charge-only exports (or separate debit and credit columns if your report has them), and the lines post with the right sign from your organisation's perspective. The mapping is saved, so repeat uploads apply it automatically.

Only real money movements: advances paid to your bank, debtor collections, and the fees and charges deducted inside the facility. Availability is headroom, not cash, and the sales ledger tracks invoices, not money - both stay out of the feed. That is what keeps the facility reconcilable instead of double-counted.

A real feed. StatementClear posts through Xero's Bank Feeds API, so your OptiPay lines land in Xero as live feed lines ready to reconcile - not another CSV to massage through the importer. Upload the export; duplicates are skipped and the direction is checked before anything posts.

Where this comes from

Everything above about what Xero's native feed covers, what its manual import accepts and how feed lines reach a bank account comes from Xero's own documentation. The relevant pages are below, so you can check the claim rather than take it.

  • About bank feedsXero's own account of which feeds exist, how they connect and what they do not cover.
  • Import a CSV bank statementThe manual import: the formats it accepts, and how it handles lines it has seen before.
  • Bank Feeds API overviewThe interface StatementClear posts through, and the reason a fed line is not an imported one.

Related accounts

Stop importing OptiPay statements. Start feeding them.

Connect Xero, drop in a OptiPay statement, and watch the lines arrive as feed lines.

Start a free trial

14 days, no card. Connect Xero and post a real statement before you decide anything.

Browse every bank and platform or read the Xero bank feed guides.