QuickBooks Newsletter

 
 

QuickLabs.com
14515 North East 67th Court
Redmond, WA 98052

Phone: 425-885-1223
Fax: 425-883-1230
Website: QuickLabs.com

Table of Contents
March 2004
 

QuickBooks News
QuickBooks Features
QuickBooks Common Questions
QuickBooks Tips
QuickBooks Product Updates
Articles
Prior Issues

 
QuickBooks News
 
New Customer Care Policy for QuickBooks Users
Intuit Wins CNET Editors' Choice Award

New Customer Care Policy for QuickBooks Users
Intuit, the makers of QuickBooks, has launched a new "Customer Care Policy" that expands the free telephone support available to its QuickBooks customers to better meet customer needs and expectations. The policy covers the first 12 months from the date of registration of any currently supported version of QuickBooks.

Prior to Customer Care, if a customer called the support number they would be asked for a credit card number before being connected to a technical representative in almost every case. Now, for many technical support issues, they will be connected to a representative directly. Aside from possible toll charges the call will be free.

The QuickBooks Customer Care Policy helps ensure that a customer's new QuickBooks financial software works properly so they can focus on their business. If a customer is a registered user of a currently supported U.S. version of QuickBooks, they are eligible to receive free telephone support as outlined below.

For 12 months from the date of a customer's initial software registration, Intuit will help a customer:

  • Successfully install QuickBooks software for the first time or re-install QuickBooks on a replacement computer.
  • Convert a QuickBooks data file for the first time to the latest version of QuickBooks from an earlier version of QuickBooks.
  • Resolve all QuickBooks-specific error messages.
  • Help resolve confirmed product defects for registered, supported products.

The telephone number is (888) 320-7276 weekdays, 6 a.m. to 6 p.m. Pacific Time. To learn more about the new Customer Care Policy, visit
http://www.quickbooks.com/support/programs/free.html.


Intuit Wins CNET Editors' Choice Award
CNET gave its Editor's Choice Award to QuickBooks: Premier 2004, in its recent review of the software. The review, by CNET's Jeff Bertolucci, calls the program "best-in-class" and "the best and most comprehensive small-business accounting program out there." The review calls out some features for special attention, including the new tools for tracking fixed assets and vehicle mileage, managing loans, and estimating cash flow.

 
QuickBooks Features
 
QuickBooks Centers
Company Center
Customer Center
Customer Detail Center
Vendor Detail Center
Expert Analysis Tool

QuickBooks Centers
QuickBooks centers collect and group your company data for specific areas of your business. In each center, you can look at several sets of related data, analyze the information, and take appropriate action on it. In some centers, the same sets of data are shown all the time. In other centers, you can choose the data you want to see.
You can specify a date range for each set of data. You can use the Activities menu items to take action on the data you see. The four centers are:

  • Company Center
  • Customer Center
  • Customer Detail Center
  • Vendor Detail Center

Company Center
In the Company Center, you'll see:

  • All of your accounts receivable, accounts payable, bank, credit card, and current liability account balances
  • A graph of the income and expense trend for your business
  • Customer Center Highlights, which show you the latest summary information about your customers, such as how much your customers owe you, the total overdue balances from your customers, and more. You can click on any headline to see more detailed information about it, either in another center or in a report.

You also have access to Decision Tools.

What Are Decision Tools?
Decision tools provide information to help you manage and make decisions about your business. QuickBooks decision tools help you compare alternatives, analyze your financial position, and set policies. In centers, click on a tool name to perform the analysis and learn how to interpret it. Tool names include:

  • Measure profitability
  • Analyze financial strength
  • Compare debt and ownership
  • Depreciate your assets
  • Manage your receivables
  • Employee, contractor, or temp?
  • Improve your cash flow

You can see the complete list of decision tools, with descriptions, in the Decision Tools Directory.

To use a decision tool
From the Company menu, choose Decision Tools, and then choose the tool you want to use.


