Invoicing, accounting and tax declaration method and system for supply chain

Abstract

The invention relates to the technical field of data processing, in particular to an invoicing, accounting and tax declaration method and system for a supply chain, and the method comprises the following steps: obtaining original data, including purchase order, customs declaration and invoice information, generated in each business link of the supply chain, and synchronizing the original data to a financial data center through a system interface for standardization processing; classifying the standardized data based on a preset rule, generating a to-be-processed receivable bill and a to-be-processed payable bill, and associating corresponding business records; comparing the purchase order, the acceptance record and the invoice information, generating an account checking difference report, and pushing the account checking difference report to a related service terminal; updating the account period state according to the account checking result; extracting tax refund elements in the customs declaration, generating a tax refund application, and tracking an auditing progress until the tax refund application arrives at an account and is filed; the method automatically synchronizes data of links such as customs affair and storage through a system interface and performs standardization processing, solves the problem of lagging of manual data collection, and improves the data synchronization efficiency.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of data processing, and in particular to a method and system for invoicing, accounting and tax reporting of a supply chain. BACKGROUND

[0002] In traditional supply chain management, the invoicing, accounting and tax reporting processes often rely on manual operation. Financial personnel need to manually collect data from customs, warehousing and other links to generate reconciliation statements, then manually match invoice information, complete the accounting, and separately organize tax reporting materials. The whole process is time-consuming and labor-intensive, and lacks data linkage. There are problems such as data transmission lag, error-prone and low efficiency. SUMMARY

[0003] The present application provides a method and system for invoicing, accounting and tax reporting of a supply chain, which solves the problem of data transmission lag, error-prone and low efficiency in traditional supply chain management.

[0004] To achieve the above-mentioned purpose, the present application provides a method for invoicing, accounting and tax reporting of a supply chain, comprising the following steps:

[0005] Obtain the original data generated by each business link of the supply chain, including purchase orders, customs declarations, and invoice information, and synchronize them to the financial data center through system interfaces for standardized processing;

[0006] Classify the standardized data based on preset rules, generate the to-be-processed receivables and payables statements, and associate the corresponding business records;

[0007] Compare the purchase orders, inspection records and invoice information, generate an account reconciliation difference report and push it to the relevant business terminal;

[0008] Update the account period status according to the reconciliation results;

[0009] Extract the tax refund elements from the customs declaration, generate a tax refund application and track the audit progress until the account is archived.

[0010] The method further comprises:

[0011] After the statement is checked and found to be correct, the invoice issuing process is performed, and the customer tax information and order details are filled in;

[0012] Generate an electronic invoice PDF by interfacing with a tax control device, and synchronize and push it to the customer terminal and the financial data center;

[0013] After the payment is confirmed, the invoice is automatically cancelled, and the account period status is updated to "completed".

[0014] The "obtaining original data generated by each business link of the supply chain, including purchase orders, customs declaration forms, and invoice information, and synchronizing the data to a financial data center for standardized processing" specifically includes:

[0015] Invoice information is recognized by OCR technology, and fields such as supplier name, tax number, and amount are extracted and matched with purchase orders;

[0016] According to the export date and commodity code in the customs declaration form, the dynamically updated tax refund rate database of the General Administration of Customs is called to calculate the tax refund rate and the refundable amount, and the calculation result is associated with the unique identifier of the corresponding invoice through the hash algorithm;

[0017] The material procurement data is converted into accounts payable subjects according to the preset accounting subject mapping rules, and standardized accounting vouchers containing debit and credit subjects, amounts, and summaries are automatically generated, and the balance relationship of the vouchers is synchronously verified;

[0018] The step-by-step unit price data in the purchase order is structured, and the price mapping table is generated according to the minimum / maximum order quantity interval, and the payable amount is updated after matching with the actual transaction quantity in the customs declaration form;

[0019] Logical verification is performed on the synchronized customs declaration form amount and purchase order amount;

[0020] The unstructured acceptance records are converted into a unified XML format using ETL tools, and the repeated fields are removed through data cleaning rules, and a three-dimensional association index is established with the purchase order and invoice.

[0021] The "classifying the standardized data based on preset rules, generating the to-be-processed accounts receivable and accounts payable, and associating the corresponding business records" specifically includes:

[0022] According to the customs declaration form clearance date, the accounts receivable are collected, the account period list is generated, and the intervals of "0-30 days" and "31-60 days" are divided;

[0023] The accounts receivable details are calculated based on the customs declaration form, and the customer order number, material code, and invoicing status are associated;

