• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Download Schedule B Calculator Excel Template

Download Schedule B Calculator Excel Template

Schedule B Calculator is an excel template that consists of calculations of taxable interest and ordinary dividends under Schedule B of Form 1040 and 1040A for federal income tax.

Interests and dividend incomes received during a tax year are reported in Schedule B.

It is not mandatory to file Schedule B for taxpayer every year. A taxpayer requires filing the Schedule B only when he/she receives interest and dividend above a certain threshold.

Who needs to file Schedule B?

According to IRS, you require to file Schedule B (Form 1040A or 1040) if any of the following applies:

Schedule B Calculator

For the purpose ease of understanding and avoiding mistakes, we have created an excel template Schedule B Calculator considering all the above points.

Schedule B Calculator

Click here to download Schedule B Calculator Excel Template.

To download the same calculator in Numbers click the link below:

Schedule B Calculator Apple Numbers Template

It is just the replica of the Schedule B fillable PDF available on IRS website. Click on the link below to download the pdf.

Schedule B – Interests and Ordinary Dividends

Let us discuss the contents of the template in detail.

Contents of Schedule B Calculator

Schedule B consist of 3 sections:

  1. Interests – Part I
  2. Ordinary Dividends – Part II
  3. Foreign Accounts and Trusts – Part III

1. Interests – Part I

Usually, all types of interest are subject to federal income tax except Interest earned on Series I and EE savings bonds issued after 1989.

These interests include interest from bank savings accounts, investment in corporate bonds etc. The entities paying interest report them in Form 1099-INT.

1099 provides you with relevant details to be filled in Schedule B.

Schedule B Calculator

If you received a Form 1099-INT, Form 1099-OID, or substitute statement from a brokerage firm, list the firm’s name as the payer and enter the total interest shown on that form.

Just enter the relevant description as well as amounts in respective cells in Part I. It will automatically make subtotals with a predefined formula using the SUM Function.

As Interests earned on Series I and EE savings bond are not subject to federal income tax, it will be deducted from the interest amounts.

2. Ordinary Dividends – Part II

Dividends refer to rewards in form of cash or shares etc given by a company to its shareholders. Similar to interests, if the total dividends income exceeds a certain threshold, it is mandatory to file Schedule B.

You need to report the dividends along with the name of the company that has paid the dividends.

Schedule B Calculator

Enter the name of the organization/company paying the dividend and amounts in Part II. The system will automatically subtotal the amount for you.

3. Foreign Accounts and Trusts – Part III

A taxpayer must complete Part III, if :

(a) has the taxable interest or ordinary dividends over $1,500;

(b) has a foreign account; or

(c) has received a distribution from, or were a grantor of, or a transferor to, a foreign trust.

Schedule B Calculator

Taxpayers having interests from foreign accounts during the tax year must file FinCEN Form 114.

A taxpayer who has been receiving a distribution from, or were the grantor of, or transferor to, a
foreign trust has to file Form 3520.

This section only consists of only yes or no. Thus, no amounts are reported here. All amounts will be reported in FinCEN Form 114, Form 3520 etc.

We thank our readers for liking, sharing and following us on different social media platforms.

If you have any queries please share in the comment section below. I will be more than happy to assist you.

« Download Itemized Deductions Calculator Excel Template
Download Child Tax Credit Calculator Excel Template »

Filed Under: Federal Income Tax Templates

You are Here: Home / Excel Templates / Federal Income Tax Templates / Download Schedule B Calculator Excel Template

About Shabbir Bhimani

I have worked in Excel and like to share functional excel templates at ExcelDataPro.

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Federal Income Tax Templates

  • Traditional IRA Calculator Excel Template
  • Roth IRA Calculator Excel Template
  • Adjusted Gross Income Calculator Excel Template
  • Modified Adjusted Gross Income Calculator Excel Template
  • Traditional VS Roth IRA Calculator in Excel
  • Simple Tax Estimator Excel Template
  • Itemized Deductions Calculator Excel Template
  • Schedule B Calculator Excel Template
  • Child Tax Credit Calculator Excel Template
  • 401k Calculator Excel Template
  • Section 179 Deduction Calculator Excel Template
  • Adoption Tax Credit Calculator Excel Template

ExcelDataPro

Free Excel Pro Templates

  • Glossary
    • Accounting Glossary
    • HR & Payroll Glossary
    • Tax Glossary
  • Templates
    • Accounting
      • Financial Analysis
      • Financial Statement
    • Educational
    • Taxation
      • Federal Income Tax
      • GST
      • UAE VAT
      • UK VAT
    • Human Resources
      • HR & Payroll
      • HR Metrics
    • School Management
    • Social Media
    • Sales-Marketing
    • Personal Finance
    • Other
      • Health & Fitness
  • Functions
  • FAQ’s
  • Blog
  • Home
  • Contact
  • Privacy
  • Terms

© ExcelDataPro 2023. Content Licensed Under Creative Commons with Attribution Required

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT