Monitoring system for financial internal examination

Abstract

The invention discloses a monitoring system for financial internal examination, and relates to the technical field of financial detection, and the system comprises the following steps: S100, logging in, and inputting related data; step S200, scoring the input data; step S300, obtaining scores, analyzing reasons, and performing internal analysis on unsatisfactory products; step S400, performing feedback on the reason; according to the method, the score and the corresponding rating are obtained by comparing and analyzing each piece of data, time can be well saved for financial staff, and time can be saved for correction of the financial staff by analyzing data which do not meet requirements.

Description

Technical Field

[0001] The present invention relates to the technical field of financial detection, in particular to a monitoring system for financial internal auditing. Background Art

[0002] Finance broadly refers to both financial activities and financial relationships. The former refers to the activities involving funds in the production process of an enterprise, reflecting the formal characteristics of finance; the latter refers to the economic relationships between the enterprise and various parties involved in financial activities, revealing the essence of finance. Therefore, in summary, corporate finance is the movement of funds in the enterprise's reproduction process, reflecting the economic relationships between the enterprise and various parties. Finance is not only the objective movement of funds in the reproduction of material resources by various departments and units of the national economy and the economic relationships reflected in this movement of funds, but more importantly, it is about property and debt, that is, assets and liabilities.

[0003] At present, financial personnel check the data and then summarize it. This is not only labor-intensive but also prone to errors in the second phase. In addition, with the existing financial data comparison system, after the comparison, financial personnel do not know whether the overall data meets the requirements, and personnel participation is also required. Summary of the Invention

[0004] The purpose of the present invention is to provide a monitoring system for financial internal auditing to solve the problems raised in the above background technology.

[0005] In order to solve the above technical problems, the present invention provides the following technical solution: a monitoring system for financial internal audit, comprising the following steps:

[0006] Step S100: Log in first, then input relevant data;

[0007] Step S200: scoring the input data;

[0008] Step S300: Obtain scores, analyze reasons, and conduct internal analysis for those that do not meet the requirements;

[0009] Step S400: Provide feedback on the reason.

[0010] As a preferred solution of the monitoring system for financial internal audit of the present invention, in step S100, the relevant data is first input into the sum.xlsx table, and then the entire sum.xlsx table is input therein.

[0011] As a preferred solution of the monitoring system for financial internal audit of the present invention, in step S100, the score column items of each row in the sum.xlsx table include 36 items, each with 10 points.

[0012] As a preferred solution of the monitoring system for financial internal audit of the present invention, the 36 items include accounts receivable, other accounts receivable, prepaid accounts, financial expenses, administrative expenses, sales expenses, prepaid accounts, general taxpayers of inventory, small-scale inventory, taxes payable, the income amounts of the four statements in each quarter should be consistent, the ratio of the cost amount of the natural person's agency to the total cost amount, the taxes payable-input tax amount line, the taxes payable-output tax amount line, the trading enterprises are outside the line at both ends, the purchase and sales mismatch line, sales without progress and invoice cancellation / redemption, etc.

[0013] As a preferred solution of the monitoring system for financial internal audit of the present invention, the rating is performed according to the range of the total values ​​in the sum.xlsx table, and the specific rating rules are: 350-330 points A+ / 330-320 points A / 310-280 points B / 280-240C / 240-0 points D.

[0014] As a preferred solution of the monitoring system for financial internal audit of the present invention, the ratings C and D do not meet the requirements.

[0015] As a preferred solution of the monitoring system for financial internal audit of the present invention, in step S400, the reasons for the analysis are fed back to the customer and the system for storage and display.

[0016] As a preferred solution of the monitoring system for financial internal audit of the present invention, the stored reasons increase the analysis capability of the system itself.

[0017] Compared with the existing technology, the beneficial effects achieved by the present invention are: by comparing and analyzing each data, obtaining scores and corresponding ratings, it can save time for financial personnel, and by analyzing data that does not meet the requirements, it can save time for financial personnel to correct them. BRIEF DESCRIPTION OF THE DRAWINGS

[0018] The accompanying drawings are used to provide a further understanding of the present invention and constitute a part of the specification. Together with the embodiments of the present invention, they are used to explain the present invention and do not constitute a limitation of the present invention. In the accompanying drawings:

[0019] Figure 1 This is a flow chart of a monitoring system for financial internal auditing according to the patent of the present invention. DETAILED DESCRIPTION

[0020] The following will clearly and completely describe the technical solutions in the embodiments of the present invention in conjunction with the accompanying drawings. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without making creative efforts are within the scope of protection of the present invention.

[0021] See also Figure 1 The present invention provides a technical solution: a monitoring system for financial internal audit, comprising the following steps:

[0022] Step S100: First log in with your account, then enter the relevant data, first into the sum.xlsx table, then enter the entire sum.xlsx table. The score columns for each row in the sum.xlsx table include 36 items, each with 10 points. Rating is performed based on the range of the total values ​​in the sum.xlsx table. The specific rating rules are: 350-330 points A+ / 330-320 points A / 310-280 points B / 280-240 C / 240-0 points D. Ratings C and D do not meet the requirements.

[0023] Description of the logical relationship between the score columns in each row of the sum.xlsx table

