We've Moved - Visit My New Home For Blog Posts

Moved to New Home

A quick note to let you know that I've moved my blog to a new home.

You can still enjoy all the great archived content right where you are. Feel free to browse around (all the topics and posts are categorized for you over on the right hand side of the page)

Visit my new home to check out the newest blog posts, QuickBooks and profit improvement tips

_________________________________________________________________________________________________________


Continually Resizing Column Widths in QuickBooks Desktop Screens?

Frustrated with QB Column Widths

Are you as frustrated as I am by having to constantly resize your screen widths in QuickBooks desktop products (Pro, Premier and Enterprise)?

If you are, please take just a moment and share your thoughts on this topic with the developers at QuickBooks by clicking Help > Send Feedback Online > Bug Report (these clicks are to be done directly within your QuickBooks when it is running...)

Do it now while you're thinking of it!

Maybe, just maybe, this issue will get into the programming queue and be fixed once and for all (I have no idea as to why it has taken years and is still not resolved - @Intuit, any feedback you can share here?)

We can dream, can't we?

If anyone has found a solution to this ongoing problem with QuickBooks, please share it with us. Please....

_________________________________________________________________________________________________________


Webinar: Understanding Assemblies, Bills of Material and Groups/Kits in QuickBooks

  Assembly Concept_665907886
Looking for a better understanding of how to set up and track assemblies and groups/kits in QuickBooks Premier, or Enterprise?

Get the insights you're looking for with my new webinar called "Understanding Assemblies, Bills of Material and Groups/Kits in QuickBooks"

Designed for all inventory based businesses that are looking for insights and ideas on how to use QuickBooks better!

Be sure to take advantage of the early registration discount too...

Webinar Registration Button

_________________________________________________________________________________________________________


The QuickReport in QuickBooks - See the History of a Customer, Item or Vendor Instantly

QuickReport in QB

Ever found yourself trying to figure out why the on-hand quantity of an item went negative?

Wanted to see the invoices and payments for a customer during a particular period of time?

Been in search of the transaction details for inventory, customers or vendors?

If so, the QuickBooks Quick Report is something you'll want to have in your tool kit! (this is found in QB Pro, Premier and Enterprise - if it exists in QuickBooks Online, I don't see it...)

ACCESSING THE QUICKREPORT

For example, let's say that you want to see the history for an inventory part in QuickBooks.

Simply find the part in your item list, highlight it, click the Reports box at the bottom of the item list, then click QuickReport (or CTRL + Q if you prefer keyboard shortcuts). You'll get a report that looks like this:

QuickReport Sample

As you can see, this provides a great way to visualize exactly what happened with this item during the period.

The same concept applies if you want to see what happened with a customer and/or jobs. Simply find the customer/job, right click on the name, choose QuickReport, and you'll get a report that looks like this (in this example, I did a QuickReport on the main customer and all the jobs for that customer):

  QuickReport Customer Sample

Hopefully having this report in your tool kit will help you save time while working in QuickBooks each week!

_________________________________________________________________________________________________________


What's New in QuickBooks Desktop Enterprise 2018?

Whats New in QBES 2018

Want to take a closer look at the new features that Intuit has baked into QuickBooks Desktop Enterprise 2018?

My video will provide you with the quick tour you've been looking for to see what's inside:

 

 ADDITIONAL QUICKBOOKS DESKTOP ENTERPRISE RESOURCES FOR YOU:

_________________________________________________________________________________________________________


Webinar: How to Track Inventory in QuickBooks Desktop (Pro/Premier/Enterprise)

Inventory and Warehouse

Wish you had a better understanding of how to set up and track inventory in QuickBooks Pro, Premier, or Enterprise?

Get the insights you're looking for with my new webinar called "Tracking Inventory in QuickBooks Desktop - From Purchase to Shipment"

Designed for all inventory based businesses that are looking for insights and ideas on how to use QuickBooks better.

Webinar Registration Button

_________________________________________________________________________________________________________


5 Reasons to Pause Before Selecting QuickBooks Online for Inventory Tracking

Pause for QBO Inventory

Thinking about using QuickBooks Online (QBO) for tracking your inventory?

