Subscribe by Email

Your email:

Newsletter Subscription

Receive DataCraft News fresh off the presses - direct to your email.

Subscribe to DataCraft News 

 

Ask the Bean Counter

ask the bean counterHave a question you would like to see answered here?

Submit your question to the Bean Counter

DataCraft Blog

Current Articles | RSS Feed RSS Feed

Can QuickBooks be an ERP system?

  | Share on Twitter Twitter | Share on Facebook Facebook | Submit to Digg digg it |  Add to delicious  delicious |  Submit to StumbleUpon StumbleUpon |  Share on LinkedIn LinkedIn | Submit to Reddit reddit 

Intuit Solution ProviderMany people use the accounting software in QuickBooks and forget the rest.  For the most part, clients know how to use accounts receivable and accounts payable.  What is often forgotten or misused in QuickBooks?  That would be estimates, sales orders, sales reports and items (products and services you sell). 

People misunderstand the importance of using estimates (bids, grants, proposals or quotes) for follow up and profit margin tracking.  Sales people or customer service could be entering those estimates directly into QuickBooks.  Worried about your employees messing up your software?  Security controls can be established so that they can't go anywhere else in the software.  Do you know what your profit margin is per job or are you simply making journal entries and "approximating" the profit margins?  What was the estimated versus actual revenue and costs?  Can you set up your company's selling workflow in the software?  You should be able to.

Whether you sell products or services it is vital to set up items in QuickBooks.  Why?  The more detail you use for item lists the better your reports.  Questions can be answered like ... Which item is my best source of income?  Which items are my best sellers?  Product costs and labor costs should all be set up and tracked in QuickBooks.  Pricing? Set up your price levels and use those to your advantage to help control sales profit margins.

The Sales Order tool is excellent for managing partial shipments and sales order fulfillment for inventoried products and their interface to purchase orders, pick lists, and packing slips in QuickBooks.  

A full or mini ERP implementation should take full advantage of the financial and business software your company purchased.

For the above metioned QuickBooks functions, it makes a difference which QuickBooks package you have ...

Is QuickBooks right for your company? Compare it to other leading software systems: Download the Software Selection Guide

Accounting Ratios 101

  | Share on Twitter Twitter | Share on Facebook Facebook | Submit to Digg digg it |  Add to delicious  delicious |  Submit to StumbleUpon StumbleUpon |  Share on LinkedIn LinkedIn | Submit to Reddit reddit 

In the world of accounting, ratios give and invaluable amount of information about your company and it's fiscal well being. Accountants use financial ratio analysis on a regular basis. These analyses help to evaluate the financial performance by comparing financial ratios of a business over various periods of time to other businesses in the same industry.

accounting ratio formula In his book Financial Analysis Tools and Techniques , financial expert Erich A. Helfert defines ratios analysis as
"the use of a variety of ratios in analyzing the financial performance and condition of a business from various viewpoints such as managers, owners, and creditors.

Get out your financial calculator.
There are three different types of ratios:
Liquidity
Profitability
Solvency

Liquidity
Liquidity ratios measure your business short-term ability to pay bills as they are due and let you know if you have the cash to cover and unexpected expenses. Liquidity ratios compare your most liquid assets (assets that are easily turned into cash) with your short-term liabilities. In general, the greater the ratio of liquid assets to short-term liabilities, the better off your company is. These ratios let you know that your company can pay debts that are owed and still continue to operate normally.

Current Ratios
Acid Test Ratios
Current Cash Debt Coverage
Receivables Turnover
Inventory Turnover

Profitability
Profitability ratios measure the operating success of your company for a specific period of time. They give you a better understanding of how well your company made use of its resources to generate profit.

Profitability Ratios
Profit Margin
Cash Return on sales
Asset Turnover
Return on Assets
Return of Equity

Solvency
Solvency ratios measure how well your business can survive over a long period of time by measuring your income after taxes. Solvency ratios take a look at your past financial statement analysis and let you know if your company can continue to pay its debts now and in the future by looking at your income after taxes. A ratio that is higher that 20% means that your business is financially healthy. The lower your ratio, the greater chance your company will default on its debt obligations.

Solvency Ratios
Debt to Asset
Times Interest Earned
Cash Debt Coverage

All of these ratios, liquidity, profitability, and solvency alike can provide you with useful financial information about your company. If you can get so much information from just looking at one type of ratio, imagine the invaluable knowledge you can gain to keep everything on track and guide your company to success.

