Guides

Step-by-step fixes for jobs Xero leaves to you: getting a batch payment file accepted by your bank, and creating purchase orders in bulk from a spreadsheet.

• Santander rejected my Xero batch payment file: how to fix it

  Why Santander Connect rejects a Xero batch payment file (the missing debit account reference, a blank last line, an empty trailer total) and how to fix each one.

• Xero batch payments to NatWest Bankline, Revolut and Monzo

  Xero gives most UK banks a BACS file. What NatWest Bankline, Revolut Business and Monzo Business accept instead, and how to turn the Xero file into theirs.

• How to import purchase orders into Xero from a CSV

  Xero has no purchase order import. How to create purchase orders in bulk from a CSV through the Xero API: columns, dates, tax rates, contacts and tracking.