Everything the customer was charged comes from Shopify. The cost comes from the ERP, by the best evidence available for each line: first the line's own SKU looked up straight in the ERP's SKU table, which is the exact size the customer bought; failing that the ERP's own item for the order, priced through its bill of materials in PRODUCT_SKU; failing that the product catalogue, which prices what was ordered rather than what shipped and is labelled Estimated. US prices for US orders, Canadian prices for Canadian ones. That is a product cost, not a landed cost: freight in, duty, assembly and payment fees are not in it, so the bottom line here is a gross margin and will fall once those are added. Shipping cost stays empty until carrier invoices are imported. Where a product's bill of materials is missing prices the margin is left blank rather than guessed — filter to Needs prices in the ERP to see exactly which ones.

Files the intake opened and decided against — too old for the first scan, a file type it can't read, or a document it couldn't read as an invoice. Each one is remembered so the same file isn't paid for twice, which also means it will never be looked at again on its own. If one of these is a real bill, put it back.

Forward a bill to the ops inbox, drop it in the shared Drive folder, or post the file straight into the Telegram group — all three land in this register. Invoices from suppliers we already know post themselves; anything new or unclear waits in the Accounting tab's review queue first. QuickBooks fills in whatever never reached us as an original, and anything it restates is marked a duplicate and kept out of every total.