FBAR Exchange Rates: Convert the Peak, Not the Balance

An overseas savings account reached its highest sterling balance in April and ended December almost empty. Which date belongs in a US foreign account report? A correct calculation can involve the balance from April and a conversion rate for the end of December. Multiplying the year-end balance by a technically correct rate would answer the wrong question.

Which local balance and rate convention belong in the report? Start by checking largest local balance, account currency and calendar year in the source documents. The calculations below distinguish the published record from an illustrative customer transaction and show how to check the result in dollars.

Key insight. For FBAR maximum value, first determine a reasonable approximation of the largest local-currency account value during the calendar year. FinCEN then calls for conversion of that maximum with the Treasury rate for the last day of that calendar year, subject to its rule for an unavailable Treasury rate.

Find the maximum in the account’s own currency

Periodic statements can help establish the maximum if they fairly reflect it. A large deposit and withdrawal between statement dates can make a statement-only estimate inappropriate. Build a timeline of balances in the account currency and keep any more detailed records needed to support the estimate. An account’s final balance, total annual deposits and largest single transaction each describe a different item.

FBAR requirements depend on who holds a financial interest or signature authority, account location, aggregate value and exceptions. For applicable US persons, the aggregate threshold is more than $10,000 at any time during the calendar year. Keep the filing-threshold analysis separate from the maximum value reported for each account. Form 8938 has its own rules and required information.

Apply the year-end table in the published direction

The Treasury PDF dated December 31, 2024 lists 0.7970 UK pounds per US dollar. A hypothetical £15,940 maximum converts to $20,000 because 15,940 divided by 0.7970 equals 20,000. If the year ended at £3,188, that final balance alone would translate to $4,000. The $16,000 difference comes entirely from substituting the wrong balance.

Check Treasury’s current historical record for applicable amendments. If a Treasury rate is unavailable, FinCEN instructs the filer to use another verifiable exchange rate and give the source. Follow the form’s rounding instructions after conversion. Preserve the original local maximum, its supporting records, the exchange-rate source and the calendar year. A GBP/USD chart normally displays dollars per pound and therefore has the opposite orientation to this Treasury entry.

The account that opened and closed in one year

An account opened in March, reached its maximum in July and closed in October. There is no December statement balance, but a US person can still have had a reportable account during the calendar year. Determine the maximum in the currency of denomination and convert as instructed for that year’s report. Keep closing records, not just an online dashboard that disappears after closure. A balance transferred to another account may appear in both accounts’ records at different dates; the calculation of values to report and the separate filing-threshold test need careful attention to the circumstances.

At the published 2024 rate, dividing £1,594 by 0.7970 returns exactly $2,000. Use that simple identity to test a worksheet before putting a five-figure balance into it. A spreadsheet that returns $1,270.42 has multiplied instead of dividing. Store the Treasury source beside the rate and preserve the precision of the input even if the eventual filing asks for whole dollars. Foreign account reporting also can depend on signature authority, ownership and exceptions. Matching a number in this exercise cannot decide those questions for an individual.

Reconcile a maximum without inventing an account balance

Take a sterling account that starts a month at £7,300. On the fifth, £8,640 is deposited. On the twelfth, £12,752 is transferred out. There are no other movements in this simplified example. The running balances are £7,300, £15,940 and £3,188. The largest transaction is the withdrawal, but neither its sign nor its size identifies the maximum. The maximum occurred after the deposit and before the withdrawal. The final balance happens to be one fifth of the maximum, showing how much a monthly closing figure can conceal.

Write down the day’s opening balance and apply each posting in its documented order when transaction details are available. A pending card authorization or statement’s available balance can differ from the account value that the records support. Follow FinCEN’s instructions for a reasonable approximation using periodic statements where they fairly reflect the maximum. If the account includes assets beyond cash, its value and the appropriate source records may require more than a running cash balance. Identify the kind of account involved before extrapolating this cash example.

