Posting payments from CAMT files
GrandTotal gives every invoice a reference that comes back with the payment. GrandTotal reads it from your bank's CAMT file and posts the payment to the right invoice.
What is CAMT?
CAMT (Cash Management) are the bank messages of the ISO 20022 standard: XML files that banks in the SEPA area and in Switzerland provide, replacing the older MT940 format. CAMT.053 is the electronic account statement, CAMT.054 reports individual credits or debits.
The reference
In the SEPA QR code an RF reference according to ISO 11649, built from the invoice number – for example RF08 2026 0415 – follows the invoice number in the remittance text; when your client scans the code, it goes into the transfer. On a QR-bill the code carries the same RF reference with a regular IBAN, and the 27-digit QR reference with a QR-IBAN. GrandTotal also finds an RF reference typed into the remittance text by hand – the check digits rule out mix-ups.
Open the file
Download the account statement (CAMT.053) or the credit notification (CAMT.054) as XML from your e-banking and open it with GrandTotal – or drag it onto the window, several files or a whole folder at once. Each payment is recorded on its invoice with booking date and amount, and the open balance goes down accordingly.
What doesn't match
The "Payments" window shows the result. Bookings whose reference belongs to no invoice appear in red; you drag them onto the right invoice by hand. If an invoice is already paid, GrandTotal rejects the booking instead of posting it twice.
Without lifting a finger
With GrandTotal XL & Classic you don't even need to open the file: GrandTotal notices newly downloaded CAMT files and posts the payments itself. A notification announces each incoming payment, and the overview lists it under "Recent Payments". A booking with the same amount and date as a payment already recorded is skipped.
At a glance
Formats
CAMT.053 and CAMT.054 as XML
QR-bill with QR-IBAN
QR reference
QR-bill with IBAN
RF reference in the code
SEPA QR code
RF reference in the remittance text
No reference
Drag onto the invoice by hand