Budgeting utilities
Axiom Performance Reporting 2022.3 comes with a variety of standard budget utilites, organized within the following folders and subfolders.
TIP: In some reports, you can drill down to specific data to view how the values were calculated. For more information, see Drilling data: Using Drill Down.
Balance Sheet and Deductions
The following utilities are designed for budget balance sheet calculation and deductions modeling to post the results to the database.
| Report | Description |
|---|---|
| Budget Balance Sheet and Cash Flow | Use this save-to-database report to project the balance sheet for the remainder of the current year and next year’s budget by category. |
| Budget Deductions | All statistics, revenues and deductions are broken out by payer. You can make assumptions for the projection and budget in each payer section. |
| NYB_Deductions_FSDetail | Use this deductions model to project deductions using the historical relationship to gross revenue for each deduction category. |
| NYB_Deductions_FSPayor | Use this deductions model to project deductions using the historical relationship to gross revenue by payer. |
Budget Reconciliation utilities
The following utilities are designed for budget balance sheet calculation and deductions modeling to post the results to the database.
| Report | Description |
|---|---|
| Budget Department Audit Report | Use to resolve possible mapping errors at the department level by highlighting mapping and process management inconsistencies in the DEPT dimension table before building plan files and starting process management. |
| Budget Process Management Report | Use to show what stage each budget plan file is in when using process management for budget staging. |
| Budget Workbook Reconciliation | Use to compare check totals from different columns in the budget workbooks to the summary fields in the database to make sure they are in balance. If the budgets are all in balance, then this report returns no data, which is the desired outcome of this report. |
| Global Depreciation Reconciliation Report | Use to show the variance between the budgeted depreciation accounts to the same accounts in the general ledger budget for a user-specified budget year. |
| Global Expense Reconciliation Report | Use to show the variance between the budgeted depreciation accounts to the same accounts in the general ledger budget for a user-specified budget year. |
| Global Revenue Reconciliation Report | Use to show the variance between the budgeted global revenue accounts to the same accounts in the general ledger budget for a user-specified budget year. |
| Labor Non-Matched | Use to identify the JobCode/PayType combinations that have dollars but have no FTE hours for the year. |
| New Department Utility | Use to create default records for a new department. You can save records to the Financial, Payroll, Provider, or RevUsage tables. |
| Payroll12 Hours Reconciliation | Use to highlight job codes saved in the Payroll12 data source from the budget workbooks that have hours but no dollars in the budget. |
| Payroll12 Negative Hours | Use to highlight job codes and pay types that have any negative FTEs budgeted in any month. The report returns all job codes in the database, but only the ones with the Review flag need to be investigated and changed, if necessary. |
| PayType Mapping Analysis | Use during budget set up for payroll budgeting to show what PayTypes map to which payroll budget category. |
| Reconcile NYBDetail to Financial | Reconcile values saved in NYBDetail table to those values saved in the Budget Table which could indicate that values in your budget plan files are not saving properly. |
| Reconcile Payroll12 to Financial-Dollars | Use to test the data transfer from the Labor tab to the Expense tab in the budget workbook. |
| Reconcile Payroll12 to Financial-FICA | Use to test the data transfer from the Labor tab to the Expense tab in the budget workbook. |
| Reconcile Payroll12 to Financial-Hours | Use to test the data transfer from the Labor tab to the Expense tab in the budget workbook. |
| Salaries Do Not Match | Use to identify accounts on the Labors tabs in the plan files that do not have history on the Expense tab and would cause a balancing mismatch. |
Budget Setup utilities
The following utility is designed to help set up security.
| Report | Description |
|---|---|
| PayrollGLMapping | To allow mapping of GL accounts and Hours accounts different from the Jobcode dimensions table or Paytype dimensions table as a result of various combinations to match GL accounts. |
Budget Extract from EPM utilities
The following utility is designed to extract budget data from the Axiom database.
| Report | Description |
|---|---|
| PayrollGLMapping | To allow mapping of GL accounts and Hours accounts different from the Jobcode Dimensions Table or Paytype Dimensions Table as a result of various combinations to match GL accounts. |
Budget Provider Utilities - Reconciliation utilities
These utilities are designed to reconcile data to support physician analysis.
| Report | Description |
|---|---|
| Matching Provider Dept Revenue to Dept Salaries | Use to determine if there are situations where the provider revenue and salaries do not match by department. |
| Matching Provider Revenue to Salaries | Use to check the net difference between revenue and salaries by provider. |
| ProviderComp JobCodes | Use to compare the coding in global assumptions to the information in the Payroll27 tables before creating budget plan files. |
| Reconcile GL Revenue to Provider | Use to reconcile the gross charges in the Financial data source to the gross charges in the Provider data source for both the current period as well as year-to-date. |
| Review Provider Data | Use to identify situations where there is revenue without matching volume in the historical data that is used for projection and budget purposes. |
Budget Provider – Statistics utilities (optional feature)
This utility is designed to reconcile data to support physician analysis.
| Report | Description |
|---|---|
| Summarize Provider Statistics to Financial | Use this save-to-database report to summarize provider data into monthly statistics to be used in Financial data tables and reports. |
Budget Provider – System Setup utilities
This utility is designed to reconcile data to support physician analysis.
| Report | Description |
|---|---|
| ProvBenchmark | This table may be used for reports to compare provider compensation to benchmarks. |
Budget Report Batch utilities
This utility is designed to run multiple reports together.
| Report | Description |
|---|---|
| Budget Reconciliation Reports Batch | Use to run multiple budget reconciliation reports for distribution. |
Budget Security utilities
This utility is designed to run multiple reports together.
| Report | Description |
|---|---|
| Budget Driver Security Update | Use to update the Driver security settings and filters for Admin users who have access to update Driver files. |
| Budget Security Update | Use to update security settings and filters for all users. |
