Bank reconciliation data browsing system

Abstract

The present invention provides a bank reconciliation data browsing system, including: a view module and a service module; the view module is used to provide a display interface and an interactive interface for reconciliation data; the service module is used to download merchant reconciliation data from a bank server and store it in a local database, and then provide the merchant reconciliation data to the view module for display. The present invention has the following advantages: by using the bank reconciliation data browsing system provided by the present invention, reconciliation data can be flexibly queried according to a variety of conditions, and the page not only displays data details, but also summarizes and displays the currently queried reconciliation data; through the data column setting function, only the data columns that the merchant is interested in can be displayed; the system also provides manual / automatic export of reconciliation statements, reconciliation data summary function, reconciliation data import function, and reconciliation data deletion function; using the system can make merchants more efficient and convenient in reconciliation.

Description

Technical Field

[0001] The invention belongs to the field of computer information technology, and in particular relates to a bank reconciliation data browsing system. Background Art

[0002] Bank reconciliation data has always been an important basis for merchants to do reconciliation. However, currently the bank reconciliation data is only a T+1 Excel file. Merchants use Excel files for reconciliation, which has poor flexibility and operability. Moreover, this method has no summary function. If merchants need to view the summary data of the year / quarter / month, it is very difficult to achieve. Therefore, there is an urgent need for a browsing system with complete functions and strong operability. Summary of the invention

[0003] In view of the defects in the prior art, the present invention provides a bank reconciliation data browsing system, which can effectively solve the above problems.

[0004] The technical solution adopted by the present invention is as follows:

[0005] The present invention provides a bank reconciliation data browsing system, comprising: a view module and a service module;

[0006] The view module is used to provide a display interface and an interactive interface for reconciliation data;

[0007] The service module is used to download the merchant reconciliation data from the bank server and store it in the local database, and then provide the merchant reconciliation data to the view module for display through the TCP protocol. Specifically, it is implemented according to the following steps:

[0008] A1, setting a query condition input box on the display interface of the view module;

[0009] A2, when the view module receives the query condition input by the user through the query condition input box, the view module sends a merchant reconciliation data query request to the service module; wherein the merchant reconciliation data query request carries the query condition;

[0010] A3, when the service module receives a merchant reconciliation data query request, the service module first queries the local database using the query condition as the query keyword to determine whether there is merchant reconciliation data matching the query condition in the local database; if there is, execute A5; if not, execute A4;

[0011] A4, the service module downloads the merchant reconciliation data matching the query condition from the bank server according to the query condition; if the download fails, a notification message of query failure is returned to the view module; if the download is successful, the queried merchant reconciliation data is first stored in the local database, and then the found merchant reconciliation data is returned to the view module;

[0012] A5, the view module displays the merchant reconciliation data returned by the service module through the display interface.

[0013] Preferably, the view module further comprises a parameter editing interface; the parameter editing interface is associated with the editing menu of the display interface;

[0014] When the editing menu of the display interface is triggered, jump to the parameter editing interface;

[0015] The parameter editing interface has a variety of parameter configuration input boxes;

[0016] When the view module receives a variety of merchant reconciliation data editing parameters through the parameter configuration input box, the view module edits the merchant reconciliation data displayed on the associated display interface accordingly, obtains the edited merchant reconciliation data, and displays it through the display interface.

[0017] Preferably, the merchant reconciliation data editing parameters include: displaying only merchant reconciliation data in specific columns, and displaying only merchant reconciliation data in specific rows.

[0018] Preferably, the view module also includes a reconciliation data summary interface;

[0019] B1, the reconciliation data summary interface has a plurality of reconciliation data summary parameter configuration input boxes;

[0020] When the view module receives the reconciliation data summary parameter through the reconciliation data summary parameter configuration input box, the view module sends a reconciliation data summary request to the service module, wherein the reconciliation data summary request carries the reconciliation data summary parameter;

[0021] B2, when the service module receives the reconciliation data summary request, the service module first queries the local database with the reconciliation data summary parameter as the query condition to determine whether there is merchant reconciliation data matching the reconciliation data summary parameter in the local database, and if so, execute B4; if not, execute B3;

[0022] B3, the service module uses the reconciliation data summary parameter as a query condition to download the merchant reconciliation data matching the reconciliation data summary parameter from the bank server; if the download fails, a notification message of the summary failure is returned to the view module; if the download is successful, the queried merchant reconciliation data is first stored in the local database, and then B4 is executed;

