Skilled Nursing Facilities

Facility or Community Generated GL Transactions Report

  2. Click G/L Transactions - New from the G/L Reports section of the GL/AP Report List. The G/L Transaction Report Setup page appears.

  3. The first report option is to run the GL Transactions by:

    • Fiscal Period - Select Fiscal Period to generate the report for the general ledger transactions by fiscal period. Then select the Fiscal Period Range for the report by selecting starting and ending period and year from the lists.

    • Calendar Date - Select Calendar Date to generate the report for the GL transactions by effective date for a specific date range. Type or select the required dates in the Date Range field. When using a calendar date range, the system automatically checks the Include Year End Adjustment Period and Include Closing Period and these types of entries appear on the report if the effective date for the entries falls within the date range for the report.

  4. In the Account(s) area, determine the accounts that you want to include in the report by selecting an appropriate option:

    • All - Generate the report for all accounts.

    • Range - Generate the report for a range of accounts, and then enter the specific G/L account numbers in the Range fields. Alternatively, you can search for the accounts using the search icons lookup.gif.

    • Single - Generate reports for a specific account, and then specify the account number in the Account field. Alternatively,search for the account using the search icons lookup.gif.

  5. Select Include Accounts With No Activity to include GL Accounts in the generated report that have no GL transactions for the time specified and the account balance is zero.

  6. Select Include Year End Adjustment Period to include the year-end adjustment period GL transactions in the report.

  7. Select Include Closing Period to include the closing period GL transactions in the report.

  8. Select Detailed or Summary to generate the detailed or summarized report respectively.

  9. If required select the appropriate transaction types for the Filter by Source. By clearing all the options, the generated report shows all G/L transactions. To generate a report for G/L source transactions only, select All GL. In the example below, you see that selecting All GL, the specific GL source types become unavailable.

  10. Select an appropriate option from the Sort By list. The options that appear are based on the order of GL Account segments. Common segment options are Account Number, Sub Account, Department or Cost Center.

  11. Select an appropriate option from the Report Output Format list to generate the report in PDF, Excel or HTML format. The report output format options provide PDF for optimized printing, Excel for exporting the details to a spreadsheet for data analysis and manipulation and HTML for drill down capability on a summary report. Using Excel as the output format shows additional 2 options:

    • Display Subtotals - Generates a separate Subtotals column and separate row for listing any source subtotals. Clearing this option makes the Group by Source option inactive and the generated report removes any subtotals from appearing. (Column M exists without a column header and it can be deleted as no subtotals populate the report.)

    • Display Net Change - Generates a separate Net Change column and separate row for listing Net Change by Fiscal Year and Period and the Total net change for the date range selected for the report. Clearing this option generates a report without any net change rows and there is no column showing Net Change amounts. (Delete any unnecessary column(s) created in the Excel spreadsheet.)

  12. Select Group by Source to group all transactions in the report by source, such as accounts payable (AP-IN, AP-PY), accounts receivable (AR, AR-CR) and general ledger (GL-IM, GL-HO, GL-JE, GL-RC, GL-YE).

  • Wildcard examples

  • When using a Report Output of HTML and a the Report Type of Summary, the generated report allows the drill down to the detailed GL Transaction by clicking the link for the GL Account number/descriptions.

  • If the list for Sort By shows Segment 1, it indicates that the segments for the G/L Account have not been correctly defined. To assign the segment name go to the Management Console (EMC), click the Standards tab and click the Format Account Number under the GL/AP Setup section. Select edit for each segment and enter the correct name for the Segment Name. If you do not have access, refer this to someone with GL Setup security role access

  • You require the GL Entry or GL Posting or GL Setup or GL/AP Role or equivalent security access to access GL Reports.