535 Tax Deductions Tracking Equity Draws Account Method Personal State Tax Costs

QuickBooks Desktop Pro-Personal Tax Tracking Tricks Equity Method - Using Draws Accounts To Categorize Personal Tax Items
10 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.73
List Price:  €93.71
You save:  €74.98
£16.02
List Price:  £80.17
You save:  £64.15
CA$27.50
List Price:  CA$137.58
You save:  CA$110.07
A$31.02
List Price:  A$155.19
You save:  A$124.16
S$27.18
List Price:  S$135.99
You save:  S$108.80
HK$156.54
List Price:  HK$783.09
You save:  HK$626.55
CHF 18.17
List Price:  CHF 90.90
You save:  CHF 72.73
NOK kr220.14
List Price:  NOK kr1,101.27
You save:  NOK kr881.13
DKK kr139.78
List Price:  DKK kr699.28
You save:  DKK kr559.49
NZ$33.72
List Price:  NZ$168.72
You save:  NZ$134.99
د.إ73.41
List Price:  د.إ367.25
You save:  د.إ293.83
৳2,187.62
List Price:  ৳10,943.61
You save:  ৳8,755.98
₹1,669.99
List Price:  ₹8,354.15
You save:  ₹6,684.15
RM95.62
List Price:  RM478.35
You save:  RM382.72
₦25,927.03
List Price:  ₦129,700
You save:  ₦103,772.97
₨5,548.62
List Price:  ₨27,757.02
You save:  ₨22,208.39
฿735.01
List Price:  ฿3,676.92
You save:  ฿2,941.90
₺649.83
List Price:  ₺3,250.80
You save:  ₺2,600.97
B$104.61
List Price:  B$523.34
You save:  B$418.72
R380.58
List Price:  R1,903.85
You save:  R1,523.27
Лв36.61
List Price:  Лв183.17
You save:  Лв146.55
₩27,481.84
List Price:  ₩137,477.95
You save:  ₩109,996.10
₪75.76
List Price:  ₪378.99
You save:  ₪303.23
₱1,143.72
List Price:  ₱5,721.46
You save:  ₱4,577.74
¥3,086.90
List Price:  ¥15,442.26
You save:  ¥12,355.35
MX$339.08
List Price:  MX$1,696.28
You save:  MX$1,357.19
QR72.72
List Price:  QR363.82
You save:  QR291.09
P275.49
List Price:  P1,378.16
You save:  P1,102.66
KSh2,658.67
List Price:  KSh13,300
You save:  KSh10,641.33
E£969.62
List Price:  E£4,850.57
You save:  E£3,880.94
ብር1,134.14
List Price:  ብር5,673.58
You save:  ብር4,539.43
Kz16,741.62
List Price:  Kz83,750
You save:  Kz67,008.37
CLP$19,568.81
List Price:  CLP$97,893
You save:  CLP$78,324.18
CN¥144.70
List Price:  CN¥723.91
You save:  CN¥579.20
RD$1,178.24
List Price:  RD$5,894.15
You save:  RD$4,715.90
DA2,688.36
List Price:  DA13,448.55
You save:  DA10,760.19
FJ$45.39
List Price:  FJ$227.07
You save:  FJ$181.67
Q155.02
List Price:  Q775.51
You save:  Q620.49
GY$4,173.27
List Price:  GY$20,876.83
You save:  GY$16,703.55
ISK kr2,815.79
List Price:  ISK kr14,086
You save:  ISK kr11,270.20
DH202.31
List Price:  DH1,012.08
You save:  DH809.77
L357.82
List Price:  L1,790.03
You save:  L1,432.20
ден1,153
List Price:  ден5,767.92
You save:  ден4,614.91
MOP$160.77
List Price:  MOP$804.25
You save:  MOP$643.48
N$379.41
List Price:  N$1,898.03
You save:  N$1,518.61
C$733.65
List Price:  C$3,670.10
You save:  C$2,936.44
रु2,668.24
List Price:  रु13,347.92
You save:  रु10,679.67
S/74.99
List Price:  S/375.16
You save:  S/300.17
K75.76
List Price:  K379
You save:  K303.24
SAR74.98
List Price:  SAR375.12
You save:  SAR300.13
ZK503.78
List Price:  ZK2,520.20
You save:  ZK2,016.41
L93.19
List Price:  L466.22
You save:  L373.02
Kč473.61
List Price:  Kč2,369.25
You save:  Kč1,895.63
Ft7,380.05
List Price:  Ft36,918.72
You save:  Ft29,538.66
SEK kr217.75
List Price:  SEK kr1,089.33
You save:  SEK kr871.57
ARS$17,375.81
List Price:  ARS$86,922.55
You save:  ARS$69,546.73
Bs138.03
List Price:  Bs690.52
You save:  Bs552.48
COP$78,194.86
List Price:  COP$391,169.92
You save:  COP$312,975.05
₡9,987.59
List Price:  ₡49,962.95
You save:  ₡39,975.36
L492.09
List Price:  L2,461.69
You save:  L1,969.59
₲147,514.52
List Price:  ₲737,941.59
You save:  ₲590,427.06
$U777.64
List Price:  $U3,890.17
You save:  $U3,112.53
zł81.14
List Price:  zł405.91
You save:  zł324.77
Already have an account? Log In

