Custom Quickbooks Costing Report
$25-50 CAD / hour
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.
Project ID: #4911663
About the project
Awarded to:
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
7 freelancers are bidding on average $37/hour for this job
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.
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
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