 Now we could add these one by one or if we're pulling this in from another accounting system and I have a list of items that we want to do at the same time, we could import. This importing process can be done in a lot of these areas like setting up your customers, setting up your items, and setting up your inventory, service items, and your vendors. So I'm going to say, okay, let's say I hit the dropdown and say import. If I do an import option, here's what we have. First time importing products or services, all your products and service information must be in one file. The top row of the file must contain a header title for each column of information, required fields. If you're importing inventory, then product name, product type, quantity, and quantity as of date are required. If you're importing services or non-inventory items, the name of the item is the only required field. Now this is selected a CSV item here, and on this side we've got the Google sheet. So over here CSV is like an Excel file, it's like a comma delineated file, but you can open it in Excel, it basically looks like an Excel file with no formatting to it. Now we can open up their sample, so a good way to do this often time is to open up the sample, which shows up down here if you're in Google Chrome, it'll typically open up in an Excel worksheet. So I'm going to say enable, and then if I have my information that I got from another accounting system like this, then all I really want to do is populate the headers to fit. What I'd like to do is line up the proper headers so that it will line up when I import it into the system. It won't get confused because I use different header names than they have formally used. So what I'll do is I'll just modify their template here and then enter my data into it. So I'm going to change the headers to line up to what my headers are, and then I'm just going to copy and paste my data into this Excel worksheet and use it to upload. So I'm going to delete this one altogether, I'm going to delete this, and then let's look at what we have here. So what I have is the item name, product and services, so product service name, product and service description. Let's keep that, the SKU, I don't have one, so I'm going to delete. The type is going to be service for us, so let's keep that line the sales price. So we need that line income account, I think we're going to need that line. And then the purchase description is, we don't need that because we don't need the purchase cost, the expense account we don't need, so I'm going to delete those. It's not inventory, so I'm going to put my cursor on the F, and then reorder point don't need, inventory asset don't need because it's a service item. That's why this is a simplified intro into the inventory which we'll do next time. Quantity on hand we don't need. So I'm going to delete that, and then if I go back to the right, we've got the product service name, I'm going to delete these, and I'm just going to copy my product and service names, which I put here, I'm just going to copy these either generic things obviously, so they're kind of don't, and then I'll put them in here, and then we got the sales description, which I'm going to just say is the same. So this is what this description that's going to show on the invoices and sales receipts, I'm just going to copy this, put it down there, paste it, and then I didn't have something for the type, but the type is going to be a service item, it's not an inventory item, it's their service item, so I'm just going to copy this, and paste it down, and delete these two, and then the sales price, I'm going to pick that up for my data, so I had these, so I'll copy those, and put that on the sales price, and the income account, I think they had an account called service, for the income account, that's the account that will be hit every time we enter the information to the system, and I think there was a tax, there should be a tax account, which I didn't see, whether it's taxable or not, and I'm going to say non-taxable, and see if they'll able to pick that up, because it's non-taxable, meaning not subject to sales tax. Okay, so then I think that's good, I'm going to save this, I'm going to say file, save as, I'll put it on my desktop somewhere, I'm going to say it's going to go to my desktop, I'm going to put it into my QuickBooks Online file, get great guitars, and I'm going to call it service items, and then save it, and okay, continue, I think this is like an old Excel file is what they're trying to say there, so I'm going to close it out now and see if I can import it into the systems, I think I have everything I need, the headers are proper now, because I used their headers, except this one is a little iffy, we'll see what it does with that. Okay, so let's test it out, I'm going to close it up, and then I'm going to browse and look for that file that I just did, which was on the desktop, it's on QuickBooks Online, it's get great guitars, service items, it's an Excel file, which is appropriate for this side, or it could be a CSV, so I think I'm good there, so I'm just going to go okay, next, and so now it's trying to line up all the categories, so these are the header categories that are possibly available when you enter the items, these are my headers, and they should line up hopefully, because I copied their names, so this is what they have, this is what was on my Excel sheet, it lines up perfectly, great, this one lines up perfectly, great, this one lines up perfectly, great, because I used their header names, sales, price, lines up perfectly, and then the income account lines up perfectly, and then that tax thing, where did the tax thing go? It looks like they don't have the tax option here to see if it's taxable or not, so that's why I didn't have the header in the sheet, so okay we'll have to deal with the tax separately possibly, so let's go ahead and say next, and so now it's going to give us another sheet, which give us the information, the items in red are questionable items here, right, so we've got the name, so there's the names that we set up that looks right, and then we're not buying them or tracking the inventory items, there's no number there, the type looks good as a service item, sales description looks good, price looks good, income account, I said service, and they're having an issue with that, so I'm looking for an income account, service income, let's use that one, now I'm going to right click on the tab up top and duplicate it, pull that to the left, and then I'm going to go down to my chart of account, I'm going to close this out over here, and go down to my chart of accounts, under the accounting tab, chart of accounts, if you were under the business view, that would be under the bookkeeping tab, and the chart of accounts, and what I'm looking for is an income statement account that's appropriate, now if they don't have one that's appropriate, then I would make one up, but I can see down here they've got service fee income, so I'm going to use that one as my income account, if I didn't like the name, I'd change the name of it and then use that account, basically would be my idea, so I'm going to go back to the other tab and say okay, I'm just going to change all these to the service income account, boom, service income account, boom, service income account, okay, and then we don't really need an expense, and then the quantity, I'm just clicking on them just to get rid of the red, there shouldn't need a quantity, because we're not talking about inventory, no reorder point, this is not really necessary, so it should be good, now the as of date shouldn't really matter, but I'm trying to get it at the, it will matter later for the inventory, and I want it in there as of the end of last year, the end of last year, so if there wasn't a journal entry, it doesn't affect the current period, there won't be this time, but there will be when we get to the inventory items, and this is a precursor to the inventory, so let's say import and see what it does, so four out of four successfully imported, boom, that's what we like, four