CN110458674B - Method and system for generating bookkeeping voucher - Google Patents

Abstract

The invention relates to a method for generating a bookkeeping voucher, which comprises the following steps: s1, defining a mapping table of original certificate subject characteristics and bookkeeping certificate subjects; s2, defining a mapping table of the original accounting voucher subjects and the accounting voucher subjects; s3, establishing a bookkeeping voucher template library; s4, acquiring an original certificate; s5, associating the original certificates needing to be merged and booked into an original certificate group; s6, determining an applicable bookkeeping voucher template; s7, generating the subject, direction and amount of the corresponding bookkeeping voucher; s8, checking the automatically generated bookkeeping voucher; s9, detecting whether an unprocessed original certificate or an original certificate group exists or not, if so, returning to the step S6, and if not, entering the step S10; and S10, judging whether an accounting voucher template meeting the application environment characteristics exists or not, if so, entering the step S7, otherwise, ending the operation. The invention also discloses a system for generating the bookkeeping voucher.

Description

Method and system for generating bookkeeping voucher

Technical Field

The invention belongs to the technical field of computer information, and particularly relates to a method and a system for generating a bookkeeping voucher.

Background

Accounting of the enterprise is the process of generating bookkeeping vouchers from the original vouchers of the enterprise. The original voucher is generated or collected in the business process and is a paper file and an electronic file which prove the business activity of the original voucher, and the bookkeeping voucher is an accounting voucher which is filled after accounting entry is determined by classifying the original voucher which is not checked by an enterprise according to the content of economic business matters. A complete accounting voucher includes information of accounting period number, voucher date, detail subject list, direction of each detail subject, amount of each detail subject, billing person, etc., referring to fig. 1, the core of the accounting voucher is detail subject list, direction of each detail subject, amount of each detail subject.

Because the financial regulation is relatively complicated and trivial, the accounting of enterprise is a work that the specialty is stronger, though accounting computerization software provides the appurtenance that makes things convenient for the accounting staff to type the accounting document for the financial staff to can generate corresponding financial statement according to the accounting document. However, the core information of the accounting document such as the debit and credit accounting title, the auxiliary accounting title, etc. still greatly depends on the manual judgment of the accounting professionals. On the other hand, accounting is a work with strong regularity, and information such as subjects and amounts of accounting vouchers which are subjected to current accounting can be determined or preliminarily determined according to data such as personnel, a payment channel, a payment amount and a payment party, or corresponding bookkeeping vouchers can be automatically generated according to the existing subjects.

In order to improve accounting efficiency, the prior art solution defines a definite accounting rule as a voucher template, where the voucher template includes a debit subject, a credit subject, and a corresponding service type, and the accounting software can determine the voucher template according to the service type in the original voucher, and then generate a corresponding bookkeeping voucher according to the voucher template and the amount of money corresponding to the original voucher.

However, the prior art solutions have several problems: firstly, the accounts of the borrower and the accounts of the lender in the template are predetermined during the definition of the template, for the same service type, the accounts and the account number of the borrower and the lender possibly have great relation with other data of the original voucher, taking employee reimbursement as an example, the employees may submit a plurality of types of expenses such as traffic fee, travelling fee, communication fee, service fee and the like in the same reimbursement document, the expenses of each type need to be collected into the accounting subjects of the employees, and the template based on the static accounts cannot adapt to the variable scenes; secondly, the granularity defined by the voucher template is the first level of the bookkeeping voucher, the bookkeeping voucher consists of debit accounting subjects, credit accounting subjects and the amount of each subject, a large number of repeated definitions of the subject levels are caused based on the definition of the first level of the voucher template, taking service purchase as an example, because cash purchase and bank check purchase correspond to different credit subjects, at the moment, two different templates need to be defined, the workload of template definition and maintenance is increased, and the risk of errors of the bookkeeping voucher is increased.

Disclosure of Invention

The purpose of the invention is as follows: the invention aims to provide a method and a system for generating a bookkeeping voucher, which can realize the generation of the bookkeeping voucher by using a uniform bookkeeping voucher template when the subjects of the bookkeeping voucher generated by an original voucher of the same service are uncertain or the services are similar.

By the original voucher subject characteristics or the original bookkeeping voucher subject and the bookkeeping voucher subject mapping table, different debit and credit subjects can be generated by the same bookkeeping voucher template, and the application range of the template is expanded; and secondly, by introducing the accounting voucher subject mapping table, the granularity of configuration and processing is reduced, a new accounting voucher template can be prevented from being introduced due to the inconsistency of individual parameters, the workload of definition and maintenance of the accounting voucher template is reduced, and the risk of errors of the accounting voucher is avoided.

The technical scheme is as follows: a method of generating a billing voucher, comprising:

