Matching bank payments

From a bank statement

Download a CSV or XML camt.053 statement (SEPA statement) from internet banking. Vystav reads it by its column headers; you do not select a bank-specific format.

1. Open Payments and click Upload bank statement under Matching bank payments.
2. Open the statement file in a text editor such as Notepad, copy all its contents and paste them into the field.
3. Click Find matches. Vystav shows how it recognised the statement and how many incoming payments it found. It skips outgoing payments.
4. For each payment, you see a suggested invoice, the reason and the confidence of the match. Confirm the suggestion with Match.

No payment is recorded automatically; you confirm each one. Vystav looks for a match among open invoices, including advance invoices, using the variable symbol, amount and invoice number in the payment message. A payment in a different currency from the invoice weakens the match.

Vystav lists rows it could not read with the reason. Record an unmatched payment manually on the invoice detail using Record payment. You can upload the same statement again; payments already recorded are not recorded twice.

From bank notifications

Your bank sends an email or SMS about an incoming payment. In Payments, paste the notification into Notification text under Bank notifications, then click Process.

• If the variable symbol and amount match exactly one open invoice, the payment is recorded automatically.
• Otherwise, the notification waits in Awaiting assignment with invoices it could belong to. Use Assign to select the correct invoice, or Ignore for a notification you do not need.

Vystav reads the amount, payment direction, variable, constant and specific symbols, payer and payer's account from the text. It leaves anything it cannot find blank rather than guessing.

Automatic forwarding from email

Your mailbox can automatically send bank notification emails to Vystav. An owner or administrator opens Automatic forwarding from email under Bank notifications and clicks Create address. This is a web address to which the email text is sent using a POST request, not an email inbox.

Make or Zapier

An email trigger (Custom mailhook in Make or Email by Zapier), a mailbox rule that forwards bank notifications to it, and an HTTP POST step sending the email text to your address.

Gmail

A filter that labels bank notifications “banka”, and a Google Apps Script prepared by Vystav. After running nastavSpustanie once, the script sends unread notifications every 5 minutes.

Do not share the address: anyone who knows it can send notifications to Vystav. Create new address revokes the old address, after which you must update the mailbox rule.