CN111046647A - Automatic typesetting method and automatic accounting book generation method - Google Patents
Automatic typesetting method and automatic accounting book generation method Download PDFInfo
- Publication number
- CN111046647A CN111046647A CN201911153385.4A CN201911153385A CN111046647A CN 111046647 A CN111046647 A CN 111046647A CN 201911153385 A CN201911153385 A CN 201911153385A CN 111046647 A CN111046647 A CN 111046647A
- Authority
- CN
- China
- Prior art keywords
- bill
- paper
- typesetting
- accounting
- voucher
- 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.)
- Granted
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
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
-
- 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
- G06V—IMAGE OR VIDEO RECOGNITION OR UNDERSTANDING
- G06V30/00—Character recognition; Recognising digital ink; Document-oriented image-based pattern recognition
- G06V30/40—Document-oriented image-based pattern recognition
- G06V30/41—Analysis of document content
- G06V30/413—Classification of content, e.g. text, photographs or tables
Abstract
The invention belongs to the technical field of intelligent account making, and provides an automatic typesetting method and an automatic accounting book generating method, which comprise the steps of obtaining bills uploaded by a user, and obtaining forms and related information; generating a bookkeeping voucher; obtaining a voucher summary table/subject balance table according to the bookkeeping voucher; automatically typesetting related bills and forms; obtaining envelope data; and obtaining a printing format, and printing to generate an account book. Through above-mentioned technical scheme, the loaded down with trivial details, the high problem of error rate of process when having solved accounting account book among the prior art and having generated.
Description
Technical Field
The invention belongs to the technical field of intelligent account making, and relates to an automatic typesetting method and an automatic accounting book generation method.
Background
The account book can comprehensively, systematically and comprehensively reflect the economic condition and the financial income and expenditure condition of an enterprise. At present, the traditional accounting book is usually carried out manually, and the specific steps are as follows: first, a large number of tickets are based on: costs, inventory, documents, expenses, income, bank notes, etc. are sorted and ordered in a certain order; then, corresponding accounting voucher tables are made according to the various bills, and a voucher summary table and a subject balance table are made according to the accounting voucher tables under the categories. And then, sequentially pasting the attached sheets on the accounting voucher pasting sheets of the corresponding classes. And finally, checking whether the numbers of the bookkeeping voucher and the corresponding attached list are complete, whether the arrangement sequence is correct, whether missing exists and the like. Wherein, part of the attached notes need accountants to manually make forms and add up, including payroll tables, fixed asset depreciation tables, intangible asset amortization tables, asset long-term expense amortization tables and the like. If a plurality of people check that the errors are not correct, binding the books in sequence. If the binding order is reversed, the binding order needs to be rearranged and then bound into a book. The account-keeping voucher to be pasted needs to be neat, beautiful, flat and convenient to look up. When the coupon is large, the coupon needs to be folded and pasted firstly. This approach has the following disadvantages:
1. the bill quantity is large, the tedious and repeated work can cause mental fatigue, inattention and the like of the accountant staff, data errors can be caused due to human factors, and the efficiency is low.
2. Once the bill is lost, the recovery is troublesome or even impossible.
3. The arrangement work can not be carried out cooperatively, and the repeated and monotonous bill pasting work is time-consuming and labor-consuming.
4. Tables such as payroll tables, fixed asset depreciation tables, intangible asset amortization tables, asset long-term expense amortization and the like need to be manually calculated and manufactured by accountants, and the process is complicated and the error rate is high.
5. When the account book is completed, a plurality of people are required to check whether the bookkeeping voucher, the attached list number and the content of the voucher are correct or not, whether the binding sequence is correct or not and the workload is heavy.
Therefore, how to accurately, efficiently and automatically generate the account book and print the account book in an integrated mode becomes a key problem to be solved urgently.
Disclosure of Invention
The invention provides an automatic typesetting method and an automatic accounting book generating method, which solve the problem that the manual labor intensity is high when an accounting book is generated in the prior art.
The technical scheme of the invention is realized as follows: an automatic typesetting method comprises the steps of
S11: the paper information and the given ticket collection M are obtained,
obtaining the width W and the length L of the paper, defining the coordinates of the lower left corner of the paper as (0, 0) and the coordinates of the upper right corner of the paper as (W, L),
obtaining a given set of notes M { (W)1，L1，area1),(W2，L2，area2),...,(Wn，Ln，arean) The nth note is marked as MnWidth of WnLength of LnArea is areanDefinition of a Bill MnThe coordinate of the lower left corner is
Coordinates of the upper right corner are
S12: the bill M with the largest area in the bill set MiPlacing at the lower left corner of the paper, updating the width W 'and length L' of the paper, and updating the bill MiThe typesetting mode comprises the following steps: longitudinally typesetting and transversely typesetting;
s13: the bill M with the largest area and the width or the length smaller than W' in the rest bills of the bill collection MjAnd updating the width W 'and the length L' of the paper, specifically:
s131: placing bill Mj，MjHas a width of LjLength of WjAnd satisfy
Lj< W' or Wj＜W’，
Will MjPut in the upper right corner of the paper, the bill MjThe typesetting mode comprises the following steps: the horizontal typesetting or the vertical typesetting,
s132: mobile bill MjFirst moving down and then left by MjThe bill M is required to be satisfied in the moving processjNot overlapping with any existing note in the paper and note MjIs not discharged out of the sheet of paper,
s133: updating the width W 'and the length L' of the paper;
s14: step S13 is repeated until there is insufficient area left in the sheet to drop any note, i.e., any note MaLength L ofaAnd width WaSatisfy the requirement of
Wa> W' and La＞W’；
S15: calculating paper utilization
And changing the typesetting modes of the bills in the steps S12 to S14, and re-executing the steps S12 to S15 until all combinations of the bill typesetting modes are used, finding out the maximum value of the paper utilization rate, wherein the combination of the corresponding bill typesetting modes is the final bill typesetting mode.
Further, updating the width W 'and the length L' of the sheet in step S12 specifically includes:
Mihas a length of LiWidth of WiArea is areai，
If the bill MiSatisfy the requirement of
Wi< W' and Li＜W’，
Then put the bill MiThere are two ways:
a) the typesetting is carried out in the transverse direction,
bill MiAfter the placement, the width W' of the paper is W-WiLength L ═ L-Li；
b) The typesetting is carried out longitudinally,
bill MiAfter the placement, the width W' of the paper is W-LiLength L ═ L-Wi；
If the bill MiSatisfy the requirement of
Wi< W' and Li＞W’，
Then put the bill MiThen, the above-mentioned method b) is adopted;
further, updating the width W 'and the length L' of the sheet in step S13 specifically includes:
if the bill MjSatisfy the requirement of
Wj< W' and Lj＜W’，
Then put the bill MjThere are two ways:
c) the typesetting is carried out in the transverse direction,
bill MjAfter the placement, the width W 'of the paper sheet is W' -WjLength L '═ L' -Lj；
d) The typesetting is carried out longitudinally,
bill MjAfter the placement, the width of the paper W ═ W' -LjLength L '═ L' -Wj；
If the bill MjSatisfy the requirement of
Wj< W' and Lj＞W’，
Then put the bill MjThen, according to the above mode d);
furthermore, the invention also provides an automatic generation method of the accounting book, which comprises the steps of
S21: obtaining the bill uploaded by the user, classifying the bill,
the form is obtained by obtaining the form,
acquiring fixed asset depreciation data information, intangible asset amortization data information, long-term expense data information to be shared and wage and social security data;
s22: generating a bookkeeping voucher according to the bill classification result, and carrying out statistical annotation on the bill by a big data analysis method, wherein the annotation content comprises: accounting unit, bill number, belonging voucher number and date of attached instrument bill,
generating a bookkeeping voucher according to the form, and carrying out statistical annotation on the form by a big data analysis method, wherein the annotation content comprises: accounting unit, form number, certificate number and date of attached form,
the ticket and form are collectively referred to as a coupon, and the accounting voucher includes: accounting unit, number of attached bills, voucher number, subject name, debit amount, credit amount, bookkeeping personnel, billing personnel, auditor and bookkeeping date,
the fixed asset depreciation table is automatically generated by extracting the depreciation data information of the fixed asset through the regular maintenance and big data analysis meter, the intangible asset amortization table is automatically generated by extracting the intangible asset amortization data information through the regular maintenance and big data analysis meter, the asset long-term amortization cost amortization table is automatically generated by analyzing the long-term amortization cost data information through the regular maintenance and big data analysis meter, the wage statistical table is automatically generated by extracting wages and social security data through the regular maintenance and big data analysis meter, and the final period is converted into an accounting voucher,
arranging the bills and the forms in sequence to the corresponding bookkeeping vouchers through big data analysis, and marking page numbers according to the sequence;
s23: obtaining a voucher summary table/subject balance table according to the bookkeeping voucher;
s24: arranging according to the order of a voucher summary table/subject balance table, a bookkeeping voucher, a bill associated with the bookkeeping voucher, a form associated with the bookkeeping voucher, a payroll table, a fixed asset depreciation table, an intangible asset amortization table and an asset long-term amortization expense amortization table,
when the plurality of bills are associated with the bookkeeping voucher, executing the steps S11-S15 to automatically typeset the plurality of bills;
s25: obtaining envelope data, comprising: the method comprises the following steps that a filing unit is fully called, account book names, accounting time, accounting book numbers, accounting number sheets, storage period, accounting supervisor, bookbinder and bookbinding time, wherein the fully called, the accounting time, the accounting book numbers and the accounting number sheets are all automatically obtained;
s26: and obtaining a printing format, and printing to generate an account book.
Further, step S21 specifically includes:
s211: obtaining a bill picture set through scanning;
s212: uploading the bill picture set to a server;
s213: cleaning the bills with the concentrated bill pictures, and removing the repeated bills and irrelevant bills;
s214: identifying the bill contents in the bill picture set, classifying according to the identified contents,
the category I categories of the item classification include inventory, bank notes, bank statements, documents, fees, revenues, costs, certificates, assets, accessories, problem items and unidentified items, and some category I categories include category II categories
If the bill contains only the I-level catalog classification subject, generating a bookkeeping voucher corresponding to the subject bill according to the bill under the I-level catalog classification subject, if the II-level catalog exists, generating a bookkeeping voucher corresponding to the catalog bill according to the bill under the II-level catalog, and generating a combination voucher according to the bookkeeping voucher of the II-level catalog subject type under the I-level catalog classification subject.
Further, obtaining the printing format in step S26 includes
S261: selecting an account period needing to be printed with an account book, wherein the account period comprises a single-month or multi-month account book;
s262: setting a printing paper type;
s263: selecting whether an inventory subset subject document needs to be printed;
s264: selecting a summary sheet to print: a balance list of subjects or a summary list of credentials.
Further, when printing the ledger in step S26, if a plurality of users send a plurality of ledger print requests, a plurality of ledger print request tasks are sequentially stored in the message middleware, and then the task order in the message middleware is extracted into the thread pool, asynchronous parallel processing of the plurality of ledger print request tasks is realized,
and after the account book printing request task is processed, prompting that the account book is automatically generated in a short message or system message mode.
The working principle of the invention is as follows:
on a paper of width W and length L, a given set of notes M { (W) is conventionally assumed to be W < L1，L1，area1),(W2，L2，area2),...,(Wn，Ln，arean) Typesetting and printing are carried out, and the requirements of: the bill compartments are not overlapped, the bill edges are parallel to the edges of the paper, each bill can be transversely or longitudinally typeset and cannot discharge the paper, and the utilization rate of the paper is highest by changing the combination of the transverse or longitudinal typesetting modes of the bills.
The basic information of the bill is set as follows: the width of the bill is E, the length of the bill is F, and the coordinates of the lower left corner and the upper right corner of the current bill are respectively (x)l,yl),(xr,yr) The two coordinates satisfy the following relationship:
when the notes are arranged longitudinally on the sheet, co is 0, when the notes are arranged transversely on the sheet, co is 1,
any two bills M for composingc,MdThe coordinates of the lower left corner and the upper right corner are respectively:
then to ensure Mc,MdNot overlapping, one of the following needs to be satisfied,
the objective function of the typesetting is as follows:
on the premise of meeting the constraint conditions of the formulas (1) and (2), the utilization rate of the paper is as high as possible.
The specific process of automatic typesetting is as follows:
i) firstly, find out the bill M with the largest area in the bill set MiThe bill MiIs placed at the lower left corner of the paper and updates the placed bill MiWidth W 'and length L' of the rear sheet;
ii) selecting the note M with width or length smaller than W' and largest area in the rest notesjWill MjPlacing the paper on the upper right corner of the paper, moving downwards and then leftwards until the paper contacts the edges of other bills or paper, and updating the width W 'and the length L' of the paper;
iii) repeating step (ii) until there is insufficient area remaining to drop any notes;
iv) calculating the utilization of the paper
And (5) changing the typesetting modes of the bills in the steps i) to iii), and re-executing the steps S12 to S15 until all combinations of the bill typesetting modes are used, finding out the maximum value of the paper utilization rate, wherein the combination of the corresponding bill typesetting modes is the final bill typesetting mode.
The invention has the beneficial effects that:
1. the invention provides an automatic typesetting method, which is beneficial to fully utilizing the utilization rate of paper by placing various bills in sequence from large to small according to the condition that the bills are not overlapped and cannot be arranged outside the paper. Each bill has two typesetting modes of horizontal and vertical, so that a plurality of bills have various combined typesetting modes, the combination of the typesetting modes is tried once, and the combination with the highest paper utilization rate is selected as the final typesetting mode, so that the paper utilization rate is further improved.
The invention not only realizes the automatic typesetting of a plurality of bills, but also can ensure the utilization rate of paper and is beneficial to realizing the automatic printing of a plurality of bills.
2. When the width and the length of one bill are both less than the width of the rest part of the paper, the bill has two typesetting modes of transverse and longitudinal.
When a note is placed in a transverse manner, the width of the remainder of the sheet is W ═ W-WiLength L ═ L-Li(ii) a When a note is placed in a vertical manner, the width W' of the sheet is W-LiLength L ═ L-Wi。
3. On the basis of the automatic typesetting method, the invention also provides an automatic generation method of the accounting book, which generates a bookkeeping voucher on the basis of obtaining bills, forms, fixed asset depreciation data information, intangible asset amortization data information, long-term expense data information to be shared, and wage and social security data; obtaining a voucher summary table/subject balance table according to the bookkeeping voucher; arranging according to the order of a voucher summary table/subject balance table, a bookkeeping voucher, a voucher associated bill, a form, a wage statistical table, a fixed asset depreciation table, an intangible asset amortization table and an asset long-term to-be-amortized expense amortization table, and when a plurality of bills associated with the bookkeeping voucher are used as a given bill set M, executing steps S11-S15 to automatically typeset the bills; obtaining envelope data; and obtaining a printing format, and finally printing to generate the account book.
A user only needs to upload a bill to generate a form, and simultaneously inputs fixed asset depreciation data information, intangible asset amortization data information and long-term expense data information to be shared, and periodically maintains wage and social security data, so that an accounting book can be generated by one key, the integrated operation avoids errors, the printing flow of the book is more perfect and standardized, and meanwhile, the book data information is stored in a lasting and digital mode, and the audit and the lookup are convenient.
On the basis of automatic typesetting with high utilization rate, the invention accurately, efficiently and automatically prints the account book, and keeps neat, beautiful and flat, and is convenient for looking up.
The invention carries out statistical marking on accounting units, bill attaching quantity, certificate numbers, subject names, debit amount, credit amount, bookkeeping personnel, bill making personnel, auditors and bookkeeping dates related to bookkeeping vouchers through big data analysis, wherein the bill attaching quantity is convenient for auditing and checking.
According to the invention, a payroll table, a fixed asset depreciation table, an intangible asset amortization table and an asset long-term expense amortization table are generated through big data analysis and cloud computing, accounting personnel do not need to manually count and make corresponding tables, and only the related information of the personnel needs to be regularly maintained, so that the labor cost is saved, the working efficiency is greatly improved, and the error rate is reduced.
A user only needs to upload a bill to generate a form, and simultaneously inputs fixed asset depreciation data information, intangible asset amortization data information and long-term expense data information to be shared, and periodically maintains wage and social security data, so that an accounting book can be generated by one key, the integrated operation avoids errors, the printing flow of the book is more perfect and standardized, and meanwhile, the book data information is stored in a lasting and digital mode, and the audit and the lookup are convenient.
On the basis of automatic typesetting with high utilization rate, the invention accurately, efficiently and automatically prints the account book, and keeps neat, beautiful and flat, and is convenient for looking up.
4. In the invention, the bill picture is scanned and then automatically uploaded to the server, and the bill picture can be acquired from the server in the subsequent steps; by cleaning the bill pictures, repeated bills and irrelevant bills are removed, and subsequent bill content identification and bill classification are facilitated.
The forms include warehousing forms, ex-warehousing forms, etc., which are automatically generated after secondary accounting of inventory is performed.
The bills and the forms are automatically classified according to the I-level catalog classification subjects and the II-level catalog classification subjects, so that labor is saved, and the bills or the forms corresponding to the subjects can be put together to generate corresponding bookkeeping vouchers. The method comprises the following steps of automatically acquiring data of bills and forms by carrying out statistical marking on the bills and the forms, wherein the bill data comprises the following components: the accounting unit, the bill number, the certificate number and the date of the attached instrument bill, and the form data comprises: accounting unit, form number, belonging voucher number and date of attached form.
5. According to the invention, through big data and cloud computing, not only can the automatic generation of the fixed asset translation table be realized, but also a proper accounting method can be selected, so that an accounting result is more in line with the self condition of a user and has more reference value.
6. The printing format of the invention can be set by a user, firstly, the account period of the account book needing to be printed is selected, the account book in a single month or multiple months can be selected, then, the printing paper type is set, the printing of paper with various specifications is supported, and the paper size and the paper type can be customized. Finally, whether the inventory subset subject matter certificate needs to be printed is selected.
7. The invention reduces the pressure of the server through asynchronous multithreading, solves the problems of too many printing waiting time due to more users, more bookkeeping certificates, more tickets and no need of waiting for the user, and improves the user experience.
Drawings
The present invention will be described in further detail with reference to the accompanying drawings and specific embodiments.
FIG. 1 is a flow chart of an automatic typesetting method according to the invention;
FIG. 2 is a flow chart of an automatic generation method of an accounting book according to the present invention;
FIG. 3 is a schematic diagram of a billing voucher according to the present invention;
FIG. 4 is a diagram illustrating an account book structure according to the present invention;
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments obtained by persons skilled in the art based on the embodiments in the present embodiment without any creative efforts belong to the protection scope of the present embodiment.
As shown in fig. 1, an automatic typesetting method includes step S11: the paper information and the given ticket collection M are obtained,
obtaining the width W and the length L of the paper, defining the coordinates of the lower left corner of the paper as (0, 0) and the coordinates of the upper right corner of the paper as (W, L),
obtaining a given set of notes M { (W)1，L1，area1),(W2，L2，area2),...,(Wn，Ln，arean) The nth note is marked as MnWidth of WnLength of LnArea is areanDefinition of a Bill MnThe coordinate of the lower left corner is
Coordinates of the upper right corner are
S12: the bill M with the largest area in the bill set MiPlacing at the lower left corner of the paper, updating the width W 'and length L' of the paper, and updating the bill MiThe typesetting mode comprises the following steps: longitudinally typesetting and transversely typesetting;
s13: the bill M with the largest area and the width or the length smaller than W' in the rest bills of the bill collection MjAnd updating the width W 'and the length L' of the paper, specifically:
s131: placing bill Mj，MjHas a width of LjLength of WjAnd satisfy
Lj< W' or Wj＜W’，
Will MjPut in the upper right corner of the paper, the bill MjThe typesetting mode comprises the following steps: the horizontal typesetting or the vertical typesetting,
s132: mobile bill MjFirst moving down and then left by MjThe bill M is required to be satisfied in the moving processjNot overlapping with any existing note in the paper and note MjIs not discharged out of the sheet of paper,
s133: updating the width W 'and the length L' of the paper;
s14: step S13 is repeated until there is insufficient area left in the sheet to drop any note, i.e., any note MaLength L ofaAnd width WaSatisfy the requirement of
Wa> W' and La＞W’；
S15: calculating paper utilization
And changing the typesetting modes of the bills in the steps S12 to S14, and re-executing the steps S12 to S15 until all combinations of the bill typesetting modes are used, finding out the maximum value of the paper utilization rate, wherein the combination of the corresponding bill typesetting modes is the final bill typesetting mode.
The embodiment realizes the automatic typesetting of the bills on the premise that the bills are not overlapped and cannot be arranged outside the paper. Each bill has two typesetting modes of horizontal and vertical, so that a plurality of bills have various combined typesetting modes, the combination of the typesetting modes is tried once, and the combination with the highest paper utilization rate is selected as the final typesetting mode, thereby being beneficial to improving the paper utilization rate.
The embodiment not only realizes the automatic typesetting of a plurality of bills, but also can ensure the utilization rate of paper, and is favorable for realizing the automatic printing of a plurality of bills.
Further, updating the width W 'and the length L' of the sheet in step S12 specifically includes:
Mihas a length of LiWidth of WiArea is areai，
If the bill MiSatisfy the requirement of
Wi< W' and Li＜W’，
Then put the bill MiThere are two ways:
a) the typesetting is carried out in the transverse direction,
bill MiAfter the placement, the width W' of the paper is W-WiLength L ═ L-Li；
b) The typesetting is carried out longitudinally,
bill MiAfter the placement, the width W' of the paper is W-LiLength L ═ L-Wi；
If the bill MiSatisfy the requirement of
Wi< W' and Li＞W’，
Then put the bill MiThen, the above-mentioned method b) is adopted;
in the embodiment, when the width and the length of one bill are both smaller than the width of the rest part of the paper, the bill has two typesetting modes of transverse and longitudinal directions, and when the width of one bill is smaller than the width of the rest part of the paper and the length of the bill is larger than the width of the rest part of the paper, the bill has only one typesetting mode of the longitudinal direction.
When a note is placed in a transverse manner, the width of the remainder of the sheet is W ═ W-WiLength L ═ L-Li(ii) a When a note is placed in a vertical manner, the width W' of the sheet is W-LiLength L ═ L-Wi。
Further, updating the width W 'and the length L' of the sheet in step S13 specifically includes:
if the bill MjSatisfy the requirement of
Wj< W' and Lj＜W’，
Then put the bill MjThere are two ways:
c) the typesetting is carried out in the transverse direction,
bill MjAfter the placement, the width W 'of the paper sheet is W' -WjLength L '═ L' -Lj；
d) The typesetting is carried out longitudinally,
bill MjAfter the placement, the width of the paper W ═ W' -LjLength L '═ L' -Wj；
If the bill MjSatisfy the requirement of
Wj< W' and Lj＞W’，
Then put the bill MjThen, according to the above mode d);
further, the embodiment also provides an automatic generation method of the accounting book, which comprises the steps of
S21: obtaining the bill uploaded by the user, classifying the bill,
the form is obtained by obtaining the form,
acquiring fixed asset depreciation data information, intangible asset amortization data information, long-term expense data information to be shared and wage and social security data;
s22: generating a bookkeeping voucher according to the bill classification result, and carrying out statistical annotation on the bill by a big data analysis method, wherein the annotation content comprises: accounting unit, bill number, belonging voucher number and date of attached instrument bill,
generating a bookkeeping voucher according to the form, and carrying out statistical annotation on the form by a big data analysis method, wherein the annotation content comprises: accounting unit, form number, certificate number and date of attached form,
the ticket and form are collectively referred to as a coupon, and the accounting voucher includes: accounting unit, number of attached bills, voucher number, subject name, debit amount, credit amount, bookkeeping personnel, billing personnel, auditor and bookkeeping date,
the fixed asset depreciation table is automatically generated by extracting the depreciation data information of the fixed asset through the regular maintenance and big data analysis meter, the intangible asset amortization table is automatically generated by extracting the intangible asset amortization data information through the regular maintenance and big data analysis meter, the asset long-term amortization cost amortization table is automatically generated by analyzing the long-term amortization cost data information through the regular maintenance and big data analysis meter, the wage statistical table is automatically generated by extracting wages and social security data through the regular maintenance and big data analysis meter, and the final period is converted into an accounting voucher,
arranging the bills and the forms in sequence to the corresponding bookkeeping vouchers through big data analysis, and marking page numbers according to the sequence;
s23: obtaining a voucher summary table/subject balance table according to the bookkeeping voucher;
s24: arranging according to the order of a voucher summary table/subject balance table, a bookkeeping voucher, a voucher associated with the bookkeeping voucher, a payroll statistical table, a fixed asset depreciation table, an intangible asset amortization table and an asset long-term expense amortization table,
when the plurality of bills are associated with the bookkeeping voucher, executing the steps S11-S15 to automatically typeset the plurality of bills;
s25: obtaining envelope data;
s26: and obtaining a printing format, and printing to generate an account book.
On the basis of an automatic typesetting method, the embodiment also provides an automatic generation method of the accounting book, which is used for generating a bookkeeping voucher on the basis of obtaining bills, forms, fixed asset depreciation data information, intangible asset amortization data information, long-term expense waiting data information, and wage and social security data; obtaining a voucher summary table/subject balance table according to the bookkeeping voucher; arranging according to the order of a voucher summary table/subject balance table, a bookkeeping voucher, a voucher associated bill, a form, a wage statistical table, a fixed asset depreciation table, an intangible asset amortization table and an asset long-term to-be-amortized expense amortization table, and when a plurality of bills associated with the bookkeeping voucher are used as a given bill set M, executing steps S11-S15 to automatically typeset the bills; obtaining envelope data; and obtaining a printing format, and finally printing to generate the account book.
The invention carries out statistical marking on accounting units, bill attaching quantity, certificate numbers, subject names, debit amount, credit amount, bookkeeping personnel, bill making personnel, auditors and bookkeeping dates related to bookkeeping vouchers through big data analysis, wherein the bill attaching quantity is convenient for auditing and checking.
According to the invention, a payroll table, a fixed asset depreciation table, an intangible asset amortization table and an asset long-term expense amortization table are generated through big data analysis and cloud computing, accounting personnel do not need to manually count and make corresponding tables, and only the related information of the personnel needs to be regularly maintained, so that the labor cost is saved, the working efficiency is greatly improved, and the error rate is reduced.
A user only needs to upload a bill, and simultaneously inputs the depreciation data information of the fixed assets, the amortization data information of the intangible assets and the long-term expense data information to be shared, and the wages and the social security data are regularly maintained, so that the accounting book can be generated by one key, the integrated operation avoids mistakes, the printing flow of the accounting book is more perfect and standardized, and meanwhile, the data information of the accounting book is stored in a lasting and digital mode, and the auditing and the looking up are convenient.
On the basis of automatic typesetting with high utilization rate, the account book printing method and the account book printing system can accurately, efficiently and automatically print the account book and keep neat, attractive, smooth and convenient to look up.
In step S21, uploading the mass bill picture sets obtained by scanning to a server, and then cleaning the bills to remove the repeated bills and irrelevant bills; then, the bill content is identified by the bill identification module, and the intelligent and efficient multi-thread bill classification is used according to the identified content, wherein the class I catalog classification subjects of the bill classification comprise inventory, bank bills, bank statements, bills, expenses, income, cost, certificates, assets, accessories, problem bills, unidentified bills and the like. If the classification subjects of part of I-level catalogues only contain I-level catalogues, the bookkeeping voucher corresponding to the subject bill is generated according to the bill under the level catalog, if the classification subjects of the II-level catalogues exist, the bookkeeping voucher corresponding to the catalog bill is generated according to the bill under the II-level catalog, and the combination voucher is generated according to the bookkeeping voucher of the type of the II-level catalog subjects under the I-level catalog classification subjects.
The forms include warehousing forms, ex-warehousing forms, etc., which are automatically generated after secondary accounting of inventory is performed.
In step S22, a fixed asset depreciation table is automatically generated by periodically maintaining and analyzing and extracting the depreciation data information of the fixed asset with big data; periodically maintaining and analyzing intangible asset amortization data information by a big data analyzer to automatically generate an intangible asset amortization table; and the data information of the long-term expense to be shared is periodically maintained and analyzed by the big data to automatically generate an asset long-term expense amortization table, the wages and social security information are periodically maintained and analyzed by the big data analyzer to automatically generate a wage statistical table, and the data information is automatically transferred to a corresponding bookkeeping voucher at the end of the waiting period. The manual accounting of accountants and the production of corresponding forms are not needed, and only the related information of the employees needs to be maintained regularly.
Wherein, the method for accounting the depreciation of the fixed assets comprises the following steps: the average of years method, the workload method, the total sum of years method and the subtraction of double balance. According to the system, a proper accounting method is intelligently recommended through big data and cloud computing according to an expected implementation mode of economic benefits contained in fixed assets of an enterprise, and the enterprise can select different methods for accounting according to self conditions.
The three methods for amortizing intangible assets are as follows: a straight line method, a yield method and an accelerated amortization method. According to the system, a proper accounting method is intelligently recommended through big data and cloud computing according to a fixed asset depreciation method selected by an enterprise, and the enterprise can also select different methods for accounting according to self conditions.
Wherein, the accounting formula of the wages is as follows:
real wage is basic wage + subsidy-deduction + overtime-social security-tax (3)
When the accumulated pre-deducted due tax payment amount is more than 0, the calculation method of the individual tax is as follows:
the tax amount to be deducted in advance is (individual tax) as the sum of the tax amount to be deducted in advance and the deduction rate is multiplied by the deduction rate-the deduction value is calculated quickly) -the tax amount to be deducted in advance is accumulated (4)
The calculation formula of the accumulated pre-deducted due tax amount is as follows:
the sum of the accumulated pre-deducted due tax amount is accumulated income-accumulated tax free income-accumulated deduction expense-accumulated special deduction-accumulated special additional deduction-accumulated other deduction determined by law (5)
The accounting staff only need maintain staff's basic salary, subsidy, deduction, overtime and social security, and this system is through big data analysis and cloud computing to everyone's basic salary through formula (3), (4), (5) automatic calculation everyone's real salary, then automatic generation salary statistical table.
In step S23, the user can select whether the voucher summary table or the subject balance table, or both, is required according to his or her own condition.
In step S24, the corresponding bills are arranged in order after the accounting voucher through big data analysis and are marked with page numbers in order. The bill comprises: accounting unit, serial number of bill, belonging voucher number, bill and bill date. The accounting voucher includes: accounting units, bill quantity, voucher number, subject name, debit amount, credit amount, bookkeeping personnel, billing personnel, auditor and billing date.
In step S25, the ledger sheet cover data information includes: the system comprises a file building unit full name, an account book name, accounting time, accounting book number, accounting number, storage period, accounting supervisor, bookbinder and bookbinding time. The total number of the filing units is called as user login acquisition, the bookkeeping time is acquired when an account book is generated, and the bookkeeping volume number and the bookkeeping number are automatically acquired through statistical analysis without manual recording.
In step S26, the printing format can be set by the user, and the user can first select the account period for which the account book needs to be printed, can select the account book for a single month or multiple months, and then set the printing paper type to support the printing of paper of various specifications, and can also customize the paper size and the paper type. Finally, whether the inventory subset subject matter certificate needs to be printed is selected.
In step S26, in order to solve the problem that the printing waiting time is too long due to many users, many accounting vouchers, many bills, and other factors, in this embodiment, when a plurality of users send a plurality of account book printing request tasks, the system stores all the received account book printing request tasks in the message middleware, the task processing module extracts the tasks in the message middleware to the thread pool to asynchronously and concurrently process the plurality of tasks, after the task processing is completed, the system can prompt that the account book generation task is completed by a short message or a platform message, and can print the account book in a one-key sequence, so that multiple users do not need to wait, and the user experience is improved.
The present invention is not limited to the above preferred embodiments, and any modifications, equivalent substitutions, improvements, etc. within the spirit and principle of the present invention should be included in the protection scope of the present invention.
Claims (8)
1. An automatic typesetting method is characterized by comprising the following steps
S11: the paper information and the given ticket collection M are obtained,
obtaining the width W and the length L of the paper, defining the coordinates of the lower left corner of the paper as (0, 0) and the coordinates of the upper right corner of the paper as (W, L),
obtaining a given set of notes M { (W)1，L1，area1),(W2，L2，area2),...,(Wn，Ln，arean) The nth note is marked as MnWidth of WnLength of LnArea is areanDefinition of a Bill MnThe coordinate of the lower left corner is
Coordinates of the upper right corner are
S12: the bill M with the largest area in the bill set MiPlacing at the lower left corner of the paper, updating the width W 'and length L' of the paper, and updating the bill MiThe typesetting mode comprises the following steps: longitudinally typesetting and transversely typesetting;
s13: the bill M with the largest area and the width or the length smaller than W' in the rest bills of the bill collection MjAnd updating the width W 'and the length L' of the paper, specifically:
s131: placing bill Mj，MjHas a width of LjLength of WjThen satisfy
Lj< W' or Wj＜W’，
Will MjPut in the upper right corner of the paper, the bill MjThe typesetting mode comprises the following steps: longitudinal typesetting and transverse typesetting,
s132: mobile bill MjFirst moving down and then left by MjThe bill M is required to be satisfied in the moving processjNot overlapping with any existing note in the paper and note MjIs not discharged out of the sheet of paper,
s133: updating the width W 'and the length L' of the paper;
s14: step S13 is repeated until the remaining area in the sheetThe field is not sufficient to put down any bill, i.e. any bill MaLength L ofaAnd width WaSatisfy the requirement of
Wa> W' and La＞W’；
S15: calculating paper utilization
And changing the typesetting modes of the bills in the steps S12 to S14, and re-executing the steps S12 to S15 until all combinations of the bill typesetting modes are used, finding out the maximum value of the paper utilization rate, wherein the combination of the corresponding bill typesetting modes is the final bill typesetting mode.
2. The automatic typesetting method according to claim 1, wherein the step S12 updates the width W 'and the length L' of the paper, specifically:
Mihas a length of LiWidth of WiArea is areai，
If the bill MiSatisfy the requirement of
Wi< W' and Li＜W’，
Then put the bill MiThere are two ways:
a) the typesetting is carried out in the transverse direction,
bill MiAfter the placement, the width W' of the paper is W-WiLength L ═ L-Li；
b) The typesetting is carried out longitudinally,
bill MiAfter the placement, the width W' of the paper is W-LiLength L ═ L-Wi；
If the bill MiSatisfy the requirement of
Wi< W' and Li＞W’，
Then put the bill MiThen, the above-described method b) is performed.
3. The automatic typesetting method according to claim 1, wherein the step S13 updates the width W 'and the length L' of the paper, specifically:
if the bill MjSatisfy the requirement of
Wj< W' and Lj＜W’，
Then put the bill MjThere are two ways:
c) the typesetting is carried out in the transverse direction,
bill MjAfter the placement, the width W 'of the paper sheet is W' -WjLength L '═ L' -Lj；
d) The typesetting is carried out longitudinally,
bill MjAfter the placement, the width of the paper W ═ W' -LjLength L '═ L' -Wj；
If the bill MjSatisfy the requirement of
Wj< W' and Lj＞W’，
Then put the bill MjThen, the above-described method d) is performed.
4. An automatic generation method of an accounting book is characterized by comprising the following steps
S21: obtaining the bill uploaded by the user, classifying the bill,
the form is obtained by obtaining the form,
acquiring fixed asset depreciation data information, intangible asset amortization data information, long-term expense data information to be shared and wage and social security data;
s22: generating a bookkeeping voucher according to the bill classification result, and carrying out statistical annotation on the bill by a big data analysis method, wherein the annotation content comprises: accounting unit, bill number, belonging voucher number and date of attached instrument bill,
generating a bookkeeping voucher according to the form, and carrying out statistical annotation on the form by a big data analysis method, wherein the annotation content comprises: accounting unit, form number, certificate number and date of attached form,
the ticket and form are collectively referred to as a coupon, and the accounting voucher includes: accounting unit, number of attached bills, voucher number, subject name, debit amount, credit amount, bookkeeping personnel, billing personnel, auditor and bookkeeping date,
the fixed asset depreciation table is automatically generated by extracting the depreciation data information of the fixed asset through the regular maintenance and big data analysis meter, the intangible asset amortization table is automatically generated by extracting the intangible asset amortization data information through the regular maintenance and big data analysis meter, the asset long-term amortization cost amortization table is automatically generated by analyzing the long-term amortization cost data information through the regular maintenance and big data analysis meter, the wage statistical table is automatically generated by extracting wages and social security data through the regular maintenance and big data analysis meter, and the final period is converted into an accounting voucher,
arranging the bills and the forms in sequence to the corresponding bookkeeping vouchers through big data analysis, and marking page numbers according to the sequence;
s23: obtaining a voucher summary table/subject balance table according to the bookkeeping voucher;
s24: arranging according to the order of a voucher summary table/subject balance table, a bookkeeping voucher, a bill associated with the bookkeeping voucher, a form associated with the bookkeeping voucher, a payroll table, a fixed asset depreciation table, an intangible asset amortization table and an asset long-term amortization expense amortization table,
when the plurality of bills are associated with the bookkeeping voucher, executing the steps S11-S15 to automatically typeset the plurality of bills;
s25: obtaining envelope data, comprising: the method comprises the following steps that a filing unit is fully called, account book names, accounting time, accounting book numbers, accounting number sheets, storage period, accounting supervisor, bookbinder and bookbinding time, wherein the fully called, the accounting time, the accounting book numbers and the accounting number sheets are all automatically obtained;
s26: and obtaining a printing format, and printing to generate an account book.
5. The method as claimed in claim 4, wherein the step S21 is specifically:
s211: obtaining a bill picture set through scanning;
s212: uploading the bill picture set to a server;
s213: cleaning the bills with the concentrated bill pictures, and removing the repeated bills and irrelevant bills;
s214: identifying the bill contents in the bill picture set, classifying according to the identified contents,
the category I categories of the item classification include inventory, bank notes, bank statements, documents, fees, revenues, costs, certificates, assets, accessories, problem items and unidentified items, and some category I categories include category II categories
If the bill contains only the I-level catalog classification subject, generating a bookkeeping voucher corresponding to the subject bill according to the bill under the I-level catalog classification subject, if the II-level catalog exists, generating a bookkeeping voucher corresponding to the catalog bill according to the bill under the II-level catalog, and generating a combination voucher according to the bookkeeping voucher of the II-level catalog subject type under the I-level catalog classification subject.
6. The method of claim 4, wherein the step of checking the fixed asset revocation list in step S22 comprises: the method comprises the steps of carrying out year average method, workload method, total annual sum method or double balance deduction, carrying out statistics on historical data in a database through big data and cloud computing, selecting the most used accounting method as a final accounting method according to an economic benefit expectation implementation mode contained in fixed assets of an enterprise, or selecting an accounting method by a user according to self needs.
7. The method as claimed in claim 4, wherein the step of obtaining a printing format in step S26 includes
S261: selecting an account period needing to be printed with an account book, wherein the account period comprises a single-month or multi-month account book;
s262: setting a printing paper type;
s263: selecting whether an inventory subset subject document needs to be printed;
s264: selecting a summary sheet to print: a balance list of subjects or a summary list of credentials.
8. The method of claim 4, wherein when printing the book in step S26, if a plurality of users send a plurality of book print requests, a plurality of book print request tasks are sequentially stored in the message middleware and then the task sequence in the message middleware is extracted to the thread pool, thereby implementing asynchronous parallel processing of the plurality of book print request tasks,
and after the account book printing request task is processed, prompting that the account book is automatically generated in a short message or system message mode.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911153385.4A CN111046647B (en) | 2019-11-22 | 2019-11-22 | Automatic typesetting method and automatic accounting book generation method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911153385.4A CN111046647B (en) | 2019-11-22 | 2019-11-22 | Automatic typesetting method and automatic accounting book generation method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111046647A true CN111046647A (en) | 2020-04-21 |
| CN111046647B CN111046647B (en) | 2023-04-07 |
Family
ID=70232046
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911153385.4A Active CN111046647B (en) | 2019-11-22 | 2019-11-22 | Automatic typesetting method and automatic accounting book generation method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111046647B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111591061A (en) * | 2020-05-14 | 2020-08-28 | 远光软件股份有限公司 | Accounting document prints system of filing |
| CN112800726A (en) * | 2020-10-09 | 2021-05-14 | 上海天庸科技发展有限公司 | Information carrier book, generation code, device and processing equipment |
| CN113554009A (en) * | 2021-09-22 | 2021-10-26 | 北京奇虎科技有限公司 | Bill verification method, device, equipment and storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2002032520A1 (en) * | 2000-10-16 | 2002-04-25 | International Game Technology | Method and apparatus for ticket generation and accounting |
| CN101447017A (en) * | 2008-11-27 | 2009-06-03 | 浙江工业大学 | Method and system for quickly identifying and counting votes on the basis of layout analysis |
| CN109325842A (en) * | 2018-10-18 | 2019-02-12 | 杭州雅张科技有限公司 | Financial management system |
-
2019
- 2019-11-22 CN CN201911153385.4A patent/CN111046647B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2002032520A1 (en) * | 2000-10-16 | 2002-04-25 | International Game Technology | Method and apparatus for ticket generation and accounting |
| CN101447017A (en) * | 2008-11-27 | 2009-06-03 | 浙江工业大学 | Method and system for quickly identifying and counting votes on the basis of layout analysis |
| CN109325842A (en) * | 2018-10-18 | 2019-02-12 | 杭州雅张科技有限公司 | Financial management system |
Non-Patent Citations (1)
| Title |
|---|
| 吕志明: "会计软件自动转账功能分析", 《财会月刊》 * |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111591061A (en) * | 2020-05-14 | 2020-08-28 | 远光软件股份有限公司 | Accounting document prints system of filing |
| CN111591061B (en) * | 2020-05-14 | 2021-07-13 | 远光软件股份有限公司 | Accounting document prints system of filing |
| CN112800726A (en) * | 2020-10-09 | 2021-05-14 | 上海天庸科技发展有限公司 | Information carrier book, generation code, device and processing equipment |
| CN113554009A (en) * | 2021-09-22 | 2021-10-26 | 北京奇虎科技有限公司 | Bill verification method, device, equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111046647B (en) | 2023-04-07 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111046647B (en) | Automatic typesetting method and automatic accounting book generation method | |
| US7853494B2 (en) | Efficient work flow system and method for preparing tax returns | |
| JP6307693B2 (en) | Accounting system | |
| US10049410B2 (en) | Receipts scanner and financial organizer | |
| US8442881B2 (en) | Systems and methods of processing and classifying a financial transaction | |
| US9916606B2 (en) | System and method for processing a transaction document including one or more financial transaction entries | |
| CN1873706A (en) | System for making out invoices for tax receipt of deducting tax automatically, and application method | |
| JP2014206960A (en) | Book creation system, method and program and printed voucher | |
| CN111199222B (en) | Bill management method and electronic equipment | |
| US20140198969A1 (en) | Device and Method for Contribution Accounting | |
| CN110363097A (en) | Enterprise's portrait generation method and device based on financial statement | |
| CN105825425A (en) | Financial data processing method applied to ameba management depositing and withdrawing style | |
| CN102044091A (en) | Self-service ticketing system | |
| CN112801041A (en) | Financial data reimbursement method, device, equipment and storage medium | |
| EP3086271A1 (en) | Method and computer system for automatic handling and payment of invoices | |
| WO2019146118A1 (en) | Accounting processing device, accounting processing system, accounting processing method, and accounting processing program | |
| JP6151560B2 (en) | Accounting book information processing apparatus, accounting book information processing apparatus control method, accounting book processing apparatus program, and recording medium | |
| CN101261720A (en) | Comprehensive method for improving the bank work efficiency with computer | |
| CN110750302A (en) | Accounting production line accounting method for accounting | |
| JP6266154B1 (en) | Storage business support system | |
| CN201820269U (en) | Self-service ticket selling system | |
| KR100960297B1 (en) | Accounting method having a function for automatic classification, and computer readable media storing program for method thereof | |
| KR20100082057A (en) | Double entry book keeping method and system | |
| CN112735055A (en) | Invoice prereviewing and collecting system | |
| CN117273973A (en) | System depreciation method suitable for current month lifting of foreign assets |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |