Splitting Deductions
For CPG brands that have multiple product lines or sell to retailers via distributors, it's important to split deductions in order to have visibility into spend buckets per product and per retailer. Distributors often pass through individual deductions that include charges from hundreds of different retailers and products.
These backups come in the form of PDFs that contain thousands of lines of deductions, which traditionally, could need to be manually allocated. Because of that, its extremely challenging and time consuming to track and understand how much you're actually spending at your indirect retailers and products.
In Confido, we can automatically split all chargebacks out by retailer and product, which is a major unlock for brands trying to build Retailer and SKU P&Ls. We'll walk through how you can manually adjust splits, but Confido will split deductions automatically.
Let's go through it!
- Find the deduction you'd like to split
- Click "Allocate"
- Select the tables in the backup that you'd like to allocate.
- Click "Select Columns" to move to the next screen
- Ensure the Mapped Columns are accurate. These will auto-populate.
- Click "Finalize" Allocation to move to the next screen
- Map Reasons to the matching reason and fix any other standard data formatting.
- Click "Import"
- BOOM! We split the deduction into 3 different lines that are segmented by amount and deduction reason.
