Bank statement to Tally vouchers
“turn the hdfc bank statement into tally vouchers from the tally rules sheet: payment for withdrawals, receipt for deposits; match only same-direction rules by narration text, first one wins, status Agrees or Needs a ledger”
Turn the HDFC Bank statement into tally vouchers from the Tally voucher rules: payment for withdrawals, receipt for deposits; match only same-direction rules by narration text, first one wins, status Agrees or Needs a ledger.
What the agent built
4 steps, each one an ordinary Mammoth step you can open and change.
- FileHDFC Bank statementCSV export · 35 rows
- FileTally voucher rulesCSV export · 23 rows
- StepSet voucher directionStep 1
- StepNumber rule priorityStep 2
- JoinBring in same-direction rules35 of 35 paired
- StepMake Tally vouchersStep 4
- ResultHDFC Tally Vouchers35 rows · 5 flagged
- ScheduleRuns when you sayProposed
On the sample files, every step runs and the result has 35 rows.
- Download HDFC Bank statement sample (35 rows)HDFC Bank NetBanking: Accounts > Statements > Export > CSV
- Download Tally voucher rules sample (23 rows)Tally: Company > Masters > Voucher Type/Import Rules > Export to Spreadsheet
What you get back
The result of that run, the rows to look at first.
| Date | Narration | Voucher type | Amount | Ledger | Status |
|---|---|---|---|---|---|
| 2026-10-29 | UPI/236541780918/PINE NUTS WHOLESALE | Payment | 18,960 | · | Needs a ledger |
| 2026-10-31 | CHQ 000216 LATE FEE FOR OVERDRAFT | Payment | 1,250 | · | Needs a ledger |
| 2026-10-03 | ATM WDL 24X7 MIDDLETON ST BRANCH | Payment | 20,000 | · | Needs a ledger |
| 2026-10-31 | UPI/236541780919/LOCAL TAXI | Payment | 760 | · | Needs a ledger |
| 2026-10-01 | UPI/236541780912/OM CAFE MUMBAI | Payment | 1,840 | · | Needs a ledger |
| 2026-10-20 | RTGS/RCPT/CEDAR FOODS TRADING CO OCT SUPPLY | Receipt | 71,000 | Cedar Foods Trading Co | Agrees |
| 2026-10-27 | CARD SWIPE 4111 AMAZON AWS INDIA PRIME | Payment | 2,490 | Amazon India | Agrees |
| 2026-10-15 | IMPS/104523678902/MEGHA PACKERS | Payment | 16,800 | Megha Packers | Agrees |
| 2026-10-25 | NEFT/RCPT/SAFFRON DISTRIBUTORS REFUND | Receipt | 9,600 | Refunds received | Agrees |
| 2026-10-21 | UPI/236541780916/ORBIT CABS | Payment | 2,460 | Travel Expense | Agrees |
| 2026-10-31 | IMPS/104523678904/MEGHA PACKERS | Payment | 17,420 | Megha Packers | Agrees |
| 2026-10-30 | RTGS/RCPT/ALPHA RETAIL INDIA PVT LTD OCT CLOSE | Receipt | 154,000 | Alpha Retail India Pvt Ltd | Agrees |
How it works
How to use the HDFC Tally Vouchers workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and working on sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
HDFC Tally Vouchers: questions
How do you turn a bank statement into Tally vouchers?
Which export should you use?
What happens to rows that do not match a rule?
How do you change the rules?
Get early access to this workflow
It opens already built and working on sample files. Swap in your own exports to see your result.
Workflows like this
Schedules, commissions, costing and margins, worked out the same way from every new export.
- Pivot table from raw dataTurn a raw sales export into a pivot table of revenue by region and month.See the workflow Built by the agent
- Real estate commission splitWork out real estate commission on each closed sale and split it between the listing agent, buying agent and brokerage.See the workflow Built by the agent
- Loan amortization from statementsBuild a monthly loan amortization schedule from an Excel export, with interest, principal, and remaining balance for each loan.See the workflow Built by the agent
- Accrued expenses scheduleBuild an accrued expenses schedule from QuickBooks exports. Match purchase orders to vendor bills, calculate unbilled amounts, and flag items that need accrual.See the workflow Built by the agent
- RFM segmentsEvery customer scored 1-5 on recency, frequency and spend, with a segmentSee the workflow Template
- Sales velocityEach rep's open deals, win rate, deal size, sales cycle and velocity, and the team'sSee the workflow Template