Skip to main content
Official Xero App Partner

Bulk Batch Deposits
in Xero from
CSV or Excel

Stop manually applying remittance payments to dozens of Xero invoices one at a time. Email your remittance file to EntryRocket (from an NDIS plan manager, payment processor, or wholesale customer) and the batch deposit appears in Xero with every invoice matched, ready to reconcile. We also handle batch payments for AP runs and payroll.

Used by businesses across the UK, Australia, New Zealand, and the US. Xero App Partner.

100% accuracy rate
3,000+ files/hour
30-day money-back guarantee
Xero-certified integration

How it works

๐Ÿ“ง

Email your batch deposits

CSV, Excel, PDF - send as-is to <unique>@files.entryrocket.com

โ†“

โš™๏ธ

Your custom reader processes it

Maps every field (invoice or bill reference, contact, amount, bank account, date) exactly how Xero needs it

โ†“

Batch deposits appear in Xero

Every field correctly mapped as it should be

โ†“

๐Ÿ“‹

You get a confirmation email

What was imported, what Xero returned, anything to review

Reconciling a remittance line by line in Xero is one of the most tedious jobs in bookkeeping. It shouldn't be.

A plan manager, a payment processor, or a wholesale customer sends one bank deposit covering thirty, fifty, or two hundred sales invoices. Xero needs a batch deposit that matches that lump sum, with every invoice it covers linked correctly. Building that by hand means opening every invoice, finding it on the remittance, ticking it off, and hoping the totals match at the end. It's slow, error-prone, and falls behind whenever the volume spikes.

EntryRocket reads your remittance and creates the batch deposit in Xero with every invoice already matched. Same workflow goes the other way for AP batch payments and payroll runs.

Common scenarios for batch deposits and batch payments in Xero

Most of these are deposit (money in) scenarios, because that's where the volume usually is. The last one is the classic batch payment use case.

NDIS plan-manager remittances

A plan manager pays for thirty or fifty participants in one deposit and sends a remittance listing every claim. EntryRocket matches each claim to the right Xero invoice (by participant, claim reference, or invoice number) and creates a batch deposit that reconciles cleanly against the bank line.

Payment-processor settlements

Stripe, PayPal, Square, Shopify Payments and similar processors batch their transactions into daily or weekly payouts. EntryRocket reads the settlement report and creates a batch deposit in Xero with the individual invoices matched, so the lump-sum payout reconciles against the bank deposit.

Wholesale customers paying many invoices in one transfer

A large customer settles 20 or 100 outstanding invoices in a single bank transfer and sends a remittance. EntryRocket reads the remittance and creates a batch deposit applying the lump sum across every covered invoice in Xero.

AP payment runs and payroll batches (the batch payment side)

Going the other way: your AP team prepares a supplier payment run, or your payroll provider produces a payment file. EntryRocket reads the file and creates a batch payment in Xero with every payee, amount, and reference filled in, ready for your team's authorisation.

Import a batch deposit (or batch payment) into Xero in four steps

The whole process takes less than a minute. You don't need to log into anything.

1

Email your remittance or payment file

Send to your dedicated @entryrocket.com address. CSV, Excel, PDF - send it as-is. No reformatting required.

2

Your custom reader picks it up

Maps each line to the right Xero invoice (for deposits) or payee (for payments), with amounts, dates, and references mapped exactly how Xero needs them.

3

The batch deposit or payment lands in Xero

Grouped into one entry that matches the bank line (for deposits) or payment run (for batch payments), ready for your team to review and authorise.

4

You get a confirmation

An email showing what was imported, what Xero returned, and anything that needs a second look.

Import batch deposits into Xero from any file format

EntryRocket works with every format your accounting software, supplier, or ERP system can produce:

  • CSV and TSV files
  • Excel spreadsheets (.xlsx, .xls)
  • PDF documents
  • XML and JSON exports
  • IIF, TXT, and YAML files

