How to Make an Excel Spreadsheet From Quickbooks Data for a Cash Flow

Make an Excel spreadsheet from QuickBooks by using the "Export" option.

QuickBooks Pro 2008 can use be used with Excel to make spreadsheets to track cash flow. The Cash Flow statements in QuickBooks Pro 2008 are based on the balance sheet and show the changes in assets and liabilities for the period. Excel spreadsheets can help you track the details of the cash received and the cash spent for the period.

Print this article

QuickBooks Pro 2008
Dates for cash flow reports

Instructions

Statement of Cash Flow Spreadsheet
- 1
  
  Choose "Reports" from the menu bar. From the drop-down menu, choose "Company & Financial," then choose "Statement of Cash Flows."
- 2
  
  When the report appears, choose the dates for the report. Dates appear in the menu bar at the top of the report.
- 3
  
  Choose "Classify Cash" from the menu bar.
- 4
  
  The Company Preferences will appear. Choose "Cash" or "Accrual." You may also modify the dates for the transactions, choosing due date or transaction date, and assign accounts to display on the report. When finished, choose "OK."
- 5
  
  Choose "Export" from the menu bar. There are two tabs, Basic and Advanced.
- 6
  
  Choose "Basic," and choose "Excel Spreadsheet."
- 7
  
  Choose "Advanced," and uncheck "Space between columns." By unchecking this, Excel will not insert blank columns between the downloaded columns of data.
- 8
  
  Choose "Export." QuickBooks will open Excel and download the spreadsheet.
Cash Flow Forecast Spreadsheet
- 9
  
  Choose "Reports" from the menu bar. Then choose "Company & Financials," and choose "Cash Flow Forecast" from the drop-down menu.
- 10
  
  The Cash Flow Forecast displays changes in Accounts Receivable, Accounts Payable and Bank Accounts, and it shows Net Inflows of assets and the Projected Balance.
- 11
  
  Choose dates from the menu bar that you want to report.
- 12
  
  Choose the period you want to report, either weeks, months, quarter or year.
- 13
  
  Choose "Export" from the menu bar, and repeat Steps 5 through 8 from the first section above for exporting the QuickBooks data to Excel.

Photo Credit Girl on her workplace working image by Angel_a from Fotolia.com

Comments

How to Create a Cash Flow Statement
A cash flow statement could very well be the most important bookkeeping tool in the business owners arsenal. Cash flow statements can...
Activities on Quickbooks
Activities on Quickbooks. In discussing the accounting term "Activities" be aware there is a specific reference this term applies to. Accounting-wise, there...
Cash Budgeting, Forecasting Cash Flow and Account Analysis
Cash flow problems can be one of the main causes for business failure. That is not any surprise, since without cash, bills...
Importance of Statement of Cash Flows
The statement of cash flows is an integral part of a company's financial statements. It tells an investor the most important thing...
Activities on a Cash Flow Statement
The cash flow statement is one of the three most important financial statements published by a company. It provides information about the...
How to Make Money With Cash Flow Notes
A cash flow note is like an IOU for a debt that can be bought and sold. If you buy one, the...
How to Create a Cash Flow Statement
In a cash flow statement, a person itemizes expenses and estimates sales revenues in order to get an idea of how much...
How to Analyze Your Cash for Budgeting & Forecast Your Cash Flow for Your Accounting
Cash is king, especially with small businesses that may not survive without proper financial management. Cash analysis helps in creating realistic budgets...
How to Make a Cash Flow Statement
The cash flow statement reports on the cash used or generated under three sections: operating activities, investing activities and financing activities. A...
How to Understand a Cash Flow Statement
A cash flow statement shows how much money is coming in and going out of a business. Monitor the success of a...
How to Create Expense Reports in Excel
Keeping track of your business expenses can be a complicated task. Managing receipts and information will help you or your accountant when...
How to Enter Petty Cash Into QuickBooks
QuickBooks money management software is designed to help businesses track and create financial statements. In QuickBooks, you can add bank accounts, customer...
How to Create a Spreadsheet Template in Excel 2003
If you would like to use the same basic setup for several Excel spreadsheets, it might be wise to create a template....
How to Get Money to Start an Import/Export Business
Many billions of dollars worth of goods and services are traded between almost every country in the world every day, and this...
How to Create a Spreadsheet to Run in QuickBooks
QuickBooks financial management software includes options for running spreadsheet information from within the QuickBooks interface. QuickBooks can import spreadsheets ...
How to Prepare a Cash Flow Statement
A cash flow statement is a document that shows how much cash (or cash equivalents) comes into a business and how much...
How to Calculate Free Cash Flow Valuation With Excel
Free cash flow (FCF) is a measure of the cash available to make interest payments to potential creditors and equity investors, and...
How to Make a Spreadsheet for a Business
Record keeping is an essential component in business. Maintaining accurate records lets you know how well you are doing in various areas...
How to Report an Owner Withdrawal on My Cash Flow
A sole proprietorship or partnership typically has owner draw accounts as part of its general ledger. These accounts hold any information related...
How to Import From QuickBooks to Access
If you have data that you've created with the QuickBooks professional financing software, then you can easily export the data at any...

How to Make an Excel Spreadsheet From Quickbooks Data for a Cash Flow

Other People Are Reading

Things You'll Need

Instructions

Statement of Cash Flow Spreadsheet

Cash Flow Forecast Spreadsheet

More Like This

Comments

You May Also Like

Related Ads

Kid-Approved iPad Apps by Mom.me

You May Like