WO2001084388A2 - Method and apparatus for managing remittance processing within account receivables - Google Patents

Method and apparatus for managing remittance processing within account receivables Download PDF

Info

Publication number
WO2001084388A2
WO2001084388A2 PCT/IB2001/000847 IB0100847W WO0184388A2 WO 2001084388 A2 WO2001084388 A2 WO 2001084388A2 IB 0100847 W IB0100847 W IB 0100847W WO 0184388 A2 WO0184388 A2 WO 0184388A2
Authority
WO
WIPO (PCT)
Prior art keywords
customer
account
accordance
invoice
receivables
Prior art date
Application number
PCT/IB2001/000847
Other languages
French (fr)
Inventor
David Land
Alan Getgood
Original Assignee
General Electric Capital Equipment Finance, Inc.
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by General Electric Capital Equipment Finance, Inc. filed Critical General Electric Capital Equipment Finance, Inc.
Priority to AU2001252496A priority Critical patent/AU2001252496B2/en
Priority to JP2001580738A priority patent/JP2003532229A/en
Priority to MXPA02010676A priority patent/MXPA02010676A/en
Priority to CA002406641A priority patent/CA2406641A1/en
Priority to AU5249601A priority patent/AU5249601A/en
Publication of WO2001084388A2 publication Critical patent/WO2001084388A2/en

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q30/00Commerce
    • G06Q30/06Buying, selling or leasing transactions
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00Administration; Management
    • G06Q10/08Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
    • G06Q10/087Inventory or stock management, e.g. order filling, procurement or balancing against orders
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q40/00Finance; Insurance; Tax strategies; Processing of corporate or income taxes
    • G06Q40/12Accounting

