CN110796531A - Web-based accounting voucher generation method and system - Google Patents
Web-based accounting voucher generation method and system Download PDFInfo
- Publication number
- CN110796531A CN110796531A CN201911036705.8A CN201911036705A CN110796531A CN 110796531 A CN110796531 A CN 110796531A CN 201911036705 A CN201911036705 A CN 201911036705A CN 110796531 A CN110796531 A CN 110796531A
- Authority
- CN
- China
- Prior art keywords
- entry
- information
- accounting
- voucher
- web
- 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
Images
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
Landscapes
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Engineering & Computer Science (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The invention discloses a method and a system for generating a bookkeeping voucher based on a web, belongs to the field of bookkeeping voucher generation, and aims to solve the technical problem of how to generate a general bookkeeping voucher generation mode based on the web. The method comprises the following steps: checking the input accounting original data, including checking whether the information field in the accounting original data is correct or not; if the verification is successful, carrying out data processing on the accounting original data to obtain basic information of the accounting voucher, and storing the basic information of the accounting voucher into a basic information table; generating entry information of each entry according to the configuration information in the entry configuration table, and storing the entry information into an entry detail table; and calling a financial system interface, and importing the accounting voucher information into a financial system. The system comprises a database, a checking module, a data processing module, an entry module and a lead-out module.
Description
Technical Field
The invention relates to the field of accounting voucher generation, in particular to a method and a system for generating an accounting voucher based on a web.
Background
The Web is an information service provided by the Internet, and has a main function of providing people to issue, process, browse and the like information on the Internet, and the Web is a set of technical specifications and comprises a plurality of technologies and protocols (such as an HTML technology, a URL, an HTTP protocol and the like).
Through the technical specification, resources on a host (Web server) of the Internet network can be described, published and processed, and further, other machines on the Internet can browse the Web resources (usually Web pages) through client software.
The technical problem to be solved when generating a universal accounting voucher generation mode based on the web is that the vouchers to be produced are different due to different accounting data.
Disclosure of Invention
The technical task of the invention is to provide a method and a system for generating a bookkeeping voucher based on a web to solve the problem of how to generate a general bookkeeping voucher generation mode based on the web.
In a first aspect, the present invention provides a web-based billing voucher generation method, comprising the steps of:
checking the input accounting original data, including checking whether the information field in the accounting original data is correct or not;
if the verification is successful, carrying out data processing on the accounting original data to obtain basic information of the accounting voucher, and storing the basic information of the accounting voucher into a basic information table;
generating entry information of each entry according to the configuration information in the entry configuration table, and storing the entry information into an entry detail table;
and calling a financial system interface, and importing the accounting voucher information into a financial system.
Preferably, the billing raw data includes amount, transaction type, currency, and exchange rate;
checking the input accounting original data, comprising:
checking whether the amount format is correct;
checking whether the field of the transaction type is correct;
checking whether the field of the currency is correct;
the field of exchange rate is checked for correctness.
Preferably, the basic information of the accounting voucher includes serial number, accounting date, transaction type, exchange rate, debit amount, credit amount, bank account number, account maker, auditor and generation time.
Preferably, the configuration information in the entry configuration table includes a credential code, an entry serial number, and a subject number.
Preferably, the entry information includes serial number, voucher code, entry number, digest, subject number, debit tag, debit amount, and credit amount.
Preferably, the basic information table and the entry detail table are both stored in the database, and the database further stores a certificate table and a subject table, the certificate table stores a certificate code and a certificate name, and the subject table stores a subject number and a subject name.
In a second aspect, the present invention provides a web-based billing voucher generation system comprising:
the system comprises a database, a data base and a data processing system, wherein the database is provided with a basic information table, an entry detail table, a certificate table and a subject table, the basic information table is used for storing basic information of an accounting certificate, the entry detail table is used for storing entry information, the certificate table is used for storing a certificate code and a certificate name, and the subject table is used for storing a subject number and a subject name;
the checking module is used for checking the input accounting original data, and checking whether the information field in the accounting original data is correct or not;
the data processing module is used for carrying out data processing on the accounting original data after the verification is successful to obtain the basic information of the accounting voucher and storing the basic information of the accounting voucher to a basic information table;
the entry module is used for generating entry information of each entry according to the configuration information in the entry configuration table and storing the entry information into the entry detail table;
and the export module is used for calling the financial system interface and importing the accounting voucher information into the financial system.
Preferably, the billing raw data includes amount, transaction type, currency, and exchange rate;
the verification module verifies the input accounting original data and comprises the following steps:
checking whether the amount format is correct;
checking whether the field of the transaction type is correct;
checking whether the field of the currency is correct;
the field of exchange rate is checked for correctness.
Preferably, the basic information of the accounting voucher includes serial number, accounting date, transaction type, exchange rate, debit amount, credit amount, bank account number, account maker, auditor and generation time.
Preferably, the configuration information comprises a certificate code, an entry serial number and a subject number;
the entry information includes serial number, voucher code, entry serial number, abstract, subject number, debit mark, debit amount and credit amount.
The web-based accounting voucher generation method and system have the following advantages that:
1. the method is universal for different bookkeeping original data, has wide range, and saves the time for financial staff to manually calculate and enter bookkeeping vouchers;
2. compared with manual accounting, the method improves the accuracy, and verifies the input accounting original data to further improve the accuracy.
Drawings
In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings needed to be used in the description of the embodiments will be briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without creative efforts.
The invention is further described below with reference to the accompanying drawings.
FIG. 1 is a block flow diagram of a method for generating a web-based billing voucher in accordance with example 1.
Detailed Description
The present invention is further described in the following with reference to the drawings and the specific embodiments so that those skilled in the art can better understand the present invention and can implement the present invention, but the embodiments are not to be construed as limiting the present invention, and the embodiments and the technical features of the embodiments can be combined with each other without conflict.
The embodiment of the invention provides a method and a system for generating a bookkeeping voucher based on a web, which are used for solving the technical problem of how to generate a universal bookkeeping voucher generation mode based on the web.
Example 1:
as shown in fig. 1, a method for generating a web-based billing voucher of the present invention comprises the following steps:
s100, checking the input accounting original data, including checking whether an information field in the accounting original data is correct or not;
s200, if the verification fails, ending, if the verification succeeds, performing data processing on the accounting original data to obtain basic information of the accounting voucher, and storing the basic information of the accounting voucher to a basic information table;
s300, generating entry information of each entry according to the configuration information in the entry configuration table, and storing the entry information into an entry detail table;
and S400, calling a financial system interface, and importing the accounting voucher information into a financial system.
The billing raw data includes, among other things, the amount, transaction type, currency, and exchange rate. Checking the input accounting original data, comprising: checking whether the amount format is correct; checking whether the field of the transaction type is correct; checking whether the field of the currency is correct; the field of exchange rate is checked for correctness.
After the verification is successful, data processing is carried out on the bookkeeping original data, information such as accounting date, transaction type, exchange rate, debit amount, credit amount, bank account number, system person, audit person and generation time is obtained, a serial number is generated and is a bookkeeping unique identifier, and the information such as the serial number, the accounting date, the transaction type, the exchange rate, the debit amount, the credit amount, the bank account number, the system person, the audit person and the generation time is stored in a basic information table as basic information of a bookkeeping voucher.
The configuration information in the entry configuration table comprises a certificate code, an entry serial number and a subject number, and the entry information comprises a serial number, a certificate code, an entry serial number, an abstract, a subject number, a lending mark, a borrower amount, a lender amount and the like.
The basic information table and the entry detail table are stored in the database, a certificate table and a subject table are further stored in the database, a certificate code and a certificate name are stored in the certificate table, and a subject number and a subject name are stored in the subject table.
The invention relates to a web-based accounting voucher generation method, which is used for processing the successfully verified accounting original data to obtain accounting voucher information, and performing entry to finally realize the generation of the accounting voucher.
Example 2:
the invention discloses a web-based accounting voucher generating system which comprises a database, a checking module, a data processing module, an entry module and a derivation module.
The database is configured with a basic information table, an entry detail table, a certificate table and a subject table, wherein the basic information table is used for storing basic information of the bookkeeping certificate, the entry detail table is used for storing entry information, the certificate table is used for storing a certificate code and a certificate name, and the subject table is used for storing a subject number and a subject name.
The checking module is used for checking the input accounting original data, including checking whether the information field in the accounting original data is correct. Billing raw data includes amount, transaction type, currency, and exchange rate. Checking the input accounting original data, comprising: checking whether the amount format is correct; checking whether the field of the transaction type is correct; checking whether the field of the currency is correct; the field of exchange rate is checked for correctness.
And the data processing module is used for carrying out data processing on the bookkeeping original data after the verification is successful, acquiring information such as accounting date, transaction type, exchange rate, debit amount, credit amount, bank account number, system person, auditor and generation time, generating a serial number which is a bookkeeping unique identifier, and storing the serial number, the accounting date, the transaction type, the exchange rate, the debit amount, credit amount, the bank account number, the system person, the auditor and the generation time which are used as basic information of a bookkeeping certificate into a basic information table.
The entry module is used for generating entry information of each entry according to the configuration information in the entry configuration table and storing the entry information into the entry detail table. The configuration information in the entry configuration table comprises a certificate code, an entry serial number and a subject number, and the entry information comprises a serial number, a certificate code, an entry serial number, an abstract, a subject number, a lending mark, a borrower amount, a lender amount and the like.
The export module is used for calling a financial system interface and importing the accounting voucher information into a financial system.
A web-based billing voucher generation system of the present invention can perform the web-based billing voucher generation method disclosed in embodiment 1.
The above-mentioned embodiments are merely preferred embodiments for fully illustrating the present invention, and the scope of the present invention is not limited thereto. The equivalent substitution or the change made by the person skilled in the art on the basis of the present invention are within the protection scope of the present invention. The protection scope of the invention is subject to the claims.
Claims (10)
1. A web-based billing voucher generation method, comprising the steps of:
checking the input accounting original data, including checking whether the information field in the accounting original data is correct or not;
if the verification is successful, carrying out data processing on the accounting original data to obtain basic information of the accounting voucher, and storing the basic information of the accounting voucher into a basic information table;
generating entry information of each entry according to the configuration information in the entry configuration table, and storing the entry information into an entry detail table;
and calling a financial system interface, and importing the accounting voucher information into a financial system.
2. The web-based billing voucher generation method of claim 1 wherein the billing original data comprises amount, transaction type, currency and exchange rate;
checking the input accounting original data, comprising:
checking whether the amount format is correct;
checking whether the field of the transaction type is correct;
checking whether the field of the currency is correct;
the field of exchange rate is checked for correctness.
3. The method as claimed in claim 2, wherein the basic information of the billing voucher includes serial number, accounting date, transaction type, exchange rate, debit amount, credit amount, bank account number, producer, auditor and generation time.
4. The web-based billing voucher generation method of claim 3, wherein the configuration information in the entry configuration table comprises a voucher code, an entry sequence number and a subject number.
5. The method of web-based billing voucher generation of claim 4 wherein the entry information comprises a serial number, voucher code, entry serial number, abstract, subject number, debit tag, debit amount and credit amount.
6. The method as claimed in any one of claims 1-5, wherein the basic information table and the entry details table are stored in a database, and the database further stores a certificate table and a subject table, the certificate table stores a certificate code and a certificate name, and the subject table stores a subject number and a subject name.
7. A web-based billing voucher generation system, comprising:
the system comprises a database, a data base and a data processing system, wherein the database is provided with a basic information table, an entry detail table, a certificate table and a subject table, the basic information table is used for storing basic information of an accounting certificate, the entry detail table is used for storing entry information, the certificate table is used for storing a certificate code and a certificate name, and the subject table is used for storing a subject number and a subject name;
the checking module is used for checking the input accounting original data, and checking whether the information field in the accounting original data is correct or not;
the data processing module is used for carrying out data processing on the accounting original data after the verification is successful to obtain the basic information of the accounting voucher and storing the basic information of the accounting voucher to a basic information table;
the entry module is used for generating entry information of each entry according to the configuration information in the entry configuration table and storing the entry information into the entry detail table;
and the export module is used for calling the financial system interface and importing the accounting voucher information into the financial system.
8. The web-based billing voucher generation system of claim 7 wherein the billing primary data comprises amount, transaction type, currency and exchange rate;
the verification module verifies the input accounting original data and comprises the following steps:
checking whether the amount format is correct;
checking whether the field of the transaction type is correct;
checking whether the field of the currency is correct;
the field of exchange rate is checked for correctness.
9. The web-based billing voucher generation system of claim 7 wherein the basic billing voucher information includes serial number, accounting date, transaction type, exchange rate, debit amount, credit amount, bank account number, credit maker, auditor and generation time.
10. The web-based billing voucher generation system of claim 9 wherein the configuration information comprises a voucher code, an entry sequence number and a subject number;
the entry information includes serial number, voucher code, entry serial number, abstract, subject number, debit mark, debit amount and credit amount.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911036705.8A CN110796531A (en) | 2019-10-29 | 2019-10-29 | Web-based accounting voucher generation method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911036705.8A CN110796531A (en) | 2019-10-29 | 2019-10-29 | Web-based accounting voucher generation method and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110796531A true CN110796531A (en) | 2020-02-14 |
Family
ID=69441856
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911036705.8A Pending CN110796531A (en) | 2019-10-29 | 2019-10-29 | Web-based accounting voucher generation method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110796531A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111738847A (en) * | 2020-08-03 | 2020-10-02 | 成都寻道数财科技有限公司 | System and method for matching lenders of same economic service in certificate sheet |
| CN112950345A (en) * | 2021-03-05 | 2021-06-11 | 北京健康之家科技有限公司 | Business and financial data processing method and device and computer equipment |
| CN113051883A (en) * | 2021-03-23 | 2021-06-29 | 金蝶软件（中国）有限公司 | Voucher generation method and device, computer equipment and storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2010244227A (en) * | 2009-04-03 | 2010-10-28 | Hisatomo Kk | Accounting input storage device |
| CN102567345A (en) * | 2010-12-17 | 2012-07-11 | 金蝶软件（中国）有限公司 | Method and device for generating bookkeeping voucher |
| CN108717429A (en) * | 2018-05-11 | 2018-10-30 | 平安科技（深圳）有限公司 | Financial data accreditation method, apparatus, computer equipment and storage medium |
| CN108734563A (en) * | 2018-04-27 | 2018-11-02 | 陈�光 | A method of automatically generating intelligent accounting voucher |
| CN109961359A (en) * | 2017-12-22 | 2019-07-02 | 银联数据服务有限公司 | A kind of fund management method and capital management platform |
-
2019
- 2019-10-29 CN CN201911036705.8A patent/CN110796531A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2010244227A (en) * | 2009-04-03 | 2010-10-28 | Hisatomo Kk | Accounting input storage device |
| CN102567345A (en) * | 2010-12-17 | 2012-07-11 | 金蝶软件（中国）有限公司 | Method and device for generating bookkeeping voucher |
| CN109961359A (en) * | 2017-12-22 | 2019-07-02 | 银联数据服务有限公司 | A kind of fund management method and capital management platform |
| CN108734563A (en) * | 2018-04-27 | 2018-11-02 | 陈�光 | A method of automatically generating intelligent accounting voucher |
| CN108717429A (en) * | 2018-05-11 | 2018-10-30 | 平安科技（深圳）有限公司 | Financial data accreditation method, apparatus, computer equipment and storage medium |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111738847A (en) * | 2020-08-03 | 2020-10-02 | 成都寻道数财科技有限公司 | System and method for matching lenders of same economic service in certificate sheet |
| CN112950345A (en) * | 2021-03-05 | 2021-06-11 | 北京健康之家科技有限公司 | Business and financial data processing method and device and computer equipment |
| CN113051883A (en) * | 2021-03-23 | 2021-06-29 | 金蝶软件（中国）有限公司 | Voucher generation method and device, computer equipment and storage medium |
| CN113051883B (en) * | 2021-03-23 | 2024-02-13 | 金蝶软件（中国）有限公司 | Credential generation method, apparatus, computer device, and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110612546B (en) | Method and apparatus for digital asset account management | |
| EP2284784B1 (en) | Universal merchant platform for payment authentication | |
| CN111414650B (en) | Order processing method and system based on blockchain storage certificate | |
| US7693783B2 (en) | Universal merchant platform for payment authentication | |
| US20140081863A1 (en) | Universal merchant platform for payment authentication | |
| CN106575400A (en) | Authentication system with message conversion | |
| CN110796531A (en) | Web-based accounting voucher generation method and system | |
| WO2009079098A1 (en) | System and method for electronic contracting | |
| CN202771476U (en) | Security certification system | |
| CN106815725A (en) | A kind of transaction verification method and device | |
| WO2002015091A1 (en) | System and method for providing warranties in electronic commerce | |
| CN106934621A (en) | The examination ＆ approval safety certifying method and system of payment funding | |
| CN110910106B (en) | Cash management message processing method and system | |
| CN101356776A (en) | Efficient method and system for secure business-to-business transaction | |
| KR20070092400A (en) | System and method for processing payment by using nickname | |
| US20040024705A1 (en) | Clearing method using a communications network (variants) | |
| CN114298698A (en) | Transaction settlement method and device | |
| KR20080104404A (en) | System and method for processing sale bond by using affiliated store and program recording medium | |
| JP2003233717A (en) | Electronic settlement system and electronic settlement method | |
| CN111431725B (en) | Bank system electronic protocol signing, changing and validity verification method, electronic protocol management system and readable storage medium | |
| KR20090001948A (en) | System and method for processing loan and program recording medium | |
| KR20070092391A (en) | System and method for providing unfaced channel user interface by using nickname and recording medium | |
| JP2022099455A (en) | Journal data creation system and journal data creation method | |
| KR20220111916A (en) | Payment token system and method based on self-sovereign identity verification | |
| WO2021118447A1 (en) | Method for performing an offline transaction |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20200214 |