How do I map a custom import GST to landed costs?
To link a custom/imported GST (or VAT) charge to a landed cost, you'll need to use a non-diminishing product in Qblue that represents the custom GST, link it to the custom fee type, and add it to the landed cost.
This also applies to landed fees that are not prorated onto product costs.
Follow these three steps to link a custom GST charge to a landed cost type.
Set up a custom GST product SKU (non-diminishing)
- Go to Products, then select Products / Sku variations.
- Create a new non-diminishing product SKU e.g. CUSTOMGST.
- Click Edit variant on the left access menu.
- Click Edit GL.
- Map the GL accounts to a GST-related GL code from Xero (e.g. 820 for GST/VAT).
- For the Tax type dropdown list, select GST on imports. This option only appears once the GL code is mapped to a GST/VAT account type in Xero.
⚠️Note: this non-diminishing product is for landed costing purposes only. If used in a sales or purchase order, it will be treated as a normal non-diminishing product, so don't use this product in standard orders.
Link the product to a custom fee type
- Go to Purchases, then select Landed cost calculations.
- Click on an existing calculation (or create a new one by clicking +New calculation).
- Under the Landed cost fees section, click the pencil icon (🖉) next to Type.
- Add a new fee type with the following attributes:
- Name: Custom GST (non prorata)
- Toggle off "Pro rata amount onto products"
- Enter the custom product code (from Step 1) in the "Non-prorata SKU link" field
Add the custom GST line to the landed cost calculation
- Add a new landed cost fee to the same landed cost calculation (in Step 2).
- Set the bill type to Custom GST (non prorata) - the custom fee type you created in Step 2.
- Enter the other required fields:
- Supplier
- Bill date
- Reference
- Amount
- Set the tax type to Exempt.
Result in Xero
Once the landed costing is posted, a bill will be created for the custom GST.
When it's synced with Xero, the bill's tax type will be set to exclusive and the custom GST line will be set to:
- GL code: 820 (or whichever account you selected in Step 1)
- Tax type: "GST on imports" (or "VAT on imports")
