cancel
Showing results for 
Search instead for 
Did you mean: 
pml2269487
Level 2

Quickbooks vs. Excel

I worked in hi-tech for many years and I am comfortable creating and use custom spreadsheets in Excel.  I recently became a small business owner and decided to try Quickbooks, because other professionals use it for their small business, so I figured there must be some advantage, right?  I signed up for a 3 month trial period and so far it feels like a convoluted mess just to do simple things.  I continually ask myself what I gain by adding income and expenses into Quickbooks instead of my custom Excel spreadsheet, which is clear, straight forward, and easy to read.  If I need a new category it takes only a few seconds to add another column.  Here, I am boxed in by preexising categories, many of which I don't use.  I've spent hours trying to resolve problems in Quickbooks that would take me seconds to record in Excel.

 

Here is a recent example.  I have been paying many vendors and 1099 contractors using cashier's checks drawn from my business checking account.  I see within the contractor section of Quickbooks there is an option to record these checks, so I do it.  At the end of the month it looks like I'm negative thousands of dollars due to these outstanding checks which have already been paid.  I do reading in the help section and it looks like I should have recorded those transactions under Expense and not Check.  Oops, user error, right?  So I spend the hours to go through and fix everything.  What do I gain?  How many hours of my life have I lost?  I'm already working 80 hour work weeks.  I'm paying for a software that is taking more time out of my life, not making my life easier.

 

Here is what I like about Quickbooks.  The automatic mileage tracking, the receipt photograph function in the mobile app, and the ability to send invoices to my customers.  That's it.

 

What am I missing about Quickbooks?  Does Quickbooks actually save you (other business owners) time over using Excel?  What other benefits do you (other small business owners) gain from using Quickbooks over Excel that I might be missing?

3 Comments 3
JonpriL
Moderator

Quickbooks vs. Excel

We don't want you to feel this inconvenience. I want to let you know that helping you is our priority, @pml2269487.

 

I appreciate all the ideas you shared and I'll be taking note of them to let out product developers know all of them. This way, we can provide you all the best service you need and the customer experience you deserve.

 

With this, I've got you the following articles below so you'll be updated with all the feature and enhance of our product:

Lastly, I've also included our Help Articles hub in case you need some ideas especially with QuickBooks navigation and entry recording.

 

If there's anything else that I can help you with, please let me know in the comment section down below. I'll be always around ready to help.

Rustler
Level 15

Quickbooks vs. Excel

Without seeing your excel sheet it is hard to say for sure, but I would be willing to bet that in your excel sheet you are doing single entry bookkeeping, where QB is double entry accounting.

 

In Accounting every entry has two sides, to use your example with the vendor.  You write a check, that lowers the bank balance, and yes you use an expense account as the reason for the payment.  That bank account also gets deposits from sales with the other side of the entry being income.

 

If you continue with QB, then like any software it has a learning curve, and part of that curve is accounting basics.  

daniel_ingham
Level 1

Quickbooks vs. Excel

I agree, I have spent hours of my life and on live chat trying to do very simple things like 'find my business income transactions' not are not appearing even though I have created rules for business income and even though on my home tab it shows clearly I have a profit and when you tap on it, it's empty. 

 

In the end it has made an excel style tax submission very complicated and the next tax year will just use my Monzo banks automatic google sheets feed which exports all transactions in real time to a google sheets document. 

 

In the end I have paid quickbooks £10 per month to complicate my life more than it already was and increase the time it already took me using a spreadsheet method. 

Need to get in touch?

Contact us