[0024] This table has 4 columns in total, and the last row is the total value of the score column.

[0025] 1. Under the Accounts Receivable (Pending Accounts) column, divide the following lines:

[0026] Path:\Cumulative Years\Chronological Account.xlsx

[0027] Retrieve the fixed vouchers of the fixed date in the table, and then retrieve the row with "Accounts Receivable" in the "Account Name" column of the current row and the debit amount column of the row is not empty. If the voucher contains "Main Business Income", it will be scored 10 points, otherwise it will be scored 6 points, and the negative results will be marked in yellow.

[0028] 2. Under the Accounts Receivable (Lower Account) column, divide the following lines:

[0029] Path:\Cumulative Years\Chronological Account.xlsx

[0030] Search for fixed vouchers with fixed dates in this table. Then search for rows with "Accounts Receivable" in the "Account Name" column of the current row, and the credit amount column of this row is not empty. If the voucher contains "Bank Deposit" or "Cash on Hand" or "Other Payables", 10 points will be awarded. Otherwise, 6 points will be awarded. The negative results will be marked in yellow.

[0031] 3. Under the Account Column - Other Receivables (Pending Accounts), divide the following lines:

[0032] Path:\Cumulative Years\Chronological Account.xlsx

[0033] Search for fixed vouchers with fixed dates in this table. Then search for rows with "Other Receivables" in the "Account Name" column of the current row, and the debit amount column of that row is not empty. If the voucher contains "Bank Deposit" or "Cash on Hand," 10 points will be awarded. Otherwise, 6 points will be awarded; any negative results will be marked in yellow.

[0034] 4. Under the Account Column - Other Receivables (Download), divide the following lines:

[0035] Path:\Cumulative Years\Chronological Account.xlsx

[0036] Search the "Summary" column of the table and find words such as "repayment", "reimbursement", or "collection", or search the row containing "other receivables" in the "Account Name" column of the current row. If the previous row contains "bank deposits" or "cash on hand" or "expenses" or "other payables" or "main business cost", 10 points will be awarded, otherwise 6 points will be awarded; and the negative results will be marked in yellow.

[0037] 5. Under the Account Column - Prepayments (on hold) row, divide the rows into:

[0038] Path:\Cumulative Years\Chronological Account.xlsx

[0039] Searching the "Summary" column of this table and finding words such as "Prepayment," "Payment," or "Payment," or searching for a row with "Prepayments" in the "Account Name" column of the current row, and the next row containing "Bank Deposits" or "Cash on Hand," will give 10 points; otherwise, 6 points will be given. Negative results will be marked in yellow.

[0040] 6. Under the Account Column - Prepaid Accounts (Download), divide the following lines:

[0041] Path:\Cumulative Years\Chronological Account.xlsx

[0042] Searching the "Summary" column of this table and finding words such as "Income," "Cost," or "Inventory," or searching for a row containing "Prepayments" in the "Account Name" column of the current row, and the previous row containing "Inventory," "Cost of Main Business," "Taxes Payable," or "Bank Deposits," will earn 10 points; otherwise, 6 points will be awarded. Negative results will be marked in yellow.

[0043] 7. Under the Accounts Payable (Pending Accounts) column, divide the following lines:

[0044] Path:\Cumulative Years\Chronological Account.xlsx

[0045] Searching the "Summary" column of this table and finding words such as "purchase," "purchase," "procurement," or "cost," or searching for a row containing "accounts payable" in the "Account Name" column of the current row, and the previous row containing "inventory," "main business cost," or "taxes payable," will earn 10 points. Otherwise, earn 6 points. Negative results will be marked in yellow.

[0046] 8. Under the Accounts Payable (Download) column, divide the following lines:

[0047] Path:\Cumulative Years\Chronological Account.xlsx

[0048] Searching the "Summary" column of this table and finding words such as "Payment" or "Pay" or searching for a row containing "Accounts Payable" in the "Account Name" column of the current row, and the next row containing "Bank Deposits" or "Cash on Hand," "Other Payables," or "Other Receivables," will earn 10 points. Otherwise, earn 6 points. Negative results will be highlighted in yellow.

[0049] 9. Under the Account Column - Other Payables (Pending Accounts), divide the following lines:

[0050] Path:\Cumulative Years\Chronological Account.xlsx

[0051] Search for words such as "Loans," "Collection," "Payment," or "Accounts Payable" in the "Summary" column of the table, or search for rows containing "Other Payables" in the "Account Name" column of the current row. If the previous row contains "Bank Deposits," "Cash on Hand," "Inventory," "Cost of Main Business," or "Taxes Payable," 10 points will be awarded. Otherwise, 6 points will be awarded. Negative results will be marked in yellow.

[0052] 10. Under Account Column - Other Payables (Download), divide the following lines:

[0053] Path:\Cumulative Years\Chronological Account.xlsx

[0054] Searching the "Summary" column of this table and finding words such as "Repayment," "Payment on Behalf," "Cost," or "Other Payables" in the "Account Name" column of the current row, and the next line containing "Bank Deposits" or "Cash on Hand," will give 10 points; otherwise, 6 points will be given. Negative results will be marked in yellow.

[0055] 11. Under the Account Column - Advance Received (Pending Account), divide the following lines:

