Expenditure management system, method and recording media

• US 20020049754A1
• Filed: 08/14/2001
• Published: 04/25/2002
• Est. Priority Date: 08/18/2000
• Status: Abandoned Application

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Ohsako, Akinori
• Application Number:
  US09/929,797
• Publication Number:
  US 20020049754A1
• Time in Patent Office: Days
• US Class Current: 707/3
• CPC Class Codes: G06Q 40/02 Banking, e.g. interest calculation or account maintenance credit or loans G06Q40/03

Abstract

Provides expenditure management methods and systems for performing the handling of consumption tax and for performing various kinds of management by creating master data for appropriation and write-off of expenditures and master data for transfer within an organization. One system for managing expenditure for automatic transfer service of rates includes: a detail data input section; a pre-journalizing details database for storing this detail data; a master database for storing master data; a data collation and journalizing section for collating the detail data with the master data and creating journal data; and an appropriation database and transfer journal database for storing the journal data. It creates journal data according to contents of processing for the expenditure management, while the master database stores multiple kinds of master data depending on the multiple kinds of journal data created by the data collation and journalizing section.

Claims

1. An expenditure management system for managing expenditure for an automatic transfer service of rates, comprising:

a detail data input section for inputting detail data about said rates;

a pre-journalizing details database for storing said detail data input at said detail data input section;

a master database for storing master data used for journalizing on the basis of collation with said detail data;

a data collation and journalizing section for collating said detail data stored in said pre-journalizing details database with said master data stored in said master database and creating journal data; and

a journal database for storing said journal data created at said data collation and journalizing section,

wherein said data collation and journalizing section creates multiple kinds of journal data according to the contents of processing for the expenditure management, while said master database stores multiple kinds of master data depending on said multiple kinds of journal data created by said data collation and journalizing section.

2. The expenditure management system according to claim 1, further comprising a data format conversion section that converts the detail data input at said detail data input section into a unified data format, wherein said pre-journalizing details database stores the detail data converted in said data format conversion section.

3. The expenditure management system according to claim 2, wherein said data format conversion section converts the detail data input at said detail data input section into a data format that includes at least a transfer key, an amount for each transfer key, and identification data showing a kind of data that was classified according to journalizing by said data collation and journalizing section.

4. The expenditure management system according to claim 1, wherein said master database storing:

a first master data that manages a total amount of main body that does not include consumption tax within the rates in said detail data, which is used for appropriation and write-off of expenditures as processing in the expenditure management; and

a second master data that manages an amount for each transfer key in said detail data, which is used for transfer as processing in the expenditure management.

17. A computer program product comprising a computer usable medium having computer readable program code means embodied therein for causing the expenditure management system for managing expenditure for an automatic transfer service of rates, the computer readable program code means in said computer program product comprising computer readable program code means for causing a computer to effect the functions of claim 1.

5. An expenditure management system for managing expenditure for an automatic transfer service of rates, comprising:

detail data storing means for storing detail data about rates; and

journalizing means for journalizing said detail data,

wherein said detail data storing means classifies said detail data into data for each transfer key, data about a total amount of main body that does not include consumption tax, and data about total consumption tax and storing,

wherein said journalizing means collates master data prepared for collation with said detail data according to the contents of journalizing with data necessary for the journalizing within said detail data and performs journalizing.

6. The expenditure management system according to claim 5, said detail data storing means further classifies data for each said transfer key in said detail data into an amount subject to consumption tax and a nontaxable amount.

7. The expenditure management system according to claim 5, wherein said journalizing means collates data about said total amount of main body stored in said detail data storing means and data about said consumption tax with master data corresponding to data about said total amount of main body, thereby journalizing for appropriation and write-off of expenditures.

8. The expenditure management system according to claim 5, wherein said journalizing means collates data for each said transfer key stored in said detail data storing means with master data corresponding to data for said transfer key, thereby journalizing for transfer.

18. A computer program product comprising a computer usable medium having computer readable program code means embodied therein for causing the expenditure management system for managing expenditure for an automatic transfer service of rates, the computer readable program code means in said computer program product comprising computer readable program code means for causing a computer to effect the functions of claim 5.

9. A method for managing expenditure for an automatic transfer service of rates, comprising the steps of:

acquiring detail data about said rates;

creating a plurality of master data according to contents of journalizing, wherein the master data is used for journalizing on the basis of collation with said detail data; and

collating said detail data with said master data and creating multiple kinds of journal data according to contents of processing in the expenditure management.

10. The method according to claim 9, further comprising:

after the step of acquiring detail data, the step of converting the acquired detail data into a unified data format.

11. The method according to claim 9, further comprising:

after the step of acquiring detail data, the step of classifying the acquired detail data into data for each transfer key, data about a total amount of main body that does not include consumption tax, and data about total consumption tax.

12. The method according to claim 11, wherein the step of classifying the detail data further comprising the step of multiplying a total amount of main body subject to consumption tax within data for each transfer key in said detail data by a value corresponding to a consumption tax rate to calculate an amount of consumption tax for the data about total consumption tax.

13. The method according to claim 9, wherein the step of creating master data further comprises the steps of:

creating a first master data that manages a total amount of main body that does not include consumption tax within the rates in said detail data; and

creating a second master data that manages an amount for each transfer key in said detail data, and

wherein the step of creating journal data further comprises the steps of;

collating said detail data with said first master data to create journal data for appropriation and write-off of expenditures; and

collating said detail data with said second master data to create journal data for transfer.

15. The recording medium according to claim 14, the processing further comprising:

after the processing for acquiring detail data, processing for converting the acquired detail data into a unified data format.

16. The recording medium according to claim 14, the processing further comprising:

after the processing for acquiring detail data, processing for classifying the acquired detail data into data for each transfer key, data about a total amount of main body that does not include consumption tax, and data about total consumption tax.

19. An article of manufacture comprising a computer usable medium having computer readable program code means embodied therein for causing expenditure management for an automatic transfer service of rates, the computer readable program code means in said article of manufacture comprising computer readable program code means for causing a computer to effect the steps of claim 9.

20. A program storage device readable by machine, tangibly embodying a program of instructions executable by the machine to perform method steps for managing expenditure for an automatic transfer service of rates, said method steps comprising the steps of claim 9.

14. A recording medium storing a program readable by input means of a computer and causing the computer to execute the processing, the processing comprising:

processing for acquiring detail data about rates;

processing for acquiring a plurality of master data prepared according to contents of journalizing, wherein the master data is used for journalizing on the basis of collation with said detail data; and

processing for collating said detail data with said master data and creating multiple kinds of journal data according to contents of processing in the expenditure management.