Archive for July, 2009

QuickBooks and MS Excel – Analyzing your product lines, which product is making you the most money?

July 29, 2009 Leave a comment
View The Web Cast |

A few months back on April 15, 2009 we recorded a web cast on how to track, manage, and update your inventory in QuickBooks using a template I created in Microsoft Excel. Once your inventory is updated and adjusted properly such that you have accurate balances in your inventory accounts and as long as you know you have updated your books to reflect all purchases and sales to date then it is time to analyze your inventory to see which products are generating the most profit. If something is selling well and your gross profit % is low then you are not getting the most out of your product. You may also find that you have a product with a high profit margin that isn’t selling as well as it could. This is all valuable information that can and should be used to manage your business well and make it as profitable as possible while also maintaining balance with customer satisfaction. In other words making sure that you are charging a price for your product that is fair and that your customers will feel represents a very good deal on what they’ve purchased.

In this web cast:

  • First we’ll show you how to run the Sales By item Summary report in QuickBooks
  • Then we’ll show you how to export that report to Microsoft Excel
  • Once the report is in Excel we will show you how to re-format the report such that it is easy to read and easy to sort.
  • Finally we’ll show you how to perform 2 sorts that will show you very valuable information about your products.

When we are asked to work with companies directly we look at these details to find ways to make your company more profitable. This kind of analysis cannot be performed without first having the books complete, accurate, and current. Once all of this is in place, then we can not only do this analysis, but we can use the information to set goals about where we want to focus our efforts in terms of future product sales. We can determine which products are worth making more efforts to sell and based on that we can develop projections aimed at setting aside marketing dollars to be invested into promotions of these products. When we have a great handle on all of our resources it becomes easy to analyze and plan the growth of the company.

Call us today at (866) 945-8070 for a free phone consultation.

Or post a comment on our blog if you simply have a question about this web cast.


View The Web Cast |


Excel Navigation Tips – Highlighting Rows And Columns

July 23, 2009 Leave a comment

A tip for getting around Microsoft Excel Spreadsheets Quickly

One of the things I have found in designing spreadsheet applications is that it saves many hours of time when you know how to use the keyboard shortcuts in order to navigate around the spreadsheet quickly and efficiently. I have learned many of these tricks by rushing on the keyboard and noticing that I did something, then re-tracing my steps in order to figure out what I did.

Here’s a tip on highlighting Rows and Columns:

  1. CTRL + Spacebar: Highlights the entire Column you are in. Fig 1-1
  2. Shift + Spacebar: Highlights the entire Row you are in. Fig 1-2
  3. If you have a range of cells across a row highlighted and then do Step 1 you will highlight all of those columns
  4. If you have a range of rows highlighted and do step 2, you will highlight all of those rows.

Fig 1-1

Fig 1-2