Calculation guide
Use the same successfully collected invoices. Include reconciliation overhead for bank transfers. Ignore reversals and settlement timing.
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
| Input | Value |
|---|---|
| Amount collected | 20,000 |
| Number of collections | 100 |
| Card percentage fee | 2% |
| Card fixed fee per receipt | 0.2 |
| Bank fee per transfer | 0.5 |
| Bank reconciliation overhead | 60 |
| Result | Value |
|---|---|
| Saving with transfer | 310 |
| Total card cost | 420 |
| Total transfer cost | 110 |
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.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Amount collected | 20,000 | 22,000 | Saving with transfer | 310 | 350 |
| Number of collections | 100 | 110 | Saving with transfer | 310 | 307 |
| Card percentage fee | 2% | 3% | Saving with transfer | 310 | 510 |
| Card fixed fee per receipt | 0.2 | 1.2 | Saving with transfer | 310 | 410 |
| Bank fee per transfer | 0.5 | 1.5 | Saving with transfer | 310 | 210 |
| Bank reconciliation overhead | 60 | 66 | Saving with transfer | 310 | 304 |
