Inquiry page · Budgeting
Actual vs. budget
An inquiry page that compares budget amounts with actual amounts for the financial dimension values you select.
- Used by
- Auditor, Budget clerk, Budget contributor and 7 more roles
- Business process
- —
- Menu item
BudgetBalancesActualsByFocus- Main table
BudgetTmpBalancesActuals- Data entity
- —
- Setup steps
- —
Show what matters for
Everyone
1What it is and why
| What it is | An inquiry page that compares budget amounts with actual amounts for the financial dimension values you select. |
|---|---|
| What you do here | Used to drill into the details behind budget and actual amounts. |
| Example | — |

Functional consultant · Solution architect
2Where it fits
| Business process | — |
|---|---|
| Menu path | Budgeting › Inquiries and reports › Basic budgeting › Actual vs. budget |
| Set up first | Budget register entries Microsoft Learn ↗ |
| Used next by | — |
| Related pages | Budget account entries Microsoft Learn ↗Actual vs. budget by period Microsoft Learn ↗ |
End user · Functional consultant
3How to do it
Microsoft's steps
- Go to Budgeting > Inquiries and reports > Basic budgeting > Actual vs. budget.
- Select a line.
- Select Period balances to see the budget and actual amounts spread across fiscal periods.
- Select Budget account entries to see the budget register entries behind the budget amount.
- Select General journal entries to see the ledger transactions behind the actual amount.
Source: Microsoft Learn ↗
Field guide
| Field | What it means | Worked example | Table column |
|---|---|---|---|
| Actual | The sum of debits and credits posted for the financial dimension value.Microsoft Learn ↗ | — | — |
| Preliminary budget | The total of preliminary budget register entries for the budget model and dimension values (public sector).Microsoft Learn ↗ | — | — |
Functional consultant
4Setup decisions
| Setup step | Recommended value and why | Decision · common mistake · test |
|---|---|---|
| — No setup is made on this page. | ||
Solution architect
5Design impact
| Shared or per company | — |
|---|---|
| Can it be undone | — |
| Feature or country | — |
| If you change it later | — |
Technical architect
6Technical
| Menu item | BudgetBalancesActualsByFocus Checked in Dynamics 365 |
|---|---|
| Form | BudgetBalancesActualsByFocus Checked in Dynamics 365 |
| Table | BudgetTmpBalancesActualsShown as “Budget balances” in Record infoChecked in Dynamics 365 |
| Data entities | — |
| Who can open it | PrivilegesView actuals versus budget information BudgetBalancesActualsByFocusViewDutiesReview budget process performance BudgetBudgetProcessPerfReviewInquire into budget master BudgetBudgetsInquireInquire into budget register entry status BudgetBudgetTransStatusInquire10 security rolesAuditorAuditPolicyManagerBudget clerk BudgetBudgetClerkBudget contributor BudgetBudgetContributorBudget manager BudgetBudgetManagerChief executive officer CompanyChiefExecutiveOfficerChief financial officer CompanyChiefFinancialOfficerAccountant LedgerAccountantAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorFinancial controller LedgerFinancialController |
| Actions on the page | Options: Personalize, Page options, ShareChecked in Dynamics 365 |
Developer
7Developer
| Open it directly | https://<your-environment>/?mi=BudgetBalancesActualsByFocus |
|---|---|
| Integrate with | — |
| Table definition | — |
Everyone
8Sources and checks
- learn.microsoft.com/training/modules/setup-use-basic-budgeting-finance/use-inquiries-reports
- learn.microsoft.com/dynamics365/finance/budgeting/basic-budgeting-overview-configuration
- learn.microsoft.com/dynamics365/finance/public-sector/preliminary-budgets-apportionments-public-sector
- Checked in a working Dynamics 365 system, version 10.0.49: the menu item, form, table and security, the page.