[0056] Path:\Cumulative Years\Chronological Account.xlsx

[0057] Searching the "Summary" column of this table and finding words such as "Advance Received," "Payment," or "Received," or searching for a row containing "Advance Received" in the "Account Name" column of the current row, and the previous row containing "Bank Deposits" or "Cash on Hand," will give 10 points; otherwise, 6 points will be given. Negative results will be marked in yellow.

[0058] 12. Under the Account Column - Advance Received (Postal Account), divide the following lines:

[0059] Path:\Cumulative Years\Chronological Account.xlsx

[0060] Searching the "Summary" column of this table and finding words such as "sales," "payment," "return," or "returned goods," or searching for a row containing "advance payments" in the "Account Name" column of the current row, and the next row containing "main business income," "bank deposits," "cash on hand," or "other payables," will earn 10 points. Otherwise, 6 points will be awarded. Negative results will be marked in yellow.

[0061] 13. Account column - Financial expenses row: (If the voucher contains the current year profit account, the voucher will be skipped directly)

[0062] Path:\Cumulative Years\Chronological Account.xlsx

[0063] Search the "Summary" column of the table and find words such as "Handling Fee" or "Interest," or search for a row with "Financial Expenses" in the "Account Name" column of the current row. If the voucher contains "Bank Deposit," 10 points will be awarded. Otherwise, 6 points will be awarded. Negative results will be marked in yellow.

[0064] 14. Account column - Administrative expenses row: (If the voucher contains the current year profit account, the voucher will be skipped directly)

[0065] Path:\Cumulative Years\Chronological Account.xlsx

[0066] Searching the "Summary" column of this table and finding words such as "Expenses," "Wages," "Reimbursement," or "Benefits" in the "Account Name" column of the current row, or searching for a row containing "Administrative Expenses" and the next row containing "Bank Deposits," "Cash on Hand," "Other Payables," "Other Receivables," or "Employee Salaries Payable," will give 10 points. Otherwise, 6 points will be given. Negative results will be highlighted in yellow.

[0067] 15. Account column - Sales expense row: (If the voucher contains the current year profit account, the voucher will be skipped directly)

[0068] Path:\Cumulative Years\Chronological Account.xlsx

[0069] Searching the "Summary" column of this table and finding words such as "Expenses," "Reimbursement," or "Benefits," or searching for a row containing "Selling Expenses" in the "Account Name" column of the current row, and the next row containing "Bank Deposits," "Cash on Hand," "Other Payables," or "Other Receivables," will result in 10 points. Otherwise, 6 points will be awarded. Negative results will be highlighted in yellow.

[0070] 16. Accounts Receivable:

[0071] 1. Path:\Cumulative Years\Chronological Account.xlsx

[0072] 2. Path:\Analysis\Accounts Receivable Analysis Sheet.xlsx

[0073] Search the chronological account table under path (1) and filter the "Account Name" column for the names with 100% identical characters after "Accounts Receivable_" and the accumulated values ​​of "Credit Amount" and "Debit Amount" year by year. In the "Accounts Receivable Analysis Table" under path (2), sort the "Company Name" and "Credit Amount and Debit Amount" according to the time in path (1). Fill in the percentage column in the corresponding row with the percentage of credit amount divided by debit amount. Mark the percentage below 70% and above 100% in red. If there is a red mark in the table under path 2, 6 points will be awarded; otherwise, 10 points will be awarded.

[0074] 17. Account column - Prepaid accounts row is divided into:

[0075] 1. Path:\Cumulative Years\Chronological Account.xlsx

[0076] 2. Path:\Analysis\Prepaid Accounts Analysis Sheet.xlsx

[0077] Search the chronological account table under path (1) and filter the "Account Name" column for the names with 100% identical characters after "Prepaid Accounts_" and the accumulated values ​​of "Credit Amount" and "Debit Amount" year by year. In the "Prepaid Accounts Analysis Table" under path (2), sort the "Company Name" and "Credit Amount and Debit Amount" according to the time in path (1). Fill in the percentage column in the corresponding row with the percentage of credit amount divided by debit amount. Mark the percentage below 70% and above 100% in red. If there is a red mark in the table under path 2, 6 points will be awarded; otherwise, 10 points will be awarded.

[0078] 18. Account Column - Other Receivables:

[0079] 1. Path:\Cumulative Years\Chronological Account.xlsx

[0080] 2. Path:\Analysis\Other Accounts Receivable Analysis Sheet.xlsx

[0081] Search the chronological account table under path (1) and find the names with 100% identical characters after "Other Accounts Receivable_" in the "Account Name" column, and the cumulative values ​​of "Credit Amount" and "Debit Amount" year by year. In the "Other Accounts Receivable Analysis Table" under path (2), sort the "Company Name" and "Credit Amount and Debit Amount" according to the time in path (1). Fill in the percentage column in the corresponding row with the percentage of credit amount divided by debit amount. Mark the percentage below 70% and above 100% in red. If there is a red mark in the table under path 2, 6 points will be awarded; otherwise, 10 points will be awarded.

[0082] 19. Account column - Accounts payable row is divided into:

[0083] 1. Path:\Cumulative Years\Chronological Account.xlsx

