From PDF to a workbook you can use
Most people who need a bank statement in Excel need it for something specific: categorising a year of spending, preparing figures for an accountant, reconciling business expenses, or showing income for a rental or loan application. All of those start with the same chore, getting every transaction out of a PDF and into cells that behave like numbers.
Upload the statement above and DocFig reads each transaction, checks it, and builds an XLSX file. Before you download, the rows appear in a table on this page so you can see what you are getting.
What is in the Excel file
The workbook has two sheets.
- Transactions holds one row per transaction with these columns: Date, Description, Money out, Money in, Amount, Balance and Check. Amount is signed, positive for money in and negative for money out, which is the easiest column to total. Money out and Money in are kept separate as well, for anyone who prefers the layout of the statement.
- Statement lists what was read from the statement itself: bank name, statement type, the last four digits of the account, currency, period, opening and closing balance, and the result of the checks.
Dates are stored as Excel date values rather than text, so sorting by date, filtering by month and formulas such as EOMONTH work immediately. Amounts are numbers with two decimals and no currency symbols mixed in. The header row is frozen and has filters switched on.
Rows that need checking are easy to find
A conversion is only useful if you can trust it. Every row is tested against the running balance printed on the statement, the opening and closing balance, and the text of its page. When a row fails, it is filled light yellow in the workbook and the reason is written in the Check column, for example that the running balance does not add up around that row. Filter the Check column to non-blank values and you have a short list to compare against the PDF.
On a statement that reconciles, the Check column is empty and the Statement sheet says the balances reconcile. That is a stronger statement than "the conversion looks fine": the arithmetic of the statement itself agrees with the rows.
Useful things to do next in Excel
- Totals by month. Insert a pivot table, put Date in rows grouped by month, and Amount in values.
- Spending by payee. Add a Category column, fill it for one row of each payee, then use SUMIF on Category and Amount.
- Prove it yourself. Opening balance plus SUM of the Amount column equals the closing balance on a bank statement. On a card statement, the previous balance minus that sum gives the new balance.
- Combine months. Every file uses the same columns in the same order, so later months can be pasted straight under earlier ones.
Which statements work
Current, checking, savings and business accounts, and credit card statements, from banks in any country. Separate debit and credit columns, single amount columns with DR or CR, decimal commas and newest-first ordering are all read correctly. Scanned statements are read with OCR; see scanned bank statement to Excel for tips. The free limit is 30 pages per file and 30 pages a day.
Your file is held in memory only, account numbers are masked before AI processing, and nothing is kept once the table reaches your browser. See how files are handled. Prefer a plain text file? Use the bank statement to CSV page instead.