Definitions

  • This invention relates generally to a web-enabled Accounts Receivable System (ARS) and more particularly to methods and apparatus for managing various functions related to accounts receivables, credit granting, collection, dispute management and reporting and remittance processing.
  • ARS Accounts Receivable System
  • An accounts receivable function includes the tasks of credit inquiries, approving credit to new and existing customers, and analyzing payment history of existing customers. In addition to credit approvals, aging of the receivables, disputes and delinquencies, collections and proper application of the payments, and determining appropriate write-offs and appropriate reporting capabilities, also must be managed. These tasks are time-consuming and often take away resources of the corporation from its operations and other profitable activities. Completing several of these tasks also typically requires interfacing with outside agencies for credit approval and constant updates to the customer records.
  • Accounts Receivable System provides a full range of trade receivables Credit & Collection services including credit evaluation, credit granting, customer collection and account reconciliation, remittance processing, application and banking, all account receivables (A/R) reporting, consolidation, including customer statement preparation and mailing, ending with direct feeds to a client's general ledger system (G/L) for the client's financial statement preparation.
  • the system serves clients by allowing them to outsource their full accounts receivable (A/R) function while still retaining the important computer-to-computer links covering order shipping approvals (after credit evaluation), billing/invoice feeds, customer dispute monitoring and reporting (on-line), and final month-end G/L interface for receivables balancing.
  • the system includes five modules which include a Credit Inquiry Module, a Remittance Processing Module, an Accounts Receivable Claim Module, a Maintenance Module, and an Administration Module. These modules are integrated with each other and are capable of interfacing with a client's Order, Ship, Bill (OSB) system for smooth functioning.
  • the ARS is further capable of automatically upgrading the software and systems templates to the client by downloading on a realtime basis as they are being implemented at a central site and as called for by a user.
  • the Remittance Processing Module accepts funds in any foreign currency and translates the funds into the required local currency for reporting purposes. Reporting is also done in a local or a foreign currency. Exchange gain and loss calculations are automatically generated by the Remittance Processing Module.
  • the Remittance Processing Module performs Auto Draft and Reverse Application functions. Further, the Remittance Processing
  • Module accepts funds electronically, and, under certain conditions, automatically applies and updates a customer's account in the most efficient manner.
  • Figure 1 is a block diagram of an Accounts Receivable System including a server system and a plurality of devices;
  • FIG. 2 is a block diagram of an alternative embodiment of an
  • Figure 3 is further another embodiment of an Accounts Receivable System
  • Figure 4 is an exemplary embodiment of a software architecture for the Accounts Receivable System shown in Figure 3;
  • Figure 5 is a database structure within a database server of the Accounts Receivable System shown in Figure 3;
  • Figure 6 depicts the functions of an Order, Ship, Bill (OSB) System and an Accounts Receivable System with reference to a business process;
  • OSB Order, Ship, Bill
  • Figure 7 depicts the functional relationship of the Accounts Receivable
  • Figure 8 is an exemplary screen layout of the Accounts Receivable System shown in Figure 3;
  • Figure 9 is an activity diagram for performing a credit check through a
  • Figure 10 is an activity diagram of the ARS shown in Figure 3, for the invoice generation
  • FIG 11 is an activity diagram of the ARS shown in Figure 3, for remittance processing
  • Figure 12 is an exemplary embodiment of a screen layout of the ARS shown in Figure 3, which displays a payment application to a customer account;
  • Figure 13 is an exemplary embodiment of a screen layout of the ARS shown in Figure 3, which displays the creation of a parent heirarchy record or payor heirarchy record for the subsidiary customer;
  • Figure 14 is an exemplary embodiment of a screen layout of the ARS shown in Figure 3, which displays the manner in which payment that has been applied by Accounts Receivable System may be subsequently reversed;
  • Figure 15 is an exemplary embodiment of a screen layout of the ARS shown in Figure 3, which displays the reversal of a zero application and all other records;
  • Figure 16 is an activity diagram of the ARS shown in Figure 3, for the collection process;
  • Figure 17 is an exemplary screen layout of the Accounts Receivable System shown in Figure 3, which displays customer interchange credit;
  • Figure 18 is an exemplary screen layout of the ARS shown in Figure 3, which displays customer information sorted by customer number;
  • Figure 19 is an exemplary screen layout of the ARS shown in Figure 3, which displays the detail aging of a given customer along with scratch pad notes;
  • Figure 20 is an exemplary screen layout of the ARS shown in Figure 3, which displays the payment history of a given customer;
  • Figure 21 is an activity diagram of the Accounts Receivable claim (ARC) procedure of the ARS shown in Figure 3;
  • Figure 22 is an exemplary screen layout of the ARS shown in Figure 3, which displays the root cause analysis summarizing outstanding Accounts Receivable Claims;
  • Figure 23 is a process flow chart for the ARS shown in Figure 3.
  • the systems and processes facilitate, for example, electronic submission of information using a client system, automated transmission of information, and web-enabled monitoring and reporting and management of account receivables including a final month end general ledger interface for receivable balancing for client's users.
  • FIG. 1 is a simplified block diagram of an Accounts Receivable System (ARS) 10 including a server system 12 and a plurality of devices 14 connected to server system 12,
  • devices 14 are computers including a web browser, and server system 12 is accessible to devices 14 via the Internet.
  • Devices 14 are interconnected to the Internet through many interfaces including a network, such as a local area network (LAN) or a wide area network (WAN), dial-in-connections, cable modems and special high-speed ISDN lines.
  • Devices 14 could be any device capable of interconnecting to the Internet including a web-enabled phone or other web-enabled connectable equipment.
  • Device 14 is capable of connecting directly to Order, Ship, Bill (OSB) System 20 located at the client site.
  • OSB Order, Ship, Bill
  • Server system 12 is also capable of communicating with OSB system 20 either through a direct link or through one of devices 14 located at the client site and upload and download the data as required.
  • Accounts Receivable System 10 is installed at a business entity site within a firewall 22 while OSB system 20 is located at client site outside firewall 22 of the business entity. Both systems are configured to download and upload required data through a secure connection for performing the required functions.
  • FIG. 2 is a block diagram of an alternative- exemplary embodiment of a server architecture of Accounts Receivable System (ARS) 30.
  • System 30 includes a server system 12 and devices 14.
  • Server system 12 includes a database server 36 including a data storage device 38, an application server 40, a web server 42, a directory server 46, a fax server 52 and a mail server 56.
  • a disk storage unit 38 is coupled to database server 36 and director server 46.
  • Servers 36, 40, 42, 46, 50, 52, and 56 are coupled in a local area network (LAN) 60.
  • LAN local area network
  • device 14 includes a system administrator work station 64, a customer service representative work station 66, a credit officer's work station 70, and a general function work station 72.
  • Work station 72 is utilized by someone having an authorized access to maintain and update ARS 30.
  • Work stations 64, 66, 70, and 72 are connected to LAN 60.
  • workstations 64, 66, 70, and 72 are coupled to LAN 60 via an Internet link or connected through an Intranet.
  • Each work station 64, 66, 70 and 72 in the exemplary embodiment, is a personal computer including a web browser. Work stations 64, 66, 10 and 72, are illustrated as being associated with separate functions only to facilitate an understanding of the different types of functions that can be performed by individuals having access to LAN 60.
  • server system 12 is configured to be communicatively coupled to third parties, e.g., internal or external auditors 78, and to various clients 80 located outside firewall 22, via an Internet Service Provider (ISP) Internet connection 84.
  • ISP Internet Service Provider
  • the communication in the exemplary embodiment is illustrated as being performed via the Internet, however, any other wide area network
  • WAN wide area network
  • a local area network could be used in place of the WAN.
  • Each outside client 80 is connected to their own OSB system 20.
  • Outside client 80 also has a work station 88, which is a personal computer including a web browser.
  • Work stations 88 are configured to communicate with server system 12.
  • fax server 52 communicates with outside clients 80 and any of the remotely located overseas clients including a device (not shown) via a telephone link. Fax server 52 communicates with other devices 64, 66, 70 and 72, as well.
  • Accounts Receivable System 30 is installed at a business entity site while OSB system 20 is located at the client site. Both systems 20, 30 are configured to download and upload required data through a secure connection, from each other, for performing the required functions. Continuous enhancements ensure compatibility to use new technology as it becomes available which ultimately reduce cost and improve efficiency.
  • FIG 3 illustrates an alternative exemplary embodiment of an Accounts Receivable System (ARS) 90.
  • ARS Accounts Receivable System
  • device 14 is a desktop (thin device or often referred as thin client).
  • Thin devices are Intel compatible PCs with Pentium or higher processors and a minimum 36 MB RAM running Windows 95 or Windows NT 4.0 workstation and Internet Explorer 4.0 and above.
  • Server system 12 includes an application server 40 with a Pentium processor and a minimum 64 MB RAM running Windows NT 4.0 server and an Internet Information Server 92.
  • the Business logic will reside in this layer in the form of Dynamic Link Libraries (DLL).
  • DLL Dynamic Link Libraries
  • Database server 36 is a server including a Pentium processor and a minimum 64 MB RAM running Sun Solaris.
  • the database layer resides within database server 36.
  • Devices 14 are internally connected to OSB System 20 located at the client site. Server system 12 communicates with OSB system 20 either through a direct link or through one of the devices 14 located at the client site to upload and download the data as required.
  • Figure 4 is an exemplary embodiment of the software architecture 98 of ARS 30 as well as ARS 90, database server 36 and application server 40 of Server system 12.
  • the Software Architecture used in ARS system 30 has a Web Browser such as IE 4.0 and above as the front end.
  • the Web Browser downloads the ActiveX controls developed in VB5.0*. which forms the User Interface.
  • Middleware in ARS 30 implements the business rules and database calls and resides on the NT application server.
  • the middleware is in the form of ActiveX objects (DLLs).
  • Middleware is a software that connects two otherwise separate applications. For example, there are a number of middleware products that link a database system to a Web server. This allows users to request data from the database using forms displayed on a Web browser, and it enables the Web server to return dynamic Web pages based on the user's requests and profile.
  • Middleware retrieves data from Oracle database 94 residing on the UNIX server. IIS is used as the Webserver. Active Database Objects (ADO) are used for database access. Oracle 7.3.2 database 94 resides on the UNIX Server.
  • ADO Active Database Objects
  • Security in ARS 30 is closely monitored because of confidential and proprietary client information. Security is maintained in the system by providing various authority access levels. These access levels exist for individuals with different authorities such as Headquarter authority, supervisor authority, credit evaluator authority, Collector authority and remittance processing authority. When the user logs onto the application, the user's authority is checked, and depending upon the user's authority the user is given access to select screens.
  • authorities such as Headquarter authority, supervisor authority, credit evaluator authority, Collector authority and remittance processing authority.
  • ARS 30 also maintains regular security that is normally involved in every Intranet application.
  • Every Active Server page ARS 30 checks whether the user has logged in and if the user has logged in then system 30 also checks whether the user has come for the right Active Server Page from which the user is supposed to access. If none of the above criteria is satisfied then system 30 displays an error message "Invalid Access to Screen". Also there is a session variable that checks if the logged on user is idle for more than a predetermined period of time and if so the user is automatically logged out of the application.
  • Figure 5 is database 94 structure within database server 36.
  • Database 94 is coupled to several separate components within server system 12, which perform specific tasks.
  • ARS 30 manages full range of trade receivables credit and collection services involving credit evaluation credit granting, customer collection and account reconciliation, remittance receipt, application processing, banking, receivables consolidation, and updating OSB general ledger.
  • ARS 30 receives the pertinent information from client's OSB system 20 for processing and generating required journal entries with a variety of reports for financial monitoring, reporting and auditing purposes.
  • the information retrieved and processed is stored in centralized database 94 for permanent as well as temporary access.
  • server system 12 is divided into separate components such as, a download component 100 for downloading journal entries and a variety of reports, a display component 102 for displaying the journal entries and the variety of reports, a transmit component 108 for transmitting required information to the OSB system, and a printing component 112 for printing journal entries and the variety of reports downloaded and displayed by the respective server components.
  • the system accepts commands from device 14, e.g., by utilizing a peripheral to make a selection or by utilizing a voice command.
  • Server system 12 includes a processing component 116 for searching and processing received requests against data storage device 38.
  • server system 12 also includes a retrieving component 120 to retrieve information from data storage device 38.
  • An information fulfillment component 122 downloads the requested information after retrieving from data storage device 38 to the plurality of devices.
  • FIGS. 6 through 23 illustrate the operational flow of ARS 10 including the interrelationship among various ARS 10 modules and the interface between ARS 10 and OSB 20.
  • FIG. 6 depicts the functions of OSB System 20 and ARS 10, with reference to a business process 160.
  • OSB * System 20 includes an Order Entry function 164, a Shipping function 170 and a Billing function 174.
  • ARS 10 includes the remaining functions involved with accounts receivables of business process 160 including managing customer credits, receiving and processing payments against open invoices, balancing general ledger on a periodic basis, financial statement data generation for accounting and internal controls and preparing periodic reports to meet generally accepted accounting principles (GAAP) and Financial Accounting Standards Board (FASB) requirements.
  • Clients 80 from their individual locations operate OSB system 20 and a General Ledger (G/L) system 180.
  • ARS 10 is operated at a remote location by a business entity, which has a group of professionals specializing in ARS 10. In an alternative embodiment, ARS 10 is operated and
  • FIG. 7 shows how ARS 10 interfaces with a client OSB system 20 and general ledger (G/L) module 180 to provide continuity to the client.
  • ARS 10 receives the data from, and transmits the data to, the different components of OSB system 20 such as Order Entry 164, Shipping 170, and Billing 174.
  • Order Entry 164 processes the customer order by extracting data from Pricing component 176 and Inventory component 178.
  • ARS 10 also interacts with various other components 182 of client system as required.
  • the integrity of OSB system 20 is critical for proper functioning of ARS 10 since ARS 10 uses the data received from OSB 20 to generate the general ledger entries as well as other management reports.
  • ARS 10 manages several other aspects of business process 160 to properly populate the general ledger with pertinent receivable data on a periodic basis including processes involved with credit management.
  • FIG 8 is an exemplary screen layout of ARS 10.
  • ARS 10 involves credit granting, collection, remittance processing, and reporting/administration.
  • ARS functions are organized into five modules: a Credit Inquiry Module 190, a remittance processing Module 194, an Accounts Receivable Claim (ARC) Module 200, a Maintenance Module 204 and an Administration Module 210.
  • Remittance Processing Module 194 is sometimes referred to as a Cash Application Module.
  • Credit Inquiry Module 190 provides to the user extensive customer and receivable related information in a variety of ways.
  • Remittance Processing Module 194 involves processing of remittance payments, delinquency management and payment-related functions.
  • ARC Module 200 manages customer disputes.
  • Maintenance Module 204 is used to maintain and store various types of customer information.
  • Administration Module 210 is used to handle security and high-level systems functions.
  • a user may enter a function attached to a particular module in ARS 10, subsequent navigation takes the user back and forth across the different modules in ARS 10.
  • a user applying a check in Remittance Processing Module 194 accesses Credit Inquiry Module 190 to conduct a customer search or to display invoice details.
  • a user viewing a customer statement accesses Maintenance Module 204 to modify customer information, or Remittance Processing Module 194 to offset debit and credits together under the account, or ARC Module 200 to set up or display a dispute.
  • a user searching for an invoice in Credit Inquiry Module 190 or setting up a reference between two invoices in Maintenance Module 204 accesses Remittance Processing Module 194 to display a list of duplicate invoices.
  • a user reviewing billing batches in Administration Module 210 accesses Credit Inquiry Module 190 to display invoice details.
  • ARS 10 provides a full range of credit and collection services for trade receivables including credit evaluation, credit granting, customer collection and account reconciliation, payment receipt, application and banking, account receivables (A R) reporting, consolidation, including customer statement preparation and mailing, ending with direct feeds to the client's general ledger (G/L) system 180 for financial statement preparation.
  • ARS 10 can produce journal entries to update G/L system 180 by using pseudo account numbers internally which are mapped and transferred to client's G/L system 180 via a file transfer protocol (FTP).
  • FTP file transfer protocol
  • ARS 10 provides an option to clients 80 to outsource their full A R function while still retaining the important computer-to-computer links with OSB system 20 covering order shipping approvals (after credit valuation), billing/invoice feeds, customer dispute monitoring and reporting (on-line), and final month-end G/L interface for receivables balancing.
  • OSB system 20 covering order shipping approvals (after credit valuation), billing/invoice feeds, customer dispute monitoring and reporting (on-line), and final month-end G/L interface for receivables balancing.
  • Each module of ARS 10 is described in detail.
  • A. CREDIT INQUIRY MODULE Credit Inquiry Module 190 primarily involves credit evaluation at the time the customer account is set up, and credit maintenance activities. Credit Inquiry Module 190 also interfaces with various modules to access delinquencies, collections and write-offs.
  • Credit Inquiry Module 190 reviews pay history and performs ' credit inquiries.
  • Pay history is a set of calculations based on a payment period from invoice date to date of payment received.
  • ARS 10 sorts all data and compiles it into a report that compares the data over an eighteen-month period and displays it in six-month increments.
  • Credit Inquiry Module 190 accesses a customer account and views a diverse supply of data used for customer analysis, credit management, and customer contact. Credit Inquiry Module 190 further includes search options.
  • Credit Inquiry Module 190 predicts remittance forecasts for a specific customer or account based on historic data. ARS 10 predicts overall cash forecasting for the client. Credit Inquiry Module 190 further performs audit verification for tracking all transactions at the customer level for account reconciliation.
  • the client works with the business entity to establish approval criteria on new customer accounts and to choose client specific credit scoring options using scoring software programs contained in ARS 10.
  • Figure 9 is an activity diagram for performing a credit check for an existing customer through Credit Inquiry Module 190 on a customer who has placed a purchase order through OSB system 20.
  • ARS 10 receives a request for approval 220 on a new account.
  • ARS 10 procedures routes request for approval 220 to a designated credit officer 224 out of a plurality of credit officers 230.
  • Credit officers 230 are also sometimes referred to as collectors or collection representatives.
  • Designated credit officer 224 performs an initial credit investigation 234 on request for approval 220 of the new account.
  • Designated credit officer 224 automatically approves request for approval 220 if the order aggregates less than an amount specified by the client or if the order is from a specified known customer pre-designated by the client. If request for approval 220 is not automatically approved 240, designated credit officer 224 performs a detailed credit investigation 244.
  • Credit investigation 244 does not have a specified application; rather it involves a variety of tools such as Dun & Bradstreet reports 250 and or other credit reporting agencies 254, trade references 260, bank reports 264, financial statements 270, customer visits 274, and survey of Mines and Industrials 280.
  • ARS 10 electronically interfaces with Dun & Bradstreet or other credit reporting agencies for searching and identifying a customer by name, address and telephone number and obtaining Dun & Bradstreet reports 250 or other credit reporting agencies reports 254, thereby minimizing the time in the credit approval process.
  • designated credit officer 224 determines whether credit should be granted to the customer.
  • Each designated credit officer 224 has limits to the credit authority, which are resident and strictly controlled within ARS 10. Designated credit officer 224 cannot grant a credit line in excess of their delegated authority limits. ARS 10 restricts access for changing the credit limits of credit officers 230 only to specified authorized individuals within the business entity.
  • designated credit officer 224 approves the new account request. If the customer does not meet the pre-determined parameters of credit investigation 244 or if the credit requested by the customer exceeds the authorized limits of designated credit officer 224, then ARS 10 personnel attempts to obtain security 290 such as personal guarantees 294, inter-corporate guarantees 300, PPSA 304 or conditional sales agreements 310. For approval of various orders, a letter of credit 314 may be sought.
  • ARS 10 assigns an approval number in the case of an existing account or an account number 326 in the case of a new customer account to the order and interfaces with OSB system 20 which performs Order Entry function 164, Shipping function 170, and Billing function 174.
  • An interface 330 completes the credit approval process.
  • Figure 10 is an activity diagram which depicts the process for customer order approval and invoice generation 412 as well as credit approval and posting of general ledger entries on G/L system 180. Activities are located in respective columns based on the system that performs the activity. The columns correspond to OSB system 20, G/L (General Ledger) System 180 and ARS 10.
  • OSB system 20 enters/ receives a customer order approval request 414.
  • OSB system 20 makes 416 a decision to automatically approve customer order 414 if the amount of order 414 is less than or equal to the Order Control Limit (OCL) 422.
  • OCL 422 is initially established when the account is set up in ARS 10. After the initial set up, there are three ways in which the OCL 422 can be adjusted. Designated credit officer 224 can change the limit, or can place a Hold Order or a Credit Referral on the account. If a Hold Order or Credit Referral is placed on the account, OCL 422 is automatically reduced to zero. These changes to OCL 422 are fed to the client's OSB system 20 in a pre-determined cycle.
  • approval request 414 is deferred and designated credit officer 224 is informed of the deferral through ARS 10.
  • Designated credit officer 224 then makes 428 a decision to approve, decline or hold the approval request 414. Since the information is fed back and forth between OSB system 20 and ARS 10 in pre-determined cycles, the time lag for a decision is short with the vast majority being automatically and instantly approved within the client's.
  • OSB 20 based on ARS 10 pre-approvals. Once approved, OSB system 20 ships product 430 and generates a final invoice 432.
  • the client's OSB system 20 manages pricing and stores this information together with customer discounting structures, etc., within OSB system 20 and subsequently generates a customer invoice (hard copy or electronic) for its customer.
  • OSB system 20 also creates a batch file 436 and dispatches said batch file 436 to ARS 10 the same evening.
  • Batch file 436 includes basic information 440 pertaining to invoice 432.
  • Information 440 received electronically to ARS 10 includes information such as a date of invoice 442, a due date of invoice 444, a currency of invoice 446, an amount of invoice 448, a customer number 450, a billing identification recognition code (IC) 452, an invoice number 454, other payment terms 456 and a customer purchase order number 458, if available.
  • IC billing identification recognition code
  • ARS 10 then uses batch file 436 to update the customer's statement 460 for collection and monitoring purposes.
  • ARS 10 also posts a journal entry 462 for balancing of the client's G/L system 180 at the month end.
  • ARS 10 finally produces an "assessed receivable" total 464, which provides the client with the G/L interface numbers to balance its financial statement and outstanding receivables.
  • ARS 10 produces aged trial balances, dispute reports, trending reports, and any other reports for use by the client in substantiating assessed receivable total 464.
  • Remittance Processing Module 194 involves application of remittance payments, aging the receivables.
  • Remittance Processing Module 194 has several capabilities including accepting funds in any foreign currency and translating the funds into the required local currency for reporting purposes. In one embodiment, the reporting is conducted in local currency. In an alternative embodiment, the reporting is conducted in foreign currency.
  • Exchange gain and loss calculations are automatically generated by Remittance Processing Module 194 of .
  • Remittance Processing Module 194 under certain conditions, automatically applies and updates a customer's account through a series of algorithms. Appropriate individuals, as designated, based on systems' security levels, have the authority to ZAP a particular account. ZAP is a derivative of remittance processing which allows for offsetting of items within a customer's account. In these situations, updating of balance is performed automatically online.
  • Remittance Processing Module 194 displays the accounts and applies the received cash by Payor Hierarchy. Payor Hierarchy allows the user to access multiple accounts through one or more designated main accounts. Remittance Processing Module 194 also allows Auto Draft and Reverse Application functions in conjunction with Maintenance Module 204. Auto Draft selects specific invoices in a customer's account to be paid, which are formatted into an electronic bank file for funds transfer. Through Reverse Application, ARS 10 reverses previously completed applications and associated general ledger entries on G/L system 180, and restores the account to the original balance on-line.
  • Figure 11 is an activity diagram for remittance processing.
  • the customer remits to the business entity the payment 470 on invoices through checks, wire transfers, electronic deposits, credit cards or drafts.
  • ARS 10 receives the payments 474 and deposits them 480 in client's bank account.
  • Remittance Processing Module 194 of ARS 10 generally applies payments 474 to the invoice(s) 440 to which the customer wishes the payment to be applied. If remittance instructions are not received by ARS 10, the cash received is treated as On Account Unapplied Cash. ARS 10 automatically sends a letter to customers who have On Account Unapplied Cash. The letter asks for instructions on how to apply the cash (and may result in a call to the customer for information). The On Account Unapplied Cash moves with the aging buckets but does not reduce the delinquency amounts until it is applied, unless specifically cross referenced by designated credit officer 224 to a particular aging bucket.
  • ARS 10 maintains an audit trail of all cross-references made by designated credit officer 224.
  • ARS 10 accepts payments 474 in multi-currency 484 and accounts for exchange gains or losses in the balancing process.
  • ARS 10 also offers on-line remittance processing 490 so that concurrently with the application of the checks against the invoices, these invoices are shown as paid and the customer balance is updated in an on-line format.
  • Remittance processing 490 allows for multi-account connectivity as depicted in Figure 14 herein.
  • ARS 10 identifies any cash variances, exchange losses, discounts and concessions that are allowed.
  • ARS 10 then automatically balances payment 474 by writing the journal entry so that the appropriate cash variance, exchange variance, discount or concession journal entry is included in the receivable totals balancing 494.
  • Remittance Processing Module 194 is balanced 494 in batch mode overnight and the appropriate journal entries are generated to update the receivable numbers in the client's G/L system 180.
  • ARS 10 produces numerous reports and on-line screens which remittance processors use to reconcile the amounts of payments 474 received against the amount of cash applied and the amount deposited in the bank, so that any imbalance positions are immediately discovered.
  • ARS 10 produces a current activity file on every transaction or edit to ARS 10 and also ties in the identification code of the person who made any change within ARS 10 at any time. This file is archived to a storage media.
  • Figure 12 is an exemplary embodiment of a screen layout of ARS 10, which displays a payment application 510 to a customer account.
  • Payment application 510 permits the operator to select a method 514 to apply the payment in a particular manner, such as by account descending 516, a statement balance 520, an invoice number 522, a payment from oldest invoices 524, pay by finder number 530, an invoice search 534, etc.
  • Figure 13 is an exemplary embodiment of a screen layout of ARS 10, which displays the creation of a parent hierarchy record or payor hierarchy record for the subsidiary customer. Specifically, the customer record of a subsidiary 544 is interconnected to a payor 600. This provides a merging of multiple accounts in order to obtain on-line aging of customer exposure and better facilitate remittance processing.
  • Figure 14 is an exemplary embodiment of a screen layout of ARS 10, which displays the manner in which payment 474 that has been applied by ARS 10 may be subsequently reversed.
  • a previous payment application is reversed in ARS 10 by providing information relating to a customer number 610, a check reference
  • information is automatically provided by data from other screens being used to populate select fields within reverse check screens.
  • Figure 15 is an exemplary embodiment of a screen layout of ARS 10, which displays the reversal of a zero application and all other records.
  • the screen layout identifies a customer number 640, a finder number 642, and an invoice number
  • Designated credit officer 224 can monitor the account balances and activity on-line through ARS 10. Periodically, reports are generated that indicate the accounts on which action is required during the following week. Accounts are included in the report if they meet any of the exception conditions which can be changed immediately through the use of tables. ARS 10 produces numerous reports from the individual account level up to the overall client level.
  • Not Due Current means the invoice is due within 30 days from a defined closing date. Not-due means that the invoice is due at least 31 days from a defined closing date. Delinquent (or past due) means the invoice is unpaid at least one day after its individual due date.
  • the main report used to identify aging is an Aged Trial Balances as well as a Trending Report.
  • Remittance Processing Module 194 Although the aging of accounts receivable has been described here in Remittance Processing Module 194, in another embodiment, it can be accessed or interfaced from other modules such as Credit Inquiry Module 190, ARC Module 194 or Maintenance Module 204.
  • the normal, delinquency collection cycle takes place by designated credit officer 224 and is triggered by either a past due condition which is identified on a weekly exception condition run and/or an on-line inquiry screen showing a customer who has exceeded their credit line. Although there are a variety of reasons for making collection calls or reconciliation attempts, the principal reason is delinquency.
  • One of the biggest collection incentives are the targets imposed upon credit officers 230 for collections as a percent to available receivables (total receivable balance less not dues) as well as percent to forecasted collections (used to measure ability of credit officer 224 to set accurate targets) which are monitored and reported on a monthly basis for each credit officer 224 and which become a part of the yearly performance evaluation of credit officers 230.
  • Figure 16 is an exemplary embodiment of a simplified activity diagram of the collection process.
  • credit officer 224 begins the required collection activities 700. These are reviewed based on collections as a percent to forecast and available amounts as well as delinquency ratios. Delinquent accounts are reviewed routinely by credit officers 230 with their particular District Credit Managers in order to increase the intensity and level of collection activity, if required.
  • ARS 10 has a variety of reports that monitor delinquencies such as an aged trial balance 710, an on-line aged balance 712, an on-line customer data summary 714, an interchange 720 from various credit agencies, payment habit statistics 724, ARS 10 generated collection letters 730 (also sometimes referred to as "dunning" letters), a credit scoring 734, a parent hierarchy 740, communications on scratch pad 744, and other reports.
  • Payment habit statistics 724 also sometimes referred to as payment history reports, are on a per account basis, per credit officer 224 basis, per client basis, etc. These reports are generated either on-line or in a monthly format together with the weekly exception reports on collection calls that are required.
  • the "trending report” encapsulates 38 actuals of A/R information per month on a 13 month tracking trend on one sheet of paper with their top 25 customer abusers on the back page.
  • An account is defined as being past due or delinquent within ARS 10 on the first day beyond the agreed upon terms of sale 746. For example, an invoice billed on January 1st, 2000 with a term of net 30 days becomes past due and delinquent on January 31, 2000 and is reported in that format.
  • ARS 10 extracts from the billing input file the term 456 that is associated with each individual invoice and, together with its table matrix which has been approved by the client, assigns the particular due date 444.
  • the aging on ARS 10 is measured on a day-by-day basis, which is an accurate measurement facilitating better follow-up on delinquencies.
  • ARS 10 receives feeds from Dun & Bradstreet and other credit reporting agencies. Ownership changes, rating changes, judgments, and large decreases in Paydex or Payment Index scores are reported to designated credit officer 224 in a hard copy report. Additionally, any promises to pay made by customers are input into ARS 10. These promises also appear on-line and on the weekly exception reports.
  • Collection letters are used 750 for smaller accounts. Multiple Collection letters, of increasing (strength), may be generated after individual invoice due dates based on a variable criteria by client and at predetermined intervals. Larger or "at risk" customers typically do not pass through the collection letter process 750 and are directly contacted by phone when their accounts become past due.
  • a customer has delinquencies in the form of a reconciliation progress whereby a substantial portion of the account is paid within the normal industry standard payment terms and it is important that collection calls not irritate the customer.
  • Designated credit officer 224 is responsible to manage the account through its life cycle and to build a customer service oriented rapport with that customer for the maximum benefit to the client. In some cases special arrangements such as having the customer pay down old balances with the purchase of new goods allows the customer to work down any outstanding obligations.
  • ARS 10 also reviews 754 other documentation pertaining to the delinquent account such as letter of credit 314, export insurance, and other financing documents.
  • Past due accounts are managed by a variety of credit officers 230 and are, in various instances, placed for collection 760 with an outside collection agency and/or lawyer prior to the request for bad debt authorization. By this, an independent third party makes an unbiased attempt at collecting the funds before writing it off as a bad debt. Customers that are bankrupt or have receivers appointed are handled 764 in accordance with the appropriate law. Generally, ARS 10 transfers such accounts to active bad debt files (discussed below). Any cash collected through collection activities 700 is processed through Remittance Processing Module 194.
  • Figure 17 is an exemplary screen layout of ARS 10, which displays customer credit interchange. Although the screen layout displays an embodiment of Dun & Bradstreet reports 250, similar screens are also obtainable from other credit reporting agencies 254.
  • ARS 10 utilizes a risk code system 766 that assigns a value from 1 to 8 based on information from trade experiences, Dun and Bradstreet, and other credit reporting agencies. If no information is available, the account is coded "N". These codes are used to override "off switches that may be present, such as the switch to turn off collection letters, also known as Dunning letters (discussed later) or other exception conditions.
  • Figure 18 is an exemplary screen layout of ARS 10 which displays customer information sorted by customer number 768. This inforriiation is accessed by designated credit officer 224 through ARS 10 during their detailed credit investigation 244 as well as on-going account review and monitoring.
  • the customer information includes a name 770, an address 772, a telephone number 774, a Dun & Bradstreet rating 776, a risk code 778, an amount of highest credit 780, a date of last sale 782, the year-to-date sales 784, the unshipped order 786, a date customer was opened 788, a balance 790, a current balance 792, a past due balance 794, a name of parent 796, a currency 798, credit status 800, and other information.
  • ARS 10 reviews individual accounts on an exception basis. There is also a more formalized procedure whereby ARS 10 establishes a periodic credit update review and alerts designated credit officer 224 within a pre-determined time period prior to the lapse of the date that a review is required. This review may be simply designated credit officer's 224 mental review of the account, payment status with ARS 10, pay history, days to pay statistics, Dun & Bradstreet on-line interface information, so that an approval is input in ARS 10 to change the review date for another year. ARS 10 checks any change in the credit requirement to the individual identification code of designated credit officer 224 making the change to ensure that the credit limit of the customer has not been increased beyond the delegated authority of designated credit officer 224.
  • Figure 19 is an exemplary screen layout of ARS 10, which displays the detail aging of a given customer 802 along with scratch pad notes 744.
  • Scratch pad notes 744 include telephone or other exchange with or from customer, information regarding credits to customer, or other information.
  • the screen layout identifies a date
  • Figure 20 is an exemplary screen layout of ARS 10, which displays the payment history 810 of a given customer 802.
  • the screen layout identifies the net sales 812, the credit notes 814, the highest credit granted 816, a write-off amount 820, a check returned for not-sufficient funds 824 and other information, all of which information is displayed by the current semester 830, the last six months 834 and the prior six months 840.
  • delinquency management of accounts receivable has been described here in Remittance Processing Module 194, in another embodiment, it can be accessed or interfaced from other modules such as Credit Inquiry Module 190, ARC Module 200 or Maintenance Module 204.
  • ARS 10 provides a sophisticated method for tracking bad debts once they are written off. In essence, when a write off to bad debt takes place, a journal entry is input to ARS 10 which simply transfers a mirror image of that customer's bad debt statement out of the normal receivable statements, generates an automatic journal entry to the client's G/L system 180 and mirror images the customer statement on an internal "active bad debt file". From the client's perspective the balance is treated as a write-off. All write-offs proposed by ARS 10 are signed off by the client's Vice President of Finance (or delegate). Bad debts principally generated from receiverships, bankruptcies, etc., are still treated as active bad debt customers.
  • Manager prepares a recommendation to transfer these specific customers out of the active bad debt file and to consider them to be inactive bad debts, which are then consolidated and stored in off-site storage for tax and audit purposes.
  • ARS 10 produces monthly runs of outstanding active bad debt accounts which are controlled by the appropriate District Managers. All bad debts are signed by the District Manager, the General Manager and a client delegate of the Vice President Finance.
  • Bad debt provisions are calculated by ARS 10 for each year and then divided into quarters.
  • the bad debt provision is set at the average net bad debts over the last six years.
  • the provision is checked against actual bad debts each quarter, and provisions are also adjusted up or down each quarter, as required.
  • Near-end bad debt provisions, as calculated on ARS 10, are then recommended to the client.
  • ARC Module 200 manages the Accounts Receivable Claim Process which involves identifying invoices as disputed, and sending notice of such disputes to the client for resolution through on line communication. Upon generation of a claim, ARS 20 tracks the status in multiple ways and ages disputed items until final resolution.
  • Figure 21 is an activity diagram of the accounts receivable claim procedure. Disputes from customers are recorded 844 in ARC Module 200, which are instantly logged in, numbered, and filled in with the appropriate word description to generate an accounts receivable claim (ARC) 846. Based on the identification code matrix established for ARS 10, ARC 846 is immediately available on-line 850 to the responsible person within the client 854 for resolution and on-line tracking 860. Hard copies of individual disputes are also printed overnight 850 in batch mode on designated printers for each of the client's responsible persons if requested. These persons input comments 864 on-line with any credit notes that are issued to adjust the customer short payments so that prompt offsets take place for aging purposes. Designated credit officer 224 puts their comments 870 on ARC 846.
  • ARC 846 Based on the identification code matrix established for ARS 10, ARC 846 is immediately available on-line 850 to the responsible person within the client 854 for resolution and on-line tracking 860. Hard copies of individual disputes are also printed overnight 850 in batch mode on designated printer
  • ARC 846 the client writes to the customer wherein the letter is laser printed on ARS 10 and mailed or faxed from the business entity's pooled location using the business entity's mailing volumes and procedures. These letters are electronic and become a part of ARC 846 for follow-up and audit purposes.
  • credit officer 224 closes 874 ARC. Open ARC 846 is maintained, reporting stored 880 on-line for aging purposes until, collected, credited or written off.
  • Figure 22 is an exemplary screen layout of ARS 10, which displays the root cause analysis 890 summarizing outstanding Accounts Receivable Claims.
  • This screen layout identifies the customer, a responsible person 892 from the client for said customer and an aging 894 of the accounts receivable disputes balance for the customer.
  • Aging 894 identifies if the balance is current, 2 months past due, 3 months past due, 4-6 months past due, 7-12 months past due or 12 months past due.
  • Designated credit officer 224 or responsible person 892 identifies and inputs 896 the reason(s) for the dispute with the customer and the amount in dispute.
  • the data is captured from the initial ARC setup during remittance processing.
  • the reason for the dispute may be a sales concession, invoice not per contract, pricing error, or other reasons unique to each client and maintained in tables.
  • Maintenance Module 204 is used to maintain various types of information about the customer. For example, Maintenance Module 204 maintains and allows modifications to the customer information such as name, telephone number, and address. As depicted in Figure 14, Maintenance Module 204 also maintains and updates connectivity between separate accounts. Additionally, through Maintenance Module 204 a customer service representative, designated credit officer 224, or any other representative of the business entity accesses or updates any information pertaining to the customer interface. Maintenance Module 204 is very flexible and is accessible from Credit Inquiry Module 190, Remittance Processing Module 194, ARC Module 200 or Administration Module 210.
  • Administration Module 210 deals with normal system administrator's functions including the maintenance of the security of the system. Additionally, Administrative Module 210 is utilized in updating various data and tables both during a nightly batch process and during on-line processing. Managers and supervisors have authority to access Administration Module 210 to update various records relating to the clients and their customers.
  • FIG 23 is a process flow chart 900 summarizing the functionality of ARS 10.
  • the first step of the process involves interfacing ' 910 with OSB system 20 to exchange and download the required data.
  • ARS 10 processes 930 billing files.
  • ARS 10 extracts 940 data from the received information and posts the data to ARS 10 where it is then available to authorized users of ARS 10 business entity and client system 14. Data is then loaded 950 and displayed 960 on client system 14 or any other devices attached to ARS 10 for analysis and processing 962.
  • the payment is received 970 from the customer, the payment is posted 980 to a proper customer account through ARS 10.
  • ARS 10 personnel having the authority to adjust 990 or move the payment from one account to another, in the event of an error.
  • ARS 10 generates 1000 the required general ledger entries and transfers
  • ARS 1010 the same to post on client's G/L system 180.
  • ARS 10 then downloads and displays general ledger entries as well as other information relating to the client or client's customers on devices 14 or client's work station 88.
  • the information retrieved from OSB 20 as well as information generated by ARS 10 between various steps is stored in Database 94 on disk storage unit 38.

