System for invoice record management and asset-backed commercial paper program management

• US 20020133460A1
• Filed: 05/13/2002
• Published: 09/19/2002
• Est. Priority Date: 11/09/1994
• Status: Active Grant

• Current Assignee: Richard G. Field
• Original Assignee: Richard G. Field
• Inventors: Field, Richard G.
• Granted Patent: US 7,254,555 B2
• Time in Patent Office: Days
• US Class Current: 705/40
• CPC Class Codes: G06Q 10/10 Office automation; Time management
• CPC Class Codes: G06Q 20/102 Bill distribution or payments
• CPC Class Codes: G06Q 30/06 Buying, selling or leasing transactions
• CPC Class Codes: G06Q 40/06 Asset management; Financial planning or analysis
• CPC Class Codes: G06Q 40/08 Insurance
• CPC Class Codes: G16H 40/20 for the management or administration of healthcare resources or facilities, e.g. managing hospital staff or surgery rooms

Abstract

A computerized system that will allow healthcare providers to access the commercial paper market by “selling” their patient claims to asset backed commercial paper conduits. The system generates the statistical information on the historic collection experience of the provider'"'"'s claims required by both the rating agencies and the sponsors of the conduits. This statistical information has two pieces: the net collectible value matrix showing the percentage of the claim actually paid by individual payers; and a collection histogram showing the timing of the payers payments from the date of initial billing. The system also generates the accounting detail necessary for controlling and auditing the provider'"'"'s participation in the commercial paper conduit prog=The system tracks “periodic pools” of claims so as to be able to reconcile advances, collections, interest expense, third party fees and cash settlements between conduits and providers. This statistical information has two pieces: the net collectible value matrix showing both the percentage of the claim actually paid by individual payors and the standard deviation of this percentage; and a collection histogram showing the timing of the payors'"'"' payments from the date of initial billing.

Claims

1. A system for processing electronic accounts receivable records, each specifying an account receivable recorded in one or more computer systems for a seller of the account receivable, each accounts receivable record including (i) a date field specifying a date for the account receivable, (ii) a financial data portion specifying an amount billed to be paid by a payor, and (iii) goods or services data portion specifying information about the goods or services provided for the amount billed, comprising:

means for downloading accounts receivable records from the seller accounting system and creating an electronic financial record corresponding to each of at least some of the accounts receivable records downloaded from the provider accounting system, the financial records recording a financial data subset of all of the data recorded in a downloaded accounts receivable record, the financial data subset corresponding substantially to financial aspects of the downloaded accounts receivable records, and means for storing the financial accounts receivable in a mass storage device located at a location of the seller;

means for creating an electronic goods or services record corresponding to each of at least some of the accounts receivable records downloaded from the seller accounting system, the electronic goods or services records recording a subset of all of the data recorded in a downloaded accounts receivable, the data subset corresponding substantially to goods or services aspects of the downloaded accounts receivables, and means for storing the goods or services provided record in a mass storage device located at a seller location;

means for searching the financial records and identifying records that have a date specified in the date field of the record within a predetermined period to identify a pool of accounts receivable records, with the records a specifying corresponding periodic pool of accounts receivable; and

means for creating an electronic periodic pool record corresponding to the identifed pool of accounts receivable records.

2. A system according to claim 1 further including means for recording a pool advance amount in a field of the electronic periodic pool record representing an amount to be advanced against a value of the periodic pool of accounts receivable;

and means for electronically transferring the electronic periodic pool record to a central processing system.

3. A system for processing electronic accounts receivable records, each specifying an account receivable recorded in one or more computer systems for a seller of the account receivable, each accounts receivable record including (i) a date field specifying a date for the account receivable, and (ii) a financial data portion specifying an amount billed to be paid by a payer, comprising:

means for searching the accounts receivable records and identifying records that have a date specified in the date field of the record within a predetermined period to identify a pool of accounts receivable records, with the records a specifying corresponding periodic pool of accounts receivable;

means for creating an electronic periodic pool record corresponding to the pool of accounts receivable records;

means for recording a pool advance amount in a field of the electronic periodic pool record representing an amount to be advanced against a value of the periodic pool of accounts receivable; and

means for electronically transferring the electronic periodic pool record to a central processing system.

4. A system according to claim 3 further wherein the central processing system includes means for maintaining an electronic accounting data for each periodic pool represented by a periodic pool record, and for preparing financial statements from the electronic accounting data.

5. A system according to claim 3 further wherein the central processing system includes means for preparing reports for a third party advancing money against a periodic pool represented by a periodic pool record, and wherein the reports specify compliance with third party restrictions on advances against periodic pools.

6. A system according to claim 3 further including means for determining the pool advance amount using the amount billed specified in the financial data portion of the accounts receivable records.

7. A system according to claim 3 further including means for determining an advance amount for each of the accounts receivable in the pool and using the determined advance amounts to determine the pool advance amount.

8. A system according to claim 7 further including means for determining the advance amount for each account receivable in the pool based on payor.

9. A system according to claim 3 further wherein there is more than one seller, each of whom may have one or more locations and wherein said means for electronically transferring is provided at each seller location;

and wherein the central processing system is installed at a position remote from at least one of the seller locations.

10. A system according to claim 3 further including means for electronically transferring an electronic record to a remote location of a third party advancing money against the periodic pool of accounts receivable, the electronic record indicating the value of the periodic pool of accounts receivable.

