Create and Manage Your QuickBooks Invoice Template Excel for Pharmaceutical Needs Effortlessly

Quickbooks invoice template excel for Pharmaceutical

QuickBooks how to create an invoice hey there everyone my name is Matt Holquist with the QuickBooks University real quick before we get started if this video is helpful please give it a thumbs up share the video I sure would appreciate it also head over to the QuickBooks University at QB university.org where you can join the lifetime Member Program and learn everything you need to know about QuickBooks and ask me your personal questions okay so how to create an invoice now first thing to keep in mind when you're recording sales in QuickBooks and invoice record sales and there's a couple different way to record sales I've got other videos on this and invoice is going to be sent to a customer or a client when they owe you money so if they pay you right when they buy it that is not an invoice that is a sales receipt this is when you give a client or a customer credit and you sent you do something for them or you sell them something and you send them an invoice and they have time to pay it okay so we're here at the home screen you can see here there's a button that says create invoices you can also go up to the customer drop down menu and you will see here it says create invoices both places will take you to the same area in QuickBooks to create an invoice so we click on this create invoice and you see it brings up a form this is called a form in QuickBooks and you'll see a lot of things you know like an estimate purchase order Etc they all have this similar look and feel to them QuickBooks tries to make this very simple for you to enter or the information you need to enter all right so first things first we're going to go up here we're going to choose our customer and job and we'll just go down here and pick Jenny morgenthaler room Edition okay and you'll see here that you can assign the class so if you do use class tracking and QuickBooks we're going to say this is Remodel and the template we're using is in the sample company files this Rock Castle invoice so this is a custom invoice that this sample company Rock Castle construction has set up for use in their business which you can do the same thing you can set up your own custom invoices all right so the date pre-fills invoice number pre-fills if you do need to change this invoice what you can do is just type in your invoice number so if you have a certain sequencing you can type that in and QuickBooks will remember that and put in the next one in that sequence on the next invoice that you create the bill 2 and the ship 2 this should all pre-fill based on your customer list and entering the information for your customer same thing with the term so when you set up a customer in QuickBooks you specify the terms that you have given this customer and it'll automatically fill this now you can change this you can change it to something else you can change the date and you can change any of this stuff that you need to this just all pulls from the customer list now the next thing you're going to do this is if you are just sending an invoice and you're not pulling in any any specific time that's charged to the customer expenses or things like that you're going to choose your items now items come from your item list and these are all the things that you Bill for in your business whether it's a service item inventory non-inventory then we've got some other items down here so all of these different things are set up in your item list where you specify what it is what you charge for it and what accounts they're going to go to when you sell it so on an invoice when you specify this item you're saying okay let's say that we are charging for blueprints and the description pops up from the item list you can change it on the face of the invoice you can type in anything you want to type in and the price will automatic automatically come up from the item list so this item had a zero price and it's probably because it allows you to change it on the invoice so even though you enter in your item list what the price is for a product or service you can always change it on the face of an invoice okay so we're going to say that we have one set of blueprints and these are a thousand dollars okay so we're saying it's a thousand dollars you type that in the rate it puts in the amount and this is a non-taxable transaction again this is something that's set up in the item whether it's a taxable item you're selling or a non-taxable service you're providing depending on the state that you're in this is for sales tax so you see down below it says total uh a thousand bucks there's no tax payments applied thousand bucks you can go down here to the customer message and there are some pre-filled ones that you can put in here you can add new ones uh you can leave it blank whatever works for you and your business so we say we appreciate your prompt payment and we can save and close now or save a new if you're going to create another one now a couple of options you have up here you can print this later or you can email it later so if you're creating a lot of invoices that you're going to print and mail you're going to say print later and then you go and print those all at one time or email later so you can email a bunch of them in a batch at a later time or you can do it individually you can say print this now or email this now totally up to you all right now there's a lot of other options up here as well that we're not going to get to in this video but you can add certain expenses you can create batch invoices refund credits a lot of different options these are the basics of creating an invoice in QuickBooks all right so then we're going to save and close and it's going to save our invoice and what this is going to do is record a sale in our profit and loss statement and it's going to record an accounts receivable on our balance sheet so that we know who owes us money all right any questions any comments feel free to leave those below happy to answer those for you again head to the QuickBooks University I've got some free videos over there show you the three biggest mistakes most people make in QuickBooks and once you watch those videos you're going to be ahead of about 90 percent of people out there head over there now qbuniversity.org