Do Your Own Bookkeeping with an Excel Income Statement Template

You don’t need fancy accounting software to do your own bookkeeping. You just need a good Excel template (and some elbow grease).

Income Statement Template

Our expert bookkeepers here at Bench have built an Income Statement template in Excel that you can use to turn your business transactions into an Income Statement.

How to use the Income Statement template

  • Fill out the form, and we’ll email you the Excel template
  • On the first tab, called “Chart of Accounts”, enter all the categories of income, expenses, and cost of sale that you use in your business.
  • On the second tab, called “Transactions” is where you’ll enter your transaction details—date, description, amount, and category (matching with the categories in your Chart of Accounts tab).
  • The third tab is where your Income Statement will automatically display. Just select a date range for the Income Statement you’d like to see (for example, March 1 to March 28), and voila, you have your Income Statement.

Further reading: Understanding Income Statements vs. Balance Sheets

And if your business reaches the point where it doesn’t make sense to do your own bookkeeping, let us know. We’ll do your bookkeeping for you.

Do Your Own Bookkeeping with an Excel Income Statement Template

You don’t need fancy accounting software to do your own bookkeeping. You just need a good Excel template (and some elbow grease).

Download the Guide

Enter your details to download your free copy

Three ways this template will help you

1

Generate an income statement automatically

Once you've entered your transactions, the template will automatically generate an income statement. No need to hire an accountant or use complex software.

2

Simplify your bookkeeping

Often we procrastinate on bookkeeping because the task feels complicated. This simple spreadsheet makes it dead simple.

Save money on accounting software

Accounting software isn't free. Doing it yourself in Excel is.

Want a free month of bookkeeping?

Sign up for a trial of Bench. We’ll do one month of your bookkeeping and prepare a set of financial statements for you to keep. No pressure, no credit card required.

Decorative patterns