Is it illegal for accountants not to make monthly statements?

Is it illegal for accountants not to make monthly statements? It is not illegal for an accountant not to make a monthly statement, but it will violate the professional ethics of accountants and cut corners at work, not to mention breaking the law.

How should property accountants make monthly statements? Property accounting is also commercial accounting, and its process is the same as that of industrial enterprise accounting. It's relatively simple. Are you also a property accountant? me too

EXCEL problem: make a monthly report, the daily report is as shown in the figure, and the monthly report should count the sum of each item. Find a way? 1. It is more convenient and faster to use the PivotTable.

2. After sorting by project, classify and summarize.

3. Select non-duplicate records by using the advanced filter check box in the project bar.

Copy the filtering results to D2.

Enter or copy and paste this formula in E2.

=SUMIF(B:B，D2，C:C)

Pull-down filling

Whether last month's report is inaccurate or not will affect next month's report depends on whether there is a formula correlation between your reports. If there is a connection, it will definitely have an impact. If it's not relevant, there won't be much problem. Just change the comments next month.

How to make a monthly report? Before editing and typesetting tables, open the Tables and Borders toolbar.

(1) table editing

Editing a table includes changing the row and column space of the table and modifying the table structure. Please create a table with three rows and three columns, and then do the following operation exercises:

1) Add Row Move the cursor to the end of any line (outside the table) and press Enter once to add a line to the table; Move the cursor to any cell, open the Table menu, point to Table, and select Insert Row. A row will also be added to the table.

2) Add Row Open the Table menu, point to Table, and select Insert Row to add a row to the table.

3) Split cells Cell splitting is not only a cell, but also a group of cells, a row or a column. Before splitting, select the cells to split.

After the cell is selected, Quot "Split Cell" button on the toolbar of tables and borders, or select "Split Cell" in the Table menu to set the score in the "Split Cell" dialog box that appears.

Please do the splitting exercise in the above way.

4) Hold down the left mouse button of merged cells in the table, drag from one cell to another, and select consecutive cells. If you want to select an entire line, you can select the left mouse button when the mouse arrow tilts to the right. Press and drag to select several consecutive lines.

Select several consecutive cells, click the Merge Cells button on the Tables and Borders toolbar, or select Merge Cells on the Table menu to merge the selected cells into one.

Merging cells can also be achieved by erasing lines between cells.

5) Adjust the width of rows and columns. Point the mouse at any row in the table, and the mouse logo will become a double arrow shape. At this point, hold down the left mouse button and drag to change the width of the row or column. Pay attention to the horizontal line moving up and down and the vertical line moving left and right.

You can also adjust the width of rows and columns on the horizontal and vertical rulers.

6) Move the workbench position. There is a small cross arrow mark in the upper left corner of the table. Hold it down with the left mouse button and drag the position of the mobile workbench. There is a small square mark in the lower right corner of the table. You can drag it with the left mouse button to change the size of the table.

Please use this function to center the entire table in the file and make the table fit.

7) Evenly distribute rows and columns Select the whole table, and click the buttons of Evenly distribute rows and evenly distribute distribution list on the toolbar of Tables and Borders, and the rows and columns in the table will be evenly distributed.

(2) Edit the table contents

The editing method of table contents is the same as that of Word ordinary files, and the content in each cell is equivalent to the content of an independent paragraph.

(3) Typesetting of tables

First, reduce the left and right width of the table appropriately, then adjust the whole table to the center of the file, and then do the following:

(1) Use the Align button on the Tables and Borders toolbar to center the rows except the last row vertically;

(2) Use the "Align" button on the "Tables and Borders" toolbar to set the last line as bottom alignment;

Use the Change Text Direction button on the toolbar to adjust the direction of the text in the table.

(4) AutoFormat

In addition to the default grid table, Word also provides a variety of table styles that can be used automatically:

(1) When inserting a table, the insert table is applied. After setting the rows and columns, click the AutoFormat button to select the format you need.

(2) Apply the cursor to the existing table, open the "Table" menu, select "Form AutoFormat", and then select the format you need.

How to do the monthly report? Practice of monthly report:

1. Prepare accounting voucher summary table according to the audited accounting vouchers, and register subsidiary ledger according to the audited accounting vouchers.

2. Register the general ledger according to the audited accounting voucher summary table.

3. Make accounting statements according to the balance of general ledger and subsidiary ledger.

Because your question is not very clear, I will take the small-scale taxpayer for example:

1. General monthly financial statements are main tables such as balance sheet and income statement, and auxiliary tables such as bank balance adjustment statement, cash income statement and depreciation statement of fixed assets;

2. Non-online tax declaration households should fill in the VAT declaration form, stamp duty declaration form, business tax, education surcharge, local education surcharge and cultural undertakings construction fee tax declaration form, individual tax declaration form, etc.

If you can't find out how to generate a monthly report from last month, the system will automatically retrieve data from your account set only if you enter "keyword", so it must be that you didn't enter "keyword", UFO report-data-keyword-input-and then enter the year and month, so you can confirm it, but whether the extracted data is correct depends on whether the formula in your report template is correct. Usually, the preset template.

How to write a work summary in accounting statements (final accounts, quarterly reports and monthly reports) mainly describes the work content, achievements and shortcomings, and finally puts forward rationalization suggestions or new efforts. . . . . . Reprint: Summing up is to make a comprehensive and systematic general investigation, general evaluation, general analysis, general research, performance analysis, shortcomings analysis, experience summary and so on. Summary is a kind of applied writing, which is a rational thinking about the work that has been done. Summary and plan are complementary and should be based on the plan. Planning is always based on personal experience. The basic requirement of summary is 1. The summary must have an overview and a description of the situation, some simple and some detailed. This part mainly analyzes the subjective and objective conditions, favorable and unfavorable conditions, working environment and foundation. 2. Achievements and shortcomings. This is the center of summary. The purpose of summing up is to affirm the achievements and find out the shortcomings. What are the achievements, how big, how to use them and how to achieve them; How many shortcomings there are, what aspects they show, what nature they are, and how they come from, we must make it clear. 3. Lessons learned. Once you do something, there will always be experience and lessons. In order to facilitate the future work, it is necessary to analyze, study, summarize and concentrate the experience and lessons of the past work, and rise to the theoretical level to understand. Future plans. According to the tasks and requirements of future work, draw lessons from the previous period, clarify the direction of efforts, put forward improvement measures, and other matters needing attention. We must seek truth from facts, not exaggerate achievements, not narrow shortcomings, and not cheat. This is the basis of analysis and learning lessons. 2. Clear organization. The summary is written for people to see. If it is not clear, people will not understand it, and even if they do, they don't know why, so the purpose of summary will not be achieved. It should be appropriate and detailed. Materials are essential and phenomenal; There are important things and minor things, so when writing, we should go to the weeds and save the essence. The problems in the summary should be divided into primary and secondary, detailed, detailed and abbreviated. The basic format of the summary is 1, heading 2, and the beginning of the text: overview and overall evaluation; Summarize the full text. Subject: analyze the shortcomings of achievements and sum up experiences and lessons. Conclusion: Analyze the problem and make clear the direction. 3. Signature and date of signature

How to make monthly accounting statements? Now the boss asks me to make a monthly report, but I'm not very good at it. Under the guidance of which master ~ thank you. This is the most basic accounting knowledge. How can you be an accountant? There is so much knowledge involved that I can't say a word clearly. It is suggested to find a book on the basic knowledge of accounting and learn it from scratch.