Running Financial Reconciliation Reports

Running Financial Reconciliation Reports

Any User(s) with the "Reconciliation" tab enabled in the "Back Office" > "Financial" module can run Financial Reconciliation Reports. Please see "Setting Up Financial Reconciliation Rights" for details. Most practices utilize this feature at the end of every business day, although PatientNOW allows practices to choose any date range. 

Any User designated as a "Financial Admin" will receive the Financial Reconciliation Report Summary as a .PDF file for review. See "Setting Up Financial Reconciliation Rights - 'Financial Admin' " for how to set up a user to receive Financial Reconciliation Reports.

As you work through this article, expand any images by clicking on the image.

Page Layout

To view the Financial Reconciliation page: 

1. Click the "Back Office" module from the menu on the left.
2. Click the "Financial" sub-module.
3. Click the "Reconciliation" tab on the top right.

  1. Payments Received: The center section displays the Amount Collected by Payment Type. This is where users will enter the Amount Counted at the end of each day/week/desired date period.
  2. Sales Generated: The bottom section displays Sales Generated divided by specific Procedures and Products.
  3. Totals: The right section displays Total Sales divided by type (ie. Procedure, Product, Memberships, etc.)

Step 1: Choose the Date(s) to Review

1. Navigate to "Back Office" > "Financial" > "Reconciliation."

2. The date range will automatically show today as the "From Date" and "To Date." To select a different date range, use the appropriate dropdown arrow to select a different "From Date" and/or "To Date."

2a. To select a single date, choose the desired date for both "From Date" and "To Date." 

3. Click "Refresh Values" to update the "Payments Received" section.

Optional: Select Service Facility and/or User

The default selection is "All Facilities" and "All Users." However, to run a report on a specific facility, a specific user, or both:

1. Use the dropdown menus to select the desired facility and/or user.

Select Service Facility

Select User

2. Click "Refresh Values" to update the "Payments Received" section.

Step 2: Count the Payments/Drawer

With the desired selections, the totals for each payment type will appear in the "Payments Received" section.

1. Add up the receipts/checks/cash and enter the counted amount in the "Amount Counted" column next to the appropriate payment method. The line will turn white when the "Amount Collected" and the "Amount Counted" match. 

2. If the Amount Collected and the Amount Counted do not match, the lines will remain red and display the Difference. Notes may be written in the "Reason" text box to the right.

Step 3: Verify and Submit Reconciliation

Once all appropriate numbers have been entered into the "Amount Counted" column, and any necessary notes have been entered into the "Reason" text box, the Financial Reconciliation is ready to be submitted.

1. Verify the Grand Total, Amount Collected, Amount Counted, and Differences, and check the necessary "Verified" boxes. 
2. Click "Submit Reconciliation" to send the Financial Reconciliation Report to all Financial Admins.

3. When the Financial Reconciliation Report has been Submitted, a success message will appear. Click "OK" to close.

The Financial Reconciliation Report

The Financial Reconciliation Report is generated as a .PDF file. Below is an example:


The PatientNOW Financial Reconciliation allows practices to review all Sales made on a particular date or date range. Reports may be run on:

  1. A specific Service Facility
  2. A specific User
  3. A specific Service Facility AND specific User.
Any User designated as a "Financial Admin" will receive the Financial Reconciliation Report Summary as a .PDF file for review. See "Setting Up Financial Reconciliation Rights - 'Financial Admin' " for how to set up a user to receive Financial Reconciliation Reports.

    • Related Articles

    • Setting Up Financial Reconciliation Rights

      PatientNOW has updated its Financial Reconciliation process, making it easier to close out at the end of the day/week, as well as providing more details into payments received. See "Running Financial Reconciliation Reports"  to learn more about ...
    • Reviewing Reports

      Reports that the doctor shares with the client are available in the  Education Content area at the bottom of the home screen. A list of the reports is in the My Reports screen of the app. Clients can tap the report and see the doctor's notes, see the ...
    • Sharing Reports from the Website

      For the Doctor Doctors can share reports from the RX portal website. From a client's record, select the photos you want to share, click the blue button second from the bottom: generate report.  ​ The photos are in one tab. Click the Blocks tab to add ...
    • Sharing Reports from the App

      For the Doctor To create a report to send to the client, go to the client's photo area and select the photos to include in the report. Then tap Share Via RxPortal. Tap Add Comment to add notes and treatment recommendations. When finished, tap Done. ...
    • RxPortal - Overview List of Tutorials

      For the Doctor                                             The Doctor's App Overview Video Doctor's Tutorials Inviting a Client to RxPortal Sharing Forms with Client Submission Pending Status Sharing a Completed Form with the Client Photo Uploaded by ...