Published on 08 Feb 2014 | over 2 years ago
Learn the easiest way to make simple retail billing software to create invoice for your store or small business do it in excel , No any programming skills are required. understand the concept of billing software and you can customize this as per your requirement by creating the formulas in excel in the easiest way . you can also print the retail bill on paper and give it to the customer.
Simple and Easy steps for creating a retail billing software in Microsoft excel .
Step 1 -- First of all open a blank ms excel page or work sheet . Draw or create the header section which includes the business name , address , contact number , vat number etc as applicable .
Step 2 -- Now create levels -- like -- SERIAL NUMBER , PRODUCT NAME , QUANTITY , RATE , AMOUNT , ETC. Color the levels name with suitable color to get a professional look.
Step 3 -- Set the desired formula for each automated calculations applicable such as auto sum , multiplication of rate and quantity , amount . for creating the formula watch this video , it just require to select the desired row with appropriate multiplication , summation , of division or percentage and again select the proper column.
Step 4 -- Now define the total formula by using the selection and summation soft key as shown in video.
This software made on excel software is used for retail billing , for calculating cash memo of general store , medical store , hotel bill etc. This bill can also be printed on A4 size paper .