An alternative solution for exporters that can receive the tax invoice for payment months prior to receiving the goods into stock. The problem here is that the month the invoice is received into increases the purchases (showing a huge loss for that month), but the closing stock isn’t adjusted because they have not received the product yet. When the product is received it shows a huge profit for the month.
Solution for those cases:
In the financials, create 3 new general ledger codes
- Profit & Loss - In Transit Opening Stock
- Profit & Loss – In Transit Closing Stock
- Balance Sheet – In Transit Inventory
Create a new product code ZIT (or just IT, I prefer to put a Z in front so it doesn’t get mixed in with normal products). Note if your supplier invoices can be a combination of GST inclusive and Exempt then you will need a second product code.
- Latest Purchase Cost = $1.00
- Average Purchase Cost = $1.00
- Closing Stock G/L = Less Closing Stock in Transit
- Track Quantities = Ticked
When you receive the invoice in a different month to the products arriving. Open the purchase order and at the bottom add the ZIT product code twice. One with a positive quantity and one with a negative quantity with the GST Exclusive value of the invoice. Receive in the positive value only, allowing you to correctly process the invoice to purchases.
At the end of the month update the Stock Value to GL, the In Transit Closing Stock will be adjusted by the value of the purchase order.
The profit and loss will now be correct without the fluctuation.
To receive the stock, receipt all of the products and the negative ZIT making it a $0.00 invoice.
The next months profit and loss after updating the stock value to GL, nothing has happened to purchases, Closing Inventory In Transit has changed to $0.00 and Closing Inventory has increased.