An account can have the same local maximum in two different calendar years and a different reported dollar maximum because the applicable Treasury year-end rates differ. Conversely, a monthly sterling market rally can make a US portfolio summary show a new dollar high on a day when the sterling balance was lower. The reporting procedure starts by identifying the appropriate maximum local value and then translating it as instructed. Sorting a list of brokerage dollar marks can select a different date and value, even when every market mark was correctly calculated.

Keep the conversion record reproducible. Label the rate in pounds per US dollar, capture the calendar-year row, check for applicable amendments and retain the original unrounded local maximum before following the filing instructions on rounding. If accounts have different currencies, each needs its own conversion input. An important transaction should remain intelligible after the bank closes an old online portal. Download or preserve the statements and transaction records while they are accessible and consult form instructions when ownership, authority or exceptions are in question.

Historical workbook: Understatement in USD from substituting ending balance

The workbook follows a maximum balance supported by statements from a US dollar perspective. Its question is specific: Which local balance and rate convention belong in the report? Keep three columns beside the dates. Column one is illustrative local monthly maximum in gbp. Column two is illustrative ending statement balance in gbp. The calculated column shows understatement in usd from substituting ending balance. Using the same definitions in every row makes it possible to explain an outlier by returning to the inputs instead of changing the story after the price has moved.

Model an account during 2024 only. The GBP high and close in this exercise are invented statement entries. Convert their difference at 0.7970 pounds per USD, the published December 31, 2024 UK rate used here. The separate observed GBP/USD column values pounds in the market and is never substituted for the filing rate.

There are 12 monthly observations from 2024-01 through 2024-12. The historical FX observations come from DEXUSUK. For the independent dollar comparison below, one unit of GBP is always expressed in US dollars. Where the published quote gives foreign currency per dollar, the comparison takes its reciprocal. This keeps a rise in the comparison series synonymous with appreciation of the named foreign currency against USD. The calculation of the main worksheet stays in its original units.

Selected records from the workbook. The table displays rounded values. Statistics and reconstructions use the unrounded inputs.
PeriodIllustrative local monthly maximum in GBPIllustrative ending statement balance in GBPUnderstatement in USD from substituting ending balance
2024-019,549.00008,529.00001,279.7992
2024-0422,846.000013,716.000011,455.4580
2024-0611,054.00009,274.00002,233.3752
2024-0813,382.000012,732.0000815.5583
2024-1010,770.00008,290.00003,111.6688
2024-1110,509.000010,019.0000614.8055
2024-1212,998.000011,748.00001,568.3814

Read one row from the source to the answer

Start with 2024-06, near the chronological middle of the sample. The two inputs were 11,054.0000 for illustrative local monthly maximum in gbp and 9,274.0000 for illustrative ending statement balance in gbp. Applying the stated rule gives 2,233.3752 for the maximum-versus-close difference. A reader reconstructing the published number should carry more precision than the table displays. The market comparison used an FX mark on 2024-06-28, quoted at 1.2640 in the ordinary GBP/USD convention. It is not necessarily the observation time of the other inputs.

The simulated statement reaches £11,054 in this month and ends at £9,274. At the specified 2024 Treasury rate the two possible translations are $13,869.51 and $11,636.14. Only the first is a candidate for the annual maximum on this month’s evidence. Compare it with the high of every other month before filling an account entry. Adding all the monthly dollar candidates would report a flow-like total where the form asks for a maximum.

The last market observation for this month is 1.2640 dollars per pound. Translating the same high at that market price instead yields $13,972.26, a signed difference of $102.75 against the Treasury-table method. Even if that difference happens to be small, agreement after rounding cannot validate the substitute. Actual records must establish the account peak and, where relevant, aggregation across accounts. The synthetic monthly balances let you inspect the calculation without representing anyone’s financial account.

Which input explains the largest change?

Across adjacent months the largest absolute change in the maximum-versus-close difference occurred between 2024-03 and 2024-04. The calculated value went from 2,609.7867 to 11,455.4580, a signed difference of 8,845.6713. A headline describing the two end values is accurate but incomplete. To identify what generated the change, first update only the first column. Then update the second while holding the new first column fixed. This procedure accounts for the whole change without assuming which input moved first in real time.

