Need purchasing & ordering software RECOMMENDATIONS or Excel System - Small company


Source and recommend a simple and relatively low cost purchasing and ordering system / software for a small business according to the specification below. Alternatively outline a plan or proposal for a excel system that also meets all of the requirements below.


We currently have a relatively outdated purchasing / ordering system that is based around simple excel. The system is very time consuming, laboursome and has limited search functionality. We want to scan all paper copies of our invoices but store them digitally, and have the ability to search for these in the future, easily.

Please read the below information for a more detailed list of our setup and the requirements for a new piece of software.

We have:

• (Paper) Order Book with sequential numbers

• We place orders and receive inwards goods on one or multiple (paper) Packing Lists or shipping dockets

• This is followed up by a single (paper) Supplier Tax Invoice

We produce:

1. 1 x Excel spread sheet ‘Order Books’ and enter only the supplier, some brief key search words

‘Order Books’ achieves a simple searchable index for the books.

Order Number=Supplier=Key Product (word)

2. 1 x Excel spread sheet ‘Monthly Material Postings’. This assigns portions of the supplier invoice gross amount to individual ‘Projects’ or ‘Expense categories’

Eg. An invoice from XYZ Timber company may have a gross value of $100.00

In this spreadsheet we might attribute:

$20.00 to our project A

$20.00 to project B

$50.00 to project C

$10.00 to workshop maintenance

From ‘Monthly Material Postings’ we can extract monthly costs for current and past projects, expense categories etc

3. 1 x Excel spread sheet ‘Projects’. This assigns selected individual products from order books or actual suppliers invoices to our different projects.

Eg. Supplier Invoice from ‘Smith Ball Co’ for

6 x Blue Ball 150mm pn. 235 @$[url removed, login to view] $60.00

4 x Red Ball 100mm pn. 678 @$[url removed, login to view] $40.00

Into 3 x Blue Ball 150mm [url removed, login to view] to Project A

4 x Red Ball 100mm [url removed, login to view] to Project B

From ‘Projects’ we can reference important components for future reference.

After the purchasing department extracts the relevant data for the above spreadsheets from the Packing Lists and Supplier Invoices they are sent to the Admin department for processing and payment. At this point they are not readily accessible for future reference. Note also at this stage we have not recorded individual cost prices for products for easy future reference anywhere.

We wish to achieve:

All of the above spreadsheet information and additionally (and importantly) have the

• Scanned copy of paper order with Order Number

• Scanned copy of Packing List(s)

• Scanned copy of Supplier Invoice

• Reduce amount of input required and paperwork pile

• Increase search efficiency and usability

• Easy intuitive process

Attached together with searchable key Items

Note: With a basic operational, searchable system more than likely ‘Order Books’ will become obsolete.

Skills: Accounting, Excel, Software Architecture, Software Testing, Web Hosting

See more: online ordering system template company website, small home care companydevelop simple medical software company nurses staff forms havedownloading forms staff click type, accounting system project small company, ordering system different company, projects database system music company, airline reservation system small business, small company web page, operating system selected company use 250 computers, small reporting excel, sms food ordering software, client management system advertising company, project online reservation system transport company, drupal small company, print shop ordering software, simple data sheet company excel

About the Employer:
( 0 reviews ) vaijapur dist Aurangabad, India

Project ID: #11747601

9 freelancers are bidding on average $193 for this job


I am not able to send you messages because of this poor site. Can you please give your 5-kype name or e ma - il id

$400 AUD in 7 days
(14 Reviews)

Dear Valued Employer, I can add value to your project, by suggesting new ideas. I am fast and reliable. For further understanding why I am the right firm for your project, kindly check my profile, reviews, rating and More

$155 AUD in 3 days
(42 Reviews)

Hello, There is an open source software that has great purchasing and ordering modules: Odoo. There are many more modules that could help you out with what you are looking for. On the youtube channel of Odoo, you f More

$199 AUD in 3 days
(4 Reviews)

A proposal has not yet been provided

$277 AUD in 10 days
(3 Reviews)

expert of designing models on excel using macros. 5 years of experience.

$99 AUD in 1 day
(2 Reviews)

Hi, I am writing in response to your advertisement. After carefully reviewing the experience requirements of the job description it seems to me that my experience is suitable to match for the job. I have experience More

$250 AUD in 3 days
(0 Reviews)

We are a team of experts in developing excel softwares.

$166 AUD in 3 days
(0 Reviews)
$155 AUD in 3 days
(0 Reviews)

Hi, Your request project is nice and i am interested to work on it. Ive been using excel for 10 years now on my regular job, if you like you can check my profile. Ive been doing such kind of files on my job so i More

$35 AUD in 2 days
(0 Reviews)