Euro booking currency conversion method

• US 6,477,510 B1
• Filed: 03/15/1999
• Issued: 11/05/2002
• Est. Priority Date: 03/15/1999
• Status: Expired due to Fees

• Current Assignee: Andrew Johnson Incorporated
• Original Assignee: Andrew Johnson Incorporated
• Inventors: Johnson, Andrew P.
• Primary Examiner(s): Kramer, Dean J.
• Application Number:
  US09/268,592
• Time in Patent Office: 1,331 Days
• Field of Search: 705/30, 705/35, 705/33, 705/1, 705/400
• US Class Current: 705/30
• CPC Class Codes: G06Q 40/02 Banking, e.g. interest calculation or account maintenance credit or loans G06Q40/03
• CPC Class Codes: G06Q 40/12 Accounting

Abstract

This invention relates generally to multi-currency production ledgers, and more particularly to methods of converting multi-currency production ledgers to accommodate the unification of several national currencies by respective participating states into a single currency. In particular the invention relates to a method for use with a computer for converting an ongoing old corp production ledger processing with a participating currency, to an ongoing production ledger processing with a target currency, the old corp production ledger comprising an old master file including a plurality of old master file records, each old master file record comprising a key identifying the record, data fields and amount fields, wherein the conversion is accomplished by selecting a target currency, selecting a particular time period, creating a target currency master file that is substantially identical to the old currency master file, by creating a target currency corp record corresponding to each old currency master file corp record within the old currency master file except that the target currency corp records within the target master file hold zero balances and all participating transaction currency records and their book one equivalents within one old master file key are replaced by a single target transaction record and its book one equivalent, converting the amounts of all transaction currency records and their book one equivalents for the selected time period into their corresponding target currency equivalent amounts, rounding the target currency equivalent amounts, and populating the target currency corp records within the target master file with the corresponding rounded target currency equivalent amounts.

Claims

1. A method for use with a computer for converting an ongoing old corp production ledger processing with a participating currency, to an ongoing production ledger processing with a target currency, said old corp production ledger comprising an old master file including a plurality of old master file records, each old master file record comprising a key identifying the record, data fields and amount fields, said method comprising the steps of:

a. selecting a target currency,

b. selecting a particular time period,

c. providing a target currency master file that is substantially identical to the old currency master file, by creating a target currency corp record corresponding to each old currency master file corp record within the old currency master file except that the target currency corp records within the target master file hold zero balances and all participating transaction currency records and their book one equivalents within one old master file key are replaced by a single target transaction record and its book one equivalent,

d. converting the amounts of all transaction currency records and their book one equivalents for the selected time period into their corresponding target currency equivalent amounts,

e. rounding said target currency equivalent amounts, wherein the step of rounding the target currency equivalent amounts comprises the steps of;

i. creating second dimensional rounding entries for year-to-date balances through each accounting period within each target currency transaction currency records and book one equivalents within said target master file, and

ii. creating a master file maintenance audit trail report, and

f. populating the target currency corp records within the target master file with the corresponding rounded target currency equivalent amounts.

2. The method according to claim 1, wherein the particular time period selected is the prior year.

3. The method according to claim 1, wherein the particular time period selected is the current year.

4. The method according to claim 1, wherein the particular time period selected is a future year.

5. The method according to claim 1, wherein the step of creating second dimensional rounding entries comprises the steps of:

a. providing transaction currency records and its book one equivalent in old currency corps;

b. determining said old currency corp'"'"'s currency code,

c. determining a target currency conversion rate corresponding to said old currency corp'"'"'s currency,

d. determining said old currency corp'"'"'s corresponding converted target currency corp equivalent,

e. determining the next master file record, its corresponding master file key and its corresponding currency code,

f. storing said next master file key and its corresponding currency code, and

g. determining whether said converted target currency corp equivalent is a participating currency corp book one equivalent.

6. The method according to claim 5, further comprising the steps of:

a. determining the sum of period 01 through each accounting and adjustment period,

b. determining the difference between each accounting period'"'"'s old currency corp accumulated participating year-to-date balance and the corresponding target currency corp year-to-date balance,

c. creating a first master file maintenance transaction, and

d. populating said first master file maintenance transaction for each accounting period with a target currency corp name, its corresponding master file key and the target currency as the currency code.

7. The method according to claim 5, further comprising the steps of:

a. determining the sum of period 01 through each accounting and adjustment period,

b. comparing the target currency corp records with its corresponding old currency corp master file key and its corresponding currency code,

c. determining the year-to-date balances for each period in the target currency corp through each accounting and adjustment period,

d. determining the difference between each accounting period'"'"'s old currency corp year-to-date balance converted to the target currency and the corresponding target currency corp year-to-date balance,

e. creating a second master file maintenance transaction,

f. populating said second master file maintenance transaction for each accounting period with a target currency corp name, its corresponding master file key and its corresponding currency code, and

g. determining whether more records exists in the current master file key.

