Review inventory and cost accounting results | Pixie CRM Help Centre Canonical: https://pixiecrm.com/help-centre/inventory-and-cost-reporting Publisher: Pixie Technologies LLC Accounting & Bookkeeping · How-to guide Review inventory and cost accounting results Pixie CRM guidance. Follow the route for your workspace, check your role and enabled modules, and verify the result before moving on. Follow this guide to use ledger and financial reports to validate inventory, cost of sales and production or warehouse conversion results. Audience: Inventory finance staff; Feature: Inventory reporting; Module v1.4.5; Where to goAccounting → Reports (https://pixiecrm.com/help-centre/topic/report) and Accounting → Transactions → Warehouse (https://pixiecrm.com/help-centre/topic/warehouse) / Manufacturing (https://pixiecrm.com/help-centre/topic/manufacturing) Before you startThis guide follows Accounting and Bookkeeping module version 1.4.5. The required access is Accounting Reports (https://pixiecrm.com/help-centre/topic/report): View and Transactions: View. A related screen can remain hidden when an optional module is inactive, a source record is in an ineligible status, the selected account is inactive or the user is not an assigned approver (https://pixiecrm.com/help-centre/topic/approval). What you’ll accomplish Use ledger and financial reports (https://pixiecrm.com/help-centre/topic/report) to validate inventory, cost of sales (https://pixiecrm.com/help-centre/topic/sales) and production or warehouse (https://pixiecrm.com/help-centre/topic/warehouse) conversion results. It forms part of Pixie CRM Enterprise CRM's Accounting & Bookkeeping module and uses the module's permission-aware controller, status and mapping (https://pixiecrm.com/help-centre/topic/mapping) flow rather than a generic spreadsheet process. How it works The module does not present a single visible inventory report (https://pixiecrm.com/help-centre/topic/report) endpoint; inventory analysis is performed through Warehouse transaction (https://pixiecrm.com/help-centre/topic/warehouse) views, Balance Sheet, Profit & Loss, General Ledger and transaction reports (https://pixiecrm.com/help-centre/topic/report). When the Warehouse (https://pixiecrm.com/help-centre/topic/warehouse) or Manufacturing (https://pixiecrm.com/help-centre/topic/manufacturing) module is inactive, those source tabs are absent. Reconciliation (https://pixiecrm.com/help-centre/topic/reconciliation) requires the source inventory valuation method and Accounting mappings (https://pixiecrm.com/help-centre/topic/mapping) to be consistent. Follow these steps - Run Balance Sheet for inventory accounts. - Run General Ledger or Transaction Detail by Account. - Compare balances with Warehouse (https://pixiecrm.com/help-centre/topic/warehouse) valuation. - Check cost of sales (https://pixiecrm.com/help-centre/topic/sales) in Profit & Loss. - Investigate loss adjustments and manufacturing (https://pixiecrm.com/help-centre/topic/manufacturing) variance. - Check (https://pixiecrm.com/help-centre/topic/check) opening stock (https://pixiecrm.com/help-centre/topic/warehouse) and item mappings (https://pixiecrm.com/help-centre/topic/mapping). - Post approved corrections through the correct source or journal workflow. Settings to check Inventory asset accountsShould agree with source valuation at the selected date. Cost of sales (https://pixiecrm.com/help-centre/topic/sales)Reflects delivered or consumed inventory according to mappings (https://pixiecrm.com/help-centre/topic/mapping). Loss or variance accountsCapture approved adjustments. Work in progress or finished goodsDepend on manufacturing (https://pixiecrm.com/help-centre/topic/manufacturing) mappings (https://pixiecrm.com/help-centre/topic/mapping). Transaction detailExplains source receipts, deliveries and adjustments. Check it worked After the action is saved, Pixie CRM keeps the Accounting record connected to its source and updates the visible status or ledger data supported by this workflow. Review the saved result rather than relying only on a success message. Where the action posts accounting data, total debits and credits (https://pixiecrm.com/help-centre/topic/double-entry) must balance and the accounts must match the approved mapping (https://pixiecrm.com/help-centre/topic/mapping) or manual selection. - Open the saved record and confirm its final status. - Review the source reference and every debit and credit (https://pixiecrm.com/help-centre/topic/double-entry) line where ledger data was created. - Use the relevant register, ageing, reconciliation (https://pixiecrm.com/help-centre/topic/reconciliation) or report (https://pixiecrm.com/help-centre/topic/report) to verify the wider effect. Common mistakes to avoid - Use the same valuation date. - Do not post opening inventory twice. - Check negative or inactive-item balances. - Separate quantity errors from accounting-value errors. - Use the least destructive correction available and record the reason for material changes. - Do not bypass a permission, approval (https://pixiecrm.com/help-centre/topic/approval) or closed-period control by changing unrelated data. Accounting and data safetyDeletion, reset, void, refund, mapping (https://pixiecrm.com/help-centre/topic/mapping), journal and reconciliation (https://pixiecrm.com/help-centre/topic/reconciliation) actions can change financial history. Use approved access, retain supporting evidence and validate the result in the General Ledger or relevant control report (https://pixiecrm.com/help-centre/topic/report). Browse connected topics:reconciliation (https://pixiecrm.com/help-centre/topic/reconciliation)check (https://pixiecrm.com/help-centre/topic/check)report (https://pixiecrm.com/help-centre/topic/report)warehouse (https://pixiecrm.com/help-centre/topic/warehouse)manufacturing (https://pixiecrm.com/help-centre/topic/manufacturing)approval (https://pixiecrm.com/help-centre/topic/approval)mapping (https://pixiecrm.com/help-centre/topic/mapping)double-entry (https://pixiecrm.com/help-centre/topic/double-entry)sales accounting (https://pixiecrm.com/help-centre/topic/sales)expense (https://pixiecrm.com/help-centre/topic/expense)tax (https://pixiecrm.com/help-centre/topic/tax)customers (https://pixiecrm.com/help-centre/topic/customer) Related guides Convert Warehouse and stock transactions (https://pixiecrm.com/help-centre/warehouse-and-stock-conversion)Convert manufacturing costs to Accounting (https://pixiecrm.com/help-centre/convert-manufacturing-costs-to-accounting)Use Balance Sheet reports (https://pixiecrm.com/help-centre/balance-sheet-reports)Use Profit & Loss reports (https://pixiecrm.com/help-centre/profit-and-loss-reports)Accounting report centre overview (https://pixiecrm.com/help-centre/report-centre-overview)Use Cash Flow and Changes in Equity reports (https://pixiecrm.com/help-centre/cash-flow-and-equity-reports) Connected operational guides Inventory stock and valuation reports → (https://pixiecrm.com/help-centre/topic/inventory-warehousing-reports-currency-rates)