Skip to content
Guide

Search the Guide

Enter a query to search the Guide.

Íslenska
Menu
On this page

Move bank entries to a payment journal

Some entries exist only in the bank, for example bank charges, interest and receipts that haven't been posted. From RdN Reconcile you move them to a journal, post them and then match them.

Scenario

In the monthly reconciliation at Dæmi ehf., bank charges and a receipt from Prófun hf. that nobody has posted are left over. The accountant marks the entries, moves them to a payment journal, posts and runs automatic matching again.

Before you start

Walkthrough

  1. Mark the entries in Bank Statement Lines and choose Move marked to Payment Journal. To move all unmatched entries, choose Move to Payment Journal.

    The journal transfer actions under Functions

    The request asks where to put the entries.

    The journal transfer request before selecting a destination

  2. Select Gen. Journal Template and Gen. Journal Batch and choose OK.

    Choosing the existing INNGREIÐ template and ALMENNT batch

  3. If the journal already has lines, the system asks There are %1 entries in journal already, do you want to delete them? Answer yes to start with an empty journal, or no to add to it.

  4. The journal opens. The system has filled in the lines:

    • A receipt where the payer's national ID (kennitala) belongs to a customer goes to the customer and is applied to an open entry based on the reference.
    • A payment where the national ID in the reference belongs to a vendor goes to the vendor.
    • An entry with a category code that is mapped to a G/L account goes to that account.
  5. Fill in the account on lines the system couldn't fill in, and apply to open entries if needed.

  6. Post the journal.

  7. Go back to RdN Reconcile and choose Automatic Match. The newly posted entries match the bank entries.

Result

The missing entries are posted to the bank account in Business Central and matched against the bank.

Next, reconcile the bank account.

What can go wrong

  • There are no entries to move No entry was marked, or all entries are already matched.
  • A line comes in without an account. The system found no customer, vendor or mapping. Fill in the account by hand.
  • A line comes in with an empty amount. Empty Amount If Applies To Doc Is Missing is turned on and no document was found to apply to. Apply the line and fill in the amount.

All messages are in Help.