In Progress

Stock and Accounts System

I am looking for a really easy to use stock, invoice and accounting program

I am not looking for anything complex, I don’t want SQL Server database – an Excel or Access platform is fine.

This is what I want to do:

1. Enter a stock item showing location, description, picture, department, sku, cost price, selling price (this can be manually adjusted when we invoice the customer in case we don’t sell at the price we put in at this stage – ie discounts)

2. Quickly do an invoice showing our details, LOGO, customer details, invoice number prefixed with 1077, pick the item from stock (database), be able to change selling price, show method of payment, show delivery address, have a section for the customer to sign on delivery, show a section to manually add delivery price. Free comments section is also needed to we can write notes. Invoices to be printed or sent to pdf so we can email

3. Stock transfer – if we need to transfer some stock (without sale, showing a reason for instance damage, stolen, returned etc), same as above.

4. Input all invoices for supplies such as goods, water, rent, rates etc (a full list will follow). So when we get an invoice we batch post from drop down menus (what its for, how it was paid.

5. All sales will be recorded when we do an invoice as shown above in number 2.

6. I want to be able to run the following reports

• Profit and loss account

• Directors loan account (when we pay for an invoice we either pay for it through our bank or directors loan account) – I want to be able to show a report on the level of the directs loan account at any one time.

• Stock report – everything we have in stock inc cost, purchase date, selling price, margin, picture etc)

• Sales for a period (showing % profits)

• Department sales (showing % profits)

• Location sales and stock (showing % profits)

• Department stock levels (show % of overall stock)

• Remember when doing profit and loss, we use the stock figure from stock bought to date less stock sold plus stock on hand. We don’t sell everything we buy in the same period as it was bought so we have to have a facility to show what we physically sell.

• All reports to export to excel so we can use the info as well as PDF

• I also want the option to show graphs so I can see performance etc

• User interface is to be like a windows program – NOT a spreadsheet.

• One user is fine

• Password protected

• Backup and restore from a flash drive

* A report on who we owe money to

7. Show our full details registration number, address, delivery address, website, email etc etc

Like I say it has to look like a windows program but run on access or excel. Easy to use, no VAT just goods in and goods out with basic accounts.

Skills: Data Entry, Data Processing, Excel

See more: customer account system excel, windows sql server cost, what can i buy and sell for a profit, use case levels, t accounts in accounting, t accounts accounting, t accounts, stock logo free, sql server price list, sql get date, sell through reports, sell through report, sale logo free, rent sql server, rent pdf, program to change system logo, picture of accounting, password protected excel, need of cost accounting, method to write a report, logo of accounting, list of accounts in accounting, levels system, level one bank, level 3 payment processing

About the Employer:
( 2 reviews ) stockton, United Kingdom

Project ID: #1099975

22 freelancers are bidding on average £217 for this job

spawar

Hi, I am ready to start work on this development, can discuss in detail through PM.

£250 GBP in 10 days
(45 Reviews)
5.9
mrbrave

See PMB for details please..

£250 GBP in 10 days
(100 Reviews)
5.6
gshiels

Please see PM

£500 GBP in 5 days
(12 Reviews)
5.1
ExactSystems

Please see detail on PMB. Regards

£250 GBP in 25 days
(5 Reviews)
4.6
binaryromel

########## Expert here! Please check PM. ##########

£250 GBP in 10 days
(13 Reviews)
4.3
ifaisal

Hello I can do this for you. Please see my private message for more details. Regards Faisal

£250 GBP in 14 days
(1 Review)
2.8
superMena2001

please check your PM

£230 GBP in 5 days
(4 Reviews)
2.6
AccuPro

Can do this.

£250 GBP in 15 days
(3 Reviews)
2.2
tpraigama

I am interesting for the above job

£300 GBP in 6 days
(0 Reviews)
0.0
luxman

Dear, i interest your [url removed, login to view], check pmb. Regards Luxman

£230 GBP in 10 days
(0 Reviews)
0.0
rcs49781

Can develop project in excel. have experience and time to do the job if exact information is provided

£35 GBP in 6 days
(0 Reviews)
0.0
sannandi

I am ready to make this in MS Access.

£32 GBP in 14 days
(0 Reviews)
0.0
GlazGo

Hello! I have the program you need. Details in PM.

£250 GBP in 5 days
(0 Reviews)
1.3
MagikSystems

We are the best in the business. Check us out!

£200 GBP in 3 days
(0 Reviews)
0.0
burhanameen

I have four years experience two years for audit and two years for accounts. I Have expertise in Peach-tree software and accounts management. I have completed two stages of ACCA out of Three I am offering my serv More

£300 GBP in 30 days
(0 Reviews)
0.0
pkudiabor

Hi there, I am a professional ~IT specialist and can easily do the job. I am sure I can help you with job, fast and efficient. Regards Peace

£150 GBP in 3 days
(0 Reviews)
0.0
kvenkat24

This is bid is made by taking the following parameters. You need reports for 6 months transaction.

£193 GBP in 8 days
(0 Reviews)
0.0
watermelon1

ready to start here

£35 GBP in 2 days
(0 Reviews)
0.0
sunipan4

can start at earliest, if given a chance.

£200 GBP in 40 days
(0 Reviews)
0.0
Dilipjaipur

Hello, use Tally Accounting System. You can maintain your accounts and inventory both there. Thanks

£20 GBP in 10 days
(0 Reviews)
0.0