Financial statements are accounting statements that reflect the capital and profit status of an enterprise or budget unit in a certain period of time.
If your job is accounting, then you have to deal with excel every day, especially making tables, which consumes a lot of time for accountants. Without ready-made Excel templates and some high-efficiency skills, accountants will face overtime every day! Today, the editor will share with you: Smartbi's financial report template, put it on and put it away, put it away, and help everyone improve efficiency!
Next, let me show you the specific steps of using Sematic software Smartbi to analyze the excel plug-in to make financial statements:
This is an ordinary balance sheet that I got. The row area is the first and second level specific details of assets and liabilities. The column areas are the beginning balance, increase, decrease, and ending balance. According to accounting We know from the knowledge that the ending balance = the beginning balance + the increase in the current period-the decrease in the current period. At the same time, this is also an entry form, all data will be entered in this form.
The current demand is to enter the data in the table above, so that the data of the ending balance is displayed in the following figure, then you can see that the following table shows a lot of institutions, if it is just one institution, then It is a very simple matter. One vlookup in the EXCEL table can be solved. The problem is that there are so many institutions. If each institution has to enter at the same time, it needs to build a lot of EXCEL forms to achieve it, because each institution The data are all independent of each other. There is no way for EXCEL to implement this function in one sheet, which would be a very tedious task.
The third table below is to summarize the balances at the beginning of the year and the balances at the beginning of the year of all institutions. If you operate in EXCEL, you need to use formulas to connect the data tables of multiple institutions with formulas, which is quite troublesome and time-consuming. In that case, is there a simpler way?
First, I connected to the database in EXCEL, established a multi-dimensional data storage table in the database, entered the organization, primary classification, secondary classification, indicators, and indicator values, and then connected to this database with EXCEL, which needs to be used here A powerful excel plug-in, Smartbi analysis, can quickly connect to the database after downloading and installing, which is much simpler than connecting to other databases.
After connecting to the database, you can design the style of the spreadsheet in EXCEL. The design of the spreadsheet is also very simple. Fill in the title in the fixed area, then drag the database field to the spreadsheet area, and set With certain rules, it can be published in the cloud.
In the same way, the second and third forms can also be implemented in the same way, as long as the data of the first form is entered, the data of these two forms will be automatically updated, because these three forms are connected at the same time For data, it perfectly solves the problem of connecting multiple tables with formulas in EXCEL. It is so convenient and practical. I only hate that I know it too late.
Through the above case of using spreadsheets as data reports, we know how smart and convenient spreadsheets are. If you still only use EXCEL for simple data entry, please quickly collect this method, at least it can save you More than 80% of the time, so you have plenty of time to do other things, why not do it?