Getting started

Expense tracker with PDF import: what works, what breaks, how to check

How PDF statement import in an expense tracker works, why some PDFs read badly, and a simple check to confirm every row landed correctly.

Editorial illustration for Expense tracker with PDF import: what works, what breaks, how to check

PDF import lets an expense tracker read your bank or card statement file and propose transactions, so you review instead of typing. It works best on clean, text-based PDFs and worst on scans or oddly laid-out tables. Always compare totals after import, because a PDF is a picture of a page, not a neat table.

Why are PDFs harder than CSV?

A CSV is rows and columns. A PDF is text placed at positions on a page, with headers, footers, page breaks and sometimes wrapped lines. A narration that runs onto two lines can look like two rows. A running balance column can be mistaken for an amount. That is why no tool can honestly promise that every layout will parse perfectly.

  • Multi-page tables where headers repeat on each page.
  • Wrapped narrations spanning two lines.
  • Debit, credit and balance columns that sit close together.
  • Scanned or photographed statements instead of downloaded ones.
  • Password-protected files that must be opened first by you.

How do you get a better PDF in the first place?

  1. Download the statement from your own net-banking or card app, instead of photographing a paper copy.
  2. Check whether the same period is offered as CSV or Excel; use that if the PDF reads badly.
  3. If the file is protected, open it yourself with its own key and save an unprotected copy only if you are comfortable doing so on your own device.
  4. Import one month at a time.

What is the check after import?

CheckHowWhy
Row countCount debit lines on the statement against the toolSpots dropped or split rows
Total debitsAdd in the tool, compare with the statement totalCatches amount misreads
Total creditsSameCatches sign errors
First and last rowCompare dates and amountsCatches range trimming
Balance sanityOpening plus credits minus debits equals closingFinal proof

Say the statement shows opening balance ₹25,400, credits ₹60,000, debits ₹47,250 and closing balance ₹38,150. The check is ₹25,400 + ₹60,000 - ₹47,250 = ₹38,150, which matches. If your imported totals fail this test, a row is wrong, and the test tells you whether it is on the debit or credit side.

What does SpendixAI do with PDFs?

SpendixAI accepts bank and card statements as PDF, CSV or Excel. You pick the account before importing, review rows before saving, and can upload in batches, with an import history showing status and an Import failed notification if a file fails. Possible duplicate imports are flagged. Optional features such as reading an unfamiliar statement layout do process the uploaded document, so read the AI and privacy settings before turning them on.

What about statements with several pages and many accounts?

Import each account's statement separately and label it before loading, so rows are never mixed. For a long statement, check the page boundaries: the last row of one page and the first row of the next are where splits and duplicates tend to appear. If the tool shows an import history, note the file name against the month, so you do not upload the same period twice. Keep the original PDFs in a folder after import, as your evidence if a row looks odd later.

Be realistic about corrections. After a PDF import, expect to fix a few rows: a merchant name cut short, a category guessed wrongly, an amount sitting in the wrong column. Fixing ten rows by hand is still far quicker than typing three hundred, and the corrections are worth making carefully because a good tool uses them for next month.

If a PDF fails or reads wrongly

  • Try the CSV or Excel version of the same statement.
  • Import a shorter date range.
  • Fix the few wrong rows by hand rather than re-importing everything.
  • Never delete the original file until the totals tie out.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports