Newsagent Account Management System - System with Reports tor managing Customer Accounts

This project was awarded to winnet21 for £250 GBP.

Get free quotes for a project like this
Employer working
Awarded to:
Project Budget
£20 - £250 GBP
Total Bids
Project Description

I am looking for a software which is both easy to use and accurate. The software will be used daily and the main aim of it will be to fully automate the calculations and the creating of Invoices for certain customers that the Newsagent (A local Shop which sells Newspaper/Magazines/other items) [url removed, login to view] the Newsagent must carry out all tasks using paper and therefore is susceptible to loss. Also all calculations are done manually, so there is a high possibility of [url removed, login to view] proposed software should fully automate the calculations and the creating of Invoices

This software will be used for creating Invoices for 2 types of Customers that a Newsagent (Local Shop)) deals with, these are Newspaper and Business Customers.

Newspaper Customers have an order of Newspapers or Magazines which is given to the Newsagent and the Newsagent delivers the Customers orders on the specified days. The Customer is then sent an invoice for the Newspapers/Magazines with a delivery charge added. The customer can also add misc items to their bill. The customers can book 'Holidays' where they do not want a delivery, this should be taken of the invoice. Also customers can provide vouchers which can be used to pay for titles and this effects the bill too. Also manufacture issues should be maintainable so that customers are charged correctly.

Business Customers are local businesses which hold an account with the Newsagent. These businesses can put items onto the account and the Newsagent will bill them for these. The business can pay in full amounts of part-pay their bill so a 'live' account balance should be shown.

Software should also be able to backup/restore data, Manage user accounts amongst other functions

There are about 15 reports required in total. Most are based on the Customer/Business details and their Invoices, there are also some to aid the Newsagent with daily/weekly tasks. Reports should be well laid out and have all the required information. Also paper usage must be kept to a minimum so printing multiple invoices to a page is [url removed, login to view] reports should have customisable fields which can be maintained from within the software.

Other Requirements / Information
•Weeks run from Monday to Sunday,•Currency in pounds sterling,•Date formats in DD-MON-YYYY,•Time formats in HH24:MI:SS,•Language in English UK

•Offline system needed
•Software/database should be able to run smoothly on a Windows PC/Laptop without the specification being too high, good specification is provided
•No additional software needs to be purchased, use of free software only
•PC/Laptop will have Windows, Office 2007, IE Explorer (no internet connection)
•MySQL database is pre-installed on Test PC so this would be the ideal database platform, however other DBs are welcome
•Excel sheet with screens designed in VB attached. Optional to use.
•PC has TeamViewer installed and this is the preferred mode of data transfer

•All bids must be carefully placed taking into consideration of all points.
•Time scales must be carefully considered and adhered to strictly. The Client can test pilot software builds and provide feedback usually within 3-4 days of installation
•All bids must be final and cannot be increased once the project is taken on. This can change if the Client requests a major change.
•When placing a bid, the user must detail how they will look to achieve the project goals clearly
•The winning bidder must provide a terms and conditions document after having their bid accept. This document must have details with regards to the support of the software, the ownership of the software code, rights etc once development is completed. This must be signed and dated, and sent to the client

I have attached a full specification document along with the reports designed in Excel (All [url removed, login to view]). Also, I have attached the screen which are in the specification document in VB format ([url removed, login to view])

Good Luck!

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online