Quick note Maggie - you CANNOT claim the VAT back from these invoices - you can only do so from the C79 you receive from HMRC which will be AFTER the import VAT (and duty) has been paid. No C79 then NO VAT reclaim UNTIL you do get that document (ie sometimes it will be lost in the post - you HAVE to wait until you get a copy!! CARE - some folk will tell you its ok to do it from the freight company's invoice BUT that will not help you in the event of an HMRC inspection!!!!!!!!)

So you cannot key these invoices in the normal way anyway.

You say they send different invoices for the freight costs? They dont all do this and indeed some do not give 30 days for the freight costs, so that makes life a bit easier.

So key these as normal and they are then on the creditor list with the correct terms.

Do you have any duty deferment facilities OR is all their VAT/duty paid as soon as the goods arrive at the port?

If the latter - keep the vat/duty ones in a pile for now as a reminder to pay the VAT etc, but do not delay otherwise you will be paying over the odds (demurrage etc) for the goods! Bear in mind that any such payments should have been manually built into any proper cashflow forecast when the order was places, with an amendment as to the date such was due included as the date of arrival was made more certain. Then you can deal with the invoices when payment is made so they are not messing up your creditors report.

I will explain how to to key the entries in sage later (I need to find some spare time - now rolling round the floor laughing my head off as its Janaury! OK - hysteria set in now!), but first - have you seen the C79s before? Have a read up about C79s on the HMRC site. (or do you have an import clerk who chases them if they dont arrive etc?)

Oh, thought you said import duty and tax. So read the tax as VAT.

Do you pay VAT on the imports? As they land or via some other method?

See enclosed example - Im talking the red bit (is your VAT to be paid to the freight company and that which you reclaim via the C79). Or are you talking about the part in pink which shows no VAT?  

  If the latter and you key that as TO then you are reporting an incorrect figure on your VAT return.

Can you add a piccie example (suitably adjusted so no identifiying info is posted)? 

 

 

VinceH wrote:

 looking at the problem asked about:

---

Was only leaving this until import VAT cleared up so that mistakes were not made to the VAT return (only cos I have a wee bit of inside info about Maggie and her new-ness to this role) and until duty deferment issue was cleared up.

if no deferment and they are paid immediately, key as normal and key payment straight away, thus they don't appear on your creditor list. 

 

Hi Vince
That report sounds like it would be very good.
I have never used the Report Designer before on SAGE so any pointers on how to do this would be great.
Have just had a little play and found how to add the field to a Supplier Due Report but how do I then make it come up on the Report request criteria screen?
Maggie

Joanne:

"Was only leaving this until import VAT cleared up so that mistakes were not made to the VAT return" (only cos I have a wee bit of inside info about Maggie and her new-ness to this role and until duty deferment issue was cleared up.

Fair enough - it just looked to me like the thread was digressing and there was a danger the original problem
would be forgotten, so it seemed prudent to make a suggestion as to that while you deal with the VAT issue.

Maggie:

That report sounds like it would be very good.
I have never used the Report Designer before on SAGE so any pointers on how to do this would be great.
Have just had a little play and found how to add the field to a Supplier Due Report but how do I then make it come up on the Report request criteria screen?

Unfortunately, I believe you are on a newer Sage than me so methods may have changed, and I'm not sat at
a Windows computer anyway, so I can't run my copy to remind myself how and add any instructions. :/
When I'm finished at the client I'm working at tomorrow, if I remember I'll look at the way the report is set up
and log in to post some instructions - but the way things are at the moment, the 'if I remember' bit isn't
something I recommend relying on!

Hi both

I am using 5105 which is Import Duty on my nominal list but I'm not sure if the second invoice should really go to this or not. I can see in the history before my time, that some of these have been put to 1106.
Don't worry as you are both so busy and I have the external Accountant coming in on Monday 16th. He can earn his money. Lol.

I am going to try and watch a webinar on the Report Designer that I have found on SAGE and hope it all makes sense.

Thanks so much and don't work too hard.

Maggie X

I've just had a little play to ensure it can filter on an initial character in the
invoice reference - it can.

Note, however, I'm working from version Sage Accounts Plus 2013 (which
is version 19) - so how I say it's done is based on that; things may have
changed in later versions.

So if you start by going to Suppliers -> Reports, and go to the 'Supplier
invoices' section, you'll hopefully see a reported listed called 'Supplier
invoices due' - right click on that and click on 'Edit' in the menu.

The first thing we're going to do is save it with a different name.

In the properties section on the right (if it's not there, click on 'View' on
the menu bar and click on 'Properties') you should see a section called
'Design'in which the Name and Description for the report are listed.
Currently they'll say "Supplier invoices due" - click in each one
and change it to (say) "Suppliers to be paid immediately"

Now go to the menu bar and click on File -> Save as, type "Due
Immediately" in the File Name field, and click on Save.

The next step is to add the filter, so that it only lists invoices where the
first character in the reference field is an asterisk (*) - so go back to the
menu bar and click on Report -> Filters. You'll get a 'Modify Filter' wizard
which probably has one line of fields set up. It'll say "Include rows
where..." and the fields will show:

AUDIT_HEADER . AGED_BALANCE         Does not equal     0.00

Click on the box immediately under AUDIT_HEADER and choose 'And'
from the menu. Another line of boxes should appear.

In the first, click on it and choose AUDIT_HEADER.

In the second, click onit and choose INV_REF

In the third, click on it and choose 'Starts with'

In the fourth, type in an asterisk * on its own.

Click "OK"

If that's gone in okay, the new report will only list invoices where the
invoice number starts with an asterisk.In my case, the report I've
created shows a lot of other information (and doesn't have that filter,
obviously) but for what you're trying to do, I'd think that should be
enough to solve your problem: You now just need to prefix an
asterisk to the invoice number for those invoices to be paid
immediately.

i.e if the invoice number is 114772, enter it as *114772, and the
report should find and list it.

[Edited to shorten the silly long lines]

-- Edited by VinceH on Wednesday 11th of January 2017 04:12:56 PM