730 Tax Deductions Tracking Using Account Classes Method Medical Costs

QuickBooks Desktop Pro-Personal Tax Tracking Tricks Classes Account Method - Using Classes To Categorize Personal Tax Items
11 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.54
List Price:  €92.77
You save:  €74.23
£15.95
List Price:  £79.80
You save:  £63.84
CA$27.34
List Price:  CA$136.81
You save:  CA$109.46
A$30.24
List Price:  A$151.28
You save:  A$121.04
S$27.05
List Price:  S$135.34
You save:  S$108.28
HK$156.20
List Price:  HK$781.41
You save:  HK$625.21
CHF 18.12
List Price:  CHF 90.67
You save:  CHF 72.55
NOK kr216.26
List Price:  NOK kr1,081.87
You save:  NOK kr865.61
DKK kr138.36
List Price:  DKK kr692.16
You save:  DKK kr553.80
NZ$33.22
List Price:  NZ$166.19
You save:  NZ$132.97
د.إ73.42
List Price:  د.إ367.29
You save:  د.إ293.87
৳2,195.13
List Price:  ৳10,981.15
You save:  ৳8,786.02
₹1,669.38
List Price:  ₹8,351.08
You save:  ₹6,681.70
RM94.73
List Price:  RM473.90
You save:  RM379.16
₦28,376.40
List Price:  ₦141,953
You save:  ₦113,576.59
₨5,547.19
List Price:  ₨27,749.85
You save:  ₨22,202.65
฿733.83
List Price:  ฿3,671.03
You save:  ฿2,937.19
₺644.89
List Price:  ₺3,226.08
You save:  ₺2,581.18
B$102.79
List Price:  B$514.24
You save:  B$411.44
R367.57
List Price:  R1,838.78
You save:  R1,471.21
Лв36.27
List Price:  Лв181.47
You save:  Лв145.19
₩27,303.52
List Price:  ₩136,585.93
You save:  ₩109,282.40
₪74.45
List Price:  ₪372.47
You save:  ₪298.01
₱1,148.55
List Price:  ₱5,745.64
You save:  ₱4,597.09
¥3,113.38
List Price:  ¥15,574.70
You save:  ¥12,461.31
MX$334.98
List Price:  MX$1,675.77
You save:  MX$1,340.78
QR72.77
List Price:  QR364.05
You save:  QR291.27
P272.32
List Price:  P1,362.30
You save:  P1,089.97
KSh2,647.79
List Price:  KSh13,245.57
You save:  KSh10,597.78
E£947.48
List Price:  E£4,739.77
You save:  E£3,792.28
ብር1,143.07
List Price:  ብር5,718.23
You save:  ብር4,575.16
Kz16,718.70
List Price:  Kz83,635.33
You save:  Kz66,916.63
CLP$18,490.75
List Price:  CLP$92,500
You save:  CLP$74,009.25
CN¥144.42
List Price:  CN¥722.47
You save:  CN¥578.04
RD$1,157.70
List Price:  RD$5,791.41
You save:  RD$4,633.71
DA2,689.96
List Price:  DA13,456.57
You save:  DA10,766.60
FJ$45.39
List Price:  FJ$227.07
You save:  FJ$181.67
Q155.34
List Price:  Q777.13
You save:  Q621.78
GY$4,167.36
List Price:  GY$20,847.26
You save:  GY$16,679.89
ISK kr2,788
List Price:  ISK kr13,947
You save:  ISK kr11,158.99
DH200.18
List Price:  DH1,001.41
You save:  DH801.23
L354.81
List Price:  L1,774.94
You save:  L1,420.13
ден1,142.62
List Price:  ден5,715.96
You save:  ден4,573.34
MOP$160.27
List Price:  MOP$801.75
You save:  MOP$641.48
N$368.60
List Price:  N$1,843.95
You save:  N$1,475.34
C$732.86
List Price:  C$3,666.13
You save:  C$2,933.27
रु2,661.19
List Price:  रु13,312.64
You save:  रु10,651.44
S/74.11
List Price:  S/370.77
You save:  S/296.65
K77.19
List Price:  K386.18
You save:  K308.98
SAR74.97
List Price:  SAR375.05
You save:  SAR300.07
ZK544.96
List Price:  ZK2,726.18
You save:  ZK2,181.21
L92.28
List Price:  L461.67
You save:  L369.38
Kč462.52
List Price:  Kč2,313.79
You save:  Kč1,851.27
Ft7,192.94
List Price:  Ft35,982.70
You save:  Ft28,789.76
SEK kr216.61
List Price:  SEK kr1,083.63
You save:  SEK kr867.01
ARS$17,640.68
List Price:  ARS$88,247.55
You save:  ARS$70,606.86
Bs138.15
List Price:  Bs691.13
You save:  Bs552.98
COP$77,631.58
List Price:  COP$388,352.10
You save:  COP$310,720.51
₡10,189.93
List Price:  ₡50,975.17
You save:  ₡40,785.23
L490.79
List Price:  L2,455.18
You save:  L1,964.39
₲149,579.10
List Price:  ₲748,269.66
You save:  ₲598,690.56
$U768.53
List Price:  $U3,844.57
You save:  $U3,076.04
zł79.72
List Price:  zł398.80
You save:  zł319.08
Already have an account? Log In