s1, defining a mapping table of original certificate subject characteristics and bookkeeping certificate subjects;

s2, defining a mapping table of the original account keeping voucher subjects and the account keeping voucher subjects;

s3, establishing a bookkeeping voucher template library, wherein the bookkeeping voucher template library comprises a series of bookkeeping voucher templates, and the bookkeeping voucher templates comprise globally unique names, template application conditions, detailed items contained in the templates and borrowing directions of the items in the templates, and the bookkeeping voucher templates comprise:

the detail items contained in the template are preset accounting subjects or items in the mapping table defined in the step S1/S2;

the template application condition refers to a condition which needs to be met when the accounting voucher is generated by using the template, and the template application condition comprises the service characteristic and the application environment characteristic of the original voucher, wherein:

the service characteristics of the original certificate refer to metadata for describing a service corresponding to the original certificate;

the application environment characteristics refer to conditions met by an external environment when the template runs;

s4, acquiring an original certificate generated by an enterprise in a business process, wherein:

the original voucher comprises a voucher file and metadata corresponding to the voucher file;

s5, checking all the obtained original vouchers in the step S4, associating the original vouchers needing to be merged and booked into an original voucher group, and then entering a step S6;

s6, aiming at each original voucher or original voucher group one by one, determining an applicable bookkeeping voucher template defined in the step S3 according to the service characteristics of the original voucher or the original voucher group, and entering a step S7 after all the bookkeeping voucher templates are finished, wherein:

if the original voucher or the original voucher group is suitable for a plurality of bookkeeping voucher templates, manually selecting the used voucher template;

s7, generating the subject, direction and amount of the corresponding bookkeeping voucher aiming at each detail item contained in the bookkeeping voucher template according to the determined bookkeeping voucher template;

s8, checking the automatically generated accounting voucher, and entering a step S9 after the completion, wherein:

when the bookkeeping voucher has errors or is incomplete, returning error information and submitting manual processing of the bookkeeping accounting;

s9, detecting whether an unprocessed original certificate or an original certificate group exists or not, if so, returning to the step S6, and if not, entering the step S10;

and S10, detecting the current application environment, judging whether an accounting voucher template meeting the application environment characteristics exists, if so, entering the step S7, and if not, ending the operation.

Further, the service characteristics of the original certificate in step S3 include a document type of the original certificate and a corresponding service type.

Further, the application environment characteristics in step S3 include monthly balance in accounting billing and existing original voucher processing completion of the enterprise.

Further, step S7 includes the steps of:

s71, judging the types of the detail items one by one, if the detail items are definite accounting subjects, entering step S72, if the detail items are mapping table items defined in step S1, entering step S73, if the detail items are mapping table items defined in step S2, entering step S74, and after all the types of the detail items are processed, entering step S75;

s72, filling the debit and credit direction of the detail item and the amount of money corresponding to the detail item in the original voucher into the detail item in the accounting voucher to form an item detail of the accounting voucher;

s73, generating a corresponding accounting subject according to the mapping table defined in the step S1, and filling the debit and credit direction of the item and the amount corresponding to the subject in the original voucher into the subject item to form a subject detail in the bookkeeping voucher;

s74, judging whether a source subject corresponding to a mapping table entry in an existing bookkeeping voucher of the enterprise has a balance, if so, generating a corresponding target accounting subject, filling a debit and credit direction of the entry into a subject entry, judging whether a mapping from the source subject to the target subject contains a money amount calculation formula, if so, calling the formula to generate the money amount of the target subject to form a subject detail in the bookkeeping voucher, and if not, generating a subject without the money amount; if no balance exists, go to step S71;

s75, merging the subject details generated in the steps S72 to S74 to generate a subject detail list of the accounting voucher, and then entering the step S76;

s76 supplements the metadata of the billing voucher to generate a billing voucher, and then proceeds to step S8.

A system for generating billing credentials, comprising:

the first mapping table definition module defines a mapping table of the original certificate subject characteristics and the bookkeeping certificate subject;

a second mapping table definition module for defining the original accounting voucher subject and the mapping table of the accounting voucher subject

The module is established to the account keeping voucher template base, and account keeping voucher template base includes a series of account keeping voucher templates, the account keeping voucher template includes globally unique name, template application condition, detail entry contained in the template and borrowing direction of each entry in the template, wherein:

the detail items contained in the template are items in a preset accounting subject or a mapping table defined in a first/second mapping table definition module;

the template application condition refers to a condition which needs to be met when the accounting voucher is generated by using the template, and the template application condition comprises the service characteristic and the application environment characteristic of the original voucher, wherein:

the service characteristics of the original certificate refer to metadata used for describing the service corresponding to the original certificate;

