Do Your Own Bookkeeping, with an Excel Income Statement Template

By Ryan Smith on May 18, 2018

Cartoon illustration of an income statement

You don’t *need* fancy accounting software to do your own bookkeeping.

You just need a good Excel template (and some elbow grease).

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

  • Enter your information below, 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.

 

This post is to be used for informational purposes only and does not constitute legal, business, or tax advice. Each person should consult his or her own attorney, business advisor, or tax advisor with respect to matters referenced in this post. Bench assumes no liability for actions taken in reliance upon the information contained herein.

Portrait of Ryan Smith
Written By

Ryan Smith

Ryan writes for Bench, the online bookkeeping service that does your bookkeeping for you.