Bank statements

Scanned bank statement to Excel: what works for gig workers

Why a scanned or photographed bank statement is hard to convert to Excel, how to get a digital copy instead, and how to check any result.

Editorial illustration for Scanned bank statement to Excel: what works for gig workers

A photo or scan of a bank statement is a picture, not data, so free converters often misread digits and merge columns. The reliable route is to ask your bank for a digital statement as a PDF, CSV or Excel file, and use the scan only as a last resort that you verify line by line. SpendixAI's import is described for PDF, CSV and Excel files, so a digital copy is the safer thing to bring.

Why do scanned statements convert badly?

A converter has to guess every character from pixels. Tilted pages, shadows from a phone camera, a faded printout and small fonts all raise the error rate. The mistakes are quiet ones: a 5 read as a 6, a comma read as a full stop, a debit and a credit in the wrong column. The sheet looks fine and the totals are off.

How do you get a digital copy instead?

  1. Check your net-banking or mobile app for a statement download for the period you need.
  2. If the app lets you choose a format, prefer CSV or Excel, then PDF.
  3. If you only hold paper, ask your branch or the bank's support team through the contact details printed on your own statement or card for an emailed copy.
  4. Never share your net-banking login, OTP or PIN with anyone who offers to fetch it for you.

Menus and wording differ by bank and change often, so follow what your own app shows rather than a fixed recipe.

Worked example: proving a scan is right

Say you had to use a scan for one month. The statement says opening balance ₹12,400, closing balance ₹21,150. You keyed in three platform payouts of ₹15,000, ₹12,500 and ₹11,000, so credits are 15,000 + 12,500 + 11,000 = ₹38,500. Debits you extracted add to ₹29,750. Test: 12,400 + 38,500 − 29,750 = ₹21,150. It matches the closing balance, so the extraction is probably complete. If it came to ₹21,550, you would hunt for a ₹400 difference, most likely a 4 misread as a 0 or a missed row.

LineAmount
Opening balance₹12,400
Credits (three payouts)₹38,500
Debits extracted₹29,750
Computed closing₹21,150
Statement closing₹21,150

What if the totals do not match?

  • Split the sheet into halves and check the running balance at the middle row.
  • Repeat on the half where it breaks until you find the row.
  • Look first at amounts containing 1, 7, 5, 6 or 8, which are easily confused.
  • Check that no wrapped line became a separate row.
  • Re-key a few suspicious rows by hand.

Does this matter more for gig workers?

Often, yes. A delivery or ride partner may have many small credits from platforms plus fuel, data and repair debits, so a single misread digit hides among hundreds of rows. Keep monthly files in one folder, named by month, and keep the platform's own earnings reports as a second check against what reached the account.

Once you have the file

In SpendixAI you pick the account first, upload the file, and review each row before saving, so a wrong row can be fixed or left out at that point. Possible duplicate imports are flagged if the same month goes in twice. It cannot promise that every layout will parse perfectly, so compare the imported total with your statement's closing balance before you move on.

A last check before you hand anything over

Whoever receives your numbers, whether your accountant or yourself next year, will trust them only if they reconcile. Keep the original statement beside the spreadsheet, note any rows you corrected by hand, and tell your CA that those figures come from your own working rather than from the bank's file.

SPENDIXAI JOURNAL

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

Explore your reports