The first input went from 14,067.0000 to 22,846.0000. With the second held at its starting value of 11,987.0000, that gives a hypothetical intermediate result of 13,624.8432. The first step therefore contributes 11,015.0565 to the measured change. Replacing the remaining old input with 13,716.0000 contributes another -2,169.3852. Add the two signed contributions to recover 8,845.6713 before display rounding. A negative contribution offsets a positive one even if both raw inputs rose.

Now reverse the order. Updating the second input first produces 440.4015. Its first-step contribution under this order is -2,169.3852, and the remaining contribution is 11,015.0565. Addition and subtraction formulas give the same attribution either way. Products and quotients can distribute a joint interaction differently. If the two allocations differ, report the order you used or average the two contributions for each input. Both reconciliations describe an identity. Neither establishes an economic cause. Each monthly case identifies a candidate for the calendar-year maximum. Reporting twelve monthly maxima as twelve separate accounts would misstate the unit of analysis.

Average of both replacement orders. The two allocations sum to the full change.
Measured changeAllocated to first inputAllocated to second input
8,845.671311,015.0565-2,169.3852

Use a typical period to test a dramatic headline

Ordering the calculated record by level gives a minimum of 2024-11 (614.8055) and a maximum of 2024-04 (11,455.4580). The distance between them is 10,840.6524 in the units of the worksheet. The mean is 3,632.3714 and the median is 2,628.6073. A mean gives every period equal weight and includes the influence of extreme observations. A median locates the middle of the ordering. Neither measures the experience of a specific US account with transactions concentrated on one or two dates.

A second question is how much the maximum-versus-close difference generally changed between adjacent observations. Its median absolute change was 3,500.6274. The transition from 2024-07 to 2024-08 lies closest to that amount, going from 4,316.1857 to 815.5583. In that interval the first input moved by -1,061.0000 and the second by 1,729.0000 in their respective units. Compare those with the largest-change interval. The same final-sized change can come from modest moves in both inputs or large movements that largely offset.

For the high observation, ask what the same calculation would have returned if only the first input had taken its median sample value. Using 13,190.0000 in place of 22,846.0000 while keeping the second input at 13,716.0000 gives -659.9749. This is a deliberately constructed comparison. Those values need never have occurred together. If an input is contractually fixed or mechanically related to the other one, interpret the substitution as an arithmetic sensitivity exercise rather than a market scenario that could have been traded.

Does the dollar chart agree with the worksheet?

The largest absolute adjacent change in the dollar value of one GBP occurred from 2024-09 to 2024-10. The market comparison changed from 1.339900 to 1.285600 USD per unit, or -4.05%. By contrast, the worksheet moved by -4,052.6976 in its own units. A percentage currency return and a change in the maximum-versus-close difference are different measurements. Comparing their signs is meaningful only after specifying the direction and recognizing when one input is itself a transformation of the exchange rate.

Of the 11 adjacent pairs, 11 had a measurable change in both series. In 5 they moved in the same signed direction, and in 6 they moved in opposite directions. The remainder had a flat result in at least one column at the stated numerical tolerance. These counts describe a sample, with no assumption of independence between observations. Where the translation formula already uses the exchange rate, part or all of the association can be mechanical. An agreement count alone is unsuitable as a trading win rate.

Compare a period where the signs explicitly disagreed. From 2024-07 to 2024-08, the dollar value of one GBP moved 2.27% and the worksheet changed by -3,500.6274. The first input ended at 13,382.0000 and the second at 12,732.0000. Record the observation even if it challenges your preferred narrative. Then return to fincen maximum-value instructions and treasury’s year-end table to test whether the disagreement reflects definitions, different sampling dates or a genuinely different economic exposure. The outcome by itself does not choose between these explanations.

What was knowable before the last observation?