[0024] The due date of accounts payable is automatically generated based on the settlement account period preset by the supplier management module.

[0025] The "comparing the purchase order, acceptance record, and invoice information, generating an account reconciliation difference report, and pushing it to the relevant business terminal" specifically includes:

[0026] The consistency of the purchase order number, material quantity, and unit price with the acceptance order and invoice is verified;

[0027] The records of the matching failure are classified and reported according to the quantity difference and the amount difference, and are pushed to the procurement terminal for review;

[0028] The bill is marked as "checked" after review, and the invoice issuing or payment process is performed.

[0029] The "updating the account period state according to the account result" specifically includes:

[0030] After the account checking is correct, the invoice issuing time, number and the like are automatically generated and associated to the receivable account bill.

[0031] The overdue account for more than 15 days is marked as "high risk", and an early warning is pushed to the terminal of the business person in charge.

[0032] The "extracting the tax refund elements in the customs declaration form, generating a tax refund application and tracking the audit progress until the account is archived" specifically includes:

[0033] The invoices meeting the tax refund conditions are selected from the bill list, and the customs declaration form details, input invoice and the like are extracted;

[0034] The tax refund application form is generated according to the tax audit requirements, and sequentially passes through the data audit, internal audit and tax audit links;

[0035] The tax refund account is tracked, and the amount and date are recorded after the account, and the customs declaration form, invoice and the like are electronically archived.

[0036] The application further includes a billing, accounting and tax reporting system of a supply chain, used to execute the billing, accounting and tax reporting method of the supply chain.

[0037] The billing, accounting and tax reporting method and system of the supply chain of the application automatically synchronizes the procurement order, customs declaration form and the like through the system interface and standardizes the processing, solves the lag problem of traditional manual data collection, realizes efficient data integration by means of the OCR technology and the ETL tool, makes the data synchronization efficiency improve by more than 60% and the error rate reduce to below 0.5%; the receivable / payable bill is automatically generated based on the preset rules and is associated with the business record, replaces the manual generation of the account checking bill, automatically collects the account period in combination with the customs declaration form clearance date and the supplier settlement account period; the three bills are automatically compared to generate a classified difference report and are pushed for review, to avoid the invoice matching error of manual work; the invoice issuing and cancellation process is automatically triggered after the account checking is correct, the electronic invoice is generated by connecting the tax control equipment and is synchronously pushed, to realize the billing and accounting automation; the tax refund elements are extracted to generate an application and are tracked to archive, to save the manual tax data processing process, and the whole-process data linkage reduces the error rate and improves the overall efficiency. BRIEF DESCRIPTION OF DRAWINGS

[0038] In order to more clearly illustrate the technical solutions in the embodiments of the present application or the prior art, the accompanying drawings needed to be used in the description of the embodiments or the prior art will be briefly introduced.

[0039] Figure 1 is a flow chart of the invoicing, accounting and tax reporting method of the supply chain of the present application. DETAILED DESCRIPTION

[0040] The embodiments of the present application will be described in detail below, examples of which are shown in the accompanying drawings, the embodiments described below by referring to the accompanying drawings are exemplary and are intended to explain the present application, and cannot be understood as a limitation of the present application.

[0041] The present application provides an invoicing, accounting and tax reporting method of a supply chain, comprising the following steps:

[0042] S101: Obtain the original data generated by each business link of the supply chain, including purchase orders, customs declaration forms and invoice information, and synchronize them to the financial data center for standardized processing through system interfaces.

[0043] Specifically: recognize the invoice face information through OCR technology, extract the fields of supplier name, tax number and amount, and match them with the purchase order; according to the export date and commodity code in the customs declaration form, retrieve the dynamically updated tax refund rate database of the General Administration of Customs, calculate the tax refund rate and refundable amount, and associate the calculation results with the unique identifier of the corresponding bill through the hash algorithm; convert the material procurement data into accounts payable subjects according to the preset accounting subject mapping rules, automatically generate standardized accounting vouchers containing debit and credit subjects, amounts and summaries, and synchronize to check the balance relationship of the vouchers; structure the step-by-step unit price data in the purchase order, generate a price mapping table according to the minimum / maximum order quantity interval, and update the payable amount after matching with the actual transaction quantity in the customs declaration form; logically check the customs declaration form amount and the purchase order amount; use ETL tools to convert unstructured acceptance records into a unified XML format, remove duplicate fields through data cleaning rules, and establish a three-dimensional association index with the purchase order and the invoice.