[0023] B4, the service module performs corresponding aggregation processing on the queried merchant reconciliation data according to the reconciliation data aggregation parameter to obtain the aggregated merchant reconciliation data, and returns the aggregated merchant reconciliation data to the view module;

[0024] B5, the view module displays the aggregated merchant reconciliation data.

[0025] Preferably, the view module also includes a reconciliation file export interface;

[0026] When the view module receives an export request for the target merchant's reconciliation data through the reconciliation file export interface, the view module reads the corresponding target merchant's reconciliation data from the local database and exports it in the form of a csv / xlsx / txt file.

[0027] Preferably, the view module also includes a reconciliation file import interface;

[0028] When the view module receives an import request for a target merchant's reconciliation file through the reconciliation file import interface, the view module sends the target merchant's reconciliation file to the service module;

[0029] The service module parses the received target merchant reconciliation file and writes the target merchant reconciliation file into a local database.

[0030] Preferably, the view module also includes a file deletion interface;

[0031] When the view module receives a request to delete the target merchant's account reconciliation file through the file deletion interface, the view module sends the deletion request to the service module;

[0032] The service module deletes the target merchant reconciliation file in the local database.

[0033] Preferably, the view module further includes a timed export configuration interface;

[0034] When the view module receives a timed export request for a target merchant reconciliation file through the timed export configuration interface, the view module sends the timed export request to the service module;

[0035] The service module automatically and regularly exports the corresponding target merchant reconciliation file according to the scheduled export configuration parameters defined in the scheduled export configuration interface, and displays it through the view module.

[0036] The bank reconciliation data browsing system provided by the present invention has the following advantages:

[0037] By adopting the bank reconciliation data browsing system provided by the present invention, the reconciliation data can be flexibly queried according to various conditions. The page not only displays the data details, but also summarizes and displays the currently queried reconciliation data; through the data column setting function, only the data columns that the merchant is interested in can be displayed; the system also provides manual / automatic export of reconciliation statements, annual / quarterly / monthly summary of reconciliation data, import of reconciliation data into the local database, and deletion of reconciliation data in the local database; the use of the system can make merchants more efficient and convenient in reconciliation. BRIEF DESCRIPTION OF THE DRAWINGS

[0038] Figure 1 It is a structural schematic diagram of the bank reconciliation data browsing system provided by the present invention;

[0039] Figure 2 It is a schematic diagram of bank reconciliation data instruction interaction provided by the present invention. DETAILED DESCRIPTION

[0040] In order to make the technical problems, technical solutions and beneficial effects solved by the present invention more clearly understood, the present invention is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present invention and are not used to limit the present invention.

[0041] The bank reconciliation data browsing system provided by the present invention includes a view module and a service module; the view module is used to provide a display interface and an interactive interface; the service module is used to download merchant reconciliation data from a bank server and store it in a local database, and then provide the merchant reconciliation data to the view module for display through the TCP protocol. Using the bank reconciliation data browsing system provided by the present invention, multiple query conditions can be set to browse the reconciliation data, which is clearer and more concise; at the same time, the summary data of the year / quarter / month can be viewed, which is not possible with the current reconciliation files; the system also supports the export / import function of the reconciliation file; and the reconciliation process can be made more convenient and faster.

[0042] The present invention provides a bank reconciliation data browsing system, which can make merchant reconciliation more efficient and convenient.

[0043] refer to Figure 1 and Figure 2 ,The present invention provides a bank reconciliation data browsing system, including: a view module and a service module;

[0044] The view module is used to provide a display interface and an interactive interface for reconciliation data;

[0045] The service module is used to download the merchant reconciliation data from the bank server and store it in the local database, and then provide the merchant reconciliation data to the view module for display through the TCP protocol. Specifically, it is implemented according to the following steps:

[0046] A1, setting a query condition input box on the display interface of the view module; for example, a query condition input box such as start and end date, merchant number, terminal number, card number, etc.;

[0047] A2, when the view module receives the query condition input by the user through the query condition input box, the view module sends a merchant reconciliation data query request to the service module; wherein the merchant reconciliation data query request carries the query condition;

[0048] A3, when the service module receives a merchant reconciliation data query request, the service module first queries the local database using the query condition as the query keyword to determine whether there is merchant reconciliation data matching the query condition in the local database; if there is, execute A5; if not, execute A4;

[0049] A4, the service module downloads the merchant reconciliation data matching the query condition from the bank server according to the query condition; if the download fails, a notification message of query failure is returned to the view module; if the download is successful, the queried merchant reconciliation data is first stored in the local database, and then the found merchant reconciliation data is returned to the view module;

