FBAR balance workpaper
Find each account's highest observed CSV balance, its source row and gaps in your records. Free, entirely in your browser.
Your CSV stays on this device. No upload, account login or saved balances. Use account aliases instead of account numbers.
Trace the peak back to your records
Choose a CSV to inspect its columns. Your workpaper will keep the peak date and source row beside each account, with months lacking observations and any balance conflicts.
Observed maxima only. A higher balance may fall between rows or outside your exports. This tool cannot establish a complete annual maximum or decide whether you must file.
Source preview
Observed maxima
Full-year coverage is unproven, even when every month has a row. Missing months mean no dated observations, not proof of a missing statement. Review every exception before using a figure.
The download contains account aliases and balances. Keep it private with your original CSV.
How the figures are calculated
Printed balances and supplied openings are observations. With signed transactions, the workpaper also rebuilds balances from a prior printed balance or explicit opening. It keeps reconstructed peaks separate and flags exact arithmetic conflicts. It never sorts, repairs or removes duplicate rows.
For USD conversion, divide the candidate peak by foreign-currency units per USD 1, then round up once to the next whole dollar. Exact whole dollars stay unchanged; negative values become zero. An unresolved row or currency conflict withholds that account's USD figure. Months without rows still qualify any displayed candidate.
The bundled subset is Treasury's December 31, 2025 report, checked November 13, 2026 against its online data: AUD 1.495, CAD 1.369, CHF 0.792, EUR 0.851, GBP 0.743, JPY 156.61 and PHP 58.911 per USD 1. Check for Treasury amendments before use. Other currencies or years need a documented year-end rate. The current year's final rate stays unavailable until year end has passed and a published rate is supplied.
FinCEN's maximum-value instructions explain the year-end exchange rate and rounding rule. This workpaper covers cash-balance rows only; it does not value securities or other non-cash assets. It provides no filing, eligibility, tax or legal verdict.
Have PDFs instead? Tanod's paid bank-statement PDF converter can help prepare a CSV. Check its exported rows before using them here.
What happens to my file?
Only the page and its static assets load from the server. Your chosen CSV and all calculations stay in page memory. This tool sends no account aliases, filenames or balances to Tanod, analytics or an FX service, and saves none in browser storage. Clear the page when done. A downloaded workpaper stays on your device until you remove it. Normal page-access logging still applies.