Summarizing payments

With Continia Banking, you can consolidate two or more due ledger entries into a single payment. This can be useful if the bank charges a fee for each payment line.

If you enable summarization on the vendor card and in the payment journal setup, the system automatically consolidates payments per vendor. This happens when you make payment suggestions in the journal. However, certain limitations prevent the combination of all entries in a summarized payment. For payments to be consolidated, the following values on the entries must be the same. If any of these values differ, you get a separate payment for each group of entries:

Value on the entryRequirement
Due dateThe entries must share the exact due date.
Vendor, customer, or employeeThe entries must be related to the same vendor, customer, or employee.
CurrencyThe entries must be in the same currency.
Posting dateThe posting date becomes the payment's execution date. Entries with different dates can't share one payment.
Charges (cost type)If you add or change the charges on a payment method, entries that were posted before the change don't have that value. Those entries aren't combined with entries that do have it.
External codeDifferent external codes on the vendor entries lead to separate payments.
Z4 reporting codeDifferent Z4 reporting codes on the vendor entries lead to separate payments.

Bemærk

If you add charges to a payment method, new invoices that use that payment method get the charges automatically, and their payments are summarized again. Existing entries keep their original value.

To set up summarization on the payment journal

From the payment journal, you can access the Summarizing Payment Setup page, which helps you control how payment summarization occurs and how to consolidate multiple payments.

To set up summarization:

  1. Search () for and select Payment Journals.
  2. On the action bar, click Prepare > Summarizing Payment Setup.
  3. On the General FastTab, you can set up how to consolidate ledger entries on date and dimensions:
    • Date Deviation - when consolidating payments, due dates on ledger entries usually need to match for summarization to happen. However, the Date Deviation field lets you enter a date formula that controls the allowed deviation in due dates for summarization to occur. For example, if you have two invoices due with dates two days apart, they might not be summarized by default. You can consolidate these entries by setting up a formula such as 2D (indicating a deviation of two days). The system then recognizes them for summarization even with a slight date difference. The system summarizes the entries to be paid on the first of the two days.
    • By Dimension - usually, dimensions are reset during summarization, but this feature lets you specify the dimensions that must match for consolidation. These dimensions can represent different aspects of a transaction, such as departments, projects, locations, or cost centers within an organization. By summarizing payments by dimension, you can group ledger entries with similar dimension values. For example, you might have different cost centers and want to summarize payments per cost center. In this case, select the cost center on the Dimension Selection page.
  4. On the Exclude Entry Types FastTab, you can exclude specific ledger entries from the summarization routine:
    • Exclude Credit Memos - select an option to exclude credit memos from the summarization routine. In regular payment runs, credit memos, which are often used for refunds or adjustments, may not be required. Keeping credit memos separate prevents confusion and errors in accounting and gives accounting full manual control of when to pay and when to avoid overpaying. The options are:
      • Recipient Specific - if selected, the summarization routine is determined by the vendor card setup.
      • No - Continia Banking doesn't run the summarization routine, regardless of the vendor card's setup.
      • All - Continia Banking excludes all entries from the summarization routine, irrespective of the vendor card's setup.
    • Exclude Refunds - select an option to exclude refunds from the summarization routine. Refunds or credit memos often represent unique transactions that require specific attention. They might result from returned goods, adjustments, or other special circumstances. By handling them separately, you make sure that these transactions are properly reviewed and processed to avoid overpayment. For more information on the options and their outcome, see the description of the Exclude Credit Memos field.
    • Exclude Payments - select an option to exclude payments from the summarization routine. You can exclude certain payments from summarization for various reasons. For example, you might want to maintain clarity or handle complex transactions that require individual attention. For more information on the options and their outcome, see the description of the Exclude Credit Memos field.
  5. On the Matching Requirements FastTab, select fields where you can instruct the system to ensure specific values match before allowing summarization:
    • Credit Memo Date:
      • If enabled - the date on the credit memo must have the same value as the other entries before summarizing is allowed.
      • If disabled - ledger entries are consolidated without considering the date on the credit memo.

To enable summarization on the vendor, customer, or employee card

To enable summarization, a few setup options are available on the vendor, customer, and employee cards.

Vigtigt

For the summarization details on the vendor, customer, or employee card to take effect, you must set the respective fields on the Summarizing Payment Setup page to Recipient Specific. For more information, see To set up summarization on the payment journal.

To allow summarization for a vendor, customer, or employee:

  1. Search () for and select Vendors, Customers, or Employees.
  2. Open the card you want to set up summarization for.
  3. On the card, on the Payments FastTab, there are several fields to help decide whether to summarize payments and what to exclude:
    • Allow Summarizing Payments - enable to allow summarization for this vendor, customer, or employee when creating payment suggestions.
    • Exclude Credit Memos When Summarizing Payments - enable to exclude credit memos from the summarization routine.
    • Exclude Refunds When Summarizing Payments - enable to exclude refunds from the summarization routine. Refunds or credit memos often represent unique transactions that require specific attention. They might result from returned goods, adjustments, or other special circumstances.
    • Exclude Payments When Summarizing Payments - enable to exclude payments from the summarization routine. You can exclude certain payments from summarization for various reasons. For example, you might want to maintain clarity or handle complex transactions that require individual attention.