Customer Center
In the Customer Center, you'll see a list of all customers who have open balances, including the amount each customer owes you and when. You can also customize the two tables at the bottom of the center to show any of the following sets of data:

  • Job-related time and cost expenses that you haven't yet billed to your customers (if the time tracking preference is turned on) This data is only available in QuickBooks Pro and Premier.
  • Customers with overdue balances
  • Ten most profitable customers
  • Ten least profitable customers
  • Ten most profitable jobs
  • Ten least profitable jobs
  • Ten most profitable products
  • Ten least profitable products
  • Ten most profitable services
  • Ten least profitable services

Note: QuickBooks doesn't include inventory assembly items when it calculates the ten most profitable and ten least profitable products.


Customer Detail Center
Use the Customer Detail Center to manage your business with individual customers. Use the drop-down list at the top of the window to choose the customer whose information you want to see.

At the top of the center, you'll see the Customer contact information for the selected customer. Click Edit/More Info to see further information about the customer or to edit the information.

You can customize the two tables at the bottom of the center to show any of the following sets of data:

  • Open invoices and statement charges
  • Payments you've received and credits you've issued
  • Outstanding items on order (if inventory tracking is on)

To display the Customer Detail Center
From the Customers menu, choose Customer Detail.

To display information for a different customer
From the Centers drop-down list at the top of the window, choose a different customer name.


Vendor Detail Center
Use the Vendor Detail Center to manage your business with individual vendors. Use the drop-down list at the top of the window to choose the vendor whose information you want to see.

At the top of the center, you'll see the Vendor Contact Information for the selected vendor. Click Edit/More Info to see further information about the vendor or to edit the information.

You can customize the two tables at the bottom of the center to show any of the following sets of data:

  • All unpaid bills that you owe to the selected vendor
  • All payments that you've already made to the selected vendor
  • Outstanding purchase orders (if inventory tracking is on)

To display the Vendor Detail Center
From the Vendors menu, choose Vendor Detail.

To display information for a different vendor
From the Centers drop-down list at the top of the window, choose a different vendor name.


Expert Analysis Tool (Premier and Enterprise Solutions editions only)
Use the Expert Analysis tool to help you better understand your financial data and improve the performance of your business. The Expert Analysis tool assesses performance trends for your business in important areas such as profits, sales, borrowing, liquidity, assets, and employees. It also shows how you are performing compared to others in your industry. Comparisons are available for more than 130 specific industries!

To open the Expert Analysis tool
From the Company menu, choose Planning & Budgeting, then choose Use Expert Analysis Tool.

 
QuickBooks Common Questions
 

How Do I Measure The Profitability Of My Company?
How Can I Measure The Financial Strength Of My Company?
Why Should I Compare My Business Debt To My Ownership In My Company?


How Do I Measure The Profitability Of My Company?
You can measure your company's profitability by determining your net profit margin. Your net profit margin represents how well your company has been generating profits. It shows you what percentage of each sales dollar ends up as profit. If expenses exceed revenues for a period, the result is a net loss.

Net profit margin allows you to compare quarters that have very different results in absolute dollar terms. Income, expense, and profit all vary from quarter to quarter. Since your Profit & Loss report is always different, it can be hard to know whether profitability is improving. You might reasonably assume that an increase in sales or net income means you're doing better - but that's not always the case. An increase in the bottom line may look better, but it's not if expenses are growing even faster.

You can generate, interpret, and improve your company's net profit margin by accessing the Net Profit Margin decision tool found in the QuickBooks Decision Tool Directory. Use this tool to see whether profitability is improving and track how the relationship between income and expenses changes over time.


How Can I Measure The Financial Strength Of My Company?
You can measure your company's financial strength by determining your current ratio and working capital. Your current ratio and working capital measure the liquidity of your business, the ability to meet short-term debt with current assets. The current ratio shows whether a company has sufficient access to cash to continue operations after paying off current liabilities. Working capital is the dollar amount by which current assets exceed current liabilities.

It's important to maintain a margin of safety in liquid assets to handle potential emergencies. Inventory shrinkage, uncollectible accounts, or a debt that suddenly comes due may require you to rely more heavily on your current assets. Keeping a cushion helps you weather the inherent uncertainties of running a business. In addition, loans are frequently tied to minimum working capital and current ratio requirements. With a sound liquidity position, your company's chances of obtaining a loan increase.