Description

METHOD AND APPARATUS FOR MANAGING
REMITTANCE PROCESSING WITHIN ACCOUNT
RECEIVABLES
BACKGROUND OF THE INVENTION
This invention relates generally to a web-enabled Accounts Receivable System (ARS) and more particularly to methods and apparatus for managing various functions related to accounts receivables, credit granting, collection, dispute management and reporting and remittance processing.
The accounting department of a business entity expends substantial resources managing account receivables. An accounts receivable function includes the tasks of credit inquiries, approving credit to new and existing customers, and analyzing payment history of existing customers. In addition to credit approvals, aging of the receivables, disputes and delinquencies, collections and proper application of the payments, and determining appropriate write-offs and appropriate reporting capabilities, also must be managed. These tasks are time-consuming and often take away resources of the corporation from its operations and other profitable activities. Completing several of these tasks also typically requires interfacing with outside agencies for credit approval and constant updates to the customer records.
BRIEF SUMMARY OF THE INVENTION
In an exemplary embodiment of the invention, a web-enabled
Accounts Receivable System (ARS) provides a full range of trade receivables Credit & Collection services including credit evaluation, credit granting, customer collection and account reconciliation, remittance processing, application and banking, all account receivables (A/R) reporting, consolidation, including customer statement preparation and mailing, ending with direct feeds to a client's general ledger system (G/L) for the client's financial statement preparation. The system serves clients by allowing them to outsource their full accounts receivable (A/R) function while still retaining the important computer-to-computer links covering order shipping approvals (after credit evaluation), billing/invoice feeds, customer dispute monitoring and reporting (on-line), and final month-end G/L interface for receivables balancing.
The system includes five modules which include a Credit Inquiry Module, a Remittance Processing Module, an Accounts Receivable Claim Module, a Maintenance Module, and an Administration Module. These modules are integrated with each other and are capable of interfacing with a client's Order, Ship, Bill (OSB) system for smooth functioning. The ARS is further capable of automatically upgrading the software and systems templates to the client by downloading on a realtime basis as they are being implemented at a central site and as called for by a user.
In one embodiment of the invention, the ARS's Remittance Processing
Module accepts funds in any foreign currency and translates the funds into the required local currency for reporting purposes. Reporting is also done in a local or a foreign currency. Exchange gain and loss calculations are automatically generated by the Remittance Processing Module. The Remittance Processing Module performs Auto Draft and Reverse Application functions. Further, the Remittance Processing
Module accepts funds electronically, and, under certain conditions, automatically applies and updates a customer's account in the most efficient manner.
BRIEF DESCRIPTION OF THE DRAWINGS
Figure 1 is a block diagram of an Accounts Receivable System including a server system and a plurality of devices;
Figure 2 is a block diagram of an alternative embodiment of an
Accounts Receivable System;
Figure 3 is further another embodiment of an Accounts Receivable System;
Figure 4 is an exemplary embodiment of a software architecture for the Accounts Receivable System shown in Figure 3; Figure 5 is a database structure within a database server of the Accounts Receivable System shown in Figure 3;
Figure 6 depicts the functions of an Order, Ship, Bill (OSB) System and an Accounts Receivable System with reference to a business process;
Figure 7 depicts the functional relationship of the Accounts Receivable
System integrated directly into a client's OSB system and general ledger (G/L) system;
Figure 8 is an exemplary screen layout of the Accounts Receivable System shown in Figure 3;
Figure 9 is an activity diagram for performing a credit check through a
Credit Inquiry Module of the ARS shown in Figure 3;
Figure 10 is an activity diagram of the ARS shown in Figure 3, for the invoice generation;
Figure 11 is an activity diagram of the ARS shown in Figure 3, for remittance processing;
Figure 12 is an exemplary embodiment of a screen layout of the ARS shown in Figure 3, which displays a payment application to a customer account;
Figure 13 is an exemplary embodiment of a screen layout of the ARS shown in Figure 3, which displays the creation of a parent heirarchy record or payor heirarchy record for the subsidiary customer;
Figure 14 is an exemplary embodiment of a screen layout of the ARS shown in Figure 3, which displays the manner in which payment that has been applied by Accounts Receivable System may be subsequently reversed;
Figure 15 is an exemplary embodiment of a screen layout of the ARS shown in Figure 3, which displays the reversal of a zero application and all other records; Figure 16 is an activity diagram of the ARS shown in Figure 3, for the collection process;
Figure 17 is an exemplary screen layout of the Accounts Receivable System shown in Figure 3, which displays customer interchange credit;
Figure 18 is an exemplary screen layout of the ARS shown in Figure 3, which displays customer information sorted by customer number;
Figure 19 is an exemplary screen layout of the ARS shown in Figure 3, which displays the detail aging of a given customer along with scratch pad notes;
Figure 20 is an exemplary screen layout of the ARS shown in Figure 3, which displays the payment history of a given customer;
Figure 21 is an activity diagram of the Accounts Receivable claim (ARC) procedure of the ARS shown in Figure 3;
Figure 22 is an exemplary screen layout of the ARS shown in Figure 3, which displays the root cause analysis summarizing outstanding Accounts Receivable Claims; and
Figure 23 is a process flow chart for the ARS shown in Figure 3.
DETAILED DESCRIPTION OF THE INVENTION
Exemplary embodiments of systems and processes that facilitate integrated Internet-based accounts receivables process management are described below in detail. The systems and processes facilitate, for example, electronic submission of information using a client system, automated transmission of information, and web-enabled monitoring and reporting and management of account receivables including a final month end general ledger interface for receivable balancing for client's users.
The systems and processes are not limited to the specific embodiments described herein. In addition, components of each system and each process can be practiced independent and separate from other components and processes described herein. Each component and process can be used in combination with other components and processes.
Figure 1 is a simplified block diagram of an Accounts Receivable System (ARS) 10 including a server system 12 and a plurality of devices 14 connected to server system 12, In one embodiment, devices 14 are computers including a web browser, and server system 12 is accessible to devices 14 via the Internet. Devices 14 are interconnected to the Internet through many interfaces including a network, such as a local area network (LAN) or a wide area network (WAN), dial-in-connections, cable modems and special high-speed ISDN lines. Devices 14 could be any device capable of interconnecting to the Internet including a web-enabled phone or other web-enabled connectable equipment. Device 14 is capable of connecting directly to Order, Ship, Bill (OSB) System 20 located at the client site. Server system 12 is also capable of communicating with OSB system 20 either through a direct link or through one of devices 14 located at the client site and upload and download the data as required. Accounts Receivable System 10 is installed at a business entity site within a firewall 22 while OSB system 20 is located at client site outside firewall 22 of the business entity. Both systems are configured to download and upload required data through a secure connection for performing the required functions.
Figure 2 is a block diagram of an alternative- exemplary embodiment of a server architecture of Accounts Receivable System (ARS) 30. Components in system 30 identical to components of system 10 are identified in Figure 2 using the same reference numerals as used in Figure 1. System 30 includes a server system 12 and devices 14. Server system 12 includes a database server 36 including a data storage device 38, an application server 40, a web server 42, a directory server 46, a fax server 52 and a mail server 56. A disk storage unit 38 is coupled to database server 36 and director server 46. Servers 36, 40, 42, 46, 50, 52, and 56 are coupled in a local area network (LAN) 60. In addition, device 14 includes a system administrator work station 64, a customer service representative work station 66, a credit officer's work station 70, and a general function work station 72. Work station 72 is utilized by someone having an authorized access to maintain and update ARS 30. Work stations 64, 66, 70, and 72 are connected to LAN 60. Alternatively, workstations 64, 66, 70, and 72 are coupled to LAN 60 via an Internet link or connected through an Intranet.
Each work station 64, 66, 70 and 72, in the exemplary embodiment, is a personal computer including a web browser. Work stations 64, 66, 10 and 72, are illustrated as being associated with separate functions only to facilitate an understanding of the different types of functions that can be performed by individuals having access to LAN 60.
In an alternate embodiment, server system 12 is configured to be communicatively coupled to third parties, e.g., internal or external auditors 78, and to various clients 80 located outside firewall 22, via an Internet Service Provider (ISP) Internet connection 84. The communication in the exemplary embodiment is illustrated as being performed via the Internet, however, any other wide area network
(WAN) 86 type communication can be utilized, i.e., the systems and processes are not limited to being practiced via the Internet. In addition, and rather than a WAN, a local area network could be used in place of the WAN.
Each outside client 80 is connected to their own OSB system 20. Outside client 80 also has a work station 88, which is a personal computer including a web browser. Also, Work stations 88 are configured to communicate with server system 12. Furthermore, fax server 52 communicates with outside clients 80 and any of the remotely located overseas clients including a device (not shown) via a telephone link. Fax server 52 communicates with other devices 64, 66, 70 and 72, as well. Accounts Receivable System 30 is installed at a business entity site while OSB system 20 is located at the client site. Both systems 20, 30 are configured to download and upload required data through a secure connection, from each other, for performing the required functions. Continuous enhancements ensure compatibility to use new technology as it becomes available which ultimately reduce cost and improve efficiency. Figure 3 illustrates an alternative exemplary embodiment of an Accounts Receivable System (ARS) 90. Components in system 90 identical to components of system 30 are identified in Figure 3 showing the same reference numerals used in Figure 2. In this embodiment, device 14 is a desktop (thin device or often referred as thin client). Thin devices, as used herein, are Intel compatible PCs with Pentium or higher processors and a minimum 36 MB RAM running Windows 95 or Windows NT 4.0 workstation and Internet Explorer 4.0 and above. Server system 12 includes an application server 40 with a Pentium processor and a minimum 64 MB RAM running Windows NT 4.0 server and an Internet Information Server 92. The Business logic will reside in this layer in the form of Dynamic Link Libraries (DLL). An Oracle 7.3.2 database 94 on UNLX is used as a Database server 36, which is part of server system 12. Database server 36 is a server including a Pentium processor and a minimum 64 MB RAM running Sun Solaris. The database layer resides within database server 36. Centralized database 94 containing a variety of information relating to clients and their customers, as described below in greater detail, is stored on database server 36 of server system 12 and can be accessed by potential users at one of devices 14 by logging onto server system 12 through one of devices 14. Stored procedures are used to access database 94. All database interactions are done through Active X DLL's. Devices 14 are internally connected to OSB System 20 located at the client site. Server system 12 communicates with OSB system 20 either through a direct link or through one of the devices 14 located at the client site to upload and download the data as required.
Figure 4 is an exemplary embodiment of the software architecture 98 of ARS 30 as well as ARS 90, database server 36 and application server 40 of Server system 12. The Software Architecture used in ARS system 30 has a Web Browser such as IE 4.0 and above as the front end. The Web Browser downloads the ActiveX controls developed in VB5.0*. which forms the User Interface.
Middleware in ARS 30 implements the business rules and database calls and resides on the NT application server. The middleware is in the form of ActiveX objects (DLLs). Middleware is a software that connects two otherwise separate applications. For example, there are a number of middleware products that link a database system to a Web server. This allows users to request data from the database using forms displayed on a Web browser, and it enables the Web server to return dynamic Web pages based on the user's requests and profile. Middleware retrieves data from Oracle database 94 residing on the UNIX server. IIS is used as the Webserver. Active Database Objects (ADO) are used for database access. Oracle 7.3.2 database 94 resides on the UNIX Server.
Security in ARS 30 is closely monitored because of confidential and proprietary client information. Security is maintained in the system by providing various authority access levels. These access levels exist for individuals with different authorities such as Headquarter authority, supervisor authority, credit evaluator authority, Collector authority and remittance processing authority. When the user logs onto the application, the user's authority is checked, and depending upon the user's authority the user is given access to select screens.
Apart from the above security, ARS 30 also maintains regular security that is normally involved in every Intranet application. In every Active Server page ARS 30 checks whether the user has logged in and if the user has logged in then system 30 also checks whether the user has come for the right Active Server Page from which the user is supposed to access. If none of the above criteria is satisfied then system 30 displays an error message "Invalid Access to Screen". Also there is a session variable that checks if the logged on user is idle for more than a predetermined period of time and if so the user is automatically logged out of the application.
Figure 5 is database 94 structure within database server 36. Database 94 is coupled to several separate components within server system 12, which perform specific tasks. ARS 30 manages full range of trade receivables credit and collection services involving credit evaluation credit granting, customer collection and account reconciliation, remittance receipt, application processing, banking, receivables consolidation, and updating OSB general ledger. ARS 30 receives the pertinent information from client's OSB system 20 for processing and generating required journal entries with a variety of reports for financial monitoring, reporting and auditing purposes. The information retrieved and processed is stored in centralized database 94 for permanent as well as temporary access.
For example, server system 12 is divided into separate components such as, a download component 100 for downloading journal entries and a variety of reports, a display component 102 for displaying the journal entries and the variety of reports, a transmit component 108 for transmitting required information to the OSB system, and a printing component 112 for printing journal entries and the variety of reports downloaded and displayed by the respective server components. The system accepts commands from device 14, e.g., by utilizing a peripheral to make a selection or by utilizing a voice command. Server system 12 includes a processing component 116 for searching and processing received requests against data storage device 38. Furthermore, server system 12 also includes a retrieving component 120 to retrieve information from data storage device 38. An information fulfillment component 122 downloads the requested information after retrieving from data storage device 38 to the plurality of devices.
The architectures of systems 10 as well as various components of system 10 are exemplary only. Other architectures are possible and can be utilized in connection with practicing the processes described below.
Figures 6 through 23 illustrate the operational flow of ARS 10 including the interrelationship among various ARS 10 modules and the interface between ARS 10 and OSB 20.
Figure 6 depicts the functions of OSB System 20 and ARS 10, with reference to a business process 160. OSB * System 20 includes an Order Entry function 164, a Shipping function 170 and a Billing function 174. ARS 10 includes the remaining functions involved with accounts receivables of business process 160 including managing customer credits, receiving and processing payments against open invoices, balancing general ledger on a periodic basis, financial statement data generation for accounting and internal controls and preparing periodic reports to meet generally accepted accounting principles (GAAP) and Financial Accounting Standards Board (FASB) requirements. Clients 80 from their individual locations operate OSB system 20 and a General Ledger (G/L) system 180. ARS 10 is operated at a remote location by a business entity, which has a group of professionals specializing in ARS 10. In an alternative embodiment, ARS 10 is operated and
* managed at the clients' locations by the clients' own staff with training and system enhancements being performed by ARS 10 staff.
Figure 7 shows how ARS 10 interfaces with a client OSB system 20 and general ledger (G/L) module 180 to provide continuity to the client. ARS 10 receives the data from, and transmits the data to, the different components of OSB system 20 such as Order Entry 164, Shipping 170, and Billing 174. Order Entry 164 processes the customer order by extracting data from Pricing component 176 and Inventory component 178. ARS 10 also interacts with various other components 182 of client system as required. The integrity of OSB system 20 is critical for proper functioning of ARS 10 since ARS 10 uses the data received from OSB 20 to generate the general ledger entries as well as other management reports. ARS 10 manages several other aspects of business process 160 to properly populate the general ledger with pertinent receivable data on a periodic basis including processes involved with credit management.
Figure 8 is an exemplary screen layout of ARS 10. ARS 10 involves credit granting, collection, remittance processing, and reporting/administration. ARS functions are organized into five modules: a Credit Inquiry Module 190, a remittance processing Module 194, an Accounts Receivable Claim (ARC) Module 200, a Maintenance Module 204 and an Administration Module 210. Remittance Processing Module 194 is sometimes referred to as a Cash Application Module. Credit Inquiry Module 190 provides to the user extensive customer and receivable related information in a variety of ways. Remittance Processing Module 194 involves processing of remittance payments, delinquency management and payment-related functions. ARC Module 200 manages customer disputes. Maintenance Module 204 is used to maintain and store various types of customer information. Administration Module 210 is used to handle security and high-level systems functions.
There is a high level of integration across all the modules. Although a user may enter a function attached to a particular module in ARS 10, subsequent navigation takes the user back and forth across the different modules in ARS 10. For example, a user applying a check in Remittance Processing Module 194 accesses Credit Inquiry Module 190 to conduct a customer search or to display invoice details. A user viewing a customer statement accesses Maintenance Module 204 to modify customer information, or Remittance Processing Module 194 to offset debit and credits together under the account, or ARC Module 200 to set up or display a dispute. A user searching for an invoice in Credit Inquiry Module 190 or setting up a reference between two invoices in Maintenance Module 204 accesses Remittance Processing Module 194 to display a list of duplicate invoices. Similarly, a user reviewing billing batches in Administration Module 210 accesses Credit Inquiry Module 190 to display invoice details.
Overall, ARS 10 provides a full range of credit and collection services for trade receivables including credit evaluation, credit granting, customer collection and account reconciliation, payment receipt, application and banking, account receivables (A R) reporting, consolidation, including customer statement preparation and mailing, ending with direct feeds to the client's general ledger (G/L) system 180 for financial statement preparation. ARS 10 can produce journal entries to update G/L system 180 by using pseudo account numbers internally which are mapped and transferred to client's G/L system 180 via a file transfer protocol (FTP). ARS 10 provides an option to clients 80 to outsource their full A R function while still retaining the important computer-to-computer links with OSB system 20 covering order shipping approvals (after credit valuation), billing/invoice feeds, customer dispute monitoring and reporting (on-line), and final month-end G/L interface for receivables balancing. Each module of ARS 10 is described in detail.
A. CREDIT INQUIRY MODULE Credit Inquiry Module 190 primarily involves credit evaluation at the time the customer account is set up, and credit maintenance activities. Credit Inquiry Module 190 also interfaces with various modules to access delinquencies, collections and write-offs.
Credit Inquiry Module 190 reviews pay history and performs ' credit inquiries. Pay history is a set of calculations based on a payment period from invoice date to date of payment received. ARS 10 sorts all data and compiles it into a report that compares the data over an eighteen-month period and displays it in six-month increments. Credit Inquiry Module 190 accesses a customer account and views a diverse supply of data used for customer analysis, credit management, and customer contact. Credit Inquiry Module 190 further includes search options.
Credit Inquiry Module 190 predicts remittance forecasts for a specific customer or account based on historic data. ARS 10 predicts overall cash forecasting for the client. Credit Inquiry Module 190 further performs audit verification for tracking all transactions at the customer level for account reconciliation.
1. CREDIT APPLICATION PROCESS [NEW CUSTOMER]
The client works with the business entity to establish approval criteria on new customer accounts and to choose client specific credit scoring options using scoring software programs contained in ARS 10.
Figure 9 is an activity diagram for performing a credit check for an existing customer through Credit Inquiry Module 190 on a customer who has placed a purchase order through OSB system 20. Once the customer places a purchase order, ARS 10 receives a request for approval 220 on a new account. ARS 10 procedures routes request for approval 220 to a designated credit officer 224 out of a plurality of credit officers 230. Credit officers 230 are also sometimes referred to as collectors or collection representatives. Designated credit officer 224 performs an initial credit investigation 234 on request for approval 220 of the new account. Designated credit officer 224 automatically approves request for approval 220 if the order aggregates less than an amount specified by the client or if the order is from a specified known customer pre-designated by the client. If request for approval 220 is not automatically approved 240, designated credit officer 224 performs a detailed credit investigation 244.
Credit investigation 244 does not have a specified application; rather it involves a variety of tools such as Dun & Bradstreet reports 250 and or other credit reporting agencies 254, trade references 260, bank reports 264, financial statements 270, customer visits 274, and survey of Mines and Industrials 280. ARS 10 electronically interfaces with Dun & Bradstreet or other credit reporting agencies for searching and identifying a customer by name, address and telephone number and obtaining Dun & Bradstreet reports 250 or other credit reporting agencies reports 254, thereby minimizing the time in the credit approval process.
Based on credit investigation 244, designated credit officer 224 determines whether credit should be granted to the customer. Each designated credit officer 224 has limits to the credit authority, which are resident and strictly controlled within ARS 10. Designated credit officer 224 cannot grant a credit line in excess of their delegated authority limits. ARS 10 restricts access for changing the credit limits of credit officers 230 only to specified authorized individuals within the business entity.
If the customer meets the pre-determined parameters of credit investigation 244 and if the credit is within the limits authorized to designated credit officer 224, designated credit officer 224 approves the new account request. If the customer does not meet the pre-determined parameters of credit investigation 244 or if the credit requested by the customer exceeds the authorized limits of designated credit officer 224, then ARS 10 personnel attempts to obtain security 290 such as personal guarantees 294, inter-corporate guarantees 300, PPSA 304 or conditional sales agreements 310. For approval of various orders, a letter of credit 314 may be sought. Once designated credit officer 224 makes a decision 324 to approve the order, ARS 10 assigns an approval number in the case of an existing account or an account number 326 in the case of a new customer account to the order and interfaces with OSB system 20 which performs Order Entry function 164, Shipping function 170, and Billing function 174. An interface 330 completes the credit approval process.
2. CUSTOMER ORDER APPRO VAL-[EXISTING CUSTOMER]
Figure 10 is an activity diagram which depicts the process for customer order approval and invoice generation 412 as well as credit approval and posting of general ledger entries on G/L system 180. Activities are located in respective columns based on the system that performs the activity. The columns correspond to OSB system 20, G/L (General Ledger) System 180 and ARS 10.
OSB system 20 enters/ receives a customer order approval request 414. OSB system 20 makes 416 a decision to automatically approve customer order 414 if the amount of order 414 is less than or equal to the Order Control Limit (OCL) 422. OCL 422 is initially established when the account is set up in ARS 10. After the initial set up, there are three ways in which the OCL 422 can be adjusted. Designated credit officer 224 can change the limit, or can place a Hold Order or a Credit Referral on the account. If a Hold Order or Credit Referral is placed on the account, OCL 422 is automatically reduced to zero. These changes to OCL 422 are fed to the client's OSB system 20 in a pre-determined cycle.
If the amount of approval request 414 exceeds 424 the OCL, approval request 414 is deferred and designated credit officer 224 is informed of the deferral through ARS 10. Designated credit officer 224 then makes 428 a decision to approve, decline or hold the approval request 414. Since the information is fed back and forth between OSB system 20 and ARS 10 in pre-determined cycles, the time lag for a decision is short with the vast majority being automatically and instantly approved within the client's. OSB 20 based on ARS 10 pre-approvals. Once approved, OSB system 20 ships product 430 and generates a final invoice 432. The client's OSB system 20 manages pricing and stores this information together with customer discounting structures, etc., within OSB system 20 and subsequently generates a customer invoice (hard copy or electronic) for its customer. OSB system 20 also creates a batch file 436 and dispatches said batch file 436 to ARS 10 the same evening.
Batch file 436 includes basic information 440 pertaining to invoice 432. Information 440 received electronically to ARS 10 includes information such as a date of invoice 442, a due date of invoice 444, a currency of invoice 446, an amount of invoice 448, a customer number 450, a billing identification recognition code (IC) 452, an invoice number 454, other payment terms 456 and a customer purchase order number 458, if available.
ARS 10 then uses batch file 436 to update the customer's statement 460 for collection and monitoring purposes. ARS 10 also posts a journal entry 462 for balancing of the client's G/L system 180 at the month end. ARS 10 finally produces an "assessed receivable" total 464, which provides the client with the G/L interface numbers to balance its financial statement and outstanding receivables. As part of this function, ARS 10 produces aged trial balances, dispute reports, trending reports, and any other reports for use by the client in substantiating assessed receivable total 464.
B. REMITTANCE PROCESSING MODULE
Remittance Processing Module 194 involves application of remittance payments, aging the receivables. Remittance Processing Module 194 has several capabilities including accepting funds in any foreign currency and translating the funds into the required local currency for reporting purposes. In one embodiment, the reporting is conducted in local currency. In an alternative embodiment, the reporting is conducted in foreign currency. Exchange gain and loss calculations are automatically generated by Remittance Processing Module 194 of . ARS 10. Remittance Processing Module 194, under certain conditions, automatically applies and updates a customer's account through a series of algorithms. Appropriate individuals, as designated, based on systems' security levels, have the authority to ZAP a particular account. ZAP is a derivative of remittance processing which allows for offsetting of items within a customer's account. In these situations, updating of balance is performed automatically online.
Remittance Processing Module 194 displays the accounts and applies the received cash by Payor Hierarchy. Payor Hierarchy allows the user to access multiple accounts through one or more designated main accounts. Remittance Processing Module 194 also allows Auto Draft and Reverse Application functions in conjunction with Maintenance Module 204. Auto Draft selects specific invoices in a customer's account to be paid, which are formatted into an electronic bank file for funds transfer. Through Reverse Application, ARS 10 reverses previously completed applications and associated general ledger entries on G/L system 180, and restores the account to the original balance on-line.
The following steps explain the operational and the functional flow involved in managing Remittance Processing Module 194.
1. PAYMENT RECEIPTS AND APPLICATION
Figure 11 is an activity diagram for remittance processing. In most cases, the customer remits to the business entity the payment 470 on invoices through checks, wire transfers, electronic deposits, credit cards or drafts. ARS 10 receives the payments 474 and deposits them 480 in client's bank account.
Remittance Processing Module 194 of ARS 10 generally applies payments 474 to the invoice(s) 440 to which the customer wishes the payment to be applied. If remittance instructions are not received by ARS 10, the cash received is treated as On Account Unapplied Cash. ARS 10 automatically sends a letter to customers who have On Account Unapplied Cash. The letter asks for instructions on how to apply the cash (and may result in a call to the customer for information). The On Account Unapplied Cash moves with the aging buckets but does not reduce the delinquency amounts until it is applied, unless specifically cross referenced by designated credit officer 224 to a particular aging bucket. The cross-references done by designated credit officer 224 reduce the balance of the aging buckets that the On Account Unapplied Cash amounts are cross-referenced to in ARS 10. ARS 10 maintains an audit trail of all cross-references made by designated credit officer 224.
ARS 10 accepts payments 474 in multi-currency 484 and accounts for exchange gains or losses in the balancing process. ARS 10 also offers on-line remittance processing 490 so that concurrently with the application of the checks against the invoices, these invoices are shown as paid and the customer balance is updated in an on-line format. Remittance processing 490 allows for multi-account connectivity as depicted in Figure 14 herein. During remittance processing 490, ARS 10 identifies any cash variances, exchange losses, discounts and concessions that are allowed. ARS 10 then automatically balances payment 474 by writing the journal entry so that the appropriate cash variance, exchange variance, discount or concession journal entry is included in the receivable totals balancing 494. Remittance Processing Module 194 is balanced 494 in batch mode overnight and the appropriate journal entries are generated to update the receivable numbers in the client's G/L system 180.
ARS 10 produces numerous reports and on-line screens which remittance processors use to reconcile the amounts of payments 474 received against the amount of cash applied and the amount deposited in the bank, so that any imbalance positions are immediately discovered. ARS 10 produces a current activity file on every transaction or edit to ARS 10 and also ties in the identification code of the person who made any change within ARS 10 at any time. This file is archived to a storage media.
Figure 12 is an exemplary embodiment of a screen layout of ARS 10, which displays a payment application 510 to a customer account. Payment application 510 permits the operator to select a method 514 to apply the payment in a particular manner, such as by account descending 516, a statement balance 520, an invoice number 522, a payment from oldest invoices 524, pay by finder number 530, an invoice search 534, etc. Figure 13 is an exemplary embodiment of a screen layout of ARS 10, which displays the creation of a parent hierarchy record or payor hierarchy record for the subsidiary customer. Specifically, the customer record of a subsidiary 544 is interconnected to a payor 600. This provides a merging of multiple accounts in order to obtain on-line aging of customer exposure and better facilitate remittance processing.
Figure 14 is an exemplary embodiment of a screen layout of ARS 10, which displays the manner in which payment 474 that has been applied by ARS 10 may be subsequently reversed. A previous payment application is reversed in ARS 10 by providing information relating to a customer number 610, a check reference
614, a check number 620, a lock box number 624, a batch type 630, and a batch number 634.
In an alternative embodiment, information is automatically provided by data from other screens being used to populate select fields within reverse check screens.
Figure 15 is an exemplary embodiment of a screen layout of ARS 10, which displays the reversal of a zero application and all other records. The screen layout identifies a customer number 640, a finder number 642, and an invoice number
644 through which the operator offsets certain items to an account of customer 640 and updates the records of customer 640 on-line.
2. CONCENTRATION MONITORING
Designated credit officer 224 can monitor the account balances and activity on-line through ARS 10. Periodically, reports are generated that indicate the accounts on which action is required during the following week. Accounts are included in the report if they meet any of the exception conditions which can be changed immediately through the use of tables. ARS 10 produces numerous reports from the individual account level up to the overall client level.
3. AGING The criteria and process used in ARS 10 aging are very definitive, with an item being classified as being past due on the day after its due date. The aging of accounts in the credit status system is automated such that customer remittances are applied on-line, and the customer's balance is updated immediately for credit control purposes. Invoices that are not delinquent are broken into two sections: Current and
Not Due. Current means the invoice is due within 30 days from a defined closing date. Not-due means that the invoice is due at least 31 days from a defined closing date. Delinquent (or past due) means the invoice is unpaid at least one day after its individual due date. The main report used to identify aging is an Aged Trial Balances as well as a Trending Report.
Although the aging of accounts receivable has been described here in Remittance Processing Module 194, in another embodiment, it can be accessed or interfaced from other modules such as Credit Inquiry Module 190, ARC Module 194 or Maintenance Module 204.
4. DELINQUENCYMANAGEMENT
The normal, delinquency collection cycle takes place by designated credit officer 224 and is triggered by either a past due condition which is identified on a weekly exception condition run and/or an on-line inquiry screen showing a customer who has exceeded their credit line. Although there are a variety of reasons for making collection calls or reconciliation attempts, the principal reason is delinquency.
One of the biggest collection incentives are the targets imposed upon credit officers 230 for collections as a percent to available receivables (total receivable balance less not dues) as well as percent to forecasted collections (used to measure ability of credit officer 224 to set accurate targets) which are monitored and reported on a monthly basis for each credit officer 224 and which become a part of the yearly performance evaluation of credit officers 230.
Figure 16 is an exemplary embodiment of a simplified activity diagram of the collection process. Once accounts have been identified as requiring collection calls or preliminary investigative calls, designated credit officer 224 begins the required collection activities 700. These are reviewed based on collections as a percent to forecast and available amounts as well as delinquency ratios. Delinquent accounts are reviewed routinely by credit officers 230 with their particular District Credit Managers in order to increase the intensity and level of collection activity, if required.
Some customers require a high degree of account reconciliation which must take place between credit notes being issued, customer debit notes being deducted, ARC 654 being rejected and/or proof of delivery supplied, etc. This is done on a daily basis by designated credit officer 224 as he provides the expertise to effectively manage the portfolio so that the client's own internal measurements are achieved. There are, however, cases where concessions are made to the customer and these are normally taken up by the District Credit Managers who reviews the items in question with designated credit officer 224 and makes recommendations for concession write-offs to the Region Manager who further reviews and, if appropriate, requests sign-off by the Nice President-Finance of the client. The client has the option of delegating this to the personnel of the business entity.
ARS 10 has a variety of reports that monitor delinquencies such as an aged trial balance 710, an on-line aged balance 712, an on-line customer data summary 714, an interchange 720 from various credit agencies, payment habit statistics 724, ARS 10 generated collection letters 730 (also sometimes referred to as "dunning" letters), a credit scoring 734, a parent hierarchy 740, communications on scratch pad 744, and other reports. Payment habit statistics 724, also sometimes referred to as payment history reports, are on a per account basis, per credit officer 224 basis, per client basis, etc. These reports are generated either on-line or in a monthly format together with the weekly exception reports on collection calls that are required. They are distributed to designated credit officer 224 with monthly aged trial balance 710 being provided to the individual client involved. The "trending report" encapsulates 38 actuals of A/R information per month on a 13 month tracking trend on one sheet of paper with their top 25 customer abusers on the back page. An account is defined as being past due or delinquent within ARS 10 on the first day beyond the agreed upon terms of sale 746. For example, an invoice billed on January 1st, 2000 with a term of net 30 days becomes past due and delinquent on January 31, 2000 and is reported in that format. ARS 10 extracts from the billing input file the term 456 that is associated with each individual invoice and, together with its table matrix which has been approved by the client, assigns the particular due date 444. The aging on ARS 10 is measured on a day-by-day basis, which is an accurate measurement facilitating better follow-up on delinquencies.
Each month ARS 10 receives feeds from Dun & Bradstreet and other credit reporting agencies. Ownership changes, rating changes, judgments, and large decreases in Paydex or Payment Index scores are reported to designated credit officer 224 in a hard copy report. Additionally, any promises to pay made by customers are input into ARS 10. These promises also appear on-line and on the weekly exception reports.
Delinquent accounts are handled by a variety of methods depending on the size of the dollars past due and the customer history for delinquencies. Collection letters are used 750 for smaller accounts. Multiple Collection letters, of increasing (strength), may be generated after individual invoice due dates based on a variable criteria by client and at predetermined intervals. Larger or "at risk" customers typically do not pass through the collection letter process 750 and are directly contacted by phone when their accounts become past due.
Sometimes, a customer has delinquencies in the form of a reconciliation progress whereby a substantial portion of the account is paid within the normal industry standard payment terms and it is important that collection calls not irritate the customer. Designated credit officer 224 is responsible to manage the account through its life cycle and to build a customer service oriented rapport with that customer for the maximum benefit to the client. In some cases special arrangements such as having the customer pay down old balances with the purchase of new goods allows the customer to work down any outstanding obligations. ARS 10 also reviews 754 other documentation pertaining to the delinquent account such as letter of credit 314, export insurance, and other financing documents.
Past due accounts are managed by a variety of credit officers 230 and are, in various instances, placed for collection 760 with an outside collection agency and/or lawyer prior to the request for bad debt authorization. By this, an independent third party makes an unbiased attempt at collecting the funds before writing it off as a bad debt. Customers that are bankrupt or have receivers appointed are handled 764 in accordance with the appropriate law. Generally, ARS 10 transfers such accounts to active bad debt files (discussed below). Any cash collected through collection activities 700 is processed through Remittance Processing Module 194.
Figure 17 is an exemplary screen layout of ARS 10, which displays customer credit interchange. Although the screen layout displays an embodiment of Dun & Bradstreet reports 250, similar screens are also obtainable from other credit reporting agencies 254. ARS 10 utilizes a risk code system 766 that assigns a value from 1 to 8 based on information from trade experiences, Dun and Bradstreet, and other credit reporting agencies. If no information is available, the account is coded "N". These codes are used to override "off switches that may be present, such as the switch to turn off collection letters, also known as Dunning letters (discussed later) or other exception conditions.
Figure 18 is an exemplary screen layout of ARS 10 which displays customer information sorted by customer number 768. This inforriiation is accessed by designated credit officer 224 through ARS 10 during their detailed credit investigation 244 as well as on-going account review and monitoring. The customer information includes a name 770, an address 772, a telephone number 774, a Dun & Bradstreet rating 776, a risk code 778, an amount of highest credit 780, a date of last sale 782, the year-to-date sales 784, the unshipped order 786, a date customer was opened 788, a balance 790, a current balance 792, a past due balance 794, a name of parent 796, a currency 798, credit status 800, and other information. ARS 10 reviews individual accounts on an exception basis. There is also a more formalized procedure whereby ARS 10 establishes a periodic credit update review and alerts designated credit officer 224 within a pre-determined time period prior to the lapse of the date that a review is required. This review may be simply designated credit officer's 224 mental review of the account, payment status with ARS 10, pay history, days to pay statistics, Dun & Bradstreet on-line interface information, so that an approval is input in ARS 10 to change the review date for another year. ARS 10 checks any change in the credit requirement to the individual identification code of designated credit officer 224 making the change to ensure that the credit limit of the customer has not been increased beyond the delegated authority of designated credit officer 224.
Figure 19 is an exemplary screen layout of ARS 10, which displays the detail aging of a given customer 802 along with scratch pad notes 744. Scratch pad notes 744 include telephone or other exchange with or from customer, information regarding credits to customer, or other information. The screen layout identifies a date
804 of the last check received from customer 802 and the aging of the accounts receivable balance 806 which classifies the balance as past due for 1-30 days, 31-60 days, 61-90 days, 91-180 days, 181-365 days and over 365 days.
Figure 20 is an exemplary screen layout of ARS 10, which displays the payment history 810 of a given customer 802. For customer 802, the screen layout identifies the net sales 812, the credit notes 814, the highest credit granted 816, a write-off amount 820, a check returned for not-sufficient funds 824 and other information, all of which information is displayed by the current semester 830, the last six months 834 and the prior six months 840.
Although delinquency management of accounts receivable has been described here in Remittance Processing Module 194, in another embodiment, it can be accessed or interfaced from other modules such as Credit Inquiry Module 190, ARC Module 200 or Maintenance Module 204.
5. BAD DEBT- WRITE OFFS AND RECOVERIES ARS 10 provides a sophisticated method for tracking bad debts once they are written off. In essence, when a write off to bad debt takes place, a journal entry is input to ARS 10 which simply transfers a mirror image of that customer's bad debt statement out of the normal receivable statements, generates an automatic journal entry to the client's G/L system 180 and mirror images the customer statement on an internal "active bad debt file". From the client's perspective the balance is treated as a write-off. All write-offs proposed by ARS 10 are signed off by the client's Vice President of Finance (or delegate). Bad debts principally generated from receiverships, bankruptcies, etc., are still treated as active bad debt customers. Such information is transferred to the active bad debt file on ARS 10 which does not impact the client's aged trial balances. Files are transferred to the management individual assigned responsibility for bad debt monitoring who, on a routine basis, follows up with the various trustees, receivers, collection agencies, etc., to generate some recovery. On receipt of a final disbursement letter from the trustee or receiver, or a decision is made that there is no chance of additional recovery, the District
Manager prepares a recommendation to transfer these specific customers out of the active bad debt file and to consider them to be inactive bad debts, which are then consolidated and stored in off-site storage for tax and audit purposes.
ARS 10 produces monthly runs of outstanding active bad debt accounts which are controlled by the appropriate District Managers. All bad debts are signed by the District Manager, the General Manager and a client delegate of the Vice President Finance.
Bad debt provisions are calculated by ARS 10 for each year and then divided into quarters. The bad debt provision is set at the average net bad debts over the last six years. The provision is checked against actual bad debts each quarter, and provisions are also adjusted up or down each quarter, as required. Near-end bad debt provisions, as calculated on ARS 10, are then recommended to the client.
Although the write-off process has been described here in Remittance Processing Module 194, in another embodiment, it can be accessed or interfaced from other modules such as Credit Inquiry Module 190, ARC Module 200 or Maintenance Module 204.
C. ACCOUNT RECEIVABLE CLAIMS (ARC) MODULE
ARC Module 200 manages the Accounts Receivable Claim Process which involves identifying invoices as disputed, and sending notice of such disputes to the client for resolution through on line communication. Upon generation of a claim, ARS 20 tracks the status in multiple ways and ages disputed items until final resolution.
The following process description explains the details involved in dispute resolution and other aspects of operational functions involved in managing
Accounts Receivable Claims.
1. DISPUTE RESOLUTION
Figure 21 is an activity diagram of the accounts receivable claim procedure. Disputes from customers are recorded 844 in ARC Module 200, which are instantly logged in, numbered, and filled in with the appropriate word description to generate an accounts receivable claim (ARC) 846. Based on the identification code matrix established for ARS 10, ARC 846 is immediately available on-line 850 to the responsible person within the client 854 for resolution and on-line tracking 860. Hard copies of individual disputes are also printed overnight 850 in batch mode on designated printers for each of the client's responsible persons if requested. These persons input comments 864 on-line with any credit notes that are issued to adjust the customer short payments so that prompt offsets take place for aging purposes. Designated credit officer 224 puts their comments 870 on ARC 846. Should a customer dispute be disallowed or rejected, using ARC 846 the client writes to the customer wherein the letter is laser printed on ARS 10 and mailed or faxed from the business entity's pooled location using the business entity's mailing volumes and procedures. These letters are electronic and become a part of ARC 846 for follow-up and audit purposes. Once the dispute is resolved, designated credit officer 224 closes 874 ARC. Open ARC 846 is maintained, reporting stored 880 on-line for aging purposes until, collected, credited or written off.
Figure 22 is an exemplary screen layout of ARS 10, which displays the root cause analysis 890 summarizing outstanding Accounts Receivable Claims. This screen layout identifies the customer, a responsible person 892 from the client for said customer and an aging 894 of the accounts receivable disputes balance for the customer. Aging 894 identifies if the balance is current, 2 months past due, 3 months past due, 4-6 months past due, 7-12 months past due or 12 months past due. Designated credit officer 224 or responsible person 892 identifies and inputs 896 the reason(s) for the dispute with the customer and the amount in dispute. In an alternative embodiment, the data is captured from the initial ARC setup during remittance processing. For example, the reason for the dispute may be a sales concession, invoice not per contract, pricing error, or other reasons unique to each client and maintained in tables.
D. MAINTENANCE MODULE
Maintenance Module 204 is used to maintain various types of information about the customer. For example, Maintenance Module 204 maintains and allows modifications to the customer information such as name, telephone number, and address. As depicted in Figure 14, Maintenance Module 204 also maintains and updates connectivity between separate accounts. Additionally, through Maintenance Module 204 a customer service representative, designated credit officer 224, or any other representative of the business entity accesses or updates any information pertaining to the customer interface. Maintenance Module 204 is very flexible and is accessible from Credit Inquiry Module 190, Remittance Processing Module 194, ARC Module 200 or Administration Module 210.
E. ADMINISTRATION MODULE
Administration Module 210 deals with normal system administrator's functions including the maintenance of the security of the system. Additionally, Administrative Module 210 is utilized in updating various data and tables both during a nightly batch process and during on-line processing. Managers and supervisors have authority to access Administration Module 210 to update various records relating to the clients and their customers.
Figure 23 is a process flow chart 900 summarizing the functionality of ARS 10. The first step of the process involves interfacing' 910 with OSB system 20 to exchange and download the required data. After receiving 920 the invoice data, ARS 10 processes 930 billing files. ARS 10 extracts 940 data from the received information and posts the data to ARS 10 where it is then available to authorized users of ARS 10 business entity and client system 14. Data is then loaded 950 and displayed 960 on client system 14 or any other devices attached to ARS 10 for analysis and processing 962. Once the payment is received 970 from the customer, the payment is posted 980 to a proper customer account through ARS 10. ARS 10 personnel having the authority to adjust 990 or move the payment from one account to another, in the event of an error. Once the payment is posted and the account is updated, ARS 10 generates 1000 the required general ledger entries and transfers
1010 the same to post on client's G/L system 180. ARS 10 then downloads and displays general ledger entries as well as other information relating to the client or client's customers on devices 14 or client's work station 88. The information retrieved from OSB 20 as well as information generated by ARS 10 between various steps is stored in Database 94 on disk storage unit 38.
While the invention has been described in terms of various specific embodiments, those skilled in the art will recognize that the invention can be practiced with modification within the spirit and scope of the claims.

