Skip to content
Guide

Search the Guide

Enter a query to search the Guide.

Íslenska
Menu
On this page

Match entries by hand

You match entries that didn't match automatically in RdN Reconcile. You can let the system suggest a match or mark the entries yourself, for example when one receipt in the bank pays several invoices.

Scenario

Prófun hf. pays Dæmi ehf. three invoices with one transfer. The bank has one entry, Business Central has three. Automatic matching can't handle that, so the accountant marks the four entries and confirms the match.

Before you start

Walkthrough

Let the system suggest a match

  1. Choose Suggest Match (Shift+F11). The system finds a bank statement line and a ledger entry with the same amount and marks them in Marked.

    Suggest Match is in Functions.

    Suggest Match

  2. If the suggestion is right, choose Confirm Match (F9).

  3. If it's wrong, choose Invalidate Match. The marks are removed and the system doesn't suggest the same pair again.

  4. Repeat until no more suggestions come.

Mark entries yourself

  1. Select Marked on the entries in Bank Statement Lines and Bank Account Ledger Entries that belong together. You can also select several lines and choose Mark Selected.
  2. Compare Sum of Marked Entries in both parts of the page. They should be equal, and Total Sum at the top of the page shows the difference.
  3. Choose Confirm Match (F9). If the entries aren't all on the same day, the system asks Entries are not all on the same day, do you still want to reconcile? Answer yes if they belong together.

The example below marks one ISK 2,000 deposit against one posted bank account ledger entry. Both Sum of Marked Entries fields show 2,000 and Total Sum is zero. The match hasn't been confirmed.

Equal marked entries and Confirm Match

Recall a match

  1. Choose Filter to Matched to see matched entries.
  2. Mark one of the entries in the match and choose Recall Match.
  3. Answer yes to Recall match %1?. All entries with the same Reconciliation ID become unmatched again.

Result

The marked entries get a shared Reconciliation ID and disappear from the list of unmatched entries.

What can go wrong

  • Amounts do not match! The sum of the marked entries isn't the same on both sides. Check Total Sum and mark a missing entry or unmark a wrong one.
  • Choose entries to reconcile No entry is marked.
  • Choose ReconID to recall The marked entry hasn't been matched. Choose Filter to Matched first.
  • A ledger entry that belongs elsewhere shows. Narrow the list with Date filter or the filter actions.

All messages are in Help.