Warehousing Items Sold to A Customer & Accounting

We are producing a custom item for a customer. They will be charged $20,000 for their first order on Net 30 terms...which covers the full run. They will only be taking a portion. The remainder will be on our property and when we ship out any of the balance, we will only be charging them the shipping cost.

1. Do I set up a warehouse in Sage so that we can omit the inventory cost from our inventory?

2. Do I change the cost per unit on the first order to accommodate the cost and ship the remainder with a $0 unit price when ordered?

At this point, prepay for the whole thing is not an option. I know that this will increase sales for the month of the first order, but also push the cost of products to when it's actually shipped...which could be over years and will affect the profit when those happen. 

  • 0

    What about shipping normally, then topping up the first invoice with a misc charge line for /unshipped (to a dedicated GL account), making a total of your $20k. 

    Then on subsequent invoices you ship normally, with a negative /unshipped amount to net the lines to zero.

    (I am not an accountant, so you'll want to consult with a CPA on what they want the transaction data / GL entries to look like).

    A separate warehouse code is useful if you want to isolate that inventory value for the purposes of financial reports.

  • 0

    We setup a separate "prepaid" warehouse for items that have been paid for already.  Added the on hand inventory to that warehouse and just use a miscellaneous item code to charge for shipping on those orders.  The prepaid inv has sales prices as $0 but, we still put a cost of those items in case we want to run reports on those values.