How to Import PDF Data into Tally

How to Import PDF Data into Tally

Tally is where the data needs to end up; a PDF invoice or bank statement is where it usually starts. The gap in between — manually reading a PDF and typing what you see into Tally — is exactly what several AllPDFMagic tools export directly around, and this guide pulls those together into one practical workflow.

The Two Common Starting Points

From an Invoice PDF

AllPDFMagic's Invoice Extractor pulls vendor details, invoice number, dates, GST breakdown (CGST/SGST/IGST detected separately), and line items from an invoice PDF, and can export in a format ready for accounting import. See the full invoice data extraction guide for the complete field list and export options.

From a Bank Statement PDF

AllPDFMagic's bank statement converter extracts every transaction — date, narration, debit, credit, balance — from a statement PDF and exports a Tally-ready CSV with columns mapped to what Tally's import expects. See the full bank statement guide for details on handling different banks and scanned statements.

Step-by-Step: Bank Statement to Tally

1. Upload the bank statement PDF at the bank statement converter.
2. Export as the Tally-ready CSV format (Date, Narration, Debit, Credit columns).
3. In Tally: Gateway of Tally → Import Data → Vouchers (or your version's equivalent import path), and select the exported file.
4. Review the imported vouchers before posting — always spot-check a sample against the original statement, since even accurate extraction is worth a sanity check before it affects your books.

Step-by-Step: Invoice to Tally

1. Upload the invoice PDF at the Invoice Extractor.
2. Review the extracted fields — vendor GSTIN, invoice number, tax breakdown, line items — and the confidence score for each.
3. Export the structured data and map it into a purchase voucher in Tally, either manually for a handful of invoices or via batch export for volume.

Why This Matters for GST Reconciliation Specifically

Getting your purchase register into a clean, structured form is also the first step toward GSTR-2B reconciliation — matching what you've booked in Tally against what your vendors have actually filed. If you're doing this monthly, the free n8n reconciliation template automates the comparison itself once both sides are in structured form.

Batch Processing for Multiple Clients

CA firms processing statements or invoices for multiple clients each month can use batch processing on the Team plan (₹999/month) — upload a client's full set of documents at once rather than repeating the process file by file.

FAQs

Does the export work with every version of Tally? The CSV format follows Tally's standard import column structure (Date, Narration, Debit, Credit for bank data). Very old Tally versions with non-standard import requirements may need column adjustments — check your version's import documentation if the standard format doesn't map directly.

Should I trust the import without checking it first? No — always review a sample of imported vouchers against the source document before relying on them, the same way you'd review any data entry, whether done by a person or a tool.

Can I batch-process statements for multiple clients at once? Yes, on the Team plan and above — this is specifically what batch bank-statement processing is for, aimed at CA firms handling several client accounts.

Does this work for GST invoices specifically, not just generic ones? Yes — the invoice extractor detects CGST, SGST, and IGST separately rather than a single generic tax field, which matters for correctly posting GST invoices in Tally.