[0044] In the embodiments of the present application, the customer purchase order (including order number, material details, purchase quantity, and expected delivery date) and the supplier purchase order (purchased material, supplier information, and settlement account period) of the commercial procurement ordering module are synchronized in real time through the API interface; the supplier name, tax number, invoice amount, material details, and invoice date are extracted by scanning paper invoices or analyzing electronic invoice PDFs through OCR, and the material code and quantity in the purchase order are automatically matched; the electronic data of the customs declaration form is obtained, including the customs declaration number, export date, commodity code, customs declaration amount, and declaration elements; the OCR recognition result and the purchase order are double-checked (order number + material code), and if the matching fails, it is marked as abnormal and pushed to the financial terminal for manual review; the commodity code of the customs declaration form is used to call the Customs General Administration tax rebate rate interface, the corresponding tax rebate rate version is matched according to the export date, the refundable amount = customs declaration amount x tax rebate rate is calculated, the refundable amount and the unique identifier of the customs declaration form (customs declaration number + declaration date) are bound through the SHA-256 hashing algorithm, and the non-tamperable check code is generated; a preset material category-account subject mapping table (such as raw material procurement → “accounts payable-materials”, equipment procurement → “fixed assets”) is used to automatically generate accounting vouchers, and the balance between debit and credit is checked in real time after the voucher is generated (the total amount of debit = the total amount of credit); the step price interval in the purchase order (such as “1-100 pieces at 10 yuan each, 101-500 pieces at 8 yuan each”) is analyzed to generate a quantity-price mapping table; the corresponding unit price is matched according to the actual transaction quantity of the customs declaration form, and the amount payable is automatically updated; an ETL tool is used to convert the acceptance sheet (Excel / paper) of the warehouse module into XML format, and duplicate records (such as the same material being stored multiple times) are cleaned up; a three-dimensional index of “purchase order number + invoice number + material code” is established to associate the purchase order, invoice, and acceptance sheet data.

[0045] S102: Classify the standardized data based on preset rules to generate the to-be-processed accounts receivable and accounts payable, and associate the corresponding business records.

[0046] Specifically: The accounts receivable are collected according to the customs declaration clearance date, an account period list is generated and divided into “0-30 days”, “31-60 days”, etc.; the accounts receivable details are counted based on the customs declaration form, and the customer order number, material code, and invoicing status are associated; the accounts payable due date is automatically generated based on the settlement account period preset by the supplier management module.

[0047] In the embodiment of the application, the starting date of the accounting period is calculated according to the customs declaration date, and is automatically classified into the "0-30 days", "31-60 days", "61-90 days" and "more than 90 days" intervals; the customer order number, material code, invoicing status, receivable amount and other information are aggregated based on the customs declaration, a standardized receivable account is generated, the settlement period and transaction conditions of the customer management module are associated, and special accounts (such as prepayment accounts and installment payment accounts) are marked; based on the settlement rules (such as "pay within 30 days of delivery" and "pay within 60 days of invoicing") preset by the supplier management module, the payable due date is calculated in combination with the acceptance date / invoice date; the payable account matched with the invoice is marked as "to be paid", the account not matched with the invoice is marked as "abnormal" and pushed to the procurement department for verification, and the supplier's advance payment order is marked as "advance payment account" and associated with the advance payment agreement number.

[0048] S103: Comparing the purchase order, acceptance record and invoice information, generating an account reconciliation difference report and pushing it to the relevant business terminal.

[0049] Specifically, the consistency of the purchase order number, material quantity and unit price with the acceptance sheet and invoice is verified; a classification report is generated for the records that fail to match in terms of "quantity difference" and "amount difference", and is pushed to the procurement terminal for review; after the review, the account is marked as "checked" and the invoice is issued or the payment process is performed.

[0050] In the embodiment of the application, the consistency of the material code, quantity and delivery date is verified; the consistency of the supplier name, tax number, material details and amount is verified, and a ±3% amount difference is allowed to pass automatically; the difference classification standards are: quantity difference: acceptance quantity and order quantity deviation > 5%, amount difference: invoice amount and order amount deviation > 3%, logical difference: invoice tax number and supplier registered tax number inconsistency, material code mapping error, etc.; a classification report (including difference items, impact amount and recommended solutions) is generated for the differences exceeding the threshold, which is pushed to the procurement terminal for review, and the account that passes the review is automatically marked as "checked", triggering the invoice issuance (receivable) or payment application (payable) process, and the account that does not pass the review is frozen for related operations until the difference is resolved (such as modifying the order or reissuing the invoice).