Not sure if your format is supported? Send us a sample file and we'll tell you straight away.

Files received today

CSV ndis_remittance_march.csv Imported
XLSX plan_manager_payment_batch.xlsx Imported
PDF stripe_payout_settlement.pdf Imported
XML wholesale_remittance.xml Imported

Xero document types

Invoices and bills
Purchase orders and quotes
Payments and credit notes
Manual journals
Bank transactions
Payments and Batch payments
Inventory items
Contacts

Every Xero document type, covered

Importing batch deposits is just the start. EntryRocket can create any document type in Xero.

Each reader is built around your exact file format and your Xero setup, not a generic template.

Why businesses choose EntryRocket for Xero batch deposit imports

100% accuracy

No typos, no transposed numbers. Your data goes straight from the file into Xero exactly as it should. Our accuracy rate is 100%.

Under a minute per import

Most imports complete in under a minute. We process over 3,000 files per hour.

No login required

Just email your files. You don't need to log into anything or change your workflow.

Xero-certified

EntryRocket is an official Xero App Partner. Our integration has been reviewed and approved by Xero's team.

Always on

Send files whenever it suits you: weekends, late night, whenever. EntryRocket picks them up immediately.

Real support

Got a question? You'll hear back from the engineers who build EntryRocket, not a chatbot, not a ticket queue.

Loved by businesses worldwide

"What used to take 10-12 working hours every week now takes just seconds. EntryRocket has transformed our bookkeeping workflow completely."

IB

Irma Bantjes

CFO, Stratus Financial Group ยท Sydney, Australia

95% time saved

"Our process went from 10-12 working hours to less than 10 minutes. The time savings alone make this an incredible investment for any business."

PS

Peter Samuel

Forward Trucking Services ยท UK

10 hrs โ†’ 10 mins

Frequently asked questions

About importing batch deposits and batch payments into Xero with EntryRocket.

View all FAQs โ†’
What is a batch deposit in Xero, and how is it different from a batch payment? +

A batch deposit in Xero applies one bank deposit to multiple sales invoices in a single entry, so reconciliation matches the lump sum that arrived in your bank account. A batch payment goes the other way: it groups multiple bills you're paying out in one transaction. Both are BatchPayment records in the Xero API, distinguished only by type. Most businesses need batch deposits more often (remittances from plan managers, payment processors, or wholesale customers paying many invoices at once). EntryRocket handles both.

How do I import a batch deposit into Xero from a remittance file? +

Email the remittance file (CSV, Excel, PDF, or whatever the payer sends) to your dedicated @entryrocket.com address. EntryRocket matches each line on the remittance to the right Xero invoice (by invoice number, customer reference, or account number) and creates a batch deposit grouping them into one entry that matches the bank deposit.

Can EntryRocket handle NDIS plan-manager remittances? +

Yes. NDIS plan-manager remittances are a common use case. Each plan manager has its own format; we build a custom reader for each format and they all feed into the same Xero organisation. Invoices are matched by claim reference, participant, or invoice number depending on the plan manager.

Does EntryRocket also handle batch payments for AP runs and payroll? +

Yes. Same workflow, opposite direction: email the payment run file (from your bank, AP system, or payroll provider) and EntryRocket creates a Xero batch payment with all payees, amounts, and references ready for authorisation.

Does the batch deposit (or batch payment) get auto-authorised in Xero? +

EntryRocket creates the batch deposit or batch payment in Xero with a pending status. Your team authorises it in Xero before reconciliation or release of funds. The work that's eliminated is the data entry, not the approval step.

What file formats work for importing batch deposits and batch payments into Xero? +

CSV, Excel, PDF, XML, and most structured formats. EntryRocket has built readers for NDIS remittances, payment-processor settlements, bank payment exports, and payroll batch files.

Start importing batch deposits into Xero automatically

If you're spending even 15 minutes a week on manual Xero data entry, EntryRocket can give that time back. Most readers are ready within 2-3 business days.