Discover the Best QuickBooks Invoice Template Excel for Businesses

Quickbooks invoice template excel for businesses

foreign [Music] hey folks welcome back to a new video today we'll be diving into QuickBooks online and showing you how to create custom invoices if you're new to ask a CPA please remember to hit that subscribe button down below as you'll be coming out with weekly QuickBooks Online tips and tricks as well as some amazing business and individual tax tips so make sure you hit that subscribe Button as we have some really awesome videos playing in the next few weeks that you do not want to miss alright today we'll be covering how to create invoices and how to customize those invoices with your business logo alright guys let's Jump Right In today we're going to be using Craig's design and Landscape services so first I'll show you how to customize an invoice and then we'll show you how to go ahead and create that invoice so first head over to the spitty wheel up here in the top right hand corner and under your company hit custom um form styles all right now right here you can select new style and then invoice so from here there's design the content and the emails all of which are fully customizable so you'll see QuickBooks has some templates in here where you can select the different type of invoice that you want even got friendly I mean what's not to like about that there's fresh there's bold there's modern there's Airy classic Airy new but let's go friendly of course we want to do the friendly one um you can add your invoice here so let's go ahead and add that I went ahead and uploaded this already I created this on canva if you're not familiar with canva jump over to canva caedva.com and um you can create logos you can create all kinds of really cool um stuff for free and they also have a subscription package as well uh it's a really great website I use it all the time for all of our marketing material uh so let's go ahead and select that and we'll hit save there we go we got the logo and QuickBooks Online already use that logo uh use the colors off of our logo to customize the different fonts and colors that they used in the invoice um so that's perfect we're not going to change the font but you can if you want or you can print it out and change the um the different widths or or you know footnotes or however you want you want to change that you can do that right here um the content if you wanted to dive in and change something specific about either the header the main description or the footnote you can do that you can add a footnote that'll show up on every one of your invoices you can do that here and then the email this is the email that is sent out to the client with the invoice so as long as you have your emails set up properly an invoice will be sent out with your invoice and the client can just go ahead and pay that right from your email so it really saves you a ton of time and doing running around doing collections but you can adjust this however you want to um we're just going to leave that right there how it is I'm pretty happy with that and we'll select done and there you go so now let's go over to sales and here are your invoices that are outstanding you can look at your all of your sales you can look at your estimates your payment links customers and products and services so before we do an invoice let's take a look at our products and services so in products and services where you'll set up every single service and or product that you offer um with the cost and if it's taxable or non-taxable so in order to do that you would select the new it can either be an inventory item if it's product if it's a non-inventory product or if it's a service or a bundle so if you have like those baskets that they send out to customers um you know like the subscription baskets that's kind of what I think of when I think of those bundles where they just put you know four or five different products in and send them out [Music] um yeah or fruit baskets or cheese and wine yeah something like that there were multiple products in in one bundle um but most the time um we're doing services or or inventory so you would just select this and then you can fill out the name the description the SKU if you have one uh the price per unit and whether it's subject to sales tax let's go ahead and close out of that this is a landscape and design company so they have Design Services um and then you know fountains Landscaping sprinklers pest controls are all the different services that they offer and so they have you know pumps rock fountains these are all inventoryable items and they have quantity on hand and they've got cost per product and the sales price per product so let's go ahead and go over to an invoice so you can go through sales and go to invoices or you can select new an invoice and you'll get to the same spot now this is the main invoice screen that you're going to want to fill out and this is what is going to fill out that invoice that we just showed you how to customize so so to set up a new customer you would just select add new you go ahead and we also make sure you fill in their company name their email address their mobile number and their billing address but it's really important that you at least fill in their email address because that's where they're going to be receiving that invoice but I like to fill in as much information as I possibly can because it's it's really important just to make sure that all that is being tracked properly um but for this example we're going to use Bill's windsurf shop here we go and as you can see the email address populated as well as the billing address and you could still customize this within the invoice and that's totally fine the terms when we set up that customer we set up their terms on net 30 but you can always change that as well it has the invoice State as of the date you're creating this so I'm filming this video on September 25th 2022 and then it does it 30 days out from that date if you change the terms to net 15 it'll automatically adjust the due date as to agree to those terms we're going to leave it with net 30. tags are um tags are for when you have different Industries say where you have certain locations or different funnels or product lines or different customer types that you want to track and be able to run reports based on that information it's what you'd use tags for we're not going to be using those in this example um let's see so product or service we're going to Let's do an example with a service first so let's do design and you can always add more information on here if you wanted to you could say Uh custom design Kate at 3.5 hours then the quantity put 3.5 and her rate's 75 dollars an hour which comes to 262.50 and this is not subject to sales tax we're going to leave that one uh blank and we're not putting the service data of course you could put that in there if if you worked on this client on a specific date you wanted to add in that information uh now let's show a product as well let's do it oh fountain pump let's say it's one and the rate's fifteen dollars and that is taxable so let's include that let's do another product just for fun let's do some rocks Garden rocks awesome let's do 30 Garden rocks and this doesn't have a raid on here I guess they have multiple rocks which they charge at different rates we'll say these are 40 these are Big Rocks these are 45 bucks a rock and those are subject to sales tax as well so that's thirteen hundred and fifty dollars plus fifteen dollars which is subject to sales tax that's thirteen hundred sixty five dollars and then let's do a discount on this just to show how that works as well you can do a percentage or you can do a value let's do a percentage let's give these guys a ten percent discount because they're friends of ours and we'll say we're in California which is eight percent sales tax so as you'll see the sales tax is adjusted for the discount so if I took this discount off the amount of sales tax increases so with a 10 discount it also discounts the sales tax so on this invoice you could write in some a message you can customize this as much as you want you can add some pictures or you know whatever whatever you want to add to your invoice um you can add that on there and then let's save and send and that's it guys we'll preview the invoice this is from us at Craig's design and landscape service and this is going to build all right bill pay your invoice buddy um there we go there we have it and then send and close so it's a sample company so it's not going to send that invoice but I wonder why I didn't take uh it's taking the standard that's why all right so let's let's run back and build build one more time let's just do let's just do some design say 30 hours 75 bucks let's customize this one now let's use [Music] our custom invoice that we created there we go that looks better so now we have our logo on it and this is going to bill and we're happy with all the information but this is the this is the custom build that we created so let's save and close there we go and now you can see over here under all sales our invoices are open and outstanding those are all going to Bill Bill's a good customer hopefully Bill Pays His invoices but uh that's how you do it guys so please if you have any questions feel free to leave a comment down below I'm always happy and uh jump on here all the time and check those questions so feel free to leave a question down below or you can head over to our website at askasscpa dot Co and leave us a question there as well and I'll respond ingly uh thanks a lot and we really appreciate it make sure you hit that subscribe button guys and we'll catch you in the next video take care foreign [Music]