Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents
minLevel1
maxLevel7

Definitions

Customer: A customer may interact with multiple clinicians and also purchase products.

  1. A customer is not considered to be owned by any clinician

Services: Therapy services provided by clinicians

  1. clinician rates are decided by the clinic (in consultation with all clinicians that provide each service)

  2. Clinicians earn % (or $ value) set by service category

Products : Physical products sold that may be shelf stock or made to order

  1. Clinicians earn from services they provide

Products

  1. Some clinicians may earn from services provided by clinicians they supervise

...

Practitioners

...

Employee

...

Sessions Revenue

...

Products made up on site or provided by practitioner

...

Products from shelf stock - commissions

...

Packages Sold

...

Rent

...

Naturopath

...

no

...

100%

...

100%

Commission to clinic 10%

...

yes

...

Weekly or Daily

...

Practitioner 1

...

yes

...

$ per treatment

...

yes

...

yes

...

Practitioner 2

...

no

...

100%

...

100%

Commission to clinic 10%

...

yes

...

Weekly or Daily

Employee setup for a Practitioner

...

PAYE

  1. Hours worked

  2. Hours Sick / AL / Etc

Contractor

Needs a Debtor Record to hold the contract details

...

  1. % (or $ value) set by product category

Suppliers: Earn commission by providing services

  1. An individual may be a supplier

  2. A Company may be a supplier

  3. A supplier is linked to a commission plan

Types of Clinicians

  1. Clinicians may be employees

  2. Clinicians may be contractors

  3. Clinicians may be room renters

    1. They may provide subcontractor clinicians as representatives

  4. A Company may be a room renter

    1. All Clinicians are Representatives

Representatives

Representatives have a relationship with another supplier that gets paid for their work

They have a Relationship of type “Contractor”

  1. Parent supplier is the entity that gets paid ( a person or a company)

  2. Child is the Therapist (person)

Therapists earnings

Commission Setups

Note: Therapists that are Representatives do NOT have a separate commission plan

Each Supplier is linked to a commission plan. The commission plan enables

  1. Commission by product or service category

  2. Commission by product brand

  3. Commission by individual SKU

The commission plan is setup with a sequence which is used to determine the % to apply. The commission plan works down from lowest sequence to find the % applied and stops once one is found.

Note:

  1. Cancellation fees can be put in a separate service category if different commission plans treat them separately

  2. Sessions that are cancelled or missed need to be ticked “Therapist paid for missed session” to be included

    1. Room renters - this is ticked by default

    2. Contractors and Employees that are NOT Room Renters

      1. Therapist paid for missed session is:

        1. NOT ticked by default

        2. AND when ticked requires notes in Therapy notes (of what they were doing)

Example product sale

  1. VITC Product in “Vitamins” category and Brand “ClearAndNatural”

  2. Commission plan

    1. Seq 10 = VITC (Product) = 25%

    2. Seq 20 = ClearAndNatural (brand) = 12%

    3. Seq 30 = Vitamins (category) = 5%

  3. The result would be 25% - the first commission found that the product falls into

Example Cancelled Session - Deposit Retained

  1. Session Service “Therapy1” in product Category “HandsOn” with brand “Premium1”

  2. Cancellation Fee Service “Cancellation fee” in product category “CancelFees” and no brand

  3. Commission Plan

    1. Seq 10 = Premium1 (Brand) = 85%

    2. Seq 20 = HandsOn (Product Category) = 50%

    3. Seq 30 = CancelFees (Product Category) = 45%

  4. The result would be 85% of the deposit retained + 45% of the cancellation fee

When is commission earned

Commission calculations can be run anytime and will find any bookings that commission has not yet been paid

Earnings are based only on completed services or sales

  1. Session delivered and paid for

  2. Session missed or cancelled (if session ticked “Therapist Paid for Missed Session”)

  3. Products paid for and provided

Active sessions are NOT considered completed

Value of commission earned

Commission calculation is based on Commission plan linked to the supplier AND the sessions linked to the therapist.

Room Renters

Room renters are considered to be running their own business from the venue

They typically expect a high % of all items including cancellation fees

  • Remember to ensure the cost of credit card transaction fees is recovered

Contractors

Contractors are providing a service

They typically expect a medium % or amount per item

Employees

Employees are typically paid some incentive (perhaps $ or % ) of sessions and prescriptions

Concierge Employees

Admin employees commission plans include all services or products that DO NOT have a linked therapist AND

  1. Services > they were the sales person on the original booking made

  2. Products > they were the sales person on the sale

Example

  1. Services with no therapist - ie Sauna

  2. Products that were not prescribed - eg books or off the shelf vitamins

Setup of a Therapist

Each Therapist will be setup as an Employee so they can login to the system and use the Therapist Portal

...

