1 · Company
Voucher import
Item Master
Bank Statement
2 · Excel file & what to import
Drop the Excel file here or click to choose
.xlsx with sheets “Sales” and/or “Purchase”
Choose a company and an Excel file, then press ①.
Preview
Missing in Tally
Tally data & GST registrations
Log
| Send | Status | Type | Voucher no. | Date | Party / Buyer | Place of supply | Mode | Taxable | GST | Total | Notes / problems |
|---|
Nothing checked yet.
| What | Name | Will be created as (press ② to review & edit everything before pushing) | Needed by |
|---|
GST tax ledgers are created with the duty head only — open them once in Tally to confirm. Items need HSN/GST checked once if the Excel has no HSN column.
Nothing fetched yet.
| Registration name in Tally | GSTIN | State | companies.json |
|---|
Item master import — stock items with GST / HSN / Cess
Drop the item master Excel here or click to choose
sheet “Stock Item” of the item master template
Choose the item master Excel, then press ①.
| Row | Item | Group | Unit | HSN/SAC | GST % | Taxability | Cess type | Cess % | Cess/unit | GST from | Problems |
|---|
Bank statement → Tally Receipt / Payment / Contra vouchers
Drop the bank statement here or click to choose
.xlsx · .xls · .csv · .pdf — single or separate Debit/Credit columns
Bank ledger in Tally
Suspense ledger
Matches every line with your Tally ledgers, past voucher narrations and the rules saved from earlier confirms. Lines it cannot recognise go to the suspense ledger.
Choose the statement and the bank ledger, then press ①.
| Post | Date | Bank description | Ref / Chq | Withdrawal | Deposit | Tally ledger (click to change) | Match | Why / status |
|---|