Tracking Rebate Amounts

The way you process rebates depends on differences in the purchase order cost and rebate cost, and how the vendor pays the rebate amount.

Process rebates using either the suggested or alternative method described below:

Suggested Method for Rebate Tracking

  1. Create a balance sheet account named "Rebates Receivable" in the General Ledger.

  2. Define rebate information for customers in Customer Maintenance, and set up sell and cost overrides in Sell Matrix Maintenance. The following guidelines apply to selling and buying rebate products:

  1. Post the difference between the normal and rebate cost to the Rebate Receivables G/L account. The debit amount is the difference between the normal cost and the rebated cost of the items.

For example, if a widget's normal cost and vendor invoice cost is $100.00 and the rebate cost is $80.00, the difference of $20.00 is the adjustment to the Rebates Receivable account.

  1. Run the Customer Sales Rebates Report, and submit it to the vendor as a request for rebate payment. We recommend scheduling the report to run once a month.

  2. Process the rebate payment from the vendor as follows:

The Rebates Receivable account will display the pending or outstanding amount of rebates. The sum of the debits is the total rebate amount that has been processed to date.

Alternate Method for Rebate Tracking

  1. Create a balance sheet account named "Rebates Receivable" in the General Ledger.

  2. Define rebate information for customers in Customer Maintenance, and set up sell and cost overrides in Sell Matrix Maintenance. The following guidelines apply to selling and buying rebate products:

  1. Run the Customer Sales Rebates Report, and submit it to the vendor as a request for rebate payment. We recommend scheduling the report to run once a month.

  2. Create a journal entry to adjust the General Ledger and reconcile the difference between the normal and rebated cost in the Inventory G/L account as follows:

This records a pending or outstanding amount of rebate to be received from the vendor. The Rebates Receivable account is credited as each rebate amount is received.

  1. Process the rebate payment from the vendor.

The Rebates Receivable account shows the pending or outstanding amount of rebates. The sum of the debits is the total rebate amount that has been processed to date.

Note: If the vendor rebate payment received is for less than the original amount that was posted as a debit to Rebates Receivable, a G/L Journal Entry is required to correct the Inventory-COGS. (Debit Inventory-COGS and Credit Rebates Receivable) This entry clears the open rebate amount and reconciles the Inventory account for costs that were never rebated.

See Also

Running the Customer Sales Rebates Report

Pricing Rebate Overview