(Using Excel)

How to create a POS system from an inventory list that have the following:

0. - Column to scan the barcode for all the products which are sold.

   • - Columns to indicate the name, quantity sold, sales price for all the products sold.

   • - Columns to indicate the total sales cost, tax amount and total amount.

   • - Columns to indicate card and cash payments along with remaining balance. (Sale can't be done if the remaining balance is greater than 0)

   • (You may use excel functions like unique( ), lookup( ), vlookup( ), sum( ), countif( ), if( ), round( ) etc. )

**The excel sheet should update automatically with new entries.**