How to calculate interest earned from non-US bank accounts for FBAR and 8938

*gulp* the mere though of accomplishing this is overwhelming. I know that there are many of you out there who are like me, working class, don't have extra budget to hire a CPA to do most of the work so I will try my best to share, step-by-step my (far from perfect) method of FBAR and 8938 reporting (whatever it is that I can do and you can do on our own before you call a CPA or tax preparer for help).

1) Compile all bank statements (or as many as you can possibly get - the ones that are missing, well, you can sort of guess the % of interest per month/per year to estimate the total amount.

2) Use the spreadsheet. There are no available templates/formats out there as a guidance (not that I know of - and I've browsed up to approx 600 websites)...so I am sharing my own version (& this is my progress thus far, since my very first blog posting here):-

*Important info to include in your spreadsheet so you don't have to keep referring to your bank statements when filling up Form 8938
i) Bank account numbers
ii) Bank names & address
iii) Total interest accrued for the tax year (converted to USD)
iv) Maximum value of account during tax year (converted to USD)
v) Was/were the account/s opened during the tax year?
vi) Total interest of all bank accounts for the tax year (converted to USD)
v) Maximum value of all accounts for the tax year (converted to USD)

3) Repeat the above for all years (previous years that you've missed)

4) Next, we needs to convert the total amount of interest earned per year to USD (I am still at Step 2 :p *exhausted*...so these are I can share now about what to do)

5) My blog posting on how to obtain past currency exchange rates