Xero - tips and tricks

mrs mtx

Member
Location
Pembrokeshire
Doing my first vat return digitally. I’ve got some transactions in May ‘that’s when they went through the bank’ but I did the invoice in April so I already put them through the last vat quarter and don’t want to pay vat on it twice.

How do I take them off this vat return without deleting them from the bank?
 

Nukemall

Member
In the acc
Doing my first vat return digitally. I’ve got some transactions in May ‘that’s when they went through the bank’ but I did the invoice in April so I already put them through the last vat quarter and don’t want to pay vat on it twice.

How do I take them off this vat return without deleting them from the bank?
In the accounting menu select reports, then select tax and vat return. Then click adjust next to the amount you want to change, adjust it for the difference after taking off the ones you claimed in the previous month. You can also put a reason against the adjustment.
 
Last edited:

mrs mtx

Member
Location
Pembrokeshire
In the acc

In the accounting menu select reports, then select tax and vat return. Then click adjust next to the amount you want to change, adjust it for the difference after taking off the ones you claimed in the previous month. You can also put a reason against the adjustment.
I found that bit but when I go to the individual transactions do I edit by just taking away the vat? Or do I just adjust the box with the whole total difference?
 

Nukemall

Member
I found that bit but when I go to the individual transactions do I edit by just taking away the vat? Or do I just adjust the box with the whole total difference?
Sorry just reread your question, you don't need to go in to the individual transaction, you just adjust the totals of expenses and vat reclaimed (assuming it was on expenses). Also uncheck the create accounting transaction box.

All you are doing is correcting the vat return, and adding a reason (already caimed in previous vat return).

Hope this makes sense.
 

chaffcutter

Moderator
Arable Farmer
Location
S. Staffs
If you created them in the previous month and paid the VAT, why have you entered them again? They should just reconcile when they go through the bank account. I assume you have created your invoice in Xero? So they were automatically on the VAT return at the date of the invoice.
 

Nukemall

Member
I think they were claimed in the previous manual return, but only put on the system in this period. This is the first digital return done on xero, so it will not know that the vat is already claimed, so the return needs manually adjusted.
 

Chae1

Member
Location
Aberdeenshire
Right, probably been mentioned on this thread already but can't find it. I'm trying to setup something for HP repayments.

I have found some stuff googling but kind of stuck now.

So I entered the invoice for the full amount of the machine. I setup a HP liability account in chart of accounts. After I entered the invoice I marked it as paid as full out of the HP liability account. So this should allow me to claim back the full VAT amount.

When it comes to reconciling what do I mark the payments too? Got a self billing invoice for the trade in and need to reconcile it. Also monthly payments for the machine coming out of the bank that I need to allocate. There will also be interest on bank loan so repayment amount will be greater than purchase price.

Also should there be VAT on my HP HP liability account?

Confused.com.
 

Jerry

Member
Mixed Farmer
Location
Devon
As you reconcile the monthly payments on the dashboard you need to split the payments against the original invoice so in effect paying it down each month.

On the reconciliation page where bank payments are, select match against that payment line. Search fir the supplier, select the outstanding invoice and then select split. This allocates the monthly payment against the original invoice.

Repeat monthly until fully paid off.

I think you can create a rule to do that automatically each month.
 

Chae1

Member
Location
Aberdeenshire
As you reconcile the monthly payments on the dashboard you need to split the payments against the original invoice so in effect paying it down each month.

On the reconciliation page where bank payments are, select match against that payment line. Search fir the supplier, select the outstanding invoice and then select split. This allocates the monthly payment against the original invoice.

Repeat monthly until fully paid off.

I think you can create a rule to do that automatically each month.
I marked the invoice as fully paid. Which it has been by the bank. This was by the HP liability account I created. So the original invoice is marked as paid and not coming up as money owed to the dealer.

I think inneed to put it against the HP liability account I created, but unsure how to do this. It doesn't come up as a debtor.
 

Jerry

Member
Mixed Farmer
Location
Devon
I marked the invoice as fully paid. Which it has been by the bank. This was by the HP liability account I created. So the original invoice is marked as paid and not coming up as money owed to the dealer.

I think inneed to put it against the HP liability account I created, but unsure how to do this. It doesn't come up as a debtor.

i think you need to unmark it as fully paid, the liability is still yours even with the bank paying it in full.
 

SFI - What % were you taking out of production?

  • 0 %

    Votes: 105 40.5%
  • Up to 25%

    Votes: 94 36.3%
  • 25-50%

    Votes: 39 15.1%
  • 50-75%

    Votes: 5 1.9%
  • 75-100%

    Votes: 3 1.2%
  • 100% I’ve had enough of farming!

    Votes: 13 5.0%

May Event: The most profitable farm diversification strategy 2024 - Mobile Data Centres

  • 1,739
  • 32
With just a internet connection and a plug socket you too can join over 70 farms currently earning up to £1.27 ppkw ~ 201% ROI

Register Here: https://www.eventbrite.com/e/the-mo...2024-mobile-data-centres-tickets-871045770347

Tuesday, May 21 · 10am - 2pm GMT+1

Location: Village Hotel Bury, Rochdale Road, Bury, BL9 7BQ

The Farming Forum has teamed up with the award winning hardware manufacturer Easy Compute to bring you an educational talk about how AI and blockchain technology is helping farmers to diversify their land.

Over the past 7 years, Easy Compute have been working with farmers, agricultural businesses, and renewable energy farms all across the UK to help turn leftover space into mini data centres. With...
Top