You can generate, interpret, and improve your company's current ratio and working capital by accessing the Current Ratio & Working Capital decision tool found in the QuickBooks Decision Tool Directory.


Why Should I Compare My Business Debt To My Ownership In My Company?
Your company can only be funded by three sources: operations, financing, and investors. To maintain financial strength and stability, it's important that your company have a proper balance of funding from these three sources.

You should compare your company's business debt to your company ownership to determine how much of your business debt is funded by creditors. The debt to equity ratio reveals how much of your business is funded by creditors. This ratio shows the degree to which the business relies on borrowed money, versus the degree to which it is supported by owners' investments.

Bankers and many other lenders look for a satisfactory debt to equity ratio before making a loan. Some loan contracts stipulate a maximum debt to equity ratio. You may increase your chances of getting a loan by keeping this ratio strong. Knowing your debt to equity ratio can help you keep your debt within reasonable limits, based on industry norms and your level of tolerance for risk and indebtedness.

The amount by which your business can realistically increase the debt to equity ratio is known as "borrowing capacity." Use knowledge about your borrowing capacity to plan for future financing needs. You should preserve some borrowing capacity for unforeseen opportunities or emergencies.

You can generate, interpret, and improve your company's debt to equity ratio by accessing the Debt to Equity Ratio decision tool found in the QuickBooks Decision Tool Directory.

 
QuickBooks Tips
 

Improve Your Cash Flow
Improve Credit Management


Improve Your Cash Flow
Encouraging your customers to pay you sooner rather than later is appealing for obvious reasons. But did you know that cash flow may improve when you get paid faster?
Cash flow - the lag time between cash outflows and the receipt of incoming cash - is a critical factor in business success. In fact, poor cash flow management is a common reason for new business failures. Accelerating cash inflows can improve cash flow by closing the gap between the date bills are due and the date of sale.

An example helps illustrate this point. A small clothing boutique places an order for its fall line in May. 25% is due when the order is placed, and the balance is due 30 days following receipt of the order. The store must pay for the entire line before it can sell enough clothing to make up the cost.

When autumn arrives, the store places an order for spring. It also extends special credit terms during its Labor Day sale. This causes a delay of cash inflows, making it difficult to cover current obligations. The store manager should pay special attention to collecting payments quickly in order to cover the gap between cash outflows and cash inflows.

QuickBooks has several features expressly designed to help you improve cash flow.

Manage Your Receivables
If you carry accounts receivable, you can improve cash flow by managing your accounts effectively. Effective A/R management begins with the establishment of a credit policy. A written credit policy helps you clarify when and to whom you are willing to extend credit. It also establishes a credit agreement between you and the customer. You can use the Manage Your Receivables tool to build a credit policy.

Establish an effective credit policy
A uniform credit policy can speed collections, save time, simplify management and improve your chances to win sales. Employees should know the policy and be able to communicate it to customers. However, one person ought to have responsibility for deciding about exceptions in special cases.

Your policy should reflect the standard in your industry and the nature of your business. Try also to minimize the administrative cost of tracking payments and making collections. The simpler your system, the easier it is to manage.

Establishing a credit policy involves decisions about credit terms and managing receivables. QuickBooks makes it easy for you by using the Manage Your Receivables decision tool. Click "Establish a credit Policy" and answer nine questions to create a standardized policy for your business. QuickBooks will save your choices and allow you to make revisions to the policy. When you're done, you can print the policy for easy reference by employees or customers.

Manage Your Receivables also provides tips on how to best use, analyze, and act on the information in Accounts Receivable reports. With the Average Collections Period calculator, you can determine whether slow collections are adversely affecting your cash flow. If they are, you'll learn what you need to do to make your billing and collections efforts more effective.

Sometimes, difficult customers can thwart even your best efforts at receivables management. Manage Your Receivables also advises you on when to use a collections agency and how to select one.

Bill and Get Paid Online
One way to improve cash flow is to bill more quickly. By faxing or e-mailing invoices and statements, you can bill customers right after the sale. They receive the invoice or statement within seconds rather than days, and you save time you'd otherwise spend printing them and sending them through the mail.

