EP1704391A2 - Method and system for processing transactions - Google Patents
Method and system for processing transactionsInfo
- Publication number
- EP1704391A2 EP1704391A2 EP04815823A EP04815823A EP1704391A2 EP 1704391 A2 EP1704391 A2 EP 1704391A2 EP 04815823 A EP04815823 A EP 04815823A EP 04815823 A EP04815823 A EP 04815823A EP 1704391 A2 EP1704391 A2 EP 1704391A2
- Authority
- EP
- European Patent Office
- Prior art keywords
- data
- invoice
- purchase order
- company
- settlement
- Prior art date
- Legal status (The legal status 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 status listed.)
- Withdrawn
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION 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/00—Commerce
- G06Q30/06—Buying, selling or leasing transactions
- G06Q30/0601—Electronic shopping [e-shopping]
- G06Q30/0603—Catalogue ordering
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION 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/00—Administration; Management
- G06Q10/10—Office automation; Time management
Definitions
- the technology described herein relates to processing business transactions, and, more particularly, to a method and system for providing a single transaction point to process business transactions between multiple trading partners.
- a purchaser desires to buy products from another company, a supplier, an order is traditionally transmitted by the buying company to the selling company via a purchase order.
- the purchase order may be for a single product or for more than one product. If more than one product has been ordered, generally the purchase order will have a line item entry for each separate product. Often, a particular individual associated with the buying company, typically designated a "buyer,” is responsible for each particular purchase order. A company may have one or more such buyers.
- the selling company then fills the order and sends the product(s) to the buying company.
- the buying company generally notes the quantity of product received on the purchase order, creating a receipt document.
- the selling company After the selling company has shipped the product(s) to the buying company, the selling company generates and sends to the buying company an invoice for payment for the product(s).
- the invoice will have line item entries corresponding to those line item entries on the purchase order and receipt document.
- the invoice will have line item entries corresponding to the line items on more than one purchase order or receipt document.
- This invoice corresponds to a receivable asset of the selling company associated with the amount due from the buying company.
- the selling companies may also sell the receivable associated with the invoice to a third party, such as a bank or other receivables factoring party, based on a discount from the receivable amount. This allows the selling company to receive the cash before the invoice is paid to better manage the cash flow.
- a selling company's billing data is a component of a buying company's accounts payable data.
- a buying company's remittance data is a component of a selling company's accounts receivable data.
- a company may be a buying company for some products and a selling company for other products. For each buying company, there are many selling companies with which it is a trading partner. For each selling company, there are many buying companies with which it is a trading partner.
- the buying companies and the selling companies must each track their accounts payable and accounts receivable information for each of the companies with which they do business. This can be illustrated as in Figure 1 , representing the traditional interactions between businesses. Thousands of companies each perform billing, invoice matching, and reconciliation activities independently and redundantly, despite the fact that they are all using the same source data, namely, the data from the purchase orders and corresponding invoices and receipt documents. The results of these activities are then shared between these companies via remittances, short pays, claims, etc. This business process can create unnecessary administrative confusion and expense. Electronic billing, remittance, payment, and tracking technologies have generated limited savings because they have left the reconciliation environment within each individual company.
- one object of the present invention is to provide improved systems and methods for invoice and purchase order reconciliation. Another object of the present invention is to improve accuracy of transaction settlement post-audits. Another object of the present invention is to provide devices and methods for enabling both the buyer and seller to more quickly settle transactions and reduce problems that may typically be caught in a post audit. Another object of the present invention is to provide devices and methods to allow for transaction insight into the other trading parties business process, efficiencies, limitations, successes, etc thus creating a more accurate view of both parties efforts in the financial and physical supply chain. Yet another object of the present invention is to capture and link together in the system, all documents, memos, images, files, notes and correspondence related to the financial settlement of the transaction.
- Still a further object of the present invention is to provide methods to track and capture not only the original payment decision and/or deduction but also all dispute requests, supporting documentation and subsequent credits & debits until both parties are satisfied with the final settlement or recognize that any additional efforts will not affect the outcome. This information as it is brought into the system is then shared between both parties for a single source of data for the transaction. .
- a method is provided for processing transactions between at least one buying company and at least one selling company which results in the creation of a new collaborative data set. The method comprises of providing a central datastore accessible to users from the buying company and users from the selling company.
- Purchase order and invoice data are obtained and compared via a computer, to identify a matched record having purchase order data and corresponding invoice data.
- a collaborative data set in the central datastore is created, based in part on the matched record and storing in the datastore detailed settlement data regarding settlement of the matched record of purchase order data and corresponding invoice data.
- the method stores a complete settlement transaction history by providing for storage of additional settlement data in the central datastore, wherein credit memos, debit memos regarding the invoice, the purchase order of the matched record, and/or other documents related to the transaction are stored as part of the collaborative data set.
- a method is provided for processing transactions between at least one buying company and at least one selling company which results in the creation of a new collaborative data set.
- the method comprises providing a central datastore accessible to users from the buying company and users from the selling company; obtaining via a computer network purchase order data having at least one entry, the purchase order data including purchase order header information and purchase order detail information; obtaining via a computer network invoice data having at least one entry, the invoice data including invoice header information and invoice detail information; comparing via a computer, selected purchase order data and corresponding selected invoice data to identify a matched record having purchase order data and corresponding invoice data; creating a collaborative data set in the central datastore based in part on the matched record and storing in the datastore detailed settlement data regarding settlement of the matched record of purchase order data and corresponding invoice data; providing for storage of additional settlement data in the central datastore, wherein credit memos, debit memos regarding the invoice and/or the purchase order of the matched record are stored as part of the collaborative data set; if users from the buying company and/or selling company dispute settlement of the transaction, then: 1) providing for storage of settlement dispute data from the selling company which is stored as part of the collaborative data set; 2) providing for
- the method may further involve reconciling the transaction using the matched record and settlement dispute data stored in the datastore.
- the method may also include a transaction that is reconciled using only data and documents captured and stored in the datastore as part of the collaborative data set. Users from the buying company and selling company may view, reconcile, adjudicate and report on all financial transactions between the trading partners. Documents, memos, images, files, notes and correspondence related to the financial settlement of a transaction may be captured and linked together in the database.
- the database may include original payment decision and/or deduction but also all dispute requests, supporting documentation and subsequent credits & debits entered until both parties are satisfied with the final settlement. Information brought into the database may then be shared between both parties for a single source of data for the transaction.
- Embodiment of the present invention may allow the at least one buying company and the at least one selling company access to selected data in the database comprises providing a web page accessible by the buying company and a web page accessible by the selling company via a global computer network.
- the purchase order header information may comprise of a purchase order number, a client identification, a vendor identification, and a purchase order date.
- the purchase order detail information may comprise of the purchase order header information, a quantity ordered for each purchase order entry, an item identification for each purchase order entry, a unit price for each purchase order entry, and a charge code for each purchase order entry.
- the invoice header information may comprise of an invoice number, a client identification, a vendor identification, and an invoice date.
- the invoice detail information may comprise of the invoice header information; a quantity shipped for each invoice entry; an item identification for each invoice entry; and an extended price for each invoice entry.
- the step of obtaining purchase order data comprises obtaining the purchase order data in electronic format.
- the step of obtaining purchase order data may further comprise of obtaining the purchase order data via a global computer network.
- the step of obtaining invoice data comprises obtaining the invoice data in electronic format.
- the step of obtaining invoice data may further comprises obtaining the invoice data via a global computer network.
- the step of obtaining purchase order data may comprise of obtaining the purchase order data in paper format.
- the method may further comprise of the step of converting the purchase order data to electronic format.
- the step of obtaining invoice data comprise of obtaining the invoice data in paper format.
- the method may further comprise of the step of converting the invoice data to electronic format.
- the steps may be conducted by a party other than the buying company or the selling company.
- the method may comprise of the step of automatically comparing selected purchase order data and corresponding selected invoice data comprises performing an automated comparison using a computer.
- the method may comprise of using a single platform provided for handling all transaction for trade settlement.
- a method is provided for tracking transaction settlement between at least one buying company and at least one selling company.
- the method comprises providing a central datastore accessible to users from the buying company and users from the selling company; obtaining via a computer network purchase order data having at least one entry, the purchase order data including purchase order header information and purchase order detail information; obtaining via a computer network invoice data having at least one entry, the invoice data including invoice header information and invoice detail information; comparing via a computer selected purchase order data and corresponding selected invoice data to identify a matched record having purchase order data and corresponding invoice data; creating a collaborative data set in the central datastore based in part on the matched record and any subsequent settlement history; capturing post-match, settlement history by storing all additional settlement data to be used to as part of the same collaborative data set in the central datastore, wherein at least one of the following is stored: credit memos, debit memos regarding the invoice and/or the purchase order of the matched record, settlement dispute data from the selling company, supporting images and documentation from the selling company, settlement dispute data from the buying company, supporting images and documentation from the buying company.
- users from the buying company and users from the selling company may access the collaborative data set to reconcile the transaction using the matched record settlement transaction history and supporting documentation stored in the datastore.
- the transaction is reconciled using only data and documents captured and stored in the datastore as part of the collaborative data set.
- Users from the buying company may view additional settlement data and documents added into the collaborative data set by the selling company and vice versa.
- users from the buying company may review additional settlement data added by users from the selling company; and users from the selling company reviewing additional settlement data added by users from the buying company. This is an iterative process and the reviewing steps may be repeated between the buying company and selling company until a final settlement is reached or agreed upon.
- an electronic transaction processing system including a computer network, a processing unit, and at least one data storage unit, for performing steps comprising: providing a central datastore accessible to users from a buying company and users from a selling company; obtaining via the computer network purchase order data having at least one entry, the purchase order data including purchase order header information and purchase order detail information; obtaining via the computer network invoice data having at least one entry, the invoice data including invoice header information and invoice detail information; comparing via a computer selected purchase order data and corresponding selected invoice data to identify a matched record having purchase order data and corresponding invoice data; creating a collaborative data set in the central datastore based in part on the matched record and any subsequent settlement history; capturing post-match, settlement history by storing all additional settlement data to be used to as part of the same collaborative data set in the central datastore, wherein at least one of the following is stored: credit memos, debit memos regarding the invoice and/or the purchase order of the matched record, settlement dispute data from the selling company, supporting images and documentation
- a method for processing transactions.
- the method comprises receiving invoice data and receipt data for a plurality of transactions and storing the data in a system database; segmenting the invoice and receipt data into a plurality of segments using one or more user defined segmenting parameters, each segment including a portion of the received invoice data and receipt data based upon the user defined segmenting parameters; for each of the segments, automatically matching the portion of the received invoice data and receipt data within the segment according to a predefined match strategy comprising a plurality of matching rules; and for each invoice and receipt that are matched in the automatic matching step, assigning a unique match identifier to the invoice and receipt and storing the invoice and receipt along with the match identifier in the system database.
- a graphic user interface for transaction matching.
- the user interface comprises a screen presenting the user with: a first portion showing invoice and purchase order match information; a second portion listing invoice line items; a third portion listing receipt of goods line items, wherein the second portion and third portion are aligned horizontally so that the line items will also align in a horizontal manner to facilitate comparison.
- the user interface may also include a fourth portion listing debit memos and credit memos.
- FIG. 1 is a schematic representation of traditional prior art transaction management system
- Fig. 2 is a schematic representation of an example transaction management system in accordance with the present invention
- Fig. 3 is a flow diagram of the input data flow of the example system of Fig. 2
- Fig. 4 is a flow diagram of an example charge code verification process of the example system of Fig. 2
- Fig. 5 is a flow diagram of an example matching process of the system of Fig. 2
- Fig. 6 is a schematic representation of an example matching logic process of the system of Fig. 2
- Fig. 7 is a flow diagram of an example resolution process of the system of Fig. 2
- Fig. 1 is a schematic representation of traditional prior art transaction management system
- Fig. 2 is a schematic representation of an example transaction management system in accordance with the present invention
- Fig. 3 is a flow diagram of the input data flow of the example system of Fig. 2
- Fig. 4 is a flow diagram of an example charge code verification process of the example system of
- FIG. 8 is a flow diagram of an example cash management process of the system of Fig. 2;
- Fig. 9 is a schematic representation of an example supplier access process of the system of Fig. 2;
- Fig. 10 is a block diagram of an example distributed transaction management system;
- Fig. 11 is a flow diagram of an example transaction matching process in which invoices and receipts are segmented into a hierarchy of pools prior to automated and manual matching;
- Fig. 12 is a flow diagram of an example automated matching process providing N- dimensional matching of invoices and receipts;
- Fig. 13 is a flow diagram of an example manual reconciliation process providing numerous matching tools for matching invoices and receipts;
- Fig. 14 is a line match screen interface operable by a user of the system in order to manually reconcile invoices and receipts at the line level;
- Fig. 15A is a view match screen interface operable by a user of the system in order to view the details of a matching process executed by the system;
- Fig. 15B is a view match notes screen interface operable by a user of the system in order to identify and view notes associated with a particular match;
- Fig. 16 is a notes interface screen operable by a user of the system in order to apply a textual note to a particular transaction document;
- Fig. 17 is a reconciliation queue interface screen operable by a user of the system in order to begin the manual reconciliation process described in Fig. 13;
- Fig. 15A is a view match screen interface operable by a user of the system in order to view the details of a matching process executed by the system;
- Fig. 15B is a view match notes screen interface operable by a user of the system in order to identify
- Fig. 18 is a header match screen interface operable by a user of the system in order to manually reconcile invoices and receipts at the header level;
- Fig. 19 is an exemplary process flow diagram for researching a particular match and viewing the match using the view match screen interface;
- Fig. 20 is a document research queue interface screen;
- Fig. 21 is a view document screen interface;
- Fig. 22 is another example view match screen interface.
- Fig. 23 is a block diagram showing the creation of an new data set according to the present invention.
- Fig. 24 is a block diagram showing the invoice statuses.
- Fig. 25 is a block diagram showing the line level coding and handling of discrepancies and claims.
- Fig. 26 is a block diagram showing the comparison of charges and allowances according to the present invention.
- Optional or “optionally” means that the subsequently described circumstance may or may not occur, so that the description includes instances where the circumstance occurs and instances where it does not.
- a device optionally contains a feature for having a cassette loader, this means that the cassette loader feature may or may not be present, and, thus, the description includes structures wherein a device possesses the cassette loader feature and structures wherein the cassette loader feature is not present.
- a “server” in a hardware configuration may be a computer such as a personal computer (PC) or other intelligent device.
- a server typically performs the bulk of the centralized or generalized tasks in the network and often has more memory, processing speed, and storage than the other device on the client-server network. Alternatively, the server may perform specialized tasks such as but not limited to, distributing electronic mail, data storage or printing.
- a "server” typically is a program that provides data, stores data, or provides some service to other programs to lo which the server is connected.
- a server may be a program with higher priority, greater memory, or greater capabilities compared to the other programs connected through the network.
- a server also may be a program that includes specialized capabilities or has higher priority with respect to certain tasks or functions.
- a "client” in the software arrangement is generally a program used by a user.
- a client program typically makes use of data, processing, storage, or other resources of another program.
- a client may be used to communicate with a source or destination through a higher priority, more powerful, more capable or different program.
- the client may run on a computer such as but not limited to, a personal computer (PC), intelligent device, personal digital assistant (PDA) or workstation used by a user.
- PC personal computer
- PDA personal digital assistant
- the client may carryout tasks in the process of which the client may request information or otherwise may use the resources of another object such as the server or another client to accomplish such tasks.
- Figure 1 schematically illustrates the traditional prior art approach to management of financial and accounting transactions between trading partners, including buying companies 11 and selling companies 13.
- buying companies 11 and selling companies 13 include individuals, sole proprietorships, partnerships, limited liability companies, corporations, and any other business or non-business entities engaged in the buying and selling of products that may be included in purchase orders and/or invoices.
- products includes raw materials, finished products, services, and/or any other item that may be included in purchase orders, invoices, or other billing arrangements.
- Figure 1 shows that individual buying companies 11 and selling companies 13 internally manage the financial and accounting data related to their trading partners. This leads to inefficiencies and other difficulties as described above.
- FIG 2 presents a schematic representation of an example transaction management system in accordance with the present invention in which a single interactive platform 15 is provided for both buying companies 11 and selling companies 13 to utilize as a single transaction point to manage financial and accounting transactions with their trading partners.
- Platform 15 may be operated by a third party and may be accessible by all parties via a computer network.
- this computer network is a global computer network, and most preferably the computer network is the internet.
- Both buying companies 11 and selling companies 13 provide their purchase order data, receipt data, and invoice data to the interactive platform 15, where the data is managed, discrepancies resolved, payments provided for, and records kept.
- the trading partners complete transactions and communicate with each other via the interactive platform 15. Reports relating to transactions, financial data, and other accounting data are available via the interactive platform 15.
- the interactive platform 15 provides a unique method and system for a third party to manage all of the accounts payable and accounts receivable for buying companies 11 and selling companies 13. Further, interactive platform 15 may provide for centralized payment schemes, as authorized by buying companies 11, and can conduct all of the account payable operations currently processed within the buying company 11. Likewise, the interactive platform 15 can conduct all of the account receivable operations currently processed within the selling company 13. The interactive platform 15 conducts these accounts receivable and accounts payable operations utilizing identical data from a single database. Interactive platform 15 may also provide for management of transactions between buying companies 11 or selling companies 13 with a trading partner that does not provide corresponding accounting information to the interactive platform 15.
- a buying company 11 purchases goods from a trading partner that does not provide invoice data to the interactive platform 15, the input of purchase order information, receipt information, and invoice information may still occur via the buying company 11, and the buying company 11 will still enjoy the advantages of using the interactive platform 15. Also, the buying company 11 may direct the selling company 13 to send all invoices to the interactive platform 15 as part of the billing arrangements with that selling company 13. However, the trading partner that does, not provide information to the interactive platform 15 may not have access to the data in the interactive platform 15 or the advantages of its use.
- the interactive platform 15 is not limited to traditional goods-oriented transactions, but is also applicable to exchanges of services, routine payments, or any other payable or receiving function traditionally performed by an accounting department.
- the interactive platform 15 may be utilized to provide for payment of regular utility bills.
- a rule or other operating parameter may be established for a buying company 11 that an electric bill within a predetermined range is authorized for payment.
- the selling company 13, which happens to be an electric utility then provides the payment due information to the interactive platform 15, and payment is automatically provided for if the amount is within the authorized predetermined range. Any amounts outside the predetermined range would trigger a resolution process similar to that described below in relation to Figure 7.
- the buying company 11 may access the interactive platform 15 at any time for reports regarding the payments of electric utility bills to that selling company 13, and the selling company 13 may access the interactive platform 15 at any time for reports regarding the payments made to it by that buying company 11 or any other buying company 11.
- FIG. 3 is a flow diagram of the input data flow of the example system of Figure 2.
- Accounting data for the method of the present invention may be obtained in either paper format, such as paper purchase orders 12, paper invoices 14, or paper receiving document 16, or in electronic format, such as electronic data interface ("EDI")/Web purchase orders 18, EDI/Web invoices 20, or EDI/Web receiving documents 22.
- EDI electronic data interface
- the paper documents 12, 14, and 16 may be received via paper delivery service (e.g., U.S. mail) or via facsimile transmission, etc.
- the next step is to determine whether the paper is received via mail or facsimile transmission, as indicated by step 24. If the paper documents are received via fax, then the images will be sent to a fax pool 26, and into a staging image database 28. If the paper documents 12, 14, and 16 are received via paper delivery service, then the documents are scanned in step 30, using conventional scanning techniques. After the paper documents 12, 14, and 16 are scanned, the images resulting from the scan are provided to the staging image database 28.
- the hard paper copies are placed in storage 32.
- the paper may be stored for any amount of time, preferably 90 days.
- the images of the paper documents 12, 14, and 16 are stored in the staging image database 28, they are then provided to the data entry step 34 in which the images are translated into an electronic format that is suitable for further processing.
- the data is evaluated and validated in step 36 to identify data that may be missing, incorrectly input, etc. If the data validation step 36 identifies any problems, then the document 0is provided to the data adjudication center 38 for resolution of any problems.
- the data adjudication center 38 may provide for contact with the provider of the information for correction of that information.
- Such contact may be conducted as part of the workflow resolution 60 process described in Figure 7, or may be separate from that process.
- the electronic data 18, 20, and 22 also undergoes the data validation step 36 and is provided to the data adjudication center 38 for resolution of any problems with that data.
- the images of the documents will be stored in the image database 40. Specific data from the images will be loaded into the header tables 42 and/or the detail tables 44.
- header table 42 data may include a purchase order number, a client number or other identification, a vendor number or other identification, a buyer number or other identification, a purchase order date, and/or an order date.
- header table 42 data may include an invoice number, a purchase order number, a client number or other identification, a vendor number or other identification, a buyer number or other identification, an invoice date, and/or an order date.
- the invoice documents 14, 20 also have an invoice total cost, which is the total cost or price of the product(s) shipped to the buying company 11 from the selling company 13.
- detail table 44 data may include the purchase order header information and detailed entry information by line of the purchase order including an item number or other identification, a quantity ordered of that item, a cost per item unit, an extended price for that item, a charge code for that item, and a quantity received for that item.
- invoice documents 14, 20 detail table 44 data may include the invoice header information and detailed entry information for each line of the invoice, including an item number or other identification, a quantity of the item shipped, a unit cost or price for the item, and an extended cost or price for the item. Likewise, if freight charges, insurance charges, etc., are included as separate items, then these could also be included as separate line items.
- Receiving documents 16, 22 provide receipt data corresponding to the product(s) actually received by the buying company 11, on an item-by-item basis. This information is provided by the buying company 11 and is combined with information from the purchase order to determine the total cost of goods received, which is the cost or price of the product(s) ordered that were actually received by the buying company 11.
- the total cost of goods received may be included in the purchase order header information 42a.
- the quantity of items received and the cost of individual items received may be included in the purchase order detail information 44a.
- the data from the header tables 42 is provided to begin the exemplary matching flow process described in Figure 5.
- the data from the detail tables 44 undergoes general ledger ("GL") charge code verification, in which the detailed codes set forth in the data of the detail tables 44, generally obtained from the purchase order, are compared to predetermined GL charge codes provided by the originator of the data.
- Figure 4 is a flow diagram of an example charge code verification process of the example system of Fig. 2.
- the data from the detail tables 44a relating to purchase order 12, 18 information is compared to charge codes 46 that are provided by the originator of the purchase orders 12, 18.
- the comparison of the charge codes from the purchase order detail table 44a and the charge codes 46 occur on a line-by-line basis to ensure that the codes contained in the detail table 44a are valid codes.
- This step occurs as charge code verification step 48. If the codes from the detail table 44a match the charge codes 46, then the update of the codes is ended at step 50. If the charge code verification step 48 indicates that the charge code from the detail table 44a does not have a corresponding authorized code from charge codes 46, then suspense charge codes will be assigned to the items corresponding to the non-matching charge codes in step 52.
- a suspense charge code is an accounting placekeeper pending resolution of the correct charge code. The suspense charge code and the original charge code will then be associated with that particular item on the particular line in question.
- step 54 queries the detail table 44a to determine if there was a buyer associated with the purchase order. If there is a buyer identified, then the buyer workflow resolution will be initiated in step 60b. In this step, the individual buyer associated with the purchase order in question is contacted (through the internet, web site, etc.) to resolve the discrepancies between the authorized charge codes from the charge code database 46 and the charge codes from the detail tables 44a. If there is no buyer identified in the data from the detail tables 44a, then it is determined whether there is a default buyer for the vendor identified on the purchase order in step 58. This is determined by comparing the vendor from the data in the detail tables 44a with a predetermined list (not shown) of default buyers for vendors obtained from the originator of the purchase order 12, 18.
- FIG. 5 is a flow diagram of an example matching process of the system of Figure 2.
- Purchase order header information 42a is obtained from the header tables 42 and compared against invoice header information 42b obtained from the header tables 42. Corresponding purchase orders and invoices are selected based upon matching identified information, such as purchase order number, client number, and vendor number.
- the total cost of goods received and invoice total cost are compared in step 62 to determine if the total cost matches within a predetermined tolerance level.
- This tolerance level may be based on a dollar amount, percentage of total cost, or other criteria. If the total costs match within the tolerance, then whatever difference between the total costs are coded to a balancing account 64 and the invoice is then processed to the payment queue 66. Whether the total costs match or not, the costs and matching status information is provided to the statistics area 70 for tracking and further compilation.
- the statistics area 70 may also be used to create a digital audit trail, in which transactions, resolutions of discrepancies, and access to the system by particular individuals may be tracked.
- step 68 If the total costs do not match, then the detail tables 44 corresponding to the purchase order and invoice are checked to see if detailed information regarding each line item on the purchase orders or invoices is available, as identified in step 68. Whether the total costs match or not, that information is provided to the statistics area 70 for tracking and further compilation. If the detail required is not available, then step 69 illustrates that the appropriate detail is obtained. This may be accomplished by obtaining the data from the image database 40, or accessing the data adjudication center 38 to have the appropriate data input. Whether the detailed information is available and the method of obtaining the detailed information are supplied to the statistics area 70. In step 72, it is determined whether there are multiple invoices or purchase orders having matches with header information.
- a single invoice may correspond to more than one purchase order, or the products from a single purchase order may have been shipped under different invoices. If there are multiple invoices and/or purchase orders, then the detail information regarding individual line items are compared for matching in step 74. If there are individual line item matches between the purchase orders, including receipt data, and the invoices, then those may be provided to the payment queue 66. If the line items of the associated purchase orders with receipt data and invoices do not match, then the unmatched line items are identified for further processing. All of this information is also provided to the statistics area 70. Whether there may be multiple invoices for a particular purchase order is a set-up rule that may be selected by the customer.
- a customer does not choose to allow multiple invoices per purchase order and a purchase order has more than one invoice matching the header information, this matter is forwarded to the workflow resolution process 60. If a customer does accept multiple invoices per purchase order, and the line item match 74 indicates that there is not a match for a particular purchase order line item because the corresponding invoice(s) has a lesser quantity than the purchase order or receipt data for that line item, then the line item is split in step 71 to become two line items — one with the quantity that is on the invoice or that was received and one line item with the remainder of the quantity that can be the subject of a different invoice or receiving document for the remaining quantity or part thereof.
- the purchase orders with receipt data and invoices are compared with predetermined selections from the customer regarding the rules by which to pay the invoices in step 75. If there is not a preselected rule by which to pay the invoice associated with the purchase order or the split line items, then the line items from the detail tables 44 of the purchase order with receipt data are compared to those from the invoice to determine if there is a match 74. If there is a line item match (e.g., the item number, quantity, extended price matches between the purchase order and invoice), then the line item may be forwarded to the payment queue 66.
- a line item match e.g., the item number, quantity, extended price matches between the purchase order and invoice
- step 73 For line items that do not have corresponding matches between the purchase order with receipt data and the invoice, these issues are identified in step 73 and may be provided to the workflow resolution 60 for resolution. If the customer has allowed multiple invoices per purchase order, then the unmatched line items may be placed on hold for a period of time pending separate invoices. This period of time may also be selected by the customer, and may be of any duration. Preferably, this period of time does not extend past 30 days, beyond which the customer may be contacted through the workflow resolution 60. There may also be a provision for items that have been placed on back-order status, such that a separate period of time is specified before the issue is provided to the workflow resolution 60. Data regarding line item matches and discrepancies are also provided to the statistics area 70.
- step 76 queries whether the invoice or associated line item has been paid. If the invoice or associated line item has not been paid, then the information is provided to the payment queue 66. If the invoice has been paid, then a credit or a debit memo is generated in step 80 and provided to the payment queue 66. . If the invoice or line item is to be paid according to a rule, as identified in step 75, then the rule is applied to the matches in step 78 and the results are provided to the payment queue 66.
- One such rule that may be used is the "pay lower of the two rule.” This is a set of rules that evaluates the invoice line item and the purchase order line item and compares extended price.
- This rule allows for the lower price between the two items to be paid for the quantity of items received, or the lowest quantity of the two line items is selected and an extended price is calculated based upon a predetermined formula. It will be readily apparent to one of ordinary skill in the art that there are many rules-based alternatives for resolving how an invoice or line items upon an invoice should be paid. A rules-based payment scheme may also be applied with multiple invoices and purchase orders. The information from the payment queue 66 is provided to an accounts payable database 82, from which the payment process 84 is initiated. Differences between the amount invoiced and the amount paid are provided to the balancing account 64. The payment process 84 may be entirely controlled and contained by the originator of the purchase orders and outside the system of Figure 2.
- the information from the accounts payable database 82 may also be used in the process of factoring, described above, to create an improved process termed "approval factoring.”
- Factoring which is the selling of the receivable asset associated with amounts due to the selling company, is done at the time of the match (or approval for payment, discussed below) between the purchase order and receiving information or data with the invoice information or data, instead of the traditional method of selling the receivable at the time of invoice. This allows the factoring to occur based on a matched amount due.
- the risk to the third party associated with the receivable asset is minimized, because the matching or approval for payment has already occurred and any discrepancies have already been resolved, or at least identified.
- the discount from the face value of the receivable may be reduced and the selling company will pay less of a fee to better manage its cash flow by receiving the cash flow at known dates with minimal delay.
- the factored amount may be based on the amount actually scheduled to be paid, instead of the invoice amount, and allows for factoring over multiple invoices having only partial matches. Thus, factoring may be done for individual line items from several invoices, instead of for an entire invoice, as is traditionally done.
- the third party may be the party implementing the transaction processing system or may be one or more other parties, such as a bank or other receivables factoring party.
- Figure 6 is a schematic representation of an example matching logic process of the system of Figure 2.
- the information from purchase order header table 42a and invoice header table 42b are compared to see if there is a high level match 86 between this information.
- the header information compared is the purchase invoice number, the total cost of goods received, the total cost of products shipped, the client number or other identification, and the vendor number or other identification.
- the tolerances from tolerance consideration table 88 are to be factored in.
- the data in tolerance consideration table 88 is predetermined data and may be different depending upon the client or vendor. This data may be modified. If there is a match of the header information within the tolerance, then payment data is generated in step 90.
- the payment data is generated by accessing or retrieving the purchase order detail table 44a information for the corresponding purchase order header table 42a information. Then this information is provided to the payment queue 66, the accounts payable database 82, and on to the payment process 84. Data may be provided to the balancing account 64, for example, if there are minor discrepancies between the total cost of goods received and the invoice total cost. If the purchase order header table 42a information and the invoice header table 42b information do not match in the high level match 86 step, particularly relating to the comparison of the total cost of goods received and the invoice total cost, then the line item match step 74 occurs comparing the purchase order detail table 44a information with the invoice detail table 44b information.
- this information may include purchase order number, client number, vendor number, by line quantities (shipped and received), by line item numbers, and by line cost per unit. If individual line items match, or if a rules-based scheme is employed to resolve differences between line items, then resolution step 92 will provide the information to the payment queue 66. If there is no match and no rules-based scheme to resolve the discrepancies, then the matter is referred to the workflow resolution 60, as illustrated in Figure 7. Once the issue is resolved, then a determination is made whether the invoice has been paid in step 76. If the invoice has not been paid, then the information is provided to the payment queue 66. If the invoice has been paid, then a credit or debit memo is generated in step 80 and provided to the accounts payable database 82.
- Figure 7 is a flow diagram of an example resolution process of the system of Figure 2. This process is utilized to resolve any discrepancies identified during the previous processes. If there. are issues from the charge code verification process illustrated in Figure 4 that require administrative workflow resolution 60a or buyer workflow resolution 60b, collectively referred to as charge code issues 56, or if there are issues from the matching flow process illustrated in Figure 5 and identified at step 73, then those issues are identified to the client by email notification 94, for example.
- the email notification 94 may include statistical information on the status of the charge code issues 56 or matching issues 73 and may identify the role 96 of the issues as either administrative issues 60a or buyer issues 60b. If the issue is an administrative issue, the email notification 94 may direct the client to the administrative homepage 98 on the World Wide Web 100, for example.
- the administrative homepage 98 may be of any format suitable for performing the functions described herein.
- Two of the screens available for access from the administrative homepage 98 are the administrative charge code resolution screen 102 and the administrative matching resolution screen 104.
- the administrative charge code resolution screen 102 any of the charge code issues 56 that have been identified may be resolved.
- the administrative matching resolution screen 104 any of the matching issues 73 may be resolved. If the email notification 94 identifies that the issues to be resolved are associated with a particular buyer, then the email notification 94 may direct the client to a buyer homepage 106, accessible via the World Wide Web 100.
- the buyer homepage 106 may be accessed through any of a variety of computer networks.
- Two of the screens available from buyer homepage 106 include the buyer charge code resolution screen 108 and the buyer matching resolution screen 110.
- charge code resolution screen 108 charge code issues 56 associated with that buyer may be resolved.
- buyer matching resolution screen 110 matching issues 73 associated with that buyer may be resolved.
- buyer homepages 106 There may be many different buyer homepages 106, depending upon the number of buyers associated with that particular client.
- Each of the buyer charge code resolution screens 108 and buyer matching resolution screens 110 may also be accessed from the administrative homepage 98 for that client, if such authorization is desired by the client.
- the next step, identified as 112 on Figure 7, is to determine if payment has been made for the particular item for which there was a charge code issue 56. If payment has been made, then the records associated with the charge code issue are updated in step 114. If the payment has not been made, however, then the records associated with the charge code issue 56 are amended and the proper detail table 42, 44 is amended in step 116. After the records have been updated or amended, the data is provided to an audit file 118 to document the update of the codes in the records. The information is then passed to the payment queue 66 and subsequently to the accounts payable database 82.
- step 112. the next step is to determine whether payment has been made in step 112. Concurrently, remittance file 120 is updated with information such as the buyer who resolved the issue, the date, the changes that have been made, etc. If payment has been made, then a credit/debit memo 80 is generated and forwarded to the payment queue 66 that then loads the information to the accounts payable database 82. If payment has not been made, then the audit file 118 is updated documenting the changes and updates that have been made. The record is then forwarded to the payment queue 66 and on to the accounts payable database 82.
- the system and method of the present invention may also provide for tracking of the history of the workflow resolution process, including who accessed or participated in the resolution, the dates and times such access occurred, and the messages exchanged or provided to the system. This may be advantageous in the event that disagreements arise over the resolution, future similar discrepancies are identified, or the individuals involved need to be contacted.
- This information may be tracked in the statistics area 70, by a separate database, by the web site software associated with the administrative homepage 98, the buyer homepages 106, or the supplier homepage 144, or may be tracked in any other suitable manner.
- Figure 8 is a flow diagram of an example cash management process of the system of Figure 2.
- an appropriate notification is provided to the client alerting the client that the payment is due.
- a notification may be via e-mail as in step 122, and may be to the accounts payable manager of the client.
- the primary purpose of the notification is to alert that a payment is due within the predetermined amount of time.
- the accounts payable manager can then access the system, such as through the World Wide Web 100, and access the accounts payable manager module or homepage 124. Within the accounts payable manager module or homepage 124, the manager would be able to look at the individual records for which notification has been sent and decide whether the payment date in the records should be modified, as identified in step 126.
- step 128 the payment is rescheduled in step 128 and the item returned to the accounts payable database system 82.
- a notification is sent to the manager of the cash that will be made available for payment. This may take the form of an e-mail notification, as noted in step 130. The notification will request transfer of full funds necessary for the particular payment. The funds are then transferred in step 132 to an account from which the payment will be made. Then a check in step 134 will be made to verify that sufficient funds are available in the account to make the appropriate payments. If there are not appropriate funds in the account, then payment is not made and the client is contacted in step 136 to resolve the discrepancy.
- FIG. 9 is a schematic representation of an example supplier access process of the system of Figure 2.
- the accounts receivable or sales personnel 142 from the supplier will access the interactive platform through a supplier homepage 144.
- the access will be via the World Wide Web 100, but any suitable network may be used for access, including LAN, WAN, or other networks.
- the supplier personnel may access information regarding payment research 146, cash flow 148, or adjudication 150.
- the personnel 142 may enter a search term, such as a purchase order number or invoice number, to identify a record corresponding to the particular data input.
- step 152 From there they may see payment detail information, including whether payment has been authorized, when payment was sent, etc. This is illustrated on Figure 9 by step 152.
- the personnel 142 may see what daily payments 154 have been made or are to be made to the supplier and may see further remittance information 156 regarding the cash flow to the supplier.
- the supplier personnel 142 may see all of the adjudication items 158 relating to that supplier, including the particular issue and the detailed information for both the purchase order side and the invoice side.
- the supplier personnel 142 may have the ability to resolve the issue, but the ability is preferably limited to choosing only a lower quantity or a lower price for the item in adjudication.
- the supplier may elect to not hold up the payment merely because of such a minor discrepancy. A higher quantity or a higher price may not be chosen by the supplier at this point. If the item is adjudicated by the supplier through the adjudication access 150, then this is removed from the client resolution workflow illustrated in Figure 7, and immediately sent to the payment queue 66 for payment. From the supplier homepage 144, the information supplied comes from the accounts payable database 82 and/or the document image database 40. At any time, the supplier personnel 142 may review the image of the invoice or of any receiving documents that have been entered into the document image database 40.
- the supplier access and supplier homepage 144 may be of any format and is customizable to meet the needs of the supplier.
- Fig. 10 is a block diagram of an example distributed transaction management system 180.
- the system 180 is distributed in the sense that the system software components are not located in one system, but instead are distributed among a variety of systems.
- the system includes a central data center trading engine 182, or hub, and a plurality of trading modules and adapters that link a plurality of customer sites (spokes) 184, 186, 188, 190 to the central data center trading engine 182.
- spokes customer sites
- Two different types of customer installations are shown in Figure 10, an enterprise installation and a hosted installation.
- the system's collaborative back office (CBO) software (described in more detail below) is located at the same location as the buyer (or seller's) enterprise system.
- the CBO software is hosted by an application service provider, for example, and is located at a different location from the buyer (or seller's) enterprise system.
- the CBO software (and all other modules and adapters) are located behind the corporate firewall that controls network connectivity between the enterprise system and the data center 182.
- the CBO software and several other modules are not located behind the corporate firewall.
- the central data center 182 is preferably coupled to the buyer and seller systems via a wide area network, such as the Internet. Other network connections are also possible, such as virtual private networks, etc.
- the trading modules and adapters include a trade integration module 192, a customer adapter module 194 and a system adapter module 196 located at each customer site.
- 184, 188 all of these modules are located at the same location as the CBO software and the buyer (or seller) enterprise systems.
- the trade integration module 192 and the customer adapter 194 are located at an ASP site, and the system adapter 196 is located at the site of the customer's enterprise system.
- the collaborative back office (CBO) software is provided in both a buyer version and a seller version. Certain functionality provided by the buyer system is preferably not provided in the seller system, although in alternative embodiments these software systems could be identical.
- the buyer CBO software For the buyer CBO software, the following functions are preferably provided: sorting and matching trade data; automatic and manual matching of trade data; data reconciliation; online collaboration with supplier(s) to speed up dispute resolution, data viewing and editing; etc. These functions are further described below with reference to Figures 11-22, which describe an exemplary process for automated and manual matching and reconciliation of trade data and a corresponding interface for use by both buyers and sellers for viewing, resolving and collaborating on trade matters.
- the seller CBO software module (as shown in 188 and 190) provides a different set of features from the buyer CBO software module. Preferably, these features include: reviewing invoice status (online) prior to payment; viewing detailed deduction notification data from a buyer system; reconciliation of invoice deductions; tools for building deduction dispute forms; etc.
- the CBO systems at each buyer and seller site interface with the buyer (seller) enterprise system (via the customer adapter 194 and the system adapter 196) and the central trade engine 182 via the trade integration module 192.
- the central trade engine 182 provides message validation between the systems, data conversion, routing, and reporting functions between the various trading partners. Although just two buyer systems 184, 186 and two seller systems 188, 190 are shown in Figure 10, the system 180 is scalable to include any number of buyers and sellers, all trading data and resolving financial matters though the CBO systems and the central trade engine 182.
- the trade integration module 192 links the central data center 182 to the various CBO systems at the buyer and seller sites.
- the customer adapter module 194 is a piece of customer-specific code that links the CBO system (which is generic to all sellers or buyers) to a customer specific enterprise system through the system adapter 196. It also provides customer-specific alterations and/or customization of the CBO system, such as specific business rules, workflow or validation procedures that may be unique to the particular customer.
- the system adapter 196 links to the customer's enterprise system and provides data conversion from the enterprise system format to the format expected by the CBO system, which is preferably in XML format. Because the systems shown in Figure 10 may be connected via public networks, such as the Internet, system security is an important consideration.
- firewall protection it is preferably that data exchanges in this system are done using public/private key encryption techniques, and also using secure HTTPS/SFTP connections for web- related transmissions and file transfer between servers. For example, when transferring a batch of transaction data from an enterprise server to the CBO software system, a public/private key approach is preferred.
- User authentication is also provided for each user of the system to prevent unauthorized access to the system and/or the underlying transaction data. This user authentication is built upon a permissions-based model that allows permissions, roles and groups to be defined and configured on a per-customer basis, so that only certain data is visible to certain authenticated users. Fig.
- FIG. 11 is a flow diagram of an example transaction matching process in which invoices and receipts are segmented into a hierarchy of pools prior to automated and manual matching.
- This transaction matching process is one function of the CBO software systems shown in Figure 10, preferably implemented at the buyer CBO systems, but alternatively implemented at both the buyer and seller installations.
- the process begins at step 10, in which purchase order and receipt data as well as invoice data is extracted and image processed, as described above with reference to Figure 3.
- the extracted data is validated in step 36, similar to that described above, and then stored into the system as image data, header data and detail tables 40, 42, 44.
- This data can be stored at the buyer and/or seller systems 184, 186, 188, 190, or it can be centrally archived at the data center 182 where the trade engine is located.
- the data can be mirrored at a variety of different locations to enable both local and remote processing. Additional processes, such as those depicted in Figure 4, above, may also occur at this stage of the process.
- the data is fed into a processing queue (including stages 202, 208, 212), in which the data is sorting into logical groupings (also referred to herein as segments or pools) for automated and manual matching processes.
- logical groupings also referred to herein as segments or pools
- user defined parameters 204 are used to determine the appropriate type of segmentation (or pooling) to perform on the extracted invoice/receipt data. These user defined parameters identify specific characteristics of the invoices and receipts and sort them using these characteristics.
- Different pooling characteristics may include: by vendor; by different combinations of a company's user identification number, by a unique identification assigned by the customer's accounting department, by a specific purchase order, by the location where the goods were received, by department, etc.
- the segmentation may be accomplished in a primary, secondary, and n-ary manner so as to develop a hierarchy of segmentation, such as initial by vendor, but then within the vendor pool, by department of the vendor, and then within the department of the vendor by location, etc., so as to develop a tree-like hierarchy of segments to be searched by the automated and manual matching processes 208, 212 of the processing queue.
- the system is able to break down the matching process into smaller segments of data to be matched.
- This segment data is then provided to the automatic matching process 208 ( Figure 12), which applies a match strategy 210 comprising a plurality of matching rules in an attempt to automatically match the invoices/receipts in a given segment of data. If a match is determined within the segment, then a unique match identification (Match ID) is associated with the matched documents, and this data is then stored in the system 206 and provided to the accounting system for payments, deductions, charge back, etc.
- a match strategy 210 comprising a plurality of matching rules in an attempt to automatically match the invoices/receipts in a given segment of data.
- Fig. 12 is a flow diagram of an example automated matching process 208 providing N-dimensional matching of invoices and receipt data. Unique to this process is the system's ability to iteratively compare transactions within a given segment of data using a set of user-defined matching rules 210, which together provide a match strategy that can be customized for each buyer/seller installation.
- matching rules are applied to the match data on a priority basis until a match is detected, or if no match is detected then the system can either automatically generate a debit memo 242 or proceed to the manual reconciliation process 212.
- the process begins at step 220, where the match strategy is established using stored matching rules 210 that are unique to the customer.
- the match strategy is then applied to the segmented (pooled) transaction data in order to automatically match invoices to receipt data.
- the match strategy is typically composed of a plurality of matching rules 210.
- the match strategy may comprise three rules, a first rule to match one invoice to one receipt with no tolerance allowed (in other words a perfect match), a second rule to match one invoice to one receipt if the invoice is within 10 days of the due date with a $50 tolerance, and a third rule to match one invoice to one receipt and to pay the invoice if it is over $50.
- These three rules then comprise the example match strategy, and are applied in steps 222, 224, 226, 230 and 234 to the segmented data 206.
- the system uses the matching rules 210 to determine how invoices and receipts should be matched, such as one-to-one, all-to-all or many-to many, or any combination thereof.
- This type-of-match determination is typically based upon past historical data and can be updated as match results are analyzed by the system.
- the process then applies a match level to the segmented data at step 224.
- the match level determination can be done at the header level, the summary level or at the detail level.
- the system can make a determination (based on the header level data) to pay a particular invoice or deduct the difference in a lump sum.
- the system compares a summary invoice information and receipt information and compute either a charge back or a line level deduction.
- the system matches individual lines of the invoice/receipt.
- the system then applies a variance review process 226 using variance parameters 228.
- the variance parameters are defined as amount over/under, percent over/under, or a combination of the two. These parameters are then applied to the data output from the preliminary matching steps 222, 224 based on the matching rules to determine if the matching data is within a particular tolerance level as defined by the variance parameters 288. Acceptance of the preliminary match occurs if it is within the variance parameter.
- the system may perform a best invoice match and/or a best pool match. The best invoice match directs the system directs the system to take the first invoice in the match pool and match it to the receipt with the smallest variance within the given tolerance.
- the best pool match directs the system to calculate all possible matches for the pool based on match level (for example, 1 - 1, or A - A) and match them based on the smallest variance within the given tolerance. If the matching rules and variance steps 222, 224, 226 determine that there is a match, then at step 230, the process proceeds to step 232 and a unique match identifier (Match ID) is assigned to the match data. In this step (232), the Match ID is associated with all of the documents that related to the particular match, such as the invoice and receipt documents, and also the purchase order documents. If the resulting match generates a debit memo, then the same identification number is assigned to that debit memo.
- match level for example, 1 - 1, or A - A
- This Match ID is then used to subsequently view and understand how the match occurred, from either the buyer or seller's system, and may be used to tag additional documents that relate to the transaction.
- the associated match data (along with the Match ID) is then stored to the system database in step 238, and the match data is forwarded to the customer's accounting system for appropriate payment, etc. If the matching rules and variance steps 222, 224, 226 determine that there is not a match, however, then at step 230, the process proceeds to step 234, where a determination is made as to whether further iterations of the matching rules (and/or variance calculations) should occur.
- Fig. 13 is a flow diagram of an example manual reconciliation process 212 providing numerous matching tools for matching invoices and receipts. This process is typically applied to the segmented data that has not been matched via the N-dimensional automated matching process described in Figure 12.
- the manual reconciliation process begins at step 250 when a user (either buyer or seller) connects to the system. This connection can occur through a secure web page interface, or through other types of secure connections.
- a user either buyer or seller
- the reconciliation screen is the beginning point for manually reconciling invoices and receipts that failed to be automatically matched in the N- dimensional process of Figure 12.
- the segmented transaction data 206 is passed to the reconciliation queue screen display 252 and provided to the user for manual reconciliation. From the reconciliation screen ( Figure 17), several options are available to the user for manually reconciling the transaction data, including matching invoices and receipts at the header level 254, matching invoices and receipts at the line level 256, and invoice approval 268. Manual matching of invoices to receipts can be selected either at the header level
- the header match screen will display unapplied and applied invoices on the left side of the screen (See, Figure 18), and unapplied and applied receipts on the right side of the screen. Receipts can then be selected or unselected with a simple button click.
- the same side-by-side displays are presented to the user, but the data is presented at the line level, as shown in Figure 14 for the line match screen 270. From this screen, the user then selects the invoice line and applies the appropriate receipt lines.
- the system then assigns the unique Match ID to the transaction documents 278, stores the data (with the Match IDs tagged thereto) in the system database 280, and then forwards the match data to the buyer/seller accounting system 282.
- Semi-automated matching is provided through the quantity match 258, extended match 260 and perfect match 262 functions accessible through the line match screen ( Figure 14).
- the quantity match function 258 will apply all the receipt lines that have the same item and quantity, which enables the system to automatically match items on the invoice and receipt that have different unit costs.
- the extended match function 260 determines matching invoice and receipt lines where the item and the extended costs are the same.
- the perfect match function 262 will match invoice and receipt lines where the item number, unit price and extended costs are all the same.
- Another feature that is accessible to the user is an item match process, which allows the user to match only on the item number. This process enables matching of items that have the same item number but different quantities and unit prices.
- the system will then assign a unique Match ID to the transaction documents 278, store the documents with the tagged ID value back into the system database 280, and then forward the match data to the buyer/seller accounting system 282.
- the system may display resulting matched lines with indicators describing the quality of the match.
- Different status identifiers may include: Perfect Match (PM); Overbilled (OB); Underbilled (UB) Substituted Item (SUB); or a combination of these identifiers, for example and underbilled substitution would have the status UBS as shown in the first invoice line item of Figure 14.
- icons are displayed next to particular line item quantities to indicate how the invoice line compares to the matched receipt line.
- the system provides an ability to find particular receipts that may not be displayed on the header or line match screens because the receipt is either in another data segment, or did not pass one of the matching rules of the match strategy.
- the user accesses a receipts screen interface. From here, the system provides filtering and sorting options to enable faster searching for a particular receipt. Once the receipt is found, then at step 266 the user can choose from several options, such as adding the receipt to the view match screen, altering or modifying the selected receipt, or splitting the receipt at the line level to create several line level receipts or line level grouping of receipts. By splitting the receipt at the line level, the system enables the user to match the same receipt to multiple invoices.
- This function can also be accomplished from the line match screen 256.
- Most of the functionality described with reference to Figures 11-22 deals with the buyer-side reconciliation process accessed through the buyer COB application.
- the reconciliation screens are similar to that described and shown for the buyer, in which the seller user can view buyer applied matches, adjustments and any subsequent memos created by the buyer user.
- the seller users can view how the buyer user matched the transaction documents, and may then reconcile these matched documents to determine if the seller is in agreement with the buyer's match.
- Another function available to the user is to convert the units of measure shown on the seller invoice to the buyer's preferred units of measure. This function can ease the matching process where the buyer and seller units of measure are different.
- Fig. 14 is a line match screen interface 252 operable by a user of the system in order to manually reconcile invoices and receipts at the line level.
- the manual matching provided through the line match screen 252 incorporates a "side-by-side" presentation style for displaying the segmented invoices and receipts that did not pass the automated matching process.
- these invoices are for those receipts that met at least one of the matching rules (but not necessarily within the programmed variance) defined in the match strategy.
- the line match display portion 304 which displays a selected invoice by vendor, department number, invoice number, purchase order number, and location.
- this display portion 304 of the interface provides financial data on the invoice amount, allowance amount, charge amount, matching amount, receipt amount and any difference.
- the user can select from one of the semi-automated match functions, such as the quantity match function 258, the extended match function 260 or the perfect match function 262.
- the user can find a particular receipt 264, generate a charge back item 302, or perform a matching function 300 based on manually selected invoices/receipt, or lines of selected invoices/receipts.
- the line match display portion 304 below the line match display portion 304 is the side-by-side invoice/receipt display portions 306, 312.
- the invoice display portion 306 individual invoices lines are displayed in sequential fashion.
- the invoices lines displayed include item number, status, quantity, unit cost and extended cost.
- the status field is described above with reference to Figure 13.
- the quantity field includes the graphical icon indicators 308 described above.
- a radio button at the front of the invoice lines is used to select a particular invoice line for application to a particular receipt line, either using one of the semi-automated functions 258, 260, 262, or by manual application to a particular receipt.
- the receipt lines are displayed in the receipt display portion 312, and include similar information to the invoice lines.
- Fig. 15A is a view match screen interface operable by a user of the system in order to view the details of a matching process executed by the system.
- match summary portion 320 provides the details of the invoice to receipt match performed by the system or manually by the user.
- match summary portion 320 of the interface the following data is displayed: vendor, unique Match ID, match level, match status, match date, match type and the match strategy utilized in performing the match.
- a financial block 330 showing the invoice amount, allowance amount, charge amount, match amount, receipt amount, difference between the match amount and the receipt amount, an adjustment amount and a net difference.
- An un-match button 328 can be executed to un-do the matching performed by the system if the user determines that there has been an error in the matching process.
- match summary portion 320 Three sub-displays showing the details of the matched invoices 322, the matched receipts 324 and any debit/credit memos that were generated 326. All of these documents are tagged with the Match ID for this match transaction and stored in the system database with this tag. As can be seen in these displays, a single invoice in the amount of $69,561.90 has been matched to two receipts and a credit memo has been generated for the difference amount. From the view match screen, the user can return to the documents research queue, as further described below in Figure 19. The screen shows all the information for this transaction, starting with all the invoices involved for this one particular match, all the receipt of goods included (and this could be a one to one, one to many, many to one, many to many).
- this may result in seven invoices lining up to five receipts of goods. There may be one invoice and multiple receipt of goods (one truck with 100 widgets, dropped off at three locations). All the pieces of the transaction are included (a match, with a chargeback, the strategy used, the type of match, credit memo, if the process was disputed, what was the repayment, etc).
- the fourth quadrant of the screen (bottom left) may be reserved for the electronic submission of chargeback. Thus this screen shows any subsequent action related to the specific match
- FIG. 15B is a view match notes screen interface 332 operable by a user of the system in order to identify and view notes associated with a particular match.
- This screen shows a list of notes 334 associated with a particular match.
- the date and time of the note creation are displayed, along with an indication of the type of note and who entered it into the system. From here the user can also add a note 336.
- Fig. 16 is a notes interface screen 272 operable by a user of the system in order to apply a textual note to a particular transaction document.
- a user has opened a notes window 342 and is applying a text note to a particular invoice. This note will be associated with the invoice and will be stored with it for future transactions.
- the system has the ability to add these types of notes to any of the transaction documents processed by the system.
- Fig. 17 is a reconciliation queue interface screen 252 operable by a user of the system in order to begin the manual reconciliation process described in Fig. 13.
- This interface includes a search box 350, in which the user can search for a particular invoice by vender, department, invoice number due date, PO number location, etc.
- the results of a particular search are displayed in the results window 354, which displays invoices due dates, PO numbers, department, location, match amount, invoice date, etc. From here, the user can select certain invoices for manual reconciliation as described above with reference to Figure 13.
- Fig. 17 is a reconciliation queue interface screen 252 operable by a user of the system in order to begin the manual reconciliation process described in Fig. 13.
- This interface includes a search box 350, in which the user can search for a particular invoice by vender, department, invoice number due date, PO number location, etc.
- the results of a particular search are displayed in the results window 354, which displays invoices due dates, PO numbers, department, location, match amount, invoice date, etc. From here,
- the header match screen 276 operable by a user of the system in order to manually reconcile invoices and receipts at the header level.
- the header match screen 276 includes a match box 360 and a selection box 362.
- the match box displays a selected invoice by vender, department, PO number etc., and also provides additional financial details regarding the invoice, such as invoice amount, match amount, difference amount, etc. From the selection box 362, the user can select certain receipts to apply to the selected invoice.
- the user can execute the find receipts function 264 if an appropriate receipt is not displayed in the match box 362, or the user can jump to the line match screen 256 to attempt to match the invoice at the line level.
- FIG. 19 is an exemplary process flow diagram 400 for researching a particular match and viewing the match using the view match screen interface.
- the process begins from the document research queue 402, which is accessible from many of the previously discussed system interface screens. From the research queue, the user can either add notes 404 or go to the view document screen 406. From the view document screen 406, the user can then go to the view match screen 412, as shown above in Figure 15A and also shown below in Figure 22. Alternatively, the user can begin at the receipt research screen 408, go to the view receipt screen 410, and then from there go to the view match screen 412. Alternatively ways of jumping to the view match screen are also possible.
- Fig. 20 is a document research queue interface screen 402. This screen includes a search box 420 and a search box 422.
- Figure 23 shows that in one embodiment, a symbiotic accumulative process to handle trade settlement which results in the creation of a new collaborative data set.
- the system according to the present invention is designed for access by both parties to view, reconcile, adjudicate and report on all financial transactions between the trading partners. All documents, memos, images, files, notes and correspondence related to the financial settlement of a transaction are captured and linked together in the system. This is for not only the original payment decision and/or deduction but also all dispute requests, supporting documentation and subsequent credits & debits until both parties are satisfied with the final settlement or recognize that any additional efforts will not affect the outcome. This information as it is brought into the system is then shared between both parties for a single source of data for the transaction.
- the data set 500 may be stored at a central datastore (which may be part of the platform 15) that is accessible to users from the buying company (retailer) or the selling company (manufacturer).
- a single platform 15 is used to match invoices and purchase orders and then handle and settlement issues. Because in one embodiment, only a single platform 15 is used to process all transactions, those transactions can be captured to form the data set 500 related to at least one particular transaction (whether based off of at least one invoice, at least one purchase order, or at least one receipt of goods).
- the data set 500 may contain purchaser order detail information 506 and invoice detail information 508 obtained in this example from the retailer and manufacturer respectively.
- the receipt of goods information 510 may also stored into the data set 500 from the retailer's receipt of goods 512. This information may then be used to match invoices with purchase orders/receipt of goods using methods as described herein. This may result in a retailer first settlement 516 of the transaction.
- Figure 23 further shows that embodiments of the present invention further includes additional settlement information that is useful to obtain an accurate history of the settlement transactions.
- credit and/or debit memos 520 may also be incorporated into the data set 500. This may be included as part of the detailed settlement data 522.
- the manufacturer may then review settlement data at step 524. If the manufacturer determines that the settlement was inaccurate, they may then enter settlement dispute data 526 into the data set 500.
- Supporting documentation may also be captured and scanned images 528 incorporated as part of the data set 500.
- the retailer will have access to this same data set 500 and can see the additional settlement data added by the manufacturer. This allows the retailer to leverage on the work done by the manufacturer and examine if the settlement was accurate.
- the retailer will review the disputed data at step 530.
- the retailer may then include their own settlement dispute data 532 and images of documentation 534 into the data set 500.
- the retailer may send images of pricing list, proof of Co-op advertising, etc ... This process of review may be iterative and as indicated by arrow 536, the process will continue until a final settlement satisfactory to both parties is reached.
- the present invention allows for multiple iterations of the resolution process (go back and forth) and all of this is captured by the data set 500. This is entered by the user. Each user is doing work, but the other may benefit off of it.
- the data and documents are captured and stored in same location. This is something they would probably do any way, but it is being captured and stored and added to this data set since in the present embodiment, transactions pass through the processing engine. Thus, all subsequent settlement transactions and supporting documentation are captured by the data set 500 so that a complete, cumulative trade settlement is documented.
- Embodiment of the present invention may create a collaborative data set in the central datastore based in part on the matched record and any subsequent settlement history.
- the capturing of post-match, settlement history may involve storing all additional settlement data to be used to as part of the same collaborative data set 500 in the central datastore of the single platform 15, wherein at least one of the following is stored: credit memos, debit memos regarding the invoice and/or the purchase order of the matched record, settlement dispute data from the selling company, supporting images and documentation from the selling company, settlement dispute data from the buying company, supporting images and documentation from the buying company.
- Users from the buying company and users from the selling company accessing the collaborative data set 500 to reconcile the transaction using the matched record settlement transaction history and supporting documentation stored in the datastore.
- the present invention allows things to be stored that could not be stored before (and additional detail is kept). Together they build this datastore. This is the archival, ongoing settlement, communication, post audit, etc... (the aftermath).
- the present invention provides both parties with information and access they do not normally have and this is unique to the present invention. This may include information from manufacturer that the retailer may not normally have in an electronically format. They cannot leverage each other's work when both parties are not working off of the same data set. Since all parties must work through a single transaction platform that creates a data set for each transaction, the settlement history is more easily tracked.
- one party can see how the other resolves say a price issue. Not part of any old data, this may be a new price set based on knowledge they have gained as part of settlement iterative review by seller and buyer. For example, a bill of lading into the system may not have been tied back to the original transaction. In a post audit, the dots are now connected. The present invention provides a true report card of why the user was success and how the user succeeded. It should be understood that on the retailer side, there are two separate processes. There is payment side and there is the procurement side (and the two are kept separate). Procurement side may write a purchase order. The delivery may have multiple purchase orders on it, but the same goods on those multiple purchase orders. Might be 10 10 and 10.
- First purchase order may get 10, but he receives 30. Other two deliveries may not get the goods since all thirty were delivered at the first stop. So, those two purchase orders are short. This highlights that how goods are ordered and how goods are delivered can occur in very different ways.
- the same workspace is used.
- a communal workspace allows for more accurate matching and it allows for one side to connect the invoices and receipt of goods that make sense.
- the manufacturer may be allowed to change the matching of invoices and receipt of goods during the iterative review.
- the present example allows a user from the manufacturer to match the invoices to show that a total of 30 units were received by retailer (even though all thirty were delivered to one location instead of three). This rematching will then indicate the receipt of goods does match the invoice. The total delivered matches the total to be paid.
- the present invention archives the corrections, and this is not being tracked today.
- the system manages multiple non-dependent statuses for an invoice. This allows an invoice 540 to be paid before it is verified against a receipt and then have a deduction applied to it when it finally is matched. This enables buyers the ability to take terms discounts even when their internal process for invoice approval can not be accomplished in the terms discount time frame.
- Figure 24 shows that payment status and invoice status may be decoupled. Under the payment status, the invoice may move from being open at step 542, to being scheduled at step 544, and to being paid at step 546.
- this payment status may be independent of the invoice match status. This allows an invoice 540 to be paid before it is verified against a receipt and then have a deduction applied to it when it finally is matched.
- the invoice may move from open status 550 to a matched status 552.
- the invoice may be moved to a saved match status 554. Saved match is when a retail user is using the on-line reconciliation screens and has found an invoice and a receipt that look like they go together, but still hasn't verified all of the invoice and needs to either verify it with another department, person, etc they can save the point in the match where they are so as to not loose their work.
- the status may be an approved status 556 or a deleted status 558.
- Line Level Reason Codes 570 users can classify line item quantity discrepancies as a carrier claim 572, chargeback 574, or write-off 576.
- This functionality includes the ability to split an individual item discrepancy into both a Carrier Claim and Chargeback discrepancy.
- running totals are being kept at the top of the screen to provide a full picture of the classification process.
- the user can perform the match and the related chargeback and/or carrier claim will be systematically generated. Both documents are tied to the original match to provide a complete audit trail of the invoice deduction.
- the system compares the charges/allowances 580 on the invoice to the Retailers internal and/or vendor defined charges/allowances 582.
- Vendor header level charges/allowance amounts or percents can be defined through the flexible Admin screens according to the present invention. For discrepancies that are not in the retailers favor, a charge/allowance chargeback is generated back to the merchandise vendor. The charge/allowance comparison is performed at both the header and line level. Charge/allowance chargebacks are tied to the match to provide a full audit trail of the invoice deduction.
- embodiments of the present invention provides visibility of all charge/allowance's involved in the match and clearly identifies which is the "best" charge/allowance that was taken by the Retailer. Performing the charge/allowance match prior to payment of the invoice can reduce post audit findings. The retailer can reduce the amount of the vendor payment based on what they consider to be the best allowance. If the charge/allowance match was not performed, the retailer would have to go back for the allowance discrepancy post payment. It should be understood that embodiments of the present invention may also take allowance based on Goods Received. Based on the individual Retailer's business practice, the taking of allowances is not always solely based on the invoice amount. For certain Retailers, the business practice is to only take allowances on the actual goods received.
- the application of the present invention is flexible enough to handle both scenarios.
- the Retailer can choose to apply the "best" allowance to the merchandise chargeback to reduce the amount of the deduction.
- component pricing (price per unit, price for shipping...keeping all the individual things separate, instead of just one price) may be introduced to provide more granularity on the price per unit.
- every action on every transaction may be tracked so that a complete history is captured.
- the present invention may allow for tying deductions back to original transaction (it is a different classification of documents).
- score cards and analytics may be based on the new data set 500. Metrics may be performed on the new data set.
- the application of the present invention for settlement transactions may be implemented within a framework of an Application Service Provider (ASP) system embedded in a central server computer platform having a network interface.
- Server platform can be a single workstation computer such as a PC, a mainframe computer or a collection of computers interconnected by a local or wide area network.
- Server platform is capable of handling web-enabled technologies by means of web server application such as BEA WebLogic Server which supports Hypertext Transfer Protocol (HTTP).
- Such technologies include for example Java applets, JavaScripts, HTML, DHTML, XML, and the like on the client side, and Servlets, Java Pages (JSP) and Enterprise Java Beans (EJB) and the like on the server side.
- a user of the system communicatively interfaces over a data communication network, such as the Internet or Intranet, to central server by conventional communication devices such as a modem, a network card and the like, using a software application, i.e., Web Browser (e.g., Microsoft Explorer, Netscape Navigator).
- Web Browser e.g., Microsoft Explorer, Netscape Navigator
Landscapes
- Business, Economics & Management (AREA)
- Engineering & Computer Science (AREA)
- Strategic Management (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Entrepreneurship & Innovation (AREA)
- Economics (AREA)
- Marketing (AREA)
- Finance (AREA)
- Accounting & Taxation (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Human Resources & Organizations (AREA)
- Data Mining & Analysis (AREA)
- Tourism & Hospitality (AREA)
- Quality & Reliability (AREA)
- Operations Research (AREA)
- Development Economics (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
Description
Claims
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US53381603P | 2003-12-30 | 2003-12-30 | |
PCT/US2004/043825 WO2005065346A2 (en) | 2003-12-30 | 2004-12-30 | Method and system for processing transactions |
Publications (2)
Publication Number | Publication Date |
---|---|
EP1704391A2 true EP1704391A2 (en) | 2006-09-27 |
EP1704391A4 EP1704391A4 (en) | 2009-06-10 |
Family
ID=34748965
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
EP04815823A Withdrawn EP1704391A4 (en) | 2003-12-30 | 2004-12-30 | Method and system for processing transactions |
Country Status (3)
Country | Link |
---|---|
EP (1) | EP1704391A4 (en) |
CA (1) | CA2555190A1 (en) |
WO (1) | WO2005065346A2 (en) |
Families Citing this family (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US11687519B2 (en) | 2021-08-11 | 2023-06-27 | T-Mobile Usa, Inc. | Ensuring availability and integrity of a database across geographical regions |
Family Cites Families (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5794207A (en) * | 1996-09-04 | 1998-08-11 | Walker Asset Management Limited Partnership | Method and apparatus for a cryptographically assisted commercial network system designed to facilitate buyer-driven conditional purchase offers |
US5915022A (en) * | 1996-05-30 | 1999-06-22 | Robinson; Rodney Aaron | Method and apparatus for creating and using an encrypted digital receipt for electronic transactions |
US6330551B1 (en) * | 1998-08-06 | 2001-12-11 | Cybersettle.Com, Inc. | Computerized dispute resolution system and method |
-
2004
- 2004-12-30 EP EP04815823A patent/EP1704391A4/en not_active Withdrawn
- 2004-12-30 CA CA002555190A patent/CA2555190A1/en not_active Abandoned
- 2004-12-30 WO PCT/US2004/043825 patent/WO2005065346A2/en active Application Filing
Non-Patent Citations (2)
Title |
---|
EPO: "Mitteilung des Europäischen Patentamts vom 1. Oktober 2007 über Geschäftsmethoden = Notice from the European Patent Office dated 1 October 2007 concerning business methods = Communiqué de l'Office européen des brevets,en date du 1er octobre 2007, concernant les méthodes dans le domaine des activités" JOURNAL OFFICIEL DE L'OFFICE EUROPEEN DES BREVETS.OFFICIAL JOURNAL OF THE EUROPEAN PATENT OFFICE.AMTSBLATTT DES EUROPAEISCHEN PATENTAMTS, OEB, MUNCHEN, DE, vol. 30, no. 11, 1 November 2007 (2007-11-01), pages 592-593, XP007905525 ISSN: 0170-9291 * |
See also references of WO2005065346A2 * |
Also Published As
Publication number | Publication date |
---|---|
WO2005065346A2 (en) | 2005-07-21 |
WO2005065346A3 (en) | 2009-04-16 |
CA2555190A1 (en) | 2005-07-21 |
EP1704391A4 (en) | 2009-06-10 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US8326754B2 (en) | Method and system for processing transactions | |
US6882983B2 (en) | Method and system for processing transactions | |
US8880437B1 (en) | System and method for integrating trading operations including the generation, processing and tracking of and trade documents | |
US20190347738A1 (en) | System and method for reducing fraud in trade insurance and financing | |
AU2002242031A1 (en) | Method and system for processing transactions | |
US20020095355A1 (en) | Computer-implemented international trade system | |
US20050119926A1 (en) | Method and system for managing multi-national integrated trade and logistics and processes for efficient, timely, and compliant movement of goods across international borders | |
NZ528068A (en) | Network based business to business portal for the retail convenience marketplace | |
CA2657914A1 (en) | Method and system for receivables management | |
US20080086413A1 (en) | Systems and methods for collaborative payment strategies | |
US7788160B2 (en) | Method and system for configurable options in enhanced network-based auctions | |
WO2002035382A1 (en) | Electronic international trading | |
US20050234804A1 (en) | Method and system for auto-mapping to network-based auctions | |
US8478666B2 (en) | System and method for processing data related to management of financial assets | |
CA2657303A1 (en) | Internet enabled vehicle downpayment system and method with backend system for managing vehicle dealer information | |
WO2005065346A2 (en) | Method and system for processing transactions | |
JP2002230362A (en) | System and method for procurement support | |
JP2002230362A5 (en) | ||
AU2002233050B2 (en) | Network based business to business portal for the retail convenience marketplace | |
Hamisu | The impact of ERP system on financial accounting and reporting cycles of the company. Evidence from Ghana | |
Lemeshko et al. | MUNI ECON | |
JP2003067575A (en) | Security information registration and management system, security information registration program, and recording medium for recording the same | |
Deshmukh | The Expenditure Cycle |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PUAI | Public reference made under article 153(3) epc to a published international application that has entered the european phase |
Free format text: ORIGINAL CODE: 0009012 |
|
17P | Request for examination filed |
Effective date: 20060728 |
|
AK | Designated contracting states |
Kind code of ref document: A2 Designated state(s): AT BE BG CH CY CZ DE DK EE ES FI FR GB GR HU IE IS IT LI LT LU MC NL PL PT RO SE SI SK TR |
|
AX | Request for extension of the european patent |
Extension state: AL BA HR LV MK YU |
|
RIN1 | Information on inventor provided before grant (corrected) |
Inventor name: HANSON, PAUL Inventor name: FURPHY, THOMAS, W. Inventor name: BARNES, MICHAEL, J. Inventor name: HOFFMEYER, MARK Inventor name: MARRON, JOHN, T. Inventor name: DAWSON, TIM Inventor name: BANDYCH, DAVID, W. |
|
RAP1 | Party data changed (applicant data changed or rights of an application transferred) |
Owner name: ORACLE INTERNATIONAL CORPORATION |
|
REG | Reference to a national code |
Ref country code: HK Ref legal event code: DE Ref document number: 1098817 Country of ref document: HK |
|
PUAK | Availability of information related to the publication of the international search report |
Free format text: ORIGINAL CODE: 0009015 |
|
RIC1 | Information provided on ipc code assigned before grant |
Ipc: G06Q 10/00 20060101AFI20090427BHEP |
|
A4 | Supplementary search report drawn up and despatched |
Effective date: 20090512 |
|
STAA | Information on the status of an ep patent application or granted ep patent |
Free format text: STATUS: THE APPLICATION HAS BEEN WITHDRAWN |
|
18W | Application withdrawn |
Effective date: 20091021 |
|
REG | Reference to a national code |
Ref country code: HK Ref legal event code: WD Ref document number: 1098817 Country of ref document: HK |