<img height="1" width="1" src="https://www.facebook.com/tr?id=1168427849921758&amp;ev=PageView &amp;noscript=1">

QuickBooks Tips Blog

3 Ways To Rock QuickBooks Inventory

Posted by Sarah Smith on Dec 15, 2015 7:00:00 AM

Are you always running out of product and scrambling to reorder? Or maybe you’re trying to find space to cram just a couple more boxes of product into your storage area? You’re probably forgetting about inventory counts, tracking, and reviewing your inventory. These will help you keep products on hand to sell and keep storage space managed. Let's walk through how to manage and absolutely rock QuickBooks inventory.

Read More

Topics: QuickBooks Tips, QuickBooks Tips Blog, Certified QuickBooks ProAdvisor, QuickBooks Inventory, Counting Inventory, Inventory Accounting

QuickBooks Hack To Fix Accidentally Ignoring Transactions In QuickBooks Bank Feeds

Posted by Christina Whalen on Sep 1, 2015 9:30:00 AM

Have you ever accidentally ignored transactions in an upload to QuickBooks? Then later tried to upload the QBO (QuickBooks Importable file) again, only to have an error code pop up saying that they cannot be downloaded ever again? 

I have! Many times, while intending to batch add transactions, I have accidentally ignored/deleted all of them from bank feeds. This happened so often that one of our team members found a workaround for this common issue that is applicable to any version of QuickBooks Desktop with the Online Banking/Bank Feeds feature. 

Read More

Topics: QuickBooks Tips Blog, QuickBooks Importing, Tips Blog, importing qbo, downloading qbo, QuickBooks Bank Feeds, QuickBooks Hacks

Why Does QuickBooks Accounts Payable Report Still Show Paid Bills?

Posted by Richard Haralson on May 28, 2015 7:30:00 AM

You have entered a bill into QuickBooks and you wrote a check for that bill. So, why is that bill still showing in your accounts payable report? It’s an easy and common mistake to make. Sure there may be a number of ways this can happen, let me give a simple example.

You receive a bill from a vendor that is not due for a few weeks. You enter it and forget about it. A few weeks go by and the vendor sends a statement. You jump into QuickBooks and write a check to the vendor. Done.

Being the savvy owner you are, you often look at you’re A/R, A/P and P&L thus you are wondering, “Why does that bill still show in my A/P?” From the perspective of QuickBooks, you didn’t pay the bill (from pay bills); you simply wrote that vendor a check.

So, how do you fix this? You could delete the check, then go to Pay Bills and do it correctly, and adjust the check number to match the check that was mailed. But what if you found the issue after the checking account has been reconciled? Deleting the check will mess up the checking account reconciliation. Don’t do that. Here is a better way to fix this problem.

Open the check that was written. Select the account on the lower check details. Perhaps you had the check coded to an expense account (the coding could be anything, doesn’t matter). Change the coding to Accounts Payable. Next tab over to the Customer Job field and find the vendor name the check was written to. Save and close.

Last step is clearing the bill. Now go to pay bills and select the vendor bill in question that is still showing outstanding. Lower on the screen select set credits, apply the credits, click done, click save and close, then click done.

That’s it; you have now tied what QuickBooks thinks is a random check to a vendor bill and the bill we no longer show on your accounts payable report.

Read More

Topics: QuickBooks Tips, QuickBooks Tips Blog, QuickBooks advice, Accounts Payable, QuickBooks Bills

How To Record A Vendor Refund In QuickBooks

Posted by Richard Haralson on May 26, 2015 7:30:00 AM

At first glance you might wonder what’s so tricky about recording a vendor refund in QuickBooks. Why is this question being asked? Or, this seems simple, am I doing it right?

Let’s back up and set up a scenario. You run a service based business that pays for some supplies. One week you pay a bill to your supplier for cleaning supplies. A few weeks ago you received the bill and entered the bill in QuickBooks correctly. Last week you properly went to Pay Bills. There you paid that bill and any others that needed to be paid. If you entered a bill and then wrote a check for the bill AND the bill still shows in your Accounts Payable, go to this QuickBooks blog where I explain how to correct that.

So now your bill is paid and business goes on. Then one day you receive a check back from that vendor for any number of reasons: an unknown discount, price change, or whatever. A common mistake is to receive those funds back against the expense from the original bill; you might even go as far as labeling the deposit as being received from that vendor. And I’m sure it goes without saying that of course you noted the refund reason in the deposit memo field. But this is still incorrect, slightly. This is wrong because it does not directly tie the deposit to the vendor. Meaning you will not find this deposit in the vendor center.

