Good accounting and bookkeeping requires making ledger entries. This can be done in QuickBooks and then exported to Excel for analysis. In this video, learn how to use QuickBooks with Excel.
- [Instructor] QuickBooks is designed…to be relatively simple.…It's designed for small businesses…all the way up to big businesses.…But a lot of big businesses need more sophisticated tools.…Many big businesses have a whole set of different ledgers…they keep track of.…You can get to this in QuickBooks as well.…If you come over to the reports tab…from your dashboard in QuickBooks,…you can see your profit and loss, your balance sheet,…and other notable ledgers…that you might want to keep track of.…
So QuickBooks has a lot of very powerful tools…in addition to that.…If you come over to the accounting,…you can come to chart of accounts,…and this will list all…the different accounts that you have.…Now in this case, since we simply have a sample company,…we don't really have most of these things…filled out or available to us yet.…But nonetheless, let's take a look at what we do have.…All right, so once you've clicked on chart of accounts…you'll come to a register…of multiple different types of accounts…and you can go through and analyze how the firm is doing…
- 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.