Order Tracking and Invoicing Spreadsheet

Order Tracking and Invoicing System

We built the Order tracking and Invoicing system for a film processing agency that wanted to keep track of their clients orders as they passed through their factory.

Information from the arrival package was scanned into the system and the relevant information extracted and stored in an Excel database.

The Order Input system

The first form is the ‘Film ordering System’ where the necessary information is input and stored.
  • Store name and ID
  • Order name
Then the order details such as :
  • Film type
  • Print size.
  • CD or print

The Order Invoicing System

An invoicing system was not on the original brief, but turned out to be a very welcome addition to the project.

“Many thanks once again for all your help, J is very happy with the spreadsheet, it makes his job a lot easier. If we have any similar projects in the future we will definitely be looking to use your services again.”