So, how do you properly receive a vendor refund? Go to the deposit screen, in the received from field enter the vendor name. Then in from account field, here you put accounts payable. Memo and amount as usual then save and close. Next you need to enter a bill credit from the bills screen. After opening bills toggle it to a credit and enter the vendor name, date, amount, and memo it. In the account field, this is where you will put the expense account that off-sets the original bill. Save and close. Last step, go to pay bills and find the vendor. What you will be clearing here is the check from vendor received. Check the box, and then in the lower portion of the screen you will find set credits. There you can apply the bill credit you created and click done. Click pay selected bills, then click done.

There you have it. You have correctly received a vendor refund check. Both the incorrect and correct way will have the same impact on the expense account. However, the correct procedure will show the transaction in vendor reports.

Read More

Topics: QuickBooks Tips, QuickBooks Tips Blog, QuickBooks advice, QuickBooks Vendors

Clean up QuickBooks Customer, Vendor and Employee Lists

Posted by Richard Haralson on Dec 15, 2014 7:00:00 AM

Keeping your QuickBooks lists clean and current is always a good idea. Just like a chief will sharpen his knives and wash the dishes in preparation for the next meal, so should a bookkeeper keep their tools of the trade sharp and clean.

Read More

Topics: QuickBooks Tips, QuickBooks Tips Blog, QuickBooks Consultant, QuickBooks Lists, QuickBooks Cleanup

How to Customize the QuickBooks Home Page

Posted by Matt Roberge on Jul 25, 2014 7:00:00 AM

Today's post is a guest blog post by Trevor Matheson. Trevor Matheson works for Real World Training, the largest provider of QuickBooks Training in the U.S. Check out one of their upcoming classes in New York, Miami or other cities.

Read More

Topics: QuickBooks, QuickBooks Tips, QuickBooks Tips Blog, QuickBooks Help, QuickBooks Home Page

Why Small Businesses Need Great QuickBooks Estimates

Posted by Marti Major on Jul 9, 2014 7:00:00 AM

How do you put together your QuickBooks estimates? Are you putting down your costs on a napkin or the back of an envelope? Maybe you have stuff in a word document, and you just go in and replace the old customer name with the new one. Then you change the date, adjust your numbers up or down a little depending on how the last job went, and print.

Read More

Topics: QuickBooks Tips, QuickBooks Tips Blog, QuickBooks Estimates, QuickBooks Estimate, Customer Billing

Get Your Shopping Cart to Work with QuickBooks

Posted by Matt Roberge on May 7, 2014 7:00:00 AM

The Solution Doesn't Have to Be Complicated
By Steve M., Author of Moonlight CEO

Read More

Topics: QuickBooks, QuickBooks Tips, QuickBooks Tips Blog, QuickBooks Shopping Cart

20 Ways QuickBooks Can Help Run Your Small Business

Posted by Matt Roberge on Feb 7, 2014 7:00:00 AM

QuickBooks is excellent accounting software for running a small business.  I like to tell clients that QuickBooks is great for a small business owner that doesn't necessarily understand accounting.  The reason I say this is that many of the accounting entries are done behind the scenes in QuickBooks just by carrying out the day to day activities of your business.  However, I also see a lot of business owners not use QuickBooks to its full potential.  Here are 20 ways QuickBooks can help run your small business.

Read More

Topics: QuickBooks, Small Business Bookkeeper, QuickBooks Tips, QuickBooks Advisor, QuickBooks Tips Blog, QuickBooks Training, QuickBooks for Small Business

How To Customize QuickBooks For Your Small Business

Posted by Matt Roberge on Dec 11, 2013 7:00:00 AM

The first thing you should do when you get QuickBooks is to customize QuickBooks for your small business.  While every small business is different and has unique needs there are a few customizations you most likely want to do no matter what.  The goal of customizing QuickBooks is to make your bookkeeping as easy as possible to handle each month.  Here are a few ways to customize QuickBooks for your small business.

Read More

Topics: Efficiently Using QuickBooks, QuickBooks Advisor, QuickBooks Tips Blog, QuickBooks Customization, QuickBooks Setup, Customize QuickBooks, QuickBooks Training