The Payment Log Report is used to balance and review revenue performance. This report can be generated based on the Transaction Date or Payment Date. This report shows real-time data.
Use Cases
- Run it EOD (End of Day) to review the day’s payment balances.
- Retrieve data based on Transaction Date, Payment Date, or Deposit Date.
Let's get started!
Navigate to the System Menu > select Operational Reports under Insights.
Click the + icon on the left or the Generate Report button on the right for the chosen report.
Explore below to learn more about the desired views, filter criteria, and results.
The summary view shows the consolidation of actions, applied, and unapplied amounts for the particular location selected.
Let us explore the filters:
| No | Filters | Description |
|---|---|---|
| 1 | Date Range (Max 1 Year)* | Choose to focus the report on payments dated within the selected date range (based on your choice of Transaction Date or Payment Date). Select a maximum of up to one year. *By default, the date range will be Today. |
| 2 | Date As* | Choose to run your report based on the Transaction Date or Payment Date. *By default, Transaction Date is selected. Note: If run by Payment Date, refunds are shown by refund date. |
| 3 | Receipt Location* | Choose to focus the report on receipts added to a specific location. *By default, the user's default location will be selected. |
| 4 | Receipt Provider | Choose to focus the report based on the receipt provider(s) you want to see in the report. |
| 5 | User | Choose to focus your report based on the selected user(s) who performed the transaction. |
| 6 | Group Collection By* | By default, Payment Category is selected. The dropdown will have the following options: Payment Category, Payment Type, Receipt Location, Receipt Provider, Payment Method, Payment Source, and None. |
Once you have selected the desired filters, click on the Generate button to generate your on-screen report or Download Report As button to download your report.
Generation/Download Criteria
- Due to data volume, reports with more than 10 Treatment Locations or a date range exceeding 1 Month will not be generated on-screen.
- Reports meeting these criteria will be accessible in the Scheduled Downloads section.
Result - Summary View
Now, let us take a look at the results of the Payment Log Report (Summary View).
- Collected: The amount collected from receipts that were added in the specified date range.
- Updated: The amount which was updated on the receipts during the specified date range.
- Deleted: The amount of receipts that were deleted during the specified date range.
- Total: The sum of the amount collected from receipts that were added/updated in the selected date range.
- Trans. Charge: The amount of transaction charge that was collected from receipts that were added in the specified date range.
- Gross Collection: This will show the gross collection split on each paying entity. If the user deselects any specific paying entity, then that section will be hidden. This section will show the gross collection transaction date for each paying entity and the total.
- Transaction Summary: This section shows the overall utilisation of the collected amount. The actions coming in this section will be Collection, Applied Payments, Refunds, Transfer Receipt, Adjust Off, Provider Adjustment, Overpayment Recovery, Unsettled and Unapplied. If any of the paying entities has a value in any of these actions, the actions will be displayed; otherwise, they will be hidden.
- In the transaction date logic, it will show values based on the transaction date of the action that happened. All the transactions will show the net, i.e., the sum of all created/updated/deleted values.
- In the payment date logic, it will show values based on the payment date of the receipts.
- Collection Adjustments: The total amount of patient and insurance collection adjustments.
- Net Collection: Calculated as the sum of money from patient, insurance and collection agency receipts +/- collection adjustments and refunds.
Exclusions: Income Reduction, Special Credits and Finance Charges.
Inclusions: Transaction Charges, Membership Credit.
Click on the blue-coloured entries to view more information on the corresponding entry.
Let us explore the filters:
| No | Filters | Description |
|---|---|---|
| 1 | Date Range (Max 1 Year)* | Choose to focus the report on payments dated within the selected date range (based on your choice of Transaction Date or Payment Date). Select a maximum of up to one year. *By default, the date range will be Today. |
| 2 | Date As* | Choose to run your report based on the Transaction Date or Payment Date. *By default, Transaction Date is selected. |
| 3 | Receipt Location* | Choose to focus the report on receipts added to a specific location. *By default, the user's default location will be selected. |
| 4 | Receipt Provider | Choose to focus the report based on the receipt provider(s) you want to see in the report. |
| 5 | Payment Category | Choose to focus your report based on the category of payment, whether it was made by cash, check, credit card, and so on. |
| 6 | Payment Type | Choose to focus your report based on the type of payment accepted, whether it was made via Visa, MasterCard, Cash, Check, and so on. |
| 7 | Payment Method | Choose to focus the report based on the method of payment, whether it was Regular, Advanced, Payment Plan, Patient Portal or Payment Portal. |
| 8 | Payment Source | Choose to focus the report based on the source of the payment whether, it was Stripe or None. |
| 9 | Patient | Choose to focus the report based on the selected patients. |
| 10 | Receipt Action | Choose to focus the report on the selected receipt actions. |
| 11 | User | Choose to focus your report based on the selected user(s) who performed the transaction. |
| 12 | Group Collection By* | By default, Payment Category is selected. The dropdown will have the following options: Payment Category, Receipt Location, Payment Type, Payment Method, Payment Source, Receipt Provider and None. |
| 13 | Columns | Choose the columns required in the report. |
| 14 | Show Receipts with Transaction Charges Only | Select this option if you would like to include the receipts with transaction charges. *By default, it will be unchecked. |
| 15 | Show Refunds | Select this option to show Refunds in the report. |
| 16 | Show Remarks | Select this option if you would like to show the remarks against each receipt. *By default, it will be unchecked. |
| 17 | Show updates and deletions from prior receipts separately | Select this option to include updates and deletions from prior receipts as well. |
Once you have selected the desired filters, click on the Generate button to generate your on-screen report or Download Report As button to download your report.
Generation/Download Criteria
- Due to data volume, reports with more than 10 Treatment Locations or a date range exceeding 1 Month will not be generated on-screen.
- Reports meeting these criteria will be accessible in the Scheduled Downloads section.
Result - Collection View
Now, let us take a look at the results of the Payment Log Report (Collection View).
- Transaction Date: The date the transaction was completed in the system.
- Patient ID: The system-assigned number used to identify the patient and their records.
- Patient Name: The name of the patient for whom the receipt was added.
- Default Location: The default location of the patient.
- Receipt #: The system-assigned number used to identify the payment that has been entered into the system.
- Rcp. Location: The location pertaining to the receipt created.
- Payment Date: The date the payment was made, as mentioned in the receipt.
- Payment Category: The category of payment, whether it was made by cash, check, credit card, and so on.
- Payment Type: The type of payment accepted whether it was made via Visa, MasterCard, Cash, Check, and so on
- Payment Method: The method of payment accepted, whether it is Regular, Advanced, Payment Plan, Patient Portal, or Payment Portal.
- Payment Source: The source of the payment, whether it was Stripe or None.
- Ref No.: The reference number entered by your office staff when creating the receipt.
- Created user: The name of the user who created the receipt.
- Applied: The amount applied from the receipt as of the current day.
- Unapplied: The amount remaining as credits in the receipt as of the current day.
- Trans. Charge: The transaction charge amount applied to the receipt, if applicable.
- Payment Amount: The total amount of the payment.
- Receipt Provider: The provider associated with the receipt.
- Spc. Cred. Adj. Code: If the receipt was added with a special credit payment type, the adjustment code is displayed here.
- Action: The action related to the transaction. This column will only occur when the date is selected as the transaction date and shows the transaction action.
- Remarks: Any remarks added by the user regarding the transaction.
Click on the blue-coloured entries to view more information on the corresponding entry.
This view shows the details grouped by each transaction action for patient and insurance payments.
Each section should show the corresponding action based on the selected filters.
- In the transaction date filter, the transaction entries would show all transactions based on the selected date range.
- In the payment date filter, the transaction entries would show all transactions with payment dates based on the selected date range.
Let us explore the filters:
| No | Filters | Description |
|---|---|---|
| 1 | Date Range (Max 1 Year)* | Choose to focus the report on payments dated within the selected date range (based on your choice of Transaction Date, Payment Date, or Refund Date). Select a maximum of up to one year. *By default, the date range will be Today. |
| 2 | Date As* | Choose to run your report based on the Transaction Date, Payment Date, or Refund Date. *By default, Transaction Date is selected. |
| 3 | Receipt Location* | Choose to focus the report on receipts added to a specific location. *By default, the user's default location will be selected. |
| 4 | Transaction Location | Choose to focus the report on specific transactions that happened at a specific location. |
| 5 | Transaction Action | Choose whether to generate the report based on the transaction action like Applied Payments, Refunds, Adjust Off, Unsettled Payment, or Collection Adjustments. |
| 6 | User | Choose to focus your report based on the selected user(s) who performed the transaction. |
Once you have selected the desired filters, click on the Generate button to generate your on-screen report or Download Report As button to download your report.
Generation/Download Criteria
- Due to data volume, reports with more than 10 Treatment Locations or a date range exceeding 1 Month will not be generated on-screen.
- Reports meeting these criteria will be accessible in the Scheduled Downloads section.
Result - Transaction View
Now, let us take a look at the results of the Payment Log Report (Transaction View).
- Transaction Date: The date the transaction was completed in the system.
- Receipt #: The system-assigned number used to identify the payment that has been entered into the system.
- Rcp. Location: The location pertaining to the receipt created.
- Date Of Service: The date of service of the completed code associated with the receipt.
- Procedure Code: The procedure code name along with its description.
- Tx. Provider: The short name of the treatment provider associated with the listed procedure code or receipt.
- Tx. Location: The short name of the treatment location associated with the listed procedure code or receipt.
- Amount: The amount that was involved in the transaction.
- Applied For: The patient to whom this receipt is applied.
- Patient ID: The system-assigned number used to identify the patient and their records.
- User's Name: The name of the user who completed the transaction in the system.
- Remarks: Any remarks added by the user regarding the transaction.
- Refund Date: The date the refund was processed in the system.
- Refund Location: The location where the refund was processed.
- Refund To: Shows to whom the refund was made - Patient or Insurance.
Click on the blue-coloured entries to view more information on the corresponding entry.
Let's explore the filters:
| No | Filters | Description |
|---|---|---|
| 1 | Receipt #* | Choose to focus your report based on the entered receipt number. |
| 2 | Show Transactions* | Choose to focus your report to show the receipt transactions by Entire Transactions or by Transactions Between a certain date range. *By default, the date range will be Today when you select Transactions Between. |
| 3 | Sort By* | Choose to sort the receipt by Transaction Date or by Amount. *By default, Transaction Date is selected. |
Once you have selected the desired filters, click on the Generate button to generate your on-screen report or Download Report As button to download your report.
Generation/Download Criteria
- Due to data volume, reports with more than 10 Treatment Locations or a date range exceeding 1 Month will not be generated on-screen.
- Reports meeting these criteria will be accessible in the Scheduled Downloads section.
Result - Receipt View
Now, let us take a look at the results of the Payment Log Report (Receipt View).
- Receipt Of: The name of the patient for whom the receipt was added.
- Receipt #: The system-assigned number used to identify the payment that has been entered into the system. Click this hyperlink to be taken to the Receipt view.
- Payment Amount: The total amount paid (including the transaction charge).
- Transaction Charges: The amount of transaction charges that were collected from receipts that were added in the specified date range.
- Applied Transaction Charges: The total amount of applied transaction charges.
- Unapplied Transaction Charges: The total amount of unapplied transaction charges.
- Deposit Amount: The total amount deposited.
- Unapplied: The unapplied credits available on the receipt.
- User Name: The name of the user that created the receipt and entered it in the system.
- Location: The location where the receipt is added.
- Receipt Provider: The provider associated with the receipt.
- Payment Category: The category of payment, whether it was made by cash, check, credit card, and so on.
- Payment Type: The type of payment accepted, whether it was made via Visa, MasterCard, Cash, Check, and so on.
- Payment Date: The date the payment was made.
- Created Date: The date the receipt was made.
- Deposit Date: The date the payment was deposited by your office.
- Ref No.: The reference number entered by your office staff member accepting the payment.
- Paying Entity: The entity to whom the receipt is addressed (Patient or Insurance).
- Payment Source: The source of the payment.
- Flexi Pay: Indicates whether the receipt is a Flexi Pay payment.
- Remarks: Any remarks added, if any.
Click on the blue-coloured entries to view more information on the corresponding entry.
The Day by Day Summary View provides practices a daily overview of collections by payment category or payment type.
Let's explore the filters:
| No | Filters | Description |
|---|---|---|
| 1 | Date Range (Max 1 Year)* | Choose to focus the report on payments dated within the selected date range (based on your choice of Transaction Date or Payment Date). Select a maximum of up to one year. *By default, the date range will be Today. |
| 2 | Date As* | Choose to run your report based on the Transaction Date or Payment Date. *By default, Transaction Date is selected. |
| 3 | Receipt Location* | Choose to focus the report on receipts added to a specific location. *By default, the user's default location will be selected. |
| 4 | Show By | Choose whether to show by Payment Type or Payment Category. |
| 5 | Payment Category | Choose to focus your report based on the category of payment, whether it was made by cash, check, credit card, and so on. |
| 6 | Payment Type | Choose to focus your report based on the type of payment accepted, whether it was made via Visa, MasterCard, Cash, Check, and so on. |
Once you have selected the desired filters, click on the Generate button to generate your on-screen report or Download Report As button to download your report.
Generation/Download Criteria
- Due to data volume, reports with more than 10 Treatment Locations or a date range exceeding 1 Month will not be generated on-screen.
- Reports meeting these criteria will be accessible in the Scheduled Downloads section.
Click on the blue-coloured entries to view more information on the corresponding entry.
To enable permissions for the Payment Log Report:
- Navigate to the System Menu > select Practice Settings > Administration > Profiles.
- Click Manage Permissions for the intended profile.
- Select Insights.
- Check Generate Payment Log Report under Operational Reports to enable the permission.
- Click Save.
On the Confirm Action modal that appears, click Yes to proceed.
A toast notification appears on the top right stating, 'Profile updated successfully'.
Practices can use this comprehensive guide to efficiently generate reports, explore various use cases, and apply the necessary filter criteria to generate the desired report. Following this guide will help you create reports quickly, understand the different views available, and customise reports to meet specific needs.