the application environment characteristics refer to conditions met by an external environment when the template runs;

the original certificate acquisition module acquires an original certificate generated by an enterprise in a business process, wherein: the original voucher comprises a voucher file and metadata corresponding to the voucher file;

the merging module is used for checking all the obtained original vouchers, associating the original vouchers needing to be merged and booked into an original voucher group, and then entering the booked voucher template selection module;

the bookkeeping voucher template selecting module is used for determining an applicable bookkeeping voucher template according to the service characteristics of the original voucher or the original voucher group one by one aiming at each original voucher or the original voucher group, and the bookkeeping voucher selecting module enters the bookkeeping voucher generating module after all the bookkeeping voucher templates are finished, wherein:

if the original voucher or the original voucher group is suitable for a plurality of bookkeeping voucher templates, manually selecting the used voucher template;

the bookkeeping voucher generating module is used for generating the subject, direction and amount of the corresponding bookkeeping voucher aiming at each detail item contained in the bookkeeping voucher template according to the determined bookkeeping voucher template;

the module of checking checks the automatically generated book keeping voucher, gets into the detection module after accomplishing, wherein:

when the bookkeeping voucher has errors or is incomplete, returning error information and asking for manual handling of bookkeeping accounting;

the first detection module is used for detecting whether an unprocessed original certificate or an original certificate group exists or not, if the unprocessed original certificate or the original certificate group exists, the unprocessed original certificate or the original certificate group returns to the bookkeeping certificate template selection module, and if the unprocessed original certificate or the original certificate group does not exist, the second detection module is started;

and the second detection module is used for detecting the current application environment, judging whether an accounting voucher template meeting the application environment characteristics exists or not, if so, calling the accounting voucher generation module to generate an accounting voucher, and if not, finishing the operation.

Furthermore, the service characteristics of the original voucher in the accounting voucher template library establishing module comprise the voucher type of the original voucher and the corresponding service type.

Further, the application environment characteristics in the accounting voucher template base building module comprise monthly forward in accounting and completion of the existing original voucher processing of the enterprise.

Further, the accounting voucher generating module comprises the following modules:

the judging module judges the types of the detail items one by one, if the detail items are definite accounting items, the first item detail generating module is entered, if the detail items are mapping table items defined in the first mapping table defining module, the second item detail generating module is entered, if the detail items are mapping table items defined in the first mapping table defining module, the third item detail generating module is entered, and after all the types of the detail items are processed, the third item detail generating module is entered;

the first subject detail generation module is used for filling the debit and credit direction of the detail item and the amount of money corresponding to the detail item in the original voucher into the detail subject item in the accounting voucher to form a subject detail of the accounting voucher;

the second subject detail generation module generates a corresponding accounting subject according to the mapping table defined by the first mapping table definition module, and fills the debit and credit direction of the item and the amount of money corresponding to the subject in the original voucher into the subject item to form a subject detail in the bookkeeping voucher;

a third subject detail generating module, configured to determine whether a source subject corresponding to a mapping table entry in an existing bookkeeping voucher of an enterprise has a balance, if so, generate a corresponding target accounting subject, fill a lending direction of the entry into the subject entry, determine whether a mapping from the source subject to the target subject contains a money amount calculation formula, if so, call the formula to generate a money amount of the target subject, form a subject detail in the bookkeeping voucher, and if not, generate a subject detail without the money amount; if no balance exists, entering a step judgment module;

the merging module is used for merging the generated subject details generated by the first/second/third subject detail generating module to generate a billing voucher subject detail list, and then entering the supplementing module;

and the supplement module supplements the metadata of the bookkeeping voucher to generate the bookkeeping voucher.

Has the beneficial effects that: the method and the system for generating the bookkeeping voucher have the following beneficial effects:

1. in the template definition process, an accounting subject mapping table (comprising a mapping table of original voucher subject characteristics and bookkeeping voucher subjects, a mapping table of original bookkeeping voucher subjects and bookkeeping voucher subjects) and a mixed use of accounting subjects are supported, and the dynamic change and the local adjustment of accounting subjects generated by the same template can be supported;

2. the implementation of the invention can realize the automatic generation of the accounting voucher from the original voucher, and can also generate a new accounting voucher according to the existing accounting voucher, thereby simplifying the accounting process of accounting and improving the quality and efficiency of accounting of enterprises.

Drawings

FIG. 1 is an exemplary diagram of a billing voucher;

FIG. 2 is a flow chart of a method for generating billing vouchers in accordance with the present disclosure.

The specific implementation mode is as follows:

the following describes in detail specific embodiments of the present invention.

A method of generating a billing voucher, comprising:

s1, defining a mapping table of original voucher subject characteristics and bookkeeping voucher subjects

