Reports Reporting Suite
This article describes the Reports Reporting Suite. Learn about formatted reports, data tables, and analysis grids, and how to use the reporting tool. You can use the Reports Reporting Suite to generate and customize reports.
For the majority of our reports, the reporting data updated within 30 minutes behind real-time data, excluding the reports listed below. Our data refresh times for all other reports are listed below.
Reporting Data Is Real-Time
- Appointment Daily Summary – Analysis Grid
- Daily Office Procedures – Analysis Grid
- Daily Payment – Analysis Grid
Reporting Data Is as of the End of the Previous Day
The end of the previous day is the day before at 11:59 p.m. Pacific Time.
- Adjustment dashboard report
- AR Service Line – Analysis Grid
- Charges dashboard report
- Location Month End Performance – Analysis Grid
- Monthly Financial Summary – Analysis Grid
- Provider Month End Performance – Analysis Grid
- Payer Month End Performance – Analysis Grid
- Resident Encounter Multiple Tabs – Analysis Grid
- Resident Encounter Single Tab – Analysis Grid
- User Productivity – Analysis Grid
Reporting Data Is Generated Monthly
- AR Roll Forward by Payer
- AR Roll Forward by Provider
- Copay Deficit
- No Show and Cancellation
- Practice Month End
- Unbilled Appointments
Note about Created Date
In reports run by created date, the created date reflects the user’s computer’s time zone. In cases where a different time zone leads to a different day (e.g., biller and practice are in different time zones), you must change the user’s computer’s time zone to generate the correct date.
|Charge-based Reports||Reflect the data available in the on-screen ledgers. These are point-in-time reports, resulting in different values for the same time period when generated at different points in time. Use these reports to review service line information (e.g., Procedure Code, Date of Service, Charge Amount, Adjustments, etc).
|Payment-based Reports||Reflect the payment-level details viewable in Payments pages. Payment reports are best suited for balancing to the bank account as they include all payments posted (e.g. applied, unapplied, insurance, patient, capitation, etc). Charge-based and Transaction-based reports only reflect applied payments. These are point-in-time reports, resulting in different values for the same time period when generated at different points in time (note: if the payments from the prior time period are not edited the amounts will not change).
|Transaction-based Reports||Reflect all AR balance-changing events (e.g., charge activity, apply/unapply payments, write-offs, etc.). For balancing purposes, it is important to understand transaction reports only report the activity of applying and unapplying payments from a claim. The amounts do not change when comparing reports for the same time period at two different points in time when reporting by the transactions Created Date or Ledger Date if the month has been closed.
|Combination Reports||There are various types of combination reports available (e.g., Monthly Financial Summary, Practice Month End, and Goals). Reports are combined from different categories to help consolidate important data.
Reporting data is as of the previous day or is generated monthly.
|How do I know which report category the report is?||After selecting the Report Name in the reporting tool, the description text indicates if the report is a charge, payment, transaction, or combination report. If the description does not indicate any of these, it is a combination report.|
To Navigate to Reports
From the Practice Management menu bar, hover your cursor over Reports and click Reports. The reporting tool opens in a new tab. Depending on your browser configuration, you may have to accept pop-ups.
To Select a Report
- From MediTouch Reports page, select a Report Type.
- Select a Report Name. The filters that display below depend on which report is selected.
- After you select a report name, a description of the report displays next to the report type.
- The source of the report data and/or the report’s purpose displays next to the report name.
- Note: Reports from different sources will not necessarily align (e.g., the charge amount in charge ledger reports by created date will not always match the charge amount in ledger transaction reports).
All accounts receivable (AR) summary reports (Report Type = Accounts Receivable) are formatted reports. Formatted reports are printable and not designed to be manipulated in Excel.
- To save the report as a bookmark, click Save Bookmark
- To export the report, click Excel or PDF.
- To create a report, click Generate Report.
You can select a different reporting period and regenerate data. Note: The reporting period is not required on the Reports home page for AR summary reports. Therefore, if you do not select a reporting period on the home page, this option will not available on the report page. Date Type remains the same as what was selected previously.
Data tables are essentially read-only on-screen spreadsheets that can only be exported.
- Contain a limited number of columns so that they are printable.
- Have predetermined grouping and totaling (e.g., charge amount).
For greater control over the data generated into a report, select the analysis grid equivalent of the report (e.g., use the Transaction Details – Analysis Grid instead of the various transaction summary data tables).
- To save the report as a bookmark, click Save Bookmark.
- To export the report , click Excel, CSV, or PDF.
- To create the report, click Generate Report.
You can select a different reporting period and regenerate data. Date Type remains the same as what was selected previously.
The advantage of an analysis grid over a data table is the ability to manipulate the data to customize the reports.
- Analysis grids have more columns available.
- Columns are movable.
- Includes a number of great tools to customize the data
Save Bookmark and Export Options
- Export Report: Click Excel, CSV, or PDF to export everything that is on the page (e.g., table and chart) to an Excel, CSV, or PDF file.
- : Exports only the table or report information that is on the panel to an Excel, CSV, or PDF file. Click and then select the file type from the menu.
- You can select a different reporting period and regenerate data.
- Date Type remains the same as what was selected previously.
- Click Generate Report.
Table Configuration Options
There are two sets of table configuration options, enabling you to customize reports.
- Advanced configuration options:
- Formula: Adds columns using formulas.
- Filter: Filters the rows by the cell values.
- Add Chart: Creates a chart based on the report’s data.
- Add Crosstab: Creates a pivot table by pivoting columns of data into rows of data.
- Basic configuration options (click to show):
- Columns: Hides and shows columns.
- Sort: Sorts the table.
- Group: Organizes the rows by grouping columns.
- Aggregate: Calculates multiple data rows based on specific criteria to form a single value.
- Paging: Sets the number of rows displayed per page.
Use formulas to add columns to the report.
- Click Formula.
- Enter the name for the column.
- Select from the menu to individually insert column names into the formula and then click Insert.
- Enter mathematical symbols to complete the formula.
- Select the Data Type.
- Select the Data Format.
- Click Add. The new column displays.
- To replace an existing formula with a new formula, click Replace instead of Add.
- To remove a formula, click Remove.
Note: Replacing or removing a formula also deletes the column from the report.
The new column also displays under Columns.
- Click Filter.
- Select the Filter Column.
- Select the Comparison.
- Select the Value.
- Click Add.
- To replace an existing filter with a new filter, click Replace instead of Add.
- To remove a filter, click Remove.
- If you have more than one filter, additional options display.
- To reorder the filters, click the up and down arrows.
- To remove parentheses from, or add parentheses to, the filter equation, click the minus or plus icons.
- To insert Add or Or to the filter equation, click the Add/Or toggle button.
Produce a chart based on data in the table. Create a new chart or edit the existing chart. Our example is for a pie chart.
- Click Add Chart.
- Click the desired chart type.
- Select the Label Column.
- Select the Data Column and select whether to show percentage or value.
- Select the Data Aggregation.
- Select the Relevance.
- : Shows or hides the chart menu panel.
- : Removes the chart.
Like the Chart option, the reporting tool generates a crosstab based on what is displayed in the table. Create a new crosstab or edit the existing crosstab.
- Click Add Crosstab.
- Click the Header Values Column.
- Select the Label Values Column.
- Select the Aggregate Values Column.
- Select the Aggregate Function.
- Select the Summary Function.
- : Shows or hides the crosstab menu panel.
- : Exports the crosstab into an Excel or CSV file.
- : Removes the crosstab.
Columns is the default selection.
- Select the check box(es) for which table columns to display.
- Click OK.
Note: We have set default columns for each analysis grid. The default columns depend on which analysis grid you generate.
- Click Sort.
- Select the Data Column.
- Select the Order Direction.
- Click Add.
- To replace an existing sort with a new sort, click Replace instead of Add.
- To remove a sort, click Remove.
- Click Group.
- Select the Grouping Column. In this example (Date of Service), select year, quarter, month, or day; else, it will group by day.
- Click Add.
- To replace an existing group with a new group, click Replace instead of Add.
- To remove a group, click Remove.
- Click Aggregate.
- Select the Data Column to calculate for.
- Select the Aggregate Function (calculation to perform). Depending on which data column is selected, the aggregate function options change.
- Select the Results Positioning (where the result will display). If you have more than one aggregate, the last position you selected will apply.
- Click Add.
- To replace an existing aggregate with a new aggregate, click Replace instead of Add.
- To remove an aggregate, click Remove.
- Click Paging.
- Click Show all rows or Show paging.
- If you choose paging, enter the number of rows per page to display.
- Click OK.
Column Heading Configuration and Formatting Options
You have a limited number of configuration options accessible from the column heading. Formatting options are only available here.
Note: For illustrative purposes, both the Aggregate and Format select menus are displayed. They normally are shown individually upon selection.
- Click the column heading.
- Select an option from the pop-up menu.
- Bookmarks are shared across the practice. You only see bookmarks for reports that you have permissions to.
- Bookmarks are currently unavailable for enterprise users.
- Date span selection is important for bookmarks to be used properly. You must select the dates using the drop-down options (e.g., last month) on the Reports home page.
- To access the bookmarks, click View Bookmarks.
- To save your report as a bookmark, click Save Bookmark.