We’re having a difficult time figuring out the exact dollar amount of the total orders we’ve fulfilled in a given month. We need this number to know how much revenue we can recognize from our holding account. Our business builds its products to order, with a 2-4 week lead time, and we’re prepaid for 99% of our orders. Because of this, there’s a delay that we have to account from when we make a sale (which Shopify easily reports) to when when we fulfill the order (which Shopify doesn’t appear to report; we’ve only found fulfillment reports that show # of orders in a chosen time period).
We don’t recognize revenue in our books until the orders ship, so we need to be able to identify exactly what we shipped in a given month and the money associated with those orders. We can sort the orders by fulfilled vs unfulfilled, but we can only sort dates based on the order date, not the fulfilled date. We’ve used the Report Pundit app, in which we’ve built a “Fulfilled orders” report that includes the fulfilled date. It has been helpful but we can tell that the number isn’t 100% accurate, which we’re hoping for.
What solutions have you found to solve this accounting problem?
Thank you!