Add-In for Microsoft Excel: Transactions Report

Last updated
Save as PDF

Updated: 07/26/2023 | Views: 4121

While the Add-in for Microsoft Excel offers several types of data to query, one of the recommended types of data to query is Transactions. The Add-in reports on many transactions (e.g., Charge, Patient Statement, Payment Applied) that occur in the Desktop Application (PM) which allows System Administrators to run reports specific to those transactions. Reporting on transactions support and provide further details on standard in-app reports and also allows for further analysis of key metrics. For optimal performance of the Add-in, it is recommended to limit the data returned due to the large volume of transactions captured within the report.

Generate Transactions Report Open an Excel document > click Add-ins on the top menu bar. The available add-ins display. Click Kareo and select New Query from the drop-down menu. The Select Data to Query window opens. Select Transactions. Click Next. The Select Fields to Return window opens.
Select the desired fields to return. Click and drag to select multiple fields or hold down Ctrl while clicking the left mouse button to select or deselect individual fields. Click Next. The Select Parameters and Run Query window opens.
Click the Select a Parameter drop-down arrow and select Type. Enter one desired Value then click Add to Query. Continue to add query parameters such as a date range to limit the records returned. Note: It is recommended to limit the data returned due to the large volume of transactions captured within the report. To clear a specific parameter, select the parameter listed under the Query Parameters section then click Clear Selected. To clear the entire list of parameters under the Query Parameters section, click Clear Query. Click Finish. The report generates.

Transaction Types

The below table provides a short description of each available Value that can be entered when adding the transaction type as a parameter. The Value must be entered exactly as shown below in order to return results.

Value	Description
Adjustment	An amount written off from the original billed charge amount.
Charge	A service line of an approved encounter that contains the procedure code and charge amount.
Charge Note	A user-created note in the transaction log of a claim.
Electronic Claim	A claim submitted electronically to payers.
Paper Claim	A claim printed from the Desktop Application (PM).
Patient Note	A user-created note entered in the Notes section (also known as patient journal notes) on the General tab of the Patient record.
Patient Statement	A statement sent to the patient to notify of assigned financial responsibility.
Patient Statement Note	A user-created note added on the Account tab of the Patient record to include on a statement.
Payment Applied	A patient or insurance payment posted and applied to a date of service.
Payment Received	A patient or insurance payment record created in Tebra.
Reopened	A previously settled claim that has been reopened.
Settle	A reconciled claim.
Transfer	A reassignment of financial responsibility of the billed charge from one entity to another (e.g., from primary to secondary insurance, from insurance to patient).