[0084] 2. Path:\Analysis\Accounts Payable Analysis Sheet.xlsx

[0085] Search the chronological account table under path (1) and find the names with 100% identical characters after "Accounts Payable_" in the "Account Name" column, and the cumulative values ​​of "Credit Amount" and "Debit Amount" year by year. In the "Accounts Payable Analysis Table" under path (2), sort the "Company Name" and "Credit Amount and Debit Amount" according to the time in path (1). Fill in the percentage column in the corresponding row with the percentage of debit amount divided by credit amount. Mark the percentage below 70% and above 100% in red. If there are items marked in red in the table under path 2, score 6 points; otherwise, score 10 points.

[0086] 20. Account Column - Advance Received Row:

[0087] 1. Path:\Cumulative Years\Chronological Account.xlsx

[0088] 2. Path:\Analysis\Advance Receipt Analysis Sheet.xlsx

[0089] Search the "Account Name" column in the chronological account table under path (1) and find the names with 100% identical characters after "Advance Receipts_" and the accumulated values ​​of "Credit Amount" and "Debit Amount" year by year. In the "Advance Receipts Analysis Table" under path (2), sort the "Company Name" and "Credit Amount and Debit Amount" according to the time in path (1). Fill in the percentage column in the corresponding row with the percentage of debit amount divided by credit amount. Mark the percentage below 70% and above 100% in red. If there are items marked in red in the table under path 2, 6 points will be awarded; otherwise, 10 points will be awarded.

[0090] 21. Account column - Other payables row is divided into:

[0091] 1. Path:\Cumulative Years\Chronological Account.xlsx

[0092] 2. Path:\Analysis\Other Accounts Payable Analysis Sheet.xlsx

[0093] Search the "Account Name" column in the chronological account table under path (1) for the names with 100% identical characters after "Other Accounts Payable_" and the cumulative values ​​of "Credit Amount" and "Debit Amount" year by year. In the "Other Accounts Payable Analysis Table" under path (2), sort the "Company Name" and "Credit Amount and Debit Amount" according to the time in path (1). Fill in the percentage column in the corresponding row with the percentage of debit amount divided by credit amount. Mark the percentage below 70% and above 100% in red. If there are items marked in red in the table under path 2, 6 points will be awarded; otherwise, 10 points will be awarded.

[0094] 22. Account Column - Inventory General Taxpayer Line:

[0095] 1. Path:\Cumulative Years\Chronological Account.xlsx

[0096] 2. Path: \Tax Bureau\Input Details.xlsx

[0097] 3. Path:\Analysis\Inventory Accounting Analysis Table.xlsx

[0098] Search the chronological account table under path (1) and search the "Summary" column for all rows corresponding to the "Voucher Number" column in the order of year / month. Search for words such as "Purchase", "Purchase", or "Procurement" in the "Account Name" column of the corresponding row. Add up the debit amounts and fill in the amount column under path (3) local export. Then add up the debit amounts of all rows containing the words "Taxes Payable - VAT Payable - Input Tax Amount" and "Taxes Payable - Input Tax Amount to be Certified" in the account column of all rows corresponding to this voucher number. Fill in the tax amount column under path (3) local export. Add the values ​​of this row's amount column and tax amount column and fill in the price tax total column under path (3) local export. The second step is to search the input item detail table under path (2) and fill in the price tax total column under path (3) local export by adding up the values ​​of the "Price Tax Total" column in the order of year / month. Then compare the values ​​of the local exported price tax total column with the values ​​of the tax bureau exported price tax total column row by row, and fill the difference in the comparison into the corresponding difference column. The difference greater than or less than 0 is marked in red, and then all values ​​​​in the difference column are 0 and get 10 points, otherwise get 6 points.

[0099] 23. Account column - Inventory small scale line is divided into:

[0100] 1. Path:\Cumulative Years\Chronological Account.xlsx

[0101] 2. Path: \Tax Bureau\Input Details.xlsx

[0102] 3. Path:\Analysis\Inventory Accounting Analysis Table.xlsx

[0103] Search the chronological account table under path (1) and search the "Summary" column for all rows corresponding to the "Voucher Number" column in the order of year / month. Search for words such as "Purchase", "Purchase", or "Procurement" in the "Account Name" column of the corresponding row. Add the debit amounts and fill in the Amount column under the local export of path (3). Add the values ​​of the Amount column of this row and the Tax Amount column and fill in the Price and Tax Total column under the local export of path (3). The second step is to search the Input Item Details table under path (2) and fill in the Price and Tax Total column under the order of year / month. Then compare the values ​​of the Price and Tax Total column under the local export of path with the values ​​of the Price and Tax Total column under the tax bureau export of path (3). Fill in the difference in the difference column. If the difference is greater than or less than 0, mark it in red. If all the values ​​in the Difference column are 0, 10 points will be awarded. Otherwise, 6 points will be awarded.

[0104] 24. Account column - Taxes payable row: (Manually fill in according to the starting year and month of the chronological account)

[0105] 1. Path:\Cumulative Years\Chronological Account.xlsx

[0106] 2. Path:\Analysis\Taxes Payable Analysis Table.xlsx

