Bank Guide

PNB Bank Statement to Tally: Direct Import Guide

Import Punjab National Bank (PNB) Excel statement to Tally using Synergy Automation. Direct posting, no XML needed.

How to Download PNB Statement as Excel

Where to find it: PNB Net Banking → Account Statement → Download (Excel/XLS)

File format: PNB exports via PNB ONE or internet banking. Columns typically: Date, Particulars, Cheque No., Debit, Credit, Balance.

Step-by-Step: PNB Statement to Tally

  1. Download your PNB statement
    Go to PNB Net Banking → Account Statement → Download (Excel/XLS). Select your date range and download as Excel (.xlsx or .xls).
  2. Open Synergy Automation
    Make sure Tally is open with the correct company. Make sure the Synergy Connector is running on the same PC.
  3. Upload the Excel file
    Drag and drop your PNB Excel file into Synergy Automation. The system auto-detects the format. You will see all transactions parsed and listed.
  4. Review every entry
    Check narrations, amounts, dates. Assign Tally ledger accounts. Skip any entries you do not want in Tally.
  5. Post to Tally
    Click Post. Entries appear instantly in your open Tally company as bank payment and receipt vouchers. No XML, no file, no import dialog.

PNB-Specific Notes

  • PNB older accounts may have XLS format (not XLSX) — both work with Synergy Automation
  • Government payment entries (tax, challans) appear with "GOV" or "CMP" prefix in narrations
  • PNB One app statement format is identical to web banking download

Common Ledger Assignments for PNB Transactions

Narration ContainsSuggested Tally Ledger
GOVTax Paid / Government Dues
UPIParty or UPI Expenses
INTBank Interest Received
CHGBank Charges

Use these as a reference when assigning ledgers in the review table before posting to Tally.

Frequently Asked Questions

Q: Does Synergy Automation work with PNB statement format?

Yes. Synergy Automation automatically detects the PNB Excel statement format and parses columns correctly. No manual column mapping needed.

Q: Do I need to convert PNB statement to XML before importing to Tally?

No. Synergy Automation posts entries directly from Excel to Tally — no XML file is created or needed. This is faster and simpler than traditional XML import methods.

Q: Is this free for PNB statements?

Yes. Synergy Automation is free to use. No limits on banks, entries, or companies.

Try with Your PNB Statement — Free

Upload your PNB Excel statement. Review entries. Post directly to Tally Prime or ERP 9.

Get Free Access