If you run a mom-n-pop store and are looking for a simple application to print invoices and monitor inventory, then this template is for you. Just enter the codes and quantities of the items purchased and the template generates a professional looking invoice with a bill number, date & time, item count and amount payable. The inventory levels are also updated after every transaction, and the items falling below a specified threshold are highlighted for re-ordering.
You dont need any costly software to run this, just Excel 2007 with macros enabled.
Printed invoice sample
Sample stock listing
You can access the template here: Billing & stocking for Grocery store