Expense Tracking - Wholesale Purchases.
I am after an application/spreadsheet to help me track the wholesale purchases I make on a weekly basis. I purchase in excess of $30k produce (Fruit & Vegetables) from the markets from multiple vendors, paying via multiple ways (Cash, Credit, Cheque, Account) and the stock is of several sizes (Box, Tray, Pallet, Bin etc).
I have purchased an iPad and researched several expense management applications however none of them are simple enough to satisfy my requirements.
I would like to use this iPad to operate the spreadsheet for ease of access whilst at the markets. I am after a freelancer who can write the required spreadsheet or recommend an alternative way for me to achieve my requirement. This Spreadsheet/App should include:
- Easy Interface
* Able to quickly select multiple variables (Drop downs & Autocomplete) such as Vendor, Product, Size, Payment Method and any else I specify
* Simple way to add new vendors, products
* On a seperate sheet, Report on purchases for the week and methods of payment etc w/ Outstanding balances.
I have purchased the "Docstogo" application for the ability to read MS spreadsheets etc. I don't want to "over complicate" this project. Happy to discuss requirements/progress and the variables I am after as it is delivered.
Should not take to long, Happy to provide further information on request.
**UPDATE** - This simple expense tracker needs to be functional on the iPad. The iPad does not currently support Visual Basic or simple VBA such as "Drop-Down" menu's etc. Freelancer will need to have an idea on how this can be achieved!!