This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| how_the_whole_deduction_process_works [2025/09/25 17:41] – tina.robles | how_the_whole_deduction_process_works [2025/09/25 18:11] (current) – tina.robles | ||
|---|---|---|---|
| Line 70: | Line 70: | ||
| {{: | {{: | ||
| + | |||
| + | **DEDUCTION REBILL REPORT** | ||
| + | |||
| + | A comprehensive Rebill tracking report developed based on manufacturer feedback, the deduction rebill report addresses the need for efficient tracking of invalid deductions across all transactions. Our TPM tool generates a consolidated spreadsheet containing all rebillable deductions for streamlined distributor communication. | ||
| + | |||
| + | Why Use This Report: | ||
| + | * Replace time-consuming individual letter downloads with one comprehensive file | ||
| + | * Provide customers with an organized overview of all invalid deductions | ||
| + | * Simplify the repayment request process through consolidated documentation | ||
| + | * Enhance professional communication while reducing administrative overhead | ||
| + | |||
| + | This approach is highly recommended for distributor repayment requests, offering superior efficiency and clarity compared to traditional individual letter distribution. | ||
| + | |||
| + | __HOW TO DOWNLOAD THE REPORT__ | ||
| + | |||
| + | {{: | ||
| + | |||
| + | __HOW TO READ THE DEDUCTION REBILL REPORT__ | ||
| + | |||
| + | {{: | ||
| + | {{: | ||
| + | |||
| + | **TPM REBILL REQUEST TRACKING UPDATES** | ||
| + | |||
| + | {{: | ||
| + | {{: | ||
| + | |||
| + | __COMPLETE - REBILLABLE / REBILL SENT REBILL REQUEST UPDATES__ | ||
| + | |||
| + | {{: | ||
| + | |||
| + | __OPEN – REBILLABLE / REBILL SENT DEDUCTIONS__ | ||
| + | |||
| + | {{: | ||
| + | |||
| + | {{: | ||
| + | |||
| + | **UPDATING REBILL COLLECTED DATA** | ||
| + | |||
| + | __UPDATING REPAID AMOUNTS (SINGULAR DEDUCTION)__ | ||
| + | |||
| + | {{: | ||
| + | |||
| + | __UPDATING REPAID AMOUNTS (MULTIPLE DEDUCTIONS UNDER ONE CHECK)__ | ||
| + | |||
| + | {{: | ||
| + | {{: | ||
| + | {{: | ||
| + | |||
| + | **Note:** If the deduction cannot be found, it may have been closed in TPM after the repayment was applied, which would remove it from the 1050 deduction feed. See below for instructions on viewing closed deductions. | ||
| + | |||
| + | __VIEWING CLOSED DEDUCTIONS__ | ||
| + | |||
| + | {{: | ||
| + | |||
| + | **REBILL COLLECTED REPORTING** | ||
| + | |||
| + | The Deduction Rebill Collected Report helps identify collections on rebillable deductions and track repayment success rates. | ||
| + | |||
| + | __HOW TO RUN THE REPORT__ | ||
| + | |||
| + | 1. From the navigation pane go to the ReportingDeductionRebill Collected Report | ||
| + | |||
| + | 2. Apply Filters (Optional) You can run the report with no filters or use any combination of the following: | ||
| + | * Check Number | ||
| + | * Deduction Number | ||
| + | * Deduction Company Number | ||
| + | * Claimant Company Name | ||
| + | * Deduction Invoice Number | ||
| + | * Aged Days | ||
| + | * Deduction State | ||
| + | * Deduction Label | ||
| + | * Contract Sequence (Contract ID#) | ||
| + | * Contract Title | ||
| + | |||
| + | 3. Click " | ||
| + | |||
| + | __UNDERSTANDING THE REPORT RESULTS__ | ||
| + | |||
| + | Summary Tab | ||
| + | |||
| + | Provides high-level collection data including: | ||
| + | * Deduction Company Name: The company associated with the deductions | ||
| + | * Deduction Year: Year the deductions occurred | ||
| + | * Total Rebill Collected: Sum of all collections for that company/ | ||
| + | |||
| + | Detail Tab | ||
| + | |||
| + | Contains comprehensive information for each deduction: | ||
| + | |||
| + | * Identification: | ||
| + | * Financial Data: Invoice numbers, check numbers, requested amounts, open amounts | ||
| + | * Contract Information: | ||
| + | * Collection Details: Rebill dollars collected, sent date, request number | ||
| + | * Rebate Breakdown: Requested, allowed, and recalculated amounts | ||
| + | * Additional Info: Aged days, deduction comments, claimant details | ||
| + | |||
| + | __Important Notes__ | ||
| + | |||
| + | Data Population Requirements: | ||
| + | |||
| + | * The report only shows collections when the " | ||
| + | * This field can be updated two ways: | ||
| + | 1. Manual Entry: Manufacturers can manually enter values on individual deductions | ||
| + | |||
| + | 2. Automated Feed: Via the 1057 Open Deduction CDF data feed | ||
| + | |||
| + | **Best Practice**: Ensure the rebill collection amounts are consistently recorded to maintain accurate reporting and tracking of your collection success rates. | ||
| + | |||