People often respond more quickly to e-mail and fax than to paper mail, increasing the likelihood that you'll be paid promptly. Sending invoices and statements online also gives you an opportunity to raise and resolve questions or problems quickly.

You can e-mail invoices, statements, and estimates without charge from within QuickBooks. QuickBooks also offers a service that enables you to fax your business forms as you create them. QuickBooks now has a way for your customers to pay you online. Once you register for QuickBooks Online Billing, the invoices and statements that you e-mail can include a link to the online payment service. This link takes your customers to a secure Web site that enables them to pay you online.

Accept Credit Cards
Accepting credit cards does more than just provide your customers with a convenient way to pay. It can also reduce or eliminate billing hassles and costs, and save you several trips to the bank.

With the QuickBooks Merchant Account Service you can enter credit card payments directly in QuickBooks and have the credit card authorized online. The payment is then automatically deposited into your bank account and recorded in QuickBooks, making duplicate data entry a thing of the past. You can also store customer's credit card information in QuickBooks in a secure, encrypted format, saving you the hassle of re-entering the same data repeatedly.

The QuickBooks Merchant Account Service can be used with QuickBooks Online Billing. Use QBOB to send invoices, statements, and estimates to your customer electronically. Then, when they pay you online, use the QuickBooks Merchant Account Service to collect and process their payment.

Learn More
Used together, the features just described represent a powerful way to improve cash flow. They make it easy for customers to pay you and even easier for you to manage. Here's how the tools and services can be used in conjunction with one another for maximum benefit.


Improve Credit Management
Extending credit to your customers can be risky, but often it would be impractical not to offer credit. If customer expectations or the nature of your business compel you to sell on credit, you need to manage the risks.

Customers who pay late (or not at all) cost you money by crimping your cash flow and directing your time towards collections rather than making more sales. Ideally, the cost of uncollectible bills should not be a significant cost of doing business.

According to the American Collectors Association, bad debt should amount to no more than 5% of your gross profit-sometimes even less, depending on your type of business. To keep your losses to a minimum and speed up the collection process, you need to take the following actions:

  • extend credit sensibly
  • keep an eye on your accounts receivable
  • collect overdue bills promptly

Increases in the availability of credit are making it easier and easier for many people to get into debt over their heads. In 1998, one in twelve Americans filed for bankruptcy, and consumer debt is still on the rise. In some industries, small business debt is as high as 70% of net worth. Now more than ever it is important to protect your business from the costs of late and unpaid bills.

How can a credit policy help?
The only surefire way to avoid collection hassles is to collect in full at the time of sale. If you would like to extend credit, you can prevent many potential delinquencies by establishing an effective credit policy. A good credit policy spells out the agreement between your company and the customer. It is your job to make sure the customer understands and agrees to your policy at the time of the sale.

An important part of any credit policy is to identify the risk level of a customer - both good and bad credit risk levels. Identifying bad credit risk prospects or customers allows you to limit or avoid potential accounts receivable problems and bad debt. Identifying good credit risk prospects and customers could identify opportunities where you can afford to offer better pricing or terms - enabling you to win business which you otherwise may have lost to competitors.

Your credit policy should be easy for your customers to understand and simple for you to manage. It should help you identify good and bad credit risks up front and protect both you and your customers from miscommunications. Used consistently, a well-conceived credit policy helps you win good customers and avoid the time, cost and frustration of handling late paying customers.

Track what you're owed
In accounting terms, invoices that have been sent but not yet paid are known as accounts receivable (A/R). Actively managing your accounts receivable can help you get paid faster. Good accounts receivable management starts at or before the time of the sale by the establishment and communication of your credit policy, and lasts until you collect the money you're owed.

Collect overdue bills
Acting promptly and decisively is the key to successfully collecting overdue bills. In general, the longer a bill has been outstanding, the harder it is to collect.

A strategy for dealing with past due accounts can simplify collections and help you get paid sooner, and it's easier and less time-consuming than dealing with past due accounts on a case-by-case basis. Refer to your policy and act on it when reviewing your A/R Aging Report.

