QuickBooks and Excel: Importing and Exporting Transactions

28mIntermediate2020-03-12

Authors

Michael McDonald

Researcher and Professor of Finance at Fairfield University

Course details

Businesses all have their own way of recording financial information. The challenge is getting all the data into your analysis software in a clean and consistent format. This course helps you import and export sales transactions, financial statements, customer lists, and other important business data with Microsoft Excel and QuickBooks. Learn how to move data in and out of QuickBooks and Excel and generate common types of financial statements such as income and cash flow statements and balance sheets from QuickBooks. Instructor Michael McDonald also demonstrates how to format and upload text data in QuickBooks.

Topics include:
- Describe the outputs when importing and exporting files between QuickBooks and Excel.
- Identify limitations in QuickBooks as a bookkeeping software.
- Define financial statements used with QuickBooks.
- Review the steps necessary to import and export files between QuickBooks and Excel.
- Differentiate the use of QuickBooks and Excel in creating financial statements.

Skills covered

QuickBooks OnlineQuickBooksIntuitAccounting SoftwareSpreadsheetsMicrosoft ExcelFinance and AccountingBusiness Software and ToolsMicrosoftDeep Dive (X:Y)

Concepts

0. Introduction

01 - Saving time with QuickBooks and Excel

1. Downloading and Uploading Data with QuickBooks and Excel

02 - Using the QuickBooks interface
03 - Downloading transactions from QuickBooks
04 - Uploading Excel data to QuickBooks
05 - Limits on Excel data in QuickBooks
06 - Income statements in QuickBooks
07 - Inventory in QuickBooks
08 - Balance sheets in QuickBooks
09 - Cash flow statements in QuickBooks
10 - Going from text files to QuickBooks

Conclusion

11 - Go further with QuickBooks and Excel