Free Excel templates
27 free templates for P2P, R2R, Ind AS and InvITs
Built for accountants, CAs and CMAs, and for finance teams in toll road SPVs and InvITs. No sign-up, no macros.
For computation and reconciliation assistance only; not a substitute for formal statutory audit or legal tax advice. All sample data is illustrative and made up. Rates, limits and rules must be checked against current law and your own agreements before use. No tax saving, audit outcome or compliance result is promised.
Procure to pay (P2P)
Q · Procure to pay (P2P)
Vendor Master Checklist
Check PAN, GSTIN and IFSC formats, duplicates, MSME details, documents and maker-checker approval.
Details and download →R · Procure to pay (P2P)
Three-Way Match (PO, GRN, Invoice)
Match invoices to POs and GRNs with tolerances, flag duplicates, and split clear-to-pay from on-hold.
Details and download →S · Procure to pay (P2P)
TDS Payable Tracker
Bill-wise TDS from your rate table, deposit due dates, late flags, challans and month-wise totals.
Details and download →T · Procure to pay (P2P)
AP Ageing with MSME 45-Day Tracker
Payables ageing with the MSMED Act due date, overdue flags, estimated interest and a year-end prompt.
Details and download →U · Procure to pay (P2P)
Vendor Statement Reconciliation
Reconcile your vendor ledger with the vendor's statement, item by item.
Details and download →Record to report (R2R)
A · Record to report (R2R)
Prepaid Expense Amortisation Schedule
Spread insurance, AMC and licence costs over the service period, by day or by month.
Details and download →B · Record to report (R2R)
Month-End Accruals and Provisions Tracker
Book provisions with auto-reversal, match later invoices and flag under- or over-provision.
Details and download →C · Record to report (R2R)
Fixed Asset Register with Companies Act and Income Tax Depreciation
Schedule II depreciation and the income-tax block of assets, including the 180-day rule, in one register.
Details and download →I · Record to report (R2R)
Bank Reconciliation Statement
Match the cash book with the bank statement and prepare the BRS automatically.
Details and download →K · Record to report (R2R)
Month-End Close Checklist
Close calendar in working days, with owners, status, overdue flags and % complete.
Details and download →V · Record to report (R2R)
Intercompany Reconciliation and Elimination
Compare both sides of every intercompany balance, explain differences and get elimination totals.
Details and download →W · Record to report (R2R)
Journal Entry Register and Review
Manual journals with auditor-style flags: unbalanced, self-approved, no support, after close and more.
Details and download →X · Record to report (R2R)
Balance Sheet Reconciliation Tracker
GL vs schedule for every account, with preparer, reviewer, due dates, item age and completion by risk.
Details and download →Y · Record to report (R2R)
Trial Balance to Schedule III Mapping
Map the trial balance and get a Schedule III balance sheet and P&L, with balance checks.
Details and download →Audit and compliance
Z · Audit and compliance
CARO 2020 Fixed Asset Physical Verification Tracker
Physical verification of PPE against the register, with discrepancy values, title deeds and a CARO 3(i) clause-wise status.
Details and download →AA · Audit and compliance
Audit PBC (Prepared by Client) Tracker
The auditor's request list with owners, due dates, overdue days, open queries and progress by area.
Details and download →Ind AS
D · Ind AS
Ind AS 116 Lease Schedule (Lessee)
Lease liability, right-of-use asset, interest and depreciation, with journal entries.
Details and download →E · Ind AS
Ind AS 109 Expected Credit Loss Provision Matrix
Trade receivables ECL with ageing buckets, loss rates and a forward-looking overlay.
Details and download →Toll roads and HAM
F · Toll roads and HAM
Toll Revenue and Traffic MIS
Plaza-wise and class-wise traffic and toll collection against budget, with a 12-month trend.
Details and download →H · Toll roads and HAM
DSCR, DSRA and MMRA Covenant Tracker
Half-yearly CFADS, DSCR against covenant levels, LLCR and reserve balances.
Details and download →L · Toll roads and HAM
HAM Annuity Schedule
Construction support, half-yearly annuities with interest and O&M payments, all indexed.
Details and download →M · Toll roads and HAM
Toll Road SPV Financial Model (BOT)
Traffic × tariff, O&M, major maintenance, tax, debt sculpting, DSCR, LLCR and IRRs.
Details and download →N · Toll roads and HAM
TOT Concession Valuation
Maximum upfront fee at your target return, bid IRR, scenarios and a sensitivity table.
Details and download →InvITs
Analysis and reporting
J · Analysis and reporting
Budget vs Actual Variance Report
MTD and YTD variance by P&L line with flags, subtotals, forecast and commentary.
Details and download →O · Analysis and reporting
Financial Ratio Analyser (Schedule III)
The 11 Schedule III ratios over 3 years with automatic 'explain' flags, plus lender ratios.
Details and download →Every file is a macro-free .xlsx with a Read Me tab, blue-on-yellow input cells and a Checks box. Works in Excel 2010 or later, Microsoft 365, LibreOffice and Google Sheets.