QuickBooks Desktop Enterprise Data Extraction
Worldwide
Here's the clean combined text, ready to paste: Title: QuickBooks Desktop Enterprise — Historical Data Extraction Description: Looking for an experienced QuickBooks Desktop Enterprise freelancer to perform a one-time historical data extraction from a legacy QuickBooks company file. This is not an accounting or bookkeeping project. Need someone with hands-on experience performing QuickBooks Desktop data extraction, migration, or integration work — not advisory or consulting services. A QuickBooks Desktop Enterprise company file (about 25 years) is now maintained solely as a historical archive. The goal is a one-time extraction of key transactional data and summary reports so that the legacy file no longer needs to be accessed. The company file contains approximately 25 years of history and is very large. Experience working with large QuickBooks Desktop files is important. Technical Environment QuickBooks Desktop Enterprise company file (about 25 years) Remote Windows access will be provided once a freelancer is selected; exact configuration will be arranged with IT support team Transaction Pro is a suggested tool but freelancers who prefer an alternative extraction method (QuickBooks SDK, QODBC, or other tool) are welcome to propose that approach instead Because of the file size, transaction exports may need to be performed in multiple date ranges and combined into final deliverables What I'm Looking For Someone with experience in one or more of the following: QuickBooks Desktop Enterprise Transaction Pro, QuickBooks SDK, QODBC, or similar extraction tools QuickBooks historical data extraction or migration projects ERP migrations from QuickBooks Please Include in Your Proposal Relevant experience with QuickBooks Desktop Enterprise Experience using Transaction Pro or similar extraction tools Your proposed extraction approach Estimated hours to complete the project Estimated total project cost Any questions about the scope before beginning Project Goal To produce a complete historical archive of the requested transaction data and summary reports in open, easily accessible formats — so that the legacy QuickBooks Desktop file will no longer need to be accessed for future reporting or research. Accuracy and completeness are more important than speed. PROJECT SCOPE OF WORK Project Background The QuickBooks Desktop Enterprise company file being extracted contains approximately 25 years of accounting history. It is maintained solely as a historical archive. The goal is a one-time extraction of historical transaction data and key summary reports so that the file no longer needs to be accessed. This is a one-time data extraction project, not a consulting or advisory engagement. Existing Archived Data The following master files have already been exported and do not need to be included in this project: Customer List Vendor List Item List Required Transaction Exports Export the following transaction data covering the entire historical period. Purchasing Purchase Orders (Header) Purchase Order Line Items Bills (Header) Bill Line Items Sales Sales Orders (Header) Sales Order Line Items Invoices (Header) Invoice Line Items Credit Memos (Header) Credit Memo Line Items Optional — include if available without significant additional effort Vendor Credits (Header and Line Items) Required Summary Reports Generate the following reports covering the entire historical period. Excel preferred. Sales Sales by Customer Summary — displayed by month, with monthly and grand totals Sales by Item Summary — displayed by month, with monthly and grand totals Purchasing Purchases by Vendor Summary — displayed by month, with monthly and grand totals Financial Statements Profit & Loss by Month Balance Sheet by Month Deliverables All transaction exports and summary reports described above, organized into a clearly labeled folder structure with separate subfolders for transaction exports and summary reports. Include a simple index identifying: File name Description Date range Number of records (for transaction exports) CSV format is preferred for transaction exports; Excel is acceptable if CSV is not available. Excel is preferred for all summary reports. Technical Notes Because of the file size, it may not be practical to export all transaction history in a single operation. Exporting in multiple date ranges (for example, two-year increments) and combining the resulting files into final deliverables is expected and acceptable. Transaction Pro license is a suggested tool. Alternative extraction methods (QuickBooks SDK, QODBC, or other tools) are welcome if the freelancer believes another approach is more appropriate. The objective is accuracy and completeness, not minimizing the number of export operations. Environment Windows workstation with remote access provided once freelancer is selected QuickBooks Desktop Enterprise installed Legacy QuickBooks company file available Proposal Requirements Please include the following with your proposal: Relevant experience with QuickBooks Desktop Enterprise Experience using Transaction Pro or similar extraction tools Proposed extraction approach Estimated hours to complete the project Estimated total project cost Any questions about the scope before beginning Project Objective To produce a complete historical archive of the requested transaction data and summary reports in open, easily accessible formats. At project completion, the legacy QuickBooks Desktop file should no longer need to be accessed for future reporting or research.
- Less than 30 hrs/weekHourly
- < 1 monthDuration
- IntermediateExperience Level
$8.00
-
$25.00
Hourly- Remote Job
- One-time projectProject Type
Skills and Expertise
Activity on this job
- Proposals:5 to 10
- Last viewed by client:2 days ago
- Interviewing:1
- Invites sent:8
- Unanswered invites:3
About the client
- USABlountville11:46 AM
- $470 total spent3 hires, 1 active
- Mid-sized company (10-99 people)
Explore similar jobs on Upwork
How it works
Create your free profileHighlight your skills and experience, show your portfolio, and set your ideal pay rate.
Work the way you wantApply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
Get paid securelyFrom contract to payment, we help you work safely and get paid securely.
About Upwork
- 4.9/5(Average rating of clients by professionals)
- G2 2021#1 freelance platform
- 49,000+Signed contract every week
- $2.3BFreelancers earned on Upwork in 2020
Find the best freelance jobs
Growing your career is as easy as creating a free profile and finding work like this that fits your skills.
Trusted by