It's a good idea to keep a record of accounts receivable history, including the actions you've taken to collect on a bill. Note when you took the action and the result or customer response. Such a record can support your claims in the event of a lawsuit. But more importantly, it aids your memory and helps you communicate with your customer about the details of their case. If you have more than one overdue account at once, this can be essential to avoid confusion.

Actions to take first
Your policy might have a longer time scale or fewer steps, depending on what's common in your industry, your relationship with your customers, and the amount of time you want to devote to collections. Whatever your plan, you should follow up with late paying customers quickly and repeatedly. In general, the sooner you contact a delinquent customer, the more likely you are to get paid. Use an escalating scale; begin with a friendly attitude and become gradually more insistent and formal in communicating that the customer pay their overdue bills.

Avoid high-cost, low-return collections. Consider the likelihood of recovering the money owed to you, the total amount due, and how much it will cost in payroll and materials to make the money materialize. The best way to reduce these costs is preventative: be proactive by setting up a clear credit policy and using it consistently.

If you've tried everything and you still can't collect on a bill, it may be advantageous to hand the account over to a professional collections agency. When and how you do this will affect your chances of recovering the amount due.

When to use a collections agency
Collections become increasingly difficult, expensive, and unlikely the longer a bill has been outstanding. Getting help from an agency early in the process for appropriate cases can make the difference between successful collection and a bad debt write off. Remember, sending an account to collections without good reason may alienate your customer. Do all you can to make it easy for the customer to pay prior to handing over the account.

The recalcitrant, argumentative, or non-communicative debtor is an ideal candidate for timely use of a collections agency. You should also consider using an agency when:

  • a customer is unresponsive to reminder notices
  • the customer makes repetitious, unfounded complaints
  • the customer denies responsibility for the obligation
  • account delinquency coincides with serious marital difficulty
  • the customer has multiple delinquencies and frequent job or address changes
  • obvious financial irresponsibility is evident
  • the debtor has moved to a new location
  • the debtor fails to keep in contact
  • your company has many bad debts or delinquent A/R

Professionals trained to deal with difficult debtors track down overdue payments, allowing you to concentrate on running your business. Most agencies make collections via letters and phone calls, like you would. But third party intervention sends a powerful message that you are serious about getting paid.

Debt collectors have special resources to help them locate customers that have moved. Agencies can also affect the credit standing of the debtor, giving your customer another good reason to pay. By law, debt collectors must adhere to strict standards that limit the methods they can use to collect on a debt.

Last resorts
When all else fails, it may be time to consider collecting your debt through a lawsuit. If the amount is under a certain limit-about $1500 in most states-you can file suit in a small claims court without the assistance of a lawyer.

If the debt is uncollectible and you don't want to pursue it further, it's usually possible to take a tax write off for the loss you incurred. Eligibility for this write off depends on your accounting method: if you use accrual basis, you can write off bad debt. Businesses that use cash basis cannot.

Ideally, you will never get to the point where you need to take either of these actions. But it's impossible to forestall every instance of uncollectible debt. If you find yourself in need of help, you may wish to check with your lawyer.

 
QuickBooks Product Updates
 
None
 
Articles
 
Using Financial Statements to Analyze Business Performance
Ratios to Measure Return on Investments
Ratios to Measure Safety and Liquidity
Ratios to Measure Operating Efficiency

Using Financial Statements to Analyze Business Performance
The information contained in the basic financial statements (including the notes thereto) can and should be used to proved insight into the financial strength and earning capacity of the business. This extends beyond such single statement captions as "net income" and necessitates that relationships between accounts be examined. While an almost unlimited number of such ratios and comparisons are possible, a relatively small group of these are traditionally the object of most attention.

The nature of the analysis depends on the perspective of the reader. For example, the short-term note holder would be primarily concerned with the company's ability to pay its current obligations. The holder of long-term debt might look to both historical and projected earnings and cash flows. The stockholders, current and future, would share a viewpoint similar to that of the long-term debt holder, with perhaps more concern for earnings (vis-à-vis cash flows) than the creditors might exhibit.

