69 posts categorized "Troubleshooting QuickBooks"

Why Is My Customer Showing Overdue? I Set Up the Right Terms in QuickBooks

Let's say that you recently negotiated a sale (congratulations!), and your customer snagged some extended payment terms with you as part of the deal.

So, instead of paying you in your normal net 30 day terms, they are going to pay you with net 45 day terms (hopefully your profit margin covers this extra financing term!)

You go to create the invoice in QuickBooks, and quickly see there is no "net 45" day term in the list. So, you click the Add New option, and create the new terms that look like this:

Net 45 Day Terms

and blast through the OK button to get this invoice out the door.

All seems to be good at this point, right?

THE AGING REPORT TELLS YOU SOMETHING DIFFERENT

Next week, you do a quick rundown of your accounts receivable aging report, and you see the invoice to this customer showing as overdue. Say what?

There is no way it is overdue at this point!

Well, QuickBooks thinks something different about it than you do.

HOW TO SET UP THE PAYMENT TERMS PROPERLY

QuickBooks would indeed show you the correct aging of this invoice - if you had done one additional thing when you set up the terms above.

And here is the thing:

Net 45 Days with Days

In the original box above, the "net due in" was not changed from 0 to 45 days. So, QuickBooks would see this invoice overdue on the very first day you sent it, even though the terms "net 45" appeared on the invoice.

In the updated box below, the "net due in" is correctly set up to match the applicable terms.

Once you get in and reset the definition of the payment terms (quick shortcut to access them - click Lists > Customer and Vendor Profile Lists > Terms List). QuickBooks will then properly age the invoice on your reports!

_________________________________________________________________________________________________________


Stop Inventory Balances from Going Negative with QuickBooks Enterprise

Have you been wishing that QuickBooks would add a feature that would stop your inventory on-hand balances from going negative?

Your wishes have been granted!

Learn more about how the Enterprise edition (2015 and newer!) stops this annoyance from occurring...

In case you didn't know it, by having inventory go negative in QuickBooks, it is known to cause all sorts of issues and concerns with the average cost of items getting totally whacked out as well. My friends over at the Intuitive Accountant have a great article that discusses the impact of negative on hand on QuickBooks average cost.

ADDTIONAL RESOURCES

_________________________________________________________________________________________________________


Tired of the Hassle in Using the Accountants' Copy Feature of QuickBooks?

This post was shared by Chris Wise from CoralTree, the makers of Qbox...thanks Chris!

QBox Logo

 

 

 


