Convert the statement here, then send the transactions straight into TallyPrime — mapped to your own ledgers, checked for duplicates, with no XML file to import by hand.
Version 4.5 · 27.9 MB · Windows 10 & 11 (64-bit) · Free with your account
There are two halves to getting a bank statement into your books. The website converts the PDF — it reads the statement, including scanned and password-protected ones, and turns it into clean rows of date, description, deposit, withdrawal and balance.
The connector is the second half: a small Windows app that carries that result into TallyPrime through Tally’s own connection on port 9000. There is no XML file to import by hand, nothing to re-type, and no copy-paste into a voucher template in Excel. You review the rows, the connector writes the vouchers.
It is not a replacement for the export. You can still download the same conversion as Excel or CSV, and if you prefer the file route, the bank statement to Tally XML converter still does exactly what it did. The connector simply removes the file from the middle of the job.
Nine steps from the PDF to a reconciled set of vouchers. Your part is the short one.
Upload the bank statement PDF — including a password-protected one — on the website or in the connector window. It comes back as clean rows: date, description, deposit, withdrawal, balance.
A spreadsheet-style grid inside the connector, where every field is editable: date, description, amount, voucher type and the Particulars (ledger). Untick any row you do not want sent.
The connector reads your real ledgers out of TallyPrime and suggests one per row from the narration — UPI, NEFT and IMPS transfers, bank charges, interest, ATM, card payments, cheques, rent, salary, EMI and taxes. Every suggestion can be overridden, and a new ledger or voucher type can be created in Tally from the grid itself.
Before anything is sent, the rows are compared against the vouchers already in TallyPrime and against the connector’s own record of what it has sent before. Re-sending the same statement, or a month that overlaps one you already did, adds nothing twice.
17 checks run before a single voucher is written: TallyPrime open, responding and free of a message box, the connection switched on, the right port, the company open and readable, dates inside the books, the bank ledger really a bank ledger, missing ledgers or voucher types, invisible characters, and more. Anything wrong is shown as a card with numbered steps, and many have a one-click fix.
Vouchers go in batches of 25 with a live progress count. Each batch is recorded before it is sent, so even a TallyPrime crash leaves an exact record of what landed.
The result names exactly how many vouchers were created, how many duplicates were skipped and which ledgers were created. The vouchers are in the Day Book immediately.
Set bank dates on the imported vouchers, in bulk, from the connector’s Bank reconciliation grid — instead of walking them one at a time inside Tally.
The same conversion can still be downloaded as Excel or CSV. The connector is an addition to the export, not a replacement for it.
| You | The connector |
|---|---|
| Upload the statement PDF | Reads it and returns clean, typed rows |
| Glance down the suggested ledgers | Reads your Tally ledgers and suggests one per row |
| Change anything that looks wrong | Keeps names identical to Tally, creates what is missing when you agree |
| Click Send to Tally | Runs 17 checks, skips duplicates, writes vouchers in batches of 25 |
| Check the result | Reports what was created, skipped and created as new ledgers |
| Select the rows to reconcile | Sets the bank dates in bulk |
Grouped by the part of the job they belong to, with why each one matters when you are the person doing the books.
The checks and the repair library live in the connector window, so a problem at the end of the day does not have to wait for a reply from us.
The conversion itself is the same engine the website uses, across every bank layout we support.
| Operating system | Windows 10 or Windows 11, 64-bit. Windows 7 and 8 are not supported. |
|---|---|
| TallyPrime version | TallyPrime 6.x and 7.x. Verified by us on TallyPrime 7.1. Tally.ERP 9 is not supported. |
| Tally connection | F1 → Settings → Connectivity → “TallyPrime acts as” = Both, Port = 9000. The connector can switch this on for you, and backs up the settings file first. |
| While sending | TallyPrime must be open with the company loaded. |
| Installation | Installs to your user folder. No administrator rights needed. It does not modify Tally’s data files. |
| Account | A Bank Statement Magic account. Conversions use your plan’s page allowance. |
| Add-ons | No Tally add-on (TDL) is required for anything. |
The TallyPrime setting, in one line:
TallyPrime: F1 → Settings → Connectivity → TallyPrime acts as = Both, Port = 9000Conversions draw on your plan’s page allowance — see plans and page limits, or check what you have left in your dashboard.
The installer is not code-signed yet, so Windows SmartScreen may show “Windows protected your PC”. Choose More info → Run anyway. You can check the SHA-256 below against the file you downloaded before you run it.
It installs for your Windows account only, so it never asks for administrator rights and does not touch anyone else’s setup on the machine.
Open the connector and sign in with your Bank Statement Magic account — email and password, or Google, the same as on the website.
Open TallyPrime, load the company, set the connectivity option below, then convert a statement and send it. If anything is not right, open Fix problems and click Run all checks.
SHA-256 of version 4.5 (27.9 MB):
e3efaa417bf8284d24d3b26a0f379848652cb3931572b42e7275cb1075dba8a4If anything is not right, open Fix problems and click Run all checks.
How we handle uploaded statements is set out in the privacy policy.
The connector itself is free to download and use with your Bank Statement Magic account. Converting statements uses your plan’s page allowance, the same as converting on the website — so the connector does not cost extra, it just gives the conversion somewhere to go.
The PDF is converted by the website, through the same pipeline as a conversion you run in your browser. The vouchers then travel from your PC straight to TallyPrime at 127.0.0.1 — that traffic never leaves your machine, and we never see your TallyPrime company.
TallyPrime 6.x and 7.x. We verify each release on TallyPrime 7.1, and it is used in the field on 6.x.
No. We have not tested the connector on Tally.ERP 9, so we do not claim support for it. Please use TallyPrime 6.x or 7.x.
No. It installs into your own user folder, so it works on a locked-down office machine where you cannot install ordinary software.
Yes. You can create a ledger or a voucher type in TallyPrime from the mapping grid, and the connector can auto-create ledgers that are missing — new ledgers under Suspense A/c and the bank under Bank Accounts. It always shows you the list before it creates anything.
No. Before sending, it checks the rows against the vouchers already in TallyPrime and against its own record of what it has sent before. Re-sending a statement, or a month that overlaps one you have already done, adds nothing twice.
Vouchers go in batches of 25 and each batch is recorded before it is sent, so there is an exact record of what landed. Fix problems can also check what an interrupted send actually put in, and the duplicate check means finishing the job will not double anything.
Yes. The Bank reconciliation grid lists every bank line in the company with its bank date, and you can set or clear bank dates one by one or in bulk on the rows you select. It writes Tally’s own BANKERSDATE field.
No — and this is Tally’s rule rather than a limit we chose. TallyPrime only accepts changes from outside to vouchers it issued an ID for, which means the ones the connector sent. Vouchers you typed in Tally are shown and labelled “Tally-only”, and you reconcile or edit those inside TallyPrime.
Yes. It works with whichever company is open in TallyPrime, and one of the pre-flight checks confirms the company is open and readable before it writes. To do a second company, switch company in Tally and send the next statement.
Yes. Send each statement to its own bank ledger, and filter the reconciliation grid by bank ledger to work through them one at a time.
Fix problems detects it and can move both TallyPrime and the connector to a free port in one click. The change to TallyPrime’s settings file is backed up first and can be undone from the same window.
The connector checks the published version when it starts and tells you when a newer one is out. Download the latest installer from this page and run it over your existing install — your settings and history stay put.
No. The installer is not code-signed yet, so SmartScreen warns about it the way it warns about any new unsigned program. Choose More info → Run anyway. If you want to be certain you have the file we published, check its SHA-256 against the one printed on this page.
Yes. Every conversion can still be downloaded as Excel or CSV, and your conversion history stays available for re-download. The connector is an addition to that, not a replacement.
Start with Fix problems inside the connector — it has 17 checks and a searchable library of 43 known problems with numbered steps, and it saves diagnostics to a folder on your PC. If that does not solve it, email support@bankstatementmagic.com and attach the diagnostics.
More about converting statements in general is on the main FAQ and the blog.
Free with your Bank Statement Magic account. Windows 10 and 11, no administrator rights, and TallyPrime stays in charge of your books.
Version 4.5 · 27.9 MB · Windows 10 & 11 (64-bit) · Free with your account
Conversions use your plan’s page allowance — see plans and page limits.