Customer Credit Limits & Policy – Word & Excel Files
55.59 $Customer Credit Policy: Defines credit limits, payment terms, exception rules, and sales blocking upon limit breaches, with periodic review cycles. Delivers a Credit Limits table directly linked to AR Aging follow-up for sales and collections governance.
Customer Contracts Register – Excel Template
42.29 $Customer Contract Management Template is a comprehensive Excel-based program to manage customer contracts effectively, including contract data, payments tracking, completion percentages, delivery dates, and project profitability—supported by automated reports that improve contract oversight and customer relationships.
Customer Master Data Template – Excel Template
42.29 $Customer Master Data Template: Captures VAT/Commercial Registration (CR), addresses, contacts, payment terms, and credit limits with duplicate checks and mandatory fields. Delivers an ERP- and e-invoicing-ready Customer Master for receivables reporting and compliance.
Customer/Product Profitability – Excel Template
63.56 $Customer Profitability Analysis: Aggregates sales, COGS, rebates, fees, shipping, and returns to calculate cost-to-serve by customer/product. Delivers a report highlighting unprofitable customers/products to support pricing and discount policy decisions at close.
Rebates & Claims Settlement – Excel Template
42.29 $Customer Rebates Template: Calculates rebate accruals by contract/volume, records customer claims, and links to credit notes (CN) and invoice settlement. Delivers an accrual schedule and documented rebate settlements for sales and finance at month-end close.
AR Dispute Tracker – Excel Template
34.31 $AR Dispute Tracker: Logs disputed invoices with reason, amount, owner, and target closure date. Delivers an open-disputes list linked to collections planning—clarifying what can be collected now vs. what awaits dispute resolution.
Sales Returns & Allowances – Excel Template
42.29 $Sales Returns Provision: Calculates allowances based on historical rates, manages provision movements, and links CNs to returns and COGS impact. Delivers a monthly rollforward for net revenue and margin for sales and finance teams.
Deferred Revenue Schedule – Excel Template
42.29 $Deferred Revenue Schedule: Allocates subscription/prepayment revenue over the service period while tracking remaining balances, renewals, and cancellations. Delivers monthly recognition journals and a deferred balance per contract for recurring-revenue management.
IFRS 15 Revenue Recognition Pack – Excel Files
111.44 $IFRS 15 Revenue Recognition Pack: Breaks contracts into performance obligations and manages deferred revenue and variable consideration with supporting schedules. Delivers monthly journals and disclosure-ready reports for IFRS and reporting teams.
Payment Gateway Reconciliation Pack – Excel Files
84.84 $Payment Gateway Reconciliation: Matches Mada/Visa/MC/Apple Pay/STC/Stripe transactions to bank settlements, breaking down fees, refunds, and chargebacks. Delivers a close-ready variance and reconciliation report for e-commerce finance teams.
ECL Model – Excel File
111.44 $Expected Credit Loss (ECL) Study Template is an advanced Excel tool to calculate ECL provisions in line with IFRS 9, with automated schedules and required calculations—supporting accurate results and effective implementation.
Simplified ECL by Aging – Excel Template
63.56 $Simplified ECL Model: Calculates expected losses using aging-based loss rates, customer segmentation, and forward-looking adjustments. Delivers an auditable monthly ECL provision without complex modeling.
Bad Debt Provision Policy – Editable Word File
42.29 $Doubtful Debts Provision Policy: Defines delinquency aging rules, classification criteria, approval levels, write-off/recovery procedures, and linkage to collections. Delivers operating rules and write-off memos for audit readiness.
AR Provision Rollforward – Excel Template
42.29 $AR Provision Rollforward: Presents a full rollforward (Opening/Provision/Reversal/Write-off) with direct linkage to P&L and balance sheet impacts. Delivers disclosure- and audit-ready schedules explaining period-to-period movements.
Purchasing Controls Template – Excel Template
21.01 $Purchasing Internal Control Template is an effective Excel tool to manage supplier invoices and contractor agreements with dashboards and charts to analyze spending. Flexible and customizable to enhance procurement controls and improve purchasing efficiency.
P2P Forms Pack – Word & Excel Files
63.56 $Procurement Cycle Templates: Covers PR→PO→GRN→Invoice→Approval with mandatory fields and document linkage across stages. Delivers an audit-ready procurement file that prevents invoices without receipt or without PO for procurement and accounting teams.
AP Aging & Payables Plan – Excel Template
42.29 $Accounts Payable (AP) Aging: Buckets supplier invoices by aging and converts them into a weekly/monthly due schedule tied to liquidity. Delivers a prioritized payments list to help finance manage cash and avoid supplier delays.
3-Way Match Toolkit – Excel File
63.56 $3-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.