Tax Templates & Checklists
Free templates and guides to simplify your tax preparation
FBAR Filing Checklist
The FBAR Filing Checklist is an essential tool designed for U.S. persons who hold financial accounts in foreign countries and must report them to the Financial Crimes Enforcement Network (FinCEN). Under the Bank Secrecy Act, any U.S. citizen, resident, or entity with a financial interest in or signature authority over foreign financial accounts exceeding $10,000 in aggregate value at any point during the calendar year must file FinCEN Form 114, commonly known as the FBAR. This checklist walks you through every step of the filing process, from identifying which accounts must be reported to gathering the necessary documentation, calculating aggregate balances, and submitting the form electronically through the BSA E-Filing System. It covers joint accounts, accounts held by spouses, trust accounts, and accounts over which you have signature authority but no financial interest. The checklist also addresses common pitfalls such as failing to convert foreign currency balances to U.S. dollars using the correct Treasury exchange rate, missing accounts at foreign branches of U.S. banks, and overlooking retirement or pension accounts that may qualify as reportable foreign financial accounts. Whether you are filing for the first time or are an experienced filer looking to ensure compliance, this checklist provides a systematic approach to meeting your FBAR obligations and avoiding potentially severe civil and criminal penalties for non-compliance.
Expat Tax Return Checklist
The Expat Tax Return Checklist is a comprehensive guide tailored for American expatriates who must navigate the unique complexities of filing U.S. federal income tax returns while living and working abroad. Unlike citizens of most other countries, U.S. citizens and permanent residents are taxed on their worldwide income regardless of where they reside, making annual tax compliance a critical obligation for every American living overseas. This checklist covers the full spectrum of expat tax considerations, including the Foreign Earned Income Exclusion (FEIE) under IRC Section 911, the Foreign Tax Credit (FTC) under IRC Sections 901-909, the Foreign Housing Exclusion and Deduction, treaty-based positions, and the interaction between U.S. and foreign tax systems. It guides you through determining your filing status, establishing either the bona fide residence test or the physical presence test for the FEIE, calculating your foreign earned income, identifying which foreign taxes qualify for the FTC, and properly completing Forms 2555, 1116, and other required schedules. The checklist also addresses commonly overlooked items such as state tax obligations that may persist after moving abroad, self-employment tax requirements, retirement account contributions made to foreign pension plans, and reporting requirements for foreign trusts and corporations. With detailed instructions for each step, this template ensures you claim every benefit available to you while maintaining full compliance with U.S. tax law.
W-2 Organization Worksheet
The W-2 Organization Worksheet is a structured spreadsheet template designed to help individuals and tax preparers systematically organize, verify, and reconcile all W-2 wage and tax statements received for a given tax year. Whether you held multiple jobs, received corrected W-2s, or need to reconcile employer-reported figures with your own records, this worksheet provides a clear framework for capturing every data point from each W-2 form. The template includes dedicated columns for each box on the W-2, from Box 1 (wages, tips, other compensation) through Box 20 (locality name), allowing you to see all employer-reported information in a single consolidated view. This is particularly valuable for taxpayers with multiple W-2s who need to ensure accurate reporting on their Form 1040 and related schedules. The worksheet also includes built-in validation checks that help you identify discrepancies between reported wages, Social Security wages, and Medicare wages — a common source of errors that can trigger IRS notices. Additional sections address state and local tax withholding across multiple jurisdictions, retirement plan contribution tracking, and third-party sick pay identification. For tax professionals preparing returns for clients with numerous W-2s, this template dramatically reduces data entry errors and speeds up the return preparation process. The worksheet also serves as excellent documentation for your records, providing a clear audit trail of all wage income reported for the year.
1099 Income Organizer
The 1099 Income Organizer is a comprehensive spreadsheet template designed to help taxpayers and tax professionals track, categorize, and reconcile all 1099 forms received during the tax year. With the IRS receiving copies of every 1099 issued, accurate reporting of all non-employment income is critical to avoiding costly notices and penalties. This organizer covers every major 1099 variant, including 1099-NEC for nonemployee compensation, 1099-MISC for miscellaneous income, 1099-INT for interest income, 1099-DIV for dividends and capital gain distributions, 1099-B for proceeds from broker transactions, 1099-R for retirement distributions, 1099-S for real estate transactions, 1099-G for government payments, 1099-K for payment card and third-party network transactions, and 1099-SA for HSA distributions. The template provides separate worksheets for each 1099 type with pre-built columns matching every box on the corresponding form, making it easy to enter and verify reported amounts. A summary dashboard automatically aggregates income by category, helping you see your total freelance income, investment returns, retirement distributions, and other income streams at a glance. This is particularly valuable for freelancers, gig economy workers, investors, and retirees who may receive dozens of 1099s each year. The organizer also includes a section for tracking income that should have been reported on a 1099 but was not — because taxpayers are required to report all income regardless of whether a 1099 was issued. Built-in cross-reference formulas help ensure that every dollar is accurately captured on the appropriate line of your Form 1040.
Business Expense Tracker Template
The Business Expense Tracker Template is a detailed spreadsheet designed for self-employed individuals, freelancers, and small business owners to systematically record, categorize, and summarize deductible business expenses throughout the tax year. Proper expense tracking is the foundation of maximizing your Schedule C deductions and minimizing your tax liability, yet many business owners leave significant deductions unclaimed simply because they lack an organized system. This template aligns expense categories directly with IRS Schedule C line items, making tax-time preparation dramatically faster and more accurate. Categories include advertising, car and truck expenses, commissions and fees, contract labor, depreciation, insurance, interest on business debt, legal and professional services, office expense, rent or lease payments, repairs and maintenance, supplies, taxes and licenses, travel, meals (with the applicable deduction percentage), utilities, and other expenses. Each category includes subcategories and description fields to provide the granular detail the IRS expects in case of audit. The template also includes a mileage log section for tracking business-use vehicle expenses under both the standard mileage rate and actual expense methods, a home office expense calculator supporting both the simplified and regular methods, and a section for tracking capital equipment purchases eligible for Section 179 or bonus depreciation. Monthly and quarterly summary tabs provide real-time visibility into your business spending patterns, helping you make informed financial decisions and estimate quarterly tax payments accurately. This template is an essential tool for any business owner who wants to maintain IRS-ready records without the cost of dedicated accounting software.
Foreign Income Worksheet
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.
Treaty Benefit Eligibility Checklist
The Treaty Benefit Eligibility Checklist is a detailed guide designed to help U.S. taxpayers and nonresident aliens determine whether they qualify for benefits under one of the many income tax treaties the United States maintains with foreign countries. Tax treaties can significantly reduce or eliminate U.S. withholding taxes on certain types of income, provide exemptions for specific categories of workers (such as teachers, students, and researchers), and resolve double taxation issues that arise when income is taxed by both the U.S. and a foreign country. However, claiming treaty benefits requires meeting specific eligibility criteria and properly disclosing treaty-based positions on your tax return. This checklist walks you through the process of identifying the relevant treaty, determining your residency status for treaty purposes using tie-breaker rules, evaluating limitation on benefits (LOB) provisions, identifying which articles apply to your specific income types, and properly documenting your treaty claims on Form 8833 (Treaty-Based Return Position Disclosure) or Form W-8BEN. The checklist covers common treaty scenarios including employment income exemptions, reduced withholding rates on dividends, interest, and royalties, pension and social security benefit provisions, capital gains exemptions for non-residents, and the special rules that apply to students and trainees. Special attention is given to the U.S.-Canada Tax Treaty — one of the most frequently used bilateral agreements — with detailed sections on cross-border commuter provisions, pension treaty benefits, and the Canadian RRSP election. Whether you are a foreign national working in the U.S. or an American with income from a treaty partner country, this checklist ensures you identify and properly claim every treaty benefit available to you.
Streamlined Filing Compliance Checklist
The Streamlined Filing Compliance Checklist is an essential guide for U.S. taxpayers who have failed to report foreign financial assets and pay all tax due in respect of those assets but whose failure was non-willful. The IRS Streamlined Filing Compliance Procedures provide a way for eligible taxpayers to come into compliance without facing the severe penalties that would otherwise apply under the traditional voluntary disclosure process. This checklist walks you through the complete streamlined filing process for both the Streamlined Domestic Offshore Procedures (SDOP) and the Streamlined Foreign Offshore Procedures (SFOP), which differ in their penalty structures and eligibility requirements. The SDOP requires the taxpayer to reside in the United States and imposes a 5% miscellaneous offshore penalty calculated on the highest aggregate balance of unreported foreign financial assets, while the SFOP is available to taxpayers who qualify as non-residents and imposes zero penalties. This checklist guides you through determining your eligibility, preparing the required three years of amended or delinquent income tax returns, filing six years of delinquent FBARs, completing the certification of non-willfulness (Form 14654 for domestic filers or Form 14653 for foreign filers), and calculating any applicable penalties. The template also covers the types of income that commonly trigger streamlined filings, including unreported foreign bank account interest, foreign pension income, offshore investment returns, and income from foreign rental properties. Detailed guidance is provided on the critical non-willfulness certification, which must contain a specific, honest, and complete narrative explanation of why the taxpayer's failure to report all income, pay all tax, and submit all required information returns was due to non-willful conduct rather than willful blindness or intentional avoidance.
Crypto Tax Reporting Template
The Crypto Tax Reporting Template is a comprehensive spreadsheet designed to help cryptocurrency investors and traders accurately track, calculate, and report their digital asset transactions for U.S. federal income tax purposes. With the IRS increasing enforcement around cryptocurrency compliance — including the addition of the digital asset question on the front page of Form 1040 — proper record-keeping has never been more critical. This template handles the full range of taxable crypto events, including buying and selling cryptocurrency, trading one cryptocurrency for another, using cryptocurrency to purchase goods or services, receiving cryptocurrency as payment for services, earning crypto from mining or staking, receiving airdrops and hard fork coins, and participating in DeFi protocols such as liquidity pools and yield farming. For each transaction, the template tracks the date acquired, date sold or disposed, proceeds, cost basis (using FIFO, LIFO, or specific identification methods), and the resulting gain or loss, with automatic classification as short-term or long-term based on the holding period. The template also handles wash sale considerations, which while not explicitly required for cryptocurrency under current law, are increasingly being scrutinized and may become mandatory under pending legislation. A dedicated section addresses the complexities of cost basis determination for coins received through mining, staking, airdrops, and hard forks, where the fair market value at the time of receipt establishes the initial basis. The output of this template maps directly to Form 8949 (Sales and Other Dispositions of Capital Assets) and Schedule D, making it easy to transfer your calculated gains and losses to your tax return. Whether you made a handful of trades or thousands, this template provides the organizational structure needed for accurate and defensible crypto tax reporting.
Rental Income Tracker
The Rental Income Tracker is a comprehensive spreadsheet template designed for landlords and real estate investors to systematically record rental income, track deductible expenses, and prepare Schedule E (Supplemental Income and Loss) data for their U.S. federal tax return. Whether you own a single rental property or a portfolio of investment properties, this template provides a structured framework for capturing every financial transaction associated with your rental activities throughout the tax year. The income section tracks gross rents received, security deposits (distinguishing between refundable deposits that are not income and forfeited deposits that are), advance rent payments, and any other income such as late fees or lease cancellation payments. The expense section is organized to match the line items on Schedule E, covering advertising, auto and travel expenses, cleaning and maintenance, commissions, insurance, legal and professional fees, management fees, mortgage interest, other interest, repairs, supplies, taxes, utilities, depreciation, and other expenses. Each expense entry captures the date, amount, vendor, property address, and description, creating a detailed audit trail that stands up to IRS scrutiny. For taxpayers with multiple rental properties, the template includes separate tabs for each property with a consolidated summary that automatically aggregates totals for Schedule E reporting. The depreciation section helps you track the basis, placed-in-service date, useful life, and accumulated depreciation for each property and any improvements, using the Modified Accelerated Cost Recovery System (MACRS) applicable to residential and commercial rental property. Additional features include a rent roll for tracking tenant payments and balances, a capital improvement log for distinguishing between deductible repairs and capitalizable improvements, and a section for tracking passive activity loss limitations that may restrict your ability to deduct rental losses against other income.
Self-Employment Tax Worksheet
The Self-Employment Tax Worksheet is an essential calculation tool for freelancers, independent contractors, sole proprietors, and other self-employed individuals who need to compute their self-employment (SE) tax liability and understand their total Social Security and Medicare tax obligations. Unlike W-2 employees whose employers withhold and match Social Security and Medicare taxes, self-employed individuals are responsible for both the employee and employer portions — a combined rate of 15.3% (12.4% for Social Security and 2.9% for Medicare) on net self-employment earnings. This worksheet mirrors the calculations on IRS Schedule SE (Form 1040) and walks you through each step of the computation, from determining your net earnings from self-employment through calculating the deductible half of SE tax that reduces your adjusted gross income. The worksheet also addresses the Additional Medicare Tax of 0.9% that applies to self-employment income exceeding $200,000 for single filers ($250,000 for married filing jointly), the Social Security wage base limit above which the 12.4% Social Security portion no longer applies, and the interaction between SE tax and other employment income when you also hold a W-2 job. A particularly valuable feature is the quarterly estimated tax payment calculator, which helps you determine how much to send to the IRS each quarter to avoid underpayment penalties. The worksheet factors in both your estimated income tax and SE tax liability, accounts for safe harbor rules (paying either 100% of last year's tax or 90% of the current year's tax), and generates payment vouchers with the correct amounts and due dates for each quarter. For self-employed individuals with both domestic and foreign self-employment income, the worksheet includes sections for calculating SE tax on foreign earnings and applying applicable Totalization Agreement exemptions for those working in treaty partner countries.
FATCA Reporting Template
The FATCA Reporting Template is a detailed guide and data collection tool designed to help U.S. taxpayers meet their reporting obligations under the Foreign Account Tax Compliance Act (FATCA) by accurately completing IRS Form 8938, Statement of Specified Foreign Financial Assets. Enacted in 2010 as part of the HIRE Act, FATCA requires U.S. taxpayers who hold foreign financial assets exceeding certain thresholds to report those assets on their federal income tax return. The reporting thresholds vary based on filing status and residence: for taxpayers living in the United States, the threshold is $50,000 on the last day of the tax year or $75,000 at any time during the year (doubled for married filing jointly); for taxpayers living abroad, the thresholds are $200,000 on the last day or $300,000 at any time (doubled for MFJ). This template helps you determine whether you meet the filing threshold, identify which assets qualify as specified foreign financial assets, and systematically gather the information needed for each asset category on Form 8938. Covered assets include foreign bank and securities accounts, foreign stocks and securities not held in a financial account, interests in foreign entities (partnerships, corporations, trusts, estates), foreign financial instruments and contracts, interests in foreign retirement plans, and certain foreign-issued insurance and annuity contracts. The template provides separate sections for each asset type with fields matching the exact requirements of Form 8938 Parts I through VI, including the asset description, identifying information, maximum value during the tax year, value at year-end, income earned, and the tax return location where the income is reported. For assets jointly owned with a spouse, specific guidance addresses whether separate or joint reporting is required. This template works hand-in-hand with our FBAR Filing Checklist, as many taxpayers with FATCA obligations also have FBAR requirements, though the two regimes have different thresholds, different covered assets, and different filing procedures.
Canadian Tax Return Checklist
The Canadian Tax Return Checklist is a specialized guide designed for U.S.-Canada cross-border taxpayers who must navigate the complexities of filing tax returns in both countries. Whether you are a U.S. citizen living in Canada, a Canadian citizen with U.S. tax obligations, a cross-border commuter, or someone with income from both countries, this checklist provides a structured approach to ensuring compliance with both the Canada Revenue Agency (CRA) and the Internal Revenue Service (IRS). The checklist addresses the unique challenges of dual filing, including the interaction between Canadian T1 returns and U.S. Form 1040, the application of the U.S.-Canada Tax Treaty to prevent double taxation, currency conversion between CAD and USD, and the proper treatment of Canadian-specific income types and deductions on U.S. returns. Detailed sections cover Canadian employment income reported on T4 slips, investment income on T5 slips, Old Age Security (OAS) and Canada Pension Plan (CPP) benefits, RRSP and RRIF distributions, Registered Education Savings Plans (RESPs), Tax-Free Savings Accounts (TFSAs) — which are not recognized as tax-exempt in the U.S. — and the complex interplay between Canadian provincial taxes and U.S. state taxes. The checklist also addresses the critical issue of Canadian-controlled private corporation (CCPC) ownership, which may trigger U.S. Controlled Foreign Corporation (CFC) reporting requirements under Subpart F and potentially the Passive Foreign Investment Company (PFIC) rules. For U.S. citizens in Canada who must file both returns, the checklist provides guidance on the proper ordering of return preparation (typically preparing the Canadian return first), claiming Foreign Tax Credits on the U.S. return for Canadian taxes paid, and utilizing treaty provisions to minimize the overall combined tax burden.
Investment Income Organizer
The Investment Income Organizer is a comprehensive spreadsheet template built to help individual investors and tax professionals consolidate, categorize, and reconcile all investment-related income for accurate U.S. tax return preparation. Investment income comes in many forms — dividends, interest, capital gains, rental income, partnership distributions, royalties, and more — each with different tax rates and reporting requirements. This organizer brings clarity to the complexity by providing structured worksheets for each investment income type, with built-in logic that maps your income to the correct tax forms and schedules. The dividends section distinguishes between qualified dividends (taxed at favorable capital gains rates) and ordinary (non-qualified) dividends, tracks foreign source dividends eligible for the Foreign Tax Credit, and captures return of capital distributions that reduce your cost basis rather than creating current taxable income. The interest income section covers taxable interest, tax-exempt municipal bond interest (which may still affect your AMT calculation), OID (original issue discount), and accrued interest paid. The capital gains section provides a transaction-by-transaction log that calculates short-term and long-term gains and losses, handles wash sale adjustments, and tracks capital loss carryforwards from prior years. Additional sections cover Schedule K-1 income from partnerships and S corporations, real estate investment trust (REIT) distributions with their unique tax characteristics, master limited partnership (MLP) income, and royalty payments. A consolidated summary dashboard aggregates all investment income by tax character (ordinary, qualified, short-term capital gain, long-term capital gain, tax-exempt) and maps each total to the appropriate line on your Form 1040, Schedule B, Schedule D, and Form 8949. This template is particularly valuable for investors with complex portfolios spanning multiple brokerages who need a single consolidated view of their investment tax picture.
Estimated Tax Payment Tracker
The Estimated Tax Payment Tracker is a practical spreadsheet tool designed for taxpayers who are required to make quarterly estimated tax payments to the IRS and potentially to state taxing authorities. If you have income that is not subject to withholding — such as self-employment income, investment income, rental income, alimony received, or other non-wage income — you are generally required to make estimated tax payments if you expect to owe $1,000 or more in federal tax after subtracting withholding and credits. This tracker helps you calculate, schedule, record, and verify your estimated tax payments throughout the year, ensuring you meet your quarterly obligations and avoid underpayment penalties. The template begins with an annual income projection section where you estimate your total income, deductions, credits, and resulting tax liability for the year. Based on these projections, the tracker calculates your required quarterly payment using both the current-year method (90% of current year's estimated tax) and the prior-year safe harbor method (100% of prior year's tax, or 110% if prior year AGI exceeded $150,000), recommending the lower of the two amounts to minimize cash flow impact while avoiding penalties. Each quarter has a dedicated section for recording payment date, amount paid, payment method (EFTPS, Direct Pay, check, credit card), and confirmation number. A running balance section shows your cumulative payments versus required amounts, flagging any quarters where you may be underpaid. The tracker also calculates potential underpayment penalties using the IRS annualized income installment method, which can reduce or eliminate penalties for taxpayers whose income is unevenly distributed throughout the year — common for seasonal businesses, investors with large year-end capital gains, and freelancers with variable workloads. For cross-border taxpayers, additional sections track estimated payments to foreign tax authorities and their impact on Foreign Tax Credit calculations.
Ready 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