Collaborate on Printable Private Car Sale Receipt Template for Inventory with Ease Using airSlate SignNow

Printable private car sale receipt template for Inventory

hey guys so in this episode i will show you how to create this simple pos system in your mobile or in your laptop it's uh you can see it's a basic option i mean it's very simple to do you can use this in your small business let's say a coffee shop or a small restaurant wherein you can place an order then you can add an item and review it this can be used in mobile or a desktop you can repair your order so i will show you how to do this simple eos system all right so the first thing you need to do is we need to create a database in order to do that you have to use the google account let's say the gmail all right so you have to go to your google drive okay then we have to create a new spreadsheet okay go on the left side google sheet all right so you can you can make a title let's say i want to make a title my coffee shop okay let's make this my coffee shop right so the main thing in the system is first we have to create our products or our let's say menu okay then what you have to do is to put here let's say you can make a column uh here let's say you can would can place a category then second column let's say item name you can also put a bar like a code so in this case we will not do that and item name unit price and you can put let's say an image okay then you can put as well a description all right and then you have to add another tub we have to make our you know when you want to make an order like to punch an order so you can make another tub we make it as order form so in this case i mean in this one we have to put the important in the order is the date then you can put as well a time then what is the item item name and the unit price for that or let's say we can add a receipt number you unit price and quantity of course and then the total amount so this one is single item pos system okay so if you wish to add let's say uh you can put like 20 items so you can create like like this you can copy this and put paste it here so on and so forth yeah so in this case we'll only make a single item pos system all right let's go back all right okay this is a single item only okay you can also make yours like let's say multiple items then you can put the payment here then payment you can add as well discount if you like discount tax or goes like that okay we don't do or tax then you can put change or payment type first then change you can wish to add as well more items like tax the share name goes like that or customer name so let's make it simple okay then once you finish this you have to go to up sheet all right so here is the up sheet close this one okay go to up shift so we are done for our simple database okay it's very easy only then you have to go to my apps then make new up start with your own data let's say my coffee shop okay then category i will do this sales then choose your data then my copy shop select it all right just wait while it's loading all right so it's load already just close this one all right here we go then you go to this left side there is a data menu the first thing is uploaded is the side the first table this menu so in menu you have to click this one all right here is the category so i wanted to make a category so you have to put in new then goes like that click the one add let's say you want to add a hot drink then cold drinks then pastry okay i should like you can add some category okay then all right item name you can put it as text no problem or then the key is this one it makes this key unit price click this one select how many decimals let's say i want to put the three what is the currency let's say i put us dollar we are all good for that image of course an image no need to do that then description you can put long text so we're done for that all right then we have to add another table which is our new table we have to add the click this one my coffee shop then we have to add our order form so you have an option if this can be deleted can be added so this option is we can delete it's fine okay or read only i should like so in this case i would just suggest you can make an update you can add and you can delete add this table let's review this one other form all right all right so then you have to review again the order form view columns then date the date is correct you click this one and then use long date format okay you can also add a formula let's say every time you open the order form i want the date to be set by today so you have to put today like this and save it all right then time you can ignore seconds also here you don't want too much long receipt number i will show you later how to customize your receipt number let's say a serialized receipt number you can do that as well item name it's fine unit price click this one i want it in three digit and a us dollar so it's automatically here you can choose also i should like then quantity or it's a number of course just i don't like this like with comma payment type payment i mean it's a price as well so i can put three digit and us dollar then also the payment all right for the payment type we will make it as inum this one so you can decide whether you want it by the values cash card i should like okay change of course this is the customer change you put it as price then click this pencil 3d select currency i want it this one and click all right so we are done for this click save all right so there is like a warning date cannot be used like this so it goes like that ignore it all right then we go to eux you have first go to menu aux you can choose the view type calendar deck table gallery you can choose that one you can choose the location okay we can as well preview your application here we will preview the application that you are creating now so still no so this is the two all right let's continue so i want to sort it by item name it's fine so i want to use card view category it's fine it's fine all right let's leave it that then we go to the order form the order form i want to use it as a let's say a table view okay then i want to put in the right sort by item name it's fine or you can sort it by date and then group by or group by date then group aggregates i want to see the income all right where is it some then you can also change the display as you notice the display is nothing here right so you can change the display let's say order let me see if there is any card here new or this one i'll use this one okay and also i want to change also the menu as you can see there is no icon so the menu i want to put go to display let's say coffee do we have yeah coffee what is this one all right when i save it goes like this let's go back here see it's changed already both the then what we will do so this is pretty dull there is no color uh i want this to have a design see there is no design it's pure white then what you will do go to aox go to brand so i wanted something darker i can call this dark then i want to change the logo so for the logo guys you can change it easily you can simply go to google okay let's say i want to use the logo of starbucks starbucks okay so go to images okay so in the images let's say i want to use this logo okay what i will do i will just right click copy image address you put it here custom go back there select all save let's try i if it's working the logo should be let's sing the application see it's become dark now you can add some colors also so this is my starbucks logo all right then i want the background let's say i want to make see i want to have like a background so you can also let's say i want background of costa all right so i want this background for example what i will just do is which one the nice one let's say this one right click copy image address go to brand background custom paste the url and also launch in uh late let's let's do one by one for you to understand all right so as you can see we will refresh this one all right let's say i want to add an order there is a background you can see all right now what we will change is this white launch image so we can also change that one let's say i want to what is caribou let's say the launch image is this one okay copy image address go here lance image custom delete this uh url and paste the one and click save all right let's try now let's try should be change yes it goes like that so now i want to add a menu so we are good for this all right i want to add the menu just click plus sign what is the category let's say hot drink what's the name americano price let's say two dollars i want to add an image so if you're using a smartphone it can be goes like this and it automatically opens the camera since i'm using a laptop so i will upload the image i already downloaded some from google open it and description you can add description i should like and save it fresh so we created our first uh menu or product okay so there is no image here i mean yeah it's showing now then i want to add an order so i want to click order and plus sign all right so there is a date time receipt number let's say receipt number it i mean it will automatically created no need to type but this time for the sake of this video to create up we will just do it manual let's say one item name i want this item i want this item this this menu going here so what we will do we will just do like this go back to order form we will do some formula so go to item name make it as ref reference ref okay then select the table menu okay then done make sure that the key column and menu is the item name then i want as well when i make an order when let's say i want to make i want to order x americano the price is automatically coming here okay here so we have the price right price for that i want it to go directly here so what we will do as well we go back unit price we can add the formula so you can all right guys so what i want is uh when i order americano the price should should be automatically in input here like auto populated so in order to do that i have to go back to my app editor first thing you have to go to order form find the unit price so you have to put a formula for that to do that go to auto compute go to a formula you can make a formula like any then select what is the table name the table name is menu what is the column name it's uh unit price the unit price okay we're in this row let's say when you go here you make an order so this row under this row close it that item name when you say item name this item okay is equals to the item name in the menu okay item name then double double parenthesis then should be work if it's green meaning it's correct save then let's go to our application doesn't show right now what we'll do discard it refresh the application then go to order form like this let's say i want to order americano the price is auto automatically coming correct then i want to add one to americano so there should be like a total here so in order to do that you go back to your application go to total we can apply a formula again so the total we will change it to price and i will make it as three digit and us dollar so you have to add the formula so go to auto compute go to a formula so i want this column uh this quantity look for it multiply asterisk multiply by unit price so if how many this one how many how many quantity it will multiply automatically then let's try if it's working yeah all right go back here refresh this system order form i want to have an item name it's americano there's no total right i will add let's say two so it's correct it's correct correct then the payment here we go for the payment if customer pay let's say the total is six dollars and he paid 10 there should be a change of four right so it doesn't reflect same uh so what you will do is go back again there go to change put a formula auto compute then what you want is so we will do subtraction correct so look for the total minus minus the payment okay so let's try now done save it refresh the application we will change later on the picture is kind of blurry so here again i want three so the payment should be so the change so it's showing like this so it's showing again change so what we will do to avoid this showing still within a payment and he has to change as well of six dollars to avoid that go to change change column show click this one so we will only show this column so you go to this row if it's like uh if the payment is not blank so we'll put is not blank then show you can only use this blank payment okay so if the payment is empty so the change column will not show so let's try all right let's go back refresh again so order form let's go here so let's say three so see you cannot see the change column when you add the payment then yes did you see it's four dollar change okay so i want also if i order americano i want to see the picture we can do that also all right so what you will do go back to your uh order form you can add a virtual column okay so you can just name it as uh photo whatever you like we need to add a formula okay same formula with the a unit price you can go any select this time um i want to select the column here you can see it's what's the name in your database it's image so i want to put it as image okay just wait okay we're in this row this row that item item name is equals to the item name of the menu okay then let's try okay then let's try [Music] let's refresh once again let's make a new order seat number one for example americano so i will order let's say 2 2 10 so you can see there is a photo but i want something like a writings here how many i ordered let's say i ordered two it should be times two here okay so in order to do that it's simple go back to your here to the photo you can add the display name so we're gonna use the we will use a formula okay so the formula for this click this display use concatenate [Music] this is like merging text so i want this uh double quoted times so comma i want the quantity so let's say uh quantity times three then tama then i want the name of the of the order so double quoted let's say i want to put a dash sign double quoted comma then i want you got to go to the item name where is the item name that's and then you want to display the price it's fine you can do that so double quoted dash then go to the total amount total column so it will summarize click save save it okay then let's try the this thing it should be working order then item name quantity 2 for example payment 10 cash see two times americano but the problem is just saying four so in order to solve that you go back to your uh order form table go to the virtual column portal you can go to your display as you can see it's just i want it showing like four dollars so go here so i want to add in the the last portion i want to add so double quoted text dollar sign double quoted then come close dip okay so let's try go back there let's refresh this one okay let's make another order one item quantity two payment is ten all right see it's showing two times americano at four dollars correct so once you save it refresh it upload you can also uh if you want like an auto saving you can i mean once you save it it will upload automatically you have just to go to your here behavior offline scene this delayed scene um remove the delete sing and save all right so here i have an income of today february 12th four dollars if you wish to edit it you can edit the order if you got mistake like this okay and also this this is how you do it all right so now you know when you make an order i want the receipt number to be automatically populated so what you will do goes like this go back to your database click on i mean make another table so i want this table named as receipt number so in the receipt number you can just put here receipt number that's all you have to do then you have to make a formula so in the google in the spreadsheet you have to click you have to type equals then query then go to menu i mean to order form this side okay so a2 a2 remove this segment close it okay then format this one as number okay what happened why it's too much wait so order receipt number is c so we have to change it to letter c c okay there we go so i don't want it like a double digit i want it only like single digit only this all right go back to your app you have to add a new table new table sheets in google drive then go to your my coffee shop app i mean database select receipt number in this case i want it only to be read only so i don't want to edit it add this table all right then in order to make the receipt number serialize you go to your order form here view columns go to receipt number so receipt number i don't want it to become i don't know why it's showing ref it should be not it should be showing only like number convert it into number um then you go to uh auto compute you go to initial value then we have to create a formula so the formula for that is you type max max means it will find the maximum number to the designated table the table name is received number correct receipt number then put the column which is the column is the receipt number also here this is receipt number and this is the table this is the column name go there receive number make sure the spelling is correct same name with the table and the then close it plus one then close all right now let's try this formula just a second so it doesn't it's invalid so you can put another one here all right let's save this and try the so now as you can see we have number one receipt so when we make a new order it should be number two the receipt number now we will try all right let's make a new order so see it's automatically coming number two all right so that's how this uh application work it's very simple to make you can also add some twists like reports or design as you like okay so how to change this color if you don't like this color just just a quick recap go to aux ux brand let's say i want the color i want it like this full and then the color i want let's say different let's say orange okay i want to do like that you can choose this one and save it will change the color but it's a dark mode yeah you can check okay let's see if it's applied already see it's applied actually like you can do and also i will show you in the mobile application how this works um so guys this is how it works in mobile as you can see it's very simple to do in mobile as well as you can see a good item name americano and it shows here okay and also i think we know it's very simple you can just click the plus sign then um with menu plus sign item name add drink for example let's say latte unit price let's say one one dollar then the photo image you can just click camera and you can directly take a photo as you can see fix that [Music] and click save so that's how it look likes in mobile and i hope this helps you a lot and i mean you learn something in this video and please share your feedback at the comment section and thank you so much for watching