The mapping table of the original voucher subject characteristics and the bookkeeping voucher subject refers to the corresponding relation between the original voucher subject characteristics and the bookkeeping voucher subject, and the mapping table represents that if the original voucher has the subject characteristics meeting the predefinition in the mapping table, corresponding accounting subjects are generated in the bookkeeping voucher; the original voucher subject characteristics refer to metadata which has a direct relation with the selection of the bookkeeping subject in the original voucher, and comprise the cost type when the employee reimburses and the department to which the employee belongs when the employee reimburses;

for example, the mapping table of the payment and accounting purposes is as follows:

receiving and paying mode	Subject of accounting
		Cash money	Cash stock
Remittance of money by bank	Bank deposit
		Payment device	Other monetary funds-Paibao
WeChat	Other monetary funds-Wechat

Table 1: receipt and payment mode-accounting subject mapping table

S2, defining a mapping table of the original account keeping voucher subjects and the account keeping voucher subjects

The mapping table of the original bookkeeping voucher subjects and the bookkeeping voucher subjects refers to the corresponding relation between the original bookkeeping voucher subjects and the bookkeeping voucher subjects when new bookkeeping vouchers are generated through the original bookkeeping voucher (depreciation, amortization, bad account preparation and the like), if the items of the target subjects can be calculated through the subject amounts in the original bookkeeping voucher, the mapping table simultaneously comprises corresponding calculation formulas, the original bookkeeping voucher subjects are called source subjects, and the bookkeeping voucher subjects are called target subjects; the method comprises the steps that shown in an existing accounting voucher of an enterprise, if a source subject has balance, subject details of a target subject are generated in the accounting voucher;

for example, a mapping table of source subjects and target subjects for fixed assets, intangible assets is as follows

Subject of origin	Target subject	Formula for calculation
			Fixed assets	Manufacturing expense-depreciation expense and amortization	Total monthly depreciation of all fixed assets

Table 2: fixed asset-depreciation subject mapping table

For subjects with complicated calculation of the amount of money such as 'reduction preparation' and the like and which cannot be calculated through a simple formula, the invention only defines the mapping of a source subject and a target subject when defining the subject mapping, does not define the amount calculation formula, and the amount is manually supplemented by bookkeeping personnel.

Subject of source	Target subject
		Fixed assets	Fixed asset derating preparation
Intangible assets	Intangible asset derating preparation
		Receivables	Bad account preparation-account receivable bad account preparation

Table 3: subtract value to prepare subject mapping table

S3, establishing a bookkeeping voucher template library, wherein the bookkeeping voucher template library comprises a series of bookkeeping voucher templates, and the bookkeeping voucher templates comprise globally unique names, template application conditions, detailed items contained in the templates and borrowing directions of the items in the templates, and the bookkeeping voucher templates comprise:

the detail items contained in the template are preset accounting subjects or items in the mapping table defined in the step S1/S2;

the template application condition refers to a condition which needs to be met when the accounting voucher is generated by using the template, and the template application condition comprises the service characteristic and the application environment characteristic of the original voucher, wherein:

the service characteristics of the original certificate refer to metadata used for describing the service corresponding to the original certificate;

an example of a template applied according to the original voucher service characteristics is as follows:

table 4: accounting voucher template-receiving customer money

The application environment characteristics refer to conditions met by an external environment when the template runs; examples of templates applied according to application environment characteristics are as follows:

table 5: accounting voucher template-fixed asset depreciation

Table 6: accounting voucher template-asset derating preparation

S4, acquiring an original certificate generated by an enterprise in a business process, wherein:

the original voucher comprises a voucher file and metadata corresponding to the voucher file;

s5, all the obtained original certificates in the step S4 are checked, the original certificates needing to be merged and booked are associated into an original certificate group, and then the step S6 is carried out;

s6, aiming at each original voucher or original voucher group one by one, determining an applicable bookkeeping voucher template defined in the step S3 according to the service characteristics of the original voucher or the original voucher group, and entering a step S7 after all the bookkeeping voucher templates are finished, wherein:

if the original voucher or the original voucher group is suitable for a plurality of bookkeeping voucher templates, manually selecting the used voucher template;

s7, generating the subject, direction and amount of the corresponding bookkeeping voucher aiming at each detail item contained in the bookkeeping voucher template according to the determined bookkeeping voucher template;

according to tables 1 and 4, when the original voucher with the deposit increased by 1000 yuan is received, the automatically generated accounting voucher of the invention is as follows:

abstract	Subject of the scientific discipline	Amount of money	Direction
				Receive the customer money	Bank deposit	1000	Borrowing money
	Receivables	1000	Credit

Table 7: bank deposit accounting voucher

