Review and Prove Out Insurance Payments by Check Number in the Report Library

Coming Soon in PCC 10.1: This feature is currently being tested and is not yet available to all PCC Clients. Stay tuned for additional functionality and release information.

Your practice can reconcile posted insurance payments with two different reports in the Report Library: The Payment Totals by Check Number report displays check totals by date. The Payment Details by Check Number report displays each individual payment on a particular check.

Contents

1 Reconcile Insurance Payment Totals in the Report Library
2 Investigate Payment Details
3 Fix Payments That Were Posted Incorrectly
4 Customize to Display Additional Criteria and Columns
- 4.1 Add Transaction Date
- 4.2 Display Posting Date Column

Reconcile Insurance Payment Totals in the Report Library

After posting insurance and other payments, run the Payment Totals by Check Number report in the Report Library to compare the posted payments with your ERA or EOB.

Open the Report Library

Open the Report Library from the Reports menu in PCC EHR.

Select the Payment Totals by Check Number Report

Select the Payment Totals by Check Number report in the Financial Oversight category.

You can control which users have access to this report. To learn more, visit Restrict Access to Reports in the PCC EHR Report Library.

Choose Report Criteria

Choose the posting date and payment classes that you wish to report on.

Generate the Report

Click the “Generate” button to run the report.

Review the Generated Report

Review your payment data by check number in the generated report.

You can group, sort, or hide columns in the report output. To learn more about working with generated reports, read Run Reports in the Report Library.

Reconcile Payments with the Generated Report

To ensure that all payments are present, compare the generated report with your ERA or EOB.

If the values do not match, make a note of the check number and total on this report, then run the Payment Details by Check Number report (as described in the Investigate Payment Details section below) to compare each individual entry and find the discrepancy.

Investigate Payment Details

When entries in the Payment Totals by Check Number report do not match the numbers on your ERA or EOB, run the Payment Details by Check Number report to see the details for each payment entry.

Select the Payment Details by Check Number Report

Select the Payment Details by Check Number report in the Financial Oversight category.

You can control which users have access to this report. To learn more, visit Restrict Access to Reports in the PCC EHR Report Library.

Choose a Posting Date Range

Use the drop-down, date fields, or calendar icon to choose a posting date.

Posting Date is the date that the payment was entered into PCC.

Search for the Check Number

To search for your check number, choose a search method and enter some or all of your check number into the search field.

The search can be broadened or narrowed as needed.

Contains: searches for checks that contain your entry in any part of the check number.

Equals: searches for only an exact match with your entry.

Starts with: searches for check numbers that start with your entry.

Ends with: searches for check numbers that end with your entry.

Set Payment Class

Set the payment classes that you want to include on your report.

Generate the Report

Click the “Generate” button to run the report.

Compare Posted Payments with the Generated Report

Locate the data that you need and compare the generated report with your ERA or EOB amounts to ensure that all payments and charges are present and correct.

You can group, sort, or hide columns in the report output. To learn more about working with generated reports, read Run Reports in the Report Library.

Unlinked Payments Display with No Patient Name: Patient and PCC number do not display on this report when a payment is unlinked, such as with insurance takebacks.

Fix Payments That Were Posted Incorrectly

As you review these reports, you may find payments that were posted incorrectly.

Use either the Payments tool or the Insurance Payments tool in PCC EHR to review and edit an individual account’s full payment history. For more information, read Review Payment History and Edit Personal Payments.

Prove Out Daily: If you catch and correct mistakes on the same day as they were posted, the dates on your proving out reports will match cleanly when you run by posting date.

Customize to Display Additional Criteria and Columns

You can further organize your output by customizing your report and altering criteria.

Add Transaction Date

Both of these reports run by posting date as the default. To add the transaction date to either of these reports, customize your report, click “Select Criteria”, then select “Transaction Date”.

Once selected, the transaction date will display in the customization screen and on the generated report output.

Display Posting Date Column

To display the posting date column on the Payment Totals by Check Number report, customize your report, click “Edit”, then select “Posting Date”.

Once selected, the Posting Date column will display on the generated report output.

To learn more about creating a custom report, read Create a Custom Report.

Here are some related articles in Billing and Practice Management > Get Started in Billing and Practice Management:

