Importing data from Excel to QuickBooks can be tricky. In this video, learn how to effectively and quickly move 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 transaction data,…one with the date, one with a description,…
- List the most common tasks and approaches faced by accountants in their daily lives.
- Determine whether transactions can be exported from Quickbooks to Excel or not.
- Outline the structure that the SUMIF function uses.
- Explain how to measure EBITDA.
- Identify at what level the General Ledger tracks expenses.
- Break down how to construct a business valuation using a cash flow analysis.