Free Spreadsheets to Track your Revenue and Expenses

Free Spreadsheets: Tired of trying to keep up with your small business’s accounting on paper?

My free spreadsheets may be just what you are looking for!

You need to be able to tell at a glance where you stand financially in order to make sound business decisions.

So I built some accounting spreadsheets that will automatically generate monthly, quarterly, and annual income reports.

With them you can tell at a glance if you can afford that printer you so desperately need; make tax time less stressful; and have the reports ready in an instant to take to the bank for that small business loan.

As a special thank you gift for those who sign up for my free small business newsletter, I am giving these accounting spreadsheets away....free!

Simply fill in the form on the free newsletter page and after you have confirmed your subscription you will receive a welcome email with link to your free spreadsheets.
(Descriptions of all free accounting software downloads are below)

Accounting Spreadsheets Descriptions

All of my free spreadsheets are just single entry accounting spreadsheets. See my double entry bookkeeping page for the difference between single and double entry accounting systems. If you can afford it and have the time to learn it, double entry software is usually the best for your accounting needs.

However, if you are a small business that is just starting up or cannot afford expensive accounting software just yet, my free accounting software downloads may be just what you need.

If you are a church or nonprofit, I have free accounting spreadsheets designed specifically for you, please see my church accounting site.

Note: You must have MS Excel or another compatible spreadsheet application like OpenOffice installed on your computer to download my free spreadsheet software. You will also need to know which Excel version you have...if you are not sure simply right-click on your Excel and go to properties.

However, the automatic spreadsheets are not compatible with Microsoft Works...if you can get them open they will not contain the formulas that automatically carry over the GL totals to the Reports.

I have 4 different free spreadsheets. Two for small business owners with only one primary business and two for entrepreneurs with multiple businesses such as web site owners with multiple sites. I have them all zipped together in one file. You can pick which one will work best for you and delete the rest.

It is set up for 1 primary business.

Unlike my automatic accounting spreadsheets....only the annual report is automatically generated. You will have to manually put in all the totals for the monthly reports.

It is set up for one primary business. Since it is easily modified, it is good for start up businesses.

It is set up for 3 businesses. It is great for entrepreneurs with multiple web sites or multiple businesses that want to track each separately and together! P.S. you can add or delete businesses. See this page.

Unlike my automatic accounting free spreadsheets....only the annual report is automatically generated. You will have to hand put in all the totals for the monthly reports.

It is set up for 3 businesses. Since it is easily modified, it is good for start up or smaller businesses.

"Thank you so much. I have been stressing about doing this accounting stuff for my husband. Quickbooks was too complicated for his small business and these spreadsheets are just what I was looking for!!!"
Josi Michael

"As a small business owner my expertise has always been in marketing and customer service. I have struggled with many different options for my bookkeeping. Vickey's basic accounting help and ledgers have made my business so much easier!"
Kelly Howard

"Thank you for your free spreadsheet! It has helped me tremendously to track daily sales and get a grip on the full scope of what revenues are coming in and my expenses."
Gabby of Gumdrop Swap

“I just want to say "Thank you" for all the help you send me thru your newsletters. I have used your spreadsheets for 2 years for my small business and they work out great. I have all my figures together at the end of the year for my accountant, it’s so easy.”
Debbie Lewing
Petroleum Landman
Shepherd, Texas

Instructions for free accounting spreadsheets

Need to add more rows, accounts, etc. to the free accounting spreadsheets>

See this page on customizing your spreadsheets.

Outright.com Online Bookkeeping - Free Trial. If you can't use or don't want my accounting spreadsheets...you might want to check out this single entry bookkeeping system. It is easy to use and easy to track and analyze your financial data with.

Microsoft Office 2010 Home & Student includes 2010 versions of Excel, PowerPoint, Word, and OneNote.

Microsoft Excel 2010 Plain & Simple: Get the guide that makes learning Microsoft Excel 2010 plain and simple! This full color, no-nonsense book shows you the quickest ways to solve a problem or learn a skill, using easy-to-follow steps and concise, straightforward language. You'll analyze, manage, and share information in more ways than ever before.

Microsoft Office Excel Home and Student 2007 [Old Version] includes 2007 versions of Excel, PowerPoint, Word, and OneNote.

One look at Excel 2007, with its new Office Button, Quick Access toolbar, and Ribbon, and you realize you’re not in Kansas anymore. Well, have no fear—Excel 2007 For Dummies is here.

If you’ve never worked with a computer spreadsheet, or if you’ve had some experience with earlier versions of Excel but need help transitioning, here you’ll find everything you need to create, edit, format, and print your own worksheets (without sacrificing your sanity!). Excel 2007 for Dummies covers all the fundamental techniques, concentrating on only the easiest, most user-friendly ways to get things done.

Scan, Categorize, and Organize Your Documents at Shoeboxed.com! It is like having your own personal assistant. Shoeboxed enters all your business receipts into your own secure account. You can then import the organized data to PDF, Excel, Quicken, Quickbooks, Freshbooks, Outright.com and Evernote. You can even try it free for a month!

Want to learn accounting basics at your own pace? Don’t have time to take an accounting course? Need help with your accounting homework?

AccountingCoach Pro can help small business owners, accountants wanting to brush up on their accounting skills, and students needing help with their accounting course.

Other pages that may interest you:

• Basic Accounting Concepts Made Easy
  
  
• Accounting Basic Terms
  
  
• Number One Accounting Rule - Accounting 101

Go to Basic Accounting Concepts from Free Spreadsheets