[0051] S104: Updating the accounting period status according to the account reconciliation result.

[0052] Specifically, after the account is checked without error, the invoice issuance time and number are automatically generated and associated with the receivable account; overdue accounts for more than 15 days are marked as "high risk" and pushed to the business manager terminal for warning.

[0053] In the embodiment of the present application, after the bill is checked, the invoice issuing time, number, type and other information are generated and associated to the receivable account bill; 5 days before the due date, the repayment reminder is sent to the terminal of the business manager (system message + email); 15 days after the due date, the overdue amount is marked as "high risk", and when the payable amount is greater than 20% of the receivable amount in the future 30 days, the fund scheduling suggestion (such as advance repayment, application for short-term financing) is generated and pushed to the terminal of the financial supervisor.

[0054] S105: Extract the tax refund elements in the customs declaration form, generate a tax refund application and track the audit progress until the account is archived.

[0055] Specifically: filter the invoices meeting the tax refund conditions from the bill list, extract the customs declaration form details, input invoice and other data; generate a tax refund application form according to the tax audit requirements, and go through the data audit, internal audit and tax audit links in turn; track the tax refund account status, record the amount and date after the account is received, and electronically archive the customs declaration form, invoice and other data.

[0056] In the embodiment of the present application, the invoices meeting the tax refund conditions (export trade mode, commodity code in the tax refund directory) are filtered, the customs declaration form details, input invoice and other data are extracted, the consistency of the commodity name, quantity and amount of the invoice and the customs declaration form is verified (allowing ±5% difference); a tax refund application form is generated according to the tax audit requirements, including electronic attachments such as customs declaration form, invoice, contract, packing list, filling in fields such as declaration date, tax refund amount and tax refund rate; the financial personnel can view the data integrity online (such as whether the input invoice deduction link is missing), interface with the electronic tax bureau API to obtain the audit status (in process / correction / pass) in real time, and if correction is encountered, the correction data is pushed to the responsible department; the bank account notice is matched with the tax refund application form (amount + tax refund number), the account date and amount are recorded, and the accounting voucher (debit: bank deposit, credit: receivable export tax refund) is generated; within 15 working days after the tax refund is completed, all data (customs declaration form, invoice, audit record, etc.) are packaged and archived according to the "customer + customs declaration form" dimension.

[0057] S106: After the bill is checked, the invoice issuing process is performed, and the customer tax information and order details are filled in.

[0058] S107: Interface with the tax control equipment to generate an electronic invoice PDF, and synchronously push it to the customer terminal and financial data center.

[0059] In the embodiment of the present application, after the receivable account bill is checked, the invoice application is performed, the customer tax information (name, tax number, address and phone number) and order details are extracted, the invoice content (commodity name, specification, quantity, unit price) is generated according to the tax control requirements, the tax amount (distinguish general invoice / special invoice tax rate) is calculated, the total amount of price and tax is generated, the electronic invoice PDF is generated by interfacing with the tax control equipment, and is synchronously pushed to the customer mailbox and system message center.

[0060] S108: After the collection is confirmed, the invoice is automatically cancelled, and the account period status is updated to "completed".

[0061] In the embodiment of the present application, the bank interface is used to synchronize the bank flow data in real time, automatically extract the information such as the collection amount, the payer name, and the transaction date, and match the information to the corresponding customer's receivable account. The matching rule is verified according to the "customer name + collection amount + account period" in priority, and if the matching is successful, it is marked as "to be cancelled". When the collection amount is completely consistent with the invoice amount, the invoice status is marked as "cancelled", and the "collection date" and "collection amount" fields of the corresponding receivable account are updated synchronously. After the cancellation is completed, the status of the receivable account is updated to "completed", and the related process entrances such as the invoicing and payment of the account are closed to avoid repeated operations.

[0062] The present application also includes a supply chain invoicing, accounting and tax reporting system for executing the supply chain invoicing, accounting and tax reporting method.

[0063] The above only discloses one or more preferred embodiments of the present application, and cannot limit the scope of the rights of the present application. Those skilled in the art can understand that all or part of the above-mentioned embodiments can be implemented, and equivalent changes made according to the claims of the present application still belong to the scope covered by the present application.

Claims