Keep the last month outside the record when setting a reference. The earlier 11 observations had a median worksheet value of 2,647.4279. The last result was 1,568.3814 in 2024-12. A simple baseline using the immediately preceding value, 614.8055, misses the last result by 953.5759 on an actual-minus-baseline convention. The earlier median misses by -1,079.0464. These baselines answer different questions about stability and representativeness.

Extend the last-value test across every adjacent pair and take the mean absolute difference. The result is 4,105.1671, compared with a median absolute difference of 3,500.6274. The mean gives unusually large misses their full weight. The median describes a typical miss. When you evaluate a real budget, multiply a per-unit figure only by its proper exposure, and account for any amount the formula already includes. Multiplying a dollar total by the entire invoice a second time would produce a fictitious level of risk.

These tests run on one documented set of historical observations. A revised series, an annual value compiled after year-end or a market quote taken after a release can include information unavailable at the hypothetical decision. To turn the worksheet into a real-time study, save the exact version that was available, the timestamp at which it became available and the quote at which a decision could be implemented. Keep statements or a transaction ledger that supports the annual peak with that file. A comparison that relies on a later release remains a historical reconciliation even if it happens to fit the chart perfectly.

How different is the market-mark translation of this peak?

Multiply the modeled local peak by the final GBP/USD market mark of the month, then subtract its translation at 0.7970 GBP per dollar. This measures the size and sign of using the wrong type of rate in this 2024 record. The market method is included solely to diagnose a possible worksheet error.

The output column below is market translation minus treasury translation in usd. This is a second calculation on the same dated records. State the assumption before reading the result so it is clear which parts of the comparison come from observations and which come from the proposed decision. The smallest calculated result occurs in 2024-04, at -75.5093. The largest occurs in 2024-09, at 1,718.4654. A negative result, where the formula allows one, means the order of the comparison matters. It does not mean that the source supplied a negative market price.

Market translation minus Treasury translation in USD. Repeated selections are shown once.
PeriodFirst inputSecond inputOriginal worksheet resultSecond calculation
2024-0422,846.000013,716.000011,455.4580-75.5093
2024-019,549.00008,529.00001,279.7992177.5623
2024-0920,171.000014,461.00007,164.36641,718.4654
2024-1212,998.000011,748.00001,568.3814-33.8617

For a central case use 2024-01, where the result is 177.5623, against a full-sample median of 168.6225. The associated FX observation was 1.27330 in the GBP/USD convention on 2024-01-31. Compare it with the largest case rather than simply picking the most recent observation. If an assumed quantity, policy or percentage in the calculation would have been different at the time, describe the result as a controlled comparison across historical conditions. Avoid presenting it as a transaction the source actually recorded.

The first 6 records, 2024-01 through 2024-06, average 106.9844 on this second calculation. The later 6 records, 2024-07 through 2024-12, average 563.8180. The signed difference is 456.8336. This gives equal weight to each retained observation and asks how the same rule behaved over two consecutive intervals. It does not adjust for changes in business activity or prove that the start of the later interval marks a regime change. After identifying the calendar-year local maximum, use the applicable FinCEN rate procedure regardless of which translation is larger. Market values and filing values need separate labels.

Does the currency table describe a single calendar year?

Where two annual worksheets share a spreadsheet, protect the year lookup from silently carrying last year’s rate forward. Log country, currency, year, effective date and any amendment. The official Treasury PDF used for the illustration explicitly warns that amendments are available online. A verifiable rate fallback matters only when a Treasury rate for the currency is unavailable under FinCEN’s rule.

Sort local balances before translation, verify the largest candidate against the account records and retain the calculation for each account independently. Revisit ownership and aggregate filing obligations using the applicable instructions.

How to identify the price setup on a GBP/USD chart

The FBAR worksheet ends with a statutory reporting convention. To understand why a GBP/USD chart supplies a different kind of evidence, the next exercise tests a separate, hypothetical intraday setup. The Treasury year-end price does not identify an entry or protective stop on that chart.

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 1.28126. Mark it while the chart still ends before the next challenge. The subsequent wick reaches 1.28068, 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 1.28271. In this schematic the outer wicks of bars five and seven leave a three-candle fair value gap between 1.28225 and 1.28261. 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.

