Skip to content
Guilda Work Help center
Go to the app

Help center / Posting invoices / Generating the file for a3

Generating the file for a3

Open in Guilda Work

Check, generate and download the SUENLACE.DAT, and take it to a3.

Updated on

  • Invoice bookkeeping

The SUENLACE.DAT file carries a client's reviewed invoices. Pick the client (and, if you want, the quarter) in Invoices to post.

Checking before generating

Check first generates the file in memory, reads it back by its positions and shows you the result without marking or saving anything:

  • Errors: what a3 would reject or post wrongly (an amount without a3's format, a credit note without its corrective record, a VAT amount that is not the base times the rate…). With the record number. While there are errors, the file is not handed over.
  • Warnings: things that are probably fine but worth a look (an invoice without a tax ID, a tax ID that fails its check digit, an intra-EU operation without form 349, invoices from several financial years…).
  • The new subaccounts that would be assigned and the closed periods that are touched.

Generating and downloading

Generate SUENLACE.DAT creates the file, downloads it and marks those invoices as exported. Each file stays saved in Generated files, with Download to fetch it again and Check to go over it once more. Check a file reviews any SUENLACE.DAT you upload, for example one made by another program.

Closed periods

A client's quarter is closed if you close it by hand with Close quarter or if its form 303 (or that year's 390) shows as filed in the tax calendar. When exporting invoices from a closed period you are asked to tick Export even though the period is closed: normally they are already posted or a supplementary return has to be filed. Reopen the period removes a closure made by hand; one from a filed return is reopened in the tax calendar.

Taking it to a3

In a3, open the company and go to Utilidades › Importar/Exportar › Enlace contable. Choose the file. a3 creates the subaccounts that do not exist.

The first time, do it in a test company and run the file through a3's "Chequeo" button before using it in a real company. Guilda Work's pre-check does not know that company's chart of accounts; a3's does.

If something has to be corrected

An already exported invoice cannot be changed. Reopen it, correct it, review it again and generate the file once more: it will come out in a new batch. If a3 had already imported the previous one, correct it there too.

Warnings about the accounts in the file

The pre-check warns (without blocking the export) about what is usually a setup mistake: a customer sub-account on a received invoice (or a supplier one on an issued invoice), an income account on an expense (or an expense account on income), several different tax IDs on the same sub-account (in a3 they will all end up on one record) and the same tax ID with different sub-accounts in the file. If the client has imported their a3 chart of accounts, it also warns about third-party sub-accounts that were typed in or remembered and are not in the chart. The generic ones and those the program numbers itself are not flagged: they are intentional.

File format: 512 or 256

In the client's a3 settings (and as a firm-wide value) you choose the File format for a3. The 512-position one (with SII) is the one for current versions and the usual one. The classic 256 one is needed by older versions and is the only one that also carries the model 340 and 347 extension records, imports, due dates, account registrations with their tax ID and a note with the Guilda number on every entry. If you are unsure which to use, leave 512.

Data for models 340 and 347 and for imports

On the invoice page, Data for models 340 and 347 and for imports collects the special cases: investment good (goes in both formats), model 340 key (receipt or travel agencies), DUA number, representative's tax ID, self-invoice, cash amounts and property transfers for 347, and the due date, payment method and IBAN. An import (operation type Import) is only exported in the 256 format and with its DUA.

Each line also carries its Form: by default the 349 one that applies and, for purchases with withholding, 115 (19 percent), 110 professionals (15 and 7) or 110 agricultural (2 and 1). You can change it by hand.

If an invoice already went out and you correct it

An exported invoice is reopened, corrected and reviewed again. Before exporting it again, the invoice page and Check first warn that it already went out in file #N and, if a3 had confirmed it, that it would be duplicated: correct it directly in a3 or delete it there before importing the new file. In What is left to close, the To correct in a3 column counts them.

Status of each file

In Generated files you note, after importing it in a3, whether the file was Imported or Rejected by a3 (with the reason it gave). It is your own note: it does not change the invoices. A rejected file stands out in What is left to close.

Receipt and payment entries

In Generated files → Receipt and payment entries you choose a client, the already exported invoices that have been collected or paid, and the date, and download a file with their entry: the payment to a supplier (debit the supplier, credit the bank) or the receipt from a customer (debit the bank, credit the customer), using the bank or cash account from the settings. It only works with the 256-position format. Invoices with an entry are marked so they are not repeated (there is a box to repeat), the file is saved with the Receipts and payments label and goes through the same pre-check, which also checks that every entry balances. A credit note is not included.

Warnings in Today

Files rejected by a3, and those that have gone three days or more without being marked as imported or matched against a3's return, appear in your Today tray.

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