Solutions

Applications for finance teams on Microsoft Fabric data

Month-end analysis is already in the model. The explanations, approvals and adjustments around it should be too, instead of in spreadsheets sent by email.

Use cases

Forecast adjustments

Controlled adjustments to a forecast baseline, stored as versioned records with a reason.

Not available as a demo yet

Accrual and allocation confirmations

Unit controllers confirm or correct proposed accruals and allocations before close.

Not available as a demo yet

Mapping maintenance

Business users maintain account or cost-centre mappings with an approval step.

Not available as a demo yet

Typical data sources

  • ERP general ledger for actuals
  • Planning or budgeting system for budget and forecast
  • Existing finance semantic models and Power BI reports
  • Spreadsheets currently used for commentary

What to settle early

  • Sign conventions and favourable/unfavourable logic must be agreed and defined once in the model.
  • Segregation of duties: preparers and approvers should be different roles, enforced by permissions.
  • The close calendar defines deadlines and reminders; the app should follow it, not the other way round.
  • Approved commentary is reporting content; its retention and change rules belong in finance governance.

Discuss a finance use case with Antdata

Describe the workflow and the systems involved. We will tell you how we would approach a pilot.

Discuss your project