Small businesses banking with AU Small Finance Bank usually start bookkeeping with good intentions and a spreadsheet — and end it with a shoebox of PDFs at tax time. If that sounds familiar, it is time to import AU Bank statement into Xero properly. A file-based import takes about fifteen minutes a month, keeps every transaction traceable to the original statement, and turns the monthly close from a dreaded weekend project into a coffee-break task.
This guide is written for small-business owners, not accountants: the practical choices (bank feed or file import?), the exact steps, and the mistakes that cost the most time to fix.
Bank feeds vs. file imports: which fits AU Bank users
Xero offers two ways to get transactions in: a live bank feed that pulls them automatically, or a manual file import from a converted statement. Bank feeds are convenient, but they have quirks — feeds can disconnect, re-pull old transactions after a reconnect, and give you no clean audit file to point at later. A file import is deliberate: you control the exact period, you keep the original statement as evidence, and every imported line traces back to a specific file.
For most small businesses, the pragmatic answer is one method per account, used consistently. If your AU Bank feed has ever duplicated a month after a reconnect, switching that account to monthly file imports will feel like a relief. If the feed has been rock-solid, keep it — just never run both at once for the same account, because that is the number-one source of duplicate transactions.
Step 1 — Export your AU Bank statement
Log in to AU Bank's net banking portal or mobile app and download the statement for the account you reconcile in Xero. Choose a full calendar month and the PDF format. Save the file with a clear name — something like "AU-Bank-2026-09.pdf" — so that six months from now you can still tell which file produced which import.
While you are there, glance at the statement's first and last pages and note the opening and closing balances. You will compare these against the converted file in a moment; thirty seconds of checking here saves hours of reconciliation hunting later. If the PDF asks for a password, have it ready — the converter will ask for it during upload, use it only to read the tables, and discard it immediately.
Step 2 — Convert and tidy the data
Xero imports CSV, OFX, and QIF files, and a clean CSV is the easiest to inspect. Upload the AU Bank PDF to Convert Statement and download the CSV — your first 8 pages are free and most monthly statements fit comfortably. Open the result in a spreadsheet and run a two-minute quality check: one row per transaction, dates in a single consistent format, amounts numeric with no currency symbols, and descriptions readable.
Watch for the multi-line description problem: some statements wrap a long merchant name across two PDF lines, and a careless conversion splits it into two rows — one with a blank description. If you spot a blank row, check whether it belongs to the transaction above it. Also confirm the opening and closing balances match the PDF. Balances that agree mean the conversion is trustworthy; balances that disagree mean you should re-export the statement before going further.
Step 3 — Import into Xero without mapping headaches
In Xero, open the bank account and choose the statement import option, then upload the CSV. Xero asks you to map columns to date, description, and amount — this is the step people rush, and rushing it is what produces "imported but wrong" books. Take the thirty seconds to verify each mapping, especially if your file uses separate debit and credit columns rather than a single signed amount column.
Review the preview screen carefully before confirming. Scan for blank dates, amounts in the wrong column, and any transaction dated before your previous import's end date — that last one is the fingerprint of an overlapping period. If the preview is clean, confirm the import. The lines land in the account's review tab, ready for categorization. The same mapping discipline applies to any bank — see our Lloyds Bank to Xero walkthrough for another worked example.
Categorizing AU Bank transactions in Xero
With the lines imported, work the review tab methodically. Xero suggests categories based on past behavior — accept correct suggestions, correct wrong ones, and let the system learn. Create bank rules for the transactions that repeat every month: rent, internet, supplier payments, card settlements. Two or three months of disciplined corrections and the rules handle the bulk of the statement on their own.
Treat transfers between your own accounts as transfers, not expenses — mislabeling a transfer inflates both spending and income. And if a transaction truly cannot be identified, code it to an "ask my accountant" holding account rather than guessing; a flagged item is honest, a guessed category is a future correction. Pair this routine with a proper bank reconciliation habit and your books stay audit-ready all year.
Common import errors and how to fix them
Everything imported but the balance is wrong. Almost always an overlapping period or a duplicated file. Delete the imported batch (Xero lets you remove a statement import), fix the date range, and re-import.
Dates landed in the description column. The CSV's date format didn't match what Xero expected during mapping. Standardize the date column in the spreadsheet and re-import.
Amounts look doubled. You probably mapped both a signed amount column and separate debit/credit columns. Map only one representation.
Some transactions are missing. Check whether they fell on a second page range you didn't include, or whether multi-line descriptions split rows. Re-export the full period and reconvert.
Frequently asked questions
Should I use Xero's bank feed or manual imports for AU Bank?
Use one or the other per account, not both. Feeds are hands-off but can re-pull transactions after reconnects; file imports give you exact period control and a clean audit trail. Many small businesses prefer imports for exactly that reason.
How do I avoid duplicates when importing monthly?
Import non-overlapping calendar months in order, and never enter transactions manually for an account you also import. One path per account is the whole rule.
What if the CSV has a blank description row?
It is usually a wrapped merchant name split across two rows — merge it with the row above. If blanks persist, reconvert the PDF; see our AU Bank converter page for format notes.
Can I import a full year of statements at once?
You can, but do it month by month in chronological order. Smaller batches are easier to review, and errors stay contained in one period.
Fifteen minutes a month beats a weekend of catch-up every time. Convert your AU Bank statement to CSV free and make this the month your Xero books finally stay current.