Transcript

In this presentation, we will discuss a method for tracking deductions related to personal state taxes. I'm thinking here property taxes within our business account within QuickBooks using what I'm calling an equity method. Here we are in the homepage, we currently have the open windows open. In order to open the open windows, you go to the View, drop down and select the open windows list. We're not going to enter this information for property taxes, we're going to assume this is property taxes. It could be the same for any type of state tax that we believe may be deductible, but which is not a normal business expense.

Our goal here to track them out of the business checking account, and in our QuickBooks account, not as a business expense for QuickBooks for the business but as an equity account so that we can track them and give this information to our tax preparer. Note that if we're talking about property tax say on our home, this might Do something that's deductible on the federal tax return and might need to be tracked. Also, it might be tracked, however, through the mortgage company. So if we pay mortgage and the mortgage company actually handles our property taxes as well, then it might be the case that they're going to actually report that at the end of the year, we may not need to track it. If if the if it's going to be reported on the year end statements along with the mortgage interest. So be aware of that.

If however, that's not the case, and we're paying it outside of the mortgage company, they're not going to report it. This is one method we could use any other state taxes that might be deductible that we haven't even if we haven't a question about it, we might say who maybe I should put it in here, maybe like the state DMV taxes for motor vehicle taxes or any type of other local taxes we might have. We may want to list them out and give a report to our tax preparer and ask them about whether or not these types of items would be something deductible even though they're not business expenses. So what we're We're going to do then is we're going to take our bank statement, we've consciously paid these items that we think are deductible, even though they're not business expenses out of the business checking account.

And here's our bank statement, which would then of course, reflect all payments made out of it. We've been recording all the payments out of this entering them directly into our QuickBooks check register, we are now going to go down and we're going to enter these items and continue just entering this information out. We've written checks, this would be the same if we didn't write checks, we have electronic transfers or anything like that electronic payments. As long as it came out of our checking account, it'll be on the bank statement. And if we can find the vendor that we paid, then we can decide where what account we want it to go to note that if you're following along, we have not entered data for this E trade IRA yet, we're going to pick that one up when we do the bank reconciliation. So we'll do the bank reconciliation.

We will notice as we do the bank reconciliation that we have not yet picked this one up and we will into that went up in a similar fashion, noting that it'll be a similar format that we'll have to record it as a draws account, this being something that we're going to say is not going to be a business business related deduction for the IRA. But something we still want to track for tax purposes. And we will do that at that time when we do the bank reconciliation at the end of this section. So we're going to continue with this, we're going to enter these two first, just to give an example of kind of normal checks. These two are going to be employee payroll checks, and we're just going to enter the net check as if this was being done by someone like ADP or paychecks.

And we're just entering this information into our system to get the net check in the system. So just to give an example of normal kind of what we would think of business expenses, and then we'll go up here to the state tax, which is property tax, which I'm assuming this is on our home, not on the business, and therefore it's something that the tax preparer may want at year end, but not so Something that is going to be a business expense on the schedule, see the business return if we're if we're a sole proprietor. So that's what we'll do here, we're going to enter these two first, just to show what, you know, a normal type expense will show up on an income or Expense Type account. So let's do that. First. Here we go.

Here is our QuickBooks file. We're going to select the banking drop down and go to use register. So we're in use register, we're going to use the checking account and say, okay, and we're going to say that this happened on the 31st. So I'm going to say the 31st. And we're going to enter these two payroll paychecks first. And so that's going to be 1043.

