Every exported workbook includes these columns — formatted and ready to use.
| Date | Description | Debit | Credit | Balance |
|---|---|---|---|---|
| Jan 15, 2024 | AMAZON.COM | 45.99 | — | 2,954.01 |
| Jan 16, 2024 | DIRECT DEPOSIT — PAYROLL | — | 3,200.00 | 6,154.01 |
| Jan 18, 2024 | STARBUCKS #4821 | 6.75 | — | 6,147.26 |
| Jan 20, 2024 | RENT PAYMENT — LANDLORD | 1,500.00 | — | 4,647.26 |
Upload any PDF bank statement — scanned or digital. Documentric sends it through AI-powered OCR to extract every transaction row.
Every transaction is identified automatically — date, description, debit, credit, and running balance. Review and edit the table inline before export.
Click export and download a formatted Excel workbook. Open it directly in Excel, Google Sheets, Apple Numbers, or LibreOffice.
Scroll through transactions with familiar spreadsheet tools. Filter by date, sort by amount, highlight anomalies.
Use Excel pivot tables to summarise spending by category, month, or payee across multiple statement periods.
Send a clean, formatted workbook to clients or colleagues. No accounting software access required on their end.
Copy or link the transaction data into existing Excel financial models, cash flow forecasts, or budget templates.
The export is a real .xlsx workbook with formatting, not a plain CSV renamed. Column headers, date cells, and numeric values are typed correctly.
Column headers are consistent and clearly labelled: Date, Description, Debit, Credit, Balance. No blank headers or merged cells to untangle.
Debit, credit, and balance columns are formatted as numbers, not text strings. Formulas and pivot tables work on them immediately without conversion.
Documentric calculates the running balance for every transaction row so you can verify the extracted data against the original statement instantly.
The exported .xlsx file opens natively in all major spreadsheet applications.
The Excel export produces a formatted .xlsx workbook with column headers, currency-formatted number cells, and a pre-calculated running balance column. The CSV export is a plain text file with no formatting. Use Excel when you want a workbook ready to open and analyse; use CSV when you need raw data for another system.
The exported .xlsx file includes formatted column headers (Date, Description, Debit, Credit, Balance), date cells formatted as dates, and numeric columns formatted as currency values. The running balance is calculated automatically so you can verify totals at a glance.
Yes. Upload the .xlsx file to Google Drive and it opens directly in Google Sheets. All column formatting, dates, and numeric values carry over without any conversion step needed.
Yes. Documentric extracts the closing balance from the statement and uses the debit and credit values to calculate the running balance for every transaction row. This lets you spot any discrepancy between the extracted data and the original statement at a glance.
Documentric gives you 50 free pages with no account required. Upload your PDF, review the extracted transactions, and download the .xlsx workbook — all free on your first 50 pages. No credit card needed.