Groups
7
Documented columns
58
Importable groups
3
Formats
CSV · Excel · Tally
Find a template
Search by group or by a column you're trying to fill — e.g. 'placeOfSupply' or 'GSTIN'.
Opening balances (cash, bank, UPI)
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.
label
Exactly as you call it internally. Re-importing the same name updates it instead of duplicating. · e.g. HDFC Current A/c
type
cash for the tin, bank for current/savings, upi for a VPA float, card for a credit card. · e.g. bank
openingBalance
Rupees in the account on the opening date. Use a negative number for a card you owe on. · e.g. 860000
branch
Branch that operates the account — used for branch-level books and GSTIN matching. · e.g. Delhi flagship
upiId
Only for upi accounts — powers Quick Collect links and QRs. · e.g. studio@hdfcbank
Ledger transactions (historical entries)
Every rupee that moved: client receipts, vendor payments, payouts, expenses. One row per voucher.
date
Voucher date. · e.g. 2026-04-12
direction
in = money received, out = money paid. · e.g. in
amount
Gross amount including GST. · e.g. 240000
mode
How the money actually moved. · e.g. Bank transfer
account
Must match an account name from the opening balances sheet. · e.g. HDFC Current A/c
source
What kind of voucher this is — drives P&L grouping. · e.g. Client payment
party
Client, vendor or staff name — builds the party ledger. · e.g. Aarti Sharma
partyType
Decides whether a balance reads as receivable, payable or advance. · e.g. client
reference
Invoice or bill number. · e.g. INV-1042
project
Shoot or project, for project profitability. · e.g. Aarti & Nikhil — Wedding
branch
Branch raising the invoice — picks the GSTIN. · e.g. Delhi flagship
department
Cost centre. · e.g. Production
memo
What the entry was for. · e.g. 60% milestone
gstRate
0, 5, 12, 18 or 28. Leave blank for non-GST. · e.g. 18
gstAmount
Leave blank and it is derived from the rate. · e.g. 36610
placeOfSupply
Two-digit state code of the client — decides CGST/SGST vs IGST. · e.g. 27
tdsRate
For payouts with tax deducted at source. · e.g. 10
tdsAmount
Leave blank and it is derived from the rate. · e.g. 4600
Contra transfers
Money moved between your own accounts — cash deposited, UPI swept to bank.
date
Transfer date. · e.g. 2026-07-20
fromAccountId
Account debited. · e.g. Cash in Hand
toAccountId
Account credited. · e.g. HDFC Current A/c
amount
Rupees moved. · e.g. 50000
memo
Why the money was moved. · e.g. Weekly cash deposit
Credit & debit notes
Discounts, write-offs and extra charges raised against a client or vendor.
date
Note date. · e.g. 2026-07-11
kind
credit reduces what they owe, debit increases it. · e.g. credit
party
Client or vendor name. · e.g. Simran Bedi
partyType
Which ledger the note belongs to. · e.g. client
amount
Value of the note. · e.g. 5000
reason
Why it was raised. · e.g. Album page count reduced
reference
Linked invoice. · e.g. INV-1044
Staff advances & petty cash
Floats handed to the team, and how much has come back.
date
Date issued. · e.g. 2026-07-24
staff
Who holds the float. · e.g. Kabir Kohli
amount
Rupees handed over. · e.g. 12000
purpose
What it is for. · e.g. Jaipur shoot travel float
accountId
Account the cash left. · e.g. Cash in Hand
settledAmount
How much has been accounted for. · e.g. 8400
status
Open until fully settled. · e.g. Open
Quick Collect requests
UPI collection links and QRs sent to clients, and whether they landed.
createdAt
When the link was created. · e.g. 2026-07-28T09:12:00.000Z
party
Who was asked to pay. · e.g. Simran Bedi
invoice
Invoice or milestone reference. · e.g. INV-1044
amount
Amount requested. · e.g. 120000
accountId
Account the money lands in. · e.g. Studio UPI — Naman
status
Collected entries are already in the ledger. · e.g. Awaiting
upiUri
The generated upi:// link behind the QR. · e.g. upi://pay?pa=studio@hdfcbank&am=120000
GST registrations (multi-GSTIN)
One row per state you're registered in. Invoices raised by a branch automatically carry that branch's GSTIN.
branch
Branch that bills under this registration. · e.g. Delhi flagship
gstin
15-character GSTIN. The first two digits set the state. · e.g. 07AABCK1234M1Z5
legalName
Name as registered on the GST portal. · e.g. Kohli Studios Pvt Ltd
tradeName
Name printed on invoices, if different. · e.g. Kohli Studios
address
Principal place of business for this state. · e.g. 212 Hauz Khas Village, New Delhi 110016
placeOfSupplyDefault
Two-digit state code used when the client's state is unknown. · e.g. 07
isDefault
TRUE for the registration used when no branch is set. · e.g. TRUE
active
FALSE to retire a surrendered registration. · e.g. TRUE
stateCode
Derived from the GSTIN — shown for reference. · e.g. 07 Delhi
Tally day-book
Export a day book from Tally as XML and drop it straight into Import & export — this sample shows the shape the importer reads.
Each VOUCHER needs a date, a narration and its ledger entries; receipts become money in, payments become money out.