Card versus bank transfer collection cost · Calculation guide

Compare the cost of collecting the same invoices through two channels.

Calculation guide

Use the same successfully collected invoices. Include reconciliation overhead for bank transfers. Ignore reversals and settlement timing.

saving = sales*rate/100+count*(card-bank)-admin · cardcost = sales*rate/100+count*card · bankcost = count*bank+admin

Inputs

Amount collected

Example entry 20000 (in the selected currency).

Number of collections

Example entry 100. Use whole numbers.

Card percentage fee

Example entry 2 %. Allowed range 0 to 100.

Card fixed fee per receipt

Example entry 0.2 (in the selected currency).

Bank fee per transfer

Example entry 0.5 (in the selected currency).

Bank reconciliation overhead

Example entry 60 (in the selected currency).

Worked example

InputValue
Amount collected20,000
Number of collections100
Card percentage fee2%
Card fixed fee per receipt0.2
Bank fee per transfer0.5
Bank reconciliation overhead60
ResultValue
Saving with transfer310
Total card cost420
Total transfer cost110

Calculation steps

Saving with transfer = ((((Amount collected × Card percentage fee) ÷ 100) + (Number of collections × (Card fixed fee per receipt − Bank fee per transfer))) − Bank reconciliation overhead)

((((20,000 × 2) ÷ 100) + (100 × (0.2 − 0.5))) − 60) = 310

Total card cost = (((Amount collected × Card percentage fee) ÷ 100) + (Number of collections × Card fixed fee per receipt))

(((20,000 × 2) ÷ 100) + (100 × 0.2)) = 420

Total transfer cost = ((Number of collections × Bank fee per transfer) + Bank reconciliation overhead)

((100 × 0.5) + 60) = 110

How each input affects this example

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

InputOriginal inputNew inputAffected resultOriginal resultNew result
Amount collected20,00022,000Saving with transfer310350
Number of collections100110Saving with transfer310307
Card percentage fee2%3%Saving with transfer310510
Card fixed fee per receipt0.21.2Saving with transfer310410
Bank fee per transfer0.51.5Saving with transfer310210
Bank reconciliation overhead6066Saving with transfer310304
Card versus bank transfer collection cost →