We bring sea containers of stock into Australia, so we receive the bill way before the goods arrive. If I hit enter bills and tell it the supplier, it says you have open PO's attached to this supplier, do you want to receive these items. If say yes, it receives these goods into stock (this is bad). If I say no, then the bill and the order are disconnected, it also starts asking what account you want to put it against (this is programmed into the PO so I dont want to mess with that).
Any ideas????
Any ideas????
-
534 Points
Posted 5 years ago
Kevin V. Russell, Accredited Partner
-
5,580 Points
-
534 Points
Jason Hollis, Head of Product
-
10,156 Points
Hi Ben,
This is a common scenario and there are a few ways to attack it including Kevin's suggestion - especially if you are paying on a proforma prior to shipment.
The important aspect is that the BILL DATE (of the bill that includes the inventory) should be the date the goods are received at your warehouse. That is, their receipt date. This will ensure your SOH figures are accurate.
But how do I pay for the goods in advance or know the terms? There are a few options, but this is what I prefer...
a) create a BANK ACCOUNT called Goods in Transit or GIT (I like GIT)
b) Create a bill for the date of your suppliers invoice including the correct terms, however DO NOT add the inventory but instead post it to the GIT Account (under the expense tab in the bill). This gives your GIT account a credit (also useful for knowing the value of the goods you have on the water - especially if you have several in transit at once).
c) When you receive the goods convert your PO to a bill and date the bill as the receipt date (the due date is irrelevant)
d) Pay the inventory bill from the GIT account (using Pay Bills). This clears the GIT as you no longer have any goods in transit.
e) Pay the GIT bill (from step b) on the due date as per the suppliers invoice
NB. There can be quite a few variables here in terms of GST timing, foreign currency, freight forwarding fees, true landed cost, received goods total not equalling the proforma invoice total and so on so please seek advice from your accountant or a registered BAS agent (our accredited partner network is a great place to look) as this post is conceptual in nature only.
Kind regards,
Jason Hollis - Partner Relationship Manager - Business Group
(Edited)
Kelly Day, Accredited Partner, Accredited Partner
-
2,064 Points
My preferred method too
-
130 Points
We use Fishbowl Inventory Management and Reckon. We often pay for stock being shipped from overseas before being received (either a deposit or in full). I want to record the prepayment into the Reckon system but, then when we receive the physical stock and enter it into Fishbowl, offset the prepayment entry in Reckon against the entry imported from Fishbowl.
Currently we receive it into Fishbowl but this overstates our stock on the balance sheet and can cause issues for our manufacturing, as they think there is stock there for the BOM's to make our products, when there isn't.
How is it best to manage this?
Currently we receive it into Fishbowl but this overstates our stock on the balance sheet and can cause issues for our manufacturing, as they think there is stock there for the BOM's to make our products, when there isn't.
How is it best to manage this?
Rav, Community Manager
-
85,644 Points
