Skip to content
Guilda Work Help center
Go to the app

Help center / Posting invoices / Check what a3 returns

Check what a3 returns

Open in Guilda Work

Upload an a3 list and check which exported invoices are really booked, and whether the VAT adds up.

Updated on

  • Invoice bookkeeping

Exporting the SUENLACE.DAT does not guarantee a3 imported it. In Generated files → Check what a3 returns you upload a list of the client's invoices taken from a3 (the VAT register or any list, as CSV or Excel) and Guilda Work cross-checks it with what you exported.

How the list is recognised

By the title of each column: invoice number, date, tax ID, base, VAT amount and total. The number is enough; if the list has a tax ID or amounts, they must not contradict. If a3 has one row per VAT rate of each invoice, they are grouped per invoice.

What it tells you

  • Confirmed: in a3 with the same amounts. The date is recorded (Mark the matching ones as confirmed box), each file shows n / total in the In a3 column and the client sees the Confirmed step of the invoice in their portal.
  • With different amounts: in a3 but the total, base or VAT amount differs. They are not confirmed: check which one is right.
  • Exported but not found: those within the list's date range that a3 does not have, with their file. See whether a3 rejected them or the file still has to be imported; you can download it again.
  • In a3 and not exported from here: manual entries or from another route.
  • VAT reconciliation by quarter: VAT per Guilda and VAT per a3 for invoices on both sides, to look at any difference before form 303.

Reopening an invoice removes its confirmation. The list is not stored: only the confirmation date.

Account map

In Client a3 settings → Account map you see which sub-account will be used for each supplier and customer and where it comes from (From the a3 chart, Set, New: it will be numbered automatically or Generic, which mixes everyone into one account). You can change it by hand: it must have the client's number of digits and what was already exported does not change.

If the columns are not recognised

If the listing has no recognisable headers, open My listing is not recognised: set the columns: you will see the first rows of the file with the letter of each column (A, B, C…). Say which one is the invoice number (required), date, tax ID, total, base and VAT amount (the number plus one more column is enough) and which row holds the headers (0 if none). Choose the file again and press Check. The assistant and the MCP accept the same.

Maybe the same invoice with another number

Under Maybe the same invoice with another number you will see exported invoices that a3 does not have under their number but whose total matches an a3 row with a very close date (up to three days). It is usually the same invoice renumbered or typed differently: check it and fix the number where needed. Nothing is confirmed automatically.

Reconciliation with model 303

If the account holder has Guilda Fiscal with their profile, the result adds Reconciliation with model 303: the VAT on domestic transactions of reviewed or exported invoices against boxes 27 (output VAT) and 45 (total deductible) of the simulated 303. A difference is usually an invoice that did not reach Guilda Fiscal (it was taken out or its entry is not approved). Intra-EU transactions, reverse charge and imports are not compared.

It remembers the columns

When you set the columns of a listing that was not recognised, Guilda Work remembers them for that client: the next time its listing is not recognised by its headers, it is read with the same columns without you having to enter them. A listing with recognisable headers is always read by its headers.

Related guides

Back to Posting invoices

Was this guide helpful?

We only count your vote: we don't store who you are.

Can't find the answer?

Write to us and we'll help.

Write to support