[0107] Search the "Account Name" column in the chronological account table under the path (1) and filter "Taxes Payable_" by year / month. Then, fill in the corresponding credit amounts in the rows named "Stamp Duty", "Urban Maintenance and Construction Tax", "Education Surcharge", "Local Education Surcharge", "Enterprise Income Tax", "Taxes Paid", and "Unpaid Value Added Tax" in the "Account Set Export" column of the "Taxes Payable Analysis Table" under the path folder (2). Compare the values ​​in the actual payment column with the details in each row of the account set column (manually filled in in advance), and fill in the difference between the corresponding name columns in the difference column. If the difference is less than 100%, mark the details in the corresponding row in the account set export column in red. If the value of all difference columns is equal to 0, 10 points will be awarded. If it is less than or greater than 0, 6 points will be awarded.

[0108] 25. Account Column - The income amount of the four reports for each quarter should be consistent row by row: (After transferring the tables, make sure that all table extraction parameters are the same)

[0109] 1. Path:\Tax Bureau\B\Z\All Forms

[0110] 2. Path:\Tax Bureau\B\Q\All Forms

[0111] 3. Path:\Tax Bureau\B\Y\All Forms

[0112] 4. Path:\Tax Bureau\B\S\All Forms

[0113] After sorting all the tables under the search path (1) by year / month or quarter, if the file name under the path contains the word "month", fill in the numbers under the "this month's number" under the "general items" column in the 7th row of each table in the "VAT monthly" column under the 5th path, and add them up by calendar quarter and fill them in the "total 1" column. If the file name under the path contains the word "quarter", fill in the numbers in the 9th row - K to Q columns of each table in the "VAT quarterly" column under the 5th path.

[0114] After sorting all the tables under the search path (2) by year and quarter, fill in the numbers in the 21st row M to O columns of the table for the first quarter of the natural year into the "Income Tax" column under the 5th path. From the second quarter to the fourth quarter, subtract the numbers in the 21st row M to O columns from the previous quarter and fill in the corresponding quarterly rows (the second quarter value minus the first quarter, the third quarter minus the first and second quarters, the fourth quarter minus the third and second quarters).

[0115] After sorting all the tables under the search path (3) by year / month or quarter, if the file name under the path contains the word "month", fill in the values ​​in the 7th row-H column of each table into the "Sales Detail Analysis Table" and "Stamp Duty Monthly" columns under the 5th path, and add them up by calendar quarter and fill them into the "Total 2" column. If the file name under the path contains the word "quarter", fill in the numbers in the 7th row-H column of each table into the "Sales Detail Analysis Table" and "Stamp Duty Quarterly" columns under the 5th path.

[0116] After searching all tables under path (4) and sorting them by year / quarter, enter the values ​​in column F of row 7 of each table into the "Water Conservancy Construction Fund Quarterly" column of the "Sales Detail Analysis Table" under path 5. Compare the values ​​in "Total 1," "VAT Quarterly," "Income Tax," "Total 2," "Stamp Duty Quarterly," "Water Conservancy Construction Fund Quarterly," and "Total 3" based on the calendar quarter row. If they are different, mark them in red. If there are red marks in the table under path 5, score 6 points; otherwise, score 10 points.

[0117] 26. Account column - Percentage of cost of opening an account on behalf of a natural person to the total cost amount:

[0118] 1. Path: \Tax Bureau\Input Details.xlsx

[0119] 2. Path: \Analysis\Personal Agency Analysis Table.xlsx

[0120] Search the "Input Details Table" under path (1), and fill in the cumulative sum of the amounts in the "Total Price and Tax" column of all rows containing the word "Tax Bureau" in the "Seller Name" column in the amount column under path (2). Then fill in the total column under path (2) with the cumulative sum of the amounts in all rows of the "Total Price and Tax" column in the input details table under path (1). Fill in the percentage column by dividing the amount column by the total column. If it is greater than or equal to 26%, it will be marked in red and get 6 points, otherwise it will get 10 points.

[0121] 27. Account column - Taxes payable - Input tax row:

[0122] 1. Path:\Cumulative Years\Chronological Account.xlsx

[0123] 2. Path:\Analysis\Incoming Detail Analysis Table.xlsx

[0124] 3. Path: \Tax Bureau\Input Details List.xlsx

[0125] Search the chronological account table under the path (1), filter the "Taxes Payable_VAT Payable-Input Tax Amount" row in the "Account Name" column by year / month, and fill in the total debit amount corresponding to the year / month in the account set export column in the "Input Item Detail Analysis Table" under the path (2) file. Then, add the "Tax Amount Column" in the "Input Item Detail Table" under the path (3) file by year / month and fill it in the "Tax Bureau Export Column" in the "Input Item Detail Analysis Table" under the path (2). Compare the values ​​of each row of details, and fill in the difference column with the value obtained by subtracting the tax bureau export column from the account set export column. Values ​​greater than or less than 0 are marked in red. All values ​​marked in red in the difference column will receive 6 points, otherwise 10 points will be received.

[0126] 28. Account column - Taxes payable - Output tax row: (number of declaration forms)

[0127] 1. Path:\Cumulative Years\Chronological Account.xlsx

[0128] 2. Path:\Analysis\Sales Detail Comparison Table.xlsx

[0129] 3. Path: \Tax Bureau\Sales List.xlsx

