Sage query ECSL/VAT Return

Gem7321

This is bamboozling me.

We run quite a comprehensive import procedure from our invoicing system into sage. Any sales which have been paid on proforma to customers who are based in Europe are imported to 1 customer ledger 'MISCE'. Similarly if an invoice has been paid at the time of ordering by credit card this is imported to ledger 'CASHE'.

Only some of these will be actual EC Sales - if one of those invoices is refunded/credited the credit doesn't appear on my Sage ECSL or VAT return even though it is posted as a T4.

Please can someone advise? All other credits appear correctly from other ledgers.