3 Reasons Your QuickBooks Statement of Cash Flow is Wrong

Loading...
Plans & Pricing

Solutions

About Us

Who Uses CFOwise?

Blog

Contact us

Website Login

The Six Scoreboards Every Business Needs™

Call Today 800.531.4218 or 855.CFO.wise

Blog Categories

F REE CONSUL T AT ION

3 Reasons Your QuickBooks Statement of Cash Flow is Wrong

accountant Accounting black friday Bookkeeping

Tweet

by Ken Kaufman October 1, 2009

Budget

Share

Business business dashboard Business Model Business Plan Cash Flow CFO CFO Services Christmas Debt Financing discovery Economy Entrepreneurship

The statement of cash flows is the most valuable, the most under-used, and the least understood of the three main financial statements (profit & loss, balance sheet, statement of cash flows). Since a lot of businesses use QuickBooks, I feel it is critical to make sure we all understand what needs to happen to make this reporting feature more accurate.The statement of cash flows is the most valuable, the most underused, and the least understood of the three main financial statements (profit & loss, balance sheet, statement of cash flows). Since a lot of businesses use QuickBooks, I feel it is critical to make sure we all understand what needs to happen to make this reporting feature more accurate. It is likely that our QuickBooks-generated statement of cash flows is incorrect for the following three reasons: CLASSIFICATION OF ACCOUNTS

Equity Financing execution Exit Strategies Financial Health Financial model Financial Statements Foundry General Business Human Resources IMPACT Interim CFO Internal Controls

Each time a QuickBooks user creates a new account the system looks at the type of account and, if that account type is on the balance sheet, it is classified into one of the three sections of the cash flow – cash from operations, investing, or financing. QuickBooks is often right in its inclusion of accounts on the statement but it can be very wrong on the section of the statement in which the account should be included. For example, a working capital line of credit is often coded as a current liability. QuickBooks assumes this account should be in the operating section of the cash flow, but that is not always the case. A line of credit is usually reported in the investing section of the statement. The classification of all accounts can be manually changed in QuickBooks by going to Edit, Preferences, Reports and Graphs (Company Preferences), and then click on the Classify Cash button in the Statement of Cash Flows section. An account is placed on the report when a checkmark is next to the account in one of the three fields, which represent each section of the report.

Leadershi

DEPRECIATION

Leadership

The whole purpose of the statement of cash flow is to adjust the net income reported on the profit and loss to the cash position of the company. Depreciation is a non-cash expense, and, therefore, is added back to net income as a first order of business on the statement of cash flow. Since depreciation is not a balance sheet item, QuickBooks, by default, does not even include it on the statement of cash flows. QuickBooks does, however, include accumulated depreciation on the report, but it is reported in the investing section (depreciation is technically part of the operating section). To correct this situation, two things must be done. First, follow the instructions above and remove the accumulated depreciation account from the report. Second, add the depreciation account to the operating section.

lean Management Management Reports Operations part time cfo Part-Time CFO planning

CHANGES TO PRIOR PERIODS

Press Releases Profit Sales & Marketing Sales & marketing Scoreboard Social Media Start-Up startup Startups

This issue causes problems with all three of the financial statements. Once a period is complete, all of the accounts are reconciled, and financials have been issued, there should be no more changes to that period or earlier. By simply using the Closing Date and Password functionality of QuickBooks, the company can lock prior periods and protect them from any attempts to add to, delete from, or change any transactions in the closed periods. This is easy to use and can save the business from a lot of headaches in the near and long-term, not to mention safeguard the accuracy of it’s reporting. This is done by going to Edit, Preferences, Accounting (Company Preferences), and then clicking on the “Set Date/Password” button in the Closing Date section. This will allow you to set the date of the close as well as only allow people to make changes prior to that date if they know the closing date password. CONCLUSION

Strategy

If I could only receive one of the three financial statements, I would always pick the cash flow statement. It is the most valuable for any business, especially start-up and emerging businesses. It is the best indicator I have in my role of part-time CFO and business finance consultant for any business, especially start-up and emerging businesses. By setting up QuickBooks correctly and then using it correctly it is capable of cash flow reporting that will help entrepreneurs and CEO maximize their cash flow.

Tax validation