Transcript

In the presentation, we will discuss a method for tracking tax deductions related to medical costs within our business account using a classes method within QuickBooks. Here we are in the home tab, we currently have the open windows open, you can open the open windows by going to the view drop down and selecting the open windows list. We're not going to open up the check register by going to the banking drop down and go into the US register item. And we're going to have the checking account that being the register we want. So far, we have an entering data directly from our bank statement into our check register add in these items related to tax deductions as we go. Go into our bank statement.

This is the data that we have been inputting our bookkeeping process just entering this data directly into the bank statement. We left off last time entering the we just entered Verizon is in there. And now we're going to add the new items. So we're going to add A normal type of item Edison, which is a utility company, and just keep on going as we normally would entering the transactions from our bank statement was paid out of the bank. Now we're going to enter it into our bookkeeping system. And then we're going to have the new item, the Blue Cross, and the doctor, he and this is kind of the Rite Aid.

These are going to be medical type expenses that we want to break out, not because they're deductible for the business, but because we want to record them and track them in case their deductible in some other area. Again, is it deductible, you want to ask your tax preparer, but if it's something that you've been tracking that you need to provide at the end of the year, then this is a method that we're looking to track them in a place where we can easily put all this information together in therefore, we have consciously made the change to pay medical expenses out of our business account, so that we can assign them but assign them to a special personal account and account that we then label And get a class to that we can track in. So we're going to first do our normal account the Edison Electric.

So we'll go back up top. And we're going to say that this happened on 316. So, March 16 2019, the year we're working on the account, the cheque number 1035. And then we're just going to type in Edison, it should populate for us because we paid them before. And then if we select a tab, it's already going to the utilities expense. That's where we want it because Edison's Electric Company, and if we select the drop down, then it's an expense.

So everything looks good. This is just normal type of transaction that we have entering that in, then we're going to go back and we're going to say, Okay, now we have two Blue Cross, which we hadn't put there last month. And we're consciously putting them there this month, because we are adding those and we want to track them and be able to provide that information to our tax preparer, although it's not business related. So we're going to enter that into our system and assign a new account from It. So we're going to go into our QuickBooks file and that happened on the 19th. So we're going to say the 19th 1030.

Actually, I have to check numbers that have the same again, sorry about that. But it shouldn't affect what we're doing here. So we're going to say Blue Cross is the new one. Blue Cross. Again, this isn't a business related expense, we're assuming that we're paying this. And it's something we have to track outside for tax purposes, but not business related.

And we'll say tab. And again, this isn't tax advice, obviously, you could you have to consult to see whether or not that would be the case, because medical expenses can be one of those items, where depends on the entity, and what type of system we have set up. So in any case, this is what we're doing here. We're saying this is not a business expense, but we want to track it. So we're going to say quick add, and we're going to say it's a vendor, and we want to add the amount of 500. And then we need to have an A Count, I've just I've just pasted this in here.

So personal deductions, medical insurance. So we're going to clearly define and say, Hey, this is something that shouldn't be on the business side, but on the personal side, and we're going to label it as medical insurance so that we can then track it. Once that is set up, I'm going to select the split, and then it's going to tell me Do I want to set it up? Or I can just hit Tab? It's gonna say, do you want to set it up? We're going to say, Yes, please set it up.

I'm paraphrasing what it's saying personal deductions is not in the account list set up. That's what I'm asking if we want to set it up. So here it is the personal deduction, that's what we want medical insurance to kind of cut off the end of the name there. That's okay. That should be enough. That should be enough.

