Custom Quickbooks Costing Report

In Progress Posted Sep 9, 2013 Paid on delivery
In Progress

Subject: Custom Quickbooks Report to look at the Historical Costing of Assemblies

Report: Goal is to create an organized report with Quickbooks that helps us cost one to several assemblies based on Vendor Bills or issued Purchase Orders.

Input: Assembly number or number(s), date range (like Quickbooks ie. Last Quarter, Fiscal Year, or Custom etc.), and Based on Vendor Bills or Purchase Orders

We will enter Assemblies into Quickbooks per the attachment ([url removed, login to view]), The Assembly will be an Inventoried Assembly and the parts will be created as a BOM's. The BOM items will be entered as parts into QuickBooks Item list as Non-Inventory Items.

A607L01 BOM's:

2607L01

2607L02

ETC.

Sample Output:

Cost Report

Assembly Number: A607L01

Description: 4.5" Harrier Shifting Tool

From: Vendor Bills or Purchase Orders (Depending on selection - if possible)

Part Number 2607L01

Date Vendor Description Qty Cost

1/21/12 XXX Manufacturing 4.5" Guide Ring 5 $50

1/21/13 XYZ Machining 4.5" Guide Ring w/ Material 3 $75

Part Number 2607L02

Etc. Etc.

The goal is to create a report that pulls all the historical data from Purchase Orders and Vendor Bills for all the items that make up an assembly, as determined by the BOM entered into Quickbooks. It will list all the costs for each item by Vendor to see the historical cost trend of the items/parts.

Intuit QuickBooks

Project ID: #4911663

About the project

7 proposals Remote project Active Oct 1, 2013

Awarded to:

laconsultant

I'm a versatile IT consultant with deep accounting and operations management experience. I have wide background in cost accounting and unit pricing. This appears to be a fairly straightforward project that I can turn a More

$50 CAD / hour
(0 Reviews)
0.0

7 freelancers are bidding on average $37/hour for this job

consus

Hello Sir Please check inbox for bid details. Thanks

$38 CAD / hour
(30 Reviews)
7.1
pawankhurana

Hi Let the expert deals with it Check Pm for more details regards Pawan

$33 CAD / hour
(7 Reviews)
3.3
thindo

Dear Steelhaus, I have gone through the project details. I have very good experience in QuickBooks accounting system. Its one of my regular work. Hope to hear from you and looking for long term relationship.

$38 CAD / hour
(0 Reviews)
0.0
balajishripatwad

Kindly read private Message

$27 CAD / hour
(0 Reviews)
0.0
arnab304029

Hallo, I am a chartered accountant from India. I am really good at working with quickbooks and iam working on it for last few years. As you would know that i hold one of the best accounting degree of the world, courtes More

$33 CAD / hour
(0 Reviews)
0.0
Bookkeeper2013

Hi, I have over 8 years experience in QuickBooks and Accounting and have worked on lots of QuickBooks reporting. I can do this job perfectly on time. Thanks for this opportunity

$41 CAD / hour
(0 Reviews)
0.0