Collaborate on Cash Sale Receipt Template for Planning with Ease Using airSlate SignNow

Cash sale receipt template for Planning

thank you for watching this video this video is brought to you by new QuickBooks comm so is our website new QuickBooks calm and you can see all QuickBooks related to videos video tutorials tips and articles you know all kinds of good stuff you can visit in here and check it out so in this video I'm gonna focus on how to create sales suceed template to introduce sales summary so create sales to see template to introduce sales summary so this could be for e-commerce business or retailers our restaurant business or other tablet business so that's the focus of this video so I'm gonna go to QuickBooks desktop in here so here's QuickBooks desktop normally to look like this right you all the charge in here I'm gonna hide this okay so create sales to see so this is the one so it creates chef succeed so normally what you have is a critical some sales this is your default one and underneath you to see Debbie so summary in here there is so summary in here that's the one I want to use for this video so the only use daily sales summary one even if you don't have the daily summary you can still use this one it's not a big deal but if you have created a company as a retail you should see daily Sound City sales summary template in here so if you want to see all the templates that you have then all you do is go in here the West templates and you can see templates in here for sales to seed in here so this is here skander one and if you don't see their sales then you just have to customize it and create a new one on the way you like it it's pretty straight step by step is pretty straightforward and go from there okay so this key I already have it so I'm going to use this one there is sales okay so before I go to the item listen here but this is the important one I'm gonna I'm just gonna show you how this one works you know on top of this video so let's say you have a known taxable sales at $1,000 and $1000 and they paid it let's say by the safe by check and you just so payment as negative like this and underneath like this and underneath under total that you will see zero in here so it's basically your daily sales summary is likely zero selves zero template here zero safe succeed right so the way this works is $1000 is your income they will show in your P&L at income and $1000 you know first it goes to on the father phones as clearing and when you have time to deposit to your bank account or if it's a credit card you know the Martin merchants while they'll deposit to your bank account so basically it goes from undeposited funds at the clearing account and then you'll show up in your bank account alright so this is how it well this is the you know this is Europe this is how you you can play to look like you know it should be zero in here okay so I'm going to show you the listing you how I've created item list that's the most important one for this one okay so I'm going to clear this okay let's go to item list and item listen here I have all these before I do that I'm gonna show you the chart of accounts that you need it's going to be some of some of these okay so I'm gonna go to chart of accounts in here okay so you gotta have a much sense merchants much in sales merchandising much in sales account that's your income type so you account it income much in merchandise sales or whatever you name it that's okay so it has to be income type not expense type of course or cost of goods sold this is the income our sales so you type and then you will have a much an account fees at cost of goods sold normally all these when you create a company you know it automatically QuickBooks automatic create all in all the accounts needed for your business and so you need that and then you will have if you have charts selling merchandise then you'll have a cost for that much a nice to so you'll need a one merchandiser experience account right so it could be cost of goods sold in hands that create a new one so the focus for this video is the greeting sales sales template and then other one is the gift card if you deal with the gift card we don't do it that's fine but if you deal with gifts car so you need to create the one account for grid cars grapes gift certificates some gifts when you sell gift certificate it's basically the IOU type so you have to set up like a other car liability so that's the right way to do it it's a real accounting way to do it and so I have already done it here you know like this one so the account type is other car liability right so come down here account new and underneath in here other current liability so that's the one you want to select and in here so this is for gift cars that's very similar to the one you do for a credit card type to the gift card is your liability okay and then if you want to create other cost of goods sold for your merchandise purchases then you come down here and account this new and under account types you select a cost of goods sold a lot and then you save much and that's purchases so it's very easy I'm gonna show you right away in here cost of goods so continue it and just name it whatever you purchases like this let's part a cost of goods sold okay like this now you have it right okay so those two and of course you'll have a bank account I don't have some bank accounts in here okay and now let's go to the the see if I have the I'm gonna run the company financial and if I have something I'm going to eat then we'll have everything fresh in here so I don't have done one here I'm going to leave this one okay so now okay so I'm ready to go to the item list so that's the most important one all right item less in here okay so first of all you need taxable and non-taxable items and if it's a merchandise one it's non englander tribe you know tracking inventory this is basically byte and you wanna buy to expense it when you sell it it becomes your income okay so non-taxable one in here like this it's basically item name I have in here total sales non-taxable and tax code is non-taxable and price this little bit blank an account you want select its merchandise sales that's part of the income type right income type okay and the other one same thing the other one is taxable one taxable total sales total sales taxable and in this case you just select the tax code here tax one okay and the county wants licking merchandise right okay just in case you don't see tax code like in here so that means you haven't gone to the preferences and until QuickBooks that you charge sales tax so go come down your sales tax company preferences and just you know if we have you done you has known the street generator button to guess these are sales tax yes and did you know ad sales tax in here I'm gonna go through this a little bit okay so that's how you have to do it okay I have it right here okay so now the next one is the gift card one you know if you don't sell gift card that's okay but in this case I have gift car sales in and payment okay so so the gift card is I just said it's the like IOU type so when you sell it it's not your income yet when they you know then customer come and use the gift card then and buy much and at the end it's your sales so the way this is set up is others charge type is other stars knew all the charges right here so you'll have other stars okay but it's our sales like this one here right so it's selling gift card in here so it's basically give cars you know the select dial on we already went to let's run and it's non-taxable you don't start tax when you sell it sell gift card gift certificate when they buy merchandise then of course yes our sales tax that one okay so on the gift card payment is basically when you come back and use that gift card to buy merchandise and it's still same thing exactly same I'm just doing one for one for sales are going for payment and just to track to see you know how much gift card is sold and how much they use the gift card and what's left basically and in the discount one if you are you know giving discount and you want to try to track it separately in your P&L figure out I have $1,000 my regular retail price is $100 and I'm gonna get 10% discount and sell from 90 bucks I wanna track that and I are $10 in my P&L so basically you know discount in your P&L sitting here sort of account sales discount right here income so you go like a negative merchandise sales is positive sale discount is a negative like a contract at account so if you have $100 sales and it's sold for $90 you know to a $10 discount you'll see $100 positive and negative $10 in here okay so um let's see how's this one is set up so discount is it's in here so when you select new and you will see a discount in here see right here at discount and either you select dollar amount or percentage and in this case I haven't slept yet you think I want to enter whatever ID I'm giving discount based on new mom total sales okay so the scene here so sales discount it's in here see the income account right this is non-taxable one and the other one is taxable one it's a taxable one see tax code in here taxable the other was non-taxable okay and then it comes to payment depending on whatever payment you accept you can select all these or whatever you accept you know so for payment come down your item and you and then you see payment in here right see payment method select all these and in if you have new one then pad new type okay and then in this case I've selected group with other undeposited funds like a clearing type you know you do pass deposit you know you have cells you may have 10 cells 10 charts and bunch of credit card cells and you do you know go to bandy boys check separately and you merchandise merchant service they will deposit credit card sales to your bank account all right so it's like creating credit I've account on deposit and from undeposited funds you make deposit to your bank account okay so I have all these let's say casts in here just basically you know payment measure from the from the west and a group with unbothered funds and in some cases if it's if it if the deposit goes directly to your bank account you know sir you saw $100 and $100 goes to your bank account then you can just directly select your your bank account in here this is my bank account here right so in this case I'm gonna go to undeposited funds stay with that one okay and then you have a sales tax in here so in this case I have a California sales tax on tax 88% and intact agency and more of Equalization so that becomes your vendor so if it's not on your vendor list just add new and then type it okay so and from here you want it from new you will see sales tax to sales tech item right here so staff I don't know this is the one you select okay and if you need to do group then you have to do it differently I have a separate beautiful down one so you can check it out okay so the items all ready to go now I'm gonna go to sales to seat and I'm gonna show you how to create sales seat now okay so basically I'm just gonna select all these right okay and let's say I want a subtotal for those two I'm just gonna start with the easy one and then you I will try to expand it later on okay let's say $1,000 for your non-taxable cells and $1000 is your another 1000 is taxable sales right so 2,000 is your total sales okay now you got the payment let's say so let's say you've got the $500 check so that you have to introduce a negative in here $500 right okay and let's say cash it's not also $500 right okay and now you've got some credit card sales so say MasterCard in this case it's a it's taxable in here $80 let's say one sells is 540 another one let's say visa you know you charge sales tax on the 500l so it's less another 540 okay so now as you can see here this total always has to be zero in here so when you know you have $1,000 sales taxable sales you have $80.00 for sales tax right underneath in here so this is your liability sales tax payable okay so you see payment for that one - so the total has to be zero and here just straight for payments these are the ones okay so so basically you have $2,000 cells and you have payment matter distributed like this one here right okay pretty easy and if you want you can get the subtotal for that one - if you need it like this so 28 is your payment right 20 80 is your payment okay so two thousand four cells 80 bucks for your for your sales tax simple as that okay so the moment just saved this so what will happen to this one now okay clicking guess it now $2,000 is your sales and 20 80 is your payment and $80 is your taxable liability right so it's basically sales 2080 taxable liable tax liability and 2080 should go to your bank account at some point okay so I'm gonna save this okay so I'm gonna go to P&L just repair it fight so this is a brand new one I don't have any other data on this one so two thousand dollars is just sales right if you click it they will take you the same place as you're there in sales summary report and $80 you should see you go to balance it and you should see $80 and yet I sales tax payable right okay and then the 2080 to choose your payments you go in here sales to see current sales the seed and when ready to deposit your bank account or transferred from one deposit fun to come down here that you can see here cash you went to the bank and need a deposit right so it could be cash and check together you know let's say deposit those two one thousand you know one deposit slip click that one and it select your bank account right checking and some of the moments you do that you'll basically move from undeposited funds account to your bank account so $1,000 you know it'll move to your bank account right okay and the next one let's say these to your merchandise or your merchant processing company they did deposit to your bank account to see 1080 those two together that day and click that one and same you know make sure the bank account is accurate and the deposit gate is accurate deposit date you know deposit did it's better to match with your your bank account bank deposit account deposit account bank posted did I mean alright save and close okay so that part is done now right okay so now if you go to your bank account so you should see the mounting gear so in this case I have ten thousand dollars from opening balance in year six eight one thousand dollars is your your check and cash right you can customize so you know the reference to our 1080s your credit card so you know it works pretty good alright let's expand this and let's say you want to track this with ah with the discount one expand its create another one in here alright the first one see you don't you don't you know tracking in a discount it's a basic one right I feel next one you know I'm gonna do with the discount okay so so now basically you know it's you have you know you want one thousand dollars you get from you either you register or from e-commerce we have to get some some way of tracking those numbers of course tracks of them non-taxable right okay so I'm gonna create a new one now okay so let's say the same thing in here taxable and non-taxable and you know for this jobs this sells out also track discount here okay so this add in sort of line in here so I want to select discount in here there's no discount here non-taxable discount right okay I'm gonna add another one and one I'm going to delete this enjoy this there it'll delete line and I'm gonna insert line in here okay one more okay so I'm gonna get a subtotal for this one right okay so it's discount let's say this time you saw two thousand dollars sales non-taxable maybe a little bit okay ah and let's say you have some discount in two thousand dollar sales let's say 10 percent or does it matters less than $200 we'd make its negative so now we have your total sales happens to be $1,800 now right and in this case let's say discount discount taxable one taxable discount okay let's say this one there's three thousand dollars right I'll say ten percent discount of three hundred dollars discount okay so like this right and get the subtotal there we go so now as you can see here you have $1,800 non-taxable sells $2,700 taxable sales right okay and so now let's expand this a little bit let's say you also start selling your gift cards okay so select a gift cards in here right give car sale that says five hundred dollars of course right okay and make sure this is non-taxable okay so there's no tax on dowon so this is for the sales and let's say you know they started using that gift card right so if they start using that gift car let's say out of this gift Karla say our gift card in here no payment in here right cb- payment let's say they use hundred ultimately hundred dollars okay alright so now you have let's say out of this two thousand or whatever it's hundred dollars paid by a gift card okay all right so just keep adding in here now add in short line here okay so now I'm gonna make this up go for that one okay so four hundred dollars one right all right basically you so $500 gift card and hundred dollars they came in and use that gift card right okay so now you can close the bat with the payments all right we can do whatever you want so it's basically let's say MasterCard it's three thousand right now let's say check the rest let's say two one two five sixty cents this is the same example that could be you know you have to get that from your from your register or some some from e-commerce thing okay so it's basically zero now right okay so now you got an idea how to do it right okay so I'm gonna save this okay okay so now you have different sales right so you have under plotted fonts account - so you go to do your same thing I'm doing this twice now going here and deposit checks right and then deposit credit card right so that's how you have to do it okay so the sales part this is how I could do it okay so now you know everyday you don't want to type all those things right so you want to create some sort of template in here okay now you don't have to type it use this is enter all the sales you know every day just into sales okay so that's what I'm gonna do that's the next focus now alright so all you have to do is select everything in here or I can just use the other one if you want like this alright so let's make a copy just make a copy of this make a create a copy right just create a copy like this right okay this is a copy now and just make just everything 0 this is template right template all right so zero in here okay and MasterCard I said this case you can just copy the whole thing you know someday may get cast I'm Deema get check right Sunday may get debit card or if you're not tracking that separately that's okay debit card Discover card a check MasterCard Visa let's say you also accept American Express right okay like this see everything at zero now right so just stuff and then just go in here and just memorize this thing here just click it memorize right and does it say daily sales daily sales memorized list so this is go to the at my reminder list how often daily of course next date is next you know like this like this the sound and now you know everyday you just go there I'm gonna close this knob I'm gonna save that alright so going here and the memorized transaction listing here so to remind you every day you know said gaily with your mind you says come down here it's right here see so all you do is next day you know just fill out the it's like a form now this is daily sales summary form right just enter all yourself and then you're done you know into this and you're done very simple and then you know if you some somehow this forms not complete you need to add something new let's say once in a while you buy you know $10 repeats or something right so they then if that's the case or or you give $25 to for a repair guy okay so those could happen when you were in business you care self specially and if that's the case then what you have to do and then you'll be using it to create another item last year create item last right item new and you other charge and account you want to select let's say this is for the meal center cannot say you know make sure it's non-taxable alright so this is like a meals let's say like this okay so save it I'm gonna create now on right okay so now just say oh another one for like a you know some time you pay to appear guy let's say if you're a maintenance like this I'm just giving an idea now not taxable and repute like this right okay all right I'm gonna go to sales receipt now okay I'm gonna go to new on or I was a say sales summary okay I'm just gonna use not taxable so this one okay let's see if I said I went all sales and then you use a couple of bucks to buy meals entertainment all right so since this 50 bucks like this and fifty bucks for some repair guy I guess right and the rest you got to pay me let's say oh I also say yeah cash memo this totals to zero right so this is our God you know you have traveling at all sells and out of that you you know you bought you $50 for meals it could be supplies you know it could be anything you know whatever you have that you just create a new Idol listing here I don't Wes and make sure it's expense and when you when you when you create a sales summary then it's basically the negative touch expense and yet your cash and yet so this is all you got to do right so if you go to P&L you should see that hundred all expense paid $50 for meals $50 prepared right all right so that's so basically you know you don't want to expand too much but if you have you know use casts or something for office expenses type then you have to create items like this one other charge select account and just save it that's all okay so that's to do this for video files helpful and always visit our website there's our website QuickBooks new cottage calm and all kinds of videos and stuff you know all right thank you for watching bye