QuickBooks Online 2021 Custom invoice import form from Word document. Here we are in our QuickBooks Online practice problem where we’ve been talking about setting up our custom invoices last time setting up a custom invoice with the use of the QuickBooks settings to do so, now we’re thinking about some more options that you might be able to have to do further customizations, which could be the actual importing of a template for the invoice. So let’s go back up top in the cog up top. This is where we have the custom form styles.
00:34
That’s where we added our custom invoice. Typically, the drop down if you hit the drop down on top will not have the import there yet, unless you turn on a feature we’ll talk about in a second. But we’ll have the invoice estimate sales receipt, we’ve made a custom invoice here, this is the invoice that we used or we created. And then we use the set features within into it in order to make our custom invoice we see on the right now those set features have have a good deal of functionality, but nowhere near you know the types of functionality that you could have to customize an invoice. there’s pros and cons to that, of course, because the less features that you have, the less confusing it is, which is nice.
01:13
But if you wanted to do some added types of things like putting more images like in the bottom of this thing, or background images or move things around a little bit more, or a lot more, you can you could try to use some other kind of options. For example, possibly uploading an invoice. So let’s just take a look at that briefly. I won’t go into a lot of detail. I’m not a designer here. But it might be worth looking into if you’re in an industry where you feel the invoice and the look and feel of it is really important to you.
01:41
And and you know how it interacts with your client as opposed to if you’re in an industry, where the invoice to you is more of a functionality type of thing, as opposed to, you know the look and feel of it being really important. So I’m going to I’m going to exit this without saving the feature you can turn on if you go to the widget up top and we go to the QuickBooks lab on the left hand side under your company. This is where kind of some of the new stuff that will be put in play will be put in play here. And you can turn on some of these items.
02:10
So you want to check this out every once in a while some of this stuff has been in there for some time, but and then they kind of test it out and possibly pull it into the major features at some later time. And some of it may be new. So what we’re looking to here is the end points is the import style. So it says now you can spice up your brand with your own invoice design, import your.do doc x, that’s a word document basically file from Word, tell us which field to replace, and voila, your brand is yours again.
02:43
So you can watch the demo here in order to see a quick demo on it. if you so choose, if you turn that on, then then you have the option of the importing. So if I close this back out, and I’m going to close this back out now, if we went to the cog, for example, and we went to the the forms custom form styles, which is where we are at, that’s when you hit the drop down and you’ll see the import here we can import the style. So now the thing is, we can then get an invoice from basically design it in Word where we have more features to do so and then possibly invoice or import that into the QuickBooks system.
03:21
So there’s then the question is, well, how do I customize it in Word, and obviously, you could look up some templates and possibly pay for templates. So if you google search or do your search in your favorite browser, for custom templates, you can look there, or you can start with a basic template within Word a free template within Word, and then make adjustments to that. So let’s take a look at that option. Let’s open up Word and then you can open up a template by going to the to the file I’m going to say new item here and then I’m just going to type in invoice invoice.
03:52
And then we have our basically our our different types of designs we can have for an invoice, you can see some of these are fairly basic, but they do have a different look and feel than what is provided. And anything with an extended kind of image or something like that, like this green, or possibly this whole bar on the left hand side is something that you might not see in the normal templates in Word. And again, the fact that it is outside the box could make it you know, desirable make you stand apart, you know, it could give you a lot more functionality.
04:25
If you’re a bookkeeper and you’re good at this kind of stuff, then that might make you stand apart for for certain types of clients that are that really like this right. So then if I was to create, say this one, and open this one up here is going to be our standard type of invoice. Now when we upload it, anything that we want to be populated to change, we want it to kind of match into a field that’s going to be dynamic in QuickBooks, we got to put what they call the Chevron’s around it.
04:52
So this information up top For example, to the invoices going to and then the name, we might want to put we’ve got to put These little brackets around it, and hopefully then that will allow us to pick up a new field within QuickBooks. So then we got the company name. So same thing, we’ll put the little, what they call the Chevron’s around it, I believe they call them. And so we’ll put this around. And that means it’s gonna pick up the company name that we’re selling to the street address.
05:24
So we’ll put these around there around the street address, city, state, and zip code, these might not all be in one, you know, you might have to put Chevron’s around the city and then the state and then the zip code. Not quite sure. But that’s those are the things we’d have to kind of check out or compare and contrast. And then the ID number. So let’s put ID number. Let’s go. And then here. And here. And then maybe like this should be invoice number. Voice, let’s say number. And I’ll call it invoice number here, I’m just gonna call it an invoice number, invoice number, and then do due date, and then your company name.
06:25
Now, this is fairly static, because it’s going to be your company name. So I’m not going to put the Chevron’s around this because we could just type that in there as our company name, our address, and so on and so forth. And here’s the invoice number. So maybe this one is where I should have put. So, invoice number, I’ll put the Chevron’s here, invoice number, and Chevron, and then date, so I’m going to put Chevron date, or you know, you might have date as a text. And then the Chevron’s for the date. That’s not a chevron, that’s not a chevron date, Chevron.
07:12
And then, and then the thank you for your business. And so on and so forth. I think we want here, the quantity. And then I’m going to put here description, D script, Shawn, and then unit price. So put Chevron unit price, and then total Chevron total. So we’ll do that. And then down here, I’m going to do the same thing, I’m just going to say this should be the subtotal. This is going to be the tax sales tax. And then this is going to be the total. So total. Okay, so I’m gonna keep it there.
08:07
And we’ll test it out with it. So I’m going to save this, I’m going to go to File, Save as put it somewhere where I know where it’s at. And I’m going to put it into this picture file, which is my temporary file. For some reason, this is gonna be invoice template, I would say two. And then let’s save that. And let’s try importing it. Now I’m going to go back on over to QuickBooks. And let’s close this out. So once again, I’m in the the drop down for the Kog. I’m in the invoice the custom form styles. And then I’m going to say new style and import a style, import some style.
08:51
So I’m going to say invoice form. So first time importing an invoice, learn how to set up your your doc file, so you probably want to do more research on that that I put here. I’m gonna do this fairly quickly here. I’m not an expert on the design type of things. But I just want to point out this option because again, I think it could be really nice for some people that want to put in the time for it. So start with a template, a simple template can be found in the import guide. Before you up before you upload open your file and add angle brackets, angle brackets, these things is around each field you want QuickBooks to replace.
09:29
So those are the ones that we got to replace items with that we tried to go through and pick those up. And a little trial and error is probably going to be necessary here to get your design right and get it in here properly. So invoice template number two. Let’s go ahead and say next here. So next, there are fields that are not correctly mapped. So this is where you got to go through and do the mapping type of information obviously anything with a with a red area there saying hey, I can’t map that I wasn’t able to do To do the mapping for it.
10:02
Now I’m going to turn on, I want to map my template, if you use the mapping, that’s going to be in the keys in the in the template, then it’ll make it a lot easier, you won’t have to do as much of this kind of mapping type of stuff here. But I’m going to say I’m going to turn this on and see if I can match up the fields as close as I can. And we’ll just, we’ll just get as close as we can. And that’s going to be it. So, and I’m going to go down here and say this is the invoice number. So I’m looking invoice number, invoice date. So there it is, I don’t know why it couldn’t find that, it seems like that wasn’t too difficult. And then name customer client member, so I’ll keep that the fine.
10:43
And then the company business organization, I’ll keep that. And this is going to be the street address. This is the the name, customer name. And then company name. This is the company name, I think it should be the customer name here. company name, customer name, the street for the customer. Notice we have the company name there. So instead of just hard coding the cut the company name, because you would think the company name wouldn’t change. So you might want to hard code it. But if you did change your company name in QuickBooks, then you would want it to change so you can make that field possibly adjustable as well.
11:22
And so that the billing address, keep that as is the phone customer client member name, let’s pick up the phone numbers if I can pick up the phone, about telephone, tell. I’ll keep it at the at the customer phone, and then the invoice number invoice number we have that was pretty straightforward. That one item dish item description, unit price. So I’m going to say price rate, I’ll keep there the total. So invoice total do okay subtotal. subtotal, invoice, and then sales tax tax rate. Let’s do that.
12:17
And then the total, I’m going to keep it like this, again, you probably want to do some some trial and error. And it would, it would make it easier if we downloaded the templates. And we tried to make these these names that are going to be in the bracketed area for the fields that would change as close as possible as what they recommend them to be. So that you have to do less mapping when you go into it. But again, you’re probably going to have to go back and forth a little bit to map this this thing out. Exactly. But you can see how the process works, hopefully here. And then I’m going to say next.
12:48
And then we’re going to preview the information. And then if there’s any changes you need to make, I think you’re gonna need to make them before you save it because then you got you can’t go back into do the same type of customization, then you’ll have the basically saving item here and then you should have basically your new template. Now once again, our template was not beautifully crafted here, it’s going to take more intensive work.
13:10
To do this, you’ve got to be more bit a bit more of a designer to do that. That’s why the default template information is done with with a default designer. But again, if you want to put more time into it, there’s there’s that tool that gives you that bit more flexibility. If you’re looking at this designer tool within QuickBooks and saying hey, I wish I could do this. I wish I could add a background or an image or move this around in a different way. Then you could you can look into that with more detail and you should be able to do so. But again, it’ll take a little bit more time to get that to line up.