CN111047430B - Accounting information processing method and device - Google Patents
Accounting information processing method and device Download PDFInfo
- Publication number
- CN111047430B CN111047430B CN201911240154.7A CN201911240154A CN111047430B CN 111047430 B CN111047430 B CN 111047430B CN 201911240154 A CN201911240154 A CN 201911240154A CN 111047430 B CN111047430 B CN 111047430B
- Authority
- CN
- China
- Prior art keywords
- accounting
- transaction
- information
- files
- file
- 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.)
- Active
Links
- 230000010365 information processing Effects 0.000 title claims abstract description 66
- 238000003672 processing method Methods 0.000 title claims abstract description 36
- 238000000034 method Methods 0.000 claims abstract description 43
- 238000012545 processing Methods 0.000 claims description 61
- 230000008569 process Effects 0.000 claims description 26
- 238000012546 transfer Methods 0.000 claims description 18
- 238000004590 computer program Methods 0.000 claims description 14
- 238000003860 storage Methods 0.000 claims description 12
- 238000004364 calculation method Methods 0.000 claims description 2
- 238000004891 communication Methods 0.000 description 17
- 230000006870 function Effects 0.000 description 16
- 238000010586 diagram Methods 0.000 description 10
- 230000007246 mechanism Effects 0.000 description 7
- 230000005540 biological transmission Effects 0.000 description 6
- 239000000872 buffer Substances 0.000 description 4
- 238000003032 molecular docking Methods 0.000 description 3
- 238000009966 trimming Methods 0.000 description 3
- 238000006243 chemical reaction Methods 0.000 description 2
- 238000012423 maintenance Methods 0.000 description 2
- 230000009471 action Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000001413 cellular effect Effects 0.000 description 1
- 230000002354 daily effect Effects 0.000 description 1
- 238000001212 derivatisation Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000003203 everyday effect Effects 0.000 description 1
- 239000011521 glass Substances 0.000 description 1
- 210000001503 joint Anatomy 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000010295 mobile communication Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
- 238000011084 recovery Methods 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
- 230000001360 synchronised effect Effects 0.000 description 1
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
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/12—Accounting
- G06Q40/125—Finance or payroll
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/11—File system administration, e.g. details of archiving or snapshots
- G06F16/116—Details of conversion of file system types or formats
-
- 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
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/02—Banking, e.g. interest calculation or account maintenance
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Development Economics (AREA)
- Technology Law (AREA)
- Strategic Management (AREA)
- General Business, Economics & Management (AREA)
- Marketing (AREA)
- Economics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The embodiment of the application provides an accounting information processing method and device, wherein the method comprises the following steps: generating a corresponding accounting entry by a secondary update log corresponding to the online application transaction information, and splitting the accounting entry to obtain a corresponding online transaction accounting document; when the core banking system is in a day-end state, batch generating transaction detail files of the same day and accounting files of both lending and borrowing parties; and summarizing the accounting files of the online transaction and the accounting files of the lending parties to obtain corresponding general ledger interface files, and outputting the general ledger interface files. According to the accounting system and the accounting method, accounting data information such as products and transactions of the core banking system can be transmitted to the accounting system from the core banking system according to the format required by the accounting system, and updating of the accounting general ledger is completed.
Description
Technical Field
The application relates to the technical field of data processing, in particular to an accounting information processing method and device.
Background
Currently, the accounting mode of the banking system generally adopts a parameter-driven online accounting splitting mode, namely: obtaining transaction control parameters such as transaction account attribution general account subjects, transaction co-institution opponent subjects, transaction cross-currency subjects, transaction cross-site subjects, transaction total amount entering direction, transaction total entering mode and the like, and then carrying out automatic splitting processing on bank accounts according to corresponding rules on transactions in various scenes according to the obtained transaction control parameters.
However, the parameter-driven online accounting splitting mode only considers the online financial transaction, provides a certain rule splitting to generate a corresponding accounting record, and cannot be started from a core banking system to provide a complete accounting framework.
Disclosure of Invention
Aiming at the problems in the prior art, the application provides an accounting information processing method and device, which can start from a core banking system, transmit accounting data information such as products, transactions and the like of the core banking system to an accounting system according to a format required by the accounting system, and finish updating an accounting general ledger.
In order to solve the technical problems, the application provides the following technical scheme:
in a first aspect, the present application provides an accounting information processing method, including:
generating a corresponding accounting entry by a secondary update log corresponding to the online application transaction information, and splitting the accounting entry to obtain a corresponding online transaction accounting document;
When the core banking system is in a day-end state, batch generating transaction detail files of the same day and accounting files of both lending and borrowing parties;
and summarizing the accounting files of the online transaction and the accounting files of the lending parties to obtain corresponding general ledger interface files, and outputting the general ledger interface files.
Further, before the secondary update log corresponding to the online application transaction information generates the corresponding accounting entry, the method further comprises:
converting the original transfer transaction into a plurality of derivative transactions based on the online transaction request of the current day;
updating the account main file and transaction detail information corresponding to each derivative transaction respectively by applying each derivative transaction;
and respectively outputting corresponding secondary update logs by applying each derived transaction, and retaining the original financial information corresponding to the original transfer transaction.
Further, the secondary update log corresponding to the online application transaction information generates a corresponding accounting entry, and splits the accounting entry to obtain an accounting file of the corresponding online transaction, including:
splitting secondary update logs output by each derived transaction one by one to obtain corresponding accounting records;
And merging the accounting records to obtain the corresponding accounting files of the online transaction.
Further, when the core banking system is in the end-of-day state, the batch generation of the transaction details file and the accounting file of both the lending party of the current day of the core banking system includes:
when the core banking system is in a day-end state, generating transaction detail files and accounting files of both lending parties of the current day of the core banking system in batches based on preset parameter information;
wherein the parameter information includes at least one of transaction code, product information, and account information.
Further, the step of summarizing the accounting files of the online transaction and the accounting files of the lending parties to obtain corresponding general ledger interface files includes:
respectively extracting information from the accounting files of the online transaction and the accounting files of the lending parties on the same day to obtain a reconciliation text of a contract or an account;
and summarizing the account checking text based on a preset large class to generate a general account interface file of the current day.
Further, the broad class includes: institution information, currency information, subject information, and product information.
Further, the outputting the general ledger interface file includes:
processing accounting records in the general ledger interface file;
and transmitting the accounting data information in the processed general ledger interface file to a corresponding reconciliation system for reconciliation processing.
In a second aspect, the present application provides an accounting information processing device, including:
the online accounting entry generation module is used for generating a corresponding accounting entry by the secondary update log corresponding to the online application transaction information and splitting the accounting entry to obtain a corresponding online transaction accounting document;
the batch accounting entry generation module is used for generating transaction detail files of the core banking system on the same day and accounting files of lending parties in batches when the core banking system is in a final day state;
and the summarizing and outputting total module is used for summarizing the accounting files of the online transaction and the accounting files of the lending parties to obtain corresponding general ledger interface files and outputting the general ledger interface files.
Further, the system also comprises a secondary update log generation module, wherein the secondary update log generation module is used for executing the following contents:
Converting the original transfer transaction into a plurality of derivative transactions based on the online transaction request of the current day;
updating the account main file and transaction detail information corresponding to each derivative transaction respectively by applying each derivative transaction;
and respectively outputting corresponding secondary update logs by applying each derived transaction, and retaining the original financial information corresponding to the original transfer transaction.
Further, the online accounting entry generation module is configured to perform the following:
splitting secondary update logs output by each derived transaction one by one to obtain corresponding accounting records;
and merging the accounting records to obtain the corresponding accounting files of the online transaction.
Further, the batch accounting entry generation module is configured to perform the following:
when the core banking system is in a day-end state, generating transaction detail files and accounting files of both lending parties of the current day of the core banking system in batches based on preset parameter information;
wherein the parameter information includes at least one of transaction code, product information, and account information.
Further, the summarizing and outputting total module includes:
the general ledger file collecting module of the current day is used for respectively extracting information from the accounting files of the online transaction of the current day and the accounting files of the lending parties to obtain the reconciliation text of the contract or the account; and summarizing the reconciliation texts based on a preset large class to generate a general ledger interface file of the current day.
Further, the broad class includes: institution information, currency information, subject information, and product information.
Further, the summarizing and outputting total module includes:
the file processing and downloading module is used for processing accounting entry in the general ledger interface file; and transmitting the accounting data information in the processed general ledger interface file to a corresponding reconciliation system for reconciliation processing.
In a third aspect, the present application provides an electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing the steps of the accounting information processing method when executing the program.
In a fourth aspect, the present application provides a computer-readable storage medium having stored thereon a computer program which, when executed by a processor, implements the steps of the accounting information processing method.
According to the technical scheme, the method and the device for processing the accounting information provided by the application, wherein the method is used for generating the corresponding accounting record by online application of the secondary update log corresponding to the transaction information, and splitting the accounting record to obtain the corresponding accounting file of the online transaction; when the core banking system is in a day-end state, batch generating transaction detail files of the same day and accounting files of both lending and borrowing parties; summarizing the accounting files of the online transaction and the accounting files of the lending parties to obtain corresponding general ledger interface files, outputting the general ledger interface files, starting from a core banking system through designing a secondary updating mechanism for accounting, transmitting accounting data information of products, transactions and the like of the core banking system to the accounting system according to a format required by the accounting system, completing updating of the accounting general ledger, further providing a complete accounting framework, forming final available accounting data, realizing butt joint with the accounting system, being suitable for online and batch multi-scene accounting information processing, and being more beneficial to improving centralized accounting processing capacity of the core bank.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings that are required in the embodiments or the description of the prior art will be briefly described, and it is obvious that the drawings in the following description are some embodiments of the present application, and other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
Fig. 1 is a flowchart of an accounting information processing method in an embodiment of the present application.
Fig. 2 is a flowchart illustrating steps 001 to 003 in the accounting information processing method according to the embodiment of the present application.
Fig. 3 is a flowchart illustrating a step 100 in the method for processing accounting information according to the embodiment of the present application.
Fig. 4 is a first flowchart of step 300 in the method for processing accounting information in the embodiment of the present application.
Fig. 5 is a second flowchart of step 300 in the method for processing accounting information according to the embodiment of the present application.
Fig. 6 is a schematic diagram of the overall structure of the accounting information processing device in the embodiment of the present application.
Fig. 7 is a detailed structural diagram of the accounting information processing device in the embodiment of the present application.
Fig. 8 is a flow chart of a billing process corresponding to two accounts exchange and easy transfer in the application example of the present application.
Fig. 9 is a schematic structural diagram of an electronic device in an embodiment of the present application.
Detailed Description
For the purposes of making the objects, technical solutions and advantages of the embodiments of the present application more clear, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is apparent that the described embodiments are some embodiments of the present application, but not all embodiments. All other embodiments, which can be made by one of ordinary skill in the art based on the embodiments herein without making any inventive effort, are intended to be within the scope of the present application.
In one or more embodiments of the present application, the Secondary Update refers to a process of generating accounting information (general ledger interface file) according to a transaction log and a certain processing rule after the financial transaction of the core banking system completes the account master file and the transaction details.
Compared with the synchronous updating of the client account and the accounting account in the traditional mode, the accounting processing of the core banking system is more centralized, all accounting records are generated through the splitting of the core banking system at the end of the day, and the accounting records are summarized and processed into the form of a general account interface file and then are reported to the general account so as to update the accounting general account.
In order to start from the core banking system and transmit accounting data information such as products, transactions and the like of the core banking system to the accounting system according to a format required by the accounting system to complete updating of an accounting general ledger, the application provides an embodiment of an accounting information processing method, referring to fig. 1, wherein the accounting information processing method specifically comprises the following contents:
step 100: generating a corresponding accounting entry by a secondary update log corresponding to the online application transaction information, and splitting the accounting entry to obtain a corresponding online transaction accounting document;
it will be appreciated that step 100 is an online accounting entry generation process, and may specifically include: and reading a transaction log table of the secondary update log, generating an accounting entry, and then splitting to generate an accounting document.
Step 200: when the core banking system is in a day end state, transaction detail files of the same day and accounting files of both lending and lending parties are generated in batches.
It will be appreciated that step 200 is a batch accounting entry generation process, which may specifically include: and in the final state of the system, generating a transaction detail file and a accounting file according to the accounting or reconciliation requirement.
Step 300: and summarizing the accounting files of the online transaction and the accounting files of the lending parties to obtain corresponding general ledger interface files, and outputting the general ledger interface files.
It may be appreciated that the step 300 may include a general ledger file summarizing process and a file processing downloading process, and the general ledger file summarizing process may specifically include: summarizing online and batched accounting files according to institutions, currencies, subjects and product categories, and taking the summarized accounting files as summary account interface files; the file processing downloading process specifically comprises the following steps: after trimming the summarized general ledger interface file, the core banking system can transmit the general ledger interface file to the reconciliation system in a CD mode.
In order to reliably and effectively generate the secondary update log to further improve the accuracy and reliability of the accounting entry generation process, a reliable data base is provided for accounting entry generation, and in an embodiment of an accounting information processing method of the present application, referring to fig. 2, before step 100 of the accounting information processing method, the following is further specifically included:
step 001: converting the original transfer transaction into a plurality of derivative transactions based on the online transaction request of the current day;
Step 002: updating the account main file and transaction detail information corresponding to each derivative transaction respectively by applying each derivative transaction;
step 003: and respectively outputting corresponding secondary update logs by applying each derived transaction, and retaining the original financial information corresponding to the original transfer transaction.
In order to further improve the efficiency and reliability of the secondary update process, in an embodiment of the accounting information processing method of the present application, referring to fig. 3, step 100 of the accounting information processing method specifically includes the following:
step 101: and splitting secondary update logs output by each derived transaction one by one to obtain corresponding accounting records.
Step 102: and merging the accounting records to obtain the corresponding accounting files of the online transaction.
In order to further improve the efficiency and accuracy of batch generation of the accounting files, in an embodiment of the accounting information processing method of the present application, the step 200 of the accounting information processing method specifically includes the following:
step 201: when the core banking system is in a day-end state, generating transaction detail files and accounting files of both lending parties of the current day of the core banking system in batches based on preset parameter information;
Wherein the parameter information includes at least one of transaction code, product information, and account information.
In order to further improve the reliability of the general ledger interface file, in an embodiment of the accounting information processing method of the present application, referring to fig. 4, step 300 of the accounting information processing method specifically includes the following:
step 301: and respectively extracting information from the accounting files of the online transaction and the accounting files of the lending parties on the same day to obtain the reconciliation text of the contract or the account.
Step 302: and summarizing the account checking text based on a preset large class to generate a general account interface file of the current day.
Wherein the broad class includes: institution information, currency information, subject information, and product information.
In order to further improve the reliability and effectiveness of outputting the general ledger interface file, in an embodiment of the accounting information processing method of the present application, referring to fig. 5, step 300 of the accounting information processing method further specifically includes the following:
step 303: processing accounting records in the general ledger interface file;
step 304: and transmitting the accounting data information in the processed general ledger interface file to a corresponding reconciliation system for reconciliation processing.
In order to transmit accounting data information such as products, transactions and the like of a core banking system from the software level to an accounting system according to a format required by the accounting system to complete updating of an accounting general account, the present application provides an embodiment of an accounting information processing device capable of implementing all or part of the content in the foregoing accounting information processing method, referring to fig. 6, where the accounting information processing device specifically includes:
the online accounting entry generation module 10 is configured to generate a corresponding accounting entry according to the secondary update log corresponding to the online application transaction information, and split the accounting entry to obtain an accounting document of the corresponding online transaction.
The batch accounting entry generation module 20 is configured to generate, in batch, a transaction detail file of a current day of the core banking system and an accounting file of both lending and lending when the core banking system is in a final day state.
And the summarizing and outputting total module 30 is configured to summarize the accounting files of the online transaction and the accounting files of the lending party, obtain a corresponding general ledger interface file, and output the general ledger interface file.
In order to reliably and effectively generate secondary update logs to further improve accuracy and reliability of an accounting entry generation process, a reliable data base is provided for accounting entry generation, and in an embodiment of an accounting information processing device of the present application, the accounting information processing device further specifically includes:
a secondary update log generation module for performing the following:
converting the original transfer transaction into a plurality of derivative transactions based on the online transaction request of the current day;
updating the account main file and transaction detail information corresponding to each derivative transaction respectively by applying each derivative transaction;
and respectively outputting corresponding secondary update logs by applying each derived transaction, and retaining the original financial information corresponding to the original transfer transaction.
In order to further improve the efficiency and reliability of the secondary update process, in an embodiment of the accounting information processing device of the present application, the online accounting entry generation module 10 of the accounting information processing device is specifically configured to perform the following:
splitting secondary update logs output by each derived transaction one by one to obtain corresponding accounting records;
And merging the accounting records to obtain the corresponding accounting files of the online transaction.
In order to further improve the efficiency and accuracy of batch generation of accounting documents, in an embodiment of an accounting information processing method of the present application, the batch accounting entry generation module 20 of the accounting information processing device is configured to perform the following:
when the core banking system is in a day-end state, generating transaction detail files and accounting files of both lending parties of the current day of the core banking system in batches based on preset parameter information;
wherein the parameter information includes at least one of transaction code, product information, and account information.
In order to further improve the reliability of the general ledger interface file, in an embodiment of the accounting information processing device of the present application, referring to fig. 7, the summary and output total module 30 of the accounting information processing method specifically includes the following:
the day general ledger file summarizing module 31 is configured to extract information from the account checking file of the online transaction and the account checking file of the lending party on the same day, respectively, to obtain reconciliation text of the contract or account; and summarizing the reconciliation texts based on a preset large class to generate a general ledger interface file of the current day.
Wherein the broad class includes: institution information, currency information, subject information, and product information.
In order to further improve the reliability and effectiveness of outputting the general ledger interface file, in an embodiment of the accounting information processing device of the present application, referring to fig. 7, the summary and output total module 30 of the accounting information processing device further specifically includes the following contents:
a document processing and downloading module 32, configured to process accounting entries in the general ledger interface document; and transmitting the accounting data information in the processed general ledger interface file to a corresponding reconciliation system for reconciliation processing.
In order to further explain the scheme, the application also provides a specific application example for implementing the accounting information processing method by using the accounting information processing device, which specifically comprises the following contents:
and (1) online accounting entry generation:
the online accounting entry generation module is used for generating general ledger accounting information (general ledger interface file).
After the online financial transaction is completed, the account master file is updated and the transaction details are written in, the transaction log table required by secondary update is written in, the transaction is checked in, and then the general ledger interface file information is generated through the secondary update.
Taking two account interchange transactions as an example, the posting process is shown in FIG. 8.
The specific process can be understood as follows:
1. after the on-line financial transaction is entered, the original transfer transaction is derived into transaction 1 and transaction 2.
2. Transaction 1 and transaction 2 update the data tables of account master file, transaction detail, etc. respectively.
3. Transaction 1 and transaction 2 write the respective preparation logs, i.e., transaction log tables, of the secondary updates, retaining the original financial information.
4. According to the transaction log table record 1 and the transaction log table record 2 output in the step 3, splitting accounting records one by one, wherein the main processing of the splitting records is divided into two steps, the first step is to acquire parameter information, which will not be described in detail, the second step is to split records according to the log records and the acquired parameter information, and finally merging to generate online inter-conversion accounting information.
5. When the splitting action is performed on the accounting entry, a situation that the transaction LOG table is split into errors possibly occurs, and at this time, an error system LOG (LOG) is required to be written into a secondary updated exception report, where the system LOG refers to a time-ordered collection of certain operations of an object specified by the system and operation results thereof.
And (II) batch accounting entry generation:
and the batch accounting entry generation module generates general ledger interface file information by batch accounting and accounting lifting.
The accounting entry sources processed in batch are, including billing, settlement, interest tax, conversion to non-billing, and completion of online transactions in a batch manner.
The process of batch generation of general ledger interface files basically follows a secondary updated public mechanism, and when the daily batch processing is finished, business processing or transaction detail generation is finished, meanwhile, general ledger interface file detail files corresponding to lending parties are generated, and each entry has strict sequence relation but does not write transaction log table records.
And (III) summarizing the general ledger file of the current day:
and the current day general ledger file summarizing module summarizes the reconciliation file according to 4 dimensions of institutions, currencies, subjects and large categories of products to generate the current day general ledger file.
And extracting information from online and batch-generated general ledger interface files every day, obtaining the checking text of a contract or an account, summarizing according to institutions, currencies, subjects and product categories, and generating a general ledger file of the same day, namely an increment general ledger of the same day, as the interface file of the general ledger.
And (IV) file processing downloading:
and the file processing downloading module downloads the general ledger file to a general ledger interface file processing system for subsequent processing.
Because the core banking system does not directly process accounting accounts, the system defines parameters, programs and files at the end of the day, so the core needs to trim accounting records in the general ledger interface file, and then transmits accounting data information such as products, transactions and the like to the general ledger interface file processing system in a CD downloading mode for subsequent reconciliation processing.
The CD is specifically IBM Sterling Connect:Direct, is a point-to-point (point-to-point) integrated middleware based on files, can provide high-security file transmission, is suitable for 24x365 unattended system environments, can provide safe, reliable, large-scale and high-capacity data exchange between enterprises, and can transmit files containing any type of data (text, EDI, binary, digital content and images). The dependence of enterprises on unreliable transmission such as File Transfer Protocol (FTP) is reduced. The solution based on Sterling Connect to Direct ensures more reliable file transfer and synchronization.
Sterling Connect: direct has the following characteristics:
1. reliable file transfer: providing automatic scheduling, checkpoint restart and automatic recovery functions helps ensure predictable, guaranteed file delivery.
2. Secure file transfer: helping to ensure customer information confidentiality and supporting legal compliance measures.
3. High performance: the most demanding workloads, ranging from a large number of small files to several gigabytes of files, can be handled.
That is, the specific process flow of the accounting information processing method may be:
step 1: and generating an online accounting entry, inputting an online transaction request of the same day, writing an account master file, transaction details and a transaction log table, and outputting split accounting information to a general ledger interface file.
The online accounting entry generation process comprises the steps of original transaction derivatization, transaction accounting, updating account master files and running lists, writing transaction log lists and splitting and merging the derivative transaction accounting entries.
Specifically, the original transaction is derived into N transactions, accounts and detail tables are respectively written, then the respective JNR is read to generate accounting records, and finally the accounting records are combined to be used as a unique general ledger interface file of the online transaction.
Step 2: batch accounting entry generation, batch processing requests such as counting, settling and the like are input, transaction details are output, and a general ledger interface file is generated.
And in the batch accounting entry generation process, business data such as charge and online account adjustment in batch transactions in the final state of the day are processed, and transaction details and debit and credit general account interface files are generated based on parameter information such as transaction codes, products and accounts.
Specifically, in the batch accounting entry generation process, JNR logs are not generated, and debit and credit general ledger interface files are generated by processing scenes and based on parameter information such as transaction codes, products and accounts.
Step 3: and (3) summarizing the general ledger file on the same day, taking the general ledger interface file generated in the step (1) and the step (2) as input, and outputting the summarized general ledger interface file.
And in the summary process of the general ledger documents on the same day, the online and batch generated general ledger documents are summarized according to the organizations, the currencies, the subjects and the product classes.
Specifically, the general ledger interface file summarizing element comprises four items of institutions, currencies, subjects and products.
Step 4: and (3) downloading the file processing, balancing the general ledger interface file in the step (3) by taking the general ledger interface file as input, and transmitting the balancing result to the ITGS in a CD mode of a core system.
And in the file processing and downloading process, the core bank system performs trimming processing on the general ledger file and finally transmits the trimming processing to the ITGS in a CD mode.
Specifically, a general ledger interface file processing method is applied to perform accounting balancing processing on the summarized general ledger interface file; and the communication mode between the core bank system and the ITGS is CD transmission by applying the general ledger interface file downloading method.
As can be seen from the above description, the secondary update method for accounting provided by the application example of the present application designs a secondary update mechanism for accounting, which can start from a core banking system, transmit accounting data information such as products and transactions of the core banking system to an accounting system according to a format required by the accounting system, complete updating of an accounting general account, further provide a complete accounting framework, form final available accounting data, realize docking with the accounting system, be applicable to online and batch multi-scene accounting information processing, and be more helpful for improving centralized accounting processing capability of the core bank. The specific advantages are as follows:
1. the secondary updating function is strong, and the general ledger interface files generated by the online mode and the batch mode are processed, so that all the calculation information of the core banking system can be covered.
2. The compatibility is strong, and when financial transactions are newly added or financial transaction accounting is adjusted, a secondary updating mechanism is satisfied, and independent configuration is not needed.
3. The development cost is low, and the data updating, entry splitting and merging, file extracting and processing and CD transmission adopted by the patent can be realized by programs without other hardware cost.
4. The maintenance is simple, the automation degree of the mechanism is higher, an exceptional report is provided for JNR splitting exception, and the maintenance difficulty is low.
In summary, the application of the present application can provide a complete secondary update framework, which is suitable for online and batch multi-scene accounting information processing, and is more conducive to improving the centralized accounting processing capability of the core bank.
In order to transmit accounting data information such as products, transactions and the like of a core banking system from the hardware level to an accounting system according to a format required by the accounting system to complete updating of an accounting general ledger, the application provides an embodiment of an electronic device for realizing all or part of contents in the accounting information processing method, wherein the electronic device specifically comprises the following contents:
a processor (processor), a memory (memory), a communication interface (Communications Interface), and a bus; the processor, the memory and the communication interface complete communication with each other through the bus; the communication interface is used for realizing information transmission between the accounting information processing device and related equipment such as a core banking system, a reconciliation system, a user terminal, a related database and the like; the logic controller may be a desktop computer, a tablet computer, a mobile terminal, etc., and the embodiment is not limited thereto. In this embodiment, the logic controller may refer to an embodiment of the method for processing accounting information in the embodiment, and an embodiment of the apparatus for processing accounting information is implemented, and the contents thereof are incorporated herein, and the details thereof will not be repeated.
It is understood that the user terminal may include a smart phone, a tablet electronic device, a network set top box, a portable computer, a desktop computer, a Personal Digital Assistant (PDA), a vehicle-mounted device, a smart wearable device, etc. Wherein, intelligent wearing equipment can include intelligent glasses, intelligent wrist-watch, intelligent bracelet etc..
In practical applications, the part of the accounting information processing may be performed on the electronic device side as described above, or all operations may be performed in the client device. Specifically, the selection may be made according to the processing capability of the client device, and restrictions of the use scenario of the user. The present application is not limited in this regard. If all operations are performed in the client device, the client device may further include a processor.
The client device may have a communication module (i.e. a communication unit) and may be connected to a remote server in a communication manner, so as to implement data transmission with the server. The server may include a server on the side of the task scheduling center, and in other implementations may include a server of an intermediate platform, such as a server of a third party server platform having a communication link with the task scheduling center server. The server may include a single computer device, a server cluster formed by a plurality of servers, or a server structure of a distributed device.
Fig. 9 is a schematic block diagram of a system configuration of an electronic device 9600 of an embodiment of the present application. As shown in fig. 9, the electronic device 9600 may include a central processor 9100 and a memory 9140; the memory 9140 is coupled to the central processor 9100. Notably, this fig. 9 is exemplary; other types of structures may also be used in addition to or in place of the structures to implement telecommunications functions or other functions.
In one embodiment, the accounting information processing functions may be integrated into the central processor 9100. The central processor 9100 may be configured to perform the following control:
step 100: generating a corresponding accounting entry by a secondary update log corresponding to the online application transaction information, and splitting the accounting entry to obtain a corresponding online transaction accounting document;
step 200: when the core banking system is in a day end state, transaction detail files of the same day and accounting files of both lending and lending parties are generated in batches.
Step 300: and summarizing the accounting files of the online transaction and the accounting files of the lending parties to obtain corresponding general ledger interface files, and outputting the general ledger interface files.
As can be seen from the above description, by designing a secondary update mechanism for accounting, the electronic device provided in the embodiments of the present application can start from a core banking system, transmit accounting data information such as products and transactions of the core banking system to an accounting system according to a format required by the accounting system, complete updating of an accounting general account, further provide a complete accounting framework, form final available accounting data, and realize docking with the accounting system, which is suitable for online and batch multi-scenario accounting information processing, and is more conducive to improving centralized accounting processing capability of the core bank.
In another embodiment, the accounting information processing device may be configured separately from the central processor 9100, for example, the accounting information processing device may be configured as a chip connected to the central processor 9100, and the accounting information processing function is implemented by control of the central processor.
As shown in fig. 9, the electronic device 9600 may further include: a communication module 9110, an input unit 9120, an audio processor 9130, a display 9160, and a power supply 9170. It is noted that the electronic device 9600 need not include all of the components shown in fig. 9; in addition, the electronic device 9600 may further include components not shown in fig. 9, and reference may be made to the related art.
As shown in fig. 9, the central processor 9100, sometimes referred to as a controller or operational control, may include a microprocessor or other processor device and/or logic device, which central processor 9100 receives inputs and controls the operation of the various components of the electronic device 9600.
The memory 9140 may be, for example, one or more of a buffer, a flash memory, a hard drive, a removable media, a volatile memory, a non-volatile memory, or other suitable device. The information about failure may be stored, and a program for executing the information may be stored. And the central processor 9100 can execute the program stored in the memory 9140 to realize information storage or processing, and the like.
The input unit 9120 provides input to the central processor 9100. The input unit 9120 is, for example, a key or a touch input device. The power supply 9170 is used to provide power to the electronic device 9600. The display 9160 is used for displaying display objects such as images and characters. The display may be, for example, but not limited to, an LCD display.
The memory 9140 may be a solid state memory such as Read Only Memory (ROM), random Access Memory (RAM), SIM card, etc. But also a memory which holds information even when powered down, can be selectively erased and provided with further data, an example of which is sometimes referred to as EPROM or the like. The memory 9140 may also be some other type of device. The memory 9140 includes a buffer memory 9141 (sometimes referred to as a buffer). The memory 9140 may include an application/function storage portion 9142, the application/function storage portion 9142 storing application programs and function programs or a flow for executing operations of the electronic device 9600 by the central processor 9100.
The memory 9140 may also include a data store 9143, the data store 9143 for storing data, such as contacts, digital data, pictures, sounds, and/or any other data used by an electronic device. The driver storage portion 9144 of the memory 9140 may include various drivers of the electronic device for communication functions and/or for performing other functions of the electronic device (e.g., messaging applications, address book applications, etc.).
The communication module 9110 is a transmitter/receiver 9110 that transmits and receives signals via an antenna 9111. A communication module (transmitter/receiver) 9110 is coupled to the central processor 9100 to provide input signals and receive output signals, as in the case of conventional mobile communication terminals.
Based on different communication technologies, a plurality of communication modules 9110, such as a cellular network module, a bluetooth module, and/or a wireless local area network module, etc., may be provided in the same electronic device. The communication module (transmitter/receiver) 9110 is also coupled to a speaker 9131 and a microphone 9132 via an audio processor 9130 to provide audio output via the speaker 9131 and to receive audio input from the microphone 9132 to implement usual telecommunications functions. The audio processor 9130 can include any suitable buffers, decoders, amplifiers and so forth. In addition, the audio processor 9130 is also coupled to the central processor 9100 so that sound can be recorded locally through the microphone 9132 and sound stored locally can be played through the speaker 9131.
The embodiments of the present application also provide a computer-readable storage medium capable of implementing all the steps in the accounting information processing method in which the execution subject is a server or a client in the above embodiments, the computer-readable storage medium storing thereon a computer program which, when executed by a processor, implements all the steps in the accounting information processing method in which the execution subject is a server or a client in the above embodiments, for example, the processor implements the following steps when executing the computer program:
step 100: generating a corresponding accounting entry by a secondary update log corresponding to the online application transaction information, and splitting the accounting entry to obtain a corresponding online transaction accounting document;
step 200: when the core banking system is in a day end state, transaction detail files of the same day and accounting files of both lending and lending parties are generated in batches.
Step 300: and summarizing the accounting files of the online transaction and the accounting files of the lending parties to obtain corresponding general ledger interface files, and outputting the general ledger interface files.
As can be seen from the above description, the computer readable storage medium provided in the embodiments of the present application, by designing a secondary update mechanism for accounting, can start from a core banking system, transmit accounting data information such as products and transactions of the core banking system to an accounting system according to a format required by the accounting system, and complete updating of an accounting general account, thereby providing a complete accounting framework, forming final available accounting data, realizing docking with the accounting system, being suitable for online and batch multi-scenario accounting information processing, and being more conducive to improving centralized accounting processing capability of the core bank.
It will be apparent to those skilled in the art that embodiments of the present invention may be provided as a method, apparatus, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (devices), and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flowchart illustrations and/or block diagrams, and combinations of flows and/or blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
The principles and embodiments of the present invention have been described in detail with reference to specific examples, which are provided to facilitate understanding of the method and core ideas of the present invention; meanwhile, as those skilled in the art will have variations in the specific embodiments and application scope in accordance with the ideas of the present invention, the present description should not be construed as limiting the present invention in view of the above.
Claims (14)
1. A calculation information processing method, characterized by comprising:
converting the original transfer transaction into a plurality of derivative transactions based on the online transaction request of the current day;
updating the account main file and transaction detail information corresponding to each derivative transaction respectively by applying each derivative transaction;
applying each derived transaction to output a corresponding secondary update log respectively, and reserving original financial information corresponding to the original transfer transaction;
generating a corresponding accounting entry by using a secondary update log corresponding to the transaction information on line, splitting the accounting entry to obtain a corresponding accounting document of the on-line transaction, wherein the secondary update refers to a processing process of generating accounting information according to the transaction log and a certain processing rule after the financial transaction of a core banking system completes an account master file and a transaction detail;
when the core banking system is in a day-end state, batch generating transaction detail files of the same day and accounting files of both lending and borrowing parties;
and summarizing the accounting files of the online transaction and the accounting files of the lending parties to obtain corresponding general ledger interface files, and outputting the general ledger interface files.
2. The method for processing accounting information according to claim 1, wherein the generating the corresponding accounting entry in the secondary update log corresponding to the online application transaction information, and splitting the accounting entry to obtain the accounting file of the corresponding online transaction, includes:
splitting secondary update logs output by each derived transaction one by one to obtain corresponding accounting records;
and merging the accounting records to obtain the corresponding accounting files of the online transaction.
3. The method for processing accounting information according to claim 1, wherein when the core banking system is in a final-day state, generating the accounting files of both the transaction details file and the borrowing party of the current day of the core banking system in batch includes:
when the core banking system is in a day-end state, generating transaction detail files and accounting files of both lending parties of the current day of the core banking system in batches based on preset parameter information;
wherein the parameter information includes at least one of transaction code, product information, and account information.
4. The method for processing accounting information according to claim 1, wherein the step of summarizing the accounting files of the online transaction and the accounting files of the lending parties to obtain corresponding general ledger interface files includes:
Respectively extracting information from the accounting files of the online transaction and the accounting files of the lending parties on the same day to obtain a reconciliation text of a contract or an account;
and summarizing the account checking text based on a preset large class to generate a general account interface file of the current day.
5. The accounting information processing method of claim 4, wherein said broad class comprises: institution information, currency information, subject information, and product information.
6. The accounting information processing method according to claim 1, wherein said outputting the general ledger interface file includes:
processing accounting records in the general ledger interface file;
and transmitting the accounting data information in the processed general ledger interface file to a corresponding reconciliation system for reconciliation processing.
7. An accounting information processing device, comprising:
a secondary update log generation module for performing the following: converting the original transfer transaction into a plurality of derivative transactions based on the online transaction request of the current day; updating the account main file and transaction detail information corresponding to each derivative transaction respectively by applying each derivative transaction; applying each derived transaction to output a corresponding secondary update log respectively, and reserving original financial information corresponding to the original transfer transaction;
The online accounting entry generation module is used for generating a corresponding accounting entry by using a secondary update log corresponding to the transaction information online, splitting the accounting entry to obtain a corresponding online transaction accounting file, wherein the secondary update refers to a processing process of generating the accounting information according to the transaction log and a certain processing rule after the financial transaction of the core banking system is completed in an account master file and a transaction detail;
the batch accounting entry generation module is used for generating transaction detail files of the core banking system on the same day and accounting files of lending parties in batches when the core banking system is in a final day state;
and the summarizing and outputting total module is used for summarizing the accounting files of the online transaction and the accounting files of the lending parties to obtain corresponding general ledger interface files and outputting the general ledger interface files.
8. The accounting information processing device of claim 7, wherein the online accounting entry generation module is configured to:
splitting secondary update logs output by each derived transaction one by one to obtain corresponding accounting records;
And merging the accounting records to obtain the corresponding accounting files of the online transaction.
9. The accounting information processing device of claim 7, wherein the batch accounting entry generation module is configured to:
when the core banking system is in a day-end state, generating transaction detail files and accounting files of both lending parties of the current day of the core banking system in batches based on preset parameter information;
wherein the parameter information includes at least one of transaction code, product information, and account information.
10. The accounting information processing device of claim 7, wherein said aggregate and output total module comprises:
the general ledger file collecting module of the current day is used for respectively extracting information from the accounting files of the online transaction of the current day and the accounting files of the lending parties to obtain the reconciliation text of the contract or the account; and summarizing the reconciliation texts based on a preset large class to generate a general ledger interface file of the current day.
11. The accounting information processing device of claim 10, wherein said broad categories include: institution information, currency information, subject information, and product information.
12. The accounting information processing device of claim 7, wherein said aggregate and output total module comprises:
the file processing and downloading module is used for processing accounting entry in the general ledger interface file; and transmitting the accounting data information in the processed general ledger interface file to a corresponding reconciliation system for reconciliation processing.
13. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the steps of the accounting information processing method of any one of claims 1 to 6 when the program is executed by the processor.
14. A computer-readable storage medium, on which a computer program is stored, characterized in that the computer program, when being executed by a processor, implements the steps of the accounting information processing method of any one of claims 1 to 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911240154.7A CN111047430B (en) | 2019-12-06 | 2019-12-06 | Accounting information processing method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911240154.7A CN111047430B (en) | 2019-12-06 | 2019-12-06 | Accounting information processing method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111047430A CN111047430A (en) | 2020-04-21 |
| CN111047430B true CN111047430B (en) | 2024-03-01 |
Family
ID=70233690
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911240154.7A Active CN111047430B (en) | 2019-12-06 | 2019-12-06 | Accounting information processing method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111047430B (en) |
Families Citing this family (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111476661B (en) * | 2020-05-04 | 2023-07-11 | 武汉众邦银行股份有限公司 | Batch processing method of general ledger system for cyclic check-in account |
| CN111709821B (en) * | 2020-06-08 | 2023-08-01 | 中国工商银行股份有限公司 | Accounting information processing method and device |
| CN111986011A (en) * | 2020-08-19 | 2020-11-24 | 江苏经贸职业技术学院 | Accounting mode |
| CN112767122A (en) * | 2021-01-14 | 2021-05-07 | 中国工商银行股份有限公司 | Accounting checking method, device, computer system and storage medium |
| CN113448398A (en) * | 2021-01-28 | 2021-09-28 | 潍坊工程职业学院 | Accounting method and device |
| CN113448713B (en) * | 2021-07-12 | 2024-02-13 | 中国银行股份有限公司 | Asynchronous processing method, device, storage medium and equipment for stream data |
| CN114723540A (en) * | 2022-03-30 | 2022-07-08 | 辽宁振兴银行股份有限公司 | Interest expenditure difference amount counting and processing method and system based on deposit interest counting and counting register |
| CN115115457B (en) * | 2022-08-29 | 2022-11-22 | 天津金城银行股份有限公司 | Method, system and medium for processing business transaction flow |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107967650A (en) * | 2017-11-08 | 2018-04-27 | 中国银行股份有限公司 | A kind of batch accounting data processing method and processing device of core banking system |
| CN109472680A (en) * | 2018-10-26 | 2019-03-15 | 中国银行股份有限公司 | A kind of accounting processing method and system |
| CN109903146A (en) * | 2018-11-22 | 2019-06-18 | 阿里巴巴集团控股有限公司 | A kind of accounting and account method and system calculate equipment and storage medium |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20160125511A1 (en) * | 2014-06-30 | 2016-05-05 | Ahmed Farouk Shaaban | System and method for managing vendors, tax allocation and posting journal entries |
-
2019
- 2019-12-06 CN CN201911240154.7A patent/CN111047430B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107967650A (en) * | 2017-11-08 | 2018-04-27 | 中国银行股份有限公司 | A kind of batch accounting data processing method and processing device of core banking system |
| CN109472680A (en) * | 2018-10-26 | 2019-03-15 | 中国银行股份有限公司 | A kind of accounting processing method and system |
| CN109903146A (en) * | 2018-11-22 | 2019-06-18 | 阿里巴巴集团控股有限公司 | A kind of accounting and account method and system calculate equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111047430A (en) | 2020-04-21 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111047430B (en) | Accounting information processing method and device | |
| US11328093B1 (en) | Protecting sensitive data | |
| CN112163946A (en) | Accounting processing method and device based on distributed transaction system | |
| CN101807273A (en) | Method and system for performing financial management by extracting consumption information in credit card short message | |
| CN101957959A (en) | Mobile terminal payment processing method, mobile terminal receipt processing method and systems | |
| CN113222555B (en) | Data processing method, device, equipment and system | |
| CN104618415A (en) | Method, device and system for creating credit account | |
| CN112784112B (en) | Message verification method and device | |
| CN109064161A (en) | A kind of bank account transaction journal intelligent management and device based on short message | |
| CN111222869A (en) | Transaction data processing method, device, computer equipment and medium | |
| CN113159913A (en) | Accounting information processing method and device | |
| CN111429282A (en) | Transaction anti-money laundering method and device based on anti-money laundering model migration | |
| CN111797099B (en) | Data processing method and device based on subjects and auxiliary attributes | |
| CN114048034A (en) | Accounting data processing method and device | |
| CN111881166B (en) | Method, device and system for processing operation data based on block chain | |
| CN111026755B (en) | Transaction sequence number acquisition method and device based on full sequence number generator | |
| CN112785201B (en) | Heterogeneous system quasi-real-time high-reliability interaction system and method | |
| CN112184248B (en) | Card organization rejection adjustment single data processing method and device | |
| CN115099930A (en) | Financial business data processing method and device | |
| CN112417018B (en) | Data sharing method and device | |
| CN105825349B (en) | Method and device for recording account information in multiple terminals | |
| CN109102381B (en) | Accounting processing method and device | |
| CN112102058A (en) | Management system parameter configuration method and device | |
| CN111161047A (en) | Bank business data processing and inquiring method and device | |
| US20140250242A1 (en) | Data sync engine, method and software |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |