Billing Software with Ms Office 2016

How to create a simple POS (point of sales) system for small shops groceries and service centers using MS Excel

POS SYSTEM MS EXCEL NEW VERSION AVAILABLE TO DOWNLOAD

With this method, you can manage the following facilities without special software or expensive equipment.

v  Issue a sales bill using a bar code reader.

v  Manage purchases

v  Control inventory

v  Day end and month end stock balance.

v  Daily sales.

v  Daily purchases.

                                                          

You need little knowledge of excel macro to do this simply, otherwise, you can download

        $6,000+ In 1 Week... Here's How To Get Started...

first, create excel workbook with 6 worksheets for the followings like this:

1.       Bills

2.       Pur

3.       Purchase

4.       Sales

5.       Stock balance

6.       Setup

Next: 

Create a setup page with this headings and setup your stock items

Category : item category

Code : Create specific code for your each items. This must be unique ID no for each items and use this to create the barcodes. Exp:

According to this, take all the inventory items & create a code and update sheet with opening stock, pur.price and Seles price. You have to give the correct purchase price and sales prices because when you issue a bill, price will pick from this sheet. Opening balance will link with stock balance sheet.

You can download Bar code Generator or can do it Online.

Example for barcode I generate for sample file.

If you don’t have barcode printer just print to A4 Sheet and paste it to your Sales items.

Next