Bank is where you reconcile your bank transactions against invoices, bills and receipts. The goal is that the bank and the books agree, and that the Unmatched tab is empty. At the top you switch between Reconciliation, which is your work, and History, which shows every reconciliation action.
Connect your bank
Find your bank in the Search for your bank … field.
Choose the ledger account the bank should be reconciled against in your accounting.
Sign in to your online bank and grant access. Payfriend only gets read access and never sees your MitID.
If the bank returns several accounts, pick the accounts to include and a ledger account for each. Click Connect selected accounts.
Wait while the first history is fetched. The bank decides how far back it goes, up to 12 months.
If you cannot find your bank, you can import transactions from CSV or Excel instead.
The bank's consent expires periodically, and the bank can also end it earlier. When the connection needs renewing, Bank shows the message Bank connection needs renewing with a Renew button. See The bank connection has expired or been disconnected.
Check that the bank agrees
Each bank account has its own card at the top. Click a card to see that account. In the bar above the list you see the count under Unmatched, the percentage reconciled, Reconciled from, Bank balance, and when Payfriend can fetch the balance from your accounting, also Book balance and Difference. The goal is a difference of zero.
When everything is reconciled and only a small difference is left, Payfriend shows a Balance button. It books the difference to a contra account with Post adjustment. The button is not shown while there are unmatched or pending transactions, or if the difference is above the balancing limit.
Reconciled from shows the date reconciliation starts. Click Change to move it. You go to Settings → Accounting → General setup, the Reconciliation start card. You can still see transactions before the date, but they do not count as work.
Reconcile a transaction
Choose the Unmatched tab. The other tabs are Matched, Ignored and All.
Click a transaction. A window opens with Payfriend's suggestion for a receipt or invoice.
Choose the suggestion and click Approve & post.
If the suggestion is wrong, click Reject suggestion, search in Search invoices, bills and receipts, or drop a file in the window.
If you have no receipt, you can click Post without a document and choose a contra account. If the receipt is lost, you can create a Replacement voucher.
Move on with Next line, or click Skip.
If you matched the wrong thing, open the transaction and click Unmatch. The line is then unmatched again. If one transaction must cover several documents, or several documents are covered by one payment, see Split-match and partial payments.
Reconcile many at once
Tick the transactions you want to process.
Click Approve selected, Ignore or Reopen.
Approve selected only works on transactions that Payfriend has already matched automatically. Use Ignore only for items that should never be reconciled. You can always undo it with Reopen.
Fetch, import and export
Sync fetches new transactions from the bank. It also happens automatically several times a day.
Import CSV/Excel lets you upload a file from the bank. You see a preview with duplicates and auto-matched lines before you click Import.
Export the reconciliation as Export CSV or Export PDF. This requires permission to export.
Swipe to catch up on mobile
On mobile and tablet the Swipe to catch up button sits at the top. It shows one transaction at a time with the best suggestion.
Swipe right to approve the suggestion.
Swipe left to postpone the transaction.
The bar shows how many are left. When the queue is empty it says You're all caught up!
The arrow takes you back to the full list.
Find a reconciliation in History
History shows every reconciliation action, yours, your colleagues' and the automation's.
Search by amount or text in the Search transactions… field.
Filter on Action, for example Matched, Unmatched, Ignored, Reopened or Approved, and on Time.
The Performed by column shows who reconciled. If it says System, it was the automation.
Click a line to see the transaction and what it was reconciled against.
How to set it up
Go to Settings → Connections. There is a guide at the top of the page, How to connect your systems, that takes you through the setup step by step, including Connect your bank and Link the bank account to your accounting.
How much Payfriend may approve on its own, and which account small differences are booked to, you control under Settings → Accounting → Reconciliation. See How to set up Accounting.
Read also
Need help?
Click the i button at the top of the page and choose Take interactive tour to see the tour again. If you still cannot get it to work, write to us in the chat at the bottom right or at [email protected].