Payroll Management System is a comprehensive Excel tool for payroll administration. It links payroll data with employee contracts and the general ledger to ensure accurate accounting mapping. Highly flexible with in-depth analytical reporting—ideal for payroll control and labor cost analysis.
Payroll Reconciliation: Links payroll registers to bank transfers and the general ledger, detailing deductions, advances, and variances per employee. Delivers a variance report and a monthly payroll account reconciliation for payroll teams and chief accountants before month-end close.
GOSI Reconciliation: Compares payroll registers with GOSI platform data and the general ledger, highlighting contribution variances and root causes. Delivers a monthly settlement report to close the GOSI account accurately before month-end close.
End-of-Service Provision (EOSB): Calculates EOSB liability and manages annual movements (Opening/Accrual/Utilization) with accounting journals and direct financial statement impact. Delivers rollforwards and adjustment memos ready for annual close by payroll and finance teams.
Leave Provision: Converts leave day balances into a monetary liability with annual movement tracking and accrual journals, linked to daily cost rates. Delivers rollforwards and close memos for HR and finance teams at year-end and periodic close.
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.
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.
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.
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.
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.
Uninvoiced 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 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 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 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: 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.
Imprest/Advance Settlement Template: Captures expenses with receipts, allocates them to cost centers, and records refunds of unspent balances with settlement limits and deadlines. Delivers settlement journals and an open-advances register for expenses and treasury teams before month-end close.
Employee 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: 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.
