740 Tax Deductions Tracking Using Account Classes Method Subaccount

QuickBooks Desktop Pro-Personal Tax Tracking Tricks Classes Account Method - Using Classes To Categorize Personal Tax Items
12 minutes
Share the link to this page
Copied
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$19.99
List Price:  $100
You save:  $80.01
€18.99
List Price:  €95.04
You save:  €76.04
£15.82
List Price:  £79.16
You save:  £63.33
CA$27.92
List Price:  CA$139.69
You save:  CA$111.76
A$30.69
List Price:  A$153.56
You save:  A$122.87
S$26.86
List Price:  S$134.41
You save:  S$107.54
HK$155.58
List Price:  HK$778.30
You save:  HK$622.72
CHF 17.66
List Price:  CHF 88.37
You save:  CHF 70.70
NOK kr220.95
List Price:  NOK kr1,105.32
You save:  NOK kr884.36
DKK kr141.71
List Price:  DKK kr708.94
You save:  DKK kr567.22
NZ$34.07
List Price:  NZ$170.47
You save:  NZ$136.39
د.إ73.42
List Price:  د.إ367.30
You save:  د.إ293.87
৳2,390.84
List Price:  ৳11,960.21
You save:  ৳9,569.36
₹1,689.80
List Price:  ₹8,453.24
You save:  ₹6,763.44
RM89.25
List Price:  RM446.50
You save:  RM357.24
₦33,594.99
List Price:  ₦168,059
You save:  ₦134,464
₨5,561.75
List Price:  ₨27,822.66
You save:  ₨22,260.91
฿693.03
List Price:  ฿3,466.90
You save:  ฿2,773.86
₺690.69
List Price:  ₺3,455.18
You save:  ₺2,764.49
B$116.15
List Price:  B$581.05
You save:  B$464.89
R362.32
List Price:  R1,812.55
You save:  R1,450.22
Лв37.15
List Price:  Лв185.87
You save:  Лв148.71
₩28,010.16
List Price:  ₩140,120.89
You save:  ₩112,110.72
₪74.65
List Price:  ₪373.45
You save:  ₪298.79
₱1,180.68
List Price:  ₱5,906.40
You save:  ₱4,725.71
¥3,086.50
List Price:  ¥15,440.26
You save:  ¥12,353.75
MX$406.68
List Price:  MX$2,034.45
You save:  MX$1,627.76
QR72.95
List Price:  QR364.97
You save:  QR292.01
P273.31
List Price:  P1,367.26
You save:  P1,093.94
KSh2,583.70
List Price:  KSh12,925
You save:  KSh10,341.29
E£992.51
List Price:  E£4,965.06
You save:  E£3,972.54
ብር2,494.39
List Price:  ብር12,478.21
You save:  ብር9,983.82
Kz18,237.42
List Price:  Kz91,232.73
You save:  Kz72,995.30
CLP$19,466.66
List Price:  CLP$97,382
You save:  CLP$77,915.33
CN¥144.76
List Price:  CN¥724.17
You save:  CN¥579.40
RD$1,206.68
List Price:  RD$6,036.43
You save:  RD$4,829.75
DA2,670.46
List Price:  DA13,358.97
You save:  DA10,688.51
FJ$45.38
List Price:  FJ$227.02
You save:  FJ$181.63
Q154.44
List Price:  Q772.62
You save:  Q618.18
GY$4,185.73
List Price:  GY$20,939.14
You save:  GY$16,753.40
ISK kr2,764.61
List Price:  ISK kr13,830
You save:  ISK kr11,065.38
DH199.86
List Price:  DH999.82
You save:  DH799.96
L364.01
List Price:  L1,821
You save:  L1,456.98
ден1,169.14
List Price:  ден5,848.66
You save:  ден4,679.51
MOP$160.40
List Price:  MOP$802.41
You save:  MOP$642.01
N$362.87
List Price:  N$1,815.29
You save:  N$1,452.41
C$736.22
List Price:  C$3,682.94
You save:  C$2,946.72
रु2,700.48
List Price:  रु13,509.16
You save:  रु10,808.68
S/75.92
List Price:  S/379.81
You save:  S/303.88
K80.54
List Price:  K402.90
You save:  K322.36
SAR75.04
List Price:  SAR375.42
You save:  SAR300.37
ZK553.68
List Price:  ZK2,769.79
You save:  ZK2,216.11
L94.55
List Price:  L472.99
You save:  L378.43
Kč481.37
List Price:  Kč2,408.10
You save:  Kč1,926.72
Ft7,812.66
List Price:  Ft39,082.89
You save:  Ft31,270.22
SEK kr220.49
List Price:  SEK kr1,103.01
You save:  SEK kr882.51
ARS$20,044.61
List Price:  ARS$100,273.19
You save:  ARS$80,228.57
Bs138.54
List Price:  Bs693.07
You save:  Bs554.52
COP$88,227.35
List Price:  COP$441,357.44
You save:  COP$353,130.08
₡10,159.94
List Price:  ₡50,825.14
You save:  ₡40,665.20
L505.57
List Price:  L2,529.12
You save:  L2,023.55
₲156,683.96
List Price:  ₲783,811.71
You save:  ₲627,127.75
$U855.26
List Price:  $U4,278.48
You save:  $U3,423.21
zł82.60
List Price:  zł413.23
You save:  zł330.63
Already have an account? Log In