11. A system according to claim 3 further including means for recording in each periodic pool record a collection value representing an amount paid on the accounts receivable in the periodic pool record.

12. A system according to claim 11 further including means for determining the collection value representing an amount paid using the financial data portion of an accounts receivable record and wherein said financial data portion specifies an amount paid.

13. A system according to claim 11 further including means for receiving an electronic record specifying a payment received value representing an amount of payments received by a third party which has the right to collect payments made on amounts billed in a periodic pool corresponding to a periodic pool record.

14. A system according to claim 13 further including means for reconciling payment received values to amount paid values from periodic pool records.

15. A system according to claim 3 further including means for creating an electronic accounts receivable financial record corresponding to each of at least some of the accounts receivable records downloaded from the provider accounting system, the financial records recording a financial data subset of all of the data recorded in a downloaded accounts receivable record, the financial data subset corresponding substantially to financial aspects of the downloaded accounts receivables, and means for storing the financial accounts receivable in a mass storage device located at a location of the seller.

16. A system according to claim 3 further wherein each accounts receivable record includes a (iii) goods or services data portion specifying information about the goods or services provided for the amount billed, and further wherein the system includes means for creating an electronic goods or services record corresponding to each of at least some of the accounts receivable records downloaded from the seller accounting system, the records recording a subset of all of the data recorded in a downloaded accounts receivable, the data subset corresponding substantially to goods or services aspects of the downloaded accounts receivables, and means for storing the goods or services provided record in a mass storage device located at a seller location.

17. A system according to claim 3 further wherein the financial data portion of each account receivable record further specifies a payor for the account receivable.

18. A system according to claim 17 further including means for looking up the collectability statistics according to the payors specified in the accounts receivable records.

19. A system according to claim 18 further including means for reporting the performance of the periodic pools according to which payor is responsible for paying accounts receivable in the periodic pool.

20. A system according to claim 18 including means for analyzing collection data specified in accounts receivable records to determine current collection statistics and means for comparing the historical collection statistics with the current collection statistics.

21. A system according to claim 3 further including means for processing historic accounts receivable records specifying payment history to determine collection timing statistics indicating when amounts billed normally get paid.

22. A system according to claim 3 further wherein each accounts receivable record specifies an amount paid on the account receivable and further including means for periodically determining an amount paid for the accounts receivable in the corresponding periodic pool by electronically reviewing the amount paid specified in each account receivable record in the periodic pool, and means for reporting a performance profile for one or more of the periodic pools indicating the collections obtained.

24. A system according to claim 20 further wherein the central processing system includes means for receiving the master electronic record and for maintaining electronic financial accounting data on each periodic pool.

25. A system according to claim 23 further wherein the central processing systems includes means for receiving collections data from a third party and means for reconciling collection data from the third party with the collection data for each periodic pool for which financial accounting data is maintained on the central processing system.

23. A system for processing electronic accounts receivable records each specifying an account receivable recorded in one or more computer systems for the seller of the account receivable, each accounts receivable record including (i) a date field specifying a date for the account receivable, and (ii) a financial data portion specifying an amount billed to be paid by a payor and an amount paid on the corresponding amount billed, comprising:

means for searching the accounts receivable records and identifying records that have a date specified in the date field of the record within a predetermined period to identify a periodic pool of account receivables representing a corresponding periodic pool of accounts receivable;

means for creating a new electronic periodic pool record corresponding to a periodic pool of accounts receivable that have not yet had an amount advanced against them by a third party;

means for recording a pool advance amount in a field of the new electronic periodic pool record representing an amount to be advanced against a value of the periodic pool of the accounts receivable;

means for searching the accounts receivable records for records corresponding to periodic pools of accounts receivable other than those corresponding to the new periodic pool record, and for determining a total amount paid for each of the other periodic pools from the accounts receivable records corresponding to the other periodic pools; and

means for transferring a master electronic record to a central processing system, the master electronic record including the pool advance amount specified in the new electronic periodic pool record and an amount collected for each of the other periodic pools which showed collections in the accounts receivable records.

26. A system for processing electronic accounts receivable records each specifying an account receivable originating in one or more accounting systems for a seller of the account receivable, each accounts receivable record including (i) a date field specifying a date for the account receivable, and (ii) a financial data portion specifying an amount billed to be paid by a payor and an amount paid on the corresponding amount billed, comprising:

means located at the seller'"'"'s location for transmitting accounts receivable records to an electronic data interchange system; and

processing means including;

(a) means for receiving accounts receivable records from the electronic data interchange system and for searching the accounts receivables records and identifying records that have a date specified in the date field of the record within a predetermined period to identify a periodic pool of accounts receivables representing a corresponding periodic pool of accounts receivable;

(b) means for creating a new electronic periodic pool record corresponding to a periodic pool of accounts receivables that have not yet had an amount advanced against them by a third party;

(c) means for recording a pool advance amount in a field of the new electronic periodic pool record representing an amount to be advanced against a value of the periodic pool of accounts receivable;

(d) means for searching the accounts receivable records for records corresponding to periodic pools of accounts receivables other than those corresponding to the new periodic pool record, and for determining a total amount paid for each of the other periodic pools from the accounts receivable records corresponding to the other periodic pools; and

(e) means for transmitting a master electronic record to a central processing system, the master electronic record including the pool advance amount specified in the new electronic periodic pool record and an amount collected for each of the other periodic pools which showed collections in the accounts receivable records.