Penny Press Machine Vending Database

My business involves owning and operating Pressed Penny Machines VENDING MACHINES) which are located at various tourist locations around Australia.

Some locations have multiple machines.

In each state (Queensland, Victoria, Western Australia etc) there are contractors who, each month, collect the money and service the machines in their region. Each machine has a digital counter which counts each time the customer inserts their money to use the machine. Some machines are a $2 vend price for the customer to use. Some machines are at a $1 vend price.

Each location is paid a commission for sales from each machine that is at their location. The commission rate varies from location to location.

Some locations collect the money due to being in a remote region and so they issue us with the sales amount and then we send them an invoice for our share of the income.

I need to issue invoices to each location which gives them all of the details for the collection from their machine/s. It would be very helpful if this database can be linked to the accounting package of MYOB.

Also, I require to access reports regarding the sales of each machine...or each location (multiple machines)...or each state or region...etc

Reports are required:

for each MONTH; each QUARTER; each YEAR for

each machine; location; region; state; total

My website is [url removed, login to view]

I would like this database to be attached to my website and to be accessed via Login (username and password)

We need to be able to add new locations or delete locations. Information about each location should be entered such as:

Business Name



Contact Name



Commission %

Machine/s Names


Each contractor or location should have a unique login and password and will only see their own machines.

Collection Data which will be input by the various contractors or locations:

Date- this is the date they visited the machine to collect money

Counter Reading- They read the electronic counter on the machine. The database should retrieve the previous counter reading and give a total vend count (the difference between previous reading and the current reading)

Actual Cash- The amount of money counted. The contractor usually counts the cash off-site (at home)

Difference - The database needs to calculate the +/- cash amount or the difference between the counter reading and the actual cash counted.

Test Vends- The number of $1 or $2 coins put thru the machine for testing purposes which changes the counter reading

Refunds- Any refunds given to customers by the location...then reimbursed by us.

Comments- This is used by the contractor to report any information back to myself regarding the location or machine such as faults or issues requiring attention.

Service Data- This could be a different section that could be used to record any service data for each machine. This would be like a service log. It could record any work performed on a particular machine. Time spent by the contractor. Parts used. Faults recorded etc.

Invoices- At the end of each month I am required to provide an invoice for each location. This invoice would have all of the relevant information from the Collection Data. This should be linked to MYOB accounting package

Payments - the commission percentage that a location receives varies. The payment amounts need to be automatically calculated for each location.

Reports- I require the following reports

Sales Reports

Each Machine

by Month

by Qtr

by Year

Each Location

by Month

by Qtr

by Year

Each Region

by Month

by Qtr

by Year


by Month

by Qtr

by Year

Payment Reports

by Month

by Qtr

by Year

by machine

by location

by region

by Total

It would be good to be able to pull out reports by inputing dates or selecting fields etc.

I would also like to be able to look at Graphs etc relating to the above reports.

Please read the project first and write your steps and suggestion with short description.

Compétences : Microsoft Access, MySQL, SQL

en voir plus : vending machine database, penny press machine, vending machine access database, used vending machines penny press, database project vending machine, penny press machine locations, database vending machine, www work from home com au, www graphs, work western australia, work in western australia, work in victoria australia, work in remote australia, work in queensland australia, work from home in accounting, work from home customer service phone, work from home business australia, work from home au, work from home accounting, work for microsoft from home, work at home for cash, work at home database, work at home customer service, work at home australia, western australia work

Concernant l'employeur :
( 91 commentaires ) Cairo, Egypt

Nº du projet : #1613467

5 freelance font une offre moyenne de $224 pour ce travail


Sir, I have expertise in Database application development,plz read pmb for more detail. Regards,

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(0 Commentaires)

I can help you with this project but require some additional information, regarding MYOB and how this is conected to the database. and what type of database are you using?

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)

Hi I have read your project specifications. I have experience of doing such projects. Please read the private message. Warm Regards Mohit Softprone Technologies.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)

Interesting project and reminds me of a previous project for company that installed "kids friendly" shopping carts in US dept. stores! Look forward to doing a rapid application prototype for you to load up on your webs Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(0 Commentaires)

<b><i>Removed by Admin</i></b> - Custom software development - skpye: <b><i>Removed by Admin</i></b>

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)