A mispriced compound claim can trigger a denial or an audit. This pharmacare compound costing worksheet is the practical tool pharmacists and pharmacy managers use to price compounded prescriptions for provincial plans and private payers. This guide walks through what to gather, how to calculate each line on a worksheet, how to apply overhead and tax, and how to submit or document the claim for Canadian provincial programs in 2026. Examples use common assumptions, $45.00/hr labour, 15% overhead and a 5% waste factor, with clear, step-by-step math so the worksheet matches audit requirements and payer rules.

Quick-reference summary

Use this checklist before you start a pharmacare compound costing worksheet:

  • Find the correct provincial form: BC uses Form HLTH5425; Manitoba lists pharmacare forms on its Pharmacare pages. See official pages at canada.ca and provincial sites below.
  • Collect invoice prices for all ingredients in CAD, container costs, and any single-use equipment costs (syringes, filters).
  • Record labour: total compounding minutes and the pharmacist/technician wage ($/hr). Example wage used below: $45.00/hr.
  • Apply overhead, common practice is 10-20% of ingredient + labour costs; this worksheet uses 15% in the worked example.
  • Add applicable sales tax: federal GST is 5%; provincial rates vary (BC PST 7% as of 2026, MB PST 8%).
  • Enter any plan-specific dispensing or compounding fees; list patient copays separately.

Basically, important official links: Federal pharmacare overview: https://www.canada.ca/en/health-canada/services/drugs-health-products/pharmacare.html. BC pharmacare forms and guidance: https://www2.gov.bc.ca/gov/content/health/practitioner-professional-resources/pharmacare. Manitoba Pharmacare forms: https://www.gov.mb.ca/health/pharmacare/forms/index.html.

Prerequisites

Before you fill a compound costing worksheet collect these items. Missing any will slow approval or reimbursement:

  • Full ingredient list with supplier invoice prices (CAD per unit), lot numbers, and expiry dates. Audit-ready invoices dated within the supplier's invoice period are required.
  • Exact quantity used for this prescription and any overage/waste factor (usually 5-10%). Many pharmacies use 5% for liquids and 10% for powders or transfers; note the factor on the worksheet.
  • Container and closure cost (e.g., amber vial, syringe, lid) per finished unit. Record both purchase unit price and per-dispense price. Example: 30 mL amber vial cost $0.95 each when bought in boxes of 100.
  • Actual compounding time in minutes and the hourly wage for the person compounding (pharmacist or pharmacy technician). Use inclusive wage (benefits and payroll burden) where possible, example total labour rate used below: $45.00/hr.
  • Pharmacy overhead percentage (rent, utilities, equipment amortization). Many pharmacies use 10-20%; this worksheet uses 15% as a clear example and documents how overhead is applied.
  • Any plan-specific rules: maximum allowable compound fee, list of reimbursable ingredients, whether GST/PST is payable on the label, and accepted claim method (electronic vs paper). Check plan bulletins for the current year 2026 limits.
  • Record-keeping plan: note where you’ll store batch log, time sheet, invoices, and the completed worksheet. Keep scanned copies and physical originals where required by provincial college rules.