It can be found that, aiming at different collection modes, the invention can use one bookkeeping voucher template to generate bookkeeping vouchers with different subjects, thereby reducing the number of templates and simplifying the maintenance work of the templates;

according to tables 2 and 5, at the time of monthly balance in accounting, accounting documents are generated in which the amount is determined by calculation based on the monthly depreciation amount of all the fixed assets of each company

Abstract	Subject of the scientific discipline	Amount of money	Direction
				Depreciation of fixed assets	Manufacturing expense-depreciation expense and amortization	XXX	Borrowing money
	Cumulative depreciation	XXX	Loan

Table 8: fixed asset depreciation accounting voucher

According to tables 3 and 6, at the monthly balance of accounting, if the fixed assets, accounts receivable items of the enterprise contain a balance, the accounting documents generated are as follows, where the amount is manually replenished by the accounting staff

Abstract	Subject of the scientific discipline	Amount of money	Direction
				Prepare for the count up and down value	Fixed asset derating preparation		Loan
	Bad account preparation-account receivable bad account preparation		Credit
					Managing expense-asset loss		Borrowing money

Table 9: credited preparation billing voucher

The invention can generate a new bookkeeping voucher according to the existing assets and bookkeeping voucher of the enterprise, can rapidly generate the new bookkeeping voucher, greatly simplifies the work of bookkeeping personnel and improves the efficiency of bookkeeping work.

S8, checking the automatically generated accounting voucher, and entering a step S9 after the completion, wherein:

when the bookkeeping voucher has errors or is incomplete, returning error information and submitting manual processing of the bookkeeping accounting;

if all the subjects in the generated bookkeeping voucher contain the money amount, checking the sum of the borrower and the lender according to a double bookkeeping rule, and if the sum of the borrower and the lender is equal, finishing the bookkeeping voucher; if the total sum of the borrower and the lender is not equal, returning accounting error information and submitting an accounting worker for manual processing;

if the generated bookkeeping voucher contains the subject detail which does not contain the amount, incomplete bookkeeping information is returned, and manual processing is requested by bookkeeping personnel; such as: the billing voucher of table 9;

s9, detecting whether an unprocessed original certificate or an original certificate group exists, if so, returning to the step S6, and if not, entering the step S10;

s10, detecting the current application environment, judging whether an accounting voucher template meeting the application environment characteristics exists, if so, entering the step S7, and if not, ending the operation.

Further, the service characteristics of the original certificate in step S3 include a document type of the original certificate and a corresponding service type.

Further, the application environment characteristics in step S3 include monthly balance in accounting billing and existing original voucher processing completion of the enterprise.

Further, in step S4, the original certificate includes an electronic bank statement, an invoice, an entry and exit statement, a reimbursement statement, an expense statement, an enterprise payroll table, a social security payment table, and a public deposit payment table.

Further, the metadata in step S4 includes a summary, a ticket type, an amount, and a service type.

Further, step S7 includes the steps of:

s71, judging the types of the detail items one by one, entering a step S72 if the detail items are definite accounting subjects, entering a step S73 if the detail items are mapping table items defined in the step S1, entering a step S74 if the detail items are mapping table items defined in the step S2, and entering a step S75 after all the types of the detail items are processed;

s72, filling the debit and credit direction of the detail item and the amount of money corresponding to the detail account in the original voucher into the detail account item in the accounting voucher to form an account detail of the accounting voucher;

s73, generating a corresponding accounting subject according to the mapping table defined in the step S1, and filling the debit and credit direction of the item and the amount corresponding to the subject in the original voucher into the subject item to form a subject detail in the bookkeeping voucher;

s74, judging whether a source subject corresponding to a mapping table entry in an existing bookkeeping voucher of the enterprise has a balance, if so, generating a corresponding target accounting subject, filling the debit and credit direction of the entry into the subject entry, judging whether the mapping from the source subject to the target subject contains a money amount calculation formula, if so, calling the formula to generate the money amount of the target subject to form a subject detail in the bookkeeping voucher, and if not, generating the subject without the money amount; if no balance exists, go to step S71;

s75, merging the subject details generated in the steps S72 to S74 to generate a billing voucher subject detail list, and then entering the step S76;

s76 supplements the metadata of the billing voucher to generate a billing voucher, and then proceeds to step S8.

Further, the raw data in step S76 includes the voucher number, voucher period number, and voucher number.

A system for generating billing credentials, comprising:

the first mapping table definition module is used for defining a mapping table of original certificate subjects characteristics and bookkeeping certificate subjects;

a second mapping table definition module for defining the original accounting voucher subject and the mapping table of the accounting voucher subject

The module is established to the account keeping voucher template base, and account keeping voucher template base includes a series of account keeping voucher templates, the account keeping voucher template includes globally unique name, template application condition, detail entry contained in the template and borrowing direction of each entry in the template, wherein:

