Pharmacy Supplier Invoice Reconciliation After Receiving

Pharmacy supplier invoice reconciliation checks whether the bill agrees with accepted stock, agreed prices, tax treatment and related credits. It starts after receiving has established what arrived.

An invoice can balance mathematically while still charging for rejected packs or using the wrong pack size. A promised credit also needs its own path to completion.

The workflow below is a practical recommendation for Australian community pharmacies. Use your supplier terms and accounting procedures for payment decisions and seek accountant review of uncertain tax treatment.

Start with the accepted receipt

Collect the purchase order, accepted receipt, invoice and any existing discrepancy record. Add the agreed price list or quotation and relevant supplier correspondence.

Check the supplier account, pharmacy entity, order reference and invoice number. Look for duplicate invoices or a replacement document that could otherwise be entered twice.

Use the accepted quantity as your comparison point. Preserve the quantities delivered, accepted, rejected and still pending as separate fields, with the receiving decision attached.

Our stock receiving checklist covers inspection, quarantine and placement. Reconciliation uses that evidence to settle the financial record.

A stocktake checks physical stock against recorded stock. It cannot establish whether a supplier has billed the agreed price or applied a credit.

Make invoice and receipt units comparable

Write down the unit used by each document before comparing quantities. A carton, retail pack and individual tablet are different units, even when the product description matches.

Keep the supplier product code, exact product, pack size and conversion together. If the mapping is unclear, ask for clarification before treating the line as matched.

Financial check	Compare with the invoice	Action when it differs
Accepted quantity	Receipt quantity in the billed unit	Document the shortage or excess charge
Pack conversion	Packs per carton or units per pack	Confirm the conversion and recalculate
Product substitution	Actual accepted product and pack	Check approval and the agreed replacement price
Partial delivery	Receipts already linked to this order	Separate received stock from the outstanding order
Charges and discounts	Agreed freight, fees and price terms	Request an explanation or correction
Existing credit	Original invoice and credited lines	Check that the same difference is not claimed twice

For illustration, suppose a toiletries carton contains six retail packs. The invoice bills twelve cartons, while the accepted receipt records eleven.

That means 72 packs billed and 66 accepted. The quantity difference is six packs, not one retail pack.

At an illustrative price of $8 per pack before GST, the original line is $576 and the disputed difference is $48 before GST.

These invented figures explain the conversion, not typical pharmacy prices or discrepancy rates. Keep the original invoice and record the requested correction alongside it.

Confirm price, substitutions and extra charges

Compare the billed price with the agreement that applied to this order. Check whether a discount was already included before requesting it again.

For an accepted substitution, match the invoice to the replacement product rather than the original description. Record who approved the commercial change and which price was agreed.

Leave medicine suitability decisions with qualified staff and local pharmacy procedures. Invoice reconciliation records the financial consequence of the accepted decision.

Check freight, minimum order charges and other adjustments separately. Do not spread an unexplained fee across product lines just to make the total agree.

Record the invoice due date and disputed amount. Have the authorised payment owner decide the next step under the supplier agreement, including any proposed partial payment.

Check GST for the supplier transaction

GST treatment follows the supply being checked. A retail medicine exemption does not automatically make the pharmacy’s purchase of that medicine GST free.

The ATO’s pharmaceutical guidance treats wholesaler drug supplies to pharmacists as taxable.

Section 38-50(7) limits that medicine exemption to human use and supply to an individual for private or domestic use.

Check each supplier line and charge using the confirmed purchase tax treatment. Ask the accountant to resolve unclear classifications rather than copying a shelf or retail tax code.

ATO tax invoice guidance requires mixed invoices to identify taxable items and show GST and the total payable.

For sales of $1,000 or more, the tax invoice also needs the buyer’s identity or ABN. Check that the named entity matches the pharmacy’s purchasing entity.

Track the credit through to application

Create a discrepancy record with an owner, supporting documents, disputed quantity and amount, supplier reference, next action and follow up date.

Use clear states such as raised, supplier reviewing, agreed, document received, applied and closed. An agreement to issue a credit is different from receiving one.

When the credit arrives, compare its product, quantity and amount with the agreed resolution. Record any partial credit as partial rather than closing the whole case.

Check the tax effect with the person responsible for the accounts. The ATO’s adjustment note ruling describes the required reason, adjustment effect, GST change and price difference.

A commercial credit note’s title alone does not establish its GST treatment. Ask the accounts owner whether the documents meet the relevant requirements and which accounting period applies.

Before closure, confirm:

• the correction or credit matches the agreed resolution
• the accounts record reflects the approved treatment
• the supplier statement shows its application, or a refund has been confirmed
• any returned or replacement stock has its own completed receipt record
• any remaining difference has an owner and next action

Keep the original evidence and the resolution together. Government record guidance generally requires most business records for five years, starting from receipt or completion, whichever is later.

Some records need longer retention. Confirm the applicable period rather than deleting the case as soon as its balance reaches zero.

Use resolved cases in supplier reviews

Review open balances, repeated pack mapping problems, disputed charges and credits awaiting application. Separate unresolved allegations from confirmed differences.

An illustrative monthly supplier review could cover invoice lines checked, confirmed discrepancies, outstanding credit value and time from agreement to application. This cadence is a suggestion, not a benchmark.

If you calculate a discrepancy rate, define its denominator and period. A supplier with more deliveries should not appear worse simply because its raw case count is higher.

Bring specific examples to the supplier and agree the next process change. Connect the findings with inventory cost reviews without assuming a quantified saving.

A bounded KSafe pilot discussion

KSafe owns inventory, invoices, receipts, batches, shelves, stocktakes and discrepancies within KSuite. KSuite and all its modules are in pilot.

For a reconciliation pilot, we would define the receipt evidence, financial discrepancy owner and closure test. Confirm the agreed pilot functions before relying on any invoice workflow.

To discuss that scope, book a demo. Our pharmacy automation overview explains the broader operational context.