Commission Plans

Therapists or companies that get paid commission need a Creditor Record - with link to a commission plan.

...

Example commission plan

...

Contractor via another entity

The entity needs a Supplier Record with linked commission plan

The Person Needs a link to the entity they are contracted to

...

Relationship Type Setup

This is a special relation type of “Contractor”

...

Therapists that need to be paid commission

Therapists payments

  1. A % commission on services completed from zero to 100%

    1. BUY GL account from the service sold

  2. A % of prescribed products sold

    1. % of RRP - Many products are standard stocked products

      1. Sell GL account from Stock Article > otherwise from Control Account “Cost of Sales”

    2. Some products are special (not stocked) created on the day

      1. Sell GL account from Stock Article > otherwise from Control Account “Cost of Sales”

Testing your setup

  1. Commission plan examples

    1. Examples for therapists

    2. Examples for Admin staff

  2. Suppliers

    1. Company example

      1. Therapists related to the company as SubContractors

    2. Individual examples

      1. Therapist

      2. Admin Staff

    3. Individual supplying subcontractors example

    4. Therapists related to the individual as SubContractors

  3. Rosters setup

    1. Rosters for the therapists

    2. Rosters for admin staff

  4. Book Sessions

    1. Sessions with a therapist

    2. Sessions with no therapist

  5. Complete sessions

    1. Complete some with full final payment

    2. Complete some using bulk buys

    3. Complete some using Bundle buys

    4. Complete some with deposit retained

    5. Complete some with deposit credited or refunded

    6. Complete some missed or cancelled with cancellation fee

Full Test

Completed session

Cancelled session and “Therapist Paid for Missed Session”

Missed Session and “Therapist Paid for Missed Session”

Prescribed products on completed session

non prescribed products

Company A

Representative Therapist

Representative Therapist

Representative Therapist

Representative Therapist

Individual with subcontractors

Therapist

Representative Therapist

Therapist

Representative Therapist

Therapist

Representative Therapist

Therapist

Representative Therapist

Individual therapist

Therapist

Therapist

Therapist

Therapist

Admin Staff

On original booking order as Sales Rep

On Order as Sales Rep

Journals on Session Completion as basis

Completed session journals to customer that are included in commission calculations - include GREEN cells

Therapists receive based on being the therapist on the session AND where prescribed products were purchased at checkout.

Admin staff receive based on being the sales rep on product sales AND being the sales rep on original booking orders.

Sessions > Admin and Therapists may double dip - ie both be paid for the same session

Products > Admin and Therapists do NOT double dip - if a therapist is paid then ADMIN is not paid

Values this could be

DR

CR

Service

  • RRP = normal sale

  • bulk buy price

  • bundle price

  • Deposit (if cancelled or missed and only deposit retained)

$ Value

Deposit

Deposit amount if taken

$ value

Discount

Discounted % or amounts

$ Value

Cancellation Fee

$ Value

$ value

product Sale

$ value

Business Flow Diagram Example

Gliffy
imageAttachmentIdatt890175497
macroIde5233c49-c42a-425c-85c6-e3c9ff688140
baseUrlhttps://saasplications.atlassian.net/wiki
nameClinic money flows
diagramAttachmentIdatt890208271
containerId890044417
timestamp1669689244655

Example Customer journal from above

GL account

CR

DR

Link

Description

Revenue from service

$100 = total charge

Session 1

Therapy session 1 charge

Deposits Paid

$50 = deposit paid earlier

Session 1

Session 1 deposit Credit

Product Revenue

$50 = created product

Session 1 Created Product

Created product in session 1

Revenue from service

$200 = total charge at bundled price

Session 2

Therapy session 2 charge

Deposits Paid

$200 = amount of bundle used

Session 2

Session 2 Bulk Purchase Credit

Product revenue

$85 = total

Session 2 prescribed product

Prescribed Product session 2

Deposits Paid

$90

Future booking deposit

Future booking deposit

Deposit paid

$50

Future booking request

Future booking Deposit

Practitioner Reconcilation Journal above

item

GL Account

CR

DR

Employee

Therapy session

(% of session)

Buy GL account from service

$100 x % (less supervisor % )

Session 1 Therapy charge % commission from product category less % for supervisor

% of sales

Created Product

Buy GL account from service

$50 x % (less supervisor % )

Created Product % from product category less % for supervisor

% of sales

Stocked Product

Buy GL account from Stock article or GL control account

$85 x % (less supervisor % )

Stocked Product % from product category less % for supervisor

% of sales

Therapy session by supervised therapists

Buy GL account from service

$N x %

Where N is the $ Amount of the Therapy the person I supervise provided to others.

% as supervisor

Therapy session ($ per session)

Buy GL account from service

$ per session

when not on commission but on $ per session

$ per session