Statement of Account Template — Excel & PDF to Excel

A statement of account (SOA) Excel template is a spreadsheet with pre-defined columns — Date, Description/Narration, Debit, Credit, and Running Balance — used to track all transactions for a specific account over a period. It can be used for bank accounts, customer accounts, or supplier accounts.

Upload the SOA PDF to bankstatementengine.com. The converter extracts all transactions and outputs a structured Excel file with Date, Description, Debit, Credit, and Balance columns. Works with bank SOAs and supplier/vendor SOAs. Free, no signup required.

A bank statement is issued by your bank and shows all transactions on your bank account. A statement of account (SOA) can be issued by any party — a supplier, customer, or service provider — and shows the outstanding balance, invoices, payments, and credits between two parties. Both share the same structure: opening balance, transactions, closing balance.

Yes. The SOA Excel template works for both bank account reconciliation and supplier/customer account reconciliation. The column structure (Date, Reference, Debit, Credit, Balance) is standard across both types. Use Excel's VLOOKUP or XLOOKUP to match converted SOA data against your internal records.

The standard columns are: Date, Invoice/Reference Number, Description/Narration, Debit (amount owed / charges), Credit (payment made), and Running Balance. Some templates add a Status column (Paid / Pending) and an Ageing bucket column (0–30 days, 31–60 days, 61–90 days, 90+ days) for accounts receivable tracking.