[0130] 4. Path:\Tax Bureau\B\Z\*All VAT returns including year and month

[0131] Search all tables under path 4 by year and month, and fill the numbers in the 9th row - K to Q columns of each table and the year and month in the table file name into the "Year and Month" column and "Review Report Number" column under path 2 respectively. Search the chronological account table under path (1), and filter the "Taxes Payable_VAT Payable-Output Tax Amount" row in the "Account Name" column by year / month, and fill the total debit amount corresponding to the year / month into the account set export column of the "Output Detail Analysis Table" under path (2), and then filter the (3) path file by year / month. The "Tax Amount Column" in the "Sales Detail Table" under the (2) path is accumulated and filled in the "Tax Bureau Export Column" in the "Sales Detail Comparison Table". The value of the corresponding row's account set export column minus the value of the tax bureau export column is filled in the Difference 1 column. If the value is greater than or less than 0, the value of the declaration form column in the corresponding row is subtracted from the value of the tax bureau export column. The value obtained is equal to the value of the account set export column minus the value of the tax bureau export column. Then fill the value in the Difference 2 column. If the value is greater than or less than 0, mark it in red in the Difference 2 column to get 6 points, otherwise it will get 10 points.

[0132] 29. Account column - Sales expenses row is divided into two rows:

[0133] 1. Path:\Cumulative Years\Chronological Account.xlsx

[0134] 2. Path: \Analysis\Period Sales Expense Analysis Table.xlsx

[0135] Search the chronological account table under the path (1). In the chronological account table, add up the credit amounts of the "Main Business Income" and "Other Business Income" lines in the "Account Name" column by year, and fill in the operating income column of the "Period Sales Expense Analysis Table" under the path (2). Then add up the debit amounts of the "Advertising and Business Promotion Expenses" and "Business Entertainment Expenses" lines in the "Account Name" column by year, and fill in the corresponding columns of the "Period Expenses Analysis Table" by year. Divide the values ​​contained in the above account names by the values ​​in the corresponding annual operating income column, and fill in the corresponding "Proportion 1" column of each account column. Among them, the values ​​in the "Proportion 2" column of the advertising and business promotion expenses column for a certain year that are higher than 15% are marked in red, and the values ​​in the "Proportion" column of the business entertainment expenses column for a certain year that are higher than 0.5% are marked in red. If there are red marks in the table under the path 2, 6 points will be awarded, otherwise 10 points will be awarded.

[0136] 30. Account column - Administrative expenses row is divided into two rows:

[0137] 1. Path:\Cumulative Years\Chronological Account.xlsx

[0138] 2. Path: \Analysis\Periodic Management Cost Analysis Table.xlsx

[0139] 1. Search the chronological account table under the path (1). In the chronological account table, add up the debit amounts of the "salary" lines in the "account name" column by year, and fill in the salary column of the "period management expense analysis table" under the path (2) by year. Then add up the debit amounts of the "employee benefits" lines in the "account name" column under the path (1) by year, and fill in the corresponding name column of the "period management expense analysis table" under the path (2) by year. Then multiply the corresponding annual salary column by 14% and fill the comparison value into the proportion column. If the employee benefits exceed 14% of the salary column, mark the data in the "employee benefits" column in red.

[0140] 2. Search the chronological account table under path (1) and filter the debit amounts of the "Union Funds" row in the "Account Name" column by year. Add up the debit amounts by name and fill in the corresponding name column of the "Periodic Management Expense Analysis Table" under path (2) by year. Then multiply the annual data corresponding to the "Union Funds" column by 2% of the salary column and fill in the comparison value in the percentage column. If it exceeds 2% of the salary column, mark the data in the "Union Funds" column in red.

[0141] 3. Search the chronological account table under the path (1) and filter the debit amounts of the "Employee Education Fund" row in the "Account Name" column by year. Add them up by name and fill them into the corresponding name column of the "Periodic Management Expense Analysis Table" under the path (2) by year. Then multiply the annual data corresponding to the "Employee Education Fund" column by 2.5% of the salary column and fill the comparison value into the percentage column. If it exceeds 2.5% of the salary column, mark the data in the "Employee Education Fund" column in red.

[0142] 4. In the chronological account table under the search path (1), add up the credit amounts of the "Main Business Income" and "Other Business Income" lines in the "Account Name" column of the chronological account table by year, and fill in the operating income column of the "Period Expense Management Analysis Table" under the search path (2) by year. Then add up the debit amounts of the "Business Entertainment Expenses" lines in the "Account Name" column under the search path (1) by name, and fill in the corresponding name column of the "Period Expense Analysis Table" under the search path (2) by year. Then multiply the corresponding annual data in the "Business Entertainment Expenses" column by 60% and 0.5% of the corresponding value in the "Operating Income" column respectively, and fill in the 60% column and 0.5% column of the "Period Management Expense Analysis Table" according to the corresponding year. If the value in the 60% column is higher than the value in the 0.5% column, mark the 60% column in red. If there is a red mark in the table under the search path 2, 6 points will be awarded, otherwise 10 points will be awarded.

[0143] 31. Account column - Financial expenses row is divided into:

[0144] 1. Path:\Cumulative Years\Chronological Account.xlsx

