From the course: Excel for Accountants
Unlock the full course today
Join today to access over 23,100 courses taught by industry experts.
Taxes and Excel record-keeping - Microsoft Excel Tutorial
From the course: Excel for Accountants
Taxes and Excel record-keeping
- [Instructor] Once you're able to construct a basic ledger and bring bookkeeping information out of QuickBooks and into Excel, your next step might be to analyze that information based on the organization's needs. For example, for annual tax recordkeeping purposes. We can do exactly that using Excel and the If state, or more accurately, some of the derivatives of the If statement, such as Sumif. I'm in the 02_05_Begin Excel exercise file. Let's take a look at how this works. So if we come over to the Tax Categories tab, you'll see that we have a variety of different tax categories. And of course, we have to use predefined tax categories put out by the IRS, and QuickBooks would let us go through and analyze this information based on particular categories as well. But Excel adds a level of versatility which is lacking in QuickBooks. So what we've done is create our own different expense categories. For ABC Company, they have bank fees, contractors, fees to franchisor, insurance…
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
-
-
-
-
-