Basically, I own a Resale Store with multiple vendors. Each vendor has an ID# on their product. I need a cash register program in Excel that will operate like a regular register, print receipts for sales, and record the sale data which can be recalled later and sorted by vendor, daily sales, weekly, etc...
The register needs tabs to access register, vendors list, sales data
The vendor list will have links to individual vendor pages showing the sales for that vendor
I know there are a lot of excel sheets out there that do this, but I need one specifically for me. We do NOT do inventory, so the register input will be (Vendor ID#) then (Product Description), (quantity), (Discount if any % or $ off), and automatically calculate sub-total, tax, payment received, and then change due.
We do accept credit cards and checks, so payment type needs to be recorded as well.
This job will obviously bring you MORE work as we develop and fine-tune the software for our growing needs.
I have a very detailed description of everything I need, and communicate very closely with developers, so if you have the experience with excel and databases, you should be able to create this without a problem.