How Field Workers can get help with Reassigning Products and Services in QuickBooks Online
For some, Quickbooks can be an intimidating platform to use. Especially without any formal training. In today’s blog, we will help you learn how Reassigning Products and Services using Quickbooks could benefit you.
When companies use QuickBooks to grow their company, there is one tool that can really help them analyze sales, which allows for even more growth. You always hear that you should review your key financial statements, profit and loss, and your balance sheet, on a monthly basis. However, we can gain a better understanding of our companies’ sales by setting up a General Ledger (Chart of Accounts) for different sales categories.
For example, we might want to look at our sales of labor products versus our sales of actual products. This kind of bookkeeping service goes beyond tracking sales by employee or location or class. This is tracking a specific sales group on our standard financial statements.
Set up tracking
We do this by first deciding what we want to track, then we create an account for that specific sales group. In order to do this, we’ll navigate to our chart of accounts and select “New”, and then we’ll create a new income account for Design Services, Maintenance, and Landscape.
Map your Products and Services
This will allow us to map our products and services to those accounts in order to review them in our financial statements. Here at Waterford, we find it easier to have one generic Sales account or Income account with all sub income accounts nested under that. This allows you to track all sales together and then break it down by more specifics.
Assign and Income Account
Next, we will go to our Products and Services, located under the Sales left-hand navigation bar, and click edit on a product and service. This will now allow us to assign an Income account for that product and service. We will then assign a new income account for our Service. In doing this, a check box will appear asking “Also update this account in historical transactions?” We’ll want to answer yes to this. This will then move any and all uses of this product, even information from 5 years ago, into this new income account so that you can view all historical use of that product in your financial statements. You can then make comparisons on these items for the long term, not just starting from when we transition over to the new account.
When in doubt, pull reporting
Now not everyone is going to want to use this method, and some might argue that they can pull sales reports on products by themselves, which is true. However, not only does the method we just described allow you to track each product and service like you can through a product and service report, but it also allows you to compare more generic categories month over month through your financial statements, which are more important than just looking at your product sales. We will be discussing why this is important in a later post.
Ultimately is this something that you definitely need to do? No, this is an advanced option that will allow you to have a deeper understanding of what is going on in your company and how to help your business to perform better.