the detail items contained in the template are items in a preset accounting subject or a mapping table defined in a first/second mapping table definition module;

the template application condition refers to a condition which needs to be met when the accounting voucher is generated by using the template, and the template application condition comprises the service characteristic and the application environment characteristic of the original voucher, wherein:

the service characteristics of the original certificate refer to metadata used for describing the service corresponding to the original certificate;

the application environment characteristics refer to conditions met by an external environment when the template runs;

the original certificate acquisition module acquires an original certificate generated by an enterprise in a business process, wherein: the original voucher comprises a voucher file and metadata corresponding to the voucher file;

the merging module is used for checking all the obtained original vouchers, associating the original vouchers needing to be merged and booked into an original voucher group, and then entering the booked voucher template selection module;

the bookkeeping voucher template selecting module is used for determining an applicable bookkeeping voucher template according to the service characteristics of the original voucher or the original voucher group one by one aiming at each original voucher or the original voucher group, and the bookkeeping voucher selecting module enters the bookkeeping voucher generating module after all the bookkeeping voucher templates are finished, wherein:

if the original voucher or the original voucher group is suitable for a plurality of bookkeeping voucher templates, manually selecting the used voucher template;

the bookkeeping voucher generating module is used for generating the subject, direction and amount of the corresponding bookkeeping voucher aiming at each detail item contained in the bookkeeping voucher template according to the determined bookkeeping voucher template;

the checking module is used for checking the automatically generated bookkeeping voucher and entering the detection module after the completion, wherein:

when the bookkeeping voucher has errors or is incomplete, returning error information and submitting manual processing of the bookkeeping accounting;

when all subjects in the generated bookkeeping voucher contain money, checking the sum of the borrower and the lender according to a double bookkeeping rule, and if the sum of the borrower and the lender is equal, finishing the bookkeeping voucher; if the total sum of the borrower and the lender is not equal, returning accounting error information and submitting an accounting worker for manual processing;

when the generated bookkeeping voucher contains the subject detail which does not contain the amount, incomplete bookkeeping information is returned, and manual processing is requested by bookkeeping personnel;

the first detection module is used for detecting whether an unprocessed original certificate or an original certificate group exists or not, if the unprocessed original certificate or the original certificate group exists, the unprocessed original certificate or the original certificate group returns to the bookkeeping certificate template selection module, and if the unprocessed original certificate or the original certificate group does not exist, the second detection module is started;

and the second detection module is used for detecting the current application environment, judging whether an accounting voucher template meeting the application environment characteristics exists or not, outputting the accounting voucher checked by the checking module if the accounting voucher template meets the application environment characteristics, finishing the operation, and directly finishing the operation if the accounting voucher template does not meet the application environment characteristics.

Furthermore, the service characteristics of the original voucher in the accounting voucher template base establishing module comprise the document type of the original voucher and the corresponding service type.

Further, the application environment characteristics in the accounting voucher template base building module comprise monthly forward in accounting and completion of the existing original voucher processing of the enterprise.

Further, the original voucher in the original voucher acquisition module comprises an electronic bank statement, an invoice, an entrance and exit inventory, a reimbursement bill, an expense bill, an enterprise payroll, a social security payment table and a public deposit payment table.

Further, the metadata in the original certificate acquisition module includes an abstract, a bill type, an amount, and a service type.

Further, the accounting voucher generating module comprises the following modules:

the judging module judges the types of the detail items one by one, if the detail items are definite accounting items, the first item detail generating module is entered, if the detail items are mapping table items defined in the first mapping table defining module, the second item detail generating module is entered, if the detail items are mapping table items defined in the first mapping table defining module, the third item detail generating module is entered, and after all the types of the detail items are processed, the third item detail generating module is entered;

the first subject detail generation module is used for filling the debit and credit direction of the detail item and the amount of money corresponding to the detail item in the original voucher into the detail subject item in the accounting voucher to form a subject detail of the accounting voucher;

the second subject detail generation module generates a corresponding accounting subject according to the mapping table defined by the first mapping table definition module, and fills the debit and credit direction of the item and the amount of money corresponding to the subject in the original voucher into the subject item to form a subject detail in the bookkeeping voucher;

a third subject detail generating module, configured to determine whether a source subject corresponding to a mapping table entry in an existing bookkeeping voucher of the enterprise has a balance, if so, generate a corresponding target accounting subject, fill a loan direction of the entry into the subject entry, determine whether a mapping from the source subject to the target subject contains a money amount calculation formula, if so, invoke the formula to generate a money amount of the target subject, form a subject detail in the bookkeeping voucher, and if not, generate a subject detail without the money amount; if no balance exists, entering a step judgment module;

