Untitled
Download EDI Uploads Case Study
Testimonial
This Cashbook module automates the uploading and cash application of customer remittance
data from an EDI file directly into the ERP system.

This solution evolved from a customer request to manage an EDI file containing hundreds of
customer invoices that were being settled with one payment. This module replaces the manual
task of entering paid invoices one-by-one and generally achieves high matching rates as the
customer data is usually high-quality and based on pre-defined customer-supplier reference
information.

The automation of EDI remittance data is adapted to the needs of the automotive and
pharmaceutical sectors where high invoice volumes often exist between manufacturers, OEMs
and distributors.

Features:

  • Handles most EDI remittance formats
  • Standard matching algorithms available include combinations of the following reference
    data: invoice amount, invoice number, purchase order reference, sales order reference,
    discount amount, due date
  • Matching rules can be modified or enhanced to include other specific reference fields or,
    as is often the case with EDI files, combinations of specific fields
  • Can incorporate specific business rules which exist between trading partners in order to
    determine correct updates to system (i.e. removing duplicate entries, netting transactions
    etc.)
  • Caters for Discount and Credit/Debit notes
  • Makes all necessary updates to your ERP’s A/R and G/L
  • Each EDI upload has its own Cashbook journal, so multiple files can be processed
    simultaneously

Benefits:

  • Reduces A/R processing time of EDI files by an average of 80% to 95%
  • Provides accurate and real-time information for high-volume customers on which invoices
    have been paid and when
  • High-volume receipts applied to customer accounts faster as A/R staff focus on exception
    handling instead of data entry
  • Reduces reporting time devoted to large customer accounts during closing periods
  • Automated processing of data reduces likelihood of manual entry errors
  • Elimination of manual effort allows companies to allocate more staff time to other higher-
    value activities
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
AR Draft Management
Bank Deposit Slip Reconciliation
Deductions Reconciliation
OCR Remittance Reconciliation
We are very pleased with the product
(Cashbook Electronic Payments) as well
as the ongoing support and
responsiveness of SAI. My goal was to
systematize and streamline our A/P
payment process - that was definitely
achieved.

Melanie D. McElroy, Director of Finance, RC
Bigelow Tea, USA - Customer since 2004
© 1992 - 2011 Cashbook Limited. All rights reserved.                                                                                                                                                                                  Sitemap

EDI Processing

EDI Uploads