[0050] A5, the view module displays the merchant reconciliation data returned by the service module through the display interface for user browsing.

[0051] The view module also includes a parameter editing interface; the parameter editing interface is associated with the editing menu of the display interface;

[0052] When the editing menu of the display interface is triggered, jump to the parameter editing interface;

[0053] The parameter editing interface has a variety of parameter configuration input boxes;

[0054] When the view module receives multiple merchant reconciliation data editing parameters through the parameter configuration input box, the view module edits the merchant reconciliation data displayed on the associated display interface accordingly, obtains the edited merchant reconciliation data, and displays it through the display interface. The merchant reconciliation data editing parameters include, but are not limited to: only displaying merchant reconciliation data in a specific column, only displaying merchant reconciliation data in a specific row. In actual applications, before A1, the user can set the display columns to only display the data columns that he or she is concerned about.

[0055] The view module also includes a reconciliation data summary interface;

[0056] B1, the reconciliation data summary interface has a plurality of reconciliation data summary parameter configuration input boxes;

[0057] When the view module receives the reconciliation data summary parameter through the reconciliation data summary parameter configuration input box, the view module sends a reconciliation data summary request to the service module, wherein the reconciliation data summary request carries the reconciliation data summary parameter;

[0058] B2, when the service module receives the reconciliation data summary request, the service module first queries the local database with the reconciliation data summary parameter as the query condition to determine whether there is merchant reconciliation data matching the reconciliation data summary parameter in the local database, and if so, execute B4; if not, execute B3;

[0059] B3, the service module uses the reconciliation data summary parameter as a query condition to download the merchant reconciliation data matching the reconciliation data summary parameter from the bank server; if the download fails, a notification message of the summary failure is returned to the view module; if the download is successful, the queried merchant reconciliation data is first stored in the local database, and then B4 is executed;

[0060] B4, the service module performs corresponding aggregation processing on the queried merchant reconciliation data according to the reconciliation data aggregation parameter to obtain the aggregated merchant reconciliation data, and returns the aggregated merchant reconciliation data to the view module;

[0061] B5, the view module displays the aggregated merchant reconciliation data.

[0062] Therefore, through the above functions, users can open the summary interface to browse the summary data of the year / quarter / month.

[0063] The view module also includes a reconciliation file export interface;

[0064] When the view module receives an export request for the target merchant's reconciliation data through the reconciliation file export interface, the view module reads the corresponding target merchant's reconciliation data from the local database and exports it in the form of a csv / xlsx / txt file. Therefore, in the present invention, not only does it support users to browse the reconciliation data details, but it also supports users to choose to export the reconciliation data in the form of a csv / xlsx / txt file so that they can do the processing they need.

[0065] In addition to manually exporting statements, users can also set relevant configurations to the service module so that the service module can automatically export statements every day according to the configuration.

[0066] The view module also includes a reconciliation file import interface;

[0067] When the view module receives an import request for a target merchant's reconciliation file through the reconciliation file import interface, the view module sends the target merchant's reconciliation file to the service module;

[0068] The service module parses the received target merchant reconciliation file and writes the target merchant reconciliation file into a local database.

[0069] Through the reconciliation file import function, the reconciliation file obtained by the user through other channels can be imported into the local data for the user to browse.

[0070] The view module also includes a file deletion interface;

[0071] When the view module receives a request to delete the target merchant's account reconciliation file through the file deletion interface, the view module sends the deletion request to the service module;

[0072] The service module deletes the target merchant reconciliation file in the local database.

[0073] Therefore, through the file deletion function, users can initiate a request to the service module to delete the reconciliation data in the view module, and then clear the old date data in the local database to avoid software jams caused by excessive data accumulation.

[0074] The view module also includes a timed export configuration interface;

[0075] When the view module receives a timed export request for a target merchant reconciliation file through the timed export configuration interface, the view module sends the timed export request to the service module;

[0076] The service module automatically and regularly exports the corresponding target merchant reconciliation file according to the scheduled export configuration parameters defined in the scheduled export configuration interface, and displays it through the view module.

[0077] The present invention provides a bank reconciliation data browsing system, which can be based on the window operating system, the system version needs to be XP and above, and can be installed and used on x86 or x64 systems. The view module is based on the DuiLib framework and is developed using the C++ language. The service module is developed using the Python language. As long as it is a normal non-cropped window, the above system can be used. No third-party software support is required.