the merging module is used for merging the generated subject details generated by the first/second/third subject detail generating module to generate a billing voucher subject detail list, and then entering the supplementing module;

and the supplement module supplements the metadata of the accounting voucher and automatically generates the accounting voucher.

Furthermore, the original data in the supplementary module includes the voucher number, voucher period number and voucher number.

The embodiments of the present invention have been described in detail. However, the present invention is not limited to the above-described embodiments, and various changes can be made within the knowledge of those skilled in the art without departing from the gist of the present invention.

Claims (8)

1. A method of generating a billing voucher, comprising:

s1, defining a mapping table of original voucher subject characteristics and bookkeeping voucher subjects;

s2, defining a mapping table of the original accounting voucher subjects and the accounting voucher subjects;

s3, establishing a bookkeeping voucher template library, wherein the bookkeeping voucher template library comprises a series of bookkeeping voucher templates, and the bookkeeping voucher templates comprise globally unique names, template application conditions, detailed items contained in the templates and borrowing directions of the items in the templates, and the bookkeeping voucher templates comprise:

the detail items contained in the template are preset accounting subjects or items in the mapping table defined in the step S1/S2;

the template application condition refers to a condition which needs to be met when the accounting voucher is generated by using the template, and the template application condition comprises the service characteristic and the application environment characteristic of the original voucher, wherein:

the service characteristics of the original certificate refer to metadata used for describing the service corresponding to the original certificate;

the application environment characteristics refer to conditions met by an external environment when the template runs;

s4, acquiring an original certificate generated by an enterprise in a business process, wherein:

the original voucher comprises a voucher file and metadata corresponding to the voucher file;

s5, checking all the obtained original vouchers in the step S4, associating the original vouchers needing to be merged and booked into an original voucher group, and then entering a step S6;

s6, aiming at each original voucher or original voucher group one by one, determining an applicable bookkeeping voucher template defined in the step S3 according to the service characteristics of the original voucher or the original voucher group, and entering a step S7 after all the bookkeeping voucher templates are finished, wherein:

if the original voucher or the original voucher group is suitable for a plurality of bookkeeping voucher templates, manually selecting the used voucher template;

s7, generating subjects, directions and amounts of corresponding bookkeeping vouchers aiming at each detail entry contained in the bookkeeping voucher templates according to the determined bookkeeping voucher templates;

s8, checking the automatically generated accounting voucher, and entering a step S9 after the completion, wherein:

when the bookkeeping voucher has errors or is incomplete, returning error information and asking for manual handling of bookkeeping accounting;

s9, detecting whether an unprocessed original certificate or an original certificate group exists or not, if so, returning to the step S6, and if not, entering the step S10;

and S10, detecting the current application environment, judging whether an accounting voucher template meeting the application environment characteristics exists, if so, entering the step S7, and if not, ending the operation.

2. The method for generating accounting voucher according to claim 1, wherein the service characteristics of the original voucher in step S3 comprises the document type of the original voucher and the corresponding service type.

3. The method of claim 1, wherein the application environment characteristics in step S3 include monthly forward during accounting and completion of existing original voucher processing of the enterprise.

4. The method of generating a billing voucher according to claim 1, wherein the step S7 comprises the steps of:

s71, judging the types of the detail items one by one, entering a step S72 if the detail items are definite accounting subjects, entering a step S73 if the detail items are mapping table items defined in the step S1, entering a step S74 if the detail items are mapping table items defined in the step S2, and entering a step S75 after all the types of the detail items are processed;

s72, filling the debit and credit direction of the detail item and the amount of money corresponding to the detail item in the original voucher into the detail item in the accounting voucher to form an item detail of the accounting voucher;

s73, generating a corresponding accounting subject according to the mapping table defined in the step S1, and filling the debit and credit direction of the item and the amount corresponding to the subject in the original voucher into the subject item to form a subject detail in the bookkeeping voucher;

s74, judging whether a source subject corresponding to a mapping table entry in an existing bookkeeping voucher of the enterprise has a balance, if so, generating a corresponding target accounting subject, filling the debit and credit direction of the entry into the subject entry, then judging whether the mapping from the source subject to the target subject contains a money amount calculation formula, if so, calling the formula to generate the money amount of the target subject to form a subject detail in the bookkeeping voucher, and if not, generating the subject without the money amount; if no balance exists, go to step S71;

s75, merging the subject details generated in the steps S72 to S74 to generate a billing voucher subject detail list, and then entering the step S76;

s76 supplements the metadata of the billing voucher to generate a billing voucher, and then proceeds to step S8.

5. A system for generating a billing voucher, comprising:

the first mapping table definition module defines a mapping table of the original certificate subject characteristics and the bookkeeping certificate subject;

