Missing RA Rawfile

Providers with missing remittance-advice rawfiles from Missing RA / ALL_CLINIC.xlsx.

Report Scope

The end date defaults to the Report Generator's cycle end date for the month, or its last Thursday

ALL_CLINIC

Not Ackd

Unacknowledged claims aggregated from Not Ackd / ALL_CLINIC.xlsx (Billings/Not Ackd exports).

Month End Dates

Defaults to the Report Generator's cycle end date, or the month's last Thursday — editable

ALL_CLINIC

Did Doctors Not Bill

Compares claims from the past 3 months in ClinicAid against Daily Volume. Latest Clinic Export: loading… Last Scan Time: unavailable

Scan Scope

Choose one report month or the past 3 consecutive months

Volume vs ClinicAid Unique Patients

Not started

Third Party Privates

Bluecross and WSIB invoices classified from each clinic’s -Private.csv exports for the selected report month and two preceding months.

Report Scope

Loading latest report month…

Private Insurance Invoices

Volume

All clinics A–Z from the Volume bucket. Zero-volume days are omitted; weekly and monthly averages (light red / green) sit on top of the appointment count.

Clinic Volume

Report Generator

The Report Month indicates the billing cycle — notice the MOH has pre-determined start and end dates for each report month.

Missing configuration

Checking rawfiles and reports…

Generate Reports

idle — set a cycle and click "Generate Report".

Generated Reports

browse the reports bucket
📄
Select a file on the left to preview it here.

Referral Invoice Generator

Build a referral invoice from existing physician earning reports. Pick the billing cycle + clinic, choose which physicians to bill, and the invoice is rendered straight from each report's Total Billed figure.

Invoice Setup

idle — pick a cycle, clinic, and at least one physician.
Bill-to override (auto-filled from each report's clinic info if blank)

Line Items

pick a clinic to load physicians.
Bill Physician Total Billed Referral Amount Source PDF
No physicians loaded yet.
Total $0.00 $0.00

Rawfile

Browse the juno-rawfiles bucket. Click a folder to drill in; click a file to download via a short-lived signed URL. Drag files onto the browser to upload them into the open folder.

Files

bucket root
📄
Select a file on the left to preview it here.

Clinic Info

Physician Info

Physician Configuration

Physician Special Rules

Fringe / case-by-case overrides used by the report generator. Leave Physician blank to apply the rule to every physician at the clinic.

Default Hours

Only physicians with the guarantee model are displayed.

Special Hours

One-off guarantee-hour overrides for a specific date. Used by the report generator instead of Default Hours when present.

Email Templates

What physicians and clinic owners receive when reports are sent. Send Email starts from the default template.

Email Log

Every email is a ticket. Failed sends and replies waiting on us need attention; everything else is resolved.

Ticket State Recipient Subject Details Activity