[0078] By adopting the above technical solution disclosed in the present invention, the following beneficial effects are obtained:

[0079] 1.Flexibly select query conditions, including start and end date / merchant number / terminal number / card number / transaction type / payment channel, etc. You can not only browse all transaction details, but also query certain transaction details in a targeted manner.

[0080] 2. The reconciliation file export function can be exported in csv / xlsx / txt format, and special processing can be performed according to your needs

[0081] 3. Yearly / quarterly / monthly summary function, the transaction volume is clear and easy to see at a glance.

[0082] 4. The reconciliation file import function can import the reconciliation files obtained by users through other channels into the database.

[0083] In addition to the above-mentioned system, an embodiment of the present disclosure may also be a computer program product, which includes computer program instructions, which, when executed by a processor, enable the processor to execute the steps of the method for acquiring text information according to various embodiments of the present disclosure described in the above-mentioned "Exemplary Method" section of this specification.

[0084] The computer program product may be written in any combination of one or more programming languages ​​to write program code for performing the operations of the disclosed embodiments, including object-oriented programming languages ​​such as Java, C++, etc., and conventional procedural programming languages ​​such as "C" or similar programming languages. The program code may be executed entirely on the user computing device, partially on the user device, as a separate software package, partially on the user computing device and partially on a remote computing device, or entirely on a remote computing device or server.

[0085] In addition, an embodiment of the present disclosure may also be a computer-readable storage medium having computer program instructions stored thereon, which, when executed by a processor, enables the processor to execute the steps of the method for acquiring text information according to various embodiments of the present disclosure described in the above “Exemplary Method” section of this specification.

[0086] The computer readable storage medium can adopt any combination of one or more readable media. The readable medium can be a readable signal medium or a readable storage medium. The readable storage medium can include, for example, but is not limited to, a system, device or device of electricity, magnetism, light, electromagnetic, infrared, or semiconductor, or any combination of the above. More specific examples (non-exhaustive list) of readable storage media include: an electrical connection with one or more wires, a portable disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above.

[0087] The basic principles of the present disclosure are described above in conjunction with specific embodiments. However, it should be noted that the advantages, strengths, effects, etc. mentioned in the present disclosure are only examples and not limitations, and it cannot be considered that these advantages, strengths, effects, etc. are required by each embodiment of the present disclosure. In addition, the specific details disclosed above are only for the purpose of illustration and ease of understanding, and are not limitations. The above details do not limit the present disclosure to the necessity of adopting the above specific details to be implemented.

[0088] The block diagrams of the devices, apparatuses, equipment, and systems involved in this disclosure are only illustrative examples and are not intended to require or imply that they must be connected, arranged, and configured in the manner shown in the block diagrams. As will be appreciated by those skilled in the art, these devices, apparatuses, equipment, and systems can be connected, arranged, and configured in any manner. Words such as "including", "comprising", "having", etc. are open words, referring to "including but not limited to", and can be used interchangeably with them. The words "or" and "and" used here refer to the words "and / or" and can be used interchangeably with them, unless the context clearly indicates otherwise. The word "such as" used here refers to the phrase "such as but not limited to", and can be used interchangeably with it.

[0089] The method and apparatus of the present disclosure may be implemented in many ways. For example, the method and apparatus of the present disclosure may be implemented by software, hardware, firmware, or any combination of software, hardware, and firmware. The above order of steps for the method is for illustration only, and the steps of the method of the present disclosure are not limited to the order specifically described above, unless otherwise specifically stated. In addition, in some embodiments, the present disclosure may also be implemented as a program recorded in a recording medium, which includes machine-readable instructions for implementing the method according to the present disclosure. Therefore, the present disclosure also covers a recording medium storing a program for executing the method according to the present disclosure.

[0090] It should also be noted that in the apparatus, equipment and method of the present disclosure, each component or each step can be decomposed and / or recombined. These decompositions and / or recombinations should be regarded as equivalent schemes of the present disclosure. The above description of the disclosed aspects is provided to enable any technician in the field to make or use the present disclosure. Various modifications to these aspects are very obvious to those skilled in the art, and the general principles defined herein can be applied to other aspects without departing from the scope of the present disclosure. Therefore, the present disclosure is not intended to be limited to the aspects shown here, but to the widest scope consistent with the principles and novel features disclosed herein.

[0091] The above description has been given for the purpose of illustration and description. In addition, this description is not intended to limit the embodiments of the present disclosure to the forms disclosed herein. Although multiple example aspects and embodiments have been discussed above, those skilled in the art will recognize certain variations, modifications, changes, additions and sub-combinations thereof.

