Who paid which invoice: matching payments from a bank statement
The invoice is issued, the money has arrived, but for which invoice? With more clients, partial payments and foreign currency, tracking it by hand quickly becomes a job of its own. Here is how it works manually, semi-automatically and fully on its own.
Why it matters to know what has been paid
- The reminder goes to the right client. Clients who haven’t paid get a reminder, and those who have don’t get an awkward email.
- You see how much money you actually have. Issued is not the same as collected: tax and contributions are paid from what you collect.
- Your accountant gets tidy data. For a sole proprietor keeping full books, the bank statement is part of the monthly paperwork, and a matched payment saves “what is this?” questions.
For a flat-rate entrepreneur, the 6 and 8 million limits are calculated from issued invoices, not paid ones: collection doesn’t change the limit, but it changes everything else.
What helps identify a payment
- The invoice number in the payment reference (poziv na broj) or the payment purpose. A client who pays by scanning the IPS QR code doesn’t copy anything: the invoice number, the amount and the account are already in the payment order.
- The exact amount. A payment of 48,000 dinars, when there is only one invoice for 48,000, almost certainly belongs to it.
- The payer’s name. When the name on the statement matches the client on the invoice, that is the third confirmation.
Three ways, from manual to automatic
| Manual | Statement import | Statement by email | |
|---|---|---|---|
| How | open e-banking and mark each invoice | export the statement (XML, Excel, CSV) and upload it | the bank emails the statement, the program reads it by itself |
| Your work | everything | export + confirmation | confirmation only |
| Errors | a payment is easily missed | rare | rare |
| In Stavka | Start (free) | Pro | Biznis |
Statement by email: set it up once, it runs by itself
Most banks offer a daily statement by email in e-banking. Once you forward that email to the program, matching no longer depends on whether you remembered to export the statement. It works with any email: Gmail, Outlook or your company email.
- In e-banking, turn on statements by email, in XML format if the bank offers a choice.
- In your email, create a rule that also forwards emails from the bank’s address to the address the program gives you. In Gmail this is a filter with forwarding, in Outlook a rule (Rules), and something similar exists in other email services. If e-banking allows several addresses for the statement, you can enter the program’s address directly and no forwarding is needed.
- When the statement arrives, the payments wait for your confirmation: next to each one it says which invoice it probably closes and why.
Only the bank email picked out by the rule is forwarded; the rest of your mail stays in your inbox.
How it works in Stavka
Stavka reads XML statements from Halcom e-banking (e.g. Banca Intesa, including incoming payment notices), XML statements from Raiffeisen Bank, international camt.053, SWIFT MT940 (statement for legal entities), Excel and CSV, and among PDFs the monthly statement from Yettel Bank and the foreign currency account statement from Banca Intesa. For each payment it suggests an invoice, a proforma invoice or an advance, based on the number in the payment reference or purpose, the amount and the client name, labeled Certain, Likely or Possible. Foreign currency payments are compared only with invoices in the same currency. Nothing is recorded until you confirm, and a partial payment leaves the invoice open for the remainder. Statement import is in the Pro plan, statements by email in the Biznis plan, and every new account gets Biznis free for the first 30 days. See the manual.
Frequently asked questions
Can the program see my e-banking?
No. The program only gets the statement you send it (by uploading a file or by a forwarded email). It has no access to the account and cannot make payments.
What if a client pays several invoices with one payment?
In Stavka, one payment from a statement is linked to one invoice. With a lump-sum payment, close one invoice from the statement and mark the others as paid manually.
Is a payment in euros matched with an invoice in dinars?
Not automatically: the amount is compared only in the same currency. You match a foreign currency invoice with a foreign currency inflow.