Categories
Cash Flows QuickBooks Online QBO

Cash Flow Dashboard Widget in QuickBooks Online

To turn this on: Gear > Your Company > QuickBooks Labs

The cash flow chart uses historical data from your Banking tab — bank connected transactions only.

The chart excludes:

CSV import, Credit card, entered manually into QBO, Multicurrency transactions

More Info…

Categories
Reports

How to Forecast Cash Flow

Categories
Cash Flows Navigation Reports Sales

How does QuickBooks Online produce the Statement of Cash Flow Report?

Statement of cash flow is a financial statement that shows how changes in balance sheet accounts and income affect cash and cash equivalents and break the analysis down to operating, investing and financing activities.

First, the report run is based on an accrual basis accounting method in QBO. It is hard-coded so you can not change it to cash basis method nor can be edited for any preferences to classify cash like in QuickBooks desktop versions.

In QBO, they also have the following three standard sections for the cash flow analysis.

  • Operating
  • Investing
  • Financing

It shows the amount of cash earned from profit, where you received additional cash and where your cash was spent. It uses all Bank type accounts from your chart of accounts. It also includes “undeposited funds account” from other current assets type.

The Statement of Cash Flow assumes that all activity through current assets and current liabilities are OPERATING ACTIVITIES. It also includes “accumulated depreciation” from fixed assets type.

Any entries that affect fixed assets (at original cost, less accumulated depreciation) are INVESTING ACTIVITIES. It also includes “other assets” type.

Any entries that affect long term liabilities and equity are FINANCING ACTIVITIES.

Here is how the standardized list of mappings for the different category type assigned to a section of the Statement of Cash Flow in QuickBooks Online.

Here is detail account list of Category Type (Account Type) for the Balance Sheet accounts from the chart of accounts sorted by Activities.

Cash
Operating

Investing Activities

 Category Type
1Fixed Assets (original cost)
2Other Assets
Investing

Financing Activities

 Category Type
1Long Term Liabilities
2Equity
Financing

Example of Statement of Cash Flow Report in QBO:

Profit and Loss Net Income line forwarded to Operating Activities
Statement of Cash Flow Report
Categories
App Apps

QuickBooks Online (QBO) Helpful Apps List

Accounts Receivable Management (8)

Auto Dealership Management(1)

Banking and Credit Card Processing (4)

Barcodes and Labels (2)

Billing and Invoicing (23)

Business Analytics (10)

Business Planning (4)

Business Reporting (8)

Business Research (2)

Calendar / Scheduling (2)

Collaboration (2)

Communications (3)

Custom Reporting (3)

Customer Management (CRM) (16)

Data Import / Export / Sync (20)

Data Removers (1)

Data Security / Disaster Recovery (1)

Dispatch, GPS and Tracking Solutions (3)

Document Management (2)

Ecommerce (17)

EDI – Electronic Data Interchange (1)

Employee Management (2)

ERP / MRP / Shop Floor Solutions (5)

Estimating and Bidding (5)

Expense Management (11)

Field Services Management (7)

Finance & Accounting (40)

Financial Management (15)

Freight Management (1)

Inventory Management (11)

Law Practice Tools (1)

Marketing (7)

Mobile (19)

Operations (30)

Payroll (2)

Point of Sale Solutions (4)

Productivity (21)

Project Management (7)

Project Planning / Workforce Allocation (3)

Purchasing (4)

Retail Management (3)

Sales and Marketing (35)

Sales Commission (2)

Sales Management (11)

Shipping (1)

Social Media (1)

Tax Tools (2)

Templates and Forms (1)

Time Tracking (9)

Trucking Solutions (1)

 

 

Helpful link

Categories
Reports

How to change cash flow forecast beginning balance in new QuickBooks Online?

In QBO, Cash Flow Forecast beginning balance is based on accrual basis accounting method. And, it is fixed. No way to change it from accrual to cash.

If you are running the Balance Sheet and Profit & Loss reports, you will need run on accrual basis as well to match with Cash Flow Forecast report?

For detailed instructional guide regarding these topics, you can also checkout our YouTube videos published for new QuickBooks Online users.

QuickBooks Online (QBO) Tutorial – Customer Invoice, Sales Receipt, Receive Payment, Bank Deposit

New QuickBooks Online Plus – How to enter various expenses in new QBO?

Like us ~ Subscribe us.