Convert FBAR balances at the Treasury year-end rate
Every account converted at the Treasury Reporting Rate of Exchange for December 31, rounded up — not at a spot rate from a search engine.
The FBAR rules
A U.S. person with a financial interest in, or signature authority over, foreign financial accounts must file FinCEN Form 114 if the accounts' maximum values add up to more than $10,000 at any time in the calendar year (31 CFR 1010.350; IRS FBAR page). The maximum value is a reasonable approximation of the greatest value during the year — periodic statements are fine. Convert it at the Treasury Reporting Rate of Exchange for the last day of the year and round up to the next whole dollar; report a negative value as zero (FinCEN Form 114 instructions). The FBAR is due April 15 with an automatic extension to October 15.
The Treasury rate is quoted as foreign currency per US dollar, so divide the balance by the rate. Fbartally includes the 2025-12-31 rates for about 70 currencies and uses the September 30, 2026 rates as a clearly marked estimate for 2026 until the year-end rates are published. If your currency is missing, add a rate column.
Your balances stay on your computer
Fbartally reads your file with JavaScript in this browser tab. Nothing is uploaded, and the rows are gone when you close the tab.
How it works
- List your foreign account balances — every statement, or at least the highest one for each account — in the template, or try the sample.
- Pick the calendar year, your filing status and where you live.
- Copy the maximum value for each account into FinCEN Form 114 on the BSA E-Filing System. Due April 15, with an automatic extension to October 15.
FAQ
Is my data uploaded?
No. Your files are read by JavaScript in your browser tab and never sent to us or anyone else. Balances aren't stored, so closing the tab clears them. Settings can be saved in this browser if you ask.
What does Fbartally do?
It reads a list of your foreign account balances, takes the highest balance in the calendar year for each account, converts it to US dollars at the Treasury Reporting Rate of Exchange for December 31, rounds up to the next whole dollar, adds the accounts up and tells you whether the total is over the $10,000 FBAR threshold.
Who has to file an FBAR?
A U.S. person — a citizen, resident (including green-card holders), or a U.S. company, trust or estate — with a financial interest in or signature authority over foreign financial accounts whose maximum values add up to more than $10,000 at any time in the calendar year. It is filed with FinCEN (Form 114), not with your tax return.
Which exchange rate is used?
FinCEN's instructions say to use the Treasury Reporting Rate of Exchange for the last day of the calendar year. Fbartally includes the official 2025-12-31 rates. For 2026 it uses the September 30, 2026 rates as a provisional estimate until the December 31 rates are published; you can also put your own rate in a column.
What about joint accounts?
Each owner reports the full value of a jointly owned account. A spouse may be included on the other spouse's FBAR with Form 114a if all of the spouse's accounts are jointly owned with the filer.
What's free?
Importing any number of balances, the $10,000 test, the Form 8938 check, every flag, 3 rate what-ifs, 3 accounts and 12 statement rows on screen and in print (with a footer). Pro shows everything and adds the Excel workbook and CSV exports.
What isn't covered?
Filing itself (you file on FinCEN's BSA E-Filing System), Form 8938's full value and exception rules, the 25-or-more-accounts and signature-authority shortcuts, valuing pensions or insurance that have no statement balance, and penalties or late-filing relief.
Is this tax or filing advice?
No. Fbartally applies the rules it describes to the balances you provide. It is a worksheet to prepare with — check FinCEN's instructions or a tax professional before you file. It is not affiliated with FinCEN, the IRS or the U.S. Treasury.