Description
The Foreign Income Worksheet is a specialized spreadsheet template designed to help U.S. taxpayers who earn income from foreign sources accurately categorize, convert, and report their international earnings on their federal tax return. Whether you receive a salary from a foreign employer, earn rental income on overseas property, collect dividends from foreign corporations, or operate a business through a foreign entity, this worksheet provides a structured framework for capturing every type of foreign-source income and preparing it for proper U.S. tax reporting. The worksheet begins with a comprehensive income categorization section that separates foreign earned income (wages, salaries, self-employment income) from foreign unearned income (interest, dividends, rents, royalties, capital gains) — a critical distinction because different types of foreign income qualify for different exclusions, credits, and treaty benefits. A built-in currency conversion tool allows you to enter income amounts in the original foreign currency and automatically converts them to U.S. dollars using either the annual average exchange rate or the transaction-date spot rate, depending on the income type and your chosen method. The worksheet also includes sections for tracking foreign taxes paid or accrued on each income category, which is essential for accurately claiming Foreign Tax Credits on Form 1116. Separate tabs address foreign pension income, foreign social security benefits, and income from controlled foreign corporations (CFCs) and passive foreign investment companies (PFICs), each of which has unique reporting requirements. For U.S. citizens and residents with Canadian income — one of the most common cross-border scenarios — the worksheet includes Canada-specific sections addressing T4 employment income, T5 investment income, and RRSP/RRIF distributions, with guidance on applying the U.S.-Canada Tax Treaty.
Steps
List All Foreign Income Sources
Identify every source of foreign income including employment, self-employment, investments, rental properties, pensions, and government benefits.
Categorize Income by Type
Separate income into earned vs. unearned categories and identify which income types may qualify for the FEIE, FTC, or treaty benefits.
Convert Foreign Currency to USD
Enter amounts in original foreign currency and apply the appropriate exchange rate (annual average or spot rate) to convert each income item to U.S. dollars.
Record Foreign Taxes Paid
Document all foreign income taxes paid or accrued, including withholding taxes, estimated payments, and year-end assessments, for each income category.
Apply Treaty Provisions
Review applicable tax treaty provisions that may reduce or eliminate tax on specific income types and document any treaty-based positions.
Map Income to U.S. Tax Forms
Transfer categorized and converted income amounts to the appropriate lines on Form 1040, Schedule B, Schedule D, Schedule E, Form 2555, and Form 1116.
Applicable Forms
Target Audience
U.S. taxpayers with foreign-source income including expats, cross-border workers, international investors, and those with Canadian income
Frequently Asked Questions
Which exchange rate should I use to convert foreign income to U.S. dollars?
How do I report Canadian RRSP income on my U.S. tax return?
Can I claim a Foreign Tax Credit for Canadian provincial taxes?
Get Expert Help
Need personalized guidance? Our tax professionals can help you with this and more.
Book ConsultationReady to Get Started?
Schedule a consultation or explore our services to see how we can help with your tax and accounting needs.
Need immediate assistance? Call us at +1 (409) 916-8209