It may very well be a good choice for your business, but here are five reasons why it may not...

(NOTE: Unlike the desktop versions of QuickBooks that only update new features once per year, QBO releases new features and functionality more often. The listing below is accurate as of the date of this blog post).

Reason #1 - No backorder tracking

If your business is lucky enough to ship every order complete, then this isn't a concern at all.

If you do have backorders, then QBO won't help so much.

Unlike the sales order tracking feature in QuickBooks Premier and Enterprise, QBO does not offer sales orders. Without them, you're forced to develop some alternate method (think Excel) to track your unshipped orders.

I have seen some businesses try to use the estimate feature of QBO for open order tracking. While that is certainly a start, it usually isn't robust enough to run your business on.

Reason #2 - No ability to fix calculated average cost problems

Every inventory item you create in QBO has two costs that are associated with it. 

The first cost is the one you see in the inventory item master. I'll refer to this as the "purchase cost" and this is shown in the graphic below:

QBO "PURCHASE COST" FIELD:

QBO Purchase Cost

QBO "CALCULATED AVERAGE" COST:

The second cost is the one that QBO carries that you can't see - the "calculated average" cost, as shown in the graphic below:

QBO Average Cost

Unlike the Pro, Premier and Enterprise desktop versions of QuickBooks, QBO has no button, lever, or option available to fix this calculated average cost figure if it goes out of whack. I have worked with 3 levels of support at Intuit on this issue, and the only sound I hear is crickets when discussing it.

And it WILL go out of whack due to reason #3...

Reason #3 - No ability to stop on-hand from going negative

Do you often "ship negative" to get an invoice processed and out the door?

By that, I mean you create the invoice first, drive the on-hand quantity of an item negative at that time, and then make a vow to go back and fix it later?

If that's you, QBO is going to give you some heartburn.

If you "ship negative", that process then starts to cause problems with the calculated average cost that QBO holds (see reason #2 above). The calculated average then becomes incorrect, and then any inventory valuation type reports you run in QBO will be incorrect. I've seen the effects of this process first hand in a number of customer QBO files.

The Enterprise edition of QuickBooks desktop does have an option to stop a business from "shipping negative". The Pro and Premier desktop versions of QuickBooks don't have this option, but at least they have the "fix" available for the average cost.


Reason #4 - Can't Set the Closing Date if Inventory On Hand is Negative

The closing date in both the desktop QuickBooks and QBO is a great thing! It stops entries from being made or changes to existing entries in closed accounting periods.

Sadly, if you have just one (that's right, just one) inventory item in QBO that has a negative on-hand quantity at the time you go to set the closing date, you'll be presented with this lovely message:

QBO Closing Date

Sorry to say, there is no way around this other than to get in and fix each and every negative on hand value as of the date you want to set.

I have never seen the Pro, Premier or Enterprise versions of QuickBooks flash this message if an on-hand value is negative.

I am unable to even attempt to explain the logic behind the scenes as to why this happens in QBO - it makes no sense to me.


Reason #5 - No Custom Fields for Inventory in QBO

The Pro/Premier desktop editions of QuickBooks offer you five custom fields to use as needed.

The Enterprise desktop edition of QuickBooks provides fifteen custom fields to use as needed.

QBO offers....zero (at least that I could find anyway).

Depending on what type of information you need to track for your inventory (i.e. color, weight, size, etc.), you may find this to be a very limiting factor.


GREAT NEWS! THERE ARE PLUG-INS THAT CAN SOLVE THESE INVENTORY PROBLEMS...

If you like the concept of QBO and find that it works well for other aspects of your business, you'll be glad to know there are options out there that can help fill in these missing pieces when it comes to tracking your inventory.

Plug-ins such as:

can be brought into the mix to help you overcome the inventory limitations currently found within QBO. Naturally, it's important to understand just what it is about your inventory that you need to track - that will help determine which plug-in may be the best fit for you.


NEED HELP SORTING IT ALL OUT?

I've been working with inventory-based businesses for over thirty years, and I welcome the opportunity to consult with your business on this topic.

 

_________________________________________________________________________________________________________