Data entry and cost analysis on excel sheet

已取消 已发布的 Mar 1, 2011 货到付款
已取消 货到付款

We need a review of invoices our vendors have charged us. In some cases, our vendors have overcharged us for items we had agreed prices on, and in some cases our vendors have been inconsistent with pricing. The goal of this project is to come up with an amount that our vendors have overcharged us. We will need specific data on what was charged to us, and how much we were overcharged.

There are two vendors in question with about 1500 invoices total spanning 15 months.

We need someone to enter data from approximately 1500 vendor invoices. Each invoice will have entered into a spread sheet:

1. Vendor name

2. Vendor invoice number

3. Item number (product) and qty

4. price charged to us for item

5. Price we agreed to pay for item (from our vendor list, prices we agreed to pay)

6. How much we overpaid based on the above information, by item, and a total by invoice.

Invoices will be sent to you via a ZIP file, as scans, or we may grant access to our system for you to review the actual scans.

We are a company with 8 locations, so in instances vendors have charged two different amounts for the same item going to 2 different locations.

The attached spreadsheet has three tabs, one with a sample of what we need, another with the agreed prices and part numbers, and a third tab to enter items that we had no agreed prices on.

For items we had no agreed prices on, we will determine if there are pricing variations and then assume that the vendor price that is the lowest is what we should have paid.

会计 数据输入 虚拟助手

项目ID: #3138776

关于项目

27个方案 远程项目 活跃的Mar 30, 2011

有27名威客正在参与此工作的竞标,均价$131/小时

DenisSmolentsev

See private message.

$127.5 USD 在14天内
(15条评论)
4.8
ragastens

See private message.

$42.5 USD 在14天内
(66条评论)
4.9
LGLSoftware

See private message.

$204 USD 在14天内
(28条评论)
4.6
adriangafon

See private message.

$76.5 USD 在14天内
(32条评论)
4.2
yjh123321

See private message.

$127.5 USD 在14天内
(33条评论)
3.7
xcellentworks

See private message.

$72.25 USD 在14天内
(19条评论)
3.8
zshaan07

See private message.

$255 USD 在14天内
(6条评论)
3.0
ddukette

See private message.

$425 USD 在14天内
(6条评论)
3.0
masudcox

See private message.

$127.5 USD 在14天内
(13条评论)
3.1
sadaffarooqi

See private message.

$85 USD 在14天内
(8条评论)
2.7
bestwaytechvw

See private message.

$84.15 USD 在14天内
(12条评论)
2.8
akhan11

See private message.

$102 USD 在14天内
(7条评论)
2.6
hafizzeesha

See private message.

$127.5 USD 在14天内
(6条评论)
1.2
ontun

See private message.

$68 USD 在14天内
(3条评论)
1.3
mvolz

See private message.

$250.75 USD 在14天内
(2条评论)
0.6
alvacebu

See private message.

$212.5 USD 在14天内
(1条评论)
0.5
engwaelvw

See private message.

$70.55 USD 在14天内
(0条评论)
0.0
citcltd

See private message.

$85 USD 在14天内
(1条评论)
0.0
dbor

See private message.

$25.5 USD 在14天内
(0条评论)
0.0
webdevelopers110

See private message.

$18.7 USD 在14天内
(0条评论)
0.0