How to map a custom import GST for landed costing
This article describes how to link a custom / import GST (or VAT) to a landed costing. This guide also applies to landed fees that are NOT prorata onto products.
There are three steps involved:
- Setup a custom GST non-diminishing product
- Link this product to the custom GST fee type
- Add the custom GST charge line into the landed costing
Step 1: Setup a custom GST (or other non-prorata fee types, e.g. LC_DUTY) non-diminishing product
If one has not been created prior, create a new product like normal, and set the following attributes:
- Non-diminishing is toggled on
- Edit the variant and the click "edit GL" (bottom right)
- map the GL accounts to a GST GL code from Xero (for example: 820 for GST/VAT)
- choose the "GST on imports" tax type. Please note that this tax type dropdown box becomes visible only when the GL code is set to the GST/VAT account type.
- Please note that if this product is used in a PO or sales order, then it will be treated like a normal non-diminishing product. Hence, we recommend not to enter this product into an order.
See below for an example:
Step 2: Link this product to the custom GST fee type
To edit the fee types, open a new or an existing landed costing, then click on the pencil icon next to "Type" under the section title "Landed cost fees".
Create a new custom GST type and set the following attributes:
- Name: Custom GST (non prorata)
- "Pro-rata amount onto products" toggle off (gray)
- Enter the custom GST product code (see step 1) into "Non-prorata SKU link"
See below for an example:
Step 3: Add the custom GST charge line into the landed costing
On the landed costing entry page, choose the "Custom GST (non prorata)" type and enter other details such as supplier, bill date, reference and amount. Ensure this line's tax type is set to exempt.
For example:
When the landed costing is posted, the resulting custom GST bill will be created and when it is synced to Xero, the following settings will be synced across:
- The tax type of the bill is exclusive
- The custom GST line is set to
- GL Code: 820 (or the account that you have selected on step 1)
- Tax type is "GST on imports" (or "VAT on imports")
See below for an example: