Does Xero have a chart of account codes?

Mastering Xero: A Guide to Vehicle Purchases

17/04/2002

Rating: 4.22 (13222 votes)

Recording a new vehicle purchase in Xero can be a more intricate process than it initially appears. This is primarily due to the varying tax implications and the need to accurately reflect the asset's value on your balance sheet. Unlike simple expense items, vehicle purchases often involve components subject to different tax treatments and thresholds, requiring a meticulous approach to ensure compliance and accurate financial reporting. This guide will walk you through the essential steps and considerations when entering a new vehicle acquisition into your Xero account.

How do I Mark a bill as a normal expense in Xero?
Hi In company B, go to the Chart of Accounts, find the loan account and make sure the option "Enable payments to this account" is selected. You will then be able to record the Bill as a normal expense (in company B's Xero) and mark it as being paid using the inter-co loan account.
Table

Understanding the Nuances of Vehicle Purchases

When acquiring a new motor vehicle for your business, the invoice from the dealership is rarely straightforward. Several factors can complicate the recording process:

  • GST Applicability: Not every charge on a vehicle purchase invoice is subject to Goods and Services Tax (GST). You'll need to identify which components are taxable and which are GST-exclusive.
  • Deductible Thresholds: For both GST and Income Tax purposes, the cost of a vehicle is often deductible only up to a specific annual threshold. This threshold is subject to change each year and can vary for different vehicle types (e.g., fuel-efficient vs. standard).
  • Luxury Car Tax (LCT): If the vehicle's purchase price exceeds a certain value, Luxury Car Tax may apply. This LCT threshold is also indexed annually and can differ based on fuel efficiency.

Breaking Down Vehicle Components for Xero

To accurately record a vehicle purchase, it's crucial to dissect the invoice into its constituent parts and understand how each component should be treated for GST and accounting purposes. Here's a general guide, though always consult with your accountant for specific advice:

Vehicle ChargeTax RateXero Account
Vehicle Cost (up to annual threshold)GST on Expenses or GST on CapitalMotor Vehicles - At Cost
Stamp DutyBAS ExcludedMotor Vehicles - At Cost
Vehicle Cost (above annual threshold)BAS ExcludedMotor Vehicles - At Cost
Dealer DeliveryGST on Expenses or GST on CapitalMotor Vehicles - At Cost
Premium Branded PlatesBAS ExcludedMotor Vehicles - At Cost
CTP InsuranceBAS ExcludedMotor Vehicle - Registration and Insurance
Business RegistrationBAS ExcludedMotor Vehicle - Registration and Insurance
GST over thresholdBAS ExcludedOther Expenses
Luxury Car TaxBAS ExcludedLuxury Car Tax (Other Expenses)

Recording a New Vehicle (Up to Annual Threshold)

Before entering the purchase into Xero, carefully review the vehicle tax invoice. You'll need to perform calculations to break down the charges according to the guidelines above. Let's consider an example:

Example: Vehicle Cost Breakdown Calculation

Imagine a vehicle purchase with the following invoice details:

  • Vehicle Sale Price: £25,000
  • Dealer Delivery Fee: £500
  • Stamp Duty: £1,000
  • Registration & CTP Insurance: £800
  • Annual Deductible Threshold: £30,000
  • GST Rate: 20%

Calculation:

  • Total Vehicle Cost (for asset capitalisation): £25,000 (Sale Price) + £500 (Delivery) + £1,000 (Stamp Duty) = £26,500
  • GST on Capital (if applicable): If the £26,500 is within the threshold and GST is applicable, you'd calculate GST on this amount. For simplicity in this example, let's assume the "GST on Capital" account is used for the GST component of the capitalised asset.
  • Registration & CTP Insurance (Expense): £800

Steps in Xero:

  1. Navigate to Contacts > All Contacts.
  2. Find or create the Car Dealership contact.
  3. Click on [New] > Bill.
  4. Invoice Header Details:
    • From: Confirm the Supplier's Name.
    • Date: Enter the Vehicle Invoice date.
    • Due Date: Enter the Vehicle Invoice Due date.
    • Reference: Enter the Vehicle Invoice Number or Deal Number.
  5. Invoice Line Items:
    • Line 1 (Vehicle Value): Enter the calculated vehicle cost that is eligible for capitalisation (e.g., £26,500). Ensure the appropriate tax rate is selected (e.g., 'GST on Capital').
    • Line 2 (Registration & CTP): Enter the cost of Registration & CTP Insurance (e.g., £800). Select the relevant tax rate (e.g., 'BAS Excluded' or 'GST on Expenses' if applicable).
  6. Ensure the total of the purchase transaction in Xero matches the total of the Vehicle invoice.
  7. Attach the Vehicle Invoice to the purchase transaction in Xero for your records.
  8. Click on [Approve].

Recording a New Vehicle (Value Above Annual Threshold)

If the total cost of the vehicle (as defined for tax purposes) exceeds the annual deductible threshold, you'll need to split the value above the threshold. The portion above the threshold is generally not claimable for GST and income tax purposes.

Example Continuation:

  • Vehicle Cost (Capitalisable): £26,500
  • Annual Deductible Threshold: £30,000
  • Vehicle Cost above Threshold: £0 (in this specific example, as £26,500 is below £30,000)

Let's adjust the example for clarity. Suppose the vehicle cost eligible for capitalisation was £32,000.

How to set up a lease in Xero?
The following steps will need to be actioned in order to set up the above lease in Xero: Novated Lease Clearing Account – liability account, current liability; – BAS Excluded tax code; set up a separate account for each affected employee. Employee FBT Contributions – revenue account – GST on Income tax code; place under non-trading income type e.g.
  • Vehicle Cost (Capitalisable): £32,000
  • Annual Deductible Threshold: £30,000
  • Value within Threshold: £30,000
  • Value above Threshold: £2,000 (£32,000 - £30,000)

Modified Xero Line Items:

  1. Line 1 (Vehicle Value up to Threshold): £30,000 (with appropriate GST on Capital treatment).
  2. Line 2 (Additional Vehicle Value): £2,000 (typically with a 'BAS Excluded' tax rate). This amount is added to the 'Motor Vehicles - At Cost' account.
  3. Line 3 (Unrecoverable GST): Calculate the GST on the £2,000 portion above the threshold. This GST amount is usually posted to an 'Other Expenses' account (e.g., 'GST on Capital Losses' or similar).
  4. Continue with other expense lines like Registration & CTP as before.

Recording a New Vehicle with Luxury Car Tax

If your vehicle purchase includes Luxury Car Tax (LCT), this cost must also be itemised separately. LCT is generally not claimable for GST purposes.

Example Continuation with LCT:

  • Vehicle Cost (Capitalisable): £32,000
  • Luxury Car Tax: £3,000
  • LCT Threshold: £35,000 (hypothetical for this example)

Modified Xero Line Items (incorporating LCT):

  1. Line 1 (Vehicle Value up to Threshold): £30,000 (with appropriate GST on Capital treatment).
  2. Line 2 (Additional Vehicle Value): £2,000 (BAS Excluded, added to 'Motor Vehicles - At Cost').
  3. Line 3 (Unrecoverable GST): GST on the £2,000 portion (posted to 'Other Expenses').
  4. Line 4 (Luxury Car Tax): £3,000 (BAS Excluded). This should be posted to a dedicated 'Luxury Car Tax' account within 'Other Expenses' or a specific LCT asset account if your accountant advises.
  5. Add other expense lines (Registration, CTP) as appropriate.

Utilising Xero's Chart of Accounts

Xero provides a default Chart of Accounts, but you can also customise it. For accurate vehicle recording, ensure you have appropriate accounts set up. Key accounts you might use include:

  • Motor Vehicles - At Cost (Fixed Asset): To record the capitalisable value of the vehicle.
  • Accumulated Depreciation on Motor Vehicles (Fixed Asset): To track the depreciation of the vehicle over time.
  • Motor Vehicle Expenses (Overhead): For running costs like fuel, maintenance, and repairs.
  • Motor Vehicle - Registration and Insurance (Overhead): For costs like CTP, registration fees, and comprehensive insurance.
  • Other Expenses: For non-deductible portions of the vehicle cost, unrecoverable GST, and Luxury Car Tax.

If Xero's default codes don't perfectly suit your needs, you can add custom accounts under Accounting > Advanced > Chart of Accounts. This allows for more granular tracking of your assets and expenses.

Frequently Asked Questions

What if I paid for the vehicle using a business loan?

When recording the bill in Xero, instead of selecting a bank account as the payment source, you would select the relevant loan liability account. This ensures the loan is recorded correctly on your balance sheet.

How do I enter a vehicle purchase in Xero?
Once you have calculated the vehicle's cost breakdown you can enter the vehicle purchase in Xero. Record a New Vehicle - value above Annual Threshold If the vehicle purchase value is above the Vehicle claimable Annual Threshold the value above the threshold needs to be split into 2 additional lines: Record a New Vehicle - Luxury Car Tax

How do I record depreciation for the vehicle?

Depreciation is typically calculated and journalled at the end of each accounting period (monthly, quarterly, or annually). The journal entry would debit the 'Depreciation Expense' account and credit the 'Accumulated Depreciation on Motor Vehicles' account. The specific depreciation method and rate should be determined by your accountant.

Can I mark a bill as a normal expense if it's related to a loan?

Yes, if you have a loan account set up in Xero with the option "Enable payments to this account" selected in the Chart of Accounts, you can record a bill as a normal expense and mark it as paid using the inter-company loan account. This is particularly useful for tracking internal loan movements.

How do I Mark a bill as a normal expense in Xero?
Hi In company B, go to the Chart of Accounts, find the loan account and make sure the option "Enable payments to this account" is selected. You will then be able to record the Bill as a normal expense (in company B's Xero) and mark it as being paid using the inter-co loan account.

What if the vehicle was financed through a novated lease?

Novated leases require specific setup in Xero, often involving a 'Novated Lease Clearing Account' (a liability account) and 'Employee FBT Contributions' (a revenue account). You'll need to set up separate accounts for each affected employee and ensure correct tax codes are applied. This is a complex area, and professional advice is highly recommended.

Conclusion

Recording vehicle purchases in Xero demands attention to detail, particularly regarding GST and tax thresholds. By carefully breaking down invoice components and utilising the correct Xero accounts, you can ensure accurate asset recording and compliance. Always consult with your accountant to confirm the correct treatment for your specific circumstances, especially concerning deductible thresholds, LCT, and depreciation.

If you want to read more articles similar to Mastering Xero: A Guide to Vehicle Purchases, you can visit the Automotive category.

Go up