Transcript

In this presentation, we will discuss the use of sub accounts within our tax deductions tracking method using the classes method within QuickBooks. Here we are on the homepage, we currently have the open windows open. In order to open the open windows, we go to the View drop down and select the open windows list. We're going to go now to our reports for the profit and loss and take a look at what it looks like this time and how we can adjust that that look with the use of sub accounts. So we'll go into the reports drop down Up top company and financial we're looking for the profit and loss by class profit and loss by class. And we're going to change the date range once again from Oh 10119 to 1230 119.

That's January 1 to December 31 2019. The year we are working on and if we scroll down we have our items that are going to be personal items that are tax deductible. We put them into this separate column the tax deductions personal column And if we start each of those types of accounts with the name, personal deduction, and we don't have account numbers as we do here, then by alphabetical order, it will group these all together. So that's kind of nice in and of itself. So we don't really have to then put in some other kind of special area to have sub accounts because it's already kind of listed out just by alphabetical order in that format. However, we may want to we may want to say that I would like to group these together under a sub account.

So that's what we'll do now we'll group these together, we'll make a master account for personal deductions and group these as sub accounts to it. To do that, we're going to go back to our chart of accounts. So we're going to go to the lists drop down, we're going to look at the chart of accounts Chart of Accounts, and we're going to add a new account which is going to be like our master account, the master account, we're going to go to account drop up down at the bottom where drops up rises up, I would say and we're going to say new account new. And it's going to be also an expense type of account. Continue. And we will call that I'm just going to call it personal deduction, personal deductions, that'd be an S, we might want an S there.

And that's where that's what it's gonna be, that's going to be our master account. We're going to set that up and then every other account that we're just going to change it and make them sub accounts of the master account. So we're going to say Save and Close. And then we'll just go into all these sub accounts, and we'll we'll make them subsidiary to the master. So I'm going to right click on this one, and we'll edit the account. And we're just going to make it a subsidiary of the personal deductions, personal deductions account there.

That's what we're going to do and just say, OK, save and close, same process for all of these personal deductions. So we'll right click on the one For a child deduction, edit that account, you cannot double click on it by the way, or else it'll go into a register. And that's not what we want. We're going to make this a sub account of the personal deductions, that website. So if I type in PERS, and then I can scroll down and find that one little bit faster if you want to go a little bit faster. And then here's the personal deductions for the college costs.

Remember those, we're going to edit that account, add the sub account, personal deductions, that's the one we want and save and close again. Then we're going to go down to the IRA, right click on it, we're going to edit that account. And we'll change it to the sub account and we're going to call this personal and we want the personal deductions again, and save and close. Then we're going to go to the medical medication. Right click What is that? Yeah, that's the one I want.

Right click and edit. And we want to make that as some of the personal deductions, that's the one and then we'll go to the medical insurance, right click, edit that account, we're going to make it a sub account of the personals. This is great. And then say Save and Close. We get to do this one last time, and then we have to stop. That's all we got.

We're going to right click on it and go to the Edit account, sub account personal that's the one and Save and Close. Now let's see what it has done to our financial statements by going into the open windows open items and go into the profit and loss by class. We will update and refresh the window as prompted. And there we have it so now we can see that it's it's broken out. And we have this personal deductions and the nice thing about that That, you know, we can now minimize that. And we have less distraction over here.

