How To Create A Retail Point Of Sale System With Excel 4 Steps

Create Excel workbook with 6 worksheets for followings steps like this:{“smallUrl”:“https://www. wikihow. com/images/d/db/18TODAY. png”,“bigUrl”:"/images/thumb/d/db/18TODAY. png/386px-18TODAY. png",“smallWidth”:460,“smallHeight”:31,“bigWidth”:386,“bigHeight”:26,“licensing”:"<div class="mw-parser-output">

Category Code : Create specific codes for your each item. This must be a unique ID number for each items. Use this to create the barcodes. {“smallUrl”:“https://www. wikihow. com/images/thumb/6/60/20TODAY. png/460px-20TODAY. png”,“bigUrl”:"/images/thumb/6/60/20TODAY. png/640px-20TODAY. png",“smallWidth”:460,“smallHeight”:109,“bigWidth”:640,“bigHeight”:151,“licensing”:"<div class="mw-parser-output">

License: <a target="_blank" rel="nofollow noreferrer noopener" class="external text" href="https://en. wikipedia. org/wiki/Fair_use">Fair Use</a> (screenshot)
\n</p></div>"} According to this, take all the inventory items & create a code and update the sheet with opening stock, pur, price, and sales price. You have to give the correct purchase price and sales prices because when you issue a bill, price will be selected from this sheet. The opening balance will be linked with the stock balance sheet. If you don’t have a barcode printer, just print the receipt to A4 Sheet and paste it to your sales items. Create a Stock balance sheet: Create this sheet with below headings: {“smallUrl”:“https://www. wikihow. com/images/thumb/5/59/21TODAY. png/460px-21TODAY. png”,“bigUrl”:"/images/thumb/5/59/21TODAY. png/596px-21TODAY. png",“smallWidth”:460,“smallHeight”:175,“bigWidth”:596,“bigHeight”:227,“licensing”:"<div class="mw-parser-output">

License: <a target="_blank" rel="nofollow noreferrer noopener" class="external text" href="https://en. wikipedia. org/wiki/Fair_use">Fair Use</a> (screenshot)
\n</p></div>"} Copy this formula to each row and copy paste to down: Code: =IF(setup!$B$3:$B$323"",setup!$B$3:$B$323,"") Description: =IF(setup!$C$3:$C$323"",setup!$C$3:$C$323,"") Opening Balance: =SUM(IF(B3=setup!$B$3:$B$1021,setup!$D$3:$D$1021)) Purchase: =SUM(IF(B3=purchase!$B$2:$B$2005,purchase!$D$2:$D$2005)) Sales: =SUM(IF(B3=sales!$H$2:$H$2551,sales!$J$2:$J$2551)) Stock: =+D3+E3-F3

Create a sheet according to this format and give the below formula to each row and create macros with below codes. Line: =IF(C5="","",B4+1) Code: Create a list box link with setup page item code and name. when you connect a bar code reader with bar code sticker details will auto pick. Description: =I4 Qty : this column you have to enter manually according to customer purchase qty. Price: =IF(E4="","",VLOOKUP(C4,al,5,0)*E4) macro for Save bill Create a button called Save bill and copy this code: You can download this file form file Sub Dayendsales()’ ‘Dayendsales Macro Sheets(“Tsales”). Select Columns(“G:G”). Select Selection. Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove Range(“E2:E255”). Select Selection. copy Range(“G2”). Select Selection. PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ =False, Transpose:=False Sheets(“sales”). Select Range(“B3:D1572”). Select Application. CutCopyMode = False Selection. ClearContents Range(“D3”). Select End Sub Sub DayendPurchases()’ ’ DayendPurchases Macro’ Sheets(“Tpurchase”). Select Columns(“F:F”). Select Selection. Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove Range(“D2:D643”). Select Selection. copy Range(“F2”). Select Selection. PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ =False, Transpose:=False Application. CutCopyMode = False Sheets(“purchase”). Select Range(“C3:D625”). Select Selection. ClearContents Range(“E3”). Select End Sub Sub SaveBill()’ ’ SaveBill Macro’ Application. Run “‘shop sales control. xls’!copy” Application. Run “‘shop sales control. xls’!SaleReplace” End Sub Sub DayEnd()’ ’ DayEnd Macro End Sub

Now create the Purchase and sales data save page with this format: Sales data base