Skip to main content

Set reconciliation start

Reconciliation start is the date when Payfriend takes over bank reconciliation. Payfriend sets it when you connect the bank. How to change it under Settings → Accounting.

Written by Nicki Elgaard

Reconciliation start is the date when Payfriend takes over responsibility for bank reconciliation. Everything before that date is history that should not sit as unreconciled work in Payfriend. You can still see the transactions, but they are marked Before reconciliation start and do not count as work.

Payfriend sets the date when you connect a bank account. It shows under Bank as Reconciled from with a date and a Change button.

Before you start

  • The bank is connected, and transactions have been fetched

  • Accounting is connected. Then Payfriend can work out what is already booked and suggest a date

  • You have permission to reconcile the bank

How to do it

1. Open the settings

Go to Settings → Accounting → General setup, or click Change next to Reconciled from under Bank. If there is no date, Bank shows the message No reconciliation start date with an Open settings button.

2. Find the Reconciliation start card

The card lists each bank account with its date and whether it was Chosen by you or is the Default from Payfriend. Click Change next to the account you want to change.

3. See Payfriend's suggestion

The Reconciliation start window checks what is already reconciled. If Payfriend can find the latest day when bank and books agreed, it says for example Bank and books agreed through a date, and suggests that date. That is usually the right choice.

4. Confirm or choose a date

Under Reconciliation starts you accept the suggestion or choose a date yourself, for example with the shortcuts Today, This month or This quarter. Choose a deliberate cutover day, such as the start of a month after a manual reconciliation. Click Confirm.

  • The date can be at most 2 months ahead.

  • If your accounting only goes back to a certain date and you choose an earlier start, the oldest transactions cannot be reconciled automatically against the accounting. You then have to match them manually.

  • Payfriend only fetches receipts a limited number of days back. If you choose a start before that, you must confirm that you reconcile that period yourself.

5. Get going

Once the date is set, Bank only shows the work after the start date. Match receipts, confirm suggestions, or swipe to catch up on mobile.

If no date is set

If Payfriend can suggest a start date, the tabs other than All show the message Reconciliation has no start date until you choose one. Click Open settings, or See all transactions instead. If Payfriend cannot suggest a date, only a banner is shown, and you can keep working.

Check that it worked

  • The reconciliation start shows next to Reconciled from under Bank

  • The message about a missing start date is gone

  • Transactions before the start date show as Before reconciliation start and are not new unreconciled work

Common problems

Symptom

Cause

Fix

No suggestion for a date

Accounting not connected, the account is in a foreign currency, the bank account has no ledger account, or there are no transactions yet

Choose a start date yourself. If the ledger account is missing, you can choose it in the window. If it says we are still waiting for postings from the accounting, try again shortly

We could not find a day when bank and books agreed

There is a difference today, and no earlier day agreed

Choose a date that matches your manual reconciliation

Huge unmatched queue

Start date too far back

Choose a later cutover date that matches your manual reconciliation

Balance does not match

Different accounts or missing postings

Next steps

Did not find an answer? Write to us via the chat in the app, or at Contact.

Did this answer your question?