Greenleaf Accounting

Virtual Bookkeeping & Accounting Services

(814) 450-0072
  • Email
  • LinkedIn
  • RSS
  • Twitter
  • Home
  • Services
  • About
  • Testimonials
  • Blog
  • Contact

Stop Using Excel for Your Bookkeeping!

April 19, 2018 by Deb Howard Greenleaf

Many new business owners try to use Excel for bookkeeping, especially in the early days of their businesses. They are, understandably,  trying to keep costs low and don’t want to spend money on hiring help or investing in software. But trying to use Excel for your books never ends well. Here are a few reasons why. 

When you try to do it yourself, you simply don’t do it at all. 

I can’t tell you how many people I’ve worked with who have some sort of Excel bookkeeping spreadsheet that is never updated. Yes, they’ve put it together neatly. But the figures never actually make it to the spreadsheet until the following year when it’s time to prepare taxes. Then the business owners are scrambling to find receipts and input income and expenses – which takes time away from the business. 

Excel is entirely manual and is not tied to the real world

If you’re going to try to do it yourself, you have to actually do it yourself – every single month. If something changes, you have to remember to go in and make the change in the spreadsheet yourself.  Excel can be automated somewhat, but most things must be input manually. That can lead to all kinds of problems, which leads us to the third reason why you shouldn’t use Excel for bookkeeping. 

Your Excel spreadsheet is likely riddled with errors

It’s far too easy to make mistakes in Excel. You override a formula or transpose two numbers and everything is off – and it can be difficult to find the mistake. A study found that 88% of Excel spreadsheets contain errors, so the odds that your spreadsheet has some sort of error is incredibly high. 

I’ve worked with one consultant who religiously tracked her client payments in an Excel spreadsheet. She used this same spreadsheet to calculate her quarterly estimated tax payments. It wasn’t until she contacted me at the end of the year that we realized that her box for “Total Revenue” had a faulty formula … and that she had underestimated her annual revenue by $12,000! Not only was her annual revenue off, but this error meant that her estimated tax payments were lower than they should have been and that she would probably be facing a much larger balance due on her tax return than she had expected.

Excel spreadsheets limit your growth potential

Many companies start using Excel because they think it’s all they need for the moment. And yes, it might work in the short-term. But using Excel to manage all your accounting information can become incredibly difficult as your business grows. That increased level of difficulty can be a hindrance for businesses – you unintentionally limit your business growth because you know how much harder it will be to manage your accounting. 

The good news is that there are many financial tools available to help small business owners. If you defaulted to Excel because you didn’t know what your options were, now’s the time to take a look. This is the first post in a series on what to do in your first year of business. 

Starting a business can be overwhelming, and whether this is your first or fifth year in business, you can always find new tips and tricks to streamline processes and improve accounting systems. Stay tuned for the next blog post where I’ll share the top financial tools you need in your business today. 

Of course, if you’re ready to ditch that spreadsheet and move into the world of cloud-based accounting, contact me to discuss your options and how I might be able to help!

Deb Howard Greenleaf
Deb Howard Greenleaf

Deb Howard Greenleaf, EA, CEO and Principal, of Greenleaf Accounting Services provides virtual accounting and bookkeeping services and specializes in financial management to consultants, coaches, solo professionals, and other small business owners across the US. Deb is an Enrolled Agent (EA)—an IRS-licensed tax professional—and specializes in small businesses and entrepreneurs filing Schedule C or as an LLC. As an Advanced Certified QuickBooks ProAdvisor, Deb spends her day in QuickBooks Online and specializes in providing QBO support.

Related posts:

Low-Cost Bookkeeping on a Budget by Greenleaf AccountingLow-Cost Bookkeeping on a Budget Default ThumbnailStop Using a Shoebox for Receipts! Default ThumbnailTop 10 Bookkeeping Mistakes The Value of a Bookkeeping Routine by Greenleaf AccountingThe Value of a Bookkeeping Routine

Filed Under: Best Practices, Bookkeeping Tagged With: best practice, bookkeeping, consultant, Excel

Free 1099 Success Cheat Sheet

Want to be ready for 1099s at year end? Learn how with my 1099 cheat sheet.

Browse by Topic

  • 1099 Reporting
  • Best Practices
  • Bookkeeping
  • Greenleaf Accounting
  • New Business
  • Quotations
  • Small Biz Taxes

Recent Posts

5 Best Practices for Invoices That Get Paid Faster

We're excited to introduce a few new voices with the first in a series … [Read More...]

How to Pay yourself as an S-Corp

If your business is set up as an S-Corp (or an LLC with an … [Read More...]

Is an S-Corp Right for Your Business?

With all the recent tax shakeups, more and more small businesses are … [Read More...]

Estimated Quarterly Taxes Due Soon!

It's that time! The deadline to pay your fourth estimated tax payment … [Read More...]

Contact

(814) 450-0072

Free 1099 Success Cheat Sheet

Want to be ready for 1099s at year end?
Learn how with my 1099 cheat sheet.

Recent Posts

  • 5 Best Practices for Invoices That Get Paid Faster
  • How to Pay yourself as an S-Corp
  • Is an S-Corp Right for Your Business?
  • Estimated Quarterly Taxes Due Soon!
  • Budgeting for 2019

Reliable, Efficient and Precise

“Deb has handled my company’s invoicing and bookkeeping with impeccable attention to detail and service for several years. She is reliable, efficient and precise – remembering logistics, following through on details, and always smiling. I appreciate her help and value her expertise in handling my finances. Deb is the quintessential professional – I highly recommend her without hesitiaton.”

– Dr. Camille Preston, Owner,
AIM Leadership, LLC

Knows Her Stuff Inside & Out

“Deb is an amazing person, not only at what she does (in which she excels) but her personality is simply the best! She is always in clear control of her work; she knows her stuff inside and out; and she’s such a joy to work with and to count as a friend! I would highly recommend Deb to anyone who is looking for someone who is “above and beyond” the normal bookkeeper.”

– Vickie Turley, Chief Administrative Manager,
BossaNova Consulting Group, Inc.

© 2023 Greenleaf Accounting Services · Privacy Policy · Terms and Conditions