Claims

1. A bank reconciliation data browsing system, characterized in that: include: View module and service module; The view module is used to provide a display interface and an interactive interface for reconciliation data; The service module is used to download the merchant reconciliation data from the bank server and store it in the local database, and then provide the merchant reconciliation data to the view module for display through the TCP protocol. Specifically, it is implemented according to the following steps: A1, setting a query condition input box on the display interface of the view module; A2, when the view module receives the query condition input by the user through the query condition input box, the view module sends a merchant reconciliation data query request to the service module; wherein the merchant reconciliation data query request carries the query condition; A3, when the service module receives a merchant reconciliation data query request, the service module first queries the local database using the query condition as the query keyword to determine whether there is merchant reconciliation data matching the query condition in the local database; if there is, execute A5; if not, execute A4; A4, the service module downloads the merchant reconciliation data matching the query condition from the bank server according to the query condition; if the download fails, a notification message of query failure is returned to the view module; if the download is successful, the queried merchant reconciliation data is first stored in the local database, and then the found merchant reconciliation data is returned to the view module; A5, the view module displays the merchant reconciliation data returned by the service module through the display interface; The view module also includes a reconciliation data summary interface; B1, the reconciliation data summary interface has a plurality of reconciliation data summary parameter configuration input boxes; When the view module receives the reconciliation data summary parameter through the reconciliation data summary parameter configuration input box, the view module sends a reconciliation data summary request to the service module, wherein the reconciliation data summary request carries the reconciliation data summary parameter; B2, when the service module receives the reconciliation data summary request, the service module first queries the local database with the reconciliation data summary parameter as the query condition to determine whether there is merchant reconciliation data matching the reconciliation data summary parameter in the local database, and if so, execute B4; if not, execute B3; B3, the service module uses the reconciliation data summary parameter as a query condition to download the merchant reconciliation data matching the reconciliation data summary parameter from the bank server; if the download fails, a notification message of the summary failure is returned to the view module; if the download is successful, the queried merchant reconciliation data is first stored in the local database, and then B4 is executed; B4, the service module performs corresponding aggregation processing on the queried merchant reconciliation data according to the reconciliation data aggregation parameter to obtain the aggregated merchant reconciliation data, and returns the aggregated merchant reconciliation data to the view module; B5, the view module displays the aggregated merchant reconciliation data.

2. The bank reconciliation data browsing system according to claim 1, characterized in that: The view module also includes a parameter editing interface; the parameter editing interface is associated with the editing menu of the display interface; When the editing menu of the display interface is triggered, jump to the parameter editing interface; The parameter editing interface has a variety of parameter configuration input boxes; When the view module receives a variety of merchant reconciliation data editing parameters through the parameter configuration input box, the view module edits the merchant reconciliation data displayed on the associated display interface accordingly, obtains the edited merchant reconciliation data, and displays it through the display interface.

3. The bank reconciliation data browsing system according to claim 2, characterized in that: The merchant reconciliation data editing parameters include: displaying only merchant reconciliation data in a specific column, and displaying only merchant reconciliation data in a specific row.

4. The bank reconciliation data browsing system according to claim 1, characterized in that: The view module also includes a reconciliation file export interface; When the view module receives an export request for the target merchant's reconciliation data through the reconciliation file export interface, the view module reads the corresponding target merchant's reconciliation data from the local database and exports it in the form of a csv / xlsx / txt file.

5. The bank reconciliation data browsing system according to claim 1, characterized in that: The view module also includes a reconciliation file import interface; When the view module receives an import request for a target merchant's reconciliation file through the reconciliation file import interface, the view module sends the target merchant's reconciliation file to the service module; The service module parses the received target merchant reconciliation file and writes the target merchant reconciliation file into a local database.

6. The bank reconciliation data browsing system according to claim 1, characterized in that: The view module also includes a file deletion interface; When the view module receives a request to delete the target merchant's account reconciliation file through the file deletion interface, the view module sends the deletion request to the service module; The service module deletes the target merchant reconciliation file in the local database.

7. The bank reconciliation data browsing system according to claim 1, characterized in that: The view module also includes a timed export configuration interface; When the view module receives a timed export request for a target merchant reconciliation file through the timed export configuration interface, the view module sends the timed export request to the service module; The service module automatically and regularly exports the corresponding target merchant reconciliation file according to the scheduled export configuration parameters defined in the scheduled export configuration interface, and displays it through the view module.

Images