Bank of Baroda Statement to Tally Prime: Import Guide (2026)
Bank of Baroda Statement to Tally Prime: Import Guide (2026)
Download and import Bank of Baroda (BOB) statements to Tally Prime. Map transaction codes, configure columns, and reconcile bank ledgers. Step-by-step guide.
Who is this for: Bank Automation
Bank of Baroda (BOB) is a premier public sector bank in India, servicing a vast network of corporate enterprises, retail traders, and service providers. Handling the accounting books for a business using a Bank of Baroda account entails recording multiple UPI transactions, vendor payments, customer receipts, and monthly service fees.
Instead of manually keying in every payment and receipt voucher, importing these statement lines in bulk saves time and avoids transaction logging discrepancies. In this article, we cover how to download Bank of Baroda statements, map common transaction prefixes, and leverage automated review tools to sync ledger accounts directly to TallyPrime.
1. Download Statements from Baroda Connect Netbanking
To obtain statements for your accounting books, follow these steps:
- Log in to the Baroda Connect portal (BOB Internet Banking).
- Navigate to the Accounts section and select Account Statement.
- Choose the target account and specify the desired date range.
- Select the format. Choose PDF for official records or CSV/Excel for spreadsheet conversions.
- Click Download to save the file.
2. Decoding Bank of Baroda Transaction Code Formats
Bank of Baroda statements include unique abbreviation prefixes that indicate how the money was moved. Knowing these simplifies accounting entries:
| Prefix Code | Meaning | Voucher Type | Target Accounting Group |
|---|---|---|---|
| NEFT / RTGS | Electronic bank transfers | Payment / Receipt | Sundry Creditors / Debtors |
| IMPS / MMT | Immediate mobile payment transfers | Payment / Receipt | Sundry Creditors / Debtors |
| TRF | Internal ledger or sweep-in transfers | Contra | Bank Accounts / Fixed Deposits |
| GST / TDS | Direct statutory payments | Payment | Duties & Taxes |
3. Honesty Check: How TrulyInvoice Automates BOB Bank Data Entry
TrulyInvoice is designed to eliminate manual spreadsheet formatting, Excel column mappings, and date errors. It provides a secure, review-first desktop sync tool.
To maintain transparency, here is exactly how the tool handles bank statements:
- No Live Bank Connection: TrulyInvoice does **not** log into your Bank of Baroda accounts or access netbanking online feeds. It does not ask for or store login credentials. You must download the statement PDF manually from BOB and upload it to the tool.
- AI Column Parsing: TrulyInvoice parses the PDF statement and extracts columns (Date, Narration, Withdrawal, Deposit). It automatically merges multi-line descriptions.
- Ledger Suggestion System: Based on the narration, TrulyInvoice suggests accounting groups and ledger names (e.g. suggesting Bank Charges for monthly maintenance fees).
- Self-Serve Review: Review and adjust mappings in a grid. Correct ledger categories or batch-edit group parameters.
- Direct Sync: Sync the reviewed entries directly to TallyPrime via a local gateway port, creating voucher logs in seconds.
- Fast-Track Reconciliation: TrulyInvoice creates the voucher records, which means you do not have to type them. However, it does not replace Tally's built-in reconciliation checks. You must still run Tally's bank reconciliation tool to match voucher dates with actual clearing dates.
4. Summary
Whether you map columns manually in Excel or use TrulyInvoice's review-first engine to suggest ledgers and auto-sync transactions, standardizing Bank of Baroda statements is crucial to clean book audits. Reconcile entries inside TallyPrime to complete the reconciliation flow.
Chartered Accountant & Accounting Automation Specialist