The Accounts Receivable accounting report is a report that will allow you to find all unpaid invoices for a specified service period, regardless of their status. This report is available for customers who are using the OSCAR billing platform in British Columbia.



Running the Accounts Receivable Report

 

To run the report, go through the following steps:

  1. Open your admin panel by clicking on ‘Admin’ (Juno UI) or 'Administration' (Classic UI) at the top of the screen.
    1. If you are using a smaller screen resolution, the ‘Admin’ option in the Juno UI may be located under the ‘More’ menu. Click on ‘More’, then click on ‘Admin’ to open the administration panel.

  2. Click on the 'Billing' tab on the left to expand it, then click on the 'Accounting Reports' link. The ‘Billing Report’ page will open. It looks like this:



  3. On the right, select the following:
  1. Select Account: Select the provider you would like to run this report for.
  2. Report Type: Accounts Receivable
  3. Start & End Date: Start and end service dates. Note that running the report over an extended period may slow the EMR down for other users. We recommend running the report in smaller increments (a few months) to avoid negatively impacting the clinic’s EMR experience.
  4. Insurer: 
    • For provincial claims, select MSP, WCB and ICBC only.
    • For private claims only, select only Private. 
    • Select all four options if you want to see all invoices. 
  1. Click on the 'Create Report' button. 


The EMR will generate the report results and prompt you to download a file that you will open to see the results.


Reading the Aged Accounts Receivable Report


The results are divided by claim statuses which makes it easy to get an overview of what is going on with your invoices. The report will look like this:

 

 

  1. Date and time – Date and time the report was run at for easy reference.

  2. Account – Name of the provider associated with the claims in this section of the report.

  3. Insurer (Header) – Insurers selected when the report was run.

  4. Insurer (Column) – MSP, WCB, ICBC or private, based on the insurer selected on the claim.

  5. Patient – Name and demographic number of the patient associated with that claim.

  6. ServDate – Service date for this specific claim.

  7. Invoice/ - Invoice number as listed internally by the EMR. This is not the sequence number from Teleplan.

  8. 91 Days+ – Unpaid invoices that are more than 90 days old.

  9. 61-90 Days – Unpaid invoices that are between 61 and 90 days old. These claims are nearing the 90 days mark after which they may not be paid. If you are tight on time, start with handling these!

  10. 31-60 Days – Unpaid invoices that are between 31 and 60 days old.

  11. 0-30 Days – Unpaid invoices that are between 0 and 30 days old.

  12. Status – Claim status with, when applicable, the message code(s) received from MSP for rejections and PwEs (Paid with Explanation).

  13. Section Total – Each status section is totaled separately.

  14. Grand Total – You will also find a grand total on the last page of the report.