8. The method according to claim 6 or 7, further comprising the step of determining whether any participating currency book one equivalents exist within the current master file key.

9. The method according to claim 8, further comprising the step of determining whether more master file keys exist within the current corp record.

10. The method according to claim 8, further comprising the step of

a. providing the corresponding target currency records,

b. applying the old currency corp'"'"'s master file key,

c. using the target currency book one equivalent as the currency code, and determining the year-to-date balance for each period in the target currency corp through each accounting and adjustment period.

11. The method according to claim 9, further comprising the step of

determining the existence of any corp records not converted into the target currency.

12. The method according to claim 1, wherein the step of rounding the target currency equivalents comprises the steps of:

a. creating third dimensional rounding entries for year-to-date balances through each accounting period within each target currency transaction currency records and its book one equivalent corp records within said target master file, and

b. providing transaction currency records and their book one equivalents in old currency corps.

13. The method according to claim 12, further comprising the step of

distinguishing between euro book one currency corps and old book one currency corps.

14. The method according to claim 13, further comprising the steps of:

a. determining said old book one currency corp'"'"'s currency code,

b. determining a target currency conversion rate corresponding to said old currency corp'"'"'s currency,

c. determining said old currency corp'"'"'s corresponding converted target currency corp equivalent, and

d. storing said next master file key and its corresponding currency code.

15. The method according to claim 14, further comprising the step of:

determining the next book one record.

16. The method according to claim 13 or 15, further comprising the step of:

a. distinguishing between balance sheet records and income statement records,

b. distinguishing between an asset type record and a liability type record,

c. distinguishing between an income type record and an expense type record,

d. calculating the sum of balance sheet records for period 00 through each accounting and adjustment period,

e. loading the sum of balance sheet records for period 00 through each accounting and adjustment period into the memory of the computer,

f. calculating the quotient of balance sheet records for each accounting and adjustment period YTD divided by the amount of the book one rate,

g. loading said quotient into the memory of the computer,

h. calculating the sum of incomes statement records for period 01 through each accounting and adjustment period,

i. loading said sum of income statement records into the memory of the computer, and

j. calculating the quotient of the income statement records for each accounting and adjustment period YTD divided by the amount of the book one rate.

17. The method according to claim 16, further comprising the step of determining whether more book one records exist in said old corp.

18. The method according to claim 17, further comprising the steps of:

a. determining a participating net balance sheet, participating net income and a participating currency net corp balance,

b. determining a euro net balance sheet, a euro net income statement and a euro net corp balance sheet, and

c. determining euro master file net balance sheet, a euro master file net income statement, and a euro net corp balance.

19. The method according to claim 1 wherein said old currency master-file corp records include participating and non-participating currency records.

20. The method according to claim 19, wherein the step of rounding the euro equivalent amounts further comprises the steps of:

a. creating third dimensional rounding entries for year-to-date balances through each accounting period within each euro currency transaction currency record and its book one equivalent corp records within said euro master file, and

b. providing transaction currency records and their book one equivalents in old currency corps.

21. A method for use on a general purpose computer for converting an ongoing old corp production ledger processing in a participating currency to an ongoing production ledger processing in euros, said old corp production ledger comprising an old master file including a plurality of old master file records, each old master file record comprising a key identifying the record, data fields and amount fields, said method comprising the steps of:

a. selecting a particular time period,

b. creating a euro master file that is substantially identical to the old currency master file, by creating a euro master file containing at least one euro corp record corresponding to each old currency master file corp record within the old currency master file except that the euro corp records within the euro master file hold zero balances and all participating transaction currency records and their book one equivalents within one old master file key are replaced by a single target transaction currency record and its book one equivalent,

c. converting the amounts of all transaction currency records and their book one equivalents for the selected time period into their corresponding euro equivalent amounts,

d. rounding said euro equivalent amounts, wherein the step of rounding the euro equivalent amounts comprises the steps of;

i. creating second dimensional rounding entries for year-to-date balances through each accounting period within each target currency transaction currency records and book one equivalents within said euro master file, and

ii. creating a euro master file maintenance audit trail report, and

e. populating the euro master file corp records within the euro master file with the corresponding rounded euro currency equivalent amounts.

22. A general purpose computer programmed for automatically correcting intra record accumulation of rounding errors occurring during the conversion of a booking ledger from a participating currency to a target currency, the general purpose computer comprising:

a. means for creating second dimensional rounding entries for year-to-date balances through each accounting period within each target currency transaction currency records and its book one equivalent within a target master file,

b. means for creating a master file maintenance audit trail report,

c. means for providing transaction currency records and their book one equivalents in old currency corps;

d. means for determining said old currency corp'"'"'s currency code,

e. means for determining a target currency conversion rate corresponding to said old currency corp'"'"'s currency,

f. means for determining said old currency corp'"'"'s corresponding converted target currency corp equivalent,

g. means for determining the next master file record, its corresponding master file key and its corresponding currency code,

h. means for storing said next master file key and its corresponding currency code,