So for example, if we wanted to just look at the unclassified the business kind of section, we could say, Okay, now we've got this, we can, we can at least zoom into one distracting number, we have one line, that's a distraction instead of that whole big lump of things that were kind of distracting looking. So that's one advantage. And of course, if we were to see it, and just if we want to make a normal profit loss by going to reports up top company and financial and a profit loss, this is a 10119 to 1230 119. We still have that case. So we still have this kind of things that are problem, because it says January through December, by the way, because these are going to be not really business related. So that's why we need to run it by class.

So I can minimize these and at least I can see Okay, that's a lump number that's kind of not really belonging in terms of business expenses on this report, and we can go back to this profit loss. And this is where they really should be. So we'll we'll discuss some different ways that we could format this profit and loss as we have these different types of classes as well. Next thing we want to do Joe, though, just for the sub accounts, you might say, hey, it'd be nice if the sub accounts were like at the bottom, maybe I want them at the bottom. And and then I don't have to see him up there. So so we could do that.

We could go to the profit add to the chart of accounts. And we can go to this personal deductions, right click and edit the personal deductions, edit account. Now one way we could do it is we can use alphabetical order and say that I want to just say I'm going to call this z personal, you know, because Z's at the end So we'll say z, personal deductions, and then say Save and Close. And because there's no other account that starts with z, we should be able to go back to the profit and loss by class, refresh it, and that'll move it down to the bottom. So at least we can say, Okay, here's all the stuff and we moved it down to the bottom. So it not, the other option we could do is actually to put it down in like other income and other or other expenses were at the bottom.

And to do that, we'd have to actually change the account types. So we could try to go back over here and say that I want to right click on this and edit the account and put it not as an expense, but as an other expense. And that'll kind of put it way on the bottom. And if we save and close that, I can't do it until I until I change all the sub accounts. So to do that, let's do that really quickly. I can call This back out.

And I could change all these sub accounts by right clicking Edit. And I'm gonna, I'm gonna unsubsidised it right now, and then change this to other expense. Do that I'm actually gonna delete the whole sub account, and then on sub account and then change it to other expense. So then I'm going to save that. I'm going to do this all the way through, I'm going to go to childcare, right click, we'll edit that one. And then I'm going to delete the sub account first unsub on sub account it and put it in as other expense.

Okay, I'm gonna do this kind of quickly. And then I'm going to right click and edit this one. We're going to delete this on sub account, and then make it an other expense type of account rather than just an expense. And then we'll go to this item, right click Edit Delete, remove the sub account, make it an other Expense Type item. Save and Close and this item right click Edit will make it a delete this item, remove the sub account and then other expense, Save and Close. And then we'll take this item right click Edit.

We'll delete this remove the sub account and other expense Save and Close. And then one more time, right click Edit, will will remove the sub account and then other expense Save and Close. Now before I change the actual master account, if we just go to the profit loss and see what happens here, we can go back in and we can see now that it's listed all into the other expenses at the bottom, which could be nice because then we got ordinary income, and then all the other stuff is broken out by taxable deduction and in the other deductions category in the bottom, even if we don't put it into a sub account, but we may have some other items and other expenses as well like interest expense sometime it's down there. So then we could go back over here and add the sub account by changing the sub account and saying that we want this to be edit.

Now other expenses and other Expense Type to match. So now that's going to be an other Expense Type. And then we could go back in here once again, and edit these two, the same account but now that is an other account. It'll now allow me to put this as a subcategory the other account. So then again, if we went through all of the edits, we want to make this a sub account of the Z personal deductions And okay, and then we went into here, edit. And we want to make this a sub account of the Z account.

And okay, and I'll just continue with these show you the result. So I've done that same process to all of these now and now made them a sub account of the personal deductions with a Z. And that should take it as far down on the income statement as we could basically go. So if we go back to the profit and loss by class then and say yes, then we could say, Okay, if we go to the bottom, it's going to be under the sub accounts and all the way in the other income, other expenses. So that's just another just kind of some grouping options that we can set these accounts up by, we still kind of need this this separate class, because if we were to see it in a profit loss, I'm going to go back to the profit and loss that doesn't have classes.

Then you could still see it's kind of broken down at the bottom and we could get to net ordinary income and this way, and then group all of our other stuff under And as long as we don't use any other expense categories, then that might be a nice way to go. However, you know, oftentimes, we might use other types of expenses for some reason other than just these personal expenses. But if not, that's another way that we can we can group this and it could make it a little bit easier for us to see net income here and then see everything else that we put down here that's personal, basically deductions without even needing the classes. So just a few formatting options within this method.

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.