Sections10
Reading time10 min
EvidenceDocument workflow

Answer in 30 seconds

Export reviewed invoice rows to Excel or configure Tally voucher XML in Dynamite Docs. Supply company ledgers, test imports, and reconcile totals.

Dynamite Docs logoDynamite Docs
The handoff
REVIEWED INVOICE DATA: Columns prepared for importUpload your invoice batch. Review with confidence scores. Map into your accounting software. Illustrative example, not extracted customer data.FROM SOURCE FILE TO A RESULT YOU CAN USEREVIEWEDINVOICE…Review workspaceColumnspreparedfor import1Upload yourinvoice batch2Review withconfidence scores3Map into youraccountingsoftware
  1. 01Upload your invoice batch
  2. 02Review with confidence scores
  3. 03Map into your accounting software
Confirm voucher types Illustrative example.

TallyPrime ledger mapping and import checks

  • Supplier layouts change, so the workbook needs stable source headers before a reusable mapping can work.
  • Party ledgers, voucher types, stock items, units, and tax ledgers come from the TallyPrime company, not from OCR.
  • Document fields and item rows may need separate sheets or multiple mapped rows for one voucher.
  • A technically successful import can still be wrong if signs, masters, dates, or tax ledgers are mapped incorrectly.

How to prepare standardized rows for accounting import

01

Upload your invoice batch

Add GST invoices as digital PDFs, scans or photos. The extractor proposes fields from each document and keeps the source available for side-by-side review.

02

Review with confidence scores

Check any flagged fields, such as vendor GSTINs or tax breakdowns, to verify numbers before exporting.

03

Export the source workbook

Choose Excel for a TallyPrime mapping template, or open the Tally export dialog to configure Sales/Purchase XML with your company and existing ledgers. Preview and test the resulting file. CSV, JSON and Google Sheets remain available for other handoffs.

04

Map into your accounting software

Download the reviewed file, add company-specific ledger or voucher values, and map its columns into the import template required by your accounting system. Test the mapping with a small batch before a full import.

Document types this workflow handles

GST tax invoicessales and purchase invoices with tax splits
Credit & debit notesadjustments exported with distinct document types
Purchase billsvendor bills for goods and services
Sales billsoutward customer invoices

What appears in the exported rows

Dynamite Docs logoDynamite Docs
Inside the output
REVIEWED INVOICE DATA: Columns prepared for importSource row key: INV/24-25/0144 · line 01. Document type: Tax invoice. Mapping status: Party ledger review required. Illustrative example, not extracted customer data.Extracted fieldsDOCUMENT SCHEMAsource_row_keyINV/24-25/0144 · line 01document_typeTax invoicemapping_statusParty ledger review requiredColumns prepared for importDESTINATION FIELDSSource row keyMap to your destination schemaDocument typeMap to your destination schemaMapping statusMap to your destination schemaIllustrative mapping. Confirm the field names accepted by your destination.
Source row key
INV/24-25/0144 · line 01
Document type
Tax invoice
Mapping status
Party ledger review required
Confirm voucher types Illustrative example.

Exports include reviewed invoice fields as clean, standardized columns. A typical extraction provides:

Source row keyINV/24-25/0144 · line 01
Document typeTax invoice
GSTIN (party)27AABCS1429B1ZP
Invoice numberINV/24-25/0144
Invoice date2026-08-02
Place of supplyMaharashtra (27)
HSN / SAC code4820
Taxable value₹24,000.00
CGST amount₹2,160.00
SGST / IGST amount₹2,160.00 / ₹33,480.00
Invoice total (incl. tax)₹28,320.00
Mapping statusParty ledger review required

Standardized columns for a controlled accounting import

Dynamite Docs logoDynamite Docs
The review
REVIEWED INVOICE DATA: Columns prepared for importCheck required columns. Confirm voucher types. Test a small import. Illustrative example, not extracted customer data.SOURCE DOCUMENTREVIEWED INVOICEDATASource row keyINV/24-25/0144 · line 01Document typeTax invoiceMapping statusParty ledger review…Review before exportSource row keyINV/24-25/0144 · line01Compare with the source on the leftAccept after reviewConfirm voucher typesOriginal stays…
Source row key
INV/24-25/0144 · line 01
Document type
Tax invoice
Mapping status
Party ledger review required
Confirm voucher types Illustrative example.

A stable export schema separates document capture from accounting configuration. The extracted invoice number, date, GSTIN, HSN or SAC, taxable value and tax amounts stay in predictable columns even when supplier layouts change. TallyPrime supports mapping Excel columns to company fields (opens in a new tab), but the required masters and import configuration still belong to the TallyPrime company. Keeping that translation outside extraction makes exceptions easier to see and mapping changes easier to audit.

Treat the export as a staging file, not as a posting-ready truth source. Review low-confidence fields against the invoice, confirm that line totals reconcile to the taxable value, and check that the tax components add up to the document total. Look for duplicate invoice references within the same supplier and financial period. If a source uses an unfamiliar item description or party spelling, resolve it to an approved master value in a separate mapping column rather than overwriting the captured source text.

Before a large import, use a small pilot containing a normal invoice, an interstate transaction, an adjustment document and at least one multi-line bill. Import it into a test company or controlled workflow, inspect the resulting vouchers, then lock the accepted header order and mapping version. Record who reviewed the source rows and who approved the import. This simple checkpoint makes rework much easier to trace than editing vouchers after a full batch has been posted.

Excel and CSV exports also work as review schedules. You can filter by supplier, GSTIN, document type or exception status; compare the batch total with the invoice register; and retain the reviewed sheet with the accounting period. JSON is useful when an internal script or integration needs explicit field names and predictable value types. Whichever format you choose, preserve the original documents and the reviewed export together so a later query can be traced back to its source.

Reliable data exports with complete user control

Consistent headers reduce repeated cleanup, but they do not decide which ledger, voucher type or tax treatment is correct for your company. That judgment stays with the reviewer and the accounting system mapping.

Digital PDFs may contain usable embedded text, while scans and photos require visual extraction. Both can contain ambiguous values, broken tables or missing labels, so both should pass through the same review controls.

Reviewed rows can be exported to Excel, CSV or JSON, or pushed to Google Sheets when that connection is enabled. Every signed-in tier can connect a provider key. Free and Starter own-key runs use their monthly PE allowance; Pro and Scale own-key runs do not consume PE.

Paid invoice intake · PRO and Scale

Stop downloading invoices from email.

Forward invoice attachments to your private Dynamite Docs address. They are stored in your account, extracted automatically, and placed in the dashboard for review and export.

  1. 01Invoice arrives
  2. 02Forward attachment
  3. 03Extract and review
  4. 04Export to your workflow
Automate invoice intakeIncluded from $59/month. Storage and processing limits apply.

Questions, answered

Extraction guides

Related document workflows

From the blog

Test a reviewed Tally export

Export reviewed Excel rows or configure a Sales/Purchase XML file using existing company ledgers. Import one file in a test company and reconcile the accepted voucher before preparing a full period.

Can we save optional cookies?

Essential cookies keep you signed in. With your permission, optional analytics cookies and masked session replays help us understand usage and diagnose errors. Privacy policy. Change your choice anytime in Cookie settings.