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
- 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). - Open Synergy Automation
Make sure Tally is open with the correct company. Make sure the Synergy Connector is running on the same PC. - 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. - Review every entry
Check narrations, amounts, dates. Assign Tally ledger accounts. Skip any entries you do not want in Tally. - 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 Contains | Suggested Tally Ledger |
|---|---|
GOV | Tax Paid / Government Dues |
UPI | Party or UPI Expenses |
INT | Bank Interest Received |
CHG | Bank 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.