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 PDF

Info

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
Application number
TW111101642A
Other languages
Chinese (zh)
Other versions
TW202329022A (en
Inventor
高健盛
蔡忠航
呂亞璇
洪宸鈞
簡文助
李卓蓉
劉帥君
王茂勝
陳盈澤
許卉瑀
林健富
Original Assignee
玉山商業銀行股份有限公司
Filing date
Publication date
Application filed by 玉山商業銀行股份有限公司 filed Critical 玉山商業銀行股份有限公司
Priority to TW111101642A priority Critical patent/TWI831114B/en
Publication of TW202329022A publication Critical patent/TW202329022A/en
Application granted granted Critical
Publication of TWI831114B publication Critical patent/TWI831114B/en

Links

Images

Abstract

An integrity verifying method of separated cross-platform trade and accounting uses an accounting module of a computer system to produce corresponding accounting entries according to the transaction details from each trade device and send the accounting entries to a general ledger module of the computer system. The general ledger module produces a general ledger subject balance which includes accounting items and general ledger balances. The accounting module compares the transaction details and the transaction details included in a transaction detail aggregation file that comes from the same trade device and produces a compare result of transaction details. The accounting module produces an account balance aggregation file according to the ledger aggregation files provided by the trade devices and sends the account balance aggregation file to the general ledger module. The general ledger module checks the general ledger balances of the general ledger subject balance and the account balances of the account balance aggregation file and produces a total check report.

Description

跨平台交易與會計分離之完整性驗證方法、系統、電腦裝置及電腦可讀取的記錄媒體Integrity verification methods, systems, computer devices and computer-readable recording media for separation of cross-platform transactions and accounting

本發明是有關於一種交易資訊之驗證方法,特別是指一種針對交易裝置與會計系統分離機制的跨平台交易與會計分離之完整性驗證方法。 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 multiple transaction devices 1, and for convenience of explanation, Figure 2 only takes two transaction devices 1 (ie, transaction device A and transaction device B) as an example; each transaction device 1 can be installed at a counter of the financial institution. Or it is set up in a place other than a financial institution to provide customers with financial transaction services, such as a computer device that provides customer deposit services, foreign exchange services, etc. as a deposit system, a foreign exchange system, etc., and will generate data corresponding to financial transactions. A system of transaction details (i.e. accounting accounts); and the method of this embodiment is implemented by the integrity verification system of cross-platform transaction and accounting separation including the transaction devices 1 and a computer system 2 shown in Figure 2, The computer system 2 can communicate through a network (such as the Internet, a local area network or an internal network, etc.) communicates with the transaction devices 1 and includes an accounting module 21 and a general ledger module 22. Among them, as shown in Figure 2, the computer system 2 includes a first computer device 2A and a second computer device 2B that can communicate with each other (for example, through an intranet or a local network), and the accounting module 21 is The general ledger module 22 is a software program installed in the first computer device 2A and executed by the first computer device 2A. The general ledger module 22 is a software program installed in the second computer device 2B and executed by the second computer device 2B. , therefore, the first computer device 2A and the second computer device 2B can complete the method steps described below and shown in FIG. 1 by executing the accounting module 21 and the general ledger module 22 respectively.

或者,如圖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 computer system 2 can also be a single computer device (integrity verification computer device, hereinafter referred to as the computer device 2), and the accounting module 21 and the general ledger module 22 are installed on A software program in the computer device 2 and executed by the computer device 2 . Specifically, as shown in Figure 4, the computer device 2 at least includes a communication interface unit 23 (such as a network card) that can establish a connection with the transaction devices 1 for communication, and a storage device composed of a memory module. The unit 24 and a processing unit 25 (such as a central processing unit) are electrically connected to the communication interface unit 23 and the storage unit 24 . And after the processing unit 25 loads the software program including the accounting module 21 and the general ledger module 22 stored in a computer-readable recording medium (such as the storage unit 24) and executes the software program, the computer Device 2 will be able to perform the method steps described below and shown in Figure 1. In the following, the computer device (computer system) 2 will be used as an example for explanation.

首先,如圖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. Device 2.

然後,如圖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 accounting module 21 of the computer device 2 generates a corresponding accounting entry recording the transaction amount and its corresponding accounting item based on the received transaction details, for example, customer A If you deposit 500 yuan into an account in Bank Y through transaction device A, the transaction details will record: 1. The cash in Bank Y increases by 500 yuan, 2. Customer A deposits 500 yuan into the current savings deposit, and the corresponding accounting entries will be recorded. Will record: 1. Debit: 003 - Cash on hand 500, 2. Credit: 466 (code of accounting item) - Current savings deposit 500.

然後,如圖1的步驟S4,該會計核算模組21會即時傳送產生的各該會計分錄給該電腦裝置的該總帳模組22,該總帳模組22收到的該等會計分錄後,如圖1的步驟S5,該總帳模組22會根據該等會計分錄記錄的會計項目,將會計項目相同的該等會計分錄記錄的交易金額加總,而產生至少一包含會計項目及一總帳餘 額的總帳科目餘額。 Then, as shown in step S4 of FIG. 1 , the accounting module 21 will immediately transmit the generated accounting entries to the general ledger module 22 of the computer device, and the general ledger module 22 will receive the accounting entries. After recording, in step S5 of Figure 1 , the general ledger module 22 will add up the transaction amounts recorded in the accounting entries with the same accounting items according to the accounting items recorded in the accounting entries, and generate at least one transaction amount including Accounting items and general ledger balances The balance of the general ledger account.

因此,如圖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 accounting module 21 will continue to receive transaction details from each transaction device 1, and transfer each transaction device to The transaction details of 1 are recorded in a transaction details list stored in the storage unit 24 of the computer device 2. Therefore, the storage unit 24 will store multiple transaction details lists corresponding to different transaction devices 1 one-to-one; At the same time, the accounting module 21 generates corresponding accounting entries based on the transaction details and sends them to the general ledger module 22. The general ledger module 22 will successively receive the corresponding accounting entries based on the current accounting day. The accounting entries, the transaction amounts recorded by the accounting entries with the same accounting items are accumulated, and the totaled general ledger account balances for different accounting items are generated. For example, the general ledger module 22 is for accounting The general ledger balance recorded in the general ledger account balance generated by item 466 is 110. At the same time, the general ledger module 22 will also add up the same transaction amounts of other accounting items in the accounting entries to generate the same transaction amount as other accounting items. The balance of one or more other general ledger accounts corresponding to the item.

然後,如圖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 transaction device 1 will confirm whether all the transaction details generated on that day have been sent to the computer device 2 at the end of the current accounting day (that is, when the financial transaction services of the day are completed). , if not, then return to and repeat the above step S2; if yes, then as shown in step S7 of Figure 1 and Figure 5, each transaction device 1 generates a transaction details summary file and a branch summary file, and transmits the The transaction detail summary file and the account summary file are provided to the accounting module 21 of the computer device 2; wherein, each The transaction details summary file contains the transaction details generated by each trading device 1 before the end of the day (that day), that is, the transaction details summary file was sent to the transaction device 1 on the day it was compiled (the current accounting day). The file of all transaction details of the computer device 2; each account summary file is the accounting object (such as live deposit, time deposit and other products) and transaction type (such as this (money, interest, etc.) and their corresponding balances; taking Figure 6 as an example, assume that the household summary file A generated by the transaction device A contains two accounting objects (represented by codes AB02, AB03, different codes represent different businesses), and The transaction types are all B009 (represented by codes), and the balances are 10 and 20 respectively; the account summary file B generated by transaction device B contains two accounting objects (represented by codes AD01 and AE01), and the transaction types are also B009, and the balances are 30 and 40 respectively.

接著,當該會計核算模組21收到來自不同交易裝置1的該等交易明細彙整檔及該等分戶彙總檔後,如圖1的步驟S9和圖7所示,該會計核算模組21從該儲存單元24取出該等交易明細清單,並比對來自同一交易裝置1的該交易明細清單記錄的該等交易明細與該交易明細彙整檔包含的該等交易明細,例如圖7所示,依系統別以交易序號進行交叉比對,而產生對應於各該交易裝置1的一交易明細比對結果並儲存於該儲存單元24中,且如圖7所示,該交易明細比對結果主要記錄在該交易明細清單或該交易明細彙整檔中沒有出現的交易序號。藉此,即可對交易完整性進行驗證, 並根據比對結果察查交易明細在跨系統間傳遞的過程是否有資料遺失的問題。 Next, when the accounting module 21 receives the transaction detail summary files and the account summary files from different transaction devices 1, as shown in steps S9 and 7 of Figure 1, the accounting module 21 The transaction details list is retrieved from the storage unit 24, and the transaction details recorded in the transaction details list from the same transaction device 1 are compared with the transaction details contained in the transaction details summary file, for example, as shown in Figure 7, The transaction serial number is used for cross-reference according to the system, and a transaction details comparison result corresponding to each transaction device 1 is generated and stored in the storage unit 24. As shown in Figure 7, the transaction details comparison result is mainly Record the transaction serial number that does not appear in the transaction details list or the transaction details summary file. In this way, the integrity of the transaction can be verified. And based on the comparison results, check whether there is any data loss problem in the process of transferring transaction details between systems.

此外,如圖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 accounting module 21 will provide corresponding accounting items according to the accounting objects and transaction types of each account in the household summary file, and the household summary generated in FIG. 6 Taking file A and household summary file B as an example, the accounting module 21 will provide accounting objects and transaction types, for example, different accounting objects (AB02, AB03, AD01, AE01) but the same transaction type (code B009). The corresponding accounting item code, such as 466, and then add the balances of the accounts with the same accounting item (such as 466) in the account summary files to generate at least one accounting item (such as 466) and the corresponding The account balance summary file of an accounting balance (for example, the sum of the balances of the four same accounting items (items) shown in Figure 8 is 100), and as shown in steps S11 and 9 of Figure 1, the account balance summary file The accounting module 21 sends the at least one account balance summary file to the general ledger module 22 .

換句話說,當分戶彙總檔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 accounting module 21 According to the accounting object (AC01, AC03) and transaction type (A001), these accounts will be given corresponding accounting item codes, such as 460, and the accounting items in the sub-account summary files A and B will be 460. The balances of the accounts are summed to obtain an accounting balance, and another account balance summary file containing accounting items 460 and the corresponding accounting balance is generated, and so on. Therefore, the accountant The accounting module 21 may generate multiple account balance summary files for different accounting items based on the household summary file A and the household summary file B (and more household summary files from other transaction devices 1).

值得一提的是,在上述步驟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 transaction device 1 can also generate a message indicating that each transaction device 1 has completed the current accounting day. ) the daily cut signal of all accounting transactions, and transmit the daily cut signal together with the transaction detail summary file and the branch summary file to the computer device 2, and the accounting module 21 will receive the daily cut signal after receiving the daily cut signal. , the above-mentioned steps S9 and S10 are executed. In addition, there is no order of step S9 and step S10. Step S10 may also be executed first and then step S9.

然後,如圖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 general ledger module 22 checks the general ledger balance in the general ledger account balances with the same accounting items and the general ledger balance in the account balance summary file. The accounting balance, and generate multiple total score reconciliation reports containing accounting items and a difference corresponding to different accounting items; for example, as shown in Figure 9, taking accounting (accounting) item (item) 466 as an example, the general ledger module 22 Check the general ledger balance (110) in the general ledger account balance with an accounting item (item) of 466 and the accounting balance (100) in the account balance summary file, and generate the total score reconciliation report It contains accounting items (items) 466 and differences (10). In addition, the total score reconciliation report can also include information such as the accounting balance (100) and the general ledger balance (110). In this way, the accounting integrity can be verified, and the account amount corresponding to the same accounting item can be confirmed based on this report. Whether there is any calculation error in the calculation process between the accounting module 21 and the general ledger module 22.

綜上所述,上述實施例藉由該電腦裝置2的該會計核算模組21根據來自各該交易裝置1的各該交易明細產生相對應的該會計分錄,並傳送各該會計分錄給該電腦裝置2的該總帳模組22,使該總帳模組22根據接收到的該等會計分錄,將會計項目相同的該等會計分錄記錄的交易金額加總而產生包含會計項目及總帳餘額的總帳科目餘額;且該會計核算模組21藉由比對來自同一交易裝置1的該等交易明細與該交易明細彙整檔包含的該等交易明細,產生該交易明細比對結果,能對交易完整性進行驗證並確認交易明細在跨系統間傳遞時是否有資料遺失問題;並且,該總帳模組22藉由核對會計項目相同的總帳科目餘額中的該總帳餘額和該會計核算模組21提供之科目餘額彙總檔中的該會計餘額,產生包含會計項目和差額的總分核對報表,能對會計完整性進行驗證並確認同一會計項目的帳目金額在會計核算與總帳計算的過程中是否有計算錯誤的問題,以確保交易與會計兩者產出的資訊的完整性,而達到本發明的功效與目的。 To sum up, in the above embodiment, the accounting module 21 of the computer device 2 generates the corresponding accounting entries based on the transaction details from each transaction device 1, and transmits the accounting entries to The general ledger module 22 of the computer device 2 causes the general ledger module 22 to add up the transaction amounts recorded in the accounting entries with the same accounting items according to the received accounting entries to generate an accounting item including and the general ledger account balance of the general ledger balance; and the accounting module 21 generates the transaction details comparison result by comparing the transaction details from the same transaction device 1 with the transaction details included in the transaction details summary file , can verify the integrity of the transaction and confirm whether there is any data loss problem when the transaction details are transmitted between systems; and, the general ledger module 22 checks the general ledger balance and the general ledger balance in the same general ledger account balance of the accounting item. The accounting balance in the account balance summary file provided by the accounting module 21 generates a total score reconciliation report including accounting items and differences, which can verify the accounting integrity and confirm that the account amount of the same accounting item is reconciled between accounting and accounting. Whether there are any calculation errors in the process of general ledger calculation, to ensure the integrity of the information produced by both transactions and accounting, and to achieve the effect and purpose of the present invention.

惟以上所述者,僅為本發明之實施例而已,當不能以此限定本發明實施之範圍,凡是依本發明申請專利範圍及專利說明書內容所作之簡單的等效變化與修飾,皆仍屬本發明專利涵蓋之範圍 內。 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)

