CN117350869A - Financial document generation method, apparatus, electronic device and computer readable storage medium - Google Patents
Financial document generation method, apparatus, electronic device and computer readable storage medium Download PDFInfo
- Publication number
- CN117350869A CN117350869A CN202310707593.4A CN202310707593A CN117350869A CN 117350869 A CN117350869 A CN 117350869A CN 202310707593 A CN202310707593 A CN 202310707593A CN 117350869 A CN117350869 A CN 117350869A
- Authority
- CN
- China
- Prior art keywords
- financial
- voucher
- data
- financial data
- source system
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 48
- 238000003860 storage Methods 0.000 title claims abstract description 24
- 238000012550 audit Methods 0.000 claims description 5
- 238000010586 diagram Methods 0.000 description 11
- 238000004590 computer program Methods 0.000 description 7
- 230000006870 function Effects 0.000 description 7
- 230000008520 organization Effects 0.000 description 7
- 238000012545 processing Methods 0.000 description 7
- 230000008569 process Effects 0.000 description 6
- 238000013507 mapping Methods 0.000 description 5
- 230000003287 optical effect Effects 0.000 description 5
- 238000004891 communication Methods 0.000 description 3
- 238000005516 engineering process Methods 0.000 description 2
- 238000007726 management method Methods 0.000 description 2
- 238000004519 manufacturing process Methods 0.000 description 2
- 239000013307 optical fiber Substances 0.000 description 2
- 230000000644 propagated effect Effects 0.000 description 2
- 239000004065 semiconductor Substances 0.000 description 2
- 230000007474 system interaction Effects 0.000 description 2
- 239000002699 waste material Substances 0.000 description 2
- 230000003796 beauty Effects 0.000 description 1
- 238000004140 cleaning Methods 0.000 description 1
- 210000001520 comb Anatomy 0.000 description 1
- 239000000835 fiber Substances 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 238000005259 measurement Methods 0.000 description 1
- 238000004801 process automation Methods 0.000 description 1
- 238000007619 statistical method Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/12—Accounting
- G06Q40/125—Finance or payroll
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
- G06F16/285—Clustering or classification
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Data Mining & Analysis (AREA)
- Computational Linguistics (AREA)
- General Business, Economics & Management (AREA)
- Technology Law (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Strategic Management (AREA)
- General Health & Medical Sciences (AREA)
- Marketing (AREA)
- Economics (AREA)
- Development Economics (AREA)
- Mathematical Physics (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The application relates to a financial document generation method, a financial document generation device, electronic equipment and a computer readable storage medium. The method comprises the following steps: acquiring financial data of at least one source system, defining a corresponding business table for each source system, determining a voucher scheme of the financial data, and defining a voucher line value rule of a financial voucher to be generated; and configuring a voucher template based on the value rule to generate the financial voucher. According to the embodiment of the application, the financial data of the systems with different sources are automatically acquired, the voucher generation template is automatically established, the financial vouchers are automatically generated according to the financial data and the preset financial rules and the financial vouchers, so that the financial vouchers can be quickly and accurately generated, the labor cost is saved, and the error rate of the financial vouchers is effectively reduced.
Description
Technical Field
The present disclosure relates to the field of data processing technologies, and in particular, to a method and apparatus for generating a financial credential, an electronic device, and a computer readable storage medium.
Background
Along with the rapid expansion and continuous expansion of enterprise business, part of financial systems used by companies are mutually independent from business systems in the companies and business systems on a third party internet platform, and in the traditional accounting process, financial staff need to manually fill financial certificates into an account book or register the financial certificates into a accounting system according to the generated business, and financial data sources possibly originate from a plurality of business systems, including a group purchasing system, a sales system, an office system, a production system and the like, and possibly originate from bills provided by a third party e-commerce system, and different account covers are needed for accounting, so that the conditions of inconsistent certificates and business are easily caused, thereby not only having large workload, time and labor waste, low efficiency and easy error.
Disclosure of Invention
In order to solve or partially solve the problems existing in the related art, the application provides a financial document generation method, a device, an electronic device and a computer readable storage medium, which can automatically acquire financial data of systems with different sources and automatically generate financial documents.
A first aspect of the present application provides a financial credential generation method, including:
obtaining financial data of at least one source system, the financial data comprising data for generating financial credentials;
defining a corresponding service table for each source system, wherein the service table is used for storing financial data of the source system corresponding to the service table;
determining a voucher scheme of the financial data, and defining a value rule of a voucher row of the financial voucher to be generated based on the voucher scheme;
and configuring a voucher template based on the value rule, and generating a financial voucher based on the voucher template. As a possible embodiment of the present application, in this embodiment, the obtaining financial data of at least one source system includes:
when the source system of the financial data is a business system, calling the financial data of the business system by adopting a preset open API interface;
when the source system of the financial data is a third-party internet transaction system, acquiring a data document of the third-party internet transaction system by adopting a preset RPA, and acquiring the financial data based on the data document.
As a possible implementation manner of the present application, in this implementation manner, the defining, for each source system, a corresponding service table includes:
and determining the service type corresponding to the financial data, and constructing a service table for storing at least the financial data and a source system and service types corresponding to the financial data.
As a possible implementation manner of the present application, in this implementation manner, the determining a credential scheme of the financial data, defining a value rule of a credential row of the financial credential to be generated based on the credential scheme, includes:
determining a source system of the financial data and a service type of the financial data, and determining a financial sleeve for generating financial credentials and an initial credential template corresponding to the financial sleeve based on the source system and the service type;
and configuring a value rule of a voucher row for generating the financial voucher based on the service type and the financial type of the financial data.
As a possible implementation manner of the present application, in this implementation manner, the configuring a credential template based on the value rule and generating a financial credential based on the credential template includes:
configuring a voucher header of a financial voucher to be generated based on the initial voucher template;
and generating the certificate row of the financial certificate to be generated in the financial data based on the value rule of the certificate row of the financial certificate to be generated.
As a possible embodiment of the present application, after the acquiring the financial data of the at least one source system, the method further includes:
determining a credential type corresponding to the financial data, and when the credential type is a cost credential, the method further comprises:
the present accounting table is generated based on preset accounting rules.
As a possible embodiment of the present application, in this embodiment, the financial credential generating method further includes:
pushing the generated financial certificate to a financial system by adopting a preset API (application program interface) of the financial system;
upon receiving an audit pass notification of the financial system, a credential summary table of the financial data is generated, the financial summary table including all financial credentials of the financial data.
A second aspect of the present application provides a financial instrument generation apparatus comprising:
a data acquisition module for acquiring financial data of at least one source system, the financial data comprising data for generating financial credentials;
the business table determining module is used for defining a corresponding business table for each source system, and the business table is used for storing financial data of the source system corresponding to the business table;
the voucher scheme determining module is used for determining a voucher scheme of the financial data, and defining a value rule of a voucher row for generating the financial voucher based on the voucher scheme;
and the voucher generation module is used for configuring a voucher template based on the value rule and generating a financial voucher based on the voucher template.
A third aspect of the present application provides an electronic device, comprising:
a processor; and
a memory having executable code stored thereon which, when executed by the processor, causes the processor to perform the method as described above.
A fourth aspect of the present application provides a computer readable storage medium having stored thereon executable code which, when executed by a processor of an electronic device, causes the processor to perform a method as described above.
According to the embodiment of the application, the financial data of different source systems are automatically acquired, the voucher generation template is automatically established, the corresponding relation between each financial data item and the account entry subject is automatically established according to the financial data and the preset financial rules, the corresponding relation between each financial data item and the account entry subject classification number specified by the account entry subject and the account entry subject classification number is automatically established according to the corresponding relation between the account entry subject and the account entry subject classification number, the financial voucher is automatically generated according to the voucher accounting rules, the financial voucher can be quickly and accurately generated, the labor cost is saved, and the error rate of the financial voucher is effectively reduced.
It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the application.
Drawings
The foregoing and other objects, features and advantages of the application will be apparent from the following more particular descriptions of exemplary embodiments of the application as illustrated in the accompanying drawings wherein like reference numbers generally represent like parts throughout the exemplary embodiments of the application.
FIG. 1 is a flow chart of a method of generating financial credentials, as shown in embodiments of the present application;
fig. 2 is a flow chart of a value rule determining method according to an embodiment of the present application;
FIG. 3 is a flow diagram of a financial credential generation process shown in embodiments of the present application;
FIG. 4 is a system interaction diagram illustrating an embodiment of the present application;
FIG. 5 is a schematic diagram of a financial credential generation device provided in an embodiment of the present application;
fig. 6 is a schematic structural diagram of an electronic device according to an embodiment of the present application.
The above and other features, advantages, and aspects of embodiments of the present disclosure will become more apparent by reference to the following detailed description when taken in conjunction with the accompanying drawings. The same or similar reference numbers will be used throughout the drawings to refer to the same or like elements. It should be understood that the figures are schematic and that elements and components are not necessarily drawn to scale.
Detailed Description
Embodiments of the present application will be described in more detail below with reference to the accompanying drawings. While embodiments of the present application are shown in the drawings, it should be understood that the present application may be embodied in various forms and should not be limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the disclosure to those skilled in the art.
The terminology used in the present application is for the purpose of describing particular embodiments only and is not intended to be limiting of the present application. As used in this application and the appended claims, the singular forms "a," "an," and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise. It should also be understood that the term "and/or" as used herein refers to and encompasses any or all possible combinations of one or more of the associated listed items.
It should be understood that although the terms "first," "second," "third," etc. may be used herein to describe various information, these information should not be limited by these terms. These terms are only used to distinguish one type of information from another. For example, a first message may also be referred to as a second message, and similarly, a second message may also be referred to as a first message, without departing from the scope of the present application. Thus, a feature defining "a first" or "a second" may explicitly or implicitly include one or more such feature. In the description of the present application, the meaning of "a plurality" is two or more, unless explicitly defined otherwise.
Along with the rapid expansion and continuous expansion of enterprise business, part of financial systems used by companies are mutually independent from business systems in the companies and business systems on a third party internet platform, and in the traditional accounting process, financial staff need to manually fill financial certificates into an account book or register the financial certificates into a accounting system according to the generated business, and financial data sources possibly originate from a plurality of business systems, including a group purchasing system, a sales system, an office system, a production system and the like, and possibly originate from bills provided by a third party e-commerce system, and different account covers are needed for accounting, so that the conditions of inconsistent certificates and business are easily caused, thereby not only having large workload, time and labor waste, low efficiency and easy error.
In view of the above problems, embodiments of the present application provide a method, an apparatus, an electronic device, and a computer readable storage medium for generating a financial document, which can automatically acquire financial data of systems of different sources and automatically generate the financial document.
FIG. 1 is a flow chart diagram of a financial credential generation method shown in an embodiment of the present application.
Referring to fig. 1, the financial credential generation method provided in the embodiment of the present application includes:
step S101, obtaining financial data of at least one source system, the financial data comprising data for generating financial credentials.
In the embodiment of the application, the financial data refers to source data required by financial staff in making financial certificates, and is data for reflecting financial conditions and operation achievements of enterprises, including but not limited to financial account book data, report data, such as sales data, cash flow data and the like, and based on the financial data, the financial certificates can be generated.
As a possible embodiment of the present application, in this embodiment, the obtaining financial data of at least one source system includes:
when the source system of the financial data is a business system, calling the financial data of the business system by adopting a preset open API (Application Programming Interface, application program interface) interface;
when the source system of the financial data is a third-party internet transaction system, a preset RPA (Robotic process automation, robot flow automation) is adopted to acquire a data document of the third-party internet transaction system, and the financial data is acquired based on the data document.
In the embodiment of the present application, different methods may be used to obtain financial data according to different source systems of the financial data, specifically, when the source system of the financial data is a business system of an enterprise, call may be performed through an open API interface preset in the business system, specifically, for example, for financial data of the enterprise, the financial data is directly called through the system to make a credential; when the source system of the financial data is a third-party internet transaction system, acquiring a data document of the third-party internet transaction system by adopting a preset RPA, and acquiring the financial data based on the data document; specifically, for example, an excel data document of the financial data of the third party internet transaction system can be downloaded through a preset RPA financial robot, and then the excel data document is extracted to obtain the financial data.
According to the method and the system, financial data of different source systems are automatically acquired, and different automatic financial data acquisition modes are adopted for the business system of the enterprise and the third-party Internet transaction system respectively, so that the method and the system can adapt to the acquisition of the financial data of different source systems.
Step S102, defining a corresponding service table for each source system, wherein the service table is used for storing financial data of the source system corresponding to the service table.
In the embodiment of the application, the financial credentials finally generated by the financial data of different source systems may be different, and the data content in the financial data of different source systems may also be different, so that different service tables are required when the financial data of different source systems are stored. The business table is used for storing financial data and other financial information corresponding to the financial data, and for each source system, a business table matched with the business table needs to be defined for storing the financial data.
As a possible implementation manner of the present application, in this implementation manner, the defining, for each source system, a corresponding service table includes:
determining the business type corresponding to the financial data, and constructing a business table for storing at least the financial data and the source system and the business type corresponding to the financial data
In this embodiment of the present application, as one possible implementation manner of the present application, each source system has a service table corresponding to financial data of the source system, where the service table refers to a table for performing statistical analysis on service contents and data, and according to different service needs of different enterprises, multiple forms of service tables are generated, and as one possible manner, the service tables are recorded with contents such as source system of financial data, service classification, table coding, table fields, service header number fields, and the like.
Step S103, determining a voucher scheme of the financial data, and defining a value rule of a voucher row of the financial voucher to be generated based on the voucher scheme.
In this embodiment of the present application, the voucher scheme is used to specify a format of a financial voucher to be generated, such as a source system indicating financial data, a service type indicating financial data, and the like, and may be directly located to a service table storing financial data through the voucher scheme, and meanwhile, the voucher scheme may define contents such as an account cover used for generating the financial voucher, a voucher template corresponding to the account cover, a status of the voucher (temporary storage voucher, submitted voucher), and generation timeliness (real-time generation, post-generation, scheduling generation).
As a possible implementation manner of the present application, in this implementation manner, as shown in fig. 2, the determining a credential scheme of the financial data, defining a value rule of a credential row of a financial credential to be generated based on the credential scheme, includes:
step S201, determining a source system of the financial data and a service type of the financial data, and determining a financial sleeve for generating financial credentials and an initial credential template corresponding to the financial sleeve based on the source system and the service type.
In the embodiment of the application, according to different financial data, the service types of the corresponding generated financial certificates are different, and the income certificate comprises a pre-sale card cross-store consumption business certificate, an inter-store settlement certificate, a public praise cooperative certificate, a beauty group takeaway collection user certificate, a POS collection user certificate, a cash inventory certificate and the like, and the cost certificate comprises a purchase warehouse-in certificate, an allocation warehouse-out certificate and the like. According to each voucher type, the financial data are combed to obtain information such as an affiliated organization, a voucher type, an accounting year, a source system, an accounting account book and the like corresponding to the financial data, and an organization map is defined, so that the source system data can be conveniently transmitted to the financial vouchers and then the corresponding financial organization can be distinguished, and the organization map comprises source system fields, organization fields and financial organization fields.
In this embodiment of the present application, before generating a financial document corresponding to financial data, accounting basic data needs to be prepared, and data maintained in industry and financial integration according to account covers, accounting structures, rate tables, and the like of a financial system specifically includes: account holders, financial organizations (cost centers), subject systems (subjects), accounting structures, ancillary accounting, exchange rate schemes, special ledger identifications, cash flows, billing codes, special ledger types, voucher types, dimensions, coin types, metering units, etc., if there are multiple account holders in one external accounting system, the same number of account holders and subject systems are established.
Step S202, based on the business type and the financial type of the financial data, configuring a value rule of a certificate row for generating the financial certificate.
In this embodiment, after determining the credential scheme, the mapping table is defined based on the credential scheme, and the corresponding value rule is configured according to the target value and two influencing factors of business and finance.
Step S104, a voucher template is configured based on the value rule, and a financial voucher is generated based on the voucher template.
In this embodiment, as shown in fig. 3, the configuring a credential template based on the value rule and generating a financial credential based on the credential template includes:
step S301, configuring a voucher head of a financial voucher to be generated based on the initial voucher template;
step S302, based on the value rule of the certificate row of the to-be-generated financial certificate, the value is taken in the financial data, and the certificate row of the to-be-generated financial certificate is generated.
In an embodiment of the present application, the initial voucher template includes a voucher header of the financial voucher, each voucher row, the voucher header including an accounting body, a ledger, a digest, a voucher code, a voucher type, a service date, a billing date, and the like. The voucher lines include line type, lending direction, accounting subjects, ancillary accounting, cash flow, units of measure, quantity, etc. The row's value rules include, but are not limited to, row type: setting the payment line as a fee line, a check-out line, a payment line and the like according to the requirement; the direction is: indicating the corresponding lending direction of the transaction; subject(s): associating with the specified related subject mapping table by utilizing SQL sentences; auxiliary accounting: associating the SQL statement with the specified service field and the related auxiliary accounting mapping table; cash flow: associating with the related cash flow mapping table by utilizing SQL sentences; data, measurement unit, coin number, original coin amount, home coin unit, home coin amount: these fields may be defined in the accounting structure if accounting quantity or foreign currency data is required. Of course, the above embodiment is only one possible implementation of the present application, and may be specifically set according to practical situations.
As one possible implementation of the application, each revenue voucher includes fields slightly different according to different financial revenue voucher types, such as a pre-sale card cross-store consumption transaction voucher including a card-opening store code, a card-opening store name-city-brand, a store-opening code, a store-opening name-city-brand, a check-out date, an account book, an accounting body, a department, an item, an amount, a revenue accounting person, a voucher number, and each cost voucher includes fields slightly different, such as a purchase-in voucher including an affiliated period, a store-opening code, a store-opening name-city-brand, a department, an account book, a voucher number, an item, a borrower-medical category, a borrower-sales category, a borrower aggregate, a lender amount, a borrower check-up, an NC push status, a push failure cause classification, failure cause detail field, and the like.
As a possible embodiment of the present application, after the acquiring the financial data of the at least one source system, the method further includes:
determining a credential type corresponding to the financial data, and when the credential type is a cost credential, the method further comprises:
the present accounting table is generated based on preset accounting rules.
In the embodiment of the application, if the financial document type belongs to the cost document, a cost accounting table is also required to be automatically generated according to the accounting rules. Wherein the cost accounting table comprises an affiliated period, a store code, a store name-city-brand, an accounting subject, a cost rate-medical cost, a cost rate-beauty cost, a cost rate-sales cost, a cost rate aggregate, a cost-medical class, a cost-beauty class, a cost-sales class, a management fee-inventory loss, a management fee-other-store favor, an audit home-in-stock-end-of-stock balance, a cost class-home-cost (without allocation, with cross-period adjustment), a cost class-home-cost (with the same sales allocation process), a cost class-different sales allocation ex-warehouse, an inventory loss-expiration ex-warehouse, an inventory loss-damage ex-warehouse, an inventory loss-inventory ex-warehouse, a home-in & home lead, a verifier, a check-in time, a status field, and the like.
In an embodiment of the present application, the provided financial credential generation method further includes: pushing the generated financial certificate to a financial system by adopting a preset API (application program interface) of the financial system; upon receiving an audit pass notification of the financial system, a credential summary table of the financial data is generated, the financial summary table including all financial credentials of the financial data.
Specifically, taking a complete embodiment as an example, as shown in fig. 4, a system interaction diagram of a financial document generation method provided in the embodiment of the present application is shown, and the financial integrated system refers to a system for generating a financial document, determines a type of the financial document to be generated, combs the financial data according to the type of the financial document, determines a source system of the financial data, obtains data sources in different ways for the source system, accesses the service system through an API interface when the source system is a service system of the enterprise itself, obtains the data sources of the service system, including but not limited to a consumption record, a purchase record, an allocation record, a cash inventory record, an inter-store settlement record, and the like, downloads source data through a preset RPA financial robot when the source system is a third-party internet transaction system, writes back to an original database through the data, defines a service table through data cleaning, defines an organization map, prepares a accounting basic data, sets up a credential scheme, defines a mapping table based on the credential scheme, configures the credential, determines that the financial cost is enough, and automatically generates financial cost according to the accounting rules of the financial document and assigns the financial cost to the corresponding financial cost item when the financial cost credential; when the financial cost certificate is not available, each financial data item is directly assigned to the corresponding financial data position on the financial certificate; and then automatically generating corresponding financial certificates based on the types of the financial certificates, pushing the corresponding financial certificates to a financial system with an API interface, and automatically generating a certificate summary table after the financial certificates are generated by financial staff.
According to the embodiment of the application, the financial data of different source systems are automatically acquired, the voucher generation template is automatically established, the corresponding relation between each financial data item and the account entry subject is automatically established according to the financial data and the preset financial rules, the corresponding relation between each financial data item and the account entry subject classification number specified by the account entry subject and the account entry subject classification number is automatically established according to the corresponding relation between the account entry subject and the account entry subject classification number, the financial voucher is automatically generated according to the voucher accounting rules, the financial voucher can be quickly and accurately generated, the labor cost is saved, and the error rate of the financial voucher is effectively reduced.
Corresponding to the embodiment of the application function implementation method, the application further provides a financial certificate generation device, electronic equipment and corresponding embodiments.
Fig. 5 is a financial instrument for generating financial instruments, as shown in an embodiment of the present application.
Referring to fig. 5, the financial credential generating device 50 provided in the embodiment of the present application includes a data acquisition module 510, a service table determination module 520, a credential scheme determination module 530, and a credential generation module 540, wherein:
a data acquisition module 510 for acquiring financial data of at least one source system, the financial data comprising data for generating financial credentials;
a service table determining module 520, configured to define, for each of the source systems, a corresponding service table, where the service table is used to store financial data of the source system corresponding to the service table;
a credential scheme determination module 530, configured to determine a credential scheme of the financial data, and define a value rule of a credential row that is to generate a financial credential based on the credential scheme;
the credential generation module 540 is configured to configure a credential template based on the value rule, and generate a financial credential based on the credential template.
As one possible embodiment of the present application, in this embodiment, the data acquisition module 510, when acquiring financial data of at least one source system, is configured to:
when the source system of the financial data is a business system, calling the financial data of the business system by adopting a preset open API interface;
when the source system of the financial data is a third-party internet transaction system, acquiring a data document of the third-party internet transaction system by adopting a preset RPA, and acquiring the financial data based on the data document.
As a possible implementation manner of the present application, in this implementation manner, the service table determining module 520 is configured to, when defining, for each of the source systems, a corresponding service table:
and determining the service type corresponding to the financial data, and constructing a service table for storing at least the financial data and a source system and service types corresponding to the financial data.
As one possible implementation manner of the present application, in this implementation manner, when determining the credential scheme of the financial data, the credential scheme determining module 530 is configured to, when defining the value rule of the credential row of the financial credential to be generated based on the credential scheme:
determining a source system of the financial data and a service type of the financial data, and determining a financial sleeve for generating financial credentials and an initial credential template corresponding to the financial sleeve based on the source system and the service type;
and configuring a value rule of a voucher row for generating the financial voucher based on the service type and the financial type of the financial data.
As one possible implementation of the present application, in this implementation, the credential scheme determination module 530 is configured to, when configuring a credential template based on the value rule, and generating a financial credential based on the credential template:
configuring a voucher header of a financial voucher to be generated based on the initial voucher template;
and generating the certificate row of the financial certificate to be generated in the financial data based on the value rule of the certificate row of the financial certificate to be generated.
As a possible embodiment of the present application, after the acquiring the financial data of the at least one source system, the method further includes:
determining a credential type corresponding to the financial data, and when the credential type is a cost credential, the method further comprises:
the present accounting table is generated based on preset accounting rules.
As a possible embodiment of the present application, in this embodiment, the financial credential generating method further includes:
pushing the generated financial certificate to a financial system by adopting a preset API (application program interface) of the financial system;
upon receiving an audit pass notification of the financial system, a credential summary table of the financial data is generated, the financial summary table including all financial credentials of the financial data.
The specific manner in which the respective modules perform the operations in the apparatus of the above embodiments has been described in detail in the embodiments related to the method, and will not be described in detail herein.
According to the embodiment of the application, the financial data of different source systems are automatically acquired, the voucher generation template is automatically established, the corresponding relation between each financial data item and the account entry subject is automatically established according to the financial data and the preset financial rules, the corresponding relation between each financial data item and the account entry subject classification number specified by the account entry subject and the account entry subject classification number is automatically established according to the corresponding relation between the account entry subject and the account entry subject classification number, the financial voucher is automatically generated according to the voucher accounting rules, the financial voucher can be quickly and accurately generated, the labor cost is saved, and the error rate of the financial voucher is effectively reduced.
Referring now to fig. 6, a schematic diagram of an electronic device 60 suitable for use in implementing embodiments of the present disclosure is shown. The terminal devices in the embodiments of the present disclosure may include, but are not limited to, mobile terminals such as mobile phones, notebook computers, digital broadcast receivers, PDAs (personal digital assistants), PADs (tablet computers), PMPs (portable multimedia players), in-vehicle terminals (e.g., in-vehicle navigation terminals), and the like, and stationary terminals such as digital TVs, desktop computers, and the like. The electronic device shown in fig. 6 is merely an example and should not be construed to limit the functionality and scope of use of the disclosed embodiments.
An electronic device includes: a memory and a processor, where the processor may be referred to as a processing device 601 described below, the memory may include at least one of a Read Only Memory (ROM) 602, a Random Access Memory (RAM) 603, and a storage device 608 described below, as follows:
as shown in fig. 6, the electronic device 600 may include a processing means (e.g., a central processing unit, a graphics processor, etc.) 601, which may perform various appropriate actions and processes according to a program stored in a Read Only Memory (ROM) 602 or a program loaded from a storage means 608 into a Random Access Memory (RAM) 603. In the RAM 603, various programs and data required for the operation of the electronic apparatus 600 are also stored. The processing device 601, the ROM 602, and the RAM 603 are connected to each other through a bus 604. An input/output (I/O) interface 605 is also connected to bus 604.
In general, the following devices may be connected to the I/O interface 605: input devices 606 including, for example, a touch screen, touchpad, keyboard, mouse, camera, microphone, accelerometer, gyroscope, and the like; an output device 607 including, for example, a Liquid Crystal Display (LCD), a speaker, a vibrator, and the like; storage 608 including, for example, magnetic tape, hard disk, etc.; and a communication device 609. The communication means 609 may allow the electronic device 600 to communicate with other devices wirelessly or by wire to exchange data. While fig. 6 shows an electronic device 600 having various means, it is to be understood that not all of the illustrated means are required to be implemented or provided. More or fewer devices may be implemented or provided instead.
In particular, according to embodiments of the present disclosure, the processes described above with reference to flowcharts may be implemented as computer software programs. For example, embodiments of the present disclosure include a computer program product comprising a computer program embodied on a non-transitory computer readable medium, the computer program comprising program code for performing the method shown in the flow chart. In such an embodiment, the computer program may be downloaded and installed from a network via communication means 609, or from storage means 608, or from ROM 602. The above-described functions defined in the methods of the embodiments of the present disclosure are performed when the computer program is executed by the processing device 601.
It should be noted that the computer readable medium described in the present disclosure may be a computer readable signal medium or a computer readable storage medium, or any combination of the two. The computer readable storage medium can be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or a combination of any of the foregoing. More specific examples of the computer-readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer diskette, 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 disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the context of this disclosure, a computer-readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. In the present disclosure, however, the computer-readable signal medium may include a data signal propagated in baseband or as part of a carrier wave, with the computer-readable program code embodied therein. Such a propagated data signal may take any of a variety of forms, including, but not limited to, electro-magnetic, optical, or any suitable combination of the foregoing. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to: electrical wires, fiber optic cables, RF (radio frequency), and the like, or any suitable combination of the foregoing.
The computer readable medium carries one or more programs which, when executed by the electronic device, cause the electronic device to: obtaining financial data of at least one source system, the financial data comprising data for generating financial credentials; defining a corresponding service table for each source system, wherein the service table is used for storing financial data of the source system corresponding to the service table; determining a voucher scheme of the financial data, and defining a value rule of a voucher row of the financial voucher to be generated based on the voucher scheme; and configuring a voucher template based on the value rule, and generating a financial voucher based on the voucher template.
Computer program code for carrying out operations of the present disclosure may be written in one or more programming languages, including, but not limited to, an object oriented programming language such as Java, smalltalk, C ++ and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computer (for example, through the Internet using an Internet service provider).
The flowcharts and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
The modules or units involved in the embodiments of the present disclosure may be implemented by means of software, or may be implemented by means of hardware. Where the name of a module or unit does not in some cases constitute a limitation of the unit itself.
The functions described above herein may be performed, at least in part, by one or more hardware logic components. For example, without limitation, exemplary types of hardware logic components that may be used include: a Field Programmable Gate Array (FPGA), an Application Specific Integrated Circuit (ASIC), an Application Specific Standard Product (ASSP), a system on a chip (SOC), a Complex Programmable Logic Device (CPLD), and the like.
In the context of this disclosure, a machine-readable medium may be a tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. The machine-readable medium may be a machine-readable signal medium or a machine-readable storage medium. The machine-readable medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. More specific examples of a machine-readable storage medium would include an electrical connection based on one or more wires, a portable computer diskette, 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 disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
The foregoing description is only of the preferred embodiments of the present disclosure and description of the principles of the technology being employed. It will be appreciated by persons skilled in the art that the scope of the disclosure referred to in this disclosure is not limited to the specific combinations of features described above, but also covers other embodiments which may be formed by any combination of features described above or equivalents thereof without departing from the spirit of the disclosure. Such as those described above, are mutually substituted with the technical features having similar functions disclosed in the present disclosure (but not limited thereto).
Moreover, although operations are depicted in a particular order, this should not be understood as requiring that such operations be performed in the particular order shown or in sequential order. In certain circumstances, multitasking and parallel processing may be advantageous. Likewise, while several specific implementation details are included in the above discussion, these should not be construed as limiting the scope of the present disclosure. Certain features that are described in the context of separate embodiments can also be implemented in combination in a single embodiment. Conversely, various features that are described in the context of a single embodiment can also be implemented in multiple embodiments separately or in any suitable subcombination.
Although the subject matter has been described in language specific to structural features and/or methodological acts, it is to be understood that the subject matter defined in the appended claims is not necessarily limited to the specific features or acts described above. Rather, the specific features and acts described above are example forms of implementing the claims.
Claims (10)
1. A method of generating financial credentials, comprising:
obtaining financial data of at least one source system, the financial data comprising data for generating financial credentials;
defining a corresponding service table for each source system, wherein the service table is used for storing financial data of the source system corresponding to the service table;
determining a voucher scheme of the financial data, and defining a value rule of a voucher row of the financial voucher to be generated based on the voucher scheme;
and configuring a voucher template based on the value rule, and generating a financial voucher based on the voucher template.
2. A method of generating financial credentials as recited in claim 1, wherein said obtaining financial data of at least one source system comprises:
when the source system of the financial data is a business system, calling the financial data of the business system by adopting a preset open API interface;
when the source system of the financial data is a third-party internet transaction system, acquiring a data document of the third-party internet transaction system by adopting a preset RPA, and acquiring the financial data based on the data document.
3. A method of generating financial credentials as claimed in claim 1, wherein said defining, for each of said source systems, a corresponding service table comprises:
and determining the service type corresponding to the financial data, and constructing a service table for storing at least the financial data and a source system and service types corresponding to the financial data.
4. A financial document generation method according to claim 3 wherein the determining of the document schema of the financial data defines a value rule for a document row of a financial document to be generated based on the document schema, comprising:
determining a source system of the financial data and a service type of the financial data, and determining a financial sleeve for generating financial credentials and an initial credential template corresponding to the financial sleeve based on the source system and the service type;
and configuring a value rule of a voucher row for generating the financial voucher based on the service type and the financial type of the financial data.
5. The financial instrument generation method of claim 4, wherein configuring an instrument template based on the value rule and generating a financial instrument based on the instrument template comprises:
configuring a voucher header of a financial voucher to be generated based on the initial voucher template;
and generating the certificate row of the financial certificate to be generated in the financial data based on the value rule of the certificate row of the financial certificate to be generated.
6. A method of generating financial credentials as recited in claim 5, wherein after said obtaining financial data for at least one source system, further comprises:
determining a credential type corresponding to the financial data, and when the credential type is a cost credential, the method further comprises:
the present accounting table is generated based on preset accounting rules.
7. A financial credential generation method as in claim 6, further comprising:
pushing the generated financial certificate to a financial system by adopting a preset API (application program interface) of the financial system;
upon receiving an audit pass notification of the financial system, a credential summary table of the financial data is generated, the financial summary table including all financial credentials of the financial data.
8. A financial instrument generation apparatus, comprising:
a data acquisition module for acquiring financial data of at least one source system, the financial data comprising data for generating financial credentials;
the business table determining module is used for defining a corresponding business table for each source system, and the business table is used for storing financial data of the source system corresponding to the business table;
the voucher scheme determining module is used for determining a voucher scheme of the financial data, and defining a value rule of a voucher row for generating the financial voucher based on the voucher scheme;
and the voucher generation module is used for configuring a voucher template based on the value rule and generating a financial voucher based on the voucher template.
9. An electronic device, comprising:
a processor; and
a memory having executable code stored thereon, which when executed by the processor, causes the processor to perform the method of any of claims 1-7.
10. A computer readable storage medium having stored thereon executable code which when executed by a processor of an electronic device causes the processor to perform the method of any of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310707593.4A CN117350869A (en) | 2023-06-14 | 2023-06-14 | Financial document generation method, apparatus, electronic device and computer readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310707593.4A CN117350869A (en) | 2023-06-14 | 2023-06-14 | Financial document generation method, apparatus, electronic device and computer readable storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN117350869A true CN117350869A (en) | 2024-01-05 |
Family
ID=89363865
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310707593.4A Pending CN117350869A (en) | 2023-06-14 | 2023-06-14 | Financial document generation method, apparatus, electronic device and computer readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117350869A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117687764A (en) * | 2024-02-04 | 2024-03-12 | 南京九洲会计咨询有限公司 | Financial data intelligent accounting method and system based on SaaS platform |
-
2023
- 2023-06-14 CN CN202310707593.4A patent/CN117350869A/en active Pending
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117687764A (en) * | 2024-02-04 | 2024-03-12 | 南京九洲会计咨询有限公司 | Financial data intelligent accounting method and system based on SaaS platform |
| CN117687764B (en) * | 2024-02-04 | 2024-04-30 | 南京九洲会计咨询有限公司 | Financial data intelligent accounting method and system based on SaaS platform |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20080046347A1 (en) | Systems and Methods for Financial Reimbursement | |
| JP7377832B2 (en) | Program, information processing device and method | |
| CN110490571B (en) | Installment payment method, device, equipment and medium | |
| CN117350869A (en) | Financial document generation method, apparatus, electronic device and computer readable storage medium | |
| CN113887971A (en) | Personal credit investigation method and device based on big data for enterprise and electronic equipment | |
| JP2020129186A (en) | Information processing apparatus, information processing method, and program | |
| CN112258306B (en) | Account information checking method, device, electronic equipment and storage medium | |
| CN112330502A (en) | Contract auditing method and device, electronic equipment and storage medium | |
| CN114239519A (en) | Credit investigation data processing method and device, electronic equipment and computer readable medium | |
| CN110673908A (en) | Interface generation method, device, medium and electronic equipment | |
| JP2023032983A (en) | Program, system, and method | |
| CN112801325A (en) | Enterprise group inspection reservation method, system, electronic device and medium | |
| JP7177587B2 (en) | Information processing device, program, information processing method | |
| CN111429251A (en) | Method and device for processing data under multiple modes | |
| CN110852857A (en) | Fare reimbursement method, device and storage medium | |
| CN114881546B (en) | Method and device for determining resource consumption | |
| CN111985919B (en) | Payment data processing method and device and electronic equipment | |
| CN117649306A (en) | Automatic account checking method, device, electronic equipment and computer readable storage medium | |
| CN111861225B (en) | Task allocation method and device, electronic equipment and storage medium | |
| CN112785406B (en) | Account checking method, device, equipment and storage medium | |
| CN113515332B (en) | Data generation method, device, equipment and storage medium | |
| CN114997977B (en) | Data processing method, device, electronic equipment and computer readable medium | |
| CN113971007B (en) | Information processing method, device, electronic equipment and medium | |
| CN117689388A (en) | Accounting data calculation method and related device for intermodal seats | |
| CN116934482A (en) | Transaction business reconciliation method, device, electronic equipment and readable storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |