From the course: Excel for Accountants
Unlock the full course today
Join today to access over 23,400 courses taught by industry experts.
Import data from Excel to QuickBooks - Microsoft Excel Tutorial
From the course: Excel for Accountants
Import data from Excel to QuickBooks
- [Instructor] Oftentimes, rather than moving data out of QuickBooks and into Excel, accountants want to do the opposite. They want to take a bunch of data that a client has in Excel and move it into QuickBooks. This is possible, though unfortunately not as easy or as powerful as we might like. Let's take a look at how that works. I'm in the 02_08 Begin Excel exercise file. Now, what we have here are transaction data throughout the year 2017. And in particular, if we just scroll through, we see a variety of different transactions with the date in column A, the description of the transaction in column B, and then the transaction amount in column C. And all of these are expenses. Now, one thing to be aware of as we look through this, all of this information is related to particular expenses for the firm. But we don't have any information about check numbers or payment types or anything of the sort. That is purposeful. QuickBooks won't let us import more than three columns for…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
Small business accounting overview3m 47s
-
(Locked)
Transactions in QuickBooks and Excel4m 51s
-
(Locked)
Quarterly profit and loss tracking in Excel4m 39s
-
(Locked)
QuickBooks and ledger records3m 38s
-
(Locked)
Taxes and Excel record-keeping3m 58s
-
(Locked)
Tracking business performance in Excel4m 43s
-
(Locked)
Pivot tables for accountants3m 58s
-
(Locked)
Import data from Excel to QuickBooks4m 42s
-
-
-
-
-