TWI831114B - Integrity verifying method, system and computer device of separated cross-platform trade and accounting, computer-readable medium - Google Patents
Integrity verifying method, system and computer device of separated cross-platform trade and accounting, computer-readable medium Download PDFInfo
- Publication number
- TWI831114B TWI831114B TW111101642A TW111101642A TWI831114B TW I831114 B TWI831114 B TW I831114B TW 111101642 A TW111101642 A TW 111101642A TW 111101642 A TW111101642 A TW 111101642A TW I831114 B TWI831114 B TW I831114B
- Authority
- TW
- Taiwan
- Prior art keywords
- accounting
- transaction
- module
- summary file
- general ledger
- Prior art date
Links
- 238000000034 method Methods 0.000 title claims abstract description 31
- 238000012795 verification Methods 0.000 claims description 30
- 238000000926 separation method Methods 0.000 claims description 16
- 238000004891 communication Methods 0.000 claims description 9
- 238000012545 processing Methods 0.000 claims description 8
- 238000004220 aggregation Methods 0.000 abstract 5
- 230000002776 aggregation Effects 0.000 abstract 5
- 238000010586 diagram Methods 0.000 description 4
- 230000000694 effects Effects 0.000 description 3
- 101001024616 Homo sapiens Neuroblastoma breakpoint family member 9 Proteins 0.000 description 2
- 102100037013 Neuroblastoma breakpoint family member 9 Human genes 0.000 description 2
- 238000011161 development Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
Images
Abstract
Description
本發明是有關於一種交易資訊之驗證方法,特別是指一種針對交易裝置與會計系統分離機制的跨平台交易與會計分離之完整性驗證方法。 The present invention relates to a verification method of transaction information, and in particular, to an integrity verification method of cross-platform transaction and accounting separation for the separation mechanism of transaction device and accounting system.
以往銀行的交易與會計都由單一系統處理,但現在因為金融科技的蓬勃發展,使得金融產品與服務日趨複雜,為了讓交易系統能專注於服務客戶,現今銀行將會計從交易系統分離出來已成為市場趨勢。因此,在交易與會計系統之間,如何確保交易與會計兩者產出的資訊的完整性,是一個相當重要的議題。 In the past, banks' transactions and accounting were handled by a single system. However, due to the booming development of financial technology, financial products and services have become increasingly complex. In order to allow the trading system to focus on serving customers, it has become a trend for banks to separate accounting from the trading system. Market trends. Therefore, between the transaction and accounting systems, how to ensure the integrity of the information produced by both transactions and accounting is a very important issue.
因此,本發明之目的,即在提供一種跨平台交易與會計分離之完整性驗證方法,以及實現該方法的一種跨平台交易與會計分離之完整性驗證系統、一種完整性驗證電腦裝置和一種電腦可讀 取的記錄媒體,其能藉由交易明細比對和總分核對,確認每日的交易與會計處理的完整性。 Therefore, the purpose of the present invention is to provide an integrity verification method for cross-platform transaction and accounting separation, as well as an integrity verification system for cross-platform transaction and accounting separation, an integrity verification computer device and a computer to implement the method readable The recording media obtained can confirm the integrity of daily transactions and accounting processing through transaction detail comparison and total score verification.
於是,本發明一種跨平台交易與會計分離之完整性驗證方法,應用於一金融機構,該金融機構具有多個交易裝置,各該交易裝置提供顧客金融交易服務並產生相對應的一交易明細;該方法包括下列步驟。 Therefore, the present invention is an integrity verification method that separates cross-platform transactions and accounting, and is applied to a financial institution. The financial institution has multiple transaction devices, and each transaction device provides customer financial transaction services and generates a corresponding transaction detail; The method includes the following steps.
(A)各該交易裝置將當日產生的各該交易明細即時傳送給該金融機構的一電腦系統,該電腦系統的一會計核算模組根據接收到的各該交易明細產生相對應的一記錄交易金額及其對應的會計項目的會計分錄,並即時傳送各該會計分錄給該電腦系統的一總帳模組,使該總帳模組根據接收到的該等會計分錄記錄的會計項目,將會計項目相同的該等會計分錄記錄的交易金額加總而產生至少一包含會計項目及一總帳餘額的總帳科目餘額。 (A) Each transaction device immediately transmits the transaction details generated on that day to a computer system of the financial institution, and an accounting module of the computer system generates a corresponding recorded transaction based on the received transaction details. The amount and the corresponding accounting entries of the accounting items, and immediately transmit each accounting entry to a general ledger module of the computer system, so that the general ledger module records the accounting items based on the received accounting entries. , adding up the transaction amounts recorded by the accounting entries with the same accounting items to generate at least one general ledger account balance including accounting items and one general ledger balance.
(B)各該交易裝置確認當日產生的該等交易明細皆已傳送給該電腦系統後,產生一交易明細彙整檔及一分戶彙總檔並傳送給該電腦系統的該會計核算模組;其中,各該交易明細彙整檔包含當日產生的該等交易明細,各該分戶彙總檔彙整當日進行金融交易的所有帳戶的核算對象、交易類型及餘額。 (B) After each transaction device confirms that the transaction details generated on that day have been sent to the computer system, it generates a transaction details summary file and a branch summary file and sends them to the accounting module of the computer system; , each transaction detail summary file contains the transaction details that occurred on that day, and each account summary file summarizes the accounting objects, transaction types and balances of all accounts that conducted financial transactions on that day.
(C)該會計核算模組比對來自同一交易裝置的該等交易明細與該交易明細彙整檔包含的該等交易明細,而產生對應於各 該交易裝置的一交易明細比對結果。 (C) The accounting module compares the transaction details from the same transaction device with the transaction details contained in the transaction details summary file, and generates corresponding A comparison result of transaction details of the transaction device.
(D)該會計核算模組根據該等分戶彙總檔中各該帳戶的核算對象和交易類型給予相對應的會計項目,並將該等分戶彙總檔中會計項目相同的該等帳戶的餘額加總而產生至少一包含會計項目和相對應的一會計餘額的科目餘額彙總檔,並傳送該至少一科目餘額彙總檔給該總帳模組。 (D) The accounting module assigns corresponding accounting items based on the accounting objects and transaction types of each account in the account summary files, and calculates the balances of the accounts with the same accounting items in the account summary files Summing up generates at least one account balance summary file including accounting items and a corresponding accounting balance, and transmits the at least one account balance summary file to the general ledger module.
(E)該總帳模組核對會計項目相同的該至少一總帳科目餘額中的該總帳餘額和該至少一科目餘額彙總檔中的該會計餘額,並產生至少一包含會計項目和一差額的總分核對報表。 (E) The general ledger module checks the general ledger balance in the at least one general ledger account balance with the same accounting item and the accounting balance in the at least one account balance summary file, and generates at least one accounting item and a difference Total score verification report.
此外,本發明實現上述方法的一種跨平台交易與會計分離之完整性驗證系統,應用於一金融機構,並包括多個交易裝置及一電腦系統;各該交易裝置提供顧客金融交易服務並產生相對應的一交易明細;該電腦系統能與該等交易裝置通訊並包含一會計核算模組及一總帳模組。 In addition, the present invention implements an integrity verification system for cross-platform transactions and accounting separation that implements the above method, is applied to a financial institution, and includes multiple transaction devices and a computer system; each transaction device provides customer financial transaction services and generates relevant Corresponding transaction details; the computer system can communicate with the transaction devices and includes an accounting module and a general ledger module.
其中,各該交易裝置將當日產生的各該交易明細即時傳送給該電腦系統,且該會計核算模組根據接收到的各該交易明細產生相對應的一記錄交易金額及其對應的會計項目的會計分錄,並即時傳送各該會計分錄給該總帳模組,該總帳模組根據接收到的該等會計分錄記錄的會計項目,將會計項目相同的該等會計分錄記錄的交易金額加總而產生至少一包含會計項目及一總帳餘額的總帳 科目餘額。 Among them, each transaction device immediately transmits each transaction details generated on that day to the computer system, and the accounting module generates a corresponding record of the transaction amount and its corresponding accounting items based on the received transaction details. Accounting entries are sent immediately to the general ledger module. The general ledger module records the accounting entries with the same accounting items based on the received accounting items. Transaction amounts are summed to produce at least one general ledger containing accounting items and one general ledger balance. Account balance.
各該交易裝置確認當日產生的該等交易明細皆已傳送給該電腦系統後,各別產生一交易明細彙整檔及一分戶彙總檔並傳送給該電腦系統的該會計核算模組;各該交易明細彙整檔包含當日產生的該等交易明細,各該分戶彙總檔彙整當日進行金融交易的所有帳戶的核算對象、交易類型及餘額;該會計核算模組比對來自同一交易裝置的該等交易明細與該交易明細彙整檔包含的該等交易明細,而產生對應於各該交易裝置的一交易明細比對結果;該會計核算模組根據該等分戶彙總檔中各該帳戶的核算對象和交易類型給予相對應的會計項目,並將該等分戶彙總檔中會計項目相同的該等帳戶的餘額加總而產生至少一包含會計項目和相對應的一會計餘額的科目餘額彙總檔,並傳送該至少一科目餘額彙總檔給該總帳模組;該總帳模組核對會計項目相同的該至少一總帳科目餘額中的該總帳餘額和該至少一科目餘額彙總檔中的該會計餘額,並產生至少一包含會計項目和一差額的總分核對報表。 After each transaction device confirms that the transaction details generated on that day have been sent to the computer system, it generates a transaction details summary file and a branch summary file and sends them to the accounting module of the computer system; The transaction details summary file contains the transaction details generated on that day. Each account summary file summarizes the accounting objects, transaction types and balances of all accounts that conducted financial transactions on that day; the accounting module compares the transaction details from the same transaction device. The transaction details and the transaction details included in the transaction details summary file generate a transaction details comparison result corresponding to each transaction device; the accounting module is based on the accounting objects of each account in the sub-account summary files. Accounting items corresponding to the transaction types are given, and the balances of the accounts with the same accounting items in the account summary files are summed to generate at least one account balance summary file containing accounting items and a corresponding accounting balance, And transmit the at least one account balance summary file to the general ledger module; the general ledger module checks the general ledger balance in the at least one general ledger account balance with the same accounting item and the at least one account balance summary file. Accounting balances, and generate at least one total reconciliation report containing accounting items and one difference.
在本發明的一些實施態樣中,該電腦系統包括能互相通訊的一第一電腦裝置及一第二電腦裝置,且該會計核算模組是安裝在該第一電腦裝置中且被該第一電腦裝置執行的軟體程式,該總帳模組是安裝在該第二電腦裝置中且被該第二電腦裝置執行的軟體程式;或者,該電腦系統是一電腦裝置,且該會計核算模組及該 總帳模組是安裝在該電腦裝置中且被該電腦裝置執行的軟體程式。 In some implementations of the present invention, the computer system includes a first computer device and a second computer device that can communicate with each other, and the accounting module is installed in the first computer device and is used by the first computer device. a software program executed by a computer device, and the general ledger module is a software program installed in and executed by the second computer device; or, the computer system is a computer device, and the accounting module and the The general ledger module is a software program installed in and executed by the computer device.
再者,本發明實現上述方法的一種跨平台交易與會計分離之完整性驗證電腦裝置,應用於一金融機構,且能與該金融機構的多個交易裝置通訊,各該交易裝置提供顧客金融交易服務並產生相對應的一交易明細,且各該交易裝置確認當日產生的該等交易明細皆已傳送給該電腦裝置後,產生一交易明細彙整檔及一分戶彙總檔並傳送給該電腦裝置,各該交易明細彙整檔包含當日產生的該等交易明細,各該分戶彙總檔彙整當日進行金融交易的所有帳戶的核算對象、交易類型及餘額;該電腦裝置包括一通訊介面單元、一儲存單元及一處理單元;該通訊介面單元與該等交易裝置建立連線以接收該等交易明細、該交易明細彙整檔及該分戶彙總檔;該儲存單元儲存該等交易明細、該交易明細彙整檔及該分戶彙總檔;該處理單元與該通訊介面單元及該儲存單元電連接並包含一會計核算模組及一總帳模組。 Furthermore, the present invention realizes the above-mentioned method, a cross-platform transaction and accounting integrity verification computer device is applied to a financial institution, and can communicate with multiple transaction devices of the financial institution, and each transaction device provides customers with financial transactions. service and generate a corresponding transaction detail, and after each transaction device confirms that the transaction details generated on that day have been sent to the computer device, a transaction details summary file and a branch summary file are generated and sent to the computer device. , each transaction detail summary file contains the transaction details generated on that day, and each account summary file summarizes the accounting objects, transaction types and balances of all accounts that conduct financial transactions on that day; the computer device includes a communication interface unit, a storage unit and a processing unit; the communication interface unit establishes a connection with the transaction devices to receive the transaction details, the transaction details summary file and the account summary file; the storage unit stores the transaction details, the transaction details summary file file and the branch summary file; the processing unit is electrically connected to the communication interface unit and the storage unit and includes an accounting module and a general ledger module.
其中,該會計核算模組根據該儲存單元儲存的各該交易明細產生相對應的一記錄交易金額及其對應的會計項目的會計分錄,並傳送各該會計分錄給該總帳模組,該總帳模組根據接收到的該等會計分錄記錄的會計項目,將會計項目相同的該等會計分錄記錄的交易金額加總而產生至少一包含會計項目及一總帳餘額的總帳科目餘額;該會計核算模組比對該儲存單元儲存之來自同一交 易裝置的該等交易明細與該交易明細彙整檔包含的該等交易明細,而產生對應於各該交易裝置的一交易明細比對結果,並儲存該交易明細比對結果於該儲存單元;該會計核算模組根據該儲存單元儲存之該等分戶彙總檔中各該帳戶的核算對象和交易類型給予相對應的會計項目,並將該等分戶彙總檔中會計項目相同的該等帳戶的餘額加總而產生至少一包含會計項目和相對應的一會計餘額的科目餘額彙總檔,並傳送該至少一科目餘額彙總檔給該總帳模組;該總帳模組核對會計項目相同的該至少一總帳科目餘額中的該總帳餘額和該至少一科目餘額彙總檔中的該會計餘額,而產生至少一包含會計項目和一差額的總分核對報表,並儲存該總分核對報表於該儲存單元。 Among them, the accounting module generates a corresponding accounting entry that records the transaction amount and its corresponding accounting item based on the transaction details stored in the storage unit, and transmits each accounting entry to the general ledger module, The general ledger module adds up the transaction amounts recorded in the accounting entries with the same accounting items according to the received accounting items recorded in the accounting entries to generate at least one general ledger including accounting items and one general ledger balance. Account balance; the accounting module compares the account balance stored in the storage unit from the same transaction The transaction details of the transaction device and the transaction details included in the transaction details summary file generate a transaction details comparison result corresponding to each transaction device, and store the transaction details comparison result in the storage unit; the The accounting module assigns corresponding accounting items based on the accounting objects and transaction types of each account in the account summary files stored in the storage unit, and assigns corresponding accounting items to the accounts with the same accounting items in the account summary files. The balances are summed to generate at least one account balance summary file including accounting items and a corresponding accounting balance, and the at least one account balance summary file is sent to the general ledger module; the general ledger module checks the account balances with the same accounting items. The general ledger balance in at least one general ledger account balance and the accounting balance in the at least one account balance summary file generate at least one total score reconciliation report including accounting items and one difference, and store the total score reconciliation report in the storage unit.
在本發明的一些實施態樣中,各該交易裝置確認當日產生的該等交易明細皆已傳送給該電腦裝置後,會產生一日切信號,並同時傳送該日切信號、該交易明細彙整檔和該分戶彙總檔給該會計核算模組;該會計核算模組收到該日切信號後,才比對來自同一交易裝置的該等交易明細與該交易明細彙整檔包含的該等交易明細;且該會計核算模組收到該日切信號後,才根據該等分戶彙總檔中各該帳戶的核算對象和交易類型給予相對應的會計項目,並產生該至少一科目餘額彙總檔。 In some implementations of the present invention, after each trading device confirms that all transaction details generated on that day have been transmitted to the computer device, it will generate a daily cut signal and simultaneously transmit the daily cut signal and the transaction details summary. file and the branch summary file to the accounting module; only after receiving the daily cut signal, the accounting module compares the transaction details from the same transaction device with the transactions included in the transaction details summary file details; and after receiving the daily cut signal, the accounting module will provide corresponding accounting items based on the accounting objects and transaction types of each account in the account summary files, and generate the at least one account balance summary file. .
在本發明的一些實施態樣中,該總分核對報表還包含 該總帳餘額和該會計餘額。 In some embodiments of the present invention, the total score verification report also includes The general ledger balance and the accounting balance.
另外,本發明實現上述方法的一種電腦可讀取的記錄媒體,其中儲存一包含一會計核算模組及一總帳模組的軟體程式,該軟體程式被一能與多個交易裝置通訊的電腦系統載入並執行後,該電腦系統能完成如上所述的跨平台交易與會計分離之完整性驗證方法;其中,各該交易裝置提供顧客金融交易服務並產生相對應的一交易明細,且各該交易裝置確認當日產生的該等交易明細皆已傳送給該電腦系統後,產生一交易明細彙整檔及一分戶彙總檔並傳送給該電腦系統,各該交易明細彙整檔包含當日產生的該等交易明細,各該分戶彙總檔彙整當日進行金融交易的所有帳戶的核算對象、交易類型及餘額。 In addition, the present invention implements the above method in a computer-readable recording medium, which stores a software program including an accounting module and a general ledger module. The software program is used by a computer that can communicate with multiple transaction devices. After the system is loaded and executed, the computer system can complete the above-mentioned integrity verification method of cross-platform transaction and accounting separation; wherein, each transaction device provides customer financial transaction services and generates a corresponding transaction detail, and each transaction device After the transaction device confirms that all the transaction details generated on the day have been sent to the computer system, it generates a transaction details summary file and a branch summary file and sends them to the computer system. Each transaction details summary file includes the transaction details generated on the day. For transaction details, each account summary file summarizes the accounting objects, transaction types and balances of all accounts that conduct financial transactions on that day.
本發明之功效在於:藉由該會計核算模組根據來自各該交易裝置的各該交易明細產生相對應的該會計分錄並傳送給該總帳模組,該總帳模組根據接收到的該等會計分錄產生包含會計項目及總帳餘額的總帳科目餘額;且該會計核算模組藉由比對來自同一交易裝置的該等交易明細與該交易明細彙整檔包含的該等交易明細,產生該交易明細比對結果,而能對交易完整性進行驗證並確認交易明細在跨系統間傳遞時是否有資料遺失問題;並且,該總帳模組藉由核對會計項目相同的總帳科目餘額中的該總帳餘額和該會計核算模組提供之科目餘額彙總檔中的該會計餘額,產生包含會 計項目和差額的總分核對報表,而能對會計完整性進行驗證並確認同一會計項目的帳目金額在會計核算與總帳計算的過程中是否有計算錯誤的問題,以確保交易與會計兩者產出的資訊的完整性。 The effect of the present invention is that the accounting module generates the corresponding accounting entries based on the transaction details from each transaction device and sends them to the general ledger module, and the general ledger module generates corresponding accounting entries based on the received transaction details. These accounting entries generate general ledger account balances that include accounting items and general ledger balances; and the accounting module compares the transaction details from the same transaction device with the transaction details contained in the transaction details summary file, The transaction details comparison result is generated to verify the integrity of the transaction and confirm whether there is any data loss problem when the transaction details are transferred between systems; and, the general ledger module checks the balance of the same general ledger account by checking the accounting items. The general ledger balance in and the accounting balance in the account balance summary file provided by the accounting module will generate It can verify the accounting integrity and confirm whether there are calculation errors in the account amount of the same accounting item during the accounting and general ledger calculation process, so as to ensure that both transaction and accounting the integrity of the information produced by the author.
1:交易裝置 1: Trading device
2:電腦系統(電腦裝置) 2: Computer system (computer device)
2A:第一電腦裝置 2A: First computer device
2B:第二電腦裝置 2B: Second computer device
21:會計核算模組 21:Accounting module
22:總帳模組 22: General ledger module
23:通訊介面單元 23: Communication interface unit
24:儲存單元 24:Storage unit
25:處理單元 25: Processing unit
S1~S12:步驟 S1~S12: steps
本發明之其他的特徵及功效,將於參照圖式的實施方式中清楚地顯示,其中:圖1是本發明跨平台交易與會計分離之完整性驗證方法的一實施例的主要流程步驟;圖2是本發明實現圖1之流程步驟的跨平台交易與會計分離之完整性驗證系統主要包含的硬體裝置與模組方塊示意圖;圖3是本發明實現圖1之流程步驟的跨平台交易與會計分離之完整性驗證系統主要包含的另一種硬體裝置與模組方塊示意圖;圖4是圖3之電腦裝置主要包含的硬體元件方塊示意圖;圖5說明本實施例的交易裝置於日間和日終分別傳送不同的資料給電腦裝置;圖6說明本實施例的各該交易裝置產生分戶彙總檔並傳送給電腦裝置的會計核算模組;圖7說明本實施例的電腦裝置的會計核算模組比對來自同一交易裝置的該等交易明細與交易明細彙整檔包含的該等交易明細並產生交易明細比對結果; 圖8說明本實施例的電腦裝置的會計核算模組將不同交易裝置提供之該等分戶彙總檔中會(計)項(目)相同的該等帳戶的餘額加總,並產生包含會(計)項(目)和會計餘額的科目餘額彙總檔;及圖9說明本實施例的電腦裝置的總帳模組核對會(計)項(目)相同的總帳科目餘額中的該總帳餘額和科目餘額彙總檔中的該會計餘額並產生包含會(計)項(目)和差額的總分核對報表。 Other features and effects of the present invention will be clearly shown in the embodiments with reference to the drawings, in which: Figure 1 is the main process steps of an embodiment of the integrity verification method for cross-platform transaction and accounting separation according to the present invention; 2 is a schematic diagram of the hardware devices and module blocks mainly included in the integrity verification system for cross-platform transactions and accounting separation of the present invention to implement the process steps of Figure 1; Figure 3 is a cross-platform transaction and module block diagram of the present invention to implement the process steps of Figure 1. Another schematic block diagram of hardware devices and modules mainly included in the accounting separation integrity verification system; Figure 4 is a block schematic diagram of hardware components mainly included in the computer device of Figure 3; Figure 5 illustrates the transaction device of this embodiment during the day and Different data are sent to the computer device at the end of the day; Figure 6 illustrates that each transaction device in this embodiment generates a household summary file and sends it to the accounting module of the computer device; Figure 7 illustrates the accounting module of the computer device in this embodiment The module compares the transaction details from the same transaction device with the transaction details included in the transaction details summary file and generates the transaction details comparison results; Figure 8 illustrates that the accounting module of the computer device in this embodiment adds up the balances of the accounts with the same accounting items (items) in the account summary files provided by different transaction devices, and generates a The account balance summary file of the accounting items (items) and accounting balances; and Figure 9 illustrates that the general ledger module of the computer device of this embodiment checks the general ledger account balances of the same general ledger items (items). The accounting balance in the balance and account balance summary file is generated and a total score reconciliation report containing accounting items and differences is generated.
在本發明被詳細描述之前,應當注意在以下的說明內容中,類似的元件是以相同的編號來表示。 Before the present invention is described in detail, it should be noted that in the following description, similar elements are designated with the same numbering.
參見圖1所示,是本發明跨平台交易與會計分離之完整性驗證方法的一實施例的主要流程,其應用於一金融機構,例如但不限於銀行,且如圖2所示,該金融機構具有多個交易裝置1,且為方便說明,圖2僅以兩個交易裝置1(即交易裝置A和交易裝置B)為例;各該交易裝置1可以是設置在金融機構的臨櫃櫃台或者設置在金融機構以外的場所,以提供顧客金融交易服務,例如做為一存放款系統、一外匯系統等提供顧客存放款服務、外匯服務等的電腦裝置,並且會產生與金融交易相對應的一交易明細(即會計帳務)的系統;且本實施例的方法是由圖2所示之包括該等交易裝置1和一電腦系統2的跨平台交易與會計分離之完整性驗證系統實現,該電腦系統2能透過網路(例如網際網路、區域網路或內部
網路等)與該等交易裝置1通訊,並包含一會計核算模組21及一總帳模組22。其中,如圖2所示,該電腦系統2包括能互相通訊(例如透過內部網路或區域網路)的一第一電腦裝置2A及一第二電腦裝置2B,且該會計核算模組21是安裝在該第一電腦裝置2A中且被該第一電腦裝置2A執行的軟體程式,該總帳模組22是安裝在該第二電腦裝置2B中且被該第二電腦裝置2B執行的軟體程式,因此,該第一電腦裝置2A和該第二電腦裝置2B可藉由分別執行該會計核算模組21及該總帳模組22而完成如下所述及圖1所示的方法步驟。
Referring to Figure 1, it is the main process of an embodiment of the integrity verification method of cross-platform transaction and accounting separation according to the present invention. It is applied to a financial institution, such as but not limited to a bank, and as shown in Figure 2, the financial institution The institution has
或者,如圖3所示,該電腦系統2也可以是單一個電腦裝置(完整性驗證電腦裝置,下稱電腦裝置2),且該會計核算模組21及該總帳模組22是安裝在該電腦裝置2中且被該電腦裝置2執行的軟體程式。具體而言,如圖4所示,該電腦裝置2至少包括一能與該等交易裝置1建立連線以通訊的通訊介面單元23(例如網路卡)、一由記憶體模組構成的儲存單元24及一與該通訊介面單元23及該儲存單元24電連接的處理單元25(例如中央處理器)。且該處理單元25載入一電腦可讀取的記錄媒體(例如該儲存單元24)儲存之包含該會計核算模組21及該總帳模組22的軟體程式並執行該軟體程式後,該電腦裝置2將能完成如下所述及圖1所示的方法步驟。以下,將以電腦裝置(電腦系統)2為例進行說明。
Alternatively, as shown in Figure 3, the
首先,如圖3所示,當有顧客(例如顧客A、顧客B)向各該交易裝置A、交易裝置B請求金融交易服務,則交易裝置A、交易裝置B在完成金融交易服務並提供交易結果給顧客A、顧客B(或其持有的終端電子裝置,例如個人電腦或智慧型手機等)的同時,如圖1的步驟S1和圖3所示,交易裝置A、交易裝置B也會各別產生與該次金融交易對應的一交易明細,並且如圖1的步驟S2和圖3所示,將當日(當前帳務日)產生的各該(每一筆)交易明細即時傳送給該電腦裝置2。
First, as shown in Figure 3, when a customer (such as customer A, customer B) requests financial transaction services from the transaction device A and transaction device B, the transaction device A and transaction device B complete the financial transaction service and provide the transaction. When the result is sent to customer A and customer B (or the terminal electronic devices held by them, such as personal computers or smartphones, etc.), as shown in steps S1 and 3 of Figure 1, transaction device A and transaction device B will also A transaction detail corresponding to the financial transaction is generated respectively, and as shown in steps S2 and 3 of Figure 1, each (each) transaction detail generated on that day (current accounting day) is immediately transmitted to the computer.
然後,如圖1的步驟S3,該電腦裝置2的該會計核算模組21根據接收到的各該交易明細產生相對應的一記錄交易金額及其對應的會計項目的會計分錄,例如顧客A透過交易裝置A存500元至Y銀行的某一帳戶,該交易明細會記載:1.Y銀行的現金增加500元,2.顧客A活期儲蓄存款存入500元,則對應的該會計分錄會記錄:1.借:003-庫存現金500,2.貸:466(會計項目的代號)-活期儲蓄存款500。
Then, in step S3 of FIG. 1 , the
然後,如圖1的步驟S4,該會計核算模組21會即時傳送產生的各該會計分錄給該電腦裝置的該總帳模組22,該總帳模組22收到的該等會計分錄後,如圖1的步驟S5,該總帳模組22會根據該等會計分錄記錄的會計項目,將會計項目相同的該等會計分錄記錄的交易金額加總,而產生至少一包含會計項目及一總帳餘
額的總帳科目餘額。
Then, as shown in step S4 of FIG. 1 , the
因此,如圖5所示,在當前帳務日中(即圖5的”日間”),該會計核算模組21會持續收到來自各該交易裝置1的交易明細,並將各該交易裝置1的該等交易明細記錄於儲存在該電腦裝置2的該儲存單元24中的一交易明細清單,因此,該儲存單元24中將儲存一對一對應不同交易裝置1的多個交易明細清單;同時,該會計核算模組21根據各該交易明細產生相對應的各該會計分錄並傳送給該總帳模組22,該總帳模組22則會根據在當前帳務日中陸續收到的該等會計分錄,將會計項目相同的該等會計分錄記錄的交易金額累加,而產生加總後的針對不同會計項目的各該總帳科目餘額,例如該總帳模組22針對會計項目466產生的該總帳科目餘額記錄的該總帳餘額為110,同時,該總帳模組22也會將該等會計分錄中其它會計項目相同的交易金額加總,而產生與其它會計項目對應的一個或一個以上的其它的該總帳科目餘額。
Therefore, as shown in Figure 5, in the current accounting day (i.e., the "day period" in Figure 5), the
然後,如圖1的步驟S6,各該交易裝置1會在當前帳務日日終(即完成當日的金融交易服務)時,確認當日產生的該等交易明細是否皆已傳送給該電腦裝置2,若否,則回到並重覆上述的步驟S2;若是,則如圖1的步驟S7及圖5所示,各該交易裝置1產生一交易明細彙整檔及一分戶彙總檔,並傳送該交易明細彙整檔及該分戶彙總檔給該電腦裝置2的該會計核算模組21;其中,各
該交易明細彙整檔包含各該交易裝置1當日日終前(即日間)產生的該等交易明細,亦即該交易明細彙整檔是該交易裝置1彙整當日(當前帳務日)已傳送給該電腦裝置2的所有交易明細的檔案;各該分戶彙總檔則是各該交易裝置1彙整當日進行金融交易的所有帳戶的核算對象(例如活存、定存等產品)、交易類型(例如本金、利息等)及其相對應的餘額;以圖6為例,假設交易裝置A產生的分戶彙總檔A包含兩個核算對象(以代號AB02、AB03表示,不同代號表示不同業務),且交易類型皆為B009(以代號表示),餘額分別為10、20;交易裝置B產生的分戶彙總檔B包含兩個核算對象(以代號AD01、AE01表示),且交易類型同樣為B009,餘額分別為30、40。
Then, as shown in step S6 of Figure 1 , each
接著,當該會計核算模組21收到來自不同交易裝置1的該等交易明細彙整檔及該等分戶彙總檔後,如圖1的步驟S9和圖7所示,該會計核算模組21從該儲存單元24取出該等交易明細清單,並比對來自同一交易裝置1的該交易明細清單記錄的該等交易明細與該交易明細彙整檔包含的該等交易明細,例如圖7所示,依系統別以交易序號進行交叉比對,而產生對應於各該交易裝置1的一交易明細比對結果並儲存於該儲存單元24中,且如圖7所示,該交易明細比對結果主要記錄在該交易明細清單或該交易明細彙整檔中沒有出現的交易序號。藉此,即可對交易完整性進行驗證,
並根據比對結果察查交易明細在跨系統間傳遞的過程是否有資料遺失的問題。
Next, when the
此外,如圖1的步驟S10所示,該會計核算模組21會根據該等分戶彙總檔中各該帳戶的核算對象和交易類型給予相對應的會計項目,以圖6產生的分戶彙總檔A和分戶彙總檔B為例,該會計核算模組21會針對核算對象和交易類型,例如對不同核算對象(AB02、AB03、AD01、AE01)但具有相同交易類型(代號B009)者給予相對應的會計項目代號,例如466,然後,將該等分戶彙總檔中會計項目相同(例如466)的該等帳戶的餘額加總,而產生至少一包含會計項目(例如466)和相對應的一會計餘額(例如圖8所示四個相同會(計)項(目)的餘額的加總為100)的科目餘額彙總檔,並如圖1的步驟S11和圖9所示,該會計核算模組21傳送該至少一科目餘額彙總檔給該總帳模組22。
In addition, as shown in step S10 of FIG. 1 , the
換句話說,當分戶彙總檔A和分戶彙總檔B中還包含具有其它的核算對象(例如代號AC01、AC03)和交易類型(例如代號A001)的帳戶時,則該會計核算模組21會針對核算對象(AC01、AC03)和交易類型(A001),給予該等帳戶相對應的會計項目代號,例如460,並將該等分戶彙總檔A、B中會計項目皆為460的該等帳戶的餘額加總得到一會計餘額,而產生另一包含會計項目460和相對應的該會計餘額的科目餘額彙總檔,依此類推。因此,該會計
核算模組21可能會根據分戶彙總檔A和分戶彙總檔B(以及來自其它交易裝置1的更多的分戶彙總檔)產生多個針對不同會計項目的科目餘額彙總檔。
In other words, when the household summary file A and the household summary file B also contain accounts with other accounting objects (such as code AC01, AC03) and transaction types (such as code A001), then the
值得一提的是,在上述步驟S7中,各該交易裝置1除了產生該交易明細彙整檔及該分戶彙總檔外,還可產生一表示各該交易裝置1已完成當日(當前帳務日)所有帳務交易的日切信號,並將該日切信號連同該交易明細彙整檔及該分戶彙總檔傳送給該電腦裝置2,且該會計核算模組21在收到該日切信號後,才執行上述步驟S9和步驟S10。此外,步驟S9和步驟S10並無先後順序之分,也可以先執行步驟S10,再執行步驟S9。
It is worth mentioning that in the above-mentioned step S7, in addition to generating the transaction detail summary file and the account summary file, each
然後,如圖1的步驟S12,該總帳模組22收到該等科目餘額彙總檔後,核對會計項目相同的各該總帳科目餘額中的該總帳餘額和各該科目餘額彙總檔中的該會計餘額,並產生對應不同會計項目之包含會計項目和一差額的多個總分核對報表;例如圖9所示,以會(計)項(目)466為例,該總帳模組22核對會(計)項(目)為466的該總帳科目餘額中的該總帳餘額(110)和該科目餘額彙總檔中的該會計餘額(100),所產生的該總分核對報表中包含會(計)項(目)466和差額(10),此外,該總分核對報表中還可包含該會計餘額(100)和該總帳餘額(110)等資訊。藉此,即可對會計完整性進行驗證,並可根據此報表確認對應同一會計項目的帳目金額在該會計
核算模組21與該總帳模組22計算的過程中是否有產生計算錯誤的問題。
Then, as shown in step S12 of Figure 1 , after receiving the account balance summary file, the
綜上所述,上述實施例藉由該電腦裝置2的該會計核算模組21根據來自各該交易裝置1的各該交易明細產生相對應的該會計分錄,並傳送各該會計分錄給該電腦裝置2的該總帳模組22,使該總帳模組22根據接收到的該等會計分錄,將會計項目相同的該等會計分錄記錄的交易金額加總而產生包含會計項目及總帳餘額的總帳科目餘額;且該會計核算模組21藉由比對來自同一交易裝置1的該等交易明細與該交易明細彙整檔包含的該等交易明細,產生該交易明細比對結果,能對交易完整性進行驗證並確認交易明細在跨系統間傳遞時是否有資料遺失問題;並且,該總帳模組22藉由核對會計項目相同的總帳科目餘額中的該總帳餘額和該會計核算模組21提供之科目餘額彙總檔中的該會計餘額,產生包含會計項目和差額的總分核對報表,能對會計完整性進行驗證並確認同一會計項目的帳目金額在會計核算與總帳計算的過程中是否有計算錯誤的問題,以確保交易與會計兩者產出的資訊的完整性,而達到本發明的功效與目的。
To sum up, in the above embodiment, the
惟以上所述者,僅為本發明之實施例而已,當不能以此限定本發明實施之範圍,凡是依本發明申請專利範圍及專利說明書內容所作之簡單的等效變化與修飾,皆仍屬本發明專利涵蓋之範圍 內。 However, the above are only examples of the present invention, and should not be used to limit the scope of the present invention. All simple equivalent changes and modifications made based on the patent scope of the present invention and the content of the patent specification are still within the scope of the present invention. Scope covered by the patent of this invention within.
1:交易裝置 1: Trading device
2:電腦系統 2:Computer system
21:會計核算模組 21:Accounting module
22:總帳模組 22: General ledger module
S1~S12:步驟 S1~S12: steps
Claims (12)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
TW111101642A TWI831114B (en) | 2022-01-14 | Integrity verifying method, system and computer device of separated cross-platform trade and accounting, computer-readable medium |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
TW111101642A TWI831114B (en) | 2022-01-14 | Integrity verifying method, system and computer device of separated cross-platform trade and accounting, computer-readable medium |
Publications (2)
Publication Number | Publication Date |
---|---|
TW202329022A TW202329022A (en) | 2023-07-16 |
TWI831114B true TWI831114B (en) | 2024-02-01 |
Family
ID=
Citations (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6990466B1 (en) | 2000-08-08 | 2006-01-24 | International Business Machines Corporation | Method and system for integrating core banking business processes |
Patent Citations (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6990466B1 (en) | 2000-08-08 | 2006-01-24 | International Business Machines Corporation | Method and system for integrating core banking business processes |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN110263024B (en) | Data processing method, terminal device and computer storage medium | |
US7617152B2 (en) | Bankcard transaction exchange system | |
US20110078083A1 (en) | Electronic draft capture | |
US20120303525A1 (en) | Methods and systems for verifying regulation compliance | |
CN107689009A (en) | Annuity data processing method, device, server and storage medium | |
CN111382081A (en) | Entry verification test method and device | |
CN115409590A (en) | Unified account checking method, device, equipment and storage medium | |
CN114840527A (en) | Data processing method, device and computer readable storage medium | |
CN113034275B (en) | Management system and method based on block chain network and terminal equipment | |
TWI831114B (en) | Integrity verifying method, system and computer device of separated cross-platform trade and accounting, computer-readable medium | |
US8478666B2 (en) | System and method for processing data related to management of financial assets | |
EP3794543A1 (en) | Automatic inter-bank reconciliation system | |
US20220277400A1 (en) | System and method for regular expression generation for improved data transfer | |
CN115147202A (en) | Banking business account processing system, method and device | |
TW202329022A (en) | Integrity verifying method, system and computer device of separated cross-platform trade and accounting, computer-readable medium | |
TWM627423U (en) | Integrity verification system and computer device for separation of cross-platform transaction and accounting | |
CN114169887A (en) | Reconciliation system based on distributed data nodes | |
CN113177772A (en) | Service data processing method, device and system | |
CN115310981A (en) | Transaction data processing method and device, electronic equipment and storage medium | |
CN113792533A (en) | Data processing method, data processing device, storage medium and electronic equipment | |
TWM596918U (en) | Automatic Recognition System for Key Customer Deals | |
KR100796056B1 (en) | System and method for integrated management of credit information | |
CN111209337A (en) | Financial report generation system, method, device, equipment and medium based on block chain | |
CA2555265A1 (en) | Account-owner verificaton database | |
CN114546872B (en) | Certificate management testing method and device, computer equipment and storage medium |