Accounts on file
3
Ledger entries
6
Import batches
0
GST registrations
3
Import opening balances & history
Start with opening balances, then load the year's vouchers. Tally day-book XML is read directly; CSV and Excel-saved CSV follow the sample layout.
Pick a target, then choose a CSV, Excel-saved CSV or Tally XML file to preview it before anything is written.
Column dictionary
Every column ledger transactions (historical entries) accepts, with format and an example.
| Column | Meaning | Required | Accepts | Example |
|---|---|---|---|---|
| date | Voucher date. | Required | YYYY-MM-DD | 2026-04-12 |
| direction | in = money received, out = money paid. | Required | in · out | in |
| amount | Gross amount including GST. | Required | number | 240000 |
| mode | How the money actually moved. | Required | Cash · UPI · Bank transfer · Card · Cheque · Other | Bank transfer |
| account | Must match an account name from the opening balances sheet. | Required | text | HDFC Current A/c |
| source | What kind of voucher this is — drives P&L grouping. | Required | Client payment · Vendor bill · Freelancer payout · Payroll · Expense · Contra · Staff advance · Credit note · Debit note · Other | Client payment |
| party | Client, vendor or staff name — builds the party ledger. | Optional | text | Aarti Sharma |
| partyType | Decides whether a balance reads as receivable, payable or advance. | Optional | client · vendor · staff | client |
| reference | Invoice or bill number. | Optional | text | INV-1042 |
| project | Shoot or project, for project profitability. | Optional | text | Aarti & Nikhil — Wedding |
| branch | Branch raising the invoice — picks the GSTIN. | Optional | text | Delhi flagship |
| department | Cost centre. | Optional | text | Production |
| memo | What the entry was for. | Required | text | 60% milestone |
| gstRate | 0, 5, 12, 18 or 28. Leave blank for non-GST. | Optional | number | 18 |
| gstAmount | Leave blank and it is derived from the rate. | Optional | number | 36610 |
| placeOfSupply | Two-digit state code of the client — decides CGST/SGST vs IGST. | Optional | text | 27 |
| tdsRate | For payouts with tax deducted at source. | Optional | number | 10 |
| tdsAmount | Leave blank and it is derived from the rate. | Optional | number | 4600 |
Export any group
Full columns, live data, plus a column dictionary sheet inside every Excel file.
Opening balances (cash, bank, UPI)
3 rows · 5 columns · Where the studio's money sat on day one of the year you're migrating. Import this first — historical entries then run on top of it.
Ledger transactions (historical entries)
6 rows · 18 columns · Every rupee that moved: client receipts, vendor payments, payouts, expenses. One row per voucher.
Contra transfers
0 rows · 5 columns · Money moved between your own accounts — cash deposited, UPI swept to bank.
Credit & debit notes
0 rows · 7 columns · Discounts, write-offs and extra charges raised against a client or vendor.
Staff advances & petty cash
1 rows · 7 columns · Floats handed to the team, and how much has come back.
Quick Collect requests
0 rows · 7 columns · UPI collection links and QRs sent to clients, and whether they landed.
GST registrations (multi-GSTIN)
3 rows · 9 columns · One row per state you're registered in. Invoices raised by a branch automatically carry that branch's GSTIN.
Import history
Every batch can be rolled back while you're still checking the numbers.
Nothing imported yet — your ledger is all hand-entered.