QuickBooks Historical Inventory Reconciliation Specialist

via Freelancer ·

Budget / Salary$250–750
TypeFreelance project
LocationRemote
Posted1 hour ago
We are seeking an experienced QuickBooks Online Inventory Accounting Specialist to perform a historical inventory reconciliation for a Canadian company that purchases bulk raw materials and converts them into finished products.

The company uses Salesforce for operational inventory and sales, QuickBooks Online for accounting, and receives separate Amazon FBA inventory reports.

Historical inventory quantity adjustments were used to correct finished-goods SKUs showing negative quantities in QBO. We need an independent specialist to determine whether the QBO Inventory Asset balance is supported by the inventory subledger and actual inventory records.

Initial scope:

Reconcile QBO Inventory Asset General Ledger to Inventory Valuation Summary and Detail.
Review historical Inventory Quantity Adjustments and Inventory Shrinkage activity.
Analyze year-end inventory journal entries for 2024, 2025 and 2026.
Investigate an unreconciled historical Inventory Shrinkage balance.
Determine whether direct journal entries caused differences between the General Ledger and inventory subledger.
Reconcile QBO to Salesforce, physical counts and Amazon FBA reports.
Review the accounting flow from bulk raw materials to finished goods.
Identify negative inventory, timing, costing and unit-of-measure issues.
Recommend corrections without posting or modifying transactions.
Design a documented monthly inventory reconciliation process.

Required experience:

Advanced QuickBooks Online inventory accounting.
Inventory subledger-to-General-Ledger reconciliations.
Negative inventory and FIFO costing.
Manufacturing or production inventory workflows.
Inventory quantity adjustments and year-end true-ups.
Experience reconciling inventory across multiple systems.
Strong Excel reconciliation and working-paper skills.

Deliverables:

Written diagnostic report.
QBO Inventory Asset versus Inventory Valuation reconciliation.
Historical Inventory Shrinkage and quantity-adjustment analysis.
Identification of unsupported or unreconciled balances.
Proposed correcting entries, if required, with financial-statement impact.
Monthly inventory reconciliation procedure.
Clear management summary suitable for the client and external accountant.

Important:

This is an investigation and recommendation engagement.
No transactions may be created, edited, deleted or posted.
All proposed adjustments require written approval.
All company information must remain confidential.

Please describe specific QBO inventory reconciliations you have completed, particularly involving manufacturing, negative inventory, Salesforce or other operational systems. Please do not submit a generic bookkeeping proposal.
accounting excel inventory management salesforce.com myob financial analysis bookkeeping xero data analysis
Apply on Freelancer →

Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.