Patient Accounting Archive

Month-End Procedures

Content on this page is for Standard Patient Accounting Archive Customers.

This guide outlines the steps necessary for closing the accounting period in DataCapture each month. The
goals of these steps include completing posting, generating dunning letters, obtaining the general ledger
report, creating guarantor-based statements, and running month-end reports.

Step 1: Complete All Posting

Ensure all postings for the month are completed. It is recommended to close the accounting period on the
final day of the month (or as close as possible). For detailed instructions, refer to the DataCapture Batch
Posting Job Aid.

Step 2: Complete the Dunning Process

If you have opted into the dunning process, review the Dunning Messages list before closing the
accounting period.

To complete the dunning steps:

  1. Navigate to Patient Accounting > Dunning Messages. (See Figure 1.1)
  2. Review the list of patients eligible for the first warning letter, along with encounter details such as
    patient name, balance, and last payment date.
  3. Select the patients who should receive a letter.
  4. Review the letter template shown on the screen.
  5. Choose to either:
      • Include the letters in the statement file that will be generated in the next section, or
      • Print the letters immediately to a PDF for separate distribution.
  6. Repeat the steps for any additional letters.

NOTE: An automatic nightly process reassesses patient accounts for dunning. Refer to the Dunning Configuration section in Patient Accounting for more details.

Figure 1.1: The Patient Accounting > Dunning Messages Selections

Step 3: Close the Accounting Period

This step should be restricted to authorized users only.
1. Once all steps above are complete, navigate to Hospital Accounting > Accounting Periods. (See
Figure 1.2 and Figure 1.3)

Figure 1.1: The Patient Accounting > Dunning Messages Selections

Figure 1.3: The DataCapture Accounting Periods Screen

2. Click Close This Period. Closing the accounting period triggers two events: the general ledger
export and the generation of guarantor-based statements. Continue with the steps below.

Step 4: Generate the General Ledger Export

NOTE: Ensure that transaction codes used during posting are linked to general ledger
accounts. For more details, go to Hospital Accounting > Settings > GL Crosswalk (see
Figure 1.4), or refer to the “DataCapture Financial Administrative Settings Guide.”

Figure 1.4: The GL Crosswalk Tab
1. Access the report in the Accounting Periods screen by selecting the recently closed period from
the Select Period drop-down list. (See Figure 1.5)
Figure 1.5: The Select Period Drop-Down List
2. After selecting the accounting period, the export options become available. (See Figure 1.6)
Figure 1.6: The Accounting Periods Screen Showing the Export Options

Choose from the following:

  • Export: This option allows you to export the report in your preferred format. Select either
    Export PDF or Export Excel from the drop-down menu. (See Figure 1.7 for the PDF format and
    Figure 1.8 for the Excel .csv format.)
Figure 1.7: Report Columns in PDF Format
Figure 1.8: Report Columns in Excel (CSV) Format
  • Intacct Export: This option allows you to export a report of General Ledger entries to Excel in
    .csv format, which can then be sent to a third-party vendor. (See Figure 1.9)
Figure 1.9: The Intacct Export Report

NOTE: The Intacct report is generated based on the parameters in Hospital Accounting >
Settings > Intact Export General Settings. (See Figure 1.10)

Figure 1.10: The Intacct Export General Settings Tab

Step 5: Generate Guarantor-Based Statements

Statements are generated for all financial classes selected in the Guarantor-Based Statements settings in
the format selected under Guarantor General Settings. The statement file should be available within a few
hours and can be found at Patient Accounting > Monthly Batch Statement. The filename will include the generation date.

NOTE: It is recommended that the accounting period be closed at the end of the month
so that the file is ready the next business day.

Figure 1.11: The Monthly Batch Statement Selection

To add a message to the statements (backside), send the content in a Word document to your project
manager or, for live clients, to support@chartcapture.com.

NOTE: The message will continue to appear on the statements until we are informed to
remove it.

Letters will be loaded as they are received. Aesto Health is not responsible for
grammatical, typographical, or informational errors.

Step 6: Generate Month-End Reports

The pre-built report available is the Aged Trial Balance (ATB). To access:

  1. Navigate to Hospital Accounting > Financial Reports > Aged Trial Balance.
  2. All financial classes and level of care are included by default.
  3. Choose to include/exclude negative and zero balances as needed.
  4. Click Go to view summary totals by financial class, or click Download List to download the detailed list for specific patient account information.
Figure 1.12: The Generate Aged Trial Balance Screen