Maybe we should just say insurance like that. And then we'll say Save and Close. And then we're going to split so that we can have the classes over here. So we're going to assign that then to the tax deduction, personal area. So that's the one we want and we're going to go ahead And then record that we're going to keep the check number. And there we have that.

Okay, so then we've done the Blue Cross back to our bank statement here. So jumped over there kind of quick, we're back on our bank statement. I'm going to cross that off. Now the next one, we went to Dr. e. This is our, this is our doctor. Their name is Dr. e. And so we and we paid for a doctor visit 195. So same kind of thing.

It's not going to be it's personal. It's not business related, but we want to track it because we may our tax preparer may want it. So we're going to say 315 1036 and we're going to say this is for Dr. E, Dr. E and set that up quick setup. We will have it as a vendor here and Dr. E, we pay the 195 and then we're going to select the account. Once again, it's a new account, we could put it into like a group that has all medical type of stuff in it, but it's probably best to break out the insurance and the non insurance. I'm just going to put medical So we'll have the same personal deductions, but this time just medical costs.

And I'm going to include in here, the doctor visits and any kind of like prescription drugs that we have or anything like that. We could break out the prescription drugs and medical visits, which might even be nicer for the tax preparer. But we're, we're here we're going to break out the insurance that we pay, and then everything else medical expenses and costs, we can then go into the detail and see what those are and kind of break them out later. As long as we don't have too much in any particular account. I hit tab and that means it's, it's asking if we want to set up again, I'm paraphrasing, I'm gonna say yes, please set that up. It's going to be an expense type account.

That's all we need. So we're going to say Save and Close. And then we're going to go to the splits item down here so we can add the class to it. And then there is the class we're going to say class, and I want to make that a tax personal class area, and then we're going to record that one. All right, one more, one more. We found Dr. E doctor he has been put in place and now we've got right a drugstore paid $37 assuming that's going to be a prescription drug that we want to track now, because it might possibly be a deduction, clearly not a business deduction, but possibly personal deduction.

So we're going to go back over here and we're going to say that that's going to happen on 320. And check number 1039 1039. And we're going to pay I'm going to type the sense a new one, right? A A ID, drug store, tab, quick add, we're going to add that vendor, that's what we want. We paid $37 for drugs. And we're going to put that into I'm going to make this into the same one we set up which is prescription drugs, you can't see it well, maybe be able to see it down there.

But first of all deduction, medical costs, so we're going to put that in the same area. And then we need to assign the class to it. But this time, I'm going to say, Well, what if I forgot what if I didn't assign the class? No big deal, we'll see why. We're going to say okay. And then let's take a look at our reports, we're going to go to the reports drop down up top, we're going to go to company and financial, then go down to our profit loss by class, changing the date range to Oh 10119 1230 119, January 1 to December 31 2019, the year we are working on, we then scroll down and we've got our medical costs here and make this I'm going to make this a little bit wider so we can see it.

And so there's our medical costs. And here's our medical insurance. We can see also that that 37 is in the wrong area. It's unclassified, which is normal business, it's not over here, easily seen, it's clear the fact that it's under personal that it should be envy this column. So what we need to do is just double click on that item Double click on it again, and then assign the proper class, which will be the tax deduction personal. And then save and close, save the changes close out this screen.

And there has been removed and changed and gone back over here. If we double click on this item, then we can see our detailed transaction which might be good, especially in this case to give to the tax preparer. Because they might say, hey, well, maybe the drugs aren't deductible and the doctor visit is deductible or whatever I'm not we're not getting the tax stuff here or you know, the planning phase of it, we're just saying this are things we think might be deductible, we're trying to put them into the categories we can, if we have more than one thing that that might be deductible in one category, then that means that it's more necessary to provide the detail which we could then go in there and kind of figure out what is in there in which is the duck which is not, you don't want to put too many things.

I want to Count because sorting through too many things, of course, takes a lot of time. That's why we're breaking it out into categories. But if you have a few different things in one category, such as the doctor visits and all the prescription drugs, then we might be able to sort that out if necessary at the end of the year. So that's going to be this one, we found the Rite Aid. Next time, we're going to be moving on to the IRA, which is a another item that we may may be something that could be deductible, and it might be something that we're not doing in the business, meaning some type of retirement plans are often going to be deductible. And again, it's one of those things that a business could set up a retirement plan like a 401k or an IRA or simple IRA or Roth, you know, or they might have something outside of the system that they want to track they know they need to give to the tax preparer.

We will assume this is outside of the bookkeeping, something that we need to track but not in the business next time.

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.