Transaction accounting software required to calculate and administer the buying and selling of Gold. This is currently achieved using an excel spreadsheet as attached with each transaction then manually stored.
Required is an application that aims to achieve what the spreadsheet does but goes further and able to STORE each transaction input.
Basically the following steps;
1) Input variables
2) Do calculations
3) Store Transactions
4) Produce Reports
This application should be simple but effective at doing the basics well and able to add future features like a feed with exchange rates and spot gold price.