[0145] 2. Path: \Analysis\Periodic Financial Expense Analysis Table.xlsx

[0146] Search (1) in the chronological account table. In the "Account Name" column of the chronological account table, filter the debit amount of the "Interest Income" line by year, and add it up year by year. Fill it in the corresponding name column of the "Period Financial Expense Analysis Table" under the path (2). Search (1) in the chronological account table. In the "Account Name" column of the chronological account table, filter the debit amount of the "Interest Expenses" line by year, and add it up year by year. Fill it in the "Interest Expenses" line of the "Period Financial Expense Analysis Table" under the path (2).

[0147] Search the chronological account table under path (1). In the "Account Name" column, filter the debit amounts of the "Long-term Loans" and "Short-term Loans" rows by year, add them up year by year, and fill them in the "Long-term Loans" and "Short-term Loans" rows of the "Period Financial Expense Analysis Table" under path (2). If the total of long-term loans and short-term loans is 0, the interest expense is 0 and is not marked in red. Otherwise, it is marked in red. Then, fill in the "Interest Expense Ratio" column with the percentage of interest expense to the total of "Long-term Loans" and "Short-term Loans". The percentage is less than or equal to 0 and greater than 5% is marked in red. The percentage marked in red is 6 points, otherwise it is 10 points.

[0148] 32. Account column - Tax paid data and taxes payable are separated into separate lines:

[0149] 1. Path:\Cumulative Years\Chronological Account.xlsx

[0150] 2. Path: \Tax Bureau\Sales Tax Details.xlsx

[0151] Search the chronological account table under path (1) and sort the "Account Name" column by year / month. Filter the debit amounts of the rows with "Taxes Payable - Unpaid VAT" or "Taxes Payable - VAT Payable - Taxes Paid", "Taxes Payable - Enterprise Income Tax", "Taxes Payable - Urban Construction and Maintenance Tax", "Taxes Payable - Education Surcharge", "Taxes Payable - Local Education Fee", "Taxes Payable - Stamp Duty", "Administrative Expenses - Union Expenses", "Taxes Payable - Water Conservancy Construction Fund", and "Administrative Expenses - Disability Insurance Fund" by year / month. Add up the debit amounts on a monthly basis and fill them into the "System Export" column of the path table (2) in year / month order. Compare them with the "Tax Bureau Export Column" of the corresponding monthly row in the path table (2). If there is any inconsistency, mark the row in red. 6 points will be awarded for rows marked in red under path 2, and 10 points will be awarded for rows marked in red otherwise.

[0152] 33. Account column - Trading enterprises have two lines of business at both ends:

[0153] 1. Path: \Tax Bureau\Sales Detail List.xlsx

[0154] 2. Path: \Analysis\Two-end external details table.xlsx

[0155] 3. Path: \Tax Bureau\Input Details List.xlsx

[0156] Search for the buyer's name and the total price and tax column value in the row where the third and fourth digits of the "Purchaser Identification Number" column in the sales item details table under the path (1) are not equal to 61, and fill in the corresponding rows year by year in the sales item details column (buyer's name) and amount column 1 in the two-end external detail table under the path (2). Then, fill in the seller's name and the total price and tax column value in the row where the third and fourth digits of the "Seller Identification Number" column in the "Input Item Details Table" under the path (3) are not equal to 61, and fill in the corresponding rows year by year in the input item details column (seller's name) and amount column 2 in the two-end external detail table under the path (2). If there is no data in the "Purchaser Identification Number" column in the table under the path 2, 10 points will be awarded, otherwise 6 points will be awarded.

[0157] 34. Account column - Purchase and sales mismatch row:

[0158] 1. Path: \Tax Bureau\Sales Detail List.xlsx

[0159] 2. Path: \Tax Bureau\Input Details.xlsx

[0160] 3. Path:\Analysis\Purchase and Sales Mismatch Statistics.xlsx

[0161] Search the "Name of Goods or Taxable Services" column in the "Sales List" under path (1) and compare the contents of *xxx* one by one with the "Name of Goods or Taxable Services" column in the "Input Detail Table" under path (2). If there is any discrepancy, fill the entire row in the Sales and Purchase Mismatch Statistics Table under path (3). If the row is not found in the "Input Invoice Detail Table", fill the entire row in the Sales and Purchase Mismatch Statistics Table under path (3) and mark it in red. If there is no content in the table under path 3, 10 points will be awarded. Otherwise, 6 points will be awarded.

[0162] 35. Account column - if there is sales but no progress, then the score is:

[0163] 1. Path: \Tax Bureau\Sales Detail List.xlsx

[0164] 2. Path: \Tax Bureau\Input Details.xlsx

[0165] 3. Path:\Analysis\Sales without purchase statistics.xlsx

[0166] Search the "Name of Goods or Taxable Services" column in the Sales Items table under path (1) and compare the content in *---* with the "Name of Goods or Taxable Services" column in the "Input Items table" under path (2). If no data is found, copy the entire row to the Sales-without-Inputs statistics table under path (3). If there is no content in path 3, 10 points will be awarded; otherwise, 6 points will be awarded.

[0167] 36. Account column - Invoice Void / Reverse Score Line:

