Skilled Nursing Facilities

Generating a Financial Report

Yyou can generate and print the report to ensure that it is formatted and it is calculating as expected. You can generate reports at both the facility and EMC level if you created the reports and account groups at the Management Console (EMC) level and the scoping is corporate. If you created the reports and accounts groups at the facilityy level, you can generate the report only at that facility or EMC. The options available for generating a custom report depend on the report type and whether it is run at the facility or EMC level.

Note

To see the Actual, Budget, or Variance divided by the Days calculation on your custom report, edit the report setup and select to add those columns the bottom of the page. 

Note

Include Adjustment and Closing period options is not available on Period Based Reports. 

  1. GL/AP > Reports > Financial Reports.

  2. Depending on the report type, select the required details to specify the Fiscal Period(s) and Year required.

    • Balance Sheet & Cash Flow Report - In the As Of section, select the appropriate month(s), and then select the applicable Fiscal year from the list.

    • Income Statement - In the Date Range section, select the appropriate month(s) and then select the appropriate Fiscal year from the list.

    • Period Based Report - In the Start Date field, select the appropriate date from the Fiscal Per list, and then select the appropriate year from the Fiscal Year list. Select the number of periods from the # of Periods list to specify the specific number of periods to display.

  3. To include the adjustment periods in the report, select the Include Adjustment Periods. Select this option only if you are running the report at year end and you need to entries posed to the adjustment period. 

  4. To include the closing periods in the report, select the Include Closing Periods. Select this option only if you want to include closing period transactions at year end.

  5. Select the Amount or Percentage (%) to enter the amount or percentage in the Threshold for Variance field. A report using a threshold option shows details for accounts that have variance greater or equal to the entered amount or percentage.

  6. Display Options.

    • Days Summary - Select this to list a Resident Days (Denominators) Totals summary for the columns and accounts and subgroups for the report. It can be used to verify that the report is correctly using the appropriate days/units denominator for the report.

  7. Calculate Daily Rates Based on - Calculate Daily Rates is available when you run the Income Statement or Period Based reports. You have 3 options for the days denominator used to calculate the per resident day amounts: Census Days, Days Account Groups, Calendar Days.

    • The Census Days option pulls the days total from the Admin census area. This may or may not be the same total as posted for Days in your General Ledger. The variance is dependent on the timing of past period days entries in the Admin module. 

    • The Days Account Groups option pulls the totals for the Days accounts as posted in your General Ledger and as configured in the Days Account Group setup. 

    • The Calendar Days option pulls the days total based on the number of calendar days in the period you are reporting on. 

  8. To generate the report in Microsoft Excel forma. select Export to Spreadsheet.

  9. To generate a report with all the amounts shown as links, select Enable Report Drill Down . The drill down takes you to the G/L transactions detail for the specific GL accounts included in that line item. 

  10. Select Run Report. The Custom Financial Report appears, based on the options selected. If the Export to Spreadsheet option is selected, the report is exported. Click Download and Open to open the report in Excel.

From Management Console (EMC) > Reporting > GL/AP - Financial Reports section

  1. Select the report type and select the required details to specify the Fiscal Period(s) and Year required.

    • Balance Sheet In the As Of section, select the appropriate month(s), and then select the applicable Fiscal year from the list.

    • Income Statement In the Date Range section, select the appropriate month(s) and then select the appropriate Fiscal year from the list.

    • Period Based Report In the Start Date field, select the appropriate date from the Fiscal Per list, and then select the appropriate year from the Fiscal Year list. Select the number of periods from the # of Periods list to specify the specific number of periods.

  2. The Facilities defaults to All Facilities being set. Select the Include Inactive Facilities to include that detail in the report. To run the report for specific facilities, set the option to Selected Facilities and the window opens to select all the required facilities. Click Save.

  3. Select Compare Facilities to create a report comparing the facilities in separate columns. Select Display Totals option first or last, to see consolidated totals at the first or last columns of the report.

  4. Select the Reporting Group option to include facilities assigned to a specific reporting group.

  5. Follow 3 to 11 from the steps for the facility procedure above.

  • To select a range of months for an income statement, select the first month and then the last month and the all the month in between are selected.

  • In multiple facility that has more than one Fiscal Year End month, the Management Console custom income statement and balance sheet has an additional feature to select the Fiscal Year End Month from the list. You can only create a report for facilities with the same year end month.

  • Use the Balance Sheet - System and the Income Statement - System report to ensure that custom reports are correctly configured. If you determine any differences, use the display account numbers and zero balance accounts options to check to make sure the custom report includes all the necessary accounts and make sure there are no accounts used more than one time. For example, make sure a single account selected for a subgroup is not also included in a range of accounts or another subgroup.