Multi-currency travel spending reconciliation · Calculation guide

Reconcile spending in several currencies against one home-currency budget.

Calculation guide

Enter each amount actually spent and its realized home-currency cost per foreign unit. Include card fees in that realized rate. Choose home currency for the display.

Home spending = Σ(foreign amount spent × home units per foreign unit); remaining = budget − home spending.

Inputs

Home-currency travel budget

Example entry 2000 (in the selected currency).

Foreign units spent

Example entry 100. Allowed range 0 to 1000000000.0.

Home units per foreign unit

Example entry 1. Allowed range 1e-06 to 100000000.0.

Worked example

InputValue
Home-currency travel budget2,000

Foreign cash and card spending

Foreign units spentHome units per foreign unit
5001.1
3000.8
25,0000.009
ResultValue
Remaining budget985
Total spending in home currency1,015

How each input affects this example

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

InputOriginal inputNew inputAffected resultOriginal resultNew result
Home-currency travel budget2,0002,200Remaining budget9851,185
Foreign units spent (row 1)500550Remaining budget985930
Home units per foreign unit (row 1)1.12.1Remaining budget985485
Multi-currency travel spending reconciliation →