Trying to find a better way of getting QuickBooks information to your accountant (or if you're an accountant, to get information from your client)?

Many accountants and small businesses become exceptionally frustrated when trying to share QuickBooks files using the Accountants Copy.  To avoid the frustration related to the reduced functions of this type of file, you can use a resource like Qbox.  Qbox is one of the fastest growing QuickBooks desktop file sharing/collaboration resources available due to its security, simplicity, affordability, and high level of customer support. 

QBox Flowchart

If you are looking for a way to share a QuickBooks desktop file with a client or shared user in a remote location, Qbox provides an effective solution.  Unlike other traditional file sharing options, Qbox has unique controls that prevent the creation of conflicted copies and file corruption.

Accountants and small businesses appreciate that each Qbox user has their own local copy of the QuickBooks file and experience the performance of their local environment when entering transactions.

As an accountant or bookkeeper, you can access all of your clients from one simplified access point called the Qbox Explorer.  You work on your client’s files at any time regardless of whether or not your client’s computer is turned on. 

Screen shot of the Qbox Explorer:

QBox Console

Using Qbox, your files are always backed up in the cloud and available to download should anything happen to a user’s computer.  Additionally, Qbox keeps 20 copies (versions) of files in the cloud at all times so in the event of a corrupted file, a user can “roll back” to their preferred instance of the file. 

If you are frustrated with the limited capabilities of an Accountants Copy, using Qbox, you always have access to the working QuickBooks file. All of the Desktop functions are available to a Qbox user and you can print and/or back up locally if you so choose. 

Click here to learn more about Qbox and start your free 30-day trial today...

 

_________________________________________________________________________________________________________


Grab a Screenshot and Help Troubleshoot QuickBooks Problems

Is QuickBooks misbehaving on you at times?

Want to grab a quick picture of your computer screen and capture an important message being displayed?

GRAB A SCREENSHOT TO HELP!

As a QuickBooks consultant, there are many times where it is invaluable for me to see what exactly is being displayed on a screen so I can help a client understand what is happening with QuickBooks (or to guide them to a resolution of a question).

There are several ways to grab a snapshot of what is appearing on your computer screen to help with the diagnosis of a problem or to get more information on an area of concern (not just with QuickBooks, but with any program for that matter!).

Options to consider:

  • Take a picture of the screen with your smartphone
  • Press the Print Screen key on your keyboard (don't panic if the printer doesn't kick in automatically - it won't!). From there, open Microsoft Word (or any other word processor) and click Edit > Paste to paste an image of the screen or just right click your mouse and Paste the image in.
  • Use the Windows Snipping Tool - found by clicking the Start button, then All Programs, then Accessories, then Snipping Tool. Once you do that, a screen like this will appear  - just follow the instructions from there:

    Windows Snipping Tool
  • My favorite solution - invest the $49.95 in a copy of SnagIt software from TechSmith. Hands down, this has been one of the best investments I have made for my business toolkit. I use it multiple times each and every day. The features and options that have been packed into this little gem of a program are simply amazing to me. They offer a free trial of the software of course, so you can "try before you buy".

DO YOU HAVE AN ALTERNATE IDEA?

If you are grabbing screenshots in a way different from those outlined above, feel free to share your insights on how you're doing it!

 

_________________________________________________________________________________________________________


How To Condense/Archive Your QuickBooks Data File Because it is Too Big

Do you find that your QuickBooks file is running very slowly?

Does it seem to take forever to run reports or look up information?

If so, your QuickBooks company file may be a prime candidate for condensing/archiving.

DANGER? DANGER! YOUR QUICKBOOKS FILE MAY IMPLODE

As I mention in my free guide titled "Danger? Danger! Your QuickBooks File May Implode", one of the options to consider to make it smaller and more manageable is the process of archiving the information. This process is something you can choose to do yourself, or turn to an outside company to handle it for you.

Some refer to this process as condensing the file. I've heard others call it "smashing the file down".

However you may refer to it, the end result is the same - a decrease in the size of your QuickBooks company/data file.

A HOW TO GUIDE ON THE CONDENSING/ARCHIVING PROCESS IN QUICKBOOKS

Many people find they need to do a condense on their QuickBooks file as it is simply too big for itself.

However, about two clicks into the process if they try it themselves, they get nervous and intimidated by the options that appear.

To help eliminate those concerns, I have created a new guide that walks you through this process - step-by-step.

Condensing QB Cover

HOW TO / WHEN TO / WHY TO CONDENSE YOUR QUICKBOOKS FILE

If you find that your QuickBooks file "needs a shrink", this guide is the solution for you. It provides you with these critical insights:

  • Learn why and when to condense a QuickBooks Company File.
  • Protect your file and prepare for the condensing process.
  • Get exact, simplified instructions for condensing the file with no headaches!
  • Before you “click” condense, learn what a “white screen” means and other important details.
  • Know how to crosscheck and verify the condense file.
  • Much more...

Learn more about "Why To...When To...How To...Condense Your Company File" now...

 

_________________________________________________________________________________________________________


QuickBooks Performance Issues - A Resource for You

Does it take a long time to open your QuickBooks company file?

Does QuickBooks slow down as more people log in?

Are you experiencing other performance issues with QuickBooks?

If so, you'll want to take a look at this very helpful page from the QuickBooks support site that discusses ideas and steps to take to address performance problems in QuickBooks.

RELATED TOPICS:

_________________________________________________________________________________________________________


Support for QuickBooks 2013 Products Ends May 31, 2016

Hate to be the bearer of bad news, but if you use QuickBooks 2013, you need to know...

Support for your version of QuickBooks will be ending May 31, 2016.

Is this a big deal?

The answer to that all depends on how you are using QuickBooks - are you using payroll, merchant services or other QuickBooks add-on services? If so, it is a VERY big deal.

If not, then maybe not so much.

Learn all about the QuickBooks 2013 discontinuation policy and see how it may impact your business.

RELATED INFORMATION

_________________________________________________________________________________________________________


Understanding and Tracking Inventory in QuickBooks -> A Webinar for You

Join me and take a deep dive into the core inventory functionality within QuickBooks Pro, Premier and Enterprise.

On Thursday, February 25, 2016, I'll be hosting a webinar that digs down into the details of what you need to know, including:

  • How to set up and use inventory properly in QuickBooks
  • Figuring out why your current setup isn't working as planned
  • The key differences between inventory parts, non-inventory parts, service items and other charges
  • An understanding of the key inventory reports available to you
  • Much, much more...

We'll be walking through the entire order to shipment process as it relates to inventory in QuickBooks.

For more details and to reserve your spot (be sure to take advantage of the early bird pricing), visit my QuickBooks Inventory Webinar page today!

_________________________________________________________________________________________________________


Merging Files in QuickBooks - Should You? Shouldn't You?

A number of inquiries have come in lately asking about "merging" two or more QuickBooks files together, and whether it could be done or not.

The better question to ask before asking if it could be done is...

"Should it be done?

Should you really merge two QuickBooks files together?"

MERGE VS. IMPORT

To make sure we're on the same page here, let's get a few definitions out of the way first (at least how I see them).

  • Merge - to actually combine ALL the contents of separate QuickBooks files together so that one QuickBooks file remains
  • Import - to selectively choose information (i.e. customers, inventory) and extract it from one QuickBooks file and pull it into another QuickBooks file

TO MERGE OR NOT TO MERGE

Over the years, I've heard many different scenarios where someone wants to merge QuickBooks files together.

To my original question about "should" you merge them?

My answer is a resounding NO.

Here's why I say you should NOT merge QuickBooks files together...

  • There is no direct way to accomplish this - no magic button exists within QuickBooks to merge files
  • The integrity of the file that is being merged into is completely lost - I shudder to think about the consequences of smashing two QuickBooks files together into one (try running historical financial reports after the merge - I think your CPA would have cardiac arrest at that point!)
  • Problems will inevitably surface (customer payments not applied correctly, incorrect bank reconciliations and many more potential headaches)

START A NEW FILE INSTEAD!

If there is a legitimate need to combine the information from two or more QuickBooks files, my suggestion is to create a brand new QuickBooks file as of a certain point in time (i.e. new fiscal year, beginning of a quarter, etc.). Leave the history in the old files for lookup purposes, and put future transactions in the new file. I think this will save you a ton of grief in the long run.

IMPORTING/PULLING INFORMATION INTO A NEW QUICKBOOKS FILE?

There are several ways to pull information from one QuickBooks file or external source to another QuickBooks file, including:

Even though these tools exist, it is still absolutely essential that you understand what they do, how they may impact existing information, and make sure that everyone is on board (including your outside accountant) about how your historical information may or may not change as a result of importing information into QuickBooks.

AGREE? DISAGREE?

You've read my take on merging QuickBooks files.

What's your take? Do you agree? Disagree?

Please drop your comments in the box below (or if you are reading this via e-mail, click the "view in browser" link to get to the comments box)

__________________________________________________________________________________________________________

_________________________________________________________________________________________________________


How to Get QuickBooks Job Profitability Summary Report to Show the Cost of Inventory Adjustments

Do you track inventory adjustments to jobs or projects in QuickBooks?

If so, have you ever noticed that the cost of those adjustments does NOT show up on the job profitability summary report? (hopefully you noticed that is, or you are having a major "oh crap moment right now!!)

Strange, isn't it? You'd think that if you set up the transaction properly, the information would flow automatically to the report.

A TWEAK TO THE JOB PROFITABILITY REPORT SETTINGS

This support article from Intuit discusses the quick tweak that needs to be made for the inventory adjustment detail to appear on the report.

Once you do that, this vital inventory adjustment information will appear and your job profitability reports will be much more accurate!

ADDITIONAL RESOURCES AND INFORMATION

 

_________________________________________________________________________________________________________