A designer in Atlanta bills a South African client in rand. On invoice day the fee clears the dollar revenue she budgeted. When the client pays thirty days later, the rand amount is correct but the dollar receipt is short. She needs to separate hours billed, exchange-rate movement and collection charges before renegotiating the next job.
For a ZAR receivable, a higher rand-per-dollar rate buys fewer dollars for the same invoice. Revenue in dollars equals rand actually converted divided by the customer rate, less any separate dollar fee. Different rules apply if the contract obliges the customer to deliver an agreed dollar amount.
Find the dollar floor on the invoice
An illustrative R38,400 fee and a $24 collection charge leave $2,000 net when the conversion delivers $2,024 gross. Divide 38,400 by 2,024 to get the limiting rand-per-dollar rate. A higher rate puts net dollars below the goal. This threshold helps explain a receivable to a client or business partner without claiming that the currency is likely to reach it.
Price a late payment separately
Keep three dates on the statement of work. The invoice date recognizes the billed amount, the due date identifies when the client owes payment, and the conversion date determines which price turned rand into dollars. If the funds sit in a rand balance for a further week, that last week is a treasury choice. Calling the entire difference a late-payment loss assigns that choice to the wrong party.
Set a quote that survives a payment delay
A freelancer expects to spend forty hours on a job. A dollar revenue floor per project should be established after asking whether it represents revenue, gross margin or take-home pay. A $2,000 net bank receipt on forty hours means $50 per hour before software, subcontracting, taxes and unpaid administrative time. An FX calculation cannot convert a revenue target into a profit target without those costs.
Suppose the customer wants two milestones. The first pays enough rand to cover a subcontractor who also invoices in rand. To that extent, the designer can match local receipts and local spending. Only the remaining net rand balance needs conversion for dollar expenses if timing, amounts and payment rights align. A gross-receivable calculation would overstate the portion ultimately converted on those assumed terms.
The timing still matters. If the subcontractor is due before the first milestone, the designer may need to buy rand with dollars before receiving any. A nominal match across the full project then hides a temporary funding exposure. Set out due dates, expected clearing dates and the currency of each commitment. A late customer payment can change the sequence without changing the stated contract value.
Quoting a fixed dollar price to the customer is another possible contract structure. It changes the distribution of exchange-rate risk and may change the customer’s willingness to buy. It does not retroactively alter a completed rand invoice. When comparing these arrangements, use the same scope of work, collection fee, payment timing and assumptions about counterparty performance.
What the dollar calculation looked like over ten years
Divide R38,400 separately by the first and last available rates of the month. Subtract the opening dollar valuation from the closing one. Identical fixed collection charges at both dates cancel in this timing comparison.
Use the rows below as a check on the method. The first complete observation is 2016-01 and the last is 2025-12. There are 120 usable monthly observations in the 2016 through 2025 study window. A row needs both inputs and the second calculation described below. A missing source observation is left out if the calculation depends on it. An empty cell has a different meaning from a genuine zero. The table shows selected rows and retains full precision for the calculations behind the displayed values.
Start with 2020-06, the observation closest to the sample median for change in usd collected on r38,400. Enter 17.400 for opening zar per usd and 17.353 for closing zar per usd. Applying the rule gives 6.041. Write the unit beside the result before rounding. It determines whether this number belongs in a dollar ledger, a rate comparison or a column measuring a change. Writing an extra percent sign or moving the decimal two places can produce a neat calculation that answers an entirely different question.
| Period | Opening ZAR per USD | Closing ZAR per USD | Change in USD collected on R38,400 |
|---|---|---|---|
| 2016-01 | 15.615 | 15.954 | -52.179 |
| 2017-12 | 13.723 | 12.375 | 304.706 |
| 2020-03 | 15.537 | 17.768 | -310.355 |
| 2020-06 | 17.400 | 17.353 | 6.041 |
| 2025-12 | 17.076 | 16.550 | 71.580 |
For a sense of ordinary variation, the middle half of the observations lies between -65.368 and 66.980 on the change in usd collected on r38,400 measure. The endpoints of the full sample are -310.355 in 2020-03 and 304.706 in 2017-12. These are different comparisons. A reader budgeting for a single decision might want to test an adverse endpoint. A reader describing a typical period has more reason to look at the middle half. Neither range gives a promised boundary for what a later observation can be.
How would a changed invoice date affect the collection result?
Move the assumed invoicing quote up by 0.30 and the collection quote up by 0.55 rand per dollar. Keep the R38,400 fee unchanged. Both valuations fall in dollar terms, but the measured timing difference depends on the size of each fall.
| Illustration | Opening ZAR per USD | Closing ZAR per USD | Change in USD collected on R38,400 |
|---|---|---|---|
| Baseline | 17.400 | 17.353 | 6.041 |
| First change | 17.700 | 17.353 | 43.446 |
| Second change | 17.400 | 17.903 | -61.945 |
| Both changes | 17.700 | 17.903 | -24.540 |
Read the first two rows across. The first alteration is 0.300 in the units described as extra ZAR per USD at invoicing. With the other input fixed at 17.353, the result moves from 6.041 to 43.446, a signed change of 37.405. Now return to the original inputs before applying the second alteration of 0.550 in the units described as extra ZAR per USD at collection. That separate result is -61.945. Starting the second trial from the already altered first row would accidentally test both changes at once.
With both changes in place the answer becomes -24.540, or -30.581 relative to the baseline. Adding the two isolated changes gives -30.581. The difference between the joint and additive calculations is 0.000 at the displayed precision. The two increments add exactly in this calculation. That makes it possible to attribute their combined effect without choosing which came first.
A fall in the opening dollar benchmark can make the timing result look better even when the dollars actually collected do not improve. Always show the closing receipt alongside any calculated gain or loss from waiting.
If the client pays installments, allocate actual rand received to each collection date before translating. An arithmetic mean of collection dates will not replace a cash ledger.
Track the largest change in the dollar worksheet
Between 2018-08 and 2018-09, change in usd collected on r38,400 went from -291.896 to 203.838. Its signed change of 495.734 had the greatest absolute size among the 119 complete adjacent month pairs. To find it, subtract each earlier value from its neighbor, take absolute values solely to rank the pairs and restore the sign when reporting the winner. Rank changes rather than levels. The highest level and the fastest move need not occur at the same time.
The first input went from 13.223 to 15.305. The second went from 14.700 to 14.155. Replace just the first earlier input with its later value. This gives 103.261, which accounts for 395.157 of the observed change on that replacement order. Replacing the second input then accounts for 100.577. The two amounts reconcile to 495.734. This arithmetic answers which measured input changed the answer. Evidence outside the worksheet is needed to explain why the input itself moved.
Try replacing the second input first. Its intermediate result is -191.318, followed by the same final 203.838. The two orders are useful when discussing opening zar per usd alongside closing zar per usd. If the assigned contributions depend on order, show both or give the order explicitly. An unqualified statement that one factor accounted for the entire change might depend on an unnoticed choice about which input the calculation held constant.
Check a less dramatic interval
For comparison, the median absolute adjacent change was 82.026. The pair nearest that magnitude ran from 2024-12 to 2025-01, moving from -75.407 to 6.619. For that pair the first input changed by 0.498 and the second by -0.237. Put these inputs alongside the largest-move pair. A single dramatic date is a poor place to learn the scale of an ordinary observation, especially if the date was chosen after reviewing the entire history.
Net USD above or below a $2,000 fee target
Translate R38,400 at the closing reference, deduct a hypothetical $24 collection fee and subtract the target of $2,000. The signed remainder is a budget margin.
Keep the second result on a separate line in the working file. In 2020-11, the first measure, change in usd collected on r38,400, was 121.537. The second, net usd above or below a $2,000 fee target, was 464.255. This date was selected because the second result lies closest to its own sample median, rather than because it gives the most favorable comparison. Start from the inputs in the table if you reproduce it. A second measure can have a different scale, denominator and sign interpretation from the first.
| Period | Opening ZAR per USD | Closing ZAR per USD | Net USD above or below a $2,000 fee target |
|---|---|---|---|
| 2018-02 | 11.840 | 11.780 | 1,235.762 |
| 2020-11 | 16.225 | 15.433 | 464.255 |
| 2023-05 | 18.373 | 19.779 | -82.517 |
| 2025-12 | 17.076 | 16.550 | 296.298 |
At the lower end of this calculation, 2023-05 gives -82.517 with inputs of 18.373 and 19.779. At the upper end, 2018-02 gives 1,235.762 with inputs of 11.840 and 11.780. Check the formula before interpreting the order. A dollar outlay, a net receipt, a growth rate and a distance from a benchmark answer different economic questions even when their values can all be ranked from low to high. An invoice denominated in dollars with the client bearing conversion has a different risk holder. Verify who promised what before translating the amount.
Reading the final observation without hindsight
Cover the last row and write two estimates for change in usd collected on r38,400. One uses the latest earlier observation, 22.444 from 2025-11. The other uses the median of the preceding 119 records, 6.041. Reveal 2025-12. The observed result is 71.580, so actual minus estimate is 49.136 for the recent observation and 65.539 for the historical middle. Keep both errors with the original estimates. Quietly replacing a poor baseline with a better one after the reveal removes the point of the exercise.
Next inspect the final record itself. It contains 17.076 for opening zar per usd and 16.550 for closing zar per usd, producing 296.298 on the second decision measure. Someone reproducing this result from rounded figures might differ in the last decimal. A large difference demands a different explanation. Check the observation period, quote direction or growth interval and whether the same quantity appears twice. The signed invoice, due date and conversion advice provide a starting point for an audit. Write down any imposed assumption that cannot be found in those records.
Did the next broad dollar move help a payer?
To connect the lesson with the US currency market, compare the worksheet with a different series. Use the Federal Reserve nominal broad dollar index, measured at the last available observation in each period. A rise means the dollar strengthened against its weighted basket. Measure the percentage change from one period-end to the next. That change is a basket return. A specific bilateral currency, a card settlement or a leveraged USD/ZAR position can give a different sign and amount.
Take the first 59 matched transitions as a calibration segment. Their starting-period median for change in usd collected on r38,400 was 16.519. Freeze that cutoff. In the remaining 60 transitions, group each starting observation by whether it was at least that value. Measure the subsequent broad dollar return within each group. Keeping adjacent pairs only prevents a missing month or quarter from silently becoming a longer observation with a different holding period. Missing values never count as zero returns.
| Later-period group | Records | Mean USD move % | Median USD move % | USD rose |
|---|---|---|---|---|
| At or above 16.519 | 26 | -0.039 | -0.379 | 10 |
| Below 16.519 | 34 | 0.266 | 0.175 | 19 |
The higher group contains 26 later observations with a mean next-period dollar move of -0.039%. The lower group contains 34 with a mean of 0.266%. Their difference is -0.305 percentage points on a high-minus-low convention. A gap is descriptive evidence for this sample and definition. Before attributing it to this measure, check whether the groups cluster in different years and whether the median tells the same story as the mean.
Release timing limits what the calculation can establish. An observation labeled with a month or quarter need not have been public at its last market close. Historical series can also change after revision. For a prospective test, replace each worksheet label with the timestamp when both inputs could actually have been known, then start the currency return after that time. Preserve a release vintage and executable prices. The table here is a retrospective comparison and supplies no entry price, success probability or trading performance record.
How much would a half deposit change collection risk?
Translate half of R38,400 at the opening rate and half at the closing rate. Compare with converting the whole invoice at collection. There is no change to project scope or total rand. The half deposit shortens the period over which some of the rand amount remains exposed.
The designer puts $20 of dollar collection variability into the project contingency budget.
| Observation | USD if half the rand is converted early | USD if all rand is converted at collection | Second minus first |
|---|---|---|---|
| 2016-01 | 2,433.085 | 2,406.995 | -26.089 |
| 2019-05 | 2,653.003 | 2,632.842 | -20.161 |
| 2020-03 | 2,316.342 | 2,161.164 | -155.178 |
| 2025-12 | 2,284.508 | 2,320.298 | 35.790 |
Use the last complete case, 2025-12, as a reconciliation. The first calculation gives 2,284.508 and the second gives 2,320.298. Subtract the first from the second to obtain 35.790 USD. A positive result has this particular interpretation: waiting to convert the entire receivable produced more dollars than the split arrangement. The absolute distance is 35.790 against the assumed allowance of 20.000. Restoring the sign after checking the size of the difference matters when one party pays an amount that another party receives.
For 2019-05, the absolute difference was 20.161 USD. This is the observation nearest the stated allowance, with a distance from that boundary of 0.161. The underlying values were 2,653.003 and 2,632.842. Check a borderline case at full precision before assigning it to either side. If you change the allowance, carry the new rule through all dates. Applying it to just the most interesting row would quietly change the selection method.
How often did the difference matter under these assumptions?
The absolute difference exceeded 20.000 USD in 81 of 120 complete records. It stayed at or below that level in 39. The largest observed absolute difference was 155.178 in 2020-03, against a middle observation by magnitude of 33.160. This count gives each observation equal weight. A person whose largest obligations or research decisions cluster in a small number of months can experience a very different total effect from the fraction of dates shown here.
A deposit that remains in rand until collection does not deliver the modeled timing effect. The early conversion date is part of the assumption.
Build the calculation in two spreadsheet cells
Put opening zar per usd in column A and closing zar per usd in column B. Use row one for labels and enter the two inputs from 2020-06 in row two. The numeric entries are 17.40000 and 17.35250 when displayed to five decimals. In this worksheet, a percentage quoted as 4.25 is entered as the number 4.25, not as the spreadsheet value 0.0425. For dollar or currency amounts, enter numbers and use cell formatting for currency symbols so the program can still do arithmetic.
In C2 enter =38400/B2-38400/A2. The expected result for change in usd collected on r38,400 is 6.04107 with unrounded inputs. Repeat the formula on the next dated row before copying it through a longer file. A second manual check on a different observation is more informative than assuming that a formula which worked on a single coincidence will work everywhere.
Reporting the change in a dollar payable instead of a rand receivable
A US customer with a rand bill and a US business owed rand experience opposite economic effects from the same dollar exchange move. The worksheet defines later dollar collection minus opening valuation. Reversing those terms makes a worse collection look like a gain.
To diagnose that problem, enter 38400/A2-38400/B2 in a separate comparison cell. With these inputs it displays -6.04107. Keep the column labeled as a diagnostic. A superficially similar number can have a different unit, denominator or sign. Where two formulas give the same number on a particular row, that agreement is a reason to test a second case with deliberately different values. It does not establish that the formulas are interchangeable.
Raise only the closing rand-per-dollar quote in a test copy. The dollars ultimately collected on an unchanged rand fee should fall. If the displayed timing gain increases, check the direction before calculating a new project price or discussing the result with the client.
How to identify the price setup on a USD/ZAR chart
The USD/ZAR illustration demonstrates execution in a dollar account. A rand receivable remains exposed to rand until conversion or an agreed change to the contract. The practice trade has no place on the customer invoice.
Use a five-minute demo chart with a named time zone, such as America/New_York. The first decision is where an existing swing could attract orders. In the drawing the prior low sits at 18.55497. Mark it while the chart still ends before the next challenge. The subsequent wick reaches 18.54439, below the earlier reference, and the market returns through it. ICT describes that sequence as a liquidity sweep. Candles show traded or quoted prices on a feed, so the sequence does not establish any individual institution’s identity or the number of orders at the swing.
The next test is displacement through the earlier internal swing at 18.58143. In this schematic the outer wicks of bars five and seven leave a three-candle fair value gap between 18.57312 and 18.57954. Write down both boundaries before testing the retest. A wick across the initial level without displacement is a different observation. A displacement without a later return can leave a correctly identified setup unfilled. Preserve each outcome so a replay does not silently select only the attractive-looking retracements.
How to trade the retest on demo
For the hypothetical long position, the order waits at 18.57614 after the gap has formed. The protective stop is 18.53834, beyond the swept extreme. The target is 18.66119, which requires the quoted pair to move higher. Cancel the order if price reaches invalidation before entry, the agreed observation window expires, or the executable spread makes the original risk budget infeasible. A chart mid touching a line does not prove the customer’s bid or offer filled. In a live record those two events need separate timestamps.
The second drawing shows one favorable branch solely to establish the accounting. A losing branch exits at the stop under an exact-fill assumption. A third branch never enters and incurs no modeled round-trip charge. If stop and target both lie within one observed bar, the wick alone does not reveal their order. Seek finer time-stamped evidence or retain an ambiguous result rather than labeling the trade a winner. For an event study, select the exit, expiry and treatment of ambiguous sequences before viewing the release-day chart.
Set the paper order aside when reconciling an actual dollar transaction. The institution delivering the currency determines the settlement price according to its terms. The illustrative chart cannot establish which rate a bank used or what amount was credited.
Worked trade in a dollar-denominated demo account
| Field | Hypothetical execution |
|---|---|
| Pair and side | USD/ZAR long |
| Size | 14,000 USD |
| Entry | 18.57614 |
| Protective stop | 18.53834 |
| Target | 18.66119 |
| Gross risk and potential reward | $28.55 and $63.81 |
| Assumed round-trip charges | $2.37 |
First subtract the entry and stop in absolute price units. The distance is 0.03780 ZAR per USD, compared with 0.08505 to the target. Multiply each by 14,000 base units. That yields 529.2000 ZAR of gross risk and 1,190.7000 ZAR of potential gross gain. For a USD account, divide each quote-currency amount by its respective assumed exit in ZAR per dollar. Use the stop exchange rate for the loss and the target rate for the gain. Keep the full numerical precision through this step.
Gross planned risk is $28.55 and potential gain is $63.81. Divide gain by risk: $63.81 / $28.55 = 2.24. On a risk-to-reward convention that is 1:2.24. Now assume $2.37 in total round-trip charges in either completed branch, with executable entry and exit prices in the example. Net risk is $28.55 plus $2.37, or $30.92. Net potential reward is $63.81 minus $2.37, or $61.44. The net R:R is 1:1.99 from $61.44 / $30.92. These ratios use full-precision amounts before display rounding.
If the stop slipped one further chart increment of 0.00010, the modeled exit would move to 18.53824 and the completed loss including the assumed charge would become $30.99. Compare this with the original $30.92. Slippage, funding and market access can all affect an actual instrument. The purpose of this branch is to make the size and account-currency conversion explicit. A promising reward-to-risk ratio says nothing about the frequency with which this particular entry, protective exit and target are actually executable.
For the chart terminology and session conventions used in a replay, see fair value gaps, order blocks, the London session, market structure shifts, the Judas swing.
Sources and data conventions
Federal Reserve H.10 country data. Historical series used in the calculations: DEXSFUS observations and units, DTWEXBGS observations and units.
Frequently asked questions
Does a higher USD/ZAR help an American paid in rand?
For an unchanged rand receivable it reduces the dollar proceeds, because each dollar requires more rand. A US buyer paying a fixed rand bill sees the opposite benefit before fees.
What rate would net $2,000 on a R38,400 job?
With a $24 separate collection fee, gross dollars must equal $2,024. Divide R38,400 by $2,024 to obtain about 18.97 rand per dollar. Confirm the all-in client and bank terms before using this as a floor.
What if I receive the rand but convert later?
Collection ends the customer’s debt to the extent provided by the agreement. Holding the rand after receipt leaves a separate currency exposure until conversion. Document those two decisions and their dates independently.
Who bears the FX cost if the invoice says USD?
The contract and settlement terms govern. If the client must deliver a fixed number of US dollars net, the client typically needs to source those dollars. Fee deductions can still cause a short payment.
Can I use a market midpoint to prove the bank made an error?
A midpoint is a reference for asking questions. Compare the trade confirmation with the agreed rate, spread, value date and fees. A discrepancy from a public daily reference alone does not establish an incorrect debit.
For related US dollar examples, read IBAN and SWIFT wire instructions, FX forward points, shared dollar exposure, and inverse currency quotes.
