 QuickBooks Online 2022, subaccounts, categories for fixed assets or depreciable assets, property planting equipment, PP and E. Get ready because it's go time with QuickBooks Online 2022. Here we are in our Get Great Guitars practice file we set up with the 30 day free trial holding down control, scrolling up a bit to get to the 1-2-5% currently in the home page, otherwise known as the Get Things Done page. Change to the accounting view it is something that you can do by going to the cog up top and going down below to the switch to the accounting view we will be toggling back and forth between the two views either here or by jumping over to the sample company currently in the accounting view. Going back to the Get Great Guitars going to open a few tabs up top by right clicking on the tab up top duplicating it back to the tab to the left right clicking on it duplicating it again we plan on putting some reports in those tabs as they are thinking. Let's jump on over to the other company so that we can look at in the accounting view where the reports are located which are on the left side under reports. Let's go back on over to the business views second tab the thinking has been done the reports are located in the business view in the business overview section and then in the reports closing up the hamburger report ranging changing up top from 010122 to 123122 and run it go to the tab to the right tab to the right go back down to the business overview and in reports closing up the hamburger open up the other the other financial statement report the income statement the profit and loss the P&L range change from 010122 this time to 022822 and let's see if we can change this to see the months so we can see the month by month side by side running it so we've got Jan, Feb, Tote and the side by side view we're currently working on February I'm going to go back to the first tab and note that down below we're focusing in on our fixed asset area down below now when you first set up a company file then QuickBooks will give you some suggested items for the fixed assets which could also be called property planted equipment or P&E and this is a good area for us to kind of practice alternative things that we can have with regards to the demonstration or the reporting of items with the use of sub accounts now with the fixed assets note that you're typically going to be tracking the detail on them with your accountant and the fixed assets themselves are an accrual kind of component so you might be saying I'm on a cash basis I don't want to do any accrual stuff but sometimes it's unavoidable and this is typically one of those times because even if you paid cash for like a building and you paid 100,000 cash for it and it was a business office building you can't just expense it for tax purposes typically you got to put it on the books as an asset and then depreciate it for tax purposes so the tax code if nothing else will not allow you to stick to a cash basis at least with regards to property planted equipment typically now the tax code is typically going to be different than what you would depreciate if you were choosing to depreciate under a method not driven by the tax code so that depreciation method that you choose to use for bookkeeping versus tax is something that you might want to discuss of course with your accountant but that leads us to the issue of doing this accrual kind of component to do an accrual kind of component it's a little bit more work we got to put it on the books as an asset and then we've got to depreciate it over its useful life we've got to track the assets then on a sub ledger which you would think then quick books would have a sub ledger to track the assets by the actual assets that we have but oftentimes we don't do that within quick books because it might be easier to do oftentimes is with tax software because there could be multiple depreciation schedules one of which we're going to have to do is the tax depreciation schedules which is better or more easily maintained with the tax software and we don't really want to do two quite complicated depreciation schedules that are into separate systems so oftentimes will be dependent on the tax software on the accountant to help us out with the adjusting entries with relation to the depreciation expense that we might do periodically at the end of the month or the end of the year using depreciation schedules we get from tax software often from a CPA firm or tax office so that would mean if we're going to use something like that which might look something like this then this being this the external schedules that we're putting together periodically every year or as we buy and sell equipment in alignment and with the help from our CPA firm and note that the changes in the equipment are not too many typically in the year we don't have a whole lot of things we purchase and dispose of that are really large kind of items so and all the stuff that's in the past is already on the schedule so we're really once we get the system set up we're looking at the changes which isn't too bad to kind of kind of adjust as we go so so then the question is well if you're going to be working with this external report from your tax from your accountant you'd probably like to set up your categories of fixed assets that line up with the categories that they're going to put in place on their tax software making the adjusting entries as easy as possible so in other words you the easiest thing to do would say i'm just going to make one fixed asset account and then i'm going to make one accumulated depreciation account and one depreciation account and just have all of my fixed assets kind of combined together in that one category however most people break out their property plant into equipment into some standardized categories and these are the ones you probably want to get from your CPA firm in other words how are you going to group the stuff on the sub ledger if i look at their schedule and they use furniture and equipment and then machinery and equipment for their categorization which is somewhat standard then if i go into my assets and i've got furniture and equipment instead of furniture and fixtures it might be a little bit more difficult for me to line up category by category the items that i have versus the other depreciation schedule so what i'd like to do is clean this up i'm going to say i'm going to make my categories line up to the categories that are on the depreciation schedule and i i then have the question of do i want one accumulated depreciation account or do i want an accumulated depreciation account per category which would allow us to then give the cost per category and then the accumulated depreciation and the book value per category and do i want a depreciation expense account that is just one depreciation account or one per category so those are so what we're going to do is i'm going to align this to the categories we have here and then i'm also going to make another depreciation account two depreciation accounts to line up to the two categories we have here on our schedule i'm going to adjust my balances to match the balances that are on my sub schedule here as you can see these items happened in 2021 these items are what we're saying that we purchased in 2022 the total cost on this schedule is 98000 for the category of furniture and fixtures and note that we're listing out the actual items here the sofas the chairs the recliners and so on and so forth that's going to be on the sub schedule which you want your tax preparer to list out properly because if they just put one lump sum of furniture and equipment and then just some big amount of 98000 when you sell something in the future they're going to have run into a problem because you only sold one piece of the thing that's included in that 98000 dollar amount and it's going to be it's going to be a pain to try to figure out how you're going to record that and then the machinery and equipment we've got the two items that we're have down here for the 5000 so i want to just tie up to the totals this total and then this total and then have the related accumulated depreciation accounts okay so that's the goal i'm going to go back on over and go to the first tab i'm going to be working in the gl so i don't want to do that in the business view i want to go to the accounting view to do that personally i think you uh that would be the way to go and then i'm going to switch go into the cog up top and switch it on over to the accounting view so that the business view when i'm adding and uh changing accounts does not drive me crazy i don't want to go i don't want to be driven to crazy the business view tried to drive me to crazy and i'm getting out of the car i don't care if it's going like 60 miles an hour whatever i've got my own car i'm going to go into the reports actually no we're going to go into the accounting now on the left hand side and then we're in the chart of accounts closing up the hamburger and then we're going to scroll down we're looking at the fixed assets area so the fixed asset there's our furniture and equipment so let's first change the name on that to tie out to what the tax software says which is which is furniture and fixtures and then we got this 98 000 in there also note that if you talk to your tax professional they might they of course have to do the depreciation schedule for the tax purposes and then they might have to do some different if you want them to have a different schedule for the book so in this case i i've recorded this on the books for a straight line method and if you looked at the tax code the tax code i have down here with using double declining just to see some of the differences but note that the tax code will also have like 179 and bonus depreciation which has nothing to do with bookkeeping it's just that's just what the tax law whatever they negotiated on the tax law so it has whole whole different kind of reasons as to why you're depreciating different ways on the tax code so you might want to then have a different depreciation schedule for the books which makes more sense for bookkeeping although that's more work or you can just do the tax depreciation and just say i'm just going to record my books on a tax basis those are the some things to discuss with your accounting firm and see and see what what they think is best so i'm going to use this one here okay now let's do it then let's do it i'm going to adjust this one furniture and equipment i'm going to hit the drop down and edit it and let's just call it we want this one to be furniture and fixture furniture and fixture not furniture and equipment furniture and fixture and then save it scrolling back down it takes me back up i'm looking for the furniture and equipment so i've got that one so now i got furniture and fixture and then if they have one down here for equipment notice they got this sub account i don't really want all this detail usually in my account quickbooks is trying i think what they're trying to do is trying to guide you to say hey these are the kind of things that you might need to basically capitalize but it gets kind of messy if you have all this detail on your books when you know you can have that it's going to have to be in these categories for taxes so so i wouldn't i'm going to not use those tools machinery and equipment so this one's pretty close but i would just like to call it machinery and equipment again i think they're trying to imply in the name the kind of stuff you should put in there but what i would like to do is tie it to what is on the depreciation schedules because that's what i'm going to have to tie to when i i report this to my accountant and when i do the the schedules and record depreciation so i'm going to edit this one and let's just call this one machinery and equipment machinery and equipment i think i'm kind of messing up whether i should capitalize the second word or not but i'll keep it at that and then i'm going to save it and close it so there's our two accounts going down if i go back down now we've got the machinery and equipment and and the other account of the furniture the furniture and fixture so those are the two accounts i'm using all these other accounts i might i might just like make them inactive or remove them let's go ahead and do that i'll just make them inactive notice that you might even if you're not going to use them at all you might try to change the name so it doesn't show up in some of the drop down lists when you're trying to record something because sometimes they still show up in the drop down lists so i'm going to say like this one all of these all of these i'm going to get rid of all of the sub accounts i'm going to make it and and it might cause me a problem to make this one inactive because there's sub accounts to it but i'm going to try to make all these inactive let's just do it i'm going to say this is going to be inactive and then yes and then i got to scroll all the way back down to do it again so i'm looking at the furniture and equipment this phone thing under the long-term equipment i'm going to make that inactive just make some of them inactive so it's not just a ridiculous it's just ridiculous furniture let's make this one inactive and then scroll down and then we're going to say that we got the furniture this one where is it where did it go where did it go custom this one let's make that one inactive custom software app i mean it's kind of a specialty let's make that inactive and then we're going to go back down and then this one copiers let's make that inactive and then let's go back down rolling back down and then long-term let's make this one inactive and now here's i'm wondering if they're going to allow me to make this one inactive because those sub accounts are all inactive but they still have sub accounts so sometimes they get picky with the sub accounts so let's go back to the furniture and equipment and we got the land then this one i'm going to try to make this one inactive inactive it's a you are you sure yes it did because i made all the sub accounts inactive good good that's good okay so then i'm going to go down so now we got the furniture and equipment machinery and equipment much easier to find and now i'm going to make a sub account for each of them that's accumulated depreciation accumulated depreciation so i think we've got one right here accumulated depreciation i want that to tie up to the furniture and equipment no i'm not going to i'm not going to do any adjusting entry to match my accumulated depreciation here here's the prior period there's the 75 right there we'll do another adjustment in the adjusting entry process to record the depreciation but for now i just want to say this one i want to tie it to the furniture and equipment so i'm going to edit that let's edit that and say i want to say this is now accumulated depreciation it's quite long so sometimes uh and notice it says accumulated de depletion i should have recorded depreciation accumulated depreciation instead of depletion it's going to do the same thing but i'm going to say depreciation and then i'm going to say that this should be acc i'm just going to call it acc d pre so i'll sub us and then i'm going to i'm going to make that for now notice you you might want you could use the full word because i'm going to make it a subcategory of the furniture and fixture but i like to actually put the name that the accumulated depreciation is related to because that makes it a little bit easier to see it and that makes a really long words so but i like to be able to see it furniture when i when i hit the drop down and fixture to record something so i'm going to say furniture and fixture so there we there we have it i'm going to and it's a subcategory so i'm going to save that changing the type or detail that's okay it shouldn't delete anything i have in it it'll just change it to another area so there it is now i got the furniture and equipment and the acc d pre let's see what it looks like on the balance sheet let's check it out see what it looks like run it and if i go down to these fixed assets there's the furniture and equipment and now i've got this amount under it now this three one oh three is uh is not correct now according to my data here it should be 98 and 5000 so that 5000 i want to break out into its own category so i'm going to do an adjusting entry to do that so i'm going to go back to the first tab and i can do that by going to either the furniture and equipment i'm going to do it with a journal entry because there's there's no there's no form that that's designed specifically to do that so i'm going to go to either the furniture and equipment or to the machinery and equipment it might be easier to go to this one because it's an increase so sometimes it's easier to think about the increase so let's go into the register here this is the register for machinery and equipment which is going to go up by 5000 i'm going to make a new journal a new journal and this is going to happen let's say it happens on uh o two let's say the end of the month o 228 22 so it's kind of like an adjusting entry and this is going to be to adjust the fixed asset balances to match depreciation category categories on on the depreciation sketch on the depreciation schedule or something like that it's going to be an increase of 5000 the other side's going to go into furniture furniture and fixture so we're going to increase this one and decrease the furniture and fixture so i'm going to save it and close it and then if i if i go to my balance sheet and see does it do what it what it should do let's run it again running it scrolling down and now we've got the 98000 that matches here 98000 for the total i don't need all this detail because that's that's what i have this sub report for but i want the categories to match up and then the 5000 matches up here so then i'm going to have another sub account for the accumulated depreciation which won't show up here on this report because there's nothing in it but i want to have it there so when i do my adjusting entries i'll be able to pick that one up so i'm going to go back to the first tab go back to my chart of accounts hold control get back to that 125 sweet spot and then i'm going to go into now notice we also could have entered that transaction by going into the furniture and fixture register and recorded the decrease on this side so i could have recorded the decrease for this one so let's go back on up top and then go back to our chart of accounts and now now i want to create another sub account ACC D pre for the machinery and equipment so i'm going to go back up top and say another account this is going to be a fixed asset type of account and a accumulated amortization i don't know why it does that on the default it should go here on the default i would think accumulated depreciation and i'm just going to call it abbreviated ACC D pre for and then for the what i call equipment machinery machinery and and equipment equipment and that's pretty standardized category so and then i'm going to make it a sub account of machinery and equipment so if you want to have the full word here you could just call it accumulated depreciation but then you're going to have two accumulated depreciation accounts because you can put it as a sub account and you'll see it a difference because it'll be the sub account but i like to see the actual name and the accumulated depreciation accounts so that helps me when i record the transactions so i'll save it and close it and then i'm going to scroll down and check that out check it out so there we have it so now we got the furniture and equipment and the ACC D pre the machinery and equipment and the ACC D pre there's no change on the balance sheet from that transaction because there's nothing in the the accumulated depreciation for the machinery and equipment so we still see we're still at the same spot at this point now the other thing we could make an adjustment to is we can think about the other side of the transaction which is depreciation expense which is going to be on the expense side of things and we might want to make multiple we can either have one depreciation expense down here or we could have multiple depreciation expense they might not have anything for it so they might not have anything yet we'll add that when we when we actually record the depreciation but the question is do i want one depreciation expense or do i want multiple you might in that case i'm almost i'm generally okay with just having one depreciation expense and just recording all the depreciation to the one expense unless there's some reason that it's it's useful for reporting purposes to break out the multiple different categories of depreciation because the depreciation expense will simply roll into like all income accounts to the retained earnings so unless it's valuable to me to see the different depreciation expenses broken out you can put them into one account it would be easier to do that's what we will do here so if i go then back to the balance sheet now we've got our information here and you can see in the fixed assets we got the triangle which represents all of the fixed asset type accounts both accumulated depreciation and the actual fixed asset accounts and then we've got this added subcategory and notice that by making this one subordinate to this one there's two ways we could have done this we could have made an overarching account called furniture and fixture and then the cost and the accumulated depreciation being sub subordinate to it the problem with that is that the because this starts with an a and we're not using account numbers then the a account would be first by using the furniture and fixture and as the parents and having this as the sub then it actually is in the right order which is kind of nice and so we've got this and then this and then that gives us the subtotal and then the machinery and equipment would also have the drop down if we had anything in the sub account which we created but doesn't have anything in it so that's going to be that's going to be the detail people often get kind of confused with the fixed asset how to break out the fixed asset how to match it up with your tax preparer what should you do with the recordings of it so if you get that down it helps out a lot also when they convert these acc accumulated depreciation accounts to like a trial balance or something that throws people off because it's a contra asset account so so it's it's good to you know get an idea of how how are people reporting this people can report it different ways get a get a feel for what's being done in whatever bookkeeping system you are using and and just have an understanding of how it works so we're not going to go to the trial balance because we haven't really made any changes other than just breaking out between these two accounts