Insurance Claim Submission and Tracking

Insurance billing in a BC clinic is not one system — it is four or five systems with different submission mechanisms, different timelines, and different consequences for missing a deadline. Jane App handles direct billing to most Canadian extended health plans cleanly. ICBC’s HCPP portal and WorkSafeBC’s Teleplan work differently, and AFU (Autism Funding Unit) adds a monthly submission cycle with a hard deadline. Without a single tracker and automated deadline reminders, claims slip through, payments get delayed, and resubmissions eat the time you saved by submitting early.

This workflow builds the infrastructure that Jane doesn’t provide: a central Airtable tracker, n8n automation to pull session data, deadline reminders that fire before the window closes, and a monthly reconciliation routine that catches discrepancies before they become write-offs.

The stack

Jane App ($79–$149/month) is the practice management platform this workflow is built on. Jane handles direct billing to most Canadian extended health insurers natively. The workflows described here extend Jane’s billing capability into the portals Jane cannot reach directly.

Heidi Health ($99/month) generates ICBC progress reports and WorkSafeBC functional summaries in the exact formats those portals expect. The clinical content comes from the in-session assessment; Heidi structures it into the report. Running Heidi for insurer reports costs less per month than writing one report by hand.

Airtable (free to $20/month per user) is the tracker. A single base tracks every insurer claim across the practice: claim number, insurer, submission date, status, expected payment date, and follow-up date. Multi-practitioner clinics get a shared view by therapist; solo practitioners use a filtered personal view. Airtable is preferred over a shared spreadsheet because it supports automations, structured views by status, and rollup fields that produce a monthly reconciliation summary without manual calculation.

n8n on OVH Canada VPS (~$15 CAD/month) is the automation layer. It pulls session data from Jane, formats it for submission templates, populates Airtable records, and triggers calendar reminders. Anything touching patient names, claim numbers, or session dates stays on Canadian infrastructure. Don’t use Zapier or Make here — no BAA, US servers, and any PHI-adjacent flow through either is a PIPEDA problem.

Google Docs or Airtable templates serve as the claim template layer for ICBC and AFU submissions. Because neither ICBC’s HCPP portal nor the AFU’s ICM Service Provider Portal has a public API, the automation covers everything upstream of the actual portal entry: pre-filling the template, staging it for submission, and confirming after the clinician has submitted.

How it gets wired

Extended health (Jane-native): Jane handles direct billing to most Canadian extended health plans. No external workflow is needed beyond confirming the patient’s insurer at intake and keeping Jane’s billing codes current.

ICBC HCPP (manual portal, workflow-assisted): The HCPP portal has no public API. The workflow is:

1. After each ICBC session, Jane records the session with the ICBC file number tagged.
2. An n8n workflow running on the Canadian VPS pulls the session data daily and pre-fills an ICBC claim template in Google Docs with session date, treatment codes, and clinician details.
3. The clinician reviews the pre-filled template, makes any corrections, and submits through the HCPP portal.
4. After submission, the Airtable record is updated with claim number, submission date, and expected payment date.
5. If a claim is rejected, Airtable captures the rejection reason and a follow-up date is set. A calendar reminder fires 48 hours before resubmission is due.

WorkSafeBC Teleplan (Jane-supported, fax required): Jane supports Teleplan billing. The clinical report requirement — faxed within 7 days of the initial assessment — is outside Jane’s billing flow. The workflow:

1. Jane sends the Teleplan billing claim as usual.
2. Heidi Health drafts the clinical report from the in-session assessment notes.
3. The clinician reviews and approves the Heidi draft.
4. The report is faxed within the 7-day window. A calendar reminder fires at day 5 to ensure the window doesn’t close.
5. Airtable logs the fax date and the claim status.

AFU (monthly cycle, deadline-driven): The AFU program ends March 31, 2027. BC is replacing it with new disability benefit programs; new authorization structures and service codes are expected in Q3 2026. Any tracking system built now should be designed for a planned migration by Q3 2026.

Today’s AFU workflow:

1. Each AFU-funded session is tagged in Jane with the client’s AFU file number and session service code.
2. A monthly n8n workflow running on the Canadian VPS pulls that month’s tagged session data from Jane and formats it for the AFU submission template.
3. The Airtable log records each submission: client name, file number, amount claimed, submission date, and approval status.
4. Calendar reminders fire 5 business days before the monthly submission deadline so nothing goes in at the last hour.
5. After approval, Airtable updates the record with the approved amount and payment date, feeding the monthly reconciliation.

Monthly reconciliation: On the first business day of each month, an n8n workflow generates a reconciliation summary from Airtable: claims submitted, claims approved, claims pending, claims rejected, and payments received against expected amounts. Any discrepancy between submitted and received triggers a follow-up task. This routine turns a scattered quarterly catch-up into a 20-minute monthly review.

Compliance posture

This workflow processes patient names, claim numbers, session dates, and funder file numbers. All automation must run on Canadian infrastructure. The OVH Canada VPS (Beauharnois, Quebec) is ISO 27001 and SOC 2 Type II certified and falls outside US CLOUD Act jurisdiction. n8n is self-hosted on that VPS with no data transiting non-Canadian servers.

Airtable stores claim metadata, not clinical notes. Clinical content stays in Jane. If your clinic is on Microsoft 365, Power Automate inside the Canadian M365 tenant replaces n8n and the VPS — it is included in Business Standard, handles PHI-adjacent data within the Canadian tenant, and removes the VPS administration requirement.

The ICBC HCPP portal and the AFU ICM portal are accessed by the clinician directly. Automation populates templates and manages the tracking layer; no automated system submits to government portals on your behalf. The clinician reviews every submission before it goes in.

Common pitfalls

• WorkSafeBC’s 7-day clinical report window is a hard deadline. Missing it delays payment and can result in the claim being denied. Set the calendar reminder at day 5, not day 7.
• ICBC claim rejections that don’t get resubmission dates in Airtable get forgotten. The Airtable automation should create a follow-up task automatically on any rejection so that nothing relies on the clinician remembering to return to it.
• AFU submissions that go in without cross-referencing Jane’s session tags against the client’s remaining fund balance create approval problems. Add a fund balance column to the Airtable view and confirm available balance before each monthly submission.
• The AFU program ends March 31, 2027. Clinics that build the AFU workflow without planning for migration will need to rebuild the tracking logic under whatever authorization structures BC’s replacement programs introduce. Build the current workflow with clean separation between AFU-specific fields and the general claim tracking structure so the migration is a modification, not a rebuild.
• n8n workflows that pull Jane session data rely on Jane’s data structure remaining stable. When Jane releases an update that changes field names or export formats, the n8n workflows may break silently. Schedule a monthly check of workflow logs to catch failures before a month of session data goes untracked.

When this is worth the setup

The tracking and automation layer described here is worth building for any clinic billing to two or more of the four systems (extended health, ICBC, WorkSafeBC, AFU). The overhead of managing four different submission cycles manually, with different deadlines and different consequences for error, produces steady claim leakage — rejected claims not resubmitted, 7-day windows missed, AFU deadlines caught late. At $95–$180 per session, three to five missed or written-off claims per month justifies the setup investment inside the first quarter.

For a solo physio or OT seeing 20 patients per week with a mixed ICBC and extended health caseload, the monthly time recapture on claim prep and follow-up typically runs 3–5 hours. For a multi-practitioner clinic, the Airtable shared view and monthly reconciliation replace a manual tracking spreadsheet that someone is currently updating inconsistently. The setup is most valuable at clinics where insurance admin is currently untracked, partially tracked in a spreadsheet, or delegated to a clinician who is also seeing patients.