The management of a company is concerned with all the above factors and, in additions, needs financial information that is useful on a daily basis.

A selection of the financial relations that are most often computed to analyze the business is shows in the following sections.


Ratios to Measure Return on Investments

1. Return on equity

Ratio
Net Income (Income Statement)
Average shareholder's equity (Balance Sheet)
Example  
465,000 = 9.2%
(5,239,000 + 4,860,000) ÷ 2

Measures the return on the investment made by the owners.

2. Return on assets

Ratio
Net Income (Income Statement)
Total assets (Balance Sheet)
Example  
465,000 = 4.0%
11,636,000

Measure return on the gross investment in the business, including the financed by the owners as well as that financed by creditors. The relationship between the returns on assets and on equity is indicative of the effect of the business's financial leverage - if the leverage is positive, the return on equity will be greater than the return on assets.


Ratios to Measure Safety and Liquidity

1. Net working capital

Ratio
Current assets (Balance Sheet)
- Current liabilities (Balance Sheet)
 
Example
$2,155,000
- 1,924,000
$231,000

Indicates the ability to meet short-term obligations, reporting the excess of current assets over current liabilities.

2. Current ratio

Ratio
Current assets (Balance Sheet)
Current liabilities (Balance Sheet)
Example  
$2,155,000 = 1.12:1
1,924,000

Also indicates the ability to pay current liabilities as they mature, providing the ratio of current assets to current liabilities. A ratio of 1:1 or greater corresponds to positive net working capital.

3. Long-term debt ratio

Ratio
Long-term debt (Balance Sheet)
Capitalization (Long-term debt
plus stockholders' equity) Balance Sheet
Example  
$2,302,000 = 30.5%
$2,302,000 + 5,239,000

Indicates the balance between total equity ownership (common and preferred stockholders) and long-term debt. The greater the percentage, the "more leveraged" is the company.

4. Times interest earned

Ratio
Income before interest and taxes (Income Statement)
Interest expense (Income Statement)
Example  
$840,000 + 242,000 = 4.5 times
$242,000

Measure the ability of a company to cover the payment of interest to borrowers.

5. Debt service ratio

Ratio
Income before interest and taxes (Income Statement)
Interest expense plus amounts of scheduled debt
repayments (Income Statement and Statement of
Cash Flows)
Example  
$840,000 + 242,000 = 1.9 times
$242,000 + 324,000

This ratio is an indicator of the company's ability to pay both the interest and the current principal installments on its outstanding debt and suggest the degree of safety for creditors concerning currently due debt service obligations.


Ratios to Measure Operating Efficiency

1. Collection period

Ratio
Average accounts receivable (Balance Sheet)
Average daily sales (Income Statement)
Example        
(1,178,000 + 1,175,000) ÷ 2 = 1,176,500 = 53.4 days
7,934,000 ÷ 360 22,039

Measure the number of days' scales that are uncollected in average accounts receivable, providing an idea of how successful the firm is in collecting its customer debt.

2. Receivable turnover ratio

Ratio
Total sales (Income Statement)
Average accounts receivable (Balance Sheet)
Example  
7,934,000 = 6.7 times
(1,178,000 + 1,175,000) /2

An alternative, but equivalent, measures of the efficiency of the company's receivable collection efforts. If the company also makes sales for cash, "total credit sales" should be substituted for "total sales."

3. Number of days' sales in inventory

Ratio
Average inventory (Balance Sheet)
Average daily cost of sales (Income Statement)
Example        
(458,000 + 424,000) /2 = 441,000 = 23.3 days
6,816,000 / 360 18,933

An indicator of the amount of inventory maintained relative to the company's sales (as measured by cost of goods sold).

4. Inventory turnover ratio

Ratio
Cost of goods sold (Income Statement)
Average inventory (Balance Sheet)
Example  
6,816,000 = 15.5 times
(458,000 + 424,000) /2

An alternative measure of how quickly inventory is sold.

 

This Newsletter is not produced or endorsed by Intuit®, the maker of QuickBooks.

QuickBooks® is a registered trademark of Intuit, Inc.