Free Spreadsheets

Free spreadsheets for small business owners to track and record their accounting data!

Maintaining proper accounting records is imperative to a small business owner.

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

If you’re like me you don’t have the time or the money to set up an expensive accounting program, when you are trying to your small business up and running.

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 newsletter: Basic Accounting Help, I am giving these accounting spreadsheets!

Simply fill in the form below 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)

Free Spreadsheets Descriptions

All of my free accounting workbooks are 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 yet, my accounting spreadsheets may be just what you need.

If you are a church or nonprofit, I have free spreadsheets designed specifically for you.

I have 2 free accounting workbooks available.

Note: You must have MS Excel or another compatible spreadsheet application like OpenOffice installed on your computer to download and use the accounting spreadsheets.

Automatic Free Spreadsheets:

free accounting softwar

I have 1 "automatic"  free accounting workbook (set of spreadsheets) available from this site.

It has fields for up to 9 income accounts and 28 expenses accounts. 

The workbook includes:

  • 12 Monthly General Ledgers (automatically carry all totals to a monthly income statement)
  • 12 Monthly Profit and Loss Reports (all the totals from the monthly reports automatically generate an quarterly report that then generate an annual report)
  • 4 Quarterly P/L Reports
  • 1 Annual P/L Report
  • 1 Summary P/L Report (shows monthly income and expenses for comparisons)
  • 1 Budget to Actual Report (compares annual budget to previous year's and current year's expenses)

Attention: I ask you to sign up for my free newsletter because it is the only way I can contact you to alert you to any errors in my spreadsheets; however, if you do not wish to be contacted and do not wish to receive my free is the download page for the spreadsheets: Accounting Spreadsheets

Manual Free Spreadsheet:

This workbook includes:

  • 12 Monthly General Ledgers 
  • 12 Monthly Profit and Loss Reports
  • 4 Quarterly P/L Reports
  • 1 Annual P/L Report

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.

Since it is easily modified, it is good for start up businesses.

Additional Resources

Other pages that may interest you:

Free Mileage Log...

Click on image above for more details.

Spreadsheet Reviews...

"I absolutely love the spreadsheets!!  Thank you so much! They are exactly what I needed."

Becky from Back to Natural

"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

"I love your accounting spreadsheets- thank you!"

Sandra from the UK

"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

Business mileage can be a very good deduction for your small business.

It can also be a nightmare, if all the IRS required information is not included in your mileage log.

See what must be included and get a free mileage log!