PDF Information Regarding FBAR Penalty Foreign Conversion ...

Information Regarding FBAR Penalty Foreign Conversion Spreadsheets

1) The currency conversion rates shown on the enclosed worksheet tabs are the historical exchange rates obtained from Financial Management Service (FMS) referenced in IRM 4.26.16.3.6 (See Comment for IRM Detail in Cell A1) at 12/31 of each Year.

Source at:



Financial Management Services

2) See Comments in each Spreadsheet Tab for additional Detail, by moving cusor over red part of each marked cells like Cell A1 Above. Each Spreadhseet has custom Headers and Footers when printed that add additional inforamtion when printed. NOTE! These Spreadsheets are not protected, so please do not delete rows in the spreadsheets, which could change formulas!!!!!

3) Custom Worksheets Tabs to Convert British Pounds (GBP), Swiss Francs (CHF), and EUROS into US Dollars for years 12/31/2002 thru 2012.

4) Worksheet Tabs for Various Countries to Convert Foreign Currency to US Dollars for 12/31/2003 through 12/31/2012 are included.

5) The Main Formula used is Foreign Currency(FC) /RATE or FC/Rate, since the rate is the amount equivalent to 1 United States Dollar.

6) One Great Website to Check Exchange Rates at various dates is located at

Oanda Currency Converter Site

NOTE! PER IRM 4.26.16.3.6 the IRS must use the Historical rates at 12/31 each year contained in these spreadsheets for FBAR Penalties from

Financial Management Service (FMS) at .

Financial Management Services

Foreign Currency Conversion Table------ British Pounds (GBP)-----Converted into United States (US) Dollars---Multiple Years

United States Treasury Foreign Currency (FC)

Exchange Rates

Years 12/31/2002 12/31/2003 12/31/2004 12/31/2005 12/31/2006 12/31/2007 12/31/2008 12/31/2009 12/31/2010 12/31/2011 12/31/2012

(FC) To $1.00 0.6210 0.5660 0.5240 0.5820 0.5120 0.4860 0.6570 0.6160 0.6400 0.6370 0.6180

Input -

British Pounds (GBP)

Amount

Output -

United States (US) Dollars Amount $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Historical Exchange Rates By Finance Management Service (FMS) Per IRM 4.26.16.3.6

Foreign Currency Conversion Table---- EUROS----- Converted into United States (US) Dollars--Multiple Years

United States Treasury Foreign Currency (FC)

Exchange Rates

Years 12/31/2002 12/31/2003 12/31/2004 12/31/2005 12/31/2006 12/31/2007 12/31/2008 12/31/2009 12/31/2010 12/31/2011 12/31/2012

(FC) To $1.00 0.9550 0.8060 0.7530 0.8470 0.7590 0.6800 0.7310 0.6950 0.7700 0.7650 0.7590

Input -

EURO

Amount

Output -

United States(US) Dollars Amount $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Historical Exchange Rates By Finance Management Service (FMS) Per IRM 4.26.16.3.6

Foreign Currency Conversion Table--- Swiss Francs (CHF)--- Converted into United States (US) Dollars---Multiple Years

United States Treasury Foreign Currency (FC)

Years 12/31/2002 12/31/2003 12/31/2004 12/31/2005 12/31/2006 12/31/2007 12/31/2008 12/31/2009 12/31/2010 12/31/2011 12/31/2012

(FC) To $1.00 1.3860 1.2760 1.1400 1.3170 1.2260 1.1280 1.0980 1.0310 1.0000 0.9350 0.9160

Input -

Swiss Francs (CHF)

Amount

Historical Exchange Rates By Finance Management Service (FMS) Per IRM 4.26.16.3.6

Foreign Currency Conversion Table--- Swiss Francs (CHF)--- Converted into United States (US) Dollars---Multiple Years

Output -

United States(US) Dollars Amount $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Historical Exchange Rates By Finance Management Service (FMS) Per IRM 4.26.16.3.6

United States Treasury----Foreign Currency Conversion Table into US Dollars----Historical Exchange Rates Per IRM 4.26.16.3.6----12/31/2003

United States Treasury Currency Conversion Table at 12/31/2003

COUNTRY-CURRENCY

AFGHANISTAN - AFGHANI ALBANIA - LEK ALGERIA - DINAR ANGOLA - KWANZA ANTIGUA - BARBUDA - E. CARIBBEAN DOLLAR ARGENTINA-PESO ARMENIA - DRAM AUSTRALIA - DOLLAR AUSTRALIA - SCHILLING AZERBAIJAN - MANAT BAHAMAS - DOLLAR BAHRAIN - DINAR BANGLADESH - TAKA BARBADOS - DOLLAR BELARUS - RUBLE BELGIUM-FRANC BELIZE - DOLLAR BENIN - CFA FRANC BERMUDA - DOLLAR BOLIVIA - BOLIVIANO BOSNIA-HERCEGOVINA MARKA BOTSWANA - PULA BRAZIL - REAL BRUNEI - DOLLAR BULGARIA - LEV BURKINA FASO - CFA FRANC BURMA - KYAT BURUNDI - FRANC CAMBODIA (KHMER) - RIEL CAMEROON - CFA FRANC CANADA - DOLLAR CAPE VERDE - ESCUDO CENTRAL AFRICAN REPUBLIC - CFA FRANC CHAD - CFA FRANC CHILE - PESO CHINA - RENMINBI COLOMBIA - PESO COMOROS - FRANC CONGO - CFA FRANC COSTA RICA - COLON COTE D'IVOIRE - CFA FRANC

CROATIA - KUNA CYPRUS - POUND CZECH - KORUNA DEM REP OF CONGO-CONGOLESE FRANC DENMARK - KRONE DJIBOUTI - FRANC DOMINICAN REPUBLIC - PESO ECAUDOR-SUCRE EGYPT - POUND EL SALVADOR-DOLARES EQUATORIAL GUINEA - CFA FRANC ERITREA - NAKFA ESTONIA - KROON ETHIOPIA - BIRR EURO ZONE - EURO FIJI - DOLLAR FINLAND-MARKKA FRANCE-FRANC GABON - CFA FRANC GAMBIA - DALASI

Foreign Currency (FC) Equivalents to One United States (US) Dollar

(FC) TO $1.00

48.1700 105.6000

70.1850 77.7140

2.7000 2.9550 563.0000 1.3600 0.0000 4900.0000 1.0000 0.3770 58.0000 2.0200 2145.0000 0.0000 2.2000 528.7200 1.0000 7.7960 1.5720 4.5580 2.9120 1.7080 1.5770 528.7200 450.0000 1062.3000 3990.0000 528.7200 1.3240 89.8270 528.7200 528.7200 596.7000 8.2650 2806.7500 557.1520 556.0000 417.8400 528.7200

6.1300 0.4710 25.7110 368.5000 6.0010 176.9500 34.8000 1.0000 6.1500 1.0000 528.7200 13.5500 12.6120 8.6200 0.8060 1.7440 0.0000 0.0000 528.7200 30.0000

Input Foreign Currency (FC)

Amount

Output United States (US) Dollars

Amount

$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Financial Management Service (FMS)

Page 6 of Page 75



 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download