Step-by-step guide for clinic staff
Download this from your TPA panel portal (AIA, MiCARE, Red Alert Online, Health Connect, or PMCare). It is an Excel file (.xlsx or .xls) that shows which patients the panel has paid.
Not sure how to download? See our Panel Download Guides
Export this from your clinic system (e.g. Clinisys). It is your clinic's list of panel claims — showing each patient visit, the amount billed, and whether it has been paid.
Must be in .xlsx format (Excel). Download Clinisys AR Export Guide (PPTX)
After you log in to ClaimHub, look at the left sidebar menu. Click "Check my claims" (or "Reconcile" on the website version).
Choose the panel that matches your payment report file. For example, if you downloaded the report from AIA's portal, select AIA.
Click "Choose File" and select the Excel file you downloaded from the panel portal. A green confirmation message will appear showing the file name.
Click "Choose File" again and select your AR file from Clinisys (or your clinic management system). This file shows your clinic's panel claims.
Enter the date when your clinic received the payment from the panel. You can find this date on the payment advice letter or bank statement.
Once all 3 items are filled in (panel type, both files, and date), click the blue "Process Reconciliation" button. Wait a few seconds — do not close the page.
You will see this while it processes:
When processing is done, you will see a green success message showing how many claims were matched.
Click "View Detailed Results" to see the full breakdown and download the reconciliation report as an Excel file.
On the results page, click the "Download Report" button to save the reconciled Excel file. This file shows:
You can also go to "Past Runs" in the left menu anytime to find and re-download previous reports.
Make sure you are uploading an Excel file (.xlsx or .xls), not a PDF or Word document. If the panel portal gives you a PDF, try RedAlertOnline or Health Connect panel type — they accept PDFs. For other panels, you need to download the Excel version from the portal.
The file is too big. This usually happens if the date range in your AR export is too wide. Try exporting a smaller date range (e.g. 3 months instead of 1 year).
This means the claim was in your AR file but not found in the panel payment report. The panel has not paid for it yet. You should follow up with the panel company.
Currently, you process one panel at a time. For example, do AIA first, then Micare, then PMCare. Each run takes about 5-10 seconds.
Click "Past Runs" in the left menu. You can view and re-download any previous reconciliation report from there.
If you are using the desktop app (downloaded installer), everything runs on your computer — no internet needed after activation. Your data never leaves your PC.
Not necessarily. Make sure the date range in your AR file matches the panel payment period. Some TPAs split payments across months. Try narrowing the date range in both files.
This shows as "Partial". The difference could be co-payment, deductible, or items not covered. Check the report for the exact difference and contact the panel if it seems wrong.
Click "Top up credits" in the left menu to purchase more. Payment is via online banking (FPX) and credits are added instantly. If the doctor needs to approve the purchase, send them the link — they can top up from their phone in under 2 minutes.
Click "Process Another File" on the results page. Your previous result is saved in "Past Runs" — it won't be lost.
Check: (1) Did you select the correct panel type? (2) Did you upload the right files in the right slots? (3) Do the files actually contain data? Open them in Excel to verify.