Skip to main content

How to Send Bank Statements from tofu to Xero (Bank Feeds and CSV Export)

tofu extracts bank statement data for AP and AR workflows. Upload PDF statements, review transactions, then export a Xero-ready CSV or publish directly to your Xero bank account with Bank Feeds. Faster reconciliation, less manual work.

Written by Jess B

tofu gives you two ways to get bank statement transactions into Xero. Export a Xero-supported CSV and import it manually, or publish directly to your Xero bank account using Bank Feeds. Both paths start the same way: upload your statement, review the extracted data, and mark it Ready.

1. Turn on Bank Statement as Extraction Type

  1. Go to Entity Settings → Features.

  2. Under Document Extraction Types, toggle Bank Statement ON.

Once enabled, bank statement extraction can be used across both Accounts Payable (AP) and Accounts Receivable (AR) workflows to support faster reconciliation.

2. Upload a Bank Statement

You can upload bank statements manually or via a cloud integration:

  1. Go to your Source Documents column.

  2. Click Upload document.

  3. Select your bank statement file to upload.

tofu can process bank statements of 1000+ pages, so there's no need to split long statements.

💡 For the easiest workflow, connect Google Drive, SharePoint or Email so statements uploaded to your connected folder sync into tofu automatically.

3. Review the extracted data and mark it Ready

Go to the Extractions column to review:

  • Bank Account

  • Currency

  • Statement Start Date and Statement End Date

  • Opening Balance and Closing Balance

Transaction Table Includes:

  • Date

  • Description (expandable for full details)

  • Amount (money in shows as a positive value, money out as a negative value)

  • Reference

  • Currency (assigned per transaction row for multi-currency statements; rows without a currency use the statement header currency)

  • Contact (shown at the far right; tofie suggests contacts based on transaction details and flags new ones with a New label, learning from your past reviews, so always take a quick look before publishing or exporting)

💡 Edit header details or line items directly in tofu. Click Save Draft before leaving the page. Once the data is accurate, click Mark Ready. If the statement still has a New contact label to confirm or a validation error to fix, it stays in Draft until you resolve it.

📘 Learn more: How to Review Bank Statements v2 in tofu

4. Publish Directly to Xero with Bank Feeds

If your entity is connected to Xero, you can publish a Ready bank statement straight into your Xero bank account. Your transactions appear in Xero ready for reconciliation, with no CSV download or manual import needed.

Each bank statement can only be published to Xero once. If you delete the statement in tofu afterward, it will not be deleted or changed in Xero, so review everything carefully before publishing.

Before you publish, check that:

  • Your Xero organization supports Bank Feeds. Inactive organizations, the Demo Company, and Ledger editions don't work with this integration.

  • The bank account on the statement exists in Xero and in Entity Settings → Accounting. The Bank Account field shows the matched account once linked.

  • No other bank feed is already connected to that Xero bank account, unless it was created by tofu.

  • Statement Start Date and Statement End Date are filled in, and every transaction date in the transaction table falls within that range. Xero accepts statements dated within the past 12 months, the end date cannot be in the future, and the end date cannot be earlier than the start date.

  • Opening Balance and Closing Balance are entered, and the closing balance matches the opening balance plus your transaction totals.

  • The statement hasn't already been published, and no duplicate for the same period or content has already been submitted.

  • The statement is Marked Ready.

To publish:

  1. Open the Ready bank statement.

  2. Click Publish at the top of the Bank Statement tab.

  3. tofu sends the transactions to the matching bank account in Xero. Click the Xero link to open the statement in Xero.

  4. In Xero, go to Accounting → Bank accounts to reconcile as usual.

  5. Back in tofu, click Mark Done to wrap up the extraction.

💡Good to know

  • Bank feeds supports single account bank statements. For multi account statements, use the Xero Bank Statement CSV export below.

  • The first time you publish, Xero may ask you to reconnect your integration. This grants tofu the bank feeds permission needed to publish statements.

5. Export a CSV and Import into Xero

Prefer to import manually, or working with a multi account statement? You can export a Xero supported CSV instead.

In tofu:

  1. Open the Ready bank statement and click Export.

  2. Select the Xero (CSV) template.

  3. Once exported, the statement moves to Exported. Click Mark Done when you've imported the file into Xero.

tofu converts the statement into a Xero-supported CSV, ready for import. No manual mapping needed.

In Xero:

  1. Go to Accounting → Bank accounts.

  2. Choose the bank account you want to update.

  3. Click Import a Statement.

  4. Upload the Xero-formatted file you exported from tofu.

Transactions will process immediately, allowing fast reconciliation.

✅ Pro Tips

  • Complete the statement dates and opening and closing balances before marking the statement Ready, so publishing is available right away.

  • Check currencies for each line item in multi-currency statements.

  • Use AI contact suggestions to save time, but always review.

  • Integrate cloud storage for automated uploads.

Related Articles
Did this answer your question?