Getting started

Punjab National Bank statement to CSV: converting and cleaning it

Need a Punjab National Bank statement as CSV? Learn the general routes to get one, then clean dates, amounts and debit-credit columns so it imports cleanly.

Editorial illustration for Punjab National Bank statement to CSV: converting and cleaning it

Download it in a spreadsheet or CSV format if your bank offers that option for your account; otherwise, convert the PDF yourself to get a Punjab National Bank statement as CSV. Check your own net banking, mobile app or branch for the formats available, because options and menu names change and differ by account type.

Which routes can give you a CSV?

  1. Download in a spreadsheet or CSV format from your bank's digital channels, if it is listed for your account.
  2. Request a statement at the branch in the format you need and ask what formats they can provide.
  3. Open the PDF, select the table and paste it into a spreadsheet, then save as CSV.
  4. Use a PDF-to-Excel converter, keeping in mind that you would be uploading your statement to a third-party service.

Many trackers read PDF, CSV and Excel directly, so you may not need to convert at all. SpendixAI is one of them, though a statement with an odd layout may need the review screen or a spreadsheet version.

What usually goes wrong after conversion?

ProblemWhat you seeFix
Dates as textLeft-aligned like 05/11/2026, sorting is wrongConvert with a formula or Text to Columns
Amounts as textNumbers with commas will not add upStrip the commas and convert
Debit and credit in two columnsOne amount column is empty on each rowMerge into one signed column
Narration split over linesExtra rows with no dateJoin them to the row above
Header repeated on each pageStray header rows inside dataFilter and delete them

How do you fix dates and amounts in Excel?

Suppose a date reads 05/11/2026 as text in A2, day first. This formula builds a real date:

=DATE(VALUE(RIGHT(A2,4)), VALUE(MID(A2,4,2)), VALUE(LEFT(A2,2)))

Format the result as a date. If an amount such as 12,450.00 is text in D2, use:

=VALUE(SUBSTITUTE(D2,",",""))

If your statement has separate debit (column D) and credit (column E) columns, a single signed amount in F2 is =N(E2)-N(D2), where N treats blanks and text as zero. That makes credits positive and debits negative. Check your own statement first, since layouts vary.

Does the CSV need to be perfect before importing?

No. Aim for one header row, one transaction per row, real dates and numeric amounts. Perfect narration text is not required. Save the CSV as a plain comma-separated file, not a workbook, and keep the original PDF in a folder in case you need to compare.

Can you skip conversion entirely?

Often yes. If the tracker takes the PDF itself, upload it, read the review screen and compare totals. Convert only when a PDF will not read properly. You also avoid sending the statement to a converter you do not know.

A short example of cleaning one row

Say a pasted row has a date text of 07/11/2026 in A2, a debit of 1,250.00 in D2 and an empty credit in E2. The date formula returns 7 November 2026, the amount formula returns 1250, and =N(E2)-N(D2) returns -1250. Do the same for every row, copy the results as values into a new sheet with headings Date, Narration and Amount, then save that sheet as CSV. Keep the narration text as it is, because it carries the payee information you will later categorise.

Quick checklist

  • Use the bank's own CSV or Excel option when available.
  • Keep the original PDF unchanged.
  • Fix dates and amounts before anything else.
  • Reconcile totals with the closing balance.
  • Delete the working copies you no longer need.
SPENDIXAI JOURNAL

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

Explore your reports