Käynnissä

Excel /electronic invoice and work flow project

The project is to build an invoice process form for approval purposes.

Function One:

The template receives a flat file feed of data which populates the invoice fields. The requirement is to put a template in place which automatically downloads the data from flat file files arriving by email.

The next function is to put in place a simple work flow process.

Function Two:

There is a field for the 'approver'. If this has a name installed, then the invoice should be routed to that person.

If it is blank it will go to the accounts department for this field to be filled in by a drop down box.

The invoice then goes to the approver where they can:

a) Change the nominal codes,

b) Change the cost centre

c) select tick boxes to approve or reject

d) Buttons which have three options: 1) Approve and send to Accounts Department, 2) Approve and release to the accounts package, 3) Reject, which returns the invoice to the vendor. There needs to be a text box created, adjacent to each line item, which allows the reason for the rejection to be stated.

Audit trail showing who took which action and date/time

e) A text box for the vendors messages

f) A text box for the users comments

g) A look up feature for a purchase order. This looks up the PO number field in the invoice and search a list of PO's and brings up the matching PO.

h) an automated PO lookup feature (each line item will have a PO number) which compares the line items/totals against the PO and changes the colour of the invoice field if they do not match.

Function Three:

The file is released into the accounts /ERP package. This will require an automated upload process.

Administrators Module:

Additional Fields: allow the administrator to add additional fields

Add users: import a list of employees, security/approvals levels and email addresses.

Security levels:

Users will have different levels e.g. approve invoices up to a certain figure, when they go over that figure they can approve but this will need further approval.

Some users will be able to release data directly to the accounts package others will not.

Access to management information

Other Lists: A module for importing the following

Nominal Codes

Cost Centres

Product Codes

user defined lists

Look up features:

example:

a) Product. The invoice arrives with a product name. If there is is no product number/ nominal code or cost centre, a lookup takes place to put the data in that field. If there is no match, the field changes colour.

b) default cost centre. The user needs to be able to set defaults for relationships between products/services/people for cost centres

We need to provide a simple way of customising the application so that organisations can add own logo. Ideally this will not have the 'look and feel' of excel but more of a stand alone application.

Interface to set up the receiving of data from the email.

Interface to set up the release of data to the accounts/ERP package

Management Screen: This allows users to view lists of invoices and set up reports. A number of standard reports will need top be built. e.g. number of invoices by data, vendor and cost centre. Rejected invoices.

Automated tracking and reminder process, which if an invoice has not been approved, sends a reminder email.

Proven track record, in this area, required

Taidot: kirjanpito, Excel

Näytä lisää: approval flow excel, invoice fields, invoicing project numbers, rejected invoice email vendor, work view, work search, we provide accounting services, we excel, view work, top work, top levels, top codes, time tracking project management, this is the flow, send an invoice, purchase order template for excel, purchase order number example, purchase order form excel, project work order template, project work example, product list excel template, people search work, need of cost accounting, need accounting services, need a audit person

Tietoa työnantajasta:
( 0 arvostelua ) London, United Kingdom

Projektin tunnus: #458636

Myönnetty käyttäjälle:

caratsnx

Hi,We have revised our bid. Looking forward for your positive reply

250 $ USD 7 päivässä
(0 arvostelua)
0.0

17 freelancers are bidding on average $379 for this job

laxmikutti

I will complete the project in 30 days with all your mentioned requirements. Please give me this project.

500 $ USD 30 päivässä
(0 arvostelua)
0.0
armkakohr

The project will be completed as suggested. I am an experienced programmer in VB, VBA, Microsoft Office and much more. Furthermore, it will be a priviledge to work with you. Awaiting your soonest reply.

400 $ USD 30 päivässä
(0 arvostelua)
0.0
latif11614

A competent professional with nearly 6 years of experience in the areas of Business Excellence, Business Process Management, Training & Knowledge Management.A thorough professional with a proactive attitude, capable of Lisää

300 $ USD 7 päivässä
(0 arvostelua)
0.0
pankaj1818

i can do it in the time give to u

438 $ USD 5 päivässä
(0 arvostelua)
0.0
cedmac

I am good at projecting is to build an invoice process form for approval purposes for your company.

555 $ USD 2 päivässä
(0 arvostelua)
0.0
onlinejobs526

Explain me what to be down

500 $ USD 7 päivässä
(0 arvostelua)
0.0
freeprofessional

Pls CHECK PM

250 $ USD 1 päivässä
(0 arvostelua)
0.0
javed78678

i will do it on time as soon as possible

300 $ USD 15 päivässä
(0 arvostelua)
0.0
maidaabbasi

Hellow i am professional cost and management accountant. I ready to work for you.

250 $ USD 30 päivässä
(0 arvostelua)
0.0
MdLutfarRahman

Hi iam expert in date entry,Excel/ Electronic Invoice. I also expert in Tally Software.

300 $ USD 7 päivässä
(0 arvostelua)
0.0
azufaaktar

Now I have done the work.

700 $ USD 30 päivässä
(0 arvostelua)
0.0
Khokon11

Hellow i am professional cost and management accountant. I ready to work for you.

250 $ USD 15 päivässä
(0 arvostelua)
0.0
mukhilchandran

hi i am chandru i have expereince in accounts more than 15 years i am curenty working as a account officer in private concern. i have very good exeprence in MSExcell. if i may get i share my expereince to your proje Lisää

400 $ USD 25 päivässä
(0 arvostelua)
0.0
cmendevil

i love this kind of job

250 $ USD 5 päivässä
(0 arvostelua)
0.0
monir57

dear sir, please give me a chance to prof my self.

250 $ USD 6 päivässä
(0 arvostelua)
0.0
Benardatelo

I am ready to do this project.I have a team of IT professionals in my IT firm( B;nacs co ltd)that does alot of this kind of job.I know given the job,your work will be done as schedule, will be delivery if needed even Lisää

550 $ USD 15 päivässä
(0 arvostelua)
0.0