Other Accounting Reports

Date: Aug 15, 2001
Author: Norine Bevan and Greg deJong
Enhancement: n/a
Bug Fix: n/a
Skill Level: advanced

Description

MediFile© includes a variety of accounting reports in a module where the reports can be greatly customized. This separate module is currently being developed such that reports will be able to be saved and run at a later time and date; however, at the time of this technote, the reports can only be run manually.

This technote is an excerpt from the Accounting Reports chapter of the MediFile Instruction Manual.

Detail

Unlike monthly reports, these other reports can be narrowed down to a specific date range. Billing, payment, and/or adjustments can be reported not only within an accounting month (or range of accouting months), but also with respect to the date of service, date last sent, or date billed/paid/adjusted (depending on the report type). As well, the reports are organized by area account, with a ‘sub-total’ line for each.

You can begin working with these other reports by clicking the Other Reports button in the Administrator’s Corner. This brings up the Scheduled Accounting Reports window, as shown next.

This window displays options for customizing a report’s date range, using a custom date criterion, the type of report to create, and the area account(s) to include.
By default, a report will include records from the selected accounting month range – the accounting month(s) enveloping the Start and End dates. However, there are alternate date criteria for the reports:

• Date of Service
• (Date) Last Sent
• Date Billed/Paid/Adj(usted)

Each of the above three items is available as a radio button, just above the Reports to Create and Accounts lists. By selecting one of these options, the report will include records within the specific dates chosen, for the associated date field.

Once you have selected one of these custom date criteria, you would have to exit the window and return to it to start a report without any of the options – which reverts the date criterion to be based on the accounting month(s).

Report Sections

For every report, you will get three sections, each starting on a new page:

1. Direct billings (patient was billed)
2. Electronic agencies
3. Third party billings (this is by default anything that does not fit into direct or electronic)

If there are no items for any one of these sections, that section will not be printed; in other words, no empty reports will be printed. Each report is printed with a heading that identifies the date range and criterion.

The types of reports available are:

• Billing Rpt Summary
• Billing Rpt Detail
• Payment Rpt Summary
• Payment Rpt Detail
• Current Adjust Detail
• Current Adjust Summary
• Past Adjust Detail
• Past Adjust Summary

Other reports may be available in your MediFile©, visible in the Reports to Create list, however only the reports listed were complete at the time of this technote.

You can generate more than one type of report at a time by selecting any combination of the items in the Reports to Create list. As with other lists of this style, items marked with an X will be generated.

Please note the following table, that shows which date criteria can be used with each report type. A cell marked ‘No’ mean that the criterion cannot be used for a report of the corresponding type; if you select a criterion that cannot be used with the report type, the report will revert to the default (accounting month) setting.

Detail or Summary

The report(s) you choose to generate can be a full listing of records (“detail”), or just a list of totals by area account (“summary”). The report name indicates which of these styles it will be.

Area Accounts

Remember to select any single (or combination of) area account, according to which of these you want included on the report.

Remember, all reports are sorted by area account, with a ‘sub-total’ line for each.

Report Butler

This feature is not yet functional. As the Other Reports module is enhanced, you will be able to configure reports and then send them to a separate computer, a Report Butler, for processing.

Running the Report

Once you have all the desired options set, click the Run Now button to generate the report(s).

Electronic Agencies in Detail Reports

When you are generating a Detail report, you still have the option of printing only a summary of electronic agencies, as opposed to a full detail listing which can be quite extensive.

You will get the following alert, which lets you determine which option to take.

Click Cancel to print a summary-format report of electronic agency records; or, click OK to use the detail format. The direct and third-party records will still be formatted according to the selected report type(s), whether detail or summary.

Print Options

After you specify which format to use for electronic agency reports, you are presented with your computer’s standard print options dialog.

You may wish to verify these settings based on which printer and printing options to use. To run the report(s), click OK.

Sample Reports

Here are some samples of printed reports, demonstrating a few different permutations of options. Below each sample is a listing of the columns of information shown.

Billing detail by accounting month for third party billings:

• Facility
• Agency
• Fee Code
• Amount
• Surname
• Time
• Serv. Date
• Subtotals and Total

Billing summary by accounting month for third party billings:

• Subtotals and Total

Billing summary by accounting month for electronic billings:

• Subtotals and Total

Past adjustment detail by accounting month for direct patient records:

• Facility
• Agency
• Fee Code
• Bill Adjustment Amount
• Surname
• Invoice
• Payment Adjustment Amount
• Subtotals and Total