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.
13 freelancers are bidding on average $178 for this job
Microsoft certified Office expert here. What you described can be accomplished efficiently with a database rather excel. A database allows you to marry vendors, products, menus in a robust application. See PM...
I can create your register no problem. We could also add a database function as a tab to track your sales, just an idea. Would love to work with you. Message me if you want sample work.