2. Prepare the source worksheet
Download the current identities and daily source counts. In the CSV, cite the original full-source export for every coverage row, map each approved close to this stable product, and bind every canonical sale to its approved order-cost report. Enter product subtotal, allocated discount and tax, total, and the dated historical COGS from the original financial evidence.
Include an older order
A refund or cost reversal belongs to its actual posting date even when the original sale was earlier. Choose the original order basis before downloading; its old revenue and COGS are not counted again.
For orders across locations, every original line's location is filled into source_location_id. Review it against the source location list and keep the exact original receipt-unit ranges from that item and site. All order lines, shared discount, tax and actual COGS must reconcile. This report includes only the selected product and location in its profit and daily inventory denominator. Split-site lines for the same product and unallocated shared acquisition charges remain held; this does not automatically verify warehouse dispatches.
This scope supports the same product on distinct original order lines at different sites. Keep every exact order/account/line and its declared site, quantity, invoice-cost intervals and independently reviewed discount, tax and refund amounts. Complete the original whole order and all other-site allocation rows; their evidence does not enter this site’s numerator. A single provider line divided across sites, transferred origins, acquisition credits and physical returns remain held. No amount is divided automatically.
Actually issued acquisition-price credits
Choose the actual supplier memo and explicitly select the original canonical product line. This first scope covers an entire unreturned receipt consumed by one line. Every known active credit must be included. An expected credit or a returned-goods settlement does not reduce these acquisition costs.
The download fills the supplier source and original receipt identities. In the worksheet, cite a separate actual finance recognition original, its unique journal reference and date, and the signed recognized reduction. Confirm zero prior recognized acquisition credit and complete daily accounting totals. Blank means unknown. The knowledge date includes later retained sources explicitly; it does not prove that those originals were held earlier. No stock, cash or journal is posted.
Review sold and retained credit shares
Include every current approved consuming order line and every actual memo for this receipt. The download supplies original source references and candidate unit ranges. Review those ranges against the originals; no credit amount is filled by a proportion.
For each memo, complete the sold acquisition_credit rows and separate asset retained_credit rows. Cite an independent allocation schedule and the exact original journal line/date for each nonzero share. Their units must completely partition the original receipt and their values must equal the actual issued allocation. A cited explicit zero share claims no journal.
Complete each retained_inventory row with its independently supported closing unit ranges and net value. Complete the other_inventory remainder even when the cited original supports zero. Together they must reconcile to the exact approved closing quantity/value. Retained inventory journals have separate posting_inventory_adjustment totals and never reduce sold COGS. Existing daily closes and their average are unchanged.
Previously recognized credits, physical returns, mixed supplier claims, split-site cost sources and unsupported landed-charge allocations remain held. This is a finance-reviewed source allocation, not an automatic warehouse or accounting-system connection.
Review a transferred original cost
This scope covers one local original receipt and lot, one direct fully traced shipment, and one destination parcel allocation. Partial arrivals must cite every accepted event before dispatch. Review the original cost case and its financial unit intervals; these do not identify physical FIFO units.
Complete the worksheet transfer_origin cell with a JSON object containing pick_id, dispatch_event_id, movement_id, pick_allocation, note_id, receipt_revision, lot_id, transfer_id, shipment_id, trace_id, accepted_event_ids, case_consumption_ranges, reviewed, reason. Select retained parcel, receipt and transfer history identities explicitly. Set reviewed to true only after checking the original invoice, every accepted event and the assigned financial intervals.
The original receipt stays at its original site. Only this destination enters the daily inventory denominator. Missing or changed custody, damage, supplier/customer returns, another hop or shipment, mixed products, refunds, acquisition credits and landed charges remain held. No stock, cash, accounting entry or automatic financial approval is created. Original-unit ownership is checked separately when retaining the reviewed shipment association.
Originals and approved order-cost reports
The source declarations must include explicit zero days and all configured channels. Check all accounting postings for the selected product and dates, including refunds or returns from older orders and other COGS adjustments. Enter reviewed zeros only when the cited original supports them; a blank is unknown. This is a reviewed export scope, not an independent guarantee that a provider returned every order.
How dated refunds and returns work
Keep separate rows for a completed customer cash refund or book credit (refund), an actual warehouse return with its accepted condition (physical_return), and a recognized cost reversal linked to those restored units (return_cogs). A refund never proves restocking; a warehouse return does not automatically change the books.
For a shared order-cost case, complete its order row and every other SKU's allocation row. The original subtotal, shared discount/tax, total, sold units and actual COGS must reconcile across all lines. Each selected product keeps only its own allocated amounts. Set case_scope to whole_order and map the line's original consumed intervals; missing line shares stay held.
For each sale basis, cite the complete opening refund/return/COGS balances as of the day before this period, including explicit zeros. Include the prior dated events that reconcile those balances. On every configured source/day, enter the complete financial posting totals, including zeros; blank means unknown. Restored unit ranges such as [[0,1]] identify the exact original approved consumed units, starting at zero. An interval's end is excluded. Shared-order line ranges map into the complete approved case; event ranges count within that line's own consumed units.
An other_cogs row needs an actual inventory write-down or correction journal, original evidence and its signed amount. Operating costs and expected supplier credits are held. Existing case refunds require an explicit product-excluding-tax or total-including-tax attribution; old amounts are not silently reinterpreted. Acquisition-credit cost changes need a separately reconciled net-cost basis. Tax is reconciled separately from product profit. Source declarations and warehouse originals require human verification; this report does not post stock, refunds or journal entries.
Included on Free. Original worksheets count toward source-file storage. A ratio stays held when dated source coverage, opening history, cost intervals or daily inventory values are incomplete.