Claims

WHAT IS CLAIMED IS:
1. A method for managing trade receivables credit and collection services using an account receivables system coupled to a database, said method comprising the steps of:
receiving customer invoice information from a client system;
utilizing data from the customer invoice information;
accepting a payment from the customer;
updating a customer account by posting the payment after applying against correct invoices; and
generating journal entries to update account receivables.
2. A method in accordance with Claim 1 wherein said step of receiving customer information from a client system further comprises the step of receiving information from a client's OSB system.
3. A method in accordance with Claim 1 wherein the accounts receivable system is coupled to a client system by a wide area network, said step of receiving customer invoice information from the client system further comprises the steps of:
establishing a communication link between the client system and the account receivables system; and
authenticating the client system.
4. A method in accordance with Claim 1 wherein the accounts receivable system is coupled to a client system by a local area network, said step of receiving customer invoice information from the client system further comprises the steps of: establishing a communication link between the client system and the account receivables system; and
authenticating the client system.
5. A method in accordance with Claim 1 wherein the accounts receivable system is coupled to a client system by the Internet, said step of receiving customer invoice information from the client system further comprises the steps of:
establishing a communication link between the client system and the account receivables system; and
authenticating the client system.
6. A method in accordance with Claim 5 wherein said step of establishing a communication link further comprises the step of linking the account receivables system to the client system by a telephone link.
7. A method in accordance with Claim 1 wherein said step of receiving customer invoice information further comprises the step of receiving at least one of currency of invoice, due date of invoice, payment terms of invoice, amounts of invoice, invoice number, billing indent recognition code, customer identification number, and customer purchase order number.
8. A method in accordance with Claim 1 further comprising the steps of loading and updating the client system with updated general ledger entries.
9. A method in accordance with Claim 1 further comprising the steps of loading and updating the client system with updated account receivables status.
10. A method in accordance with Claim 1 further comprising the steps of loading and updating the client system with updated customer outstanding balance after posting the customer payment.
11. A method in accordance with Claim 1 wherein said step of accepting a payment from the customer further comprises the steps of:
identifying a currency of the invoice;
checking the payment currency;
converting the payment currency, if necessary, to accept the payment in the same currency as the currency of the invoice;
posting the payment to the invoice and generate any discrepancy report, if necessary, to the customer.
12. A method in accordance with Claim 1 wherein said step of posting the payment to the invoice further comprises the step of updating account receivables aging report on-line.
13. A method in accordance with Claim 1 wherein said step of updating a customer account further includes the steps of:
automatically generating a letter requesting a specific instructions to the customer on how to apply the cash if the customer account reflects On Account
Unapplied Cash; and
sending a letter to the customer.
14. Apparatus for managing trade receivables credit and collection services using an account receivables system coupled to a database, said apparatus comprising:
a database; and
an account receivables system coupled to a client system by a communication link, said account receivables system configured to:
receive customer invoice information from the client system; utilizes data from the customer invoice information;
accept a payment from the customer;
update the customer account by posting the payment after applying against correct invoices; and
generate appropriate journal entries to update account receivables.
15. Apparatus in accordance with Claim 14 wherein said client system is a client's OSB system.
16. Apparatus in accordance with Claim 14 wherein the communication link is at least a wide area network, a local area network and the Internet.
17. Apparatus in accordance with Claim 14 wherein said accounts receivable system is further configured to receive customer invoice information from the client system after authenticating the client system.
18. Apparatus in accordance with Claim 14 wherein said account receivables system is further configured to receive at least one of currency of invoice, due date of invoice, payment terms of invoice, amounts of invoice, invoice number, billing indent recognition code, customer identification number, and customer purchase order number.
19. Apparatus in accordance with Claim 14 wherein said account receivables system is coupled to the client system by a telephone link.
20. Apparatus in accordance with Claim 14 wherein said account receivables system is further configured to load and update the client system with updated general ledger entries.
21. Apparatus in accordance with Claim 14 wherein said account receivables system is further configured to load and update the client system with updated account receivables status.
22. Apparatus in accordance with Claim 14 wherein said account receivables system is further configured to load and update the client system with updated customer outstanding balance after posting the customer payment.
23. Apparatus in accordance with Claim 14 wherein said account receivables system is further configured to accept a payment from the customer further configured to:
identify a currency of the invoice;
check a payment currency;
convert the payment currency, if necessary, to accept the payment in the same currency as the currency of the invoice;
post the payment to the invoice and generate any discrepancy report, if necessary, to the customer.
24. Apparatus in accordance with Claim 23 wherein said accounts receivable system is further configured to update account receivables aging report online.
25. Apparatus in accordance with Claim 14 wherein said accounts receivable system configured to update the customer account is further configured to:
automatically generate a letter requesting a specific instructions to the customer on how to apply the cash if the customer account reflects On Account Unapplied Cash; and
send a letter to the customer.
26. Apparatus in accordance with Claim 14 wherein said accounts receivable system is further configured to:
grant a specific credit line to a customer based on a delegated authority limits of a credit officer; and
communicate the credit line information to the client.
27. Apparatus in accordance with Claim 14 wherein said account receivables system is further configured to:
produce an electronic file showing a customer payment history for electronic input to any credit agency;
retrieve information electronically including trade information, aging, credit ratings, credit scoring, and suggested credit limit information from any other reputed credit agency; and
accept an electronic file from any other reputed credit agency into the accounts receivable system.
28. Apparatus in accordance with Claim 14 wherein said account receivables system is further configured to receive and process customer invoice information from the client manually instead of the client system electronically.
29. Apparatus in accordance with Claim 14 wherein said accounts receivables system is coupled to the client by a wide area network, and said account receivables system is further configured to receive customer invoice information through a communication link between the OSB system and the account receivables system.
30. Apparatus in accordance with Claim 29 wherein said account receivables system wherein the wide area network is the Internet.
31. Apparatus in accordance with Claim 14 wherein said accounts receivables system is further coupled to a customer service analyst computer to provide access to the customer information in the account receivables system to the customer service analyst.
32. Apparatus in accordance with Claim 14 wherein said accounts receivables system is further configured to reverse previously completed cash payments and associated general ledger entries on-line and restore the customer account to the original balance.
33. Apparatus in accordance with Claim 14 wherein said accounts receivables system is further configured to allow off-setting of items within the customer account and perform on-line updating.
34. Apparatus in accordance with Claim 14 wherein said accounts receivables system is further configured to accept funds in foreign currency and translate them into the required local currency for reporting purposes.
35. Apparatus in accordance with Claim 14 wherein said account receivables system is further configured to access multiple accounts through at least one designated main account.
36. Apparatus in accordance with Claim 14 wherein said accounts receivables system is further configured to allow for selection of specific invoices in the customer account to be paid which will be formatted into an electronic bank file for funds transference.
PCT/IB2001/000847 2000-05-02 2001-04-30 Method and apparatus for managing remittance processing within account receivables WO2001084388A2 (en)

