Financial Statements Builder
Trial balance to IFRS primary statements, every figure linked.
Linked Excel formats that follow the guides on this site. Basic versions are free; Advanced versions add the deeper workings.
Trial balance to IFRS primary statements, every figure linked.
Lease liability, right-of-use asset, journals and the note.
Accounting profit to taxable income and tax payable.
The working papers behind the VAT 201 return.
Asset register to depreciation and the PPE note.
Monthly payroll from fixed pay to net pay, by department.
Percentage of completion for off-plan real estate.
Trial balance to IFRS primary statements, every figure linked.
Paste a trial balance, map each account once, and the statement of financial position, profit or loss and changes in equity build themselves with checks.
Advanced adds the cash flow statement, notes for every line, consolidation of up to four entities and your own line items.
Lease liability, right-of-use asset, journals and the note.
Enter the lease terms and get the full liability and right-of-use asset schedule with an annual summary.
Advanced runs up to 20 leases with escalations, incentives, restoration costs, modifications, journal entries and the full disclosure note.
Accounting profit to taxable income and tax payable.
Standard adjustments, the Small Business Relief test and the 0% / 9% calculation in one summary computation.
Advanced adds interest limitation, participation exemption, tax losses, free zone and tax group workings, related parties and the IAS 12 reconciliation.
The working papers behind the VAT 201 return.
Summarise output and input VAT by emirate and map it to each VAT 201 box.
Advanced adds a 1,000-line register with reverse charge and blocked input tax, real estate classification, apportionment and the GL reconciliation.
Asset register to depreciation and the PPE note.
Keep the register for up to 150 assets with monthly straight-line depreciation, disposals and the IAS 16 movement note by class.
Advanced adds 1,000 assets, reducing balance, capital work in progress, revaluation, impairment, journals, a 12-month schedule and deferred tax.
Monthly payroll from fixed pay to net pay, by department.
Run one month for up to 50 employees: pro-rating for joiners and leavers, overtime at 125% / 150%, unpaid leave, bonus and deductions, with a department summary.
Advanced runs a full year for 500 employees with pension for nationals, gratuity, leave and air ticket accruals, journals, the WPS SIF layout, payslips and month-on-month variance.
Percentage of completion for off-plan real estate.
Measure progress for the whole project by cost-to-cost or the engineer's certificate, then revenue, cost of sales, contract balances and inventory for every period.
Advanced works unit by unit with cancellations and handovers, allocates cost by area or price, adjusts for the financing component, handles project loan interest and posts the journals.
Tools are calculation aids. Review results against the relevant standard or law and apply professional judgement. Premium files are sent by email after payment.