[0168] 1. Path: \Tax Bureau\Sales Detail List.xlsx

[0169] 2. Path:\Analysis\Invoice Red Offset Statistics.xlsx

[0170] Retrieve the "Invoice Status Column" in the Sales Item Details Table under the path (1) and sort them in year / month order. Count the number of invoices issued each month and fill the value into the Total Column of the Invoice Red Cancellation Statistics Table under the path (2). Then retrieve the "Invoice Status Column" in the Sales Item List Table under the path (1). Fill the number of red cancellations and voided statuses into the Red Cancellation Column of the Invoice Red Cancellation Statistics Table under the path (2). Finally, divide the number of "Red Cancellations" in each row by the percentage in the "Total Count" column and fill the percentage column. If it is greater than or equal to 20%, 6 points will be awarded. Otherwise, 10 points will be awarded.

[0171] Step S200: Score the input data to obtain A+, A, B, C or D;

[0172] Step S300: Obtain the score, analyze the reasons, conduct internal analysis for those with C or D that do not meet the requirements, compare the analysis with the previously stored qualification standards, and connect to the internal network for internal financial personnel to conduct analysis;

[0173] Step S400: Feedback is provided on the reasons, and the analyzed reasons are fed back to the customer and the system to achieve the purpose of monitoring, store and display; the stored reasons increase the analysis capability of the system itself.

[0174] It is important to note that the construction and arrangement of the present application shown in a number of different exemplary embodiments are merely illustrative. Although only a few embodiments are described in detail in this disclosure, it should be readily understood by those who refer to this disclosure that many modifications are possible (e.g., the size, scale, structure, shape and proportion of various elements, as well as parameter values ​​(e.g., temperature, pressure, etc.), mounting arrangements, use of materials, color, directional changes, etc.) without departing substantially from the novel teachings and advantages of the subject matter described in this application. For example, an element shown as integrally formed may be composed of multiple parts or elements, the position of the element may be inverted or otherwise changed, and the nature or number or position of the discrete elements may be altered or changed. Therefore, all such modifications are intended to be included within the scope of the present invention. The order or sequence of any process or method steps may be changed or reordered according to alternative embodiments. In the claims, any "means plus function" clause is intended to cover the structure described herein that performs the function, and is not only structurally equivalent but also equivalent structures. Other replacements, modifications, changes, and omissions may be made in the design, operating conditions, and arrangement of the exemplary embodiments without departing from the scope of the present invention. Therefore, the invention is not limited to the specific embodiments, but extends to various modifications that still fall within the scope of the appended claims.

[0175] Additionally, in order to provide a concise description of exemplary embodiments, all features of an actual embodiment (i.e., those features that are not relevant to the best mode presently contemplated for carrying out the invention or those that are not relevant to implementing the invention) may not be described.

[0176] It will be appreciated that in the development of any actual embodiment, as in any engineering or design project, numerous implementation-specific decisions may be made. Such a development effort may be complex and time-consuming, but will, for those of ordinary skill having the benefit of this disclosure, be a routine undertaking of design, fabrication, and production without undue experimentation.

[0177] It should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention and are not intended to limit the present invention. Although the present invention has been described in detail with reference to the preferred embodiments, those skilled in the art should understand that the technical solutions of the present invention may be modified or replaced by equivalents without departing from the spirit and scope of the technical solutions of the present invention, which should all be included in the scope of the claims of the present invention.

Claims

1. A monitoring system for financial internal audit, characterized in that: The steps include: Step S100: Log in first, then input relevant data; Step S200: scoring the input data; Step S300: Obtain scores, analyze reasons, and conduct internal analysis for those that do not meet the requirements; Step S400: Provide feedback on the reason.

2. The financial internal audit monitoring system according to claim 1, characterized in that: In step S100, the relevant data is first input into the sum.xlsx table, and then the entire sum.xlsx table is input therein.

3. The financial internal audit monitoring system according to claim 2, characterized in that: In step S100, the score column items in each row of the sum.xlsx table include 36 items, each with 10 points.

4. The financial internal audit monitoring system according to claim 3, characterized in that: The 36 items include accounts receivable, other accounts receivable, prepaid expenses, financial expenses, administrative expenses, sales expenses, prepaid expenses, general taxpayers of inventory, small-scale inventory, taxes payable, the income amount of the four statements in each quarter should be consistent, the ratio of the cost amount of the natural person to the total cost amount, taxes payable-input tax amount line, taxes payable-output tax amount line, trading enterprises are outside the line at both ends, purchase and sales mismatch line, sales without progress and invoice cancellation / cancellation, etc.

5. The financial internal audit monitoring system according to claim 4, characterized in that: The rating is performed according to the range of the total values ​​in the sum.xlsx table, and the specific rating rules are: 350-330 points A+ / 330-320 points A / 310-280 points B / 280-240C / 240-0 points D.

6. The financial internal audit monitoring system according to claim 5, characterized in that: The ratings C and D are unsatisfactory.

7. The financial internal audit monitoring system according to claim 1, characterized in that: In step S400, the analyzed reasons are fed back to the customer and the system for storage and display.

8. The financial internal audit monitoring system according to claim 7, characterized in that: The reason for the storage is to increase the analysis capability of the system itself.

Images