But Excel is the wrong tool for doing small business accounting.
This^.
I managed a small company of 9 employees (we were an aquaculture farm that sold our products both wholesale and retail) and we used Quickbooks. I know it's not the only business software out there but I would NOT attempt to run my business with excel spreadsheets.
Things Quickbooks can do easily that Excel cannot
- PROCESS PAYMENTS (including CC, paypall and cash sales)!!
- Generate Invoices
- Notify delinquent accounts and auto-email (or mail) invoices to said clients
- Track Sales & break it down by week, month, quarter
- Track expenses & break it down by week, month, quarter
- Store vendor's information
- Sync with Turbotax for tax-document prep (or file reports for useful for a CPA in filing your taxes)
- Shipping! Ship with UPS/FedEx/USPS & track packages
- email customers tracking numbers, receipt & 'capture' their emails for future marketing
you can probably figure out ways of doing these things with excel, but with QB it's dirt simple.
Consider this typical example - a customer wants to buy a bracelet and have you ship it to his sister.
In about 60 seconds with QB you can 'add new customer (and record billing & shipping addresses, email and phone number(s)), make a sale (charging appropriate sales tax), generate a professional-looking invoice & receipt, accept payment, mark that item as 'paid', have that item removed from your inventory and have all of that info included in your monthly sales report and quarterly tax fillings.
I did something similar to this at least a dozen times/day - plus sent out orders to our existing clients with invoices. I wouldn't want to attempt it with excel.
For a small business the cost is negligible