Convert a Allica statement to checked Excel

Allica isn't aimed at startups or side hustles — it's built for established small and medium businesses, the ones with employees, suppliers and a finance function that takes reconciliation seriously. For that kind of business a statement isn't a quick glance; it's a document that has to tie out against the ledger, and that only works once it's rows.

What's on an Allica statement

An Allica business account statement lists activity with a date, the description, money out, money in and a running balance. A couple of things matter for an established business:

• Rewards and cashback. Allica's business rewards account can pay cashback on spending, and that lands as its own line — kept separate so it isn't mistaken for trading income.
• Savings alongside the current account. Many Allica customers hold a savings or notice account too; if a statement covers more than one, each keeps its own balance rather than being merged into a single figure.

The description carries the payee and payment type, and a longer one wraps onto a second line. A plain PDF export reads that overflow as its own row; the converter joins it back so each payment is one clean transaction.

Made to agree with the ledger

An established business keeps a proper set of books, and the bank statement's job at month-end is to agree with them line for line. That's a stricter test than a sole trader glancing at an app — a bookkeeper is matching the statement against invoices raised, bills paid and payroll run, and a single misread line means an hour hunting the difference. Converting the Allica statement to rows is what makes that match quick: real numbers you can sort, filter and tick off against the ledger, with the running balance already checked so you know the statement side is sound before you start.

Where to download your Allica statement

1. Allica online banking: log in at allica.bank, choose the account, open Statements, select the period and download the PDF.
2. Allica app: tap the account, go to Statements, pick a statement and save the PDF.

A statement downloaded this way is a digital PDF with selectable text, so the conversion is exact. If you only have a scan or a photo, the converter reads it with OCR — that just takes a little longer.

Getting it into your books

• Excel or Google Sheets — one row per transaction with real numbers, ready to total and filter.
• Xero, QuickBooks or Sage — an import-ready file so the lines land as bank entries to reconcile.
• Zoho and others — the same clean data in each one's format.

Every figure is reconciled before download: opening balance, plus money in, minus money out, has to equal the closing balance. For a business whose statement has to agree with the ledger, that check is what confirms the month is complete before it's reconciled.

Common snags with Allica statements

• Cashback on its own line. Rewards paid on spending stay separate from your trading income.
• Current and savings accounts. If a statement covers more than one, each keeps its own balance.
• Wrapped descriptions. A long payee on a second line is joined back to its transaction.