Deductions Reconciliation 2.0

How To Upload & Add ERP Transactions

ERP Transactions refer to the deductions created in your ERP System that require validation.


How To Upload & Add Repayments

Repayments refer to ERP Transactions that are of the opposite amount of a deduction. If you upload deductions into Vividly as positive amounts, Repayments will be uploaded as negative amounts.


How To Attach & Manage Invoice Backup Files

Backups are the invoice files received from Retailers/Distributors detailing what the deduction is for. Good backup lists the customer, product, promotion timeframe, spend rate, and clearly identifies what type of promotion is being taken. Associate each deduction with the corresponding backup within Vividly for validation. This can include PDF invoices, contracts, email correspondence, etc. Organized backup files are important for audit reviews, and storing them in Vividly eliminates the need for you to store backup externally.


Bulk Editing in the Invoice Header Table

Quickly enter invoice details using the multi-select edit functionality.


Auto-Assign Backup Files to Create Invoices

Say goodbye to having to manually attach dozens of backups to a single transaction. Our new DRM Auto-Assign Backup feature will automatically create invoice headers and attach backups for as many files as you select.


Clearing Invoice Lines to a Promotion (Simple Resolution)

Simple Resolution allows you to quickly resolve a deduction by clearing it to a promotion or GL account. This method is typically used for familiar deductions that you receive more frequently that may not require in-depth validation.


Clearing / Writing-Off to a GL Account (Simple Resolution)


Scanning a Deduction Invoice Backup & Uploading Invoice Lines

Scanning and Uploading Invoice Lines is a method to validate larger deductions with many invoice lines. Scanning converts complex forms of backup into functional spreadsheets which are displayed as invoice line details within Vividly. This is a necessary step to efficiently drill down to a granular level of deduction review.


Matching a Deduction to a Promotion

Use the Deduction Matcher to match your scanned invoice lines to an approved promotion entered in Vividly by your sales team

. This automates the process of matching deductions to the appropriate promotions by considering the following criteria: Customer, Product, Promotion Type, Timeframe, and Spend Rate.


Mapping Customer and Product Codes When Uploading Invoice Lines


Batch Clearing Invoices Lines to a Promotion and Clearing Exact Amounts



Invoice Line Aggregation



Flagging a Deduction Invoice Line for Dispute or Sales Review


Linking & Offsetting Repayments


Error Handling - Voiding and Reversing Cleared Invoices


Understanding the Settlement Report

The Settlement Report provides real-time visibility into all deductions that have been resolved in Vividly. This report will be used to clear the deduction in your ERP system.


Understanding the Open Deductions Report

The Open Deductions Report provides users with a data export of all deductions currently open in Vividly. The report provides statuses for the transaction, and any linked invoices/invoice lines. It can be especially useful for managers to get a high-level snapshot of the status of all open deductions.


Settlement & Open Deduction Reports Continued


Did this page help you?