41 posts categorized "Profit Improvement Tips"

Powerfully Simple Dashboard for Your Small Business

Score some bonus points with your boss...

If you know they are frustrated trying to pull together reports and key metrics from a number of different sources, they will want to know about the Grow Dashboard (feel free to check it out yourself too!)


The Grow dashboard offers a simple way to select the metrics that are important to running your business...

  • Need information from QuickBooks? (desktop or online)
  • Want to pull information from a customized spreadsheet or database?
  • Interested in pulling together information from Salesforce, Google Analytics, MailChimp, Facebook, Twitter and a host of other places?

If so, Grow is for you...


If the built-in dashboard connections mentioned above are close, but not quite good enough, the support team at Grow can help you construct the perfect dashboard - no internal IT team required.

Grow allows you to connect your data, wherever it lives, and get the key metrics needed to monitor, manage and improve your business...

Take a closer look at the Grow dashboard solution today...



17 Things You Should Be Doing to Reduce Accounts Receivable

My friends at Anytime Collect have put together a terrific resource guide titled "17 Things You Should be Doing Right Now to Reduce Outstanding Accounts Receivable."

Bookkeeper - July 2014As you think about your accounts receivable (you are thinking about them, right?) and the systems you have in place to monitor them, one key fact stands out:

  • Every dollar outstanding in your receivables is a dollar that is NOT sitting in your bank account to fund your operations!


Having an effective credit and collections strategy and related applications has been shown to have the following benefits:


To get you started, here is a short list of ideas:

  1. Create a plan - this becomes your road map to success in managing your receivables
  2. Provide accurate and timely information - this step covers not just those internally that are managing receivables but also to your customers as well
  3. Set up Key Performance Indicators (KPI) - your favorite NFL team is evaluated by their won-loss record and and other statistics, right? So should your credit and collections systems.

Here are 14 more ideas on how to reduce your accounts receivable.


QuickBooks can provide you with some of the core reports to begin the process of managing your receivables such as:

  • The A/R Aging Summary
  • The Collections Report


QuickBooks is really not so hot at handling the automation many businesses need to see real improvements in reducing the money they are owed.

Enter Anytime Collect.

Anytime Collect is a budget friendly and rich suite of tools you can rapidly implement to start putting a dent in your receivables and keeping them under control.

Anytime Collect has full integration with your QuickBooks as well, so put your worries about double-data entry to rest.

Get more information on Anytime Collect for QuickBooks today or contact me with questions.



My Favorite Tech Tools

Looking for ways to work more efficiently and get more done in less time?

ToolBoxI wanted to share the following list of tech tools I use in my business that have helped me do both! The various apps below are used frequently to help me provide QuickBooks and CFO services to clients all over the country.

Hope you find them helpful!

Please be sure to let me know what tools you are using to help your business succeed. Just drop a comment in the box below - look forward to hearing from you!


  • Remote access to office computers - GoToMyPC
  • Automated bill payment with full sync to QuickBooks - Bill.com
  • Screen captures and editing - SnagIt
  • Mobile version of my web site - Duda




QuickBooks Cost of Goods Sold - Where Does the Number Come From?

I have been fielding many questions lately about the cost of goods sold line on the profit and loss report in QuickBooks.

Time to take a closer look...

For this article, we'll focus on inventory parts and inventory assembly items in your QuickBooks.


When you created your inventory part or inventory assembly item the very first time in QuickBooks, you had to tell it what "COGS Account" (COGS = Cost of Goods Sold) to use. See the example screen shot below:

When this item appears on an invoice or sales receipt in QuickBooks, the instructions above tell it to post to the 50100 - Cost of Goods Sold Account each and every time. No exceptions (your business may only use account names and not numbers - that is just fine).


As we know, for every transaction in QuickBooks, there is not only a ledger account but also an amount that has to post.

Much confusion exists as to where QuickBooks pulls the actual amount that gets posted to the COGS account.

Here's the scoop...

For inventory parts and assembly items, QuickBooks pulls from the value in the "average cost" field to fill in the cost of goods sold amount when the invoice or sales receipt is completed. See the screen shot below:

In the example above, if 2 of this particular item were sold on an invoice or sales receipt, a total of $6 would post to the 50100-Cost of Goods Sold account.

Keep in mind that this is an average cost - it is not a FIFO, LIFO, Standard or Landed Cost.


Many have been mistakenly led to believe that the cost that posts to the COGS account is not the average cost amount, but rather, the amount showing in the generic "Cost" box. See the screen shot below:

This understanding is not true. The generic "cost" box is more of a "management cost" type of box that is either updated manually or when purchase orders are created.


My hope is this brief lesson will help you have a better understanding of the activity that is showing up in the cost of goods sold account on your QuickBooks profit and loss report.

