Deduction Reconciliation enables organisations to streamline their deduction reconciliation
processes by auto-matching customer generated debit notes with credit notes on customer
accounts. We can reconcile at SKU level, PO Number, Quantity level, Unit Price level or Value
level or any combination or number of these. Our aim is to quickly identify the deductions that
should be automatically approved and processed.

Deduction related transactions arise for many reasons and can be split into two categories,
authorized deductions e.g. Rebates , Bulk Quantity Discounts and unauthorized deductions e.g.
such as pricing discrepancies, returned product and freight issues.

Business Problem:

  • Customer requests return of e.g 1000 items of product
  • RMA/Sales Return is issued on our ERP system at original sales price
  • Product is returned with only 900 items of product
  • Goods are received into warehouse and a Credit Note generates for 900 items of product
    at the current sales price
  • Customer then takes a deduction for 1000 items of product at incorrect price
  • Credit note on AR ≠ Deduction is included in Payment remittance
  • The AR analyst then has to search through a lot of documentation in order to investigate
    and resolve the deductions

Business Solution:

  • Reconciliation to identify the discrepancies
  • Reporting to customer to clearly identify what has not been received and where there are
    issues i.e. pricing or quantity or both

Deduction reconciliation enables automatic reconciliation of customer deduction files with sales
return credits generated from inbound receipting of goods being returned. Within Cashbook, all
open credits for a particular customer are downloaded into one side of the deductions
reconciliation. The supplier debit memo/returns files (either electronic or hard copy) are loaded
into the other side of the reconciliation. Cashbook then uses various matching algorithms to
identify the mismatch between the return and the credit memo issued on the ERP.

An automatic report is generated and issued to the supplier showing the discrepancies. As this
report is issued on receipt of the goods the issues are resolved prior to payment being made on
the account. Action to correct the problem is initiated prior to remittances being received. The
result is that a greater number of deductions are matched on receipt of remittance advices.


  • Ability to import a returns file (OCR generate file, EDI file, Spreadsheet, Trucker Detail)
    electronically into a work file (by batch number and date)
  • Import and identification of deduction files including deduction codes
  • Ability to auto-create deductions in JDE for the records received on their electronic file
  • Ability to match deductions to credits in the AR database (user definable match criteria)
    and post in JDE
  • Deductions Exception report generation


  • Reduction in number of open deductions
  • Automatic matching and validation of customer deductions with system credit memo’s
  • Deduction Exception report identifying issues with returns
  • Detailed Audit Reports
  • Improve customer relationships

                              Click to zoom

                                                                                                         Click to zoom

Automate Deduction or Dispute Reconciliation

© 1992 - 2013 Cashbook Limited. All rights reserved.                                                                                                                                                                                  Sitemap
Webinars        Contact Us        Product Tour        Press Room        Blog

Deduction Reconciliation

Live chat
Best of Breed ERP Solution.

Stephen Packwood, IT Manager, Taylor
Hobson, UK - Customer since 1996
Bank Statement Automation
MT940 bank File Format
EMEA Shared Services Centers
USA Bank Lockbox Solution
EDI Uploads
Cash Receipts
Customer Hierarchy
Excel Uploads
Customer Direct Debits
Accounts Receiavable Draft Management
Bank Deposit Slip Reconciliation
Deductions Reconciliation
OCR Remittance Reconciliation
OCR Remittance Reconciliation
OCR Remittance Reconciliation
OCR Remittance Reconciliation
OCR Remittance Reconciliation
OCR Remittance Reconciliation
Deductions Reconciliation