Pediatric Practice Oversight Reporting with PCC
You can use PCC reports to identify problem areas in your A/R, review collections, and evaluate your growth as a practice. The tables below show PCC’s recommended reporting tools for practice oversight on a daily, weekly, monthly, and annual basis.
Review Posted Charges In Daily Check
The Daily Check program (dailycheck) lists all the visits posted on a single day or range of days. The report includes every diagnosis, procedure, amount charged and payment posted. Use dailycheck to review a day's postings.
Post a Returned Check or Other Personal Payment Reversal
When a check bounces, or a credit card payment is stopped, you can quickly reverse the payment in the Payments tool in PCC EHR. You can optionally post a fee, in accordance with your office's financial policy.
What is a Claim ID Number?
Every insurance claim in your PCC system has a unique identification number. The number appears in various reports and programs, and you can use it to improve claim tracking and payment posting.
Review Personal Account Balances
The Collection Report (coll) explains an account's current balance and recent payment history. If a family does not understand why they owe money, run coll. It can also help you determine whether or not an account has been making regular payments against their outstanding balance.
Post Personal Payments and Write Off Charges
Learn how to post personal payments in PCC. When a family pays their bill, you can enter their payment, link it to charges, and optionally enter account notes.
Refund Personal Credits
When you need to refund a personal credit to a family, you can post a refund adjustment.
CARC and RARC Values in PCC
When insurance carriers send payment and adjustment information, either on an EOB or an ERA, they often include a code with a small message. These codes are known as CARC values, or Claim Adjustment Reason Codes, and they are an industry-wide standard.
Reverse an Insurance Payment (Post a Takeback)
From time to time, insurance companies will ask you to reimburse them for an overpayment. Sometimes, the company will ask you to send them a refund check. Sometimes, they will underpay you for more recent charges in order to make up for the overpayment on an old charge.
Accounting Challenges
The medical biller's job would be easier if accounts paid on time and insurance companies reimbursed the correct amount. Unfortunately, accounts build up balances and credits and insurance companies overpay, underpay, and demand "takebacks."
ERAs and EOBs with PCC
After a payer reviews your electronic claim, they will send your practice an explanation of what charges are paid, adjusted, or denied. On paper, this information arrives as an Explanation of Benefits (EOB) and a check. The electronic version of an EOB is called an Electronic Remittance Advice, or ERA. An ERA usually arrives in coordination with a direct deposit to your practice's bank account. You can use PCC software to post payment and adjustment information from both ERAs and traditional EOBs.
Post Insurance Payments and Adjustments
Automatically post ERAs sent to your practice. If a payor's response requires direct attention (or you receive a paper EOB), you can manually post the payments and adjustments.
New User Training for Billers
Use this new user training outline to learn how to complete billing tasks in PCC.
Reconcile Payments and Prove Out at the End of the Day
You can quickly and easily reconcile payments that your practice has posted in PCC EHR. Run the Payment Reconciliation report in order to prove out, checking against your cash drawer and records at the end of the day or the end of your shift. Open the Payment Reconciliation report from the Report Library in PCC […]
Post Charges
As you post charges, you can review and update patient information (like insurance eligibility), double-check the linking and codes that the clinician selected, and post any payments received.
Post Charges in PCC EHR
Watch this video to learn how to review encounter information and post charges for an appointment in PCC EHR.
Schedule, Chart, and Bill a Telemedicine Visit
Learn how to schedule, chart and bill a telemedicine visit with PCC.
Bill for Phone Encounters and Portal Messages
After you complete a phone note or portal message thread in PCC EHR, you can bill for the encounter right in PCC EHR.
Schedule, Chart, and Bill a Telemedicine Encounter
Schedule a telemedicine appointment with optional video connection information and then chart and bill the visit using PCC EHR. Patients and families will see telemedicine information in the portal, and billers will have everything they need to post charges and queue up a claim.
Analyze and Respond to COVID-19’s Impact in Your Dashboard
Use the COVID-19 section of your Practice Vitals Dashboard to track and analyze the impact on your practice. Along with details on your practice's charges, payments, and visit volume, you'll find recommendations and links to more resources.
Work with a Patient’s Billing History in the Chart
You can review all of a patient's billable encounters in the Billing History section of a patient's chart.
Post Personal Payments and Write Off Charges
Watch this video to learn how to post any personal payment in PCC EHR. Along the way, learn about Account Notes and bad debt write-offs.
Manually Post Insurance Payments and Adjustments
Learn how to manually post insurance payments and adjustments in PCC. Along the way, you can change the copay due on a charge and use PCC EHR's components to work with policies, demographics, and account notes. After posting, you can review payment histories and edit or delete the payments.
Review Payment History and Edit Payments
You can review payment history by encounter, or see all payment history for an account. You can also edit payments that were posted incorrectly and adjust how payments are applied to charges. Read below to learn how.
Review Payment History and Edit Personal Payments
You can review payment history by encounter, or see all payment history for an account. You can also edit personal payments that were posted incorrectly, or that are linked to the wrong charges.
Print a Receipt
You can print a receipt whenever you post a payment. You can also print a receipt for any payment(s) in an account's history.
Print a Receipt
You can print a receipt whenever you post a payment. You can also print a receipt for any payment(s) in an account’s history.
Post a Returned Check or Other Personal Payment Reversal
Learn how to post a returned check, stopped credit card payment, or other payment reversal in PCC EHR.
Refund Personal Credits
Learn how to refund personal credits in PCC EHR.
Reverse an Insurance Payment (Post a Takeback)
When an insurance company or other payer reverses a payment, also called a "takeback", use PCC EHR's Insurance Payments tool to quickly reverse the payment and post the new adjudication information for the claim.
Write Off Charges and Bad Debt
When you want to write off a charge that is unrecoverable ("bad debt"), or post other account adjustments that reduce the amount due for a charge and decrease an account's outstanding personal balance, use the Payments tool.
Post Capitation Checks, Incentive Payments, Interest Payments, Overpayments, and Withhold Payments
Learn how to record capitation checks, incentive payments, insurance interest payments, payment amounts that exceed the amount due on a charge ("Overpayments"), and end-of-year withhold payments
Read ERA 835s from Payors
When payors adjudicate a claim, they send your practice an Electronic Remittance Advice (ERA), also known as an 835 file. PCC receives these ERAs and you can review them in the Electronic Remittance Advice tool.
Post Less-Common Payments
Learn how to record capitation payments, incentive payment, insurance interest payments, withhold payments, and overpayments in PCC EHR.
Read ERA 835s from Payors
When you need to review the insurance company's full response to a claim submission, how do you open and work with the ERA 835 file in PCC?