Priority Applications (5)

Application Number Priority Date Filing Date Title
AU2001252496A AU2001252496B2 (en) 2000-05-02 2001-04-30 Method and apparatus for managing remittance processing within account receivables
JP2001580738A JP2003532229A (en) 2000-05-02 2001-04-30 Method and apparatus for managing receivables remittance processing
MXPA02010676A MXPA02010676A (en) 2000-05-02 2001-04-30 Method and apparatus for managing remittance processing within account receivables.
CA002406641A CA2406641A1 (en) 2000-05-02 2001-04-30 Method and apparatus for managing remittance processing within account receivables
AU5249601A AU5249601A (en) 2000-05-02 2001-04-30 Method and apparatus for managing remittance processing within account receivables

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US09/563,633 2000-05-02
US09/563,633 US7194431B1 (en) 2000-05-02 2000-05-02 Method and apparatus for managing remittance processing within account receivables

Publications (1)

Publication Number Publication Date
WO2001084388A2 true WO2001084388A2 (en) 2001-11-08

Family

ID=24251298

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/IB2001/000847 WO2001084388A2 (en) 2000-05-02 2001-04-30 Method and apparatus for managing remittance processing within account receivables

Country Status (6)

Country Link
US (1) US7194431B1 (en)
JP (1) JP2003532229A (en)
AU (2) AU2001252496B2 (en)
CA (1) CA2406641A1 (en)
MX (1) MXPA02010676A (en)
WO (1) WO2001084388A2 (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US10540714B1 (en) * 2019-05-10 2020-01-21 Capital One Services, Llc Financial analysis in a computing environment

Families Citing this family (62)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8146807B2 (en) * 1998-03-05 2012-04-03 Cgi Technologies And Solutions Inc. Method and system for managing case based promises to pay
US8050975B2 (en) * 2003-10-06 2011-11-01 Bank Of America Corporation System and method to manage supply chain settlement, risk and liquidity
US20060224475A1 (en) * 2005-04-01 2006-10-05 Microsoft Corporation Method and system for defining data in a transaction
US8069070B2 (en) * 2005-10-14 2011-11-29 Accenture Global Services Limited Configuration extensions for a telecommunications service provider
US8380553B2 (en) * 2005-12-30 2013-02-19 Sap Ag Architectural design for plan-driven procurement application software
US8327319B2 (en) * 2005-12-30 2012-12-04 Sap Ag Software model process interaction
US8522194B2 (en) 2005-12-30 2013-08-27 Sap Ag Software modeling
US8407664B2 (en) 2005-12-30 2013-03-26 Sap Ag Software model business objects
US8370794B2 (en) * 2005-12-30 2013-02-05 Sap Ag Software model process component
US20070156550A1 (en) * 2005-12-30 2007-07-05 Der Emde Martin V Architectural design for cash and liquidity management application software
US8321831B2 (en) 2005-12-30 2012-11-27 Sap Ag Architectural design for internal projects application software
US8448137B2 (en) 2005-12-30 2013-05-21 Sap Ag Software model integration scenarios
US20070156500A1 (en) * 2005-12-30 2007-07-05 Wilfried Merkel Architectural design for sell from stock application software
US8676617B2 (en) * 2005-12-30 2014-03-18 Sap Ag Architectural design for self-service procurement application software
US8316344B2 (en) * 2005-12-30 2012-11-20 Sap Ag Software model deployment units
US8660904B2 (en) * 2005-12-30 2014-02-25 Sap Ag Architectural design for service request and order management application software
US8396731B2 (en) * 2005-12-30 2013-03-12 Sap Ag Architectural design for service procurement application software
US8402426B2 (en) * 2005-12-30 2013-03-19 Sap Ag Architectural design for make to stock application software
US8326703B2 (en) 2005-12-30 2012-12-04 Sap Ag Architectural design for product catalog management application software
US8046277B2 (en) * 2006-02-23 2011-10-25 Oracle International Corporation Methods and systems for managing reconciliation and write-off in an accrual accounting environment
US8442850B2 (en) * 2006-03-30 2013-05-14 Sap Ag Providing accounting software application as enterprise services
US8326702B2 (en) * 2006-03-30 2012-12-04 Sap Ag Providing supplier relationship management software application as enterprise services
US8438119B2 (en) 2006-03-30 2013-05-07 Sap Ag Foundation layer for services based enterprise software architecture
US8538864B2 (en) * 2006-03-30 2013-09-17 Sap Ag Providing payment software application as enterprise services
US8396761B2 (en) * 2006-03-30 2013-03-12 Sap Ag Providing product catalog software application as enterprise services
US8396749B2 (en) * 2006-03-30 2013-03-12 Sap Ag Providing customer relationship management application as enterprise services
US8321832B2 (en) 2006-03-31 2012-11-27 Sap Ag Composite application modeling
US8312416B2 (en) * 2006-04-13 2012-11-13 Sap Ag Software model business process variant types
US8671034B2 (en) * 2007-12-31 2014-03-11 Sap Ag Providing human capital management software application as enterprise services
US8447657B2 (en) * 2007-12-31 2013-05-21 Sap Ag Architectural design for service procurement application software
US20090171758A1 (en) * 2007-12-31 2009-07-02 Shai Alfandary Architectural design for physical inventory application software
US8671032B2 (en) * 2007-12-31 2014-03-11 Sap Ag Providing payment software application as enterprise services
US8315900B2 (en) * 2007-12-31 2012-11-20 Sap Ag Architectural design for self-service procurement application software
US8671033B2 (en) 2007-12-31 2014-03-11 Sap Ag Architectural design for personnel events application software
US8510143B2 (en) * 2007-12-31 2013-08-13 Sap Ag Architectural design for ad-hoc goods movement software
US8401936B2 (en) * 2007-12-31 2013-03-19 Sap Ag Architectural design for expense reimbursement application software
US10453043B2 (en) * 2008-06-25 2019-10-22 Thomson Reuters Global Resources Unlimited Company System and method for online bill payment
US9928379B1 (en) 2008-09-08 2018-03-27 Steven Miles Hoffer Methods using mediation software for rapid health care support over a secured wireless network; methods of composition; and computer program products therefor
US8818884B2 (en) * 2008-09-18 2014-08-26 Sap Ag Architectural design for customer returns handling application software
US8380549B2 (en) * 2008-09-18 2013-02-19 Sap Ag Architectural design for embedded support application software
US8326706B2 (en) * 2008-09-18 2012-12-04 Sap Ag Providing logistics execution application as enterprise services
US8374896B2 (en) 2008-09-18 2013-02-12 Sap Ag Architectural design for opportunity management application software
US20100082497A1 (en) * 2008-09-18 2010-04-01 Sap Ag Providing Foundation Application as Enterprise Services
US20100070395A1 (en) * 2008-09-18 2010-03-18 Andreas Elkeles Architectural design for payroll processing application software
US8321250B2 (en) * 2008-09-18 2012-11-27 Sap Ag Architectural design for sell from stock application software
US8401928B2 (en) 2008-09-18 2013-03-19 Sap Ag Providing supplier relationship management software application as enterprise services
US8352338B2 (en) * 2008-09-18 2013-01-08 Sap Ag Architectural design for time recording application software
US20100070336A1 (en) * 2008-09-18 2010-03-18 Sap Ag Providing Customer Relationship Management Application as Enterprise Services
US8595077B2 (en) * 2008-09-18 2013-11-26 Sap Ag Architectural design for service request and order management application software
US8386325B2 (en) * 2008-09-18 2013-02-26 Sap Ag Architectural design for plan-driven procurement application software
US8315926B2 (en) * 2008-09-18 2012-11-20 Sap Ag Architectural design for tax declaration application software
US8738476B2 (en) 2008-12-03 2014-05-27 Sap Ag Architectural design for selling standardized services application software
US8321308B2 (en) * 2008-12-03 2012-11-27 Sap Ag Architectural design for manual invoicing application software
US8401908B2 (en) * 2008-12-03 2013-03-19 Sap Ag Architectural design for make-to-specification application software
US8311904B2 (en) 2008-12-03 2012-11-13 Sap Ag Architectural design for intra-company stock transfer application software
US8321306B2 (en) 2008-12-03 2012-11-27 Sap Ag Architectural design for selling project-based services application software
US8671035B2 (en) * 2008-12-11 2014-03-11 Sap Ag Providing payroll software application as enterprise services
US20100153239A1 (en) * 2008-12-11 2010-06-17 Sap Ag Providing accounting software application as enterprise services
US8706615B2 (en) * 2009-12-04 2014-04-22 Robert A. Merkle Systems and methods for evaluating the ability of borrowers to repay loans
US20150019423A1 (en) * 2013-07-15 2015-01-15 Barry Dowling Transactional reconciliation system and method
US20210133732A1 (en) * 2019-11-01 2021-05-06 Walmart Apollo, Llc Systems and methods for guest payment
US11836793B2 (en) * 2020-12-11 2023-12-05 International Business Machines Corporation Invoice deferral recommendation

Family Cites Families (44)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US4913295A (en) 1985-04-08 1990-04-03 Banctec, Inc. Apparatus for processing remittance and remittance advice documents
US5099422A (en) * 1986-04-10 1992-03-24 Datavision Technologies Corporation (Formerly Excnet Corporation) Compiling system and method of producing individually customized recording media
US5121945A (en) 1988-04-20 1992-06-16 Remittance Technology Corporation Financial data processing system
US5390113A (en) * 1990-04-05 1995-02-14 Sampson; Wesley C. Method and electronic apparatus for performing bookkeeping
US5383113A (en) 1991-07-25 1995-01-17 Checkfree Corporation System and method for electronically providing customer services including payment of bills, financial analysis and loans
US5774882A (en) 1992-03-12 1998-06-30 Keen; Regina D. Credit approval system
US5326959A (en) 1992-08-04 1994-07-05 Perazza Justin J Automated customer initiated entry remittance processing system
EP0692119A1 (en) 1992-10-22 1996-01-17 American Express Travel Related Services Company, Inc. Automated billing consolidation system and method
JPH08500201A (en) * 1993-05-20 1996-01-09 ムーア.ビジネス.フォームス.インコーポレイテッド An integrated computer network that guides customer orders to various suppliers through a centralized computer
US5666493A (en) * 1993-08-24 1997-09-09 Lykes Bros., Inc. System for managing customer orders and method of implementation
KR100216363B1 (en) 1993-10-13 1999-08-16 윤종용 Credit query service system and method
US5611052A (en) 1993-11-01 1997-03-11 The Golden 1 Credit Union Lender direct credit evaluation and loan processing system
US5930776A (en) 1993-11-01 1999-07-27 The Golden 1 Credit Union Lender direct credit evaluation and loan processing system
US5465206B1 (en) * 1993-11-01 1998-04-21 Visa Int Service Ass Electronic bill pay system
US5920847A (en) * 1993-11-01 1999-07-06 Visa International Service Association Electronic bill pay system
US5550734A (en) 1993-12-23 1996-08-27 The Pharmacy Fund, Inc. Computerized healthcare accounts receivable purchasing collections securitization and management system
US5649117A (en) * 1994-06-03 1997-07-15 Midwest Payment Systems System and method for paying bills and other obligations including selective payor and payee controls
US6073104A (en) 1994-11-09 2000-06-06 Field; Richard G. System for invoice record management and asset-backed commercial paper program management
US5732400A (en) * 1995-01-04 1998-03-24 Citibank N.A. System and method for a risk-based purchase of goods
US5677955A (en) * 1995-04-07 1997-10-14 Financial Services Technology Consortium Electronic funds transfer instruments
US5832460A (en) * 1995-06-02 1998-11-03 International Business Machines Corporation Method and system for bill presentation and payment reconciliation
US5893080A (en) * 1995-07-25 1999-04-06 Bottomline Technologies, Inc. Disbursement system and method
US5852812A (en) * 1995-08-23 1998-12-22 Microsoft Corporation Billing system for a network
US5878403A (en) 1995-09-12 1999-03-02 Cmsi Computer implemented automated credit application analysis and decision routing system
US5829953A (en) 1996-01-19 1998-11-03 International Billing Services, Inc. Billing statement system
US5991733A (en) * 1996-03-22 1999-11-23 Hartford Fire Insurance Company Method and computerized system for managing insurance receivable accounts
US5787402A (en) * 1996-05-15 1998-07-28 Crossmar, Inc. Method and system for performing automated financial transactions involving foreign currencies
DE69739173D1 (en) * 1996-10-09 2009-01-29 Visa Int Service Ass ELECTRONIC SYSTEM FOR PRESENTING EXPLANATIONS
US6070150A (en) 1996-10-18 2000-05-30 Microsoft Corporation Electronic bill presentment and payment system
US5910896A (en) * 1996-11-12 1999-06-08 Hahn-Carlson; Dean W. Shipment transaction system and an arrangement thereof
US5909542A (en) * 1996-11-20 1999-06-01 Cfi Proservices, Inc. Distributed computing system for executing intercommunicating applications programs
US6684384B1 (en) * 1997-03-28 2004-01-27 International Business Machines Corporation Extensible object oriented framework for general ledger
US6041312A (en) * 1997-03-28 2000-03-21 International Business Machines Corporation Object oriented technology framework for accounts receivable and accounts payable
US6112190A (en) 1997-08-19 2000-08-29 Citibank, N.A. Method and system for commercial credit analysis
US5903878A (en) 1997-08-20 1999-05-11 Talati; Kirit K. Method and apparatus for electronic commerce
US6044362A (en) 1997-09-08 2000-03-28 Neely; R. Alan Electronic invoicing and payment system
US5999913A (en) * 1997-12-19 1999-12-07 Ncr Corporation Electronic price label system which displays prices in multiple currencies
US6052674A (en) * 1997-12-23 2000-04-18 Information Retrieval Consultants (Europe, Middle East, Africa ) Limited Electronic invoicing and collection system and method with charity donations
US6233565B1 (en) 1998-02-13 2001-05-15 Saranac Software, Inc. Methods and apparatus for internet based financial transactions with evidence of payment
US6532450B1 (en) * 1998-12-09 2003-03-11 American Management Systems, Inc. Financial management system including an offset payment process
US20020059139A1 (en) * 1999-03-12 2002-05-16 Scott Evans System and method for debt presentment and resolution
US20030208440A1 (en) * 2000-05-01 2003-11-06 Robert Harada International payment system and method
US6807533B1 (en) * 2000-05-02 2004-10-19 General Electric Canada Equipment Finance G.P. Web-based method and system for managing account receivables
US6847942B1 (en) * 2000-05-02 2005-01-25 General Electric Canada Equipment Finance G.P. Method and apparatus for managing credit inquiries within account receivables

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US10540714B1 (en) * 2019-05-10 2020-01-21 Capital One Services, Llc Financial analysis in a computing environment

Also Published As

Publication number Publication date
AU2001252496B2 (en) 2007-11-15
JP2003532229A (en) 2003-10-28
MXPA02010676A (en) 2004-05-17
AU5249601A (en) 2001-11-12
CA2406641A1 (en) 2001-11-08
AU2001252496B9 (en) 2001-11-12
US7194431B1 (en) 2007-03-20

Similar Documents

Publication Publication Date Title
US7194431B1 (en) Method and apparatus for managing remittance processing within account receivables
US6807533B1 (en) Web-based method and system for managing account receivables
US6847942B1 (en) Method and apparatus for managing credit inquiries within account receivables
US7249074B1 (en) Method, apparatus and computer program for managing accounting system interfaces
AU2001256600B2 (en) Method and apparatus for managing account receivables
AU2001252496A1 (en) Method and apparatus for managing remittance processing within account receivables
AU2001256575A1 (en) Method and apparatus for managing credit inquiries within account receivables
AU2001258683A1 (en) Method, apparatus and computer program for managing accounting system interfaces
US6873972B1 (en) Systems and methods for credit line monitoring
AU2001256600A1 (en) Method and apparatus for managing account receivables
US7418424B2 (en) Trade finance automation system
US5383113A (en) System and method for electronically providing customer services including payment of bills, financial analysis and loans
US20020152155A1 (en) Method for automated and integrated lending process
US20060136315A1 (en) Commissions and sales/MIS reporting method and system
AU2001252491A1 (en) Method and apparatus for managing accounts receivable claims
AU2001256603A1 (en) Web-based method and system for managing account receivables
AU2007237173A1 (en) Method and apparatus for managing accounts receivable claims

Legal Events

Date Code Title Description
AK Designated states

Kind code of ref document: A2

Designated state(s): AU CA JP MX

AL Designated countries for regional patents

Kind code of ref document: A2

Designated state(s): AT BE CH CY DE DK ES FI FR GB GR IE IT LU MC NL PT SE TR

121 Ep: the epo has been informed by wipo that ep was designated in this application
DFPE Request for preliminary examination filed prior to expiration of 19th month from priority date (pct application filed before 20040101)
WWE Wipo information: entry into national phase

Ref document number: 2001252496

Country of ref document: AU

WWE Wipo information: entry into national phase

Ref document number: 2406641

Country of ref document: CA

WWE Wipo information: entry into national phase

Ref document number: PA/a/2002/010676

Country of ref document: MX

122 Ep: pct application non-entry in european phase
ENP Entry into the national phase

Ref document number: 2001252496

Country of ref document: AU

Date of ref document: 20010430

Kind code of ref document: B