Skip to content
Guide

Search the Guide

Enter a query to search the Guide.

Íslenska
Menu
On this page

Create purchase invoices from card transactions

You create purchase invoices from card transactions in RdN Reconcile. The system finds the vendor from the merchant on the transaction with a credit card mapping and attaches the receipt to the invoice. To pay it from the card's bank account when posting, use a payment method with that bank account as its balancing account. If the merchant is mapped to a G/L account or bank account, no purchase invoice is created; the transaction goes to a general journal instead.

Scenario

Employees of Dæmi ehf. buy fuel, flights and software with company cards. The fuel always comes from the same merchant, so the accountant maps it to a vendor and marks that a purchase invoice should be created automatically. Software subscriptions go straight to a G/L account, so he maps that merchant to the G/L account and moves its transactions to a general journal. Every month he creates all the invoices at once and handles the one-off transactions himself.

Before you start

  • You've imported the card transactions.
  • The vendors, G/L accounts or bank accounts you map to exist in Business Central.
  • If purchase invoices from card transactions should get a separate number series, it's selected in the reconciliation setup.
  • If posting should also pay the invoice from the card account, a payment method has that bank account as its balancing account. Check the payment method on the invoice before posting.

Walkthrough

Map a merchant to a vendor, G/L account or bank account

  1. In Bank Statement Lines, choose Credit Card Mapping. The Credit Card Vendor Mapping page opens.

    Credit Card Vendor Mapping

  2. Enter Card Acceptor ID as it is on the card transaction. You can end it with *, for example ELDSNEYTI*, to cover all of the merchant's locations.

  3. Select the Account Type: Vendor, G/L Account or Bank Account. A vendor mapping creates a purchase invoice. A G/L account or bank account mapping moves the transaction to a general journal.

  4. Select the account in Account No. Its name shows in Account Name.

  5. If the merchant's transactions should be handled by the automatic action, select Create Purchase Invoice for this vendor for a vendor, or Create General Journal Line for this account for a G/L account or bank account.

  6. If the mapping applies to one card only, choose Make Card-Specific. With Set Card Default Vendor you select a vendor for all the card's transactions that have no other mapping.

If you change the Account Type, Account No. and the switch that no longer applies are cleared.

Mapping Priority shows which mapping applies: first a mapping for the card and merchant, then a mapping for all cards, and last the card's default vendor. A master mapping for a merchant therefore wins over the card's default vendor.

When you close Credit Card Vendor Mapping, Create Purchase Invoice and Create General Journal Line on the card transactions are updated from the mapping.

Create purchase invoices

  1. To create invoices for certain transactions, mark them in Marked and choose Create Purchase Invoice for marked lines.

  2. To create invoices for all transactions where Create Purchase Invoice is selected, and move transactions where Create General Journal Line is selected to a general journal, choose Create Purchase Invoices for auto lines. Before creating a new invoice, the system first looks for one with the same Payment Reference. It also checks for posted and unposted invoices for the same vendor, with a posting date from one day before to one day after the transaction date and an amount including VAT that differs by less than 0.01 from the absolute transaction amount. For a multi-line run, it links the line to a matching invoice without asking. For one line, you can choose to open the similar invoice; if you decline, the system creates a new one.

  3. If there's no mapping for the merchant, the system asks No credit card mapping exists for "%1". Do you want to create a mapping now?

  4. The system shows a summary: how many invoices were created, how many lines were linked to an invoice that already existed, how many lines go to a general journal and how many were skipped and why.

  5. If lines are mapped to a G/L account or bank account, continue with Move card transactions to a general journal below. Otherwise the system offers to open the purchase invoices that were created.

  6. Open the purchase invoices, fill in the G/L account on the line if it's missing, and post.

The example below is an open invoice for Prófun hf., with transaction reference WP23-DEMO-TRANSACTION and a total of ISK 246. It hasn't been posted.

Open purchase invoice created from a card transaction

A new invoice gets the transaction date, the transaction ID as vendor invoice number and payment reference and prices including VAT. If a payment method has the card's bank account as its balancing account, the system selects it. The receipt goes with it as an incoming document. The invoice number shows in Purchase Invoice No. on the card transaction. If a line is linked to an existing invoice, that invoice keeps its own details.

Move card transactions to a general journal

Transactions mapped to a G/L account or bank account don't get a purchase invoice. They go to a general journal in the same run that creates the purchase invoices.

  1. When you run the action on more than one line, the summary asks Do you want to move the lines mapped to a G/L account or bank account to a general journal now? Choose Yes. If you choose No, the lines aren't moved and the system offers to open the purchase invoices. For a single line, the summary shows and the transfer opens right after.
  2. On RdN Trans. Bank Rec. to Gen. Jnl., select the Gen. Journal Template and Gen. Journal Batch.
  3. If the journal isn't empty, the system asks There are %1 entries in journal already, do you want to delete them? Choose No to add the lines to the existing ones.
  4. The general journal opens. Review the lines and post the journal as usual.

Each line gets the mapped account as the balancing account, the transaction ID in External Document No. and the receipt as an attachment. A transaction that's already in a journal, or has been posted from one, isn't moved again.

Attach a receipt later

If the receipt hadn't been fetched when the invoice was created, open the purchase invoice and choose Attach Receipt once the image is there. The system shows The receipt was attached.

Result

The purchase invoices are posted to the vendors. With the card account's balancing payment method, they are also paid from that account. The payments match the card transactions when you reconcile the card.

What can go wrong

  • A line was skipped without a credit card mapping or with no account on the mapping. The lines are still marked. Fix the mapping and run the action again.
  • A transaction isn't moved to a general journal automatically. Confirm that the Account Type is G/L Account or Bank Account and that Create General Journal Line for this account is selected on the mapping with the highest priority.
  • Wrong account type. Only a vendor mapping can create a purchase invoice, and only a G/L account or bank account mapping can create a general journal line. Select the switch that matches the Account Type.
  • A line was skipped without a Related-Party Name. The bank didn't send a merchant with the transaction. Create the invoice by hand.
  • A Purchase Invoice %1 for vendor %2 with amount %3 on %4 already exists. Do you want to open it instead of creating a new one? A posted purchase invoice can match too. The system can find invoices for the same vendor with a posting date from one day before to one day after the transaction and an amount including VAT that differs by less than 0.01 from the absolute transaction amount. Check it before creating another invoice.
  • A Posted Purchase Invoice %1 for vendor %2 with amount %3 on %4 already exists. Do you want to open it instead of creating a new one? Open it and confirm that it belongs to the transaction before creating another invoice.
  • Enter at least one character before the wildcard. The card acceptor ID can't be just *.
  • No receipt comes with the invoice. Use Attach Receipt on the purchase invoice once the image is there.

All messages are in Help.