The Cashbook Excel Remittance Upload module allows you to consolidate and automate cash
application on remittance data from one or multiple customers.

This module typically applies to customers providing information on invoices settled with one
large or periodic payment. As the data is not available on the bank statement, A/R departments
are often forced to process these customers manually. As more companies move to paying their
suppliers by electronic funds transfer, these “exceptions” are continually increasing.

Excel Upload can be used on its own or in combination with a bank file upload to achieve the
highest automated matching rate possible.


  • Uses our standard Cashbook Excel Upload Template or can be based on a customer-
    defined template
  • Template can be modified to handle upload of data from one specific customer or from
    multiple customers in the same file
  • 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
  • Allows creation of specific actions to handle items in file (e.g. bank charges, creation of
    credit/debit notes)
  • Automatic deduction rules can be applied based upon tolerance percentages and
    amounts and deduction codes
  • Caters for discount amounts and discount terms.
  • Makes all necessary updates to your ERP’s A/R and G/L
  • Each Excel upload has its own Cashbook journal, so multiple files can be processed
  • simultaneously


  • Reduces A/R processing time of customer remittance data by an average of 90%
  • Allows the automation of customer data that would otherwise not be automated through a
    bank file
  • Receipts applied to customer accounts faster as A/R staff focus on exception handling
    instead of data entry
  • 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
  • Clean, efficient processing bank Lockbox data reduces overall reporting time needed at
    month-end, quarter-end and year-end periods

                                                     Click to zoom

Reduce A/R Processing Time of Customer Remittance Data

Excel Remittance Uploads

© 1992 - 2013 Cashbook Limited. All rights reserved.                                                                                                                                                                                  Sitemap
Webinars        Contact Us        Product Tour        Press Room        Blog
Live chat
We use Cashbook for automating cash
application. I’ve found Cashbook’s
support is always quick and thorough!
They have a great team with excellent

Boyd Funk - IT Customer Service Manager
- Western US
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