Description:

In this video we show to you how to export reports to excel (plus pivot tables) in QuickBooks

Video:

Table of contents:

  • 00:00:27 – Reports (company & financial, profit & loss standard, balance sheet standard)
  • 00:00:40 – Customize report (modify report, advanced options)
  • 00:01:04 – Excel tab (create new worksheet) (send report to excel)
  • 00:01:15 – Excel spreadsheet (balance sheet)
  • 00:01:41 – QuickBooks Desktop (customize report, advanced, collapse button) (excel tab, create new worksheet, send report to excel, in existing workbook, export)
  • 00:02:33 – Excel spreadsheet (profit & loss)
  • 00:02:53 – Analysis (create new sheet) (ratios) (example, return on fixed assets, marketing expense / sales) (total net income / total fixed asset, formula %) (marketing expense / total income, formula)
  • 00:04:33 – Change periods inside of QuickBooks
  • 00:04:47 – Excel tab (update existing worksheet) (select profit & loss) (update existing worksheet) (select balance sheet)
  • 00:05:52 – Excel file (check ratios spreadsheet)
  • 00:06:35 – Example (click on total income, create a report that contains all of the detail income data that exists in the QuickBooks file and export it to excel) (pivot table) (send report to excel, select create a comma separated values (.csv) file, export)
  • 00:07:40 – Open CSV file (sales detail) (clean up columns)
  • 00:08:23 – How to create a pivot table (excel, insert, pivot table) (step by step) (examples)
  • 00:11:28 – How to create a graph in Excel file (step by step) (example)
Share →

Leave a Reply

Your email address will not be published. Required fields are marked *



For More Information

Call us to 954-633-2718 or email: hector@quickbooks-training.net