Ankeshan

Accounting Books in Excel — Ledgers, P&L, Balance Sheet

Ankeshan's Books module turns the transactions you already record in Excel into a complete set of books of accounts — Day Book, ledgers, Trial Balance, Profit & Loss, Balance Sheet, and Cash Flow — generated automatically, on your own PC, without a single manual ledger posting. You enter sales, purchases, receipts, and payments the way you always have; Ankeshan does the double-entry, the grouping, and the statements for you.

Ankeshan adds this inside the Excel you already use — nothing new to learn, nothing leaves your PC.

What it does

  • Auto-generates your Day Book from sales, purchases, receipts, payments, and journal entries — no separate posting step.
  • Maintains multi-account ledgers for cash, bank accounts, credit cards, and wallets, each with a live running balance.
  • Reconciles your bank statement. Import a bank statement (PDF or CSV) and Ankeshan matches each line to your book entries by amount, date, and narration — auto-matching the confident ones and flagging the rest for you to confirm.
  • Categorises expenses with rules based on vendor-name patterns and amount ranges, so recurring costs sort themselves.
  • Builds a real-time P&L that updates as you add transactions, split into direct/indirect income and expenses.
  • Generates a Balance Sheet grouped per Schedule III of the Companies Act, as of any date you choose.
  • Produces a Cash Flow Statement (operating, investing, financing) using the indirect method.
  • Runs a Trial Balance as of any date with an auto-balancing check that flags errors.
  • Compares year over year so you can see how this year stacks up against last.
  • Keeps an audit trail — every entry timestamped, with edit history retained.
  • Handles recurring entries (rent, salaries, subscriptions) from templates, plus opening balances at FY start and closing entries at FY end.
  • Supports multi-currency for exporters, and ages your receivables and payables into 0–30, 31–60, 61–90, 91–180, and 180+ day buckets.

How it works in Excel

You keep a simple Transactions sheet — date, voucher type (Sale, Purchase, Receipt, Payment, Journal, Contra), party, debit and credit accounts, amount, and a narration. Ankeshan reads that sheet against a standard Indian chart of accounts and writes out the finished statements as new sheets in the same workbook: Day Book, Cash Book, Bank Book, customer and vendor ledgers, Trial Balance, P&L, Balance Sheet, and Cash Flow.

Because every report is generated from the same source rows, they always agree with each other. Change a transaction and the statements refresh — no re-posting to five different ledgers by hand. For bank reconciliation, you point Ankeshan at your downloaded statement and review its suggested matches, so the tedious tick-and-tie is mostly done for you.

Who it's for

This module is for business owners and accountants who already run their accounts in Excel and are tired of manually maintaining ledgers or paying for cloud accounting software. It fits proprietors, partnerships, and small companies that want proper books — a real Trial Balance and Balance Sheet, not just a running total — without leaving their spreadsheet. It's especially useful at year-end and for anyone whose CA currently rebuilds their accounts from scratch.

Good to know

  • Your data drives the output. Clean, consistent entries in the Transactions sheet produce clean statements. Ankeshan automates the accounting, not the discipline of recording it.
  • Bank reconciliation is assisted, not magic. Ankeshan matches what it confidently can and asks you about the rest — you stay in control of the final tick.
  • Offline. Statements are generated locally in your workbook; nothing is uploaded.
  • Point-in-time reports. The Balance Sheet and Trial Balance are generated as of a date you pick, so you can produce them for any period without locking your file.

Learn more

Launching soon

Pricing is announced at launch. Join the waitlist to be first to run your books this way.