This was to Adam Hamilton. Adam Hamilton, we paid 3539. That's the net check. Again, we're assuming this is a payroll check. So we're going to put this in payroll as payroll expenses. So the point is, it's a normal type of expense.

What we are recording here note, we're not running through payroll through the process of QuickBooks. We're assuming was done by a separate outside ADP or outside payroll provider and we're entering the net check here. And we're not entering the whole gross check. So just note, we're entering just to give an example of a normal basically business expense, we're not going to get into payroll here. So that's going to be that item, we're going to say, Okay, and then we'll do the same thing for Erica, which is our other employee, we're going to go highlight that. And Eric as our other employee, we're going to say that's going to be a 1045 was the check.

We're going to say Erica Robinson 630. We're going to put that into payroll. Now the reason payrolls not populating is because payroll is kind of a special account. So typically, QuickBooks wants us to run through the payroll process in order to record payroll to purchase payroll and run through the payroll process. That's why it's not populating automatically when we put the employee in place as it has been with other vendors. For our purposes here, we just want to note that it is an issue stance kind of like a normal type of expense, something that should be long on the income statement as opposed to the property taxes on our personal property that we will do next time.

So we're going to go back, we're going to mark this off, we've completed that one. Now we're going to go in into the state taxes, this being our item that we're going to practice all of this being an item that we think is going to be deductible, possibly, but not as a business expense, and therefore something we want to track on our business account, because that's where we're good at tracking things, but not put it on as an expense, but in this case, as a draw. So this is going to be the state tax on 325. We'll go back to QuickBooks and we're going to say this is on 325. I'm going back down to the 25th. And the check numbers back down to the 1042.

And this is going to be state taxes profit. Now this is just a generic vendor name, obviously would be the state tax collector that we would be paying here. But I'm going to call it state tax, and we're going to call it property tax, property tax and tab, quick add vendor. 346 is the amount we're going to have. And the point is, we're not going to put it into an expense because it's not a business related tax, I'm assuming this is on our home, a personal expense. So I'm going to set up a draws account and call it state and local taxes.

So I'm going to anything that's a state and local tax that I think might be deductible, I want to track it, pay it out of this account. So I will remind myself to track it in the accounts that I'm good at tracking on the business accounts, but put it to the this draws account not affecting the income statement. Therefore allowing me to provide this to the tax preparer, at the end of the year as a report to ask if we can deduct these items. So we're gonna say set up and we're going to make it not an expense. That's The key it's going to be an equity account. So we'll make it to an equity account and Save and Close.

And we should probably put a memo I'm not however, I would recommend doing so though. And then we're going to say enter, then we're going to go to our report. So let's go to the reports drop down up top, company and to financial, we're going to go down to the balance sheet standard, changing the dates up top, and the customized reports. So we can get the range a 10119 to 1230 119. January through December 2019. I'm going to change the font just for the fun of it, and go to the font here.

11. Okay, yes. Okay. So check in account, we paid out of a checking account. If we double click on that, we go to the end, we see the three checks, we wrote, here's our two payroll checks that we entered normal business expense, here's our other two draws, they all came out of the checking account, that's fine. It's just that we want to make sure that they're going to the proper expense or draws account.

Other than that, so we're going to close this back out. Scrolling down here is our draws account. Notice we got a few of them now. So it gets a little convoluted down here on the equity section. But it shouldn't be too bad if we don't have too many of them for coding here to the state and local taxes. And there is our item if we double click on that, we'll have our state and local taxes which we can then provide to the tax preparer at the end of the year and we can list any taxes that are here, give them this report him or her this report and say, hey, are these deductible here are the items that we think might be deductible as state or local taxes, they're personal, they're not on the income statement.

They're not business related. We're gonna close this back out, and then see the other side of the income statement or see the other report Profit and Loss income statement reports drop down, company and financial, profit and loss. We're going to make this date range. Oh 10119 to 12. 30 119 that's January 1 2019 to December 31 2019, the year that we are working on. We'll note of course, that the payroll will be included in here we have the payroll expense for those two checks, we wrote those been business expenses.

Again, they're they're recorded net on the paycheck. So we're not talking about how to record payroll here. But payroll would be a normal business expense as opposed to the state taxes that we paid on our home, which is not a business expense and therefore not on the profit and loss of the business that we within us if we were a sole proprietor to create the schedule see it so note that it's not affecting then net income

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.