Home
Free Stuff What's New
Free Newsletter
Free Spreadsheets
Customize Sheets
Learn Basic Accounting Basic Accounting
Bookkeeping
Basic Terms
Journal Entries
General Ledger
Financial Statements
Learn Accounting
Small Business Accounting Accounting 101
Basic Principles
Cash/Accrual
Break-Even Point
Cost Accounting
Petty Cash
Software Reviews
Free Biz Software
Business Budget Tips
Biz Deductions
Schedule C
Biz Receipts
Recordkeeping
Estimated Taxes
Tax Planning
Payroll Set Up Payroll
Payroll Taxes
1099-MISC
W-3
Form 941
How To Build a Site
Choose Accountant
Office Supplies
Create a Logo
Evernote
Resources Resources/Links
Site Search
FAQ
Contact Information About Me
Contact Me
Terms of Use

[?] Subscribe To This Site

XML RSS
Add to Google
Add to My Yahoo!
Add to My MSN
Subscribe with Bloglines

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!

Maintaining proper accounting records are 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 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)

Simplify your taxes & bookkeeping - Shoeboxed.com

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.

BA-1Biz_Auto Workbook:This workbook (set of spreadsheets) consists of monthly general ledgers that automatically carry all totals to a monthly income statement. Then all the totals from the monthly reports automatically generate an quarterly report that then generate an annual report.

It is set up for 1 primary business.



BA-1Biz-Manual Workbook: This workbook (set of spreadsheets) consists of a monthly general ledger, monthly report, and an annual 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.

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



BA-3Biz-Auto Workbook: This workbook (set of spreadsheets) consists of monthly general ledgers that automatically carry all totals to a monthly income statement. Then all the totals from the monthly reports automatically generate an quarterly report. All this information generates an annual report.

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.



BA-3biz-Manual Workbook: This workbook (set of spreadsheets) consists of a monthly general ledger, monthly report, and an annual report.

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.







Testimonies

"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 free spreadsheet- 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

"I just want to say thank you and may God bless you"
Amine

"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

"Many thanks for your spreadsheets."
Peter from UK

“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


Additional Resources

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.

accounting course

Click Here for Details


Other pages that may interest you:



Go to Basic Accounting Concepts from Free Spreadsheets


Looking for something?

Use SiteSearch



small business accounting software



AccountingCoach Pro

Master Accounting Package


Click Here for Details


Free Accounting Spreadsheets

when you...

subscribe to free newsletter:



Free Mileage Log Sheet

Free Mileage Log and what must be included on it.



How to Record Accounting Journal Entries

How to Record Accounting Journal Entries



Free Small Business Software

Free Small Business Software


Recommended Products

Outright - Free Yourself from Accounting



Site Build It!

Shoeboxed Works Great With Evernote