一種跨平台交易與會計分離之完整性驗證方法,應用於一金融機構,該金融機構具有多個交易裝置,各該交易裝置提供顧客金融交易服務並產生相對應的一交易明細;該方法包括:(A)各該交易裝置將當日產生的各該交易明細即時傳送給該金融機構的一電腦系統,該電腦系統的一會計核算模組根據接收到的各該交易明細產生相對應的一記錄交易金額及其對應的會計項目的會計分錄,並即時傳送各該會計分錄給該電腦系統的一總帳模組,使該總帳模組根據接收到的該等會計分錄記錄的會計項目,將會計項目相同的該等會計分錄記錄的交易金額加總而產生至少一包含會計項目及一總帳餘額的總帳科目餘額;該會計核算模組並將各該交易裝置的該等交易明細記錄於相對應的一交易明細清單;(B)各該交易裝置確認當日產生的該等交易明細皆已傳送給該電腦系統後,產生一交易明細彙整檔及一分戶彙總檔並傳送給該電腦系統的該會計核算模組;其中,各該交易明細彙整檔包含當日產生的該等交易明細,各該分戶彙總檔彙整當日進行金融交易的所有帳戶的核算對象、交易類型及餘額;(C)該會計核算模組比對來自同一交易裝置的該交易明細清單記錄的該等交易明細與該交易明細彙整檔包含的該等交易明細,而產生對應於各該交易裝置的一交 易明細比對結果,該交易明細比對結果記錄在該交易明細清單或該交易明細彙整檔中沒有出現的交易序號;(D)該會計核算模組根據該等分戶彙總檔中各該帳戶的核算對象和交易類型給予相對應的會計項目,並將該等分戶彙總檔中會計項目相同的該等帳戶的餘額加總而產生至少一包含會計項目和相對應的一會計餘額的科目餘額彙總檔,並傳送該至少一科目餘額彙總檔給該總帳模組;及(E)該總帳模組核對會計項目相同的該至少一總帳科目餘額中的該總帳餘額和該至少一科目餘額彙總檔中的該會計餘額,並產生至少一包含會計項目和一差額的總分核對報表。 An integrity verification method that separates cross-platform transactions and accounting, applied to a financial institution. The financial institution has multiple transaction devices, each of which provides customer financial transaction services and generates a corresponding transaction detail; the method includes: (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. , sum up the transaction amounts recorded in the accounting entries with the same accounting items to generate at least one general ledger account balance including accounting items and a general ledger balance; the accounting module adds the transactions of each transaction device The details are recorded in a corresponding transaction details list; (B) after each transaction device confirms that all transaction details generated on that day have been sent to the computer system, a transaction details summary file and a branch summary file are generated and sent to The accounting module of the computer system; wherein 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 performed financial transactions on that day; (C) The accounting module compares the transaction details recorded in the transaction details list from the same transaction device with the transaction details included in the transaction details summary file, and generates a transaction corresponding to each transaction device. The transaction details comparison results are recorded in the transaction details list or the transaction sequence number that does not appear in the transaction details summary file; (D) The accounting module calculates the transaction number based on the account in the sub-account summary file. The accounting objects and transaction types are given to the corresponding accounting items, and the balances of the accounts with the same accounting items in the account summary files are added up to generate at least one account balance that includes the accounting items and the corresponding accounting balance. summary file, and transmit the at least one account balance summary file to the general ledger module; and (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 at least one general ledger module The accounting balance in the account balance summary file is generated, and at least one total score reconciliation report containing accounting items and one difference is generated. 如請求項1所述跨平台交易與會計分離之完整性驗證方法,在步驟(B)中,各該交易裝置確認當日產生的該等交易明細皆已傳送給該電腦系統後,會產生一日切信號,並同時傳送該日切信號、該交易明細彙整檔和該分戶彙總檔給該會計核算模組;在步驟(C)中,該會計核算模組收到該日切信號後,才比對來自同一交易裝置的該交易明細清單記錄的該等交易明細與該交易明細彙整檔包含的該等交易明細;且在步驟(D)中,該會計核算模組收到該日切信號後,才根據該等分戶彙總檔中各該帳戶的核算對象和交易類型給予相對應的會計項目,並產生該至少一科目餘額彙總檔。 As described in request item 1 for the integrity verification method of separating cross-platform transactions and accounting, in step (B), after each transaction device confirms that all transaction details generated on that day have been transmitted to the computer system, a one-day cut signal, and simultaneously transmit the daily cut signal, the transaction detail summary file and the account summary file to the accounting module; in step (C), the accounting module only receives the daily cut signal. Compare the transaction details recorded in the transaction details list from the same transaction device with the transaction details included in the transaction details summary file; and in step (D), after the accounting module receives the day-cut signal , corresponding accounting items are given based on the accounting objects and transaction types of each account in the account summary file, and the at least one account balance summary file is generated. 如請求項1所述跨平台交易與會計分離之完整性驗證方法,在步驟(E)中,該總分核對報表還包含該總帳餘額和該會計餘額。 As described in request item 1 for the integrity verification method of separating cross-platform transactions and accounting, in step (E), the total score reconciliation report also includes the general ledger balance and the accounting balance. 如請求項1至3其中任一項所述跨平台交易與會計分離之完整性驗證方法,其中該電腦系統包括能互相通訊的一第一電腦裝置及一第二電腦裝置,且該會計核算模組是安裝在該第一電腦裝置中且被該第一電腦裝置執行的軟體程式,該總帳模組是安裝在該第二電腦裝置中且被該第二電腦裝置執行的軟體程式;或者,該電腦系統是一電腦裝置,且該會計核算模組及該總帳模組是安裝在該電腦裝置中且被該電腦裝置執行的軟體程式。 The integrity verification method for separating cross-platform transactions and accounting as described in any one of requests 1 to 3, wherein the computer system includes a first computer device and a second computer device that can communicate with each other, and the accounting model The group is a software program installed in and executed by the first 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 general ledger module are software programs installed in and executed by the computer device. 一種跨平台交易與會計分離之完整性驗證系統,應用於一金融機構,並包括:多個交易裝置,各該交易裝置提供顧客金融交易服務並產生相對應的一交易明細;及一電腦系統,其能與該等交易裝置通訊並包含一會計核算模組及一總帳模組;其中各該交易裝置將當日產生的各該交易明細即時傳送給該電腦系統,且該會計核算模組根據接收到的各該交易明細產生相對應的一記錄交易金額及其對應的會計項目的會計分錄,並即時傳送各該會計分錄給該總帳模組,該總帳模組根據接收到的該等會計分錄記錄的會計項目,將會計項目相同的該等會計分錄記錄的交易金額加總而產生至少一包含會計項目及一總帳餘額的總帳科目 餘額;該會計核算模組並將各該交易裝置的該等交易明細記錄於相對應的一交易明細清單;各該交易裝置確認當日產生的該等交易明細皆已傳送給該電腦系統後,各別產生一交易明細彙整檔及一分戶彙總檔並傳送給該電腦系統的該會計核算模組;其中,各該交易明細彙整檔包含當日產生的該等交易明細,各該分戶彙總檔彙整當日進行金融交易的所有帳戶的核算對象、交易類型及餘額;該會計核算模組比對來自同一交易裝置的該交易明細清單記錄的該等交易明細與該交易明細彙整檔包含的該等交易明細,而產生對應於各該交易裝置的一交易明細比對結果,該交易明細比對結果記錄在該交易明細清單或該交易明細彙整檔中沒有出現的交易序號;該會計核算模組根據該等分戶彙總檔中各該帳戶的核算對象和交易類型給予相對應的會計項目,並將該等分戶彙總檔中會計項目相同的該等帳戶的餘額加總而產生至少一包含會計項目和相對應的一會計餘額的科目餘額彙總檔,並傳送該至少一科目餘額彙總檔給該總帳模組;及該總帳模組核對會計項目相同的該至少一總帳科目餘額中的該總帳餘額和該至少一科目餘額彙總檔中的該會計餘額,並產生至少一包含會計項目和一差額的總分核對報表。 An integrity verification system that separates cross-platform transactions and accounting, is applied to a financial institution, and includes: multiple transaction devices, each of which provides customer financial transaction services and generates a corresponding transaction detail; and a computer system, It can communicate with the transaction devices and includes an accounting module and a general ledger module; each of the transaction devices immediately transmits the transaction details generated on the day to the computer system, and the accounting module receives the Each received transaction detail generates a corresponding accounting entry that records the transaction amount and its corresponding accounting item, and immediately transmits each accounting entry to the general ledger module. The general ledger module responds according to the received The accounting items recorded by the accounting entries are added together to generate at least one general ledger account containing the accounting items and one general ledger balance by adding up the transaction amounts recorded by the accounting entries with the same accounting items. balance; the accounting module records the transaction details of each transaction device in a corresponding transaction details list; after each transaction device confirms that all transaction details generated on the day have been transmitted to the computer system, each transaction A transaction detail summary file and a branch summary file are respectively generated and sent to the accounting module of the computer system; among them, each transaction detail summary file contains the transaction details generated on that day, and each branch summary file contains The accounting objects, transaction types and balances of all accounts that conduct financial transactions on that day; the accounting module compares the transaction details recorded in the transaction details list from the same transaction device with the transaction details included in the transaction details summary file , and generate a transaction details comparison result corresponding to each transaction device, and the transaction details comparison result records a transaction serial number that does not appear in the transaction details list or the transaction details summary file; the accounting module based on these The accounting objects and transaction types of each account in the account summary file are assigned to corresponding accounting items, and the balances of the accounts with the same accounting items in the account summary file are added up to generate at least one accounting item and related items. an account balance summary file corresponding to an accounting balance, and transmit the at least one account balance summary file to the general ledger module; and the general ledger module checks the general ledger in the at least one general ledger account balance with the same accounting item balance and the accounting balance in the at least one account balance summary file, and generate at least one total score reconciliation report including accounting items and one difference. 如請求項5所述跨平台交易與會計分離之完整性驗證系統,其中,各該交易裝置確認當日產生的該等交易明細皆已傳送給該電腦系統後,會產生一日切信號,並同時傳送該日切信號、該交易明細彙整檔和該分戶彙總檔給該會計核算模組;該會計核算模組收到該日切信號後,才比對來自同一交易裝置的該交易明細清單記錄的該等交易明細與該交易明細彙整檔包含的該等交易明細;且該會計核算模組收到該日切信號後,才根據該等分戶彙總檔中各該帳戶的核算對象和交易類型給予相對應的會計項目,並產生該至少一科目餘額彙總檔。 The cross-platform transaction and accounting integrity verification system as described in request item 5, wherein each trading device will generate a daily cut signal after confirming that all transaction details generated on that day have been transmitted to the computer system, and at the same time Send the daily cut signal, the transaction detail summary file and the account summary file to the accounting module; only after receiving the daily cut signal, the accounting module compares the transaction detail list records from the same transaction device The transaction details and the transaction details included in the transaction details summary file; and after the accounting module receives the daily cut signal, it will calculate the accounting objects and transaction types of each account in the account summary file. The corresponding accounting items are given and the balance summary file of at least one account is generated. 如請求項5所述跨平台交易與會計分離之完整性驗證系統,其中,該總分核對報表還包含該總帳餘額和該會計餘額。 The cross-platform transaction and accounting separation integrity verification system as described in request item 5, wherein the total score reconciliation report also includes the general ledger balance and the accounting balance. 如請求項5至7其中任一項所述跨平台交易與會計分離之完整性驗證系統,其中該電腦系統包括能互相通訊的一第一電腦裝置及一第二電腦裝置,且該會計核算模組是安裝在該第一電腦裝置中且被該第一電腦裝置執行的軟體程式,該總帳模組是安裝在該第二電腦裝置中且被該第二電腦裝置執行的軟體程式;或者,該電腦系統是一電腦裝置,且該會計核算模組及該總帳模組是安裝在該電腦裝置中且被該電腦裝置執行的軟體程式。 The integrity verification system for cross-platform transaction and accounting separation as described in any one of request items 5 to 7, wherein the computer system includes a first computer device and a second computer device that can communicate with each other, and the accounting model The group is a software program installed in and executed by the first 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 general ledger module are software programs installed in and executed by the computer device. 一種跨平台交易與會計分離之完整性驗證電腦裝置,應用於一金融機構,且能與該金融機構的多個交易裝置通訊,各該交易裝置提供顧客金融交易服務並產生相對應 的一交易明細,且各該交易裝置確認當日產生的該等交易明細皆已傳送給該電腦裝置後,產生一交易明細彙整檔及一分戶彙總檔並傳送給該電腦裝置,各該交易明細彙整檔包含當日產生的該等交易明細,各該分戶彙總檔彙整當日進行金融交易的所有帳戶的核算對象、交易類型及餘額;該電腦裝置包括:一通訊介面單元,與該等交易裝置建立連線以接收該等交易明細、該交易明細彙整檔及該分戶彙總檔;一儲存單元,儲存該等交易明細、該交易明細彙整檔及該分戶彙總檔;及一處理單元,與該通訊介面單元及該儲存單元電連接並包含一會計核算模組及一總帳模組;其中該會計核算模組根據該儲存單元儲存的各該交易明細產生相對應的一記錄交易金額及其對應的會計項目的會計分錄,並傳送各該會計分錄給該總帳模組,該總帳模組根據接收到的該等會計分錄記錄的會計項目,將會計項目相同的該等會計分錄記錄的交易金額加總而產生至少一包含會計項目及一總帳餘額的總帳科目餘額;該會計核算模組並將該儲存單元儲存之各該交易裝置的該等交易明細記錄於儲存在該儲存單元中相對應的一交易明細清單;該會計核算模組比對該儲存單元儲存之來自同一交易裝置的該交易明細清單記錄的該等交易明細與該交易明細彙整檔包含的該等交易明細,而產生對 應於各該交易裝置的一交易明細比對結果,並儲存該交易明細比對結果於該儲存單元,該交易明細比對結果記錄在該交易明細清單或該交易明細彙整檔中沒有出現的交易序號;該會計核算模組根據該儲存單元儲存之該等分戶彙總檔中各該帳戶的核算對象和交易類型給予相對應的會計項目,並將該等分戶彙總檔中會計項目相同的該等帳戶的餘額加總而產生至少一包含會計項目和相對應的一會計餘額的科目餘額彙總檔,並傳送該至少一科目餘額彙總檔給該總帳模組;該總帳模組核對會計項目相同的該至少一總帳科目餘額中的該總帳餘額和該至少一科目餘額彙總檔中的該會計餘額,而產生至少一包含會計項目和一差額的總分核對報表,並儲存該總分核對報表於該儲存單元。 A computer device for integrity verification that separates cross-platform transactions and accounting. It is used in a financial institution and can communicate with multiple transaction devices of the financial institution. Each transaction device provides customer financial transaction services and generates corresponding A transaction details, 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 of the transaction details The summary file contains the transaction details that occurred 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 computer device includes: a communication interface unit, established with the transaction device Connected to receive the transaction details, the transaction detail summary file and the account summary file; a storage unit to store the transaction details, the transaction detail summary file and the account summary file; and a processing unit to communicate with the The communication interface unit and the storage unit are electrically connected and include an accounting module and a general ledger module; wherein the accounting module generates a corresponding recorded transaction amount and its corresponding transaction amount based on each transaction details stored in the storage unit. The accounting entries of the accounting items are sent to the general ledger module. The general ledger module records the accounting items with the same accounting items based on the received accounting entries. The recorded transaction amounts are summed to generate at least one general ledger account balance including accounting items and a general ledger balance; the accounting module records the transaction details of each transaction device stored in the storage unit in the A corresponding transaction details list in the storage unit; the accounting module compares the transaction details recorded in the transaction details list from the same transaction device stored in the storage unit with the transactions included in the transaction details summary file details, resulting in the A transaction detail comparison result should be performed on each transaction device, and the transaction detail comparison result should be stored in the storage unit. The transaction detail comparison result should record transactions that do not appear in the transaction detail list or the transaction detail summary file. Serial number; the accounting module assigns corresponding accounting items according to the accounting objects and transaction types of each account in the account summary files stored in the storage unit, and assigns the accounting items in the account summary files with the same The balances of other accounts 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 accounting items The same general ledger balance in the 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 The reconciliation report is stored in this storage unit. 如請求項9述跨平台交易與會計分離之完整性驗證電腦裝置,其中,各該交易裝置確認當日產生的該等交易明細皆已傳送給該電腦裝置後,會產生一日切信號,並同時傳送該日切信號、該交易明細彙整檔和該分戶彙總檔給該會計核算模組;該會計核算模組收到該日切信號後,才比對來自同一交易裝置的該交易明細清單記錄的該等交易明細與該交易明細彙整檔包含的該等交易明細;且該會計核算模組收到該日切信號後,才根據該等分戶彙總 檔中各該帳戶的核算對象及交易類型給予相對應的會計項目,並產生該至少一科目餘額彙總檔。 For example, the integrity verification computer device for cross-platform transactions and accounting separation described in request item 9, wherein each transaction device will generate a daily signal after confirming that the transaction details generated on that day have been transmitted to the computer device, and at the same time Send the daily cut signal, the transaction detail summary file and the account summary file to the accounting module; only after receiving the daily cut signal, the accounting module compares the transaction detail list records from the same transaction device The transaction details and the transaction details included in the transaction details summary file; and the accounting module only summarizes according to the account divisions after receiving the daily cut signal. The accounting objects and transaction types of each account in the file are given corresponding accounting items, and the balance summary file of at least one account is generated. 如請求項9所述跨平台交易與會計分離之完整性驗證電腦裝置,其中,該總分核對報表還包含該總帳餘額和該會計餘額。 The computer device for integrity verification of cross-platform transaction and accounting separation as described in claim 9, wherein the total score reconciliation report also includes the general ledger balance and the accounting balance. 一種電腦可讀取的記錄媒體,其中儲存一包含一會計核算模組及一總帳模組的軟體程式,該軟體程式被一能與多個交易裝置通訊的電腦系統載入並執行後,該電腦系統能完成如請求項1至4其中任一項所述的跨平台交易與會計分離之完整性驗證方法;其中,各該交易裝置提供顧客金融交易服務並產生相對應的一交易明細,且各該交易裝置確認當日產生的該等交易明細皆已傳送給該電腦系統後,產生一交易明細彙整檔及一分戶彙總檔並傳送給該電腦系統,各該交易明細彙整檔包含當日產生的該等交易明細,各該分戶彙總檔彙整當日進行金融交易的所有帳戶的核算對象、交易類型及餘額。 A computer-readable recording medium that stores a software program including an accounting module and a general ledger module. After the software program is loaded and executed by a computer system that can communicate with multiple transaction devices, the software program The computer system can complete the integrity verification method of cross-platform transaction and accounting separation as described in any one of requests 1 to 4; wherein each transaction device provides customer financial transaction services and generates a corresponding transaction detail, and After each trading 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 computer system. Each transaction details summary file includes the transaction details generated on that day. These transaction details and each sub-account summary file summarize the accounting objects, transaction types and balances of all accounts that conduct financial transactions on that day.
TW111101642A 2022-01-14 Integrity verifying method, system and computer device of separated cross-platform trade and accounting, computer-readable medium TWI831114B (en)

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)

* Cited by examiner, † Cited by third party
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)

* Cited by examiner, † Cited by third party
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