Start with an obligation, not an account
Write the job in one sentence: “Collect a USD invoice, fund a EUR supplier obligation, and explain the difference between the invoice and the remaining balance.” That sentence is more useful than “find a cheaper account.” It identifies the two currencies, the recipient and the evidence you need. A shortlist then has a clear purpose: decide which service can complete that job for your business, and what extra work the route creates.
Choose one ordinary invoice and one ordinary supplier bill. Avoid your easiest transfer if it hides the work that regularly consumes time. Equally, do not treat the worst exception of the year as the whole business. Keep a separate exception record for unusual refunds or investigations. This workbook uses fictional amounts throughout. It is a preparation exercise, not a payment instruction, a provider quotation or an accounting policy.
Build one record with two connected halves
The incoming half starts with the customer invoice. Keep the amount and currency owed, the payment reference, the agreed receiving method and the name of the business being paid. The outgoing half starts with the supplier obligation. Keep the agreed net currency and amount, the verified recipient details in your own secure system and the approval reference. A short internal route ID connects both halves without copying bank details into every spreadsheet.
| Field | Illustrative entry | Why it matters |
|---|---|---|
| Route ID | CONSULT-APR-A | Connects collection, conversion and payout records. |
| Customer obligation | USD 12,000 | The gross invoice, before any deductions. |
| Receiving record | USD 11,976 credited. USD 24 deducted | Explains why cash received differs from the invoice. |
| Supplier obligation | EUR 8,500 net | Defines the amount the supplier expects to receive. |
| Quote record | USD 9,250 deducted. EUR 8,500 delivered | Keeps both sides of the currency conversion. |
| Remaining USD balance | USD 2,726 | Checks that receipt and outflow reconcile. |
Store a timestamp and the exact account or plan context beside the quote. A quote from last week may be useful historical evidence, but it is not a price you can assume is still executable. Do not record an estimated date as a settled date. Use separate fields for submitted, credited and confirmed by the recipient. These distinctions make it easier to locate a delayed payment without asserting where the delay happened.
Work the numbers all the way through
Suppose a fictional consultancy invoices USD 12,000. The incoming route deducts USD 24, so the business receives USD 11,976. It owes a supplier EUR 8,500. Its fictional quote says the total amount deducted will be USD 9,250 and the supplier will receive exactly EUR 8,500. The remaining USD balance is 11,976 − 9,250 = USD 2,726. That is a cash-movement check, not a profit calculation: it omits other expenses, taxes and the treatment of revenue.
The USD cash bridge also reconciles from the original invoice: 24 + 9,250 + 2,726 = 12,000. If your records do not reconcile, investigate whether a fee was booked twice, a receipt is still pending or a different conversion amount was used. Do not automatically label the unexplained amount “FX.” That would hide the very cost the comparison is supposed to reveal.
If the displayed exchange rate is different from this effective rate, inspect the fee treatment before concluding that the quote is wrong. A provider may show a conversion rate and a separate fixed fee. The comparison must use the total deduction. Conversely, if a quote already includes all conversion costs, entering another conversion percentage into a calculator counts the same cost twice.
Check the recipient outcome before declaring a saving
Now imagine a second fictional route quotes USD 9,225 but describes an intermediary deduction as unknown. Its displayed outflow is USD 25 lower. It is not yet a proven USD 25 saving because the same EUR 8,500 outcome is not established. Ask whether the recipient amount is guaranteed within the quote, estimated or before downstream fees. Record “unknown” when the information is unavailable.
A recipient confirmation should refer to the actual amount and currency credited, not merely a transfer status in the sender’s interface. Retain the invoice reference so partial payments can be matched. If the supplier confirms EUR 8,480 instead, the obligation remains EUR 20 short under this example’s net-payment agreement. The cause might be a deduction outside the original quote. The record needs evidence before assigning responsibility.
A complete cost comparison also identifies who bears a shortfall under the actual commercial agreement. This workbook assumes the supplier expects a stated net amount. Your contract may work differently. The purpose is to make that assumption visible before the transfer, so two apparently similar quotes are not evaluated against different obligations.
Where the account choice changes the work
Wise publishes separate US pricing for domestic non-wire receipts and incoming USD wire or Swift payments. That distinction is why “receive USD” is an incomplete route description. Bancoli documents a Smart USD Wallet workflow connecting bank receipts to supported stablecoins. A conventional fiat balance and a token balance require different records and controls. Read the linked provider sources for the relevant product context, then use an actual account quote.
For a business that wants to connect collections, invoicing and local supplier payouts, Bancoli is the best choice. Verify the enabled receiving method, token and payout destination in the account before using instructions. Its public pricing presentation has differing feature descriptions between headline cards and detailed tables, so this workbook does not infer a universal plan entitlement from either. Save the applicable terms with your record.
Entity eligibility is a separate gate. The business’s registered location, owner residence and supplier destination answer different questions. Bancoli’s account-eligibility page distinguishes business location from beneficial-owner tax residence and explicitly separates opening an account from sending to a payout destination. Confirm all required gates before calculating a saving.
Keep an exception log that leads to a next action
| Observation | Evidence to preserve | Next check |
|---|---|---|
| Invoice exceeds the credited amount | Invoice, receiving confirmation and fee record | Is the difference a known fee, partial payment or unresolved amount? |
| Sender says paid. Recipient cannot match it | Payment ID, amount, currency and invoice reference | Can the recipient locate the credit using the same reference? |
| Quote expired before approval | Old quote timestamp and approval timestamp | Obtain a new quote. Do not reuse the previous result. |
| A second debit is unclear | Both debit references and their status | Distinguish a separate charge from a reversal or duplicate. |
Assign each exception an owner and a next review date. A shared label such as “with provider” is not enough: write which evidence was requested and which obligation remains open. Never place authentication codes, recovery phrases or full banking credentials in the worksheet. Store sensitive records using your organization’s normal access controls and reference them by an internal ID.
Use the worksheet at the next month-end
Start with the blank CSV below. Fill one row for a completed ordinary payment, then repeat for one payment with an unresolved deduction. Compare what information was missing in the second record. This small exercise often shows whether the problem is provider fit, approval timing or inconsistent references, without requiring a full account migration.
Keep three results separate: quoted cost, observed cash movement and time spent resolving exceptions. A lower quoted fee does not prove less administrative work. A messy record does not prove a provider is expensive. Use this evidence to decide whether to keep the current arrangement, add a route for a specific job or test a replacement with a bounded payment.
Download the blank payment operations workbook (CSV). Open the complete route calculator when you have current, comparable cost inputs.
Sources and scope
Official pages reviewed November 11, 2026. Product availability and terms can change. Worked amounts are illustrative unless explicitly attributed. This is not a hands-on account test.