Virtual account collection cost allocation · Calculation guide

Allocate shared collection costs to one virtual account group.

Calculation guide

Allocate the shared platform charge by transaction count, then add that group’s own per-receipt and account fees. Use one billing period.

cost = shared*receipts/total+accounts*accountfee+receipts*item · overhead = shared*receipts/total · direct = accounts*accountfee+receipts*item

Inputs

Shared platform charge

Example entry 600 (in the selected currency).

All platform receipts

Example entry 1000. Use whole numbers.

Group receipts

Example entry 250. Use whole numbers.

Group virtual accounts

Example entry 5. Use whole numbers.

Fixed fee per group account

Example entry 4 (in the selected currency).

Group fee per receipt

Example entry 0.2 (in the selected currency).

Worked example

InputValue
Shared platform charge600
All platform receipts1,000
Group receipts250
Group virtual accounts5
Fixed fee per group account4
Group fee per receipt0.2
ResultValue
Allocated cost for group220
Group share of platform charge150
Group direct charges70

Calculation steps

Allocated cost for group = ((((Shared platform charge × Group receipts) ÷ All platform receipts) + (Group virtual accounts × Fixed fee per group account)) + (Group receipts × Group fee per receipt))

((((600 × 250) ÷ 1,000) + (5 × 4)) + (250 × 0.2)) = 220

Group share of platform charge = ((Shared platform charge × Group receipts) ÷ All platform receipts)

((600 × 250) ÷ 1,000) = 150

Group direct charges = ((Group virtual accounts × Fixed fee per group account) + (Group receipts × Group fee per receipt))

((5 × 4) + (250 × 0.2)) = 70

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Shared platform charge600660Allocated cost for group220235
All platform receipts1,0001,100Allocated cost for group220206.363636
Group receipts250275Allocated cost for group220240
Group virtual accounts56Allocated cost for group220224
Fixed fee per group account45Allocated cost for group220225
Group fee per receipt0.21.2Allocated cost for group220470
Virtual account collection cost allocation →