BPCS is Cashbook’s longest standing ERP system that we have integrated with. We have been
integrating with this ERP system since 1992. We have a huge value proposition for all companies
using BPCS.

BPCS Versions Supported:

  • BPCS V2,
  • BPCS V4, v4.05, v4.17, v405CD,
  • BPCS V5,
  • BPCS V6.04, BPCS V6.1
  • BPCS V8, V8.1, V8.2, V8.3
  • ERP LX

AR Cash Application Issues:

Cashbook has replaced ACR500 functionality in BPCS. We offer a single entry point for all cash
processing that gives users the ability to quickly and easily enter cash. BPCS limitations in the
ACR space include:

  • No ability to apply cash to multiple customers at the same time
  • Deductions/Debit Notes/Credit Notes are a separate function to cash application
  • ARP is not flexible and automatically posts transactions rather than leaving the user with
    discretion as to when the post journals
  • ACR500 batches need to be closed causing AR clerks to stay to the finish
  • Limited access to additional information
  • No integration with bank statements
  • Not Benelux compliant
  • Draft Management solution is weak
  • Direct Debits functionality does not exist is core BPCS
  • No bank lockbox integration
  • No ability to apply cash across multiple BPCS companies

Cashbook looks directly at the
RAR files of BPCS and writes records directly to the RAR file. RP
records are created each time a payment is completed and/or
RD/RC records for debit/credit
notes. All general ledger postings are completed in Cashbook via
Batch Transaction
updating GJW or GBH/GBL records. We post Cashbook Journal & Line information
directly into the ACR Subledger & General Ledger for audit reasons.

Cashbook AR Value Proposition:

  • Ability to split cash across multiple customers in a single journal line
  • Deductions/Debit Notes/Credit Notes/GL Write Offs are all possible through a single
    journal line
  • Deductions can be coded to specific deduction codes for analysis
  • Full Sorting functionality by invoice, deduction, invoice date (any field in the RAR file)
  • Over 10 different algorithms with 12 different properties making the permutations of
    implementations enormous.For customers this means full flexibility and control of auto-
    matching criteria
  • Auto-matching based upon invoice numbers, sales orders, purchase orders, part numbers
  • Partial payments, Over-payments allowed on closed invoices
  • Automatic calculation of gain/loss on exchange
  • Configurable postings on AR sub-ledger and General ledger
  • Ability to view remittances while in allocation screen
  • Excel, EDI & PDF uploads with algorithms attached
  • Auto-creation of deduction codes when auto-creating customer generated deductions
  • Integration with MT940 and BAI2 files for over 50 banks
  • Draft Management and Direct Debits functionality
  • Journal reversing for bounced checks
  • Customer information listing recent payment information
  • Excel outputs of customer invoice information
  • Ability to post cash across companies

AR Credit & Deduction Management Value Proposition:

We are partners with a company that provide credit and deduction management solutions. The
limitations with BPCS financials for credit collections & deductions include:

  • No ability to put notes on customer accounts
  • No ability to re-print invoices quickly & easily
  • No facility to rapidly send fax/pdf/email to customers detailing invoices outstanding and
    cash required for collection
  • Not a user-friendly order-hold process
  • No method of tracking collection agent’s accounts & DSO achievements

Our partner’s solution views
RAR files & CDM files (if credit & deduction management is in use).
Additionally our product views
SIH & SIL order files so that users can place orders for late paying
customers on hold or release holds that have been instigated.

Cashbook Credit & Collections Proposition:

  • Dunning letters based upon numerous rules
  • Invoice reprint capability
  • Notes on invoices, notes on customers
  • Order-hold and release capability
  • Deduction analysis and tracking
  • Action list for collectors to track daily collections
  • Analyse customer DSO and DBT trends
  • Create and monitor promise to pay
  • Numerous configurable reports

AP Payment Issues:

Cashbook has added to BPCS payment functionality by providing Electronic Payment & Email
Remittance functionality in BPCS. In 2007 we offered BPCS companies our Global Payment
Solution to replace
ACP600,ACP620 and ACP650. This solution enables global payments to
occur across companies, bank codes & currencies generating single payment transmission files.
BPCS limitations in the ACP space include:

  • Selection and de-selection of vendors and invoices is done in non-intuitive fashion
  • Difficult process to manipulate the total payment amount
  • Payment process non-integrated with electronic payments or check printing programs
  • No bank integration of payment or bank statement files
  • No Positive Payment Capability
  • Reporting is not XML/XSL based
  • No formal user-based authorisation process
  • Bank reconciliation process is non-existant

Cashbook looks directly at the
APH & APL files of BPCS. When payments are completed in
Cashbook we write payment records directly to the
AMH & AML files. All general ledger postings
are completed in Cashbook via Batch Transaction Processing updating
records. We post Cashbook Journal & Line information directly into the ACP Subledger &
General Ledger for audit reasons.

Cashbook AP Value Proposition:

  • Ability to pay multiple companies in a single payment selection
  • Ability to pay multiple currencies and banks in a single payment selection
  • De-select on vendors, invoices, partial payments, pro-forma invoices
  • Ability to take into account bank charges on payments
  • Analysis of Vendors payment amounts, trends, and statistics
  • Ability to link vendor payments with treasury requirements for more cash visibility
  • Cheque printing and internal Cashbook cheque register
  • Reversals capabilities that will re-open closed invoices
  • Transmission function to batch a number of payment runs into a single payment batch
  • Facilitates SEPA credit transfers

Bank Reconciliation Value Proposition:

Cashbook has given BPCS bank reconciliation functionality by downloading AR & AP cash
receipt and payment information into one central location. These cash transactions can then be
dynamically compared to incoming bank statements from any global location. We also offer a
Cash to GL reconciliation which compares GL segment combinations to incoming bank
statements. As BPCS offers no bank reconciliation function below is a list of our products

  • Auto-matching of bank statements to cash balances
  • Search/Sort capability of both cash and bank transactions
  • Cash and Bank balances are stored within Cashbook
  • Unpresented cash transactions functionality
  • Create journals functionality
  • Write-off functionality
  • Bank Statement transactions can be coded to specific ledger accounts
  • Many to One, One to Many, Many to Many transaction matching
  • Undo option
  • Reconciliation Reporting

Cashbook pulls in payment information from
GHH files and GLH files or GJH and GJD files for
BPCS version 4. This information is then compared with incoming bank statements that can be
automatically uploaded or manually entered. The reconciliation data is all stored within Cashbook


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

BPCS ERP Integration

"The new version of Cashbook is really
an improvement to the old Cashbook. It
is a much more stable program, and a
user friendly product"

Margreet Peverelli – Cashbook User, Skiffy
BAAN ERP Cash Management Software
BPCS ERP Cash Management Software
JDE ERP Cash Management Software
MAPICS ERP Cash Management Software
LX ERP Cash Management Software
Cashbook v5
Cashbook v4
Cash Management Software Technology
Cash Management Software PC Requirements
Live chat