Skilled Nursing Facilities

Journal Entries Report

The Journal Entries report is available at the facility level. It shows a transactional summary for the month. It is generally run just before month close, and provides a summary of journal entries to be entered or imported into the General Ledger. You can also us it during Month End Close Reconciliation to validate totals with the Revenue Journal, Accommodation Summary and Cash Receipts Journal report. 

  1. Do one of the following:

    • Single facilityAdmin > Reports > Journal Entries.

    • Multi-facility: Management Console > Reporting > Admin Reports > Journal Entries.

  2. Select the posting Period.

  3. Select Summary/Detail Options to either generate a Summary version of the report or Export details to Spreadsheet:

    • If you select Summary version, select additional options:

      • Review the Journal Entries to Include and select options to clear any items that you do not want to include.

      • Group by either Consolidation Account or GL Account.

      • Output Format either PDF or HTML.

      • Click the option for Export to GL.

  4. If your organization has it configured, click the Export to GL option to save a .txt file to be imported to the General Ledger.

  5. A secondary option appears to Include All Days, which provides an extract in addition to the report output for exporting into a General Ledger. Clear the option if not applicable.

  6. In Export Results > GL Export > Save.

  • An Information icon at Summary/Detail Options provides information to generate the report as a .CSV file to be saved to a location on your system and then opened by a program such as Excel.

  • Export to GL provides an extract in addition to the report output for exporting into a General Ledger. This option is only available if it is specifically set up for the organization.

  • In Export Results: GL Export, click the ? to read instructions on how to save the export file on your computer.

  • Month End Reconciliation:

    • Select the current Month to be closed.

    • Select Summary from the Summary/Details Options list. If you then have any more issues, you can rerun the report to show the details.

    • Fix the report with the Census, Cash Receipts Journal, A/R Reconciliation, and Accommodation Revenue Reconciliation reports:

      • To fix the Journal Entries report with the Census reports, you need to compare the Grand Total in the Current Period Days Amount section of the Journal Entries report with the Paid Days Amount in the Detailed Census Report By Payer report. These figures should match. If the figures do not match, then you need to:

        • Compare the Summary By Payer (By Day) section in the Census report with the Journal Entries Report to check which payer is out of balance. Run the Detailed Monthly Census Report, and the Revenue Journal Report (select the Custom and select details for days) for the identified payer.

        • Analyze the report by comparing each Resident’s Details to find the missing days.

      • After the residents with missing days are identified, make the necessary changes in the Resident Census Tab in the resident chart for those residents and generate transactions again.

    • Check the Unbilled Transactions Report, and ensure that the information is correct.

    • Fixing the Cash Receipts Journal and Journal Entries Reports:

      • Compare the amount in the Cash Receipts field in the Journal Entries report with the Grand Total (total to Bank GL) in the Cash Receipts Journal report. These amounts should match.

      • Retain reports with month-end close reports.

    • To fix the A/R Reconciliation and Journal Entries reports, you need to check:

      • Current period: Check the Current Period Items – Accommodation;, Current Current Period Items – Ancillary;, and Current Period Items – Others in the Journal Entries report. Then, add the A/R accounts. The total of the A/R accounts should match the Current Period total (column 2) in the A/R Reconciliation report. It should also match the Amt Due field of the Grand Total for the Current Period Items in the Revenue Journal report.

      • Past period: Check the Past Period Items – Accommodation; Past Period Items – Ancillary, and Past Period Items – Others in the Journal Entries report. Then, add the A/R accounts. The total of the A/R accounts should match the Past Period total (column 3) in the A/R Reconciliation report. It should also match the Amt Due field of the Grand Total for the Past Period Items in the Revenue Journal report.

        • If the Past Period is out of balance, this could be because an A/R account was used in an adjustment, for instance using a Balance Forward adjustment code to adjust charges.

    • The data is static in reports that show Current and Past Periods. You can run this report at any time to view the data as it existed at the time the period is closed and there is no requirement to print a hard copy of this report for historic reference.

  • Only organizations that have requested Export to GL configuration has the Export to GL option available to select.