Finance & Accounts Kit – Every Pro Excel Template for Month-End and MIS
All the Pro finance and accounts templates in one ZIP: bank reconciliation, Schedule III final accounts, cash flow statement and forecasts, fixed asset register, receivables and payables ageing, ratio analysis and CMA, petty cash, GST invoice and sales register, stock register, expense tracker and P&L, EMI schedule and the freelancer invoice tracker.
For: Accountants, finance teams, CA firms and small-business owners who close the books every month and prepare final accounts and MIS.
14 Pro templates · 30 extra Pro sheets · one ZIP download · ₹266 if bought one by one
Get the kitWhy get the kit
- Month-end close in one place – reconciliation, ageing, fixed assets, petty cash and the P&L.
- Year-end and lender reporting – Schedule III, cash flow statement, ratios and CMA data.
- Day-to-day business records – GST invoices, stock, expenses, loans and cash flow forecasts.
What's included (14 Pro templates)
GST Invoice Format & Sales Register
Keep customers and items once, record each sale in the sales register, and print any invoice by picking its number. The workbook reads the customer's state from the GSTIN, charges CGST + SGST within your state or IGST outside it, and prints a tax invoice with every rule 46 particular – including the amount in words.
Pro adds: GSTR-1 Summary, Credit & Debit Notes, Payments & Outstanding
Bank Reconciliation Statement
Enter your bank book and the bank statement, then mark which entries have cleared. The template lists cheques not yet presented, deposits not yet credited and bank-only entries, and builds a BRS that proves the two balances agree.
Pro adds: Outstanding Review
Cash Flow Statement (AS 3)
Enter three balance sheets and two years of P&L. The workbook derives capex, taxes paid, interest and loan movements, and builds an AS 3 cash flow statement (indirect method) for the current and previous year that ties back to your closing cash.
Pro adds: CFS Direct, Ind AS 7
Schedule III Balance Sheet & P&L
Paste your trial balance, map each ledger to a Schedule III code once, and the balance sheet and statement of profit and loss build themselves in the Division I format, with previous-year columns and a tally check.
Pro adds: Notes, Ratios (Sch III)
Fixed Asset Register
Record every asset once — cost, put-to-use date, location, useful life — and the register calculates Companies Act depreciation (SLM or WDV) pro-rata for the year, handles disposals and gives you the gross block, accumulated depreciation and net block.
Pro adds: PPE Note (Sch III), IT Depreciation
Ratio Analysis & CMA Data
Enter three years of condensed balance sheets and P&L. The workbook calculates 20 ratios — liquidity, leverage, coverage, profitability, efficiency and growth — shows whether each improved or worsened, and explains what each one tells you.
Pro adds: CMA Data, Charts
Cash Flow Forecast (12 Months)
Enter opening cash, your customers' and suppliers' credit terms and GST rate once, then monthly sales, purchases and expenses. The workbook turns them into month-by-month cash in, cash out and closing balance, flags months below your minimum cash and tells you how much extra funding you would need.
Pro adds: Scenarios, Actual vs Forecast
Loan Amortisation & EMI Schedule
Enter the loan amount, rate, tenure and first EMI date to get the EMI and a month-by-month split of interest and principal. Add floating-rate changes and part-prepayments, choose whether to keep the EMI or the tenure, and see how many EMIs and how much interest you save.
Pro adds: Year-wise & Tax, Compare Loans
Expense Tracker & Monthly P&L
Record every money-in and money-out with a category and account. The workbook builds a month-by-month profit and loss for the financial year – income, cost of sales, gross profit, expenses and net profit – and shows the balance in cash and each bank or UPI account.
Pro adds: GST Input Credit, Dashboard
Inventory & Stock Register
List your items with opening stock, record every purchase, issue, sale, return and adjustment, and the stock summary gives received, issued and closing quantity for any period, closing value at weighted average cost, and which items have fallen to their reorder level.
Pro adds: FIFO & Ageing, FIFO Lots, Item Ledger
Budget vs Actual & Cash Flow Forecast
Enter the year's budget once, add actuals as each month closes, and pick a month. The variance report shows month and year-to-date budget, actual, variance and %, marks each line favourable or adverse, and highlights anything above your materiality limit.
Pro adds: Cash Flow Forecast
Receivables & Payables Ageing
Enter open sales invoices with their credit days. The template ages each one from its due date into Not due, 0-30, 31-60, 61-90, 91-180 and Over 180 days, and builds a customer-wise summary with follow-up comments that updates as you add invoices.
Pro adds: AP Ageing (MSME), ECL Provision
Petty Cash Book & Expense Claim
Record each top-up and small payment with its expense head and voucher number. The book keeps a running balance, flags payments without a bill, and gives a head-wise month-by-month summary ready to post to the ledger.
Pro adds: Expense Claim, Travel Claim, Replenishment Voucher
Freelancer Invoice & Payment Tracker
Add your clients once with their TDS rate and credit days, then record each invoice. The tracker works out GST if you're registered (CGST+SGST, IGST or export), the TDS each client should deduct, the due date, what is outstanding and overdue – and the year's fees, receipts and TDS to claim in your return.
Pro adds: Invoice Print, TDS vs AIS, Advance Tax
Template kit
Get the Finance & Accounts Kit
- All 14 Pro templates in one ZIP
- ₹266 if bought one by one – you pay ₹208
- One-time payment, instant download, free updates
- Use for your business and your clients
We use your details only to deliver the files and support your purchase. See our privacy policy and terms.
Questions
What is in the Finance & Accounts Kit?
The Pro edition of all 14 finance templates: GST Invoice Format & Sales Register, Bank Reconciliation Statement, Cash Flow Statement (AS 3), Schedule III Balance Sheet & P&L, Fixed Asset Register, Ratio Analysis & CMA Data, Cash Flow Forecast (12 Months), Loan Amortisation & EMI Schedule, Expense Tracker & Monthly P&L, Inventory & Stock Register, Budget vs Actual & Cash Flow Forecast, Receivables & Payables Ageing, Petty Cash Book & Expense Claim, Freelancer Invoice & Payment Tracker. You get one ZIP file with an .xlsx file for each.
How much does it cost?
₹208 one-time, paid through Razorpay by UPI, card, netbanking or wallet. Bought one by one, the same Pro templates cost ₹266 at the offer price (regular ₹1,386).
Do I get new templates added to this category?
The ZIP is put together when you download it, so if you download again from your bookmarked download page after we add a template to this category, the new one is included.
Can I use the templates for clients?
Yes – for your own business or practice, including client work. Please don't resell, share or upload the files.
Which software do I need?
Microsoft Excel 2010 or later, Google Sheets or LibreOffice Calc. There are no macros. Each file opens on a Guide sheet with sample data filled in.
Other kits
Last updated 2026-10-14. Templates are tools, not professional advice.