3-Way Match Toolkit – Excel File
2383-Way Match Reconciliation: Matches PO, GRN, and invoice with price/quantity tolerance thresholds and an exception handling workflow. Delivers an approvable invoice list and variance reports for AP before payment runs and month-end close.
Accrued Purchases Template – Excel Template
159Uninvoiced Purchases Accrual: Recognizes executed services/purchases without invoices via accruals with reversing entries and settlement upon invoice receipt. Delivers more realistic monthly expenses and fewer close surprises for AP and chief accountants.
Landed Cost Allocation Model – Excel Template
208Landed Cost Template: Captures freight, duties, insurance, and other import costs and allocates them to items (by value/weight/volume) to update unit cost. Delivers more accurate inventory valuation and COGS for import and costing teams at month-end.
Inventory Count & Variance Resolution – Excel Template
208Inventory Stocktake Template: Organizes planning, counting, review, variance analysis, approvals, and posting of adjustment entries by variance reason. Delivers variance reports and approved stocktake minutes for periodic or annual counts.
Inventory Write-off Template – Excel Template
208Inventory Scrap & Write-Off Template: Documents scrap/damage, disposal reasons, approval limits, write-off journals, and linkage to warehouse/item. Delivers disposal minutes and monthly scrap reporting for inventory teams and chief accountants.
Slow-Moving & Obsolete Inventory Provision – Excel Template
208Slow-Moving & Obsolete Inventory: Analyzes aging and days on hand, classifies slow/idle items, and calculates impairment allowance with defined rules. Delivers liquidation/markdown candidates and a monthly provision schedule to reduce cash tied up in stock.
Employee Advances & Loans Tracker – Excel Template
129Employee Loans/Advances Register: Records loan/advance amounts, repayment schedules, payroll deductions, and remaining balances per employee. Delivers an employee receivables register and monthly settlement journals for payroll/finance—supporting EOS settlements as well.
Recurring Expenses Accrual + JEs – Excel File
238Recurring Expenses Accrual: Recognizes rent, utilities, and subscriptions monthly via accruals with reversing entries and settlement upon invoice receipt. Delivers movement schedules and close journals to stabilize period expenses.
Debt Schedule Master – Excel File
318Debt Schedule: Structures loans by principal/interest, maturity dates, collateral, and short/long-term classification with close linkage. Delivers a unified debt register and baseline disclosures for reporting and treasury.
Fixed Assets Depreciation Model – Excel File
318Fixed Assets Depreciation & Management Template is a comprehensive Excel program to manage fixed assets and calculate depreciation accurately using the straight-line method. It provides detailed and summarized depreciation and net book value reports, and can be easily reconciled to the trial balance—enhancing fixed asset control and efficiency.
Finance Lease Accounting Model – Excel File
318IFRS 16 Finance Lease Accounting Template is a comprehensive Excel program to accurately calculate right-of-use assets, lease liabilities, interest, and depreciation for lease contracts. Includes detailed schedules, clear methodology, and journal entry guidance—aligned with IFRS 16 requirements.
Operating Lease Accounting Model – Excel File
159Operating Lease Expense Management Template is an effective Excel program to monitor and control operating lease expenses through detailed schedules and precise reporting of expense balances, prepaid and accrued rent—enabling easy reconciliation to the trial balance and variance analysis.
Break-even & Sensitivity Model – Excel File
238Break-Even Model: Calculates break-even point, margin of safety, and sensitivity to price/volume and fixed/variable cost changes. Delivers profitability scenarios to support pricing and expansion decisions.
Billing, Retentions & Variations – Excel Template
238Construction Progress Billings Management: Handles interim progress invoices, retentions, advance payments, change orders, and linkage to advance deduction schedules. Delivers billing/collection schedules and retention tracking for project teams before monthly close and collections.
Related Party Register – Excel File
159Related Parties Register: Documents related parties, transactions, balances, terms, and approvals, with contract references and transaction nature. Delivers RPT disclosure-ready data for financial statements and governance.
Excel Functions Practice Pack – Training Excel Files
238Practical Excel Functions Workbook: A comprehensive Excel file explaining 320 functions (definition, benefits, and usage), with hyperlinks that take you to an interactive example for each function on a dedicated worksheet.