1. A method of invoicing, accounting and tax filing for a supply chain, characterized by, The method comprises the following steps: Obtaining raw data generated by each business link of the supply chain, including purchase orders, customs declaration forms, and invoice information, synchronizing the raw data to a financial data center through a system interface for standardized processing; Classifying the standardized data based on preset rules to generate to-be-processed accounts receivable and accounts payable, and associating corresponding business records; Comparing the purchase orders, inspection records, and invoice information to generate an account reconciliation difference report and push the report to relevant business terminals; Updating the account period status according to the account reconciliation result; Extracting the tax refund elements in the customs declaration form to generate a tax refund application and track the audit progress until the tax refund is credited and archived.

2. The method of invoicing, accounting and tax filing of the supply chain as claimed in claim 1, wherein, The method further comprises: After the accounts are checked and no errors are found, an invoice issuing process is performed, and customer tax information and order details are filled in; Connecting a tax control device to generate an electronic invoice PDF and synchronously pushing the PDF to a customer terminal and a financial data center; After the payment is confirmed, the invoice is automatically cancelled, and the account period status is updated to "completed".

3. The invoice issuing, accounting, and tax filing method for the supply chain according to claim 2, wherein The "obtaining raw data generated by each business link of the supply chain, including purchase orders, customs declaration forms, and invoice information, synchronizing the raw data to a financial data center through a system interface for standardized processing" specifically comprises: Recognizing the information on the invoice surface through OCR technology, extracting the supplier name, tax number, and amount fields, and matching them with the purchase orders; According to the export date and commodity code in the customs declaration form, the tax refund rate database dynamically updated by the General Administration of Customs is called to calculate the tax refund rate and the refundable amount, and the calculation result is associated with the unique identifier of the corresponding account through a hash algorithm; Converting the material procurement data into accounts payable subjects according to the preset accounting subject mapping rules to automatically generate standardized accounting vouchers containing the debit and credit subjects, amounts, and summaries, and synchronously verifying the debit and credit balance relationship of the vouchers; Structurally processing the step-by-step unit price data in the purchase order, generating a price mapping table according to the minimum / maximum order quantity interval, and updating the payable amount after matching the actual transaction quantity in the customs declaration form; Logically verifying the customs declaration form amount and the purchase order amount; Using an ETL tool to convert unstructured inspection records into a unified XML format, removing duplicate fields through data cleaning rules, and establishing a three-dimensional association index with the purchase orders and invoices.

4. The method of invoicing, accounting and tax filing of the supply chain as claimed in claim 2, wherein, The "classifying the standardized data based on preset rules to generate to-be-processed accounts receivable and accounts payable, and associating corresponding business records" specifically comprises: Collecting accounts receivable according to the customs declaration form clearance date, generating an account period list, and dividing it into "0-30 days", "31-60 days", and other intervals; Statistically analyzing the accounts receivable details based on the customs declaration form, associating the customer order number, material code, and invoice issuing status; Automatically generating the accounts payable due date based on the preset settlement account period of the supplier management module.

5. The method of invoicing, accounting and tax filing of the supply chain as claimed in claim 3, wherein, The "comparing the purchase orders, inspection records, and invoice information to generate an account reconciliation difference report and push the report to relevant business terminals" specifically comprises: Verifying the consistency of the purchase order number, material quantity, unit price, inspection record, and invoice; Generating a classification report for the records that fail to match according to "quantity difference" and "amount difference", and pushing the report to the procurement terminal for review; The checked bill is marked as "checked" and the invoice issuing or payment process is carried out.

6. The method of invoicing, accounting and tax filing of the supply chain as claimed in claim 4, wherein, The "updating the period state according to the checking result" specifically includes: After the bill checking, the information such as the invoice issuing time and number is automatically generated and associated to the receivable bill; The overdue accounts for 15 days are marked as "high risk" and the warning is pushed to the terminal of the business manager.

7. The method of invoicing, accounting and tax filing of the supply chain as claimed in claim 5, wherein, The "extracting the tax refund elements in the customs declaration form, generating the tax refund application and tracking the audit progress until the account is archived" specifically includes: The invoices meeting the tax refund conditions are filtered from the bill list, and the customs declaration form details, input invoice and other data are extracted; The tax refund application is generated according to the tax audit requirements, and the application sequentially goes through the data audit, internal audit and tax audit; The tax refund account is tracked, and after the account, the amount and date are recorded, and the customs declaration form, invoice and other data are electronically archived.

8. A system for invoicing, accounting and tax filing of a supply chain, characterized by, The method for performing the invoicing, accounting and tax filing of the supply chain as claimed in any one of claims 1-7.

Images