Step-by-step: complete the worksheet

  1. Start with identifying info. Enter pharmacy name, licence number, prescriber, patient name or plan ID (only the plan ID if privacy rules apply), date compounded, and the provincial plan (BC, MB, etc.). Note the worksheet version and date, 2026 worksheets often require the fiscal year or form version on top.
  2. List ingredients and invoice prices. For each ingredient, create columns for ingredient name, supplier, pack size, invoice unit price (CAD), quantity used, and extended cost. Example lines:
    • Base cream 100 g tub, invoice $3.50 per 100 g, quantity used 30 g, prorated cost $1.05
    • Active API powder, invoice $120.00 per 10 g, quantity used 0.3 g, prorated cost $3.60
    Add a waste/overage row (e.g., 5% of total ingredient cost). If total ingredient cost = $4.65, 5% waste = $0.23.
  3. Container and single-use supplies. Add the per-dispense cost for the vial, closure, syringe, filter, and label. Example: amber vial $0.95, cap $0.10, label $0.05 = $1.10 total.
  4. Calculate labour. Enter compounding time in minutes. Convert to hours by dividing minutes by 60 and multiply by hourly wage. Example: compounding time 12 minutes = 12/60 = 0.20 hr. Labour cost = 0.20 × $45.00/hr = $9.00. If two staff worked (tech + pharmacist oversight), allocate minutes between roles and use the appropriate hourly rates.
  5. Apply overhead. Sum ingredient costs + container + labour to get subtotal. Multiply by overhead percentage. Example: ingredients $4.88 (including waste) + container $1.10 + labour $9.00 = $14.98 subtotal. Overhead at 15% = $2.25.
  6. Add dispensing or compounding fees. Some plans allow a fixed compounding fee or dispensing fee. If plan lists a $12.50 compounding fee per claim, enter it here. If not, leave blank but document a local policy for patient charging or private billing.
  7. Apply taxes. Calculate GST (5%) on taxable items. Note: in most provinces, prescription drugs and clinically necessary compounds are GST-exempt, but accessories and some supplies may be taxable. Where PST applies (BC 7% in 2026, MB 8% in 2026), add it only to taxable portions per provincial guidance. For the worked example assume supplies are taxable. Tax example: GST 5% × ($1.10 + $2.25 + $12.50 compounding fee) = computed tax amount, list taxes separately on the worksheet.
  8. Final total and patient copay. Sum subtotal + overhead + compounding/dispensing fees + taxes to get total claim amount. Then note patient copay or plan deductible applied. Record the amount billed to the plan and the amount collected from the patient.
  9. Attach supporting docs. Staple or digitally attach supplier invoices, time logs (with staff initials), batch log, prescriber authorization, and any plan-specific prior authorization. Sign and date the worksheet. Electronic submissions should reference the scanned files or archive location and include the claim reference number.

Worked example (single-unit cream)

Use these numbers as a clear, printable example. They reflect common practice in Canadian community pharmacies in 2026.

  • Ingredients: base cream prorated $1.05; API prorated $3.60; total ingredients $4.65.
  • Waste factor 5% of ingredients = $0.23; ingredient total = $4.88.
  • Container & supplies = $1.10.
  • Compounding time = 12 minutes; wage = $45.00/hr; labour cost = $9.00.
  • Subtotal (ingredients + container + labour) = $14.98.
  • Overhead 15% of subtotal = $2.25.
  • Compounding fee (plan-allowed or pharmacy policy) = $12.50.
  • Assumed taxable items (supplies + compounding fee) = $13.60; GST 5% = $0.68; PST (BC 7%) = $0.95.
  • Total claim = subtotal $14.98 + overhead $2.25 + fee $12.50 + taxes $1.63 = $31.36. Patient copay recorded separately.
  • Keep a compounding time log with start/stop times and staff initials, it’s the easiest audit item to validate labour lines.
  • Price-match invoice lines to the date of compounding. If the supplier price changed, show the invoice that covers the date of purchase; annotate any prorations so an auditor understands the math.
  • Standardize waste factors for each formulation type (liquid, cream, powder transfers) and document The policy in a short SOP in the pharmacy manual.
  • Label all taxable vs non-taxable components. Provincial tax rules change, as of 2026 GST is 5% nationwide; PST varies by province (BC 7%, MB 8%).
  • When in doubt about a payer rule, call the plan’s adjudication line and make a record of the call including agent name, date, and reference number.
  • Not documenting overage/waste. That single line item explains why ingredient totals exceed theoretical minimums.
  • Using staff base wage only. Forgetting payroll burden (CPP, EI, benefits) underestimates true labour cost, include a modest payroll burden or use a loaded wage.
  • Mixing taxed and non-taxed items without separate tax calculations. That leads to claim denials or provincial auditor adjustments.
  • Failing to attach supplier invoices or batch logs. Many plans deny or delay reimbursement without invoices and time records.
  • Rounding aggressively. Round cents only on the final total; keep line-item math to two decimal places and show work on the worksheet.

Related Articles

A correct pharmacare compound costing worksheet saves time, prevents denials, and protects the pharmacy in an audit. Start with the right provincial form, collect invoices and time records, apply a clear waste factor and overhead percentage, show detailed line-item math, and keep scanned supporting documents tied to each claim. With GST at 5% and provincial PST rates applied where required (BC 7% in 2026, MB 8%), explicit tax lines and documented labour minutes make the difference between quick payment and a request for more information.

This article was created with AI assistance.