Building a Period-vs-Date Reporting Model

Why the distinction matters

In NetSuite, a transaction has both a date and an accounting period, and they don’t always agree. Report on date and your numbers won’t tie to the closed books; report on period and daily operational views look wrong. Most reconciliation pain traces back to this single confusion.

Modelling it cleanly

I build a model that carries both, then default financial statements to period and operational dashboards to date. A shared calendar dimension keeps period boundaries consistent, so a P&L in Power BI matches what the controller sees inside NetSuite.