Skip to content

How do I review the VAT register?

The VAT register is the list of issued and received invoices with their tax base, their rate and their VAT amount. It is what you go over before preparing a tax return and what your accountant usually asks for. This page explains how to look it up and how to read what it shows.

The VAT register with the period’s issued and received invoices

What do I need before I start?

Nothing special: the register fills itself. Each issued invoice, sales or purchase, records itself in the register the moment it is issued, with one line for each VAT rate it carries. Delivery notes, orders and quotes don’t record anything: only invoices and credit notes go into the register.

To see the screen you need the Taxes menu. If it doesn’t appear, the installation doesn’t have that module or your user doesn’t have access to it.

How do I do it?

  1. Go to Taxes and then to VAT register.
  2. Choose the tab: Issued for sales, Received for purchases.
  3. Adjust the From and To dates. The program suggests the current calendar quarter; you can enter whatever range you like.
  4. Choose a Scheme if you want to see a particular register —for example only exports—, or leave it on All.
  5. Tick Only those not yet in a return if you only want to see what hasn’t yet gone into any VAT return.

Each row shows the date, the document number, the business partner with their Tax ID (NIF), the Scheme, the Tax base, the VAT % and the Tax amount, and —if the invoice carries equivalence surcharge (RE)— the RE % and the RE amount. There are also two marks: Corrective and the Return column.

Below the list, the Totals by rate panel groups the range by VAT percentage, with the number of entries and a total row. Note: that panel adds up the whole range, even if you have ticked Only those not yet in a return; it is the tax summary of the complete period.

What is the Scheme column and what is the filter for?

The scheme says what that invoice was for VAT purposes, and it is what decides which register it appears in. It isn’t a property of the customer, but of the invoice: you can make a domestic sale and an intra-EU supply to a French customer, and each one goes to its own register.

SchemeWhen it is used
GeneralThe normal case: a sale or purchase with Spanish VAT
Equivalence surcharge (RE)Retail customer under the surcharge scheme
Reverse chargeThe invoice arrives without VAT and the recipient declares it
ExemptTransaction exempt from VAT
ExportSale to a country outside the European Union
Intra-EU supplySale to a customer in another EU country
Intra-EU acquisitionPurchase from a supplier in another EU country
Import · CustomsPurchases from outside the EU

The scheme is chosen on the document, in the Tax scheme drop-down. If it isn’t touched, the invoice is General, which is correct in most cases.

Invoices imported from the Desktop ERP bring their scheme from there, so the exports and intra-EU invoices you already had still appear in their register.

How do I get the invoice list with VAT broken down by rate?

With the reports in Taxes → VAT reports: Issued invoice list and Received invoice list, each one sorted by date, by invoice or by customer (or supplier). They produce one line per invoice with:

Figures that are zero come out blank, so you can see at a glance which rates each invoice carries. The list sorted by date closes each month with its total; in Subtotals by you can change it to quarter or remove it.

In the report window you choose which rates come out in columns:

VAT ratesWhich columns come outPage
3 standard ratesThe standard, reduced and super-reduced rates from your tax settings (21, 10 and 4 %), even if there is no invoice with one of them in the periodPortrait, if it fits
All (landscape)All the rates on the period’s invoices, from highest to lowestLandscape

With 3 standard rates, an invoice with another rate —for example, one from a year in which VAT changed halfway through the financial year— isn’t lost: its tax amount and its tax base go to the VAT other and Tax base other columns, which only appear if needed. That way each line always matches its total.

Tick Sum of tax bases and VAT to add two columns with the sum of all tax bases (Tot. base) and of all tax amounts (Tot. VAT) on each invoice.

To see only the invoices of one scheme, such as those with reverse charge, choose that scheme in the Scheme drop-down.

To see only the large invoices, type a figure in Amount greater than: the invoices whose Total (tax base, VAT and surcharge for all their rates) reaches that figure come out. The whole invoice is looked at, not each rate separately: an invoice of 100 € at 21 % and 50 € at 10 % counts as 176 €, and it comes out complete or not at all. A credit note has a negative total, so with a positive figure it doesn’t appear.

What does the Return column mean?

Each register line shows whether it has already been included in a VAT return or not.

The control is line by line, not by month. That is why a purchase invoice that arrived late and stayed Pending isn’t lost: it goes into the next VAT return even if its date is from an earlier quarter.

Why does an invoice come out negative or marked as Corrective?

A credit note goes into the register with the tax base and the tax amount in negative and with the Corrective mark: that way it subtracts from the period’s VAT instead of adding. That is the correct behaviour.

Lines with the Corrective mark also appear when an invoice whose month was already closed or in a return is corrected or voided: the program doesn’t delete the original line, it adds another with the amounts in negative and dated today. The detail is in What happens to VAT if I correct or void an invoice?.

Do journal entries typed by hand appear in the register?

Yes. A manual journal entry with lines in its Journal entry VAT (purchase/sale) panel records in the register just like an invoice, on the tab that matches its direction. How to fill in that panel is in How do I make a manual journal entry?.

Can I see the register of a year that isn’t the one I have open?

Yes. Set From and To to that year’s dates: each line shows its invoice number and the name and tax ID of the customer or supplier, even if the invoice belongs to a financial year other than the one you have open.

Where do the number and the name of what came from the desktop ERP come from?

The VAT register that comes from the desktop ERP goes in exactly as it was declared. If its invoice or its customer were brought over too, the line shows the invoice number and the record’s details. If not —an invoice of a type that isn’t brought over, or a customer without a record—, the line shows what the desktop register says: its invoice number, the tax ID and the name of the customer’s or supplier’s account.

If something goes wrong

What you seeWhat has happenedWhat to do
What came from the desktop ERP has no number or nameIt was brought over before the register kept those detailsAsk support to bring the VAT register over again: it is completed without duplicating anything
An invoice doesn’t appearThe date is outside the range, or you are on the wrong tabWiden From/To and check Issued/Received
A delivery note doesn’t appearDelivery notes don’t record in the registerInvoice the delivery note; the invoice does record
The panel total doesn’t match the sum of the rowsYou have ticked Only those not yet in a return; the panel adds up the complete rangeUntick the filter to compare
A line comes out negativeIt is a credit note, or the correction of an invoice from a closed monthNothing: it is expected
An export appears as GeneralThe invoice was issued without choosing a schemeOpen the invoice and choose Export in Tax scheme
The Scheme filter doesn’t offer the one I’m looking forThere are sales schemes and purchase schemesSwitch tab: Import and Customs only appear in Received
The tax amount doesn’t match the current invoiceThe register is rebuilt when the invoice is modified; if it doesn’t match, there is a corrective line as well as the originalCheck whether there are rows with the Corrective mark for that document
‘The VAT register could not be loaded’Error reading the dataTry again; if it persists, tell support

See also: What happens to VAT if I correct or void an invoice? · Make a manual journal entry

More about VAT