Bank statements

How to import a Punjab National Bank statement into an expense tracker

Import a Punjab National Bank statement into an expense tracker, starting with a one-month test, and handle the March to April financial year change.

Editorial illustration for How to import a Punjab National Bank statement into an expense tracker

To import a Punjab National Bank statement into an expense tracker, start with a one-month test: download one recent month from your own login, upload it, review it and tally it with the closing balance. Only when that month matches should you bring in the other months. A small test costs ten minutes and saves you from repeating a long import.

Why start with one month?

Different accounts and different file types can read differently, and you will not know how yours reads until you try it. A single month reveals the date style, how debit and credit are shown and whether the file reads cleanly. If something is wrong, you fix one month rather than twelve. Look for the statement or e-statement section after logging in to Punjab National Bank yourself, choose the account and one month, and pick a format from those on offer.

What should the test month prove?

  • Dates are read as day and month, not swapped.
  • Debits and credits are in the right direction.
  • The row count looks right against the original.
  • The tally with the opening and closing balance works.

Say the opening balance is ₹12,500, credits ₹38,000 and debits ₹33,200. The closing balance should be ₹12,500 plus ₹38,000 minus ₹33,200, which is ₹17,300. If your imported month lands there, the layout reads properly for your account.

How do I handle March and April?

The Indian financial year runs from April to March. If you track by financial year, import April to March as twelve separate months so that no file straddles the boundary. A file that runs from 15 March to 15 April mixes two years, and your year-end totals will be wrong unless you split them. Download calendar months and the problem does not arise.

PlanFilesResult
Calendar monthsTwelveClean split between years
QuartersFourFine, but check the March to April edge
One long fileOneHardest to check and to redo

How do I import it in the tracker?

  1. Create an account, such as Punjab National Bank Savings, and select it.
  2. Upload the test month in SpendixAI and read the review screen.
  3. Save, open the import history and confirm the status.
  4. Upload the remaining months, oldest first, in one batch if you like.

Can I upload more than one file at a time?

Yes. Batch uploads are supported, which is handy once the test month has passed. Still, tally each month on its own. A batch of nine months that all look fine in the import history can hide one month with a missing page, and it is easier to find that when each month has its own tally written down. A simple note beside each month, with the opening balance, closing balance and a tick, is enough. If a file fails, the import history shows its status, and an Import failed notification tells you to look.

What about cash and small spending?

A bank statement does not show cash spending. If you withdraw ₹5,000 and spend it over a fortnight on vegetables, the milk bill and auto fares, the statement shows only the ₹5,000. Add the small items by hand, several at once if you like, in a cash account. Then the bank account still tallies with its statement and the cash account has its own story.

Treat the first import as a trial and write down what you learned: which format worked, how dates were read, and what needed fixing. The next months are then quick, and if you ever change the file type, you know which checks to repeat from the start.

Done-for-now checklist

  • One test month imported and tallied.
  • Remaining months uploaded oldest first.
  • Closing balance checked for each month.
  • Cash entered for at least the current month.
  • Originals saved in a folder by year.
SPENDIXAI JOURNAL

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

Explore your reports