Basic Accounting Structurecash ratio formula

10 Reasons Why You Shouldn't Care About Accounting Basics

  | Share on Twitter Twitter | Share on Facebook Facebook | Submit to Digg digg it |  Add to delicious  delicious |  Submit to StumbleUpon StumbleUpon |  Share on LinkedIn LinkedIn | Submit to Reddit reddit 

Business owners really know how to provide quality products and services. But when it comes to simple accounting basics that can make an impact on the success of their business, some business owners are left in the dust.

Being a business owner isn't for everyone, in fact, most businesses don't make it through their first year. People who don't care to learn all aspects of owning a business especially accounting- probably didn't care about running a successful company in the first place. If you agree with any of the following, you'll probably find yourself in the same category as them.

1. You don't care if your business is profitable.
You should only bother knowing the simple accounting if you care about the health of your company. Accounting provides structure to help business owners keep track of whether or not their business has made any money over time and where that money is coming from. Knowing the nuts and bolts will tell you how profitable your business is by keeping track of how much money is going out and coming in.Accounting Basics

2. You don't care about what others think.
As the business owner, you're not the only one who cares if your company is making any money. Banks and investors are very interested in knowing how well your business is doing financially. Banks will look at your business from a fiscal standpoint to determine whether or not they should loan your company money. More importantly, they want to be sure that if they give you a loan, you will be able to pay it back. Investors will also want to know if your company is a solid investment and a financial statement will tell them not only if, but how much they should invest into your company. The better you understand the ins and outs of your company's financial state, the more likely the bankers and investors will give your business the money that it needs.

3. You aren't concerned about employee theft; "they're like family."
This isn't to say that you can never trust your employees - there is no doubt that many employees are hard working and honest - but keeping tabs on your financial accounts can help you keep track of where your money is going. According to Score.org expense reports, payroll, purchasing, and suspense accounts are just a few of the places that disloyal employees are most likely to skim a little off the top. For a complete list of areas where employee fraud is most prevalent and what you can do as an employer to prevent employee theft, read the rest of the article.

4. You like selling products that lose money - you'll "make it up on volume"
Thinking about reducing prices to sell more products? Think again. While it may seem like it might make sense to slash prices to move more product, you are more than likely loosing out. Reducing prices reduces your gross profit margin and create more effort for your company to break even. Then again, if you knew accounting 101, you probably already knew that.

5. Cash flow isn't important to you
Your Cash Flow Statement gives you a snapshot of your company's short-term financial health. Knowing your company's cashflow is crucial, it will help you to determine if you have enough money on hand to pay employees and creditors on time. Companies who pay attention to their cashflow analysis know that if they have abundant cash on hand are able to invest the cash back into the business in order to produce more profit.

6. You don't really need to know if your customers have paid you yet
You don't care your customers don't pay their bills right? Of course you do! If you don't keep track of who has and hasn't paid you, how are you supposed to collect?

7. The IRS doesn't care if you've made your payroll tax deposits
Payroll taxes are the responsibility of every employer. Business' payroll tax responsibility consists of not only the taxes required to be withheld from employees' wages -Social Security tax, Medicare tax and federal income tax- but also that the employer's match their share of Social Security and Medicare taxes. Businesses that don't make payroll deposits can face some major penalties, including jail time.

8. Your suppliers never call you to collect their money
Just like you want to make sure that your customers pay you, the same holds true for your vendors. Keeping track of your invoices will help you stay up-to-date with liabilities and due dates for bills.

9. Your employees donate their time and don't expect to get paid
While satisfaction of a job well done is crucial for your employees to be happy and remain with your company, so is a paycheck. Not very many people can afford to volunteer 40 hours of their week. Knowing the basics, like cash flow, lets you make sure that you have enough money to pay your employees for all of their work.

10. Accounting is too difficult to learn anyway.
You don't need to be a mathlete to have a working knowledge of accounting. Chances are that if you're smart enough to learn how to run a company, you're smart enough to learn the fundamentals of accounting. Monica has put together an easy to understand course, Basic Accounting Structure that helps to explain the makeup of accounting, including the different kinds of accounts and basic financial statements that your business uses everyday.

Hopefully you don't find yourself agreeing with any of the reasons above, but if for some strange reason you might, then don't bother to learn anything about accounting; hire a mathlete to take care of all of your finances. But then again if you don't care about your money, you probably don't have enough to hire someone who does.

Photo credit: Carol Ester

Cash turnover ratio formulaAccounting basics

All Posts