i. means for determining whether said converted target currency corp equivalent is a participating currency corp book one equivalent,

j. a first means for determining the sum of period 01 through each accounting and adjustment period,

k. means for determining the difference between each accounting period'"'"'s old currency corp accumulated participating year-to-date balance and the corresponding target currency corp year-to-date balance,

l. means for creating a first master file maintenance transaction,

m. means for populating said first master file maintenance transaction for each accounting period with a target currency corp name, its corresponding master file key and the target currency as the currency code,

n. means for comparing the target currency corp records with its corresponding old currency corp master file key and its corresponding currency code,

o. means for determining the year-to-date balances for each period in the target currency corp through each accounting and adjustment period,

p. means for determining the difference between each accounting period'"'"'s old currency corp year-to-date balance converted to the target currency and the corresponding target currency corp year-to-date balance,

q. means for creating a second master file maintenance transaction,

r. means for populating said second master file maintenance transaction for each accounting period with a target currency corp name, its corresponding master file key and its corresponding currency code,

s. means for determining whether more records exists in the current master file key,

t. means for determining whether any participating currency book one equivalents exist within the current master file key,

u. means for determining whether more master file keys exist within the current corp record,

v. means for providing the corresponding target currency records,

w. means for applying the old currency corp'"'"'s master file key,

x. means for using the target currency book one equivalent as the currency code,

y. means for determining the year-to-date balance for each period in the target currency corp through each accounting and adjustment period, and

z. means for determining the existence of any corp records not converted into the target currency.

24. The computer according to claim 22 or 23, wherein the target is the euro.

23. A general purpose computer programmed for automatically correcting intra ledger accumulation of rounding errors occurring during the conversion of a booking ledger from a participating currency to a target currency, the general purpose computer comprising:

a. means for creating third dimensional rounding entries for year-to-date balances through each accounting period within each target currency transaction currency record and its book one equivalent within a target master file,

b. means for providing transaction currency records and their book one equivalents in old currency corps,

c. means for distinguishing between euro book one currency corp'"'"'s and old book one currency corps,

d. means for determining said old book one currency corps currency code,

e. means for determining a target currency conversion rate corresponding to said old currency corp'"'"'s currency,

f. means for determining said old currency corp'"'"'s corresponding converted target currency corp equivalent,

g. means for storing said next master file key and its corresponding currency code,

h. means for determining the next book one record,

i. means for distinguishing between balance sheet records and income statement records,

j. means for distinguishing between an asset type record and a liability type record,

k. means for distinguishing between an income type record and an expense type record,

l. means for calculating the sum of balance sheet records for period 00 through each accounting and adjustment period,

m. means for loading the sum of balance sheet records for period 00 through each accounting and adjustment period into the memory of the computer,

n. means for calculating the quotient of balance sheet records for each accounting and adjustment period YTD divided by the amount of the book one rate,

o. means for loading said quotient into the memory of the computer,

p. means for calculating the sum of incomes statement records for period 01 through each accounting and adjustment period,

q. means for loading said sum of income statement records into the memory of the computer,

r. means for calculating the quotient of the income statement records for each accounting and adjustment period YTD divided by the amount of the book one rate,

s. means for determining whether more book one records exist in said old corp,

t. means for determining a participating net balance sheet, participating net income and a participating currency net corp balance, and

u. means for determining a euro net balance sheet, a euro net income statement and a euro net corp balance sheet,

v. means for determining euro master file net balance sheet, a euro master file net income statement, and a euro net corp balance.

25. A method for use with a computer for converting an ongoing old corp production ledger processing with a participating currency, to an ongoing production ledger processing with a target currency, said old corp production ledger comprising an old master file including a plurality of old master file records, each old master file record comprising a key identifying the record, data fields and amount fields, said method comprising the steps of:

a. selecting a target currency,

b. selecting a particular time period,

c. providing a target currency master file that is substantially identical to the old currency master file,

d. creating a target currency corp record corresponding to each old currency master file corp record within the old currency master file,

c. populating the target currency corp records within the target master file with zero balances,

f. replacing all participating transaction currency records and their book one equivalents within one old master file key with a single target transaction record and its book one equivalent,

g. converting the amounts of all transaction currency records and their book one equivalents for the selected time period into their corresponding target currency equivalent amounts,

h. rounding said target currency equivalent amounts wherein the step of rounding the target currency equivalent amounts comprises the steps of;

i. creating second dimensional rounding entries for year-to-date balances through each accounting period within each target currency transaction currency records and book one equivalents within said target master file, and

ii. creating a master file maintenance audit trail report, and

i. populating the target currency corp records within the target master file with the corresponding rounded target currency equivalent amounts.

26. The method according to claim 25, wherein the step of rounding the target currency equivalents further comprises the steps of:

a. creating third dimensional rounding entries for year-to-date balances through each accounting period within each target currency transaction currency records and its book one equivalent corp records within said target master file, and

b. providing transaction currency records and their book one equivalents in old currency corps.