Bank Statement Converter for Surf Accounts — Import a PDF (Ireland)

When an import beats waiting for the feed

Bank feeds are convenient day to day, but there are moments they can't help with. Setting up a business in Surf mid-year leaves you needing the earlier months that predate the connection. A deposit account, a loan account or a second entity often isn't fed at all. And when a practice takes on a new client, what arrives is a stack of statement PDFs and a deadline, not a live feed reaching back over the history. In every one of those cases the PDF is already the record you have — so converting it and importing beats keying euro transactions in by hand, and it means the reconciliation begins from a complete period rather than a partial one.

From PDF to a Surf Accounts import

1. Download each statement as a PDF — AIB Internet Banking, Bank of Ireland's 365 Online, Permanent TSB's Open24 and the others keep them online.
2. Convert it to a CSV. Every transaction returns as a row — date, description, debit, credit and running balance in euro — with the closing figure checked.
3. Import into Surf Accounts. Bring the CSV in through the bank import, mapping the date, description and amount columns once.
4. Reconcile. The lines land in the account ready to match against sales, purchases and payments.

What the converter handles that a copy-paste won't

An AIB or Bank of Ireland statement often runs a payment's SEPA reference onto a second line. Pasted straight in, that overflow becomes a stray row and the euro columns slide out of step — which shows up in Surf as a reconciliation that won't balance. The converter joins each reference back to its payment, so the columns stay aligned and the import matches the statement.

It also reconciles the euro figures before you download — opening balance, plus credits, minus debits, has to reach the closing balance — so a line dropped between pages is caught before it becomes an unreconciled difference in Surf.

Getting the columns right

Surf's bank import wants a clean date, description and amount, and the converted CSV gives exactly that — one row per transaction — so the mapping is straightforward and Surf doesn't reject the file for a merged cell or a stray line. If you'd rather tidy the data in Excel first, to separate a mixed personal-and-business account for instance, you can, then import the cleaned CSV.

After the import

Once the lines are in, Surf reconciles the familiar way — each bank entry matched to an invoice, a purchase or a payment until the balance agrees with the statement. Two things make that go faster off the back of a clean conversion. The closing balance was already verified when the file was built, so a balance that won't agree points you at your matching rather than a dropped bank line. And because a converted period arrives whole, an accountant bringing a client's history into Surf can work through it as one continuous task instead of pausing to hunt for a month the feed never delivered. Across several clients, that turns an unpredictable chore into a job you can actually schedule.