Chart 1. Identify the sweep and three-candle imbalance
GBP/USD | hypothetical spot pricesPrior low 1.28126Sweep 1.28068Prior swing 1.28271Gap 1.28225 / 1.28261Green: up Red: down Blue: reference Purple: sweep Gold: gap
Schematic GBP/USD bars. Compare the wick of bar five with the wick of bar seven. The middle bar provides displacement. The shaded interval records the gap between the outside wicks.

How to trade the retest on demo

For the hypothetical long position, the order waits at 1.28242 after the gap has formed. The protective stop is 1.28035, beyond the swept extreme. The target is 1.28759, 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.

Tax and reporting records should retain the required rate independently of any broker fills or demo chart. Replacing an official reference with a profitable entry would distort the account report.

Chart 2. Price the entry, protective stop and target
GBP/USD | hypothetical spot pricesEntry 1.28242Stop 1.28035Target 1.28759Green: up Red: down Blue: reference Purple: target
Illustrative continuation after a retest. Lines show the planned long order. The favorable path is one possible sequence and carries no probability estimate.

Worked trade in a dollar-denominated demo account

Illustrative position. The prices are separate from the historical observations and the outcome has no assigned probability.
FieldHypothetical execution
Pair and sideGBP/USD long
Size10,000 GBP
Entry1.28242
Protective stop1.28035
Target1.28759
Gross risk and potential reward$20.70 and $51.70
Assumed round-trip charges$1.89

First subtract the entry and stop in absolute price units. The distance is 0.00207 USD per GBP, compared with 0.00517 to the target. Multiply each by 10,000 base units. That yields 20.7000 USD of gross risk and 51.7000 USD of potential gross gain. The figures are already in the USD account currency. Keep the full numerical precision through this step.

Gross planned risk is $20.70 and potential gain is $51.70. Divide gain by risk: $51.70 / $20.70 = 2.50. On a risk-to-reward convention that is 1:2.50. Now assume $1.89 in total round-trip charges in either completed branch, with executable entry and exit prices in the example. Net risk is $20.70 plus $1.89, or $22.59. Net potential reward is $51.70 minus $1.89, or $49.81. The net R:R is 1:2.20 from $49.81 / $22.59. These ratios use full-precision amounts before display rounding.

If the stop slipped one further pip, the modeled exit would move to 1.28025 and the completed loss including the assumed charge would become $23.59. Compare this with the original $22.59. 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.

To annotate the rehearsal, mark the existing swing first, then identify displacement and the interval between the outer candle wicks. For definitions and session context, see the school’s lessons on fair value gaps, order blocks, the London session, market structure shifts, and the Judas swing.

Sources and calculation notes

FinCEN on reporting maximum account value. Treasury reporting rates of exchange.

Historical series and original records. DEXUSUK series, units and frequency · Treasury reporting table for December 31, 2024. The calculations use observations available when checked on November 15, 2026. Subsequent revisions can change retrospective comparisons.

Frequently asked questions

Does the FBAR use the rate on the day the account peaked?

FinCEN’s maximum-value procedure uses the last-day-of-calendar-year Treasury rate for conversion.

Can the same year-end rate apply to two different peak dates?

Yes. Two sterling accounts in the same calendar year can have different dates of maximum value and share the relevant sterling conversion rate.

Can I use my closing balance because it is easiest to prove?

The required item is the maximum value. Retain records that fairly support that maximum.

What if the currency is missing from Treasury’s table?

FinCEN allows another verifiable exchange rate in that circumstance and requires its source.

Is an FBAR filed as part of the income tax return?

It is filed separately with FinCEN. Other US tax-return reporting obligations can apply independently.

To check an exchange quote from another angle, see US Forex Taxes, Form 6781 for Currency Futures, inverse currency quotes, and the trading journal.