a second mapping table definition module for defining the original accounting voucher subject and the mapping table of the accounting voucher subject

The module is established to the account keeping voucher template base, and account keeping voucher template base includes a series of account keeping voucher templates, the account keeping voucher template includes globally unique name, template application condition, detail entry contained in the template and borrowing direction of each entry in the template, wherein:

the detail items contained in the template are items in a preset accounting subject or a mapping table defined in a first/second mapping table definition module;

the template application condition refers to a condition which needs to be met when the accounting voucher is generated by using the template, and the template application condition comprises the service characteristic and the application environment characteristic of the original voucher, wherein:

the service characteristics of the original certificate refer to metadata used for describing the service corresponding to the original certificate;

the application environment characteristics refer to conditions met by an external environment when the template runs;

the system comprises an original certificate acquisition module, an original certificate acquisition module and a certificate management module, wherein the original certificate acquisition module is used for acquiring an original certificate generated by an enterprise in a business process, and the original certificate acquisition module comprises:

the original voucher comprises a voucher file and metadata corresponding to the voucher file;

the merging module is used for checking all the obtained original vouchers, associating the original vouchers needing to be merged and booked into an original voucher group, and then entering the booked voucher template selection module;

the bookkeeping voucher template selecting module is used for determining an applicable bookkeeping voucher template according to the service characteristics of the original voucher or the original voucher group one by one aiming at each original voucher or the original voucher group, and the bookkeeping voucher selecting module enters the bookkeeping voucher generating module after all the bookkeeping voucher templates are finished, wherein:

if the original voucher or the original voucher group is suitable for a plurality of bookkeeping voucher templates, manually selecting the used voucher template;

the bookkeeping voucher generation module is used for generating the subject, direction and amount of the corresponding bookkeeping voucher aiming at each detail item contained in the bookkeeping voucher template according to the determined bookkeeping voucher template;

the checking module is used for checking the automatically generated bookkeeping voucher and entering the detection module after the completion, wherein:

when the bookkeeping voucher has errors or is incomplete, returning error information and asking for manual handling of bookkeeping accounting;

the first detection module is used for detecting whether an unprocessed original certificate or an original certificate group exists or not, if the unprocessed original certificate or the original certificate group exists, the unprocessed original certificate or the original certificate group returns to the bookkeeping certificate template selection module, and if the unprocessed original certificate or the original certificate group does not exist, the second detection module is started;

and the second detection module is used for detecting the current application environment, judging whether an accounting voucher template meeting the application environment characteristics exists or not, if so, calling the accounting voucher generation module to generate an accounting voucher, and if not, ending the operation.

6. The system for generating accounting vouchers of claim 5, wherein the service features of the original voucher in the accounting voucher template library establishment module comprise a voucher type of the original voucher and a corresponding service type.

7. The system for generating bookkeeping voucher as claimed in claim 5, wherein the application environment features in the module for establishing the template base of bookkeeping voucher comprise monthly forward in accounting, and the existing processing of original voucher of enterprise is completed.

8. The system for generating billing vouchers of claim 5, wherein the billing voucher generation module comprises the following modules:

the judging module judges the types of the detail items one by one, if the detail items are definite accounting items, the first item detail generating module is entered, if the detail items are mapping table items defined in the first mapping table defining module, the second item detail generating module is entered, if the detail items are mapping table items defined in the second mapping table defining module, the third item detail generating module is entered, and after all the types of the detail items are processed, the third item detail generating module is entered;

the first subject detail generating module is used for filling the debit and credit direction of the detail item and the amount corresponding to the detail item in the original voucher into the detail item in the bookkeeping voucher to form a subject detail of the bookkeeping voucher;

the second subject detail generation module generates a corresponding accounting subject according to the mapping table defined by the first mapping table definition module, and fills the debit and credit direction of the item and the amount of money corresponding to the subject in the original voucher into the subject item to form a subject detail in the bookkeeping voucher;

a third subject detail generating module, configured to determine whether a source subject corresponding to a mapping table entry in an existing bookkeeping voucher of an enterprise has a balance, if so, generate a corresponding target accounting subject, fill a loan direction of the entry into the subject entry, then determine whether a mapping from the source subject to the target subject contains a money amount calculation formula, if so, invoke the formula to generate a money amount of the target subject, so as to form a subject detail in the bookkeeping voucher, and if not, generate a subject detail that does not contain the money amount; if no balance exists, entering a step judgment module;

the merging module is used for merging the generated subject details generated by the first/second/third subject detail generating module to generate a bookkeeping voucher subject detail list, and then entering the supplementing module;

and the supplement module supplements the metadata of the bookkeeping voucher to generate the bookkeeping voucher.

Images