Skip to main content
Q19 Files

How to generate file Q19 for bank remittances

Updated over 2 years ago

Index

FAQ

Q19 files

To make a remittance you have to generate the Q19 file and previously you will have to have issued the receipts. See the help article for Issuing Receipts.

  1. From the Main Menu, click on Dues.

  2. Click on Q19 Files.

  3. Click on New.

  4. Fill in the desired fields.

  5. In the Available Remittances section, we can view, select and filter the receipts to be issued.

  6. Click on the blue button Reset, upper part.

  7. In the new window, click on the Download Q19 button.

  8. Save the file (.txt extension) to be sent by email to our bank. This file can be downloaded as many times as necessary.

Special button. Simulate Q19

To make a simulation of the remittances, follow the instructions below:

  1. From the Main Menu, click on Quotas > Q19 Files.

  2. Click on Simulate Q19.

  3. Fill in the requested fields with the red asterisk, Filter the list and select the records that will simulate the remittance.

  4. Click on Simulate.

  5. Select the folder where to download the simulation file and Click on Save.

  6. Open the downloaded file with extension (.xml) and consult.

Specify the creditor/presenter prefix of the company to issue a SEPA remittance

1. From the Configuration Menu, click on Invoicing > Companies.

2. Click on the ID to open the company to which you want to add the prefix.

3. In the Domiciliations Section, fill in the desired fields of Creditor Prefix and Presenter Prefix.

4. Click on Save.

In case you do not know the correct prefixes, fill in both fields with the prefix "000".

The "Presenter Prefix" is the first one that appears in the XML file that is downloaded when generating a Q19. The next and last to appear is the "creditor prefix". They are distinguished because they are both formatted as follows:

ES53000BXXXXXXXXXXXX

Where BXXXXXXXXXXXX is the Company's VAT number and 000 is the presenter/creditor prefix.

How to mark a receipt as returned

From the Main Menu

  • click on Dues > Q19 Files

  • Find and select the File ID of the returned receipt.

  • In the "Lines" section, find the Client of the returned receipt.

  • Select that line and check one of the following options:

    • Check returned if you expect to collect this sale in the future and for it to be included in future remittances.

    • Mark returned and do not direct debit if you are certain that this client will not pay this debt, and to avoid adding this line to future remittances and incurring more return costs.

  • Click on Accept.

    Note: here you will be able to generate a rectifying invoice if you wish.

At this point the system:

  • Creates a negative bill with the payment method "Direct debit".

  • Creates a ticket in negative for the same amount.

  • Mark this payment as returned.

  • At the moment the system does NOT block this member and still allows online booking. But we have a manual option in the client's file (Blocked option) where you can prevent it.

How to pay a returned bill

From the Main Menu,

  • Click on Fees > Files Q19

  • Find and select the File ID of the returned bill.

  • In the "Lines" section, find the Client of the returned bill.

  • Click on Pay at POS

  • Click Finish.

  • Select the Payment Method.

How to delete file Q19

  • You cannot delete a file Q19.

  • All lines must be selected.

  • Select the Mark as returned button.

  • And generate a new Q19 again.

Error message: 504 Gateway Time-out

If you see this message when trying to generate a Q19 File, go to this link for more information.

Did this answer your question?