Of course, other transactions such as bills or credit card entries can also post into the COGS account, but understanding how inventory parts and assemblies post will be a big plus to help you manage your business...




Time to Trash Your Multi-Colored Pack of Highlighters?

Ok, be honest...

When it comes to tracking your accounts receivable, you've probably got a well refined color coding system using your highlighters week in and week out on tens or even hundreds of pages of your aging reports, right?

It's very likely this system is actually costing your business a lot of money...


Open invoices are the foundation for future inbound cash for your business. It is essential to have a really solid and efficient system in place for tracking them.

QuickBooks is great at providing the core reports you need to see the big picture with your receivables.

Unfortunately, QuickBooks is not so great (some have said even worse things!) when it comes to the day-to-day follow-up that is crucial for an effective accounts receivable management system.


What if you could have a system that automatically pulls data out of QuickBooks, and then gives you a completely modern set of tools to automate your accounts receivable collections process?

You can!

I was so impressed with the Anytime Collect accounts receivable management software for QuickBooks that I recently signed on as a referral partner with them.


Anytime Collect comes pre-loaded with the following (this is just a short list of all the ways it can help you trash your pack of highlighters):

  • Action Center - a tool that tells you who to call, when to call, what invoices are involved, etc. According to Paystream Advisors, this allows up to a 300% increase in the amount of time you spend on actual collections compared to businesses using a manual system. Just imagine how that translates into better cash flow!

  • Communication Center - allows you to manage every piece of communication (phone, e-mail, fax, carrier pigeon - ok, just kidding about that) in one place.

  • Dashboard/Intelligence Center - a live snapshot of just what is happening within each piece of your accounts receivable management processes and procedures.

  • Full integration with QuickBooks - no double-data entry needed.


If you're looking to slash the amount of cash your business has tied up in accounts receivable or find ways to get more collections work done in less time, Anytime Collect needs to be on your radar...



Building Better Business Finances: The Profit and Loss by Job Report

The profit and loss by job report in QuickBooks can bring a whole new (and better!) vision to your business when it comes to tracking revenues and expenses by job or project.

Here is a screen shot of a sample report (found by clicking Reports > Company and Financial > Profit and Loss by Job):

As you can see, this report provides the profit and loss report layout you've seen before, but the columns are now broken out by job/project. This particular sample report was filtered for just one customer and their jobs for easy reference. Some businesses may even refer to this as their "job costing" report.

In order to make this profit and loss by job report work properly, each income transaction (i.e. invoice or sales receipt) needs to be tagged with the correct job, and each expense transaction (i.e. bill, check, credit card charge, etc.) needs to be tagged correctly as well.

Need more details behind a value in the report? Like any other report in QuickBooks, simply hover over the number and double-click on it to drill down into the next level of details.




Working Too Many Evenings and Weekends?

If you love owning or running a small business, but are growing weary of the insanity it can cause, you'll be interested in the concept of lifecycle marketing.

Infusionsoft has put together a great series that will show you how to own your time and have a thriving business as well.

This video series is completely on-demand - view it on your schedule!






Today is an Awesome Day to...

Run your QuickBooks profit and loss report to see how your business is doing.

To me, this report is one of the three most critical reports you should be monitoring on a regular basis. The other two? Your accounts receivable report and a cash flow report.

If your business only gets a profit and loss report (aka income statement) when your CPA hands you a wad of papers at tax time, you're really, really missing out.

Without hesitation, your profit and loss report should be reviewed on a monthly basis.


Getting there is easy - click Reports > Company and Financial > Profit and Loss Standard. You'll see something that looks like this:

Now come the hard parts of dealing with your income statement:

  • Making sure the information in the report is accurate
  • Trying to figure out what it means (in something other than accounting-speak!)


Knowing that you aren't an accountant (and likely don't want to be!), I've created two easy ways to get you the help you need to manage (and improve!) your finances.

Take a closer look my solutions:




Get Your Customers to Take Action - But How?

So you have a web site out there...

Maybe you've tweeted or even Facebooked a bit.

Sadly, your traffic count is similar to that on a dark, backcountry highway at 3am.

How do you get customers (or potential customers) to take action?

Download this free guide from Infusionsoft on how to get your customers to take action.



How Do Your Small Business Expenses Compare to the National Averages?

Ever wonder how your business expenses stack up against the averages?

Thanks to this infographic from the team at Shoeboxed.com, you can do a quick and easy comparison (click for a larger image):

image from bit.ly


Looks like these businesses could use some help with their expense tracking too, seeing that 34% of their expenses were classified as "uncategorized"!! If that includes you, let's talk about how to use QuickBooks to get things classified correctly.