Cash Flow Financial Statements Part-Time CFO

Filed under: · Add new comment

Newsletter

COMMENTS Submitted by admin (not verified) on Wed, 03/10/2010 - 13:41.

Cutting-edge and high-impact articles focused on practical and implementable advice about entrepreneurship and finance delivered bi-monthly.

reply

Enrico, The next best option is to move the accumulated depreciation account to the operations section of the statement of cash flows. The total change in the accumulated depreciation will almost always equal your total depreciation expense for the period, so your statement should still be accurate. Ken K.

Sign Up for FREE > Submitted by Enrico Hernandez (not verified) on Wed, 03/10/2010 10:17. reply

Dear Ken: I tried following your recommendation regarding removing accumulated depreciation and adding depreciation on the Cash Flow Statement setup in QuickBooks. QB says you can't remove balance sheet accounts. Is there another workaround? I agree depreciation belongs in the operating section of the cash flow statement. Thank you, Rico Hernandez

Call Today 800.531.4218 or 855.CFO.wise Plans & Pricing

Solutions

iPhone | Android

About Us

Search

Follow us on:

Who Uses CFOwise?

Overview

Gain Clarity

Our Team

Testimonials

Our Process

Maximize Cash

Compare Us

Case Studies

Products & Services

Improve Profit

History

Why Choose CFOwise?

Optimize Time

Events

Clarity Guarantee

Enter & Exit

How We Operate

For CPAs

Public Relations

Financial Ratios

Careers

Will the Six Scoreboards Help You?

Six Scoreboards

Privacy Policy

Impact your Business Book

Business Finance Consulting

Security

Financial Statement Course IMPACT Indicators®

© Copyright CFOWise all rights reserved.

Contact us

Tools

Compensation Calculator For CPAs

IMPACT Forecaster® IMPACT CFO Services®

Recent Blog Posts Entrepreneurs, Drummers, and Merry Christmas Great Lessons Learned from Grandma 3 Real Costs of Regulation Realized This Summer The Devil in the Details Cash: Your Best Friend and Biggest Blinder

Newsletter Signup Sign up to receive the latest and greatest from CFOwise! Full name: *

Email: *

What code is in the image?: * Enter the characters shown in the image.

Sign Up

Loading...

3 Reasons Your QuickBooks Statement of Cash Flow is Wrong

Plans & Pricing Solutions About Us Who Uses CFOwise? Blog Contact us Website Login The Six Scoreboards Every Business Needs™ Call Today 800.53...

202KB Sizes 3 Downloads 4 Views

Recommend Documents

Analyzing Cash Flow: How to Use Cash Flow Statement | QuickBooks
Using the direct method, cash flows from operating activities are reported as major classes of operating cash receipts a

Analyzing Cash Flow: How to Use Cash Flow Statement | QuickBooks
Using the direct method, cash flows from operating activities are reported as major classes of operating cash receipts a

Free Cash Flow Statement Template - Intuit QuickBooks
A cash flow statement, along with the balance sheet and income statement (i.e. profit and loss statement), is one of the

How to Read a Cash Flow Statement | QuickBooks - Intuit QuickBooks
How much money does your company have available right now? That?s a question your cash flow statement can answer.

Financial Literacy-Cash Flow Statement (Statement of Cash Flows) | Is
Apr 14, 2017 by Andrew Clark. Most veterinary businesses can operate very effectively using three financial statements;

What is Cash Flow? Use a Sample Cash Flow Statement
A cash flow example or sample cash flow statement can help you understand how to handle your cash flow calculation. ...

What is Your Cash Flow Statement Telling You? - Meaden & Moore
Jan 16, 2014 - The cash flow statement is a very powerful tool in determining your financial stability of your business

Sample Cash Flow Statement. Here Is Our Template For Your
Sample Cash Flow Statement - 8+ Documents In Pdf, Word ... 17 Free Cash Flow Statement Templates - Word Excel Sheet Pdf.

Cash Flow Statement - How a Statement of Cash Flow Works
The cash flow statement is commonly presented using the indirect method. It starts with net income or loss, followed by

What Is A Cash Flow Statement? - Investopedia
Oct 31, 2017 - These adjustments are made because non-cash items are calculated into net income (income statement) and t