Statement of Account Excel Template — Standard Format
A standard statement of account in Excel has six columns. When you convert a SOA PDF using our tool, the output matches this exact format:
Date
Reference
Description
Debit
Credit
Balance
01 May 26
INV-2847
Invoice — Consulting services
1,200.00
1,200.00
08 May 26
PMT-1093
Payment received — Bank transfer
1,200.00
0.00
15 May 26
INV-2901
Invoice — Monthly retainer
850.00
850.00
28 May 26
CN-0047
Credit note — Overcharge adjustment
50.00
800.00
What Is a Statement of Account?
A statement of account (SOA) is a document that summarises all financial transactions between two parties over a specified period. There are two main types:
| Type | Issued by | Shows | Used for |
|---|
| Bank statement | Your bank | Deposits, withdrawals, charges, balance | Reconciliation, tax, visa, mortgage |
| Supplier SOA | Your supplier/vendor | Invoices raised, payments received, balance due | Accounts payable reconciliation |
| Customer SOA | You (sent to customer) | Invoices sent, payments received, amount outstanding | Accounts receivable, debt collection |
| Credit card statement | Credit card issuer | Purchases, payments, interest, credit limit | Expense tracking, reconciliation |
How to Convert a Statement of Account PDF to Excel
- Get the PDF — download from your bank's portal, ask your supplier to send it, or export from your accounting software.
- Upload to bankstatementengine.com — our extractor automatically finds the transaction table in any statement of account format.
- Download Excel — clean columns: Date, Reference, Description, Debit, Credit, Balance. Dates formatted as Excel date values, amounts as numbers.
- Use in Excel — add formulas, pivot tables, import into accounting software, or reconcile against your own records.
Reconciliation tip: Once you have your supplier SOA in Excel, paste your own accounts payable ledger next to it. Use VLOOKUP or MATCH to find invoices on both sides and highlight any discrepancies — this makes supplier reconciliation 10x faster than doing it manually from PDFs.
Who Uses Statement of Account Excel Conversion?
- Accounts payable teams — reconcile supplier statements against purchase ledger
- Accountants — verify client bank statements for tax and audit purposes
- Finance controllers — monthly bank reconciliation across multiple accounts
- Small business owners — track money in and money out from a single bank account
- Freelancers — annual income summary from bank SOA for tax self-assessment
- Loan applicants — present bank SOA data in Excel to brokers or lenders
Frequently Asked Questions
What is a statement of account template in Excel?
A statement of account Excel template is a spreadsheet with pre-formatted columns: Date, Reference, Description, Debit, Credit, and Balance. The Balance column uses a running total formula. You can populate it manually or auto-populate it by converting your SOA PDF to Excel using bankstatementengine.com — the output matches this format exactly.
How is a statement of account different from an invoice?
An invoice is a single document requesting payment for one transaction. A statement of account is a summary of all invoices, credit notes, and payments over a period, showing the running balance owed. Suppliers send statements of account monthly as a reminder of all outstanding invoices.
Can I convert a credit card statement to Excel using this tool?
Yes. Credit card statements are a type of statement of account and our converter handles them fully. Upload your credit card statement PDF and get a clean Excel file with Date, Description, Debit (charges), Credit (payments/refunds), and Balance columns. See our dedicated
credit card statement to Excel page for more details.
Convert Your Statement of Account PDF to Excel Now
Free · Instant · Bank & supplier statements · No signup required
Convert SOA to Excel Free →
Related: Bank Statement to Excel · Credit Card Statement to Excel · Bank Statement Analyser · Bank Reconciliation