Financial statement template according to the latest Circular 133, 200 Excel

Is your business in need of a suitable financial statement template? Look no further! In this blog post, we will guide you toward financial statement templates that align with Circular 133, including a collection of 200 Excel files. These templates and resources are invaluable tools for effectively organizing and preparing your financial reports. For more in-depth information, be sure to check out the Viindoo article for a comprehensive overview of the appropriate financial statement templates for your business.

Financial statement template according to Circular 133

Financial statement form according to Circular 133 is applied to enterprises meeting the continuity assumption consisting of 2 samples: B01a-DNN and B01b-DNN.

  • B01a-DNN: Assets and liabilities are written in order of liquidity decrease and specifically going from the most liquid to the least liquid.
  • B01b-DNN: Assets and liabilities are presented under short-term and long-term.

Depending on the operation characteristics, enterprises choose to prepare financial statements B01a-DNN and B01b- DNN. For businesses that are operating, you need to check which form last year you declared, you must submit this report form this year.

Load financial statement form B01a- DNNhere: Financial statement form B01a-DNN.

Load financial statement form B01b- DNNhere: Financial statement form B01b-DNN.

Financial statement template B01a- DNNFinancial statement template B01a- DNN
Financial statement template B01b- DNNFinancial statement template B01b- DNN

>>>> See More: How to make financial statements the most accurate and complete year

Financial statement template according to Circular 200

Balance sheet

The balance sheet is one of the most important financial statements of a business, showing the allocation of assets, liabilities, and capital at a given point in time. This form helps managers assess the financial position of the business and identify risks, opportunities or future development strategies.

Download Balance sheet: Here.

Accounting balance sheetAccounting balance sheet

Income Statement

The income statement is prepared once each accounting period (usually a quarter or year) and provides an overall picture of a business's consolidated profit or loss for a specific period of time.

>>>> Download the Income Statement: Here.

Cash Flow Statement

The Cash flow statement shows the cash flow of a business over a certain period of time, through its operating, investing, and financing activities. This report helps readers better understand the origin and use of the business's money, thereby making an assessment and forecast of future financial performance.

>>>> Download the Cash flow statement: Here.

>>>> Reference: Sample cash fund inventory record Circular 200,133,107 Excel

Notes to financial statement

The Notes to financial statement is a document that provides and supplement detailed information about important figures and events that have affected the financial position of the company during the reporting period. The note includes items such as an explanation of assets, liabilities, and equity, information on organizational structure, business strategy, risk factors, and future development opportunities.

>>>> Download the Notes to financial statement: Here.

Statements of cash flowsStatements of cash flows
Notes to financial statementNotes to financial statement

Financial statement template of Circular 133, 200 Excel:

Financial statement template of Circular 133, 200 was designed in the form of an Excel file, helping businesses ensure legality and save time in preparing annual report forms.

Load Financial statement template Circular 133 Excel here: Circular 133 Financial Statement Template Excel.

Load Financial statement template Circular 200 Excel here: Circular 200 Financial Statement Template Excel.

Exploring different Financial statement templates

Financial statement form according to IFRS

The IFRS financial statements are standardized in accordance with the International Financial Information Standard, providing a legal format for public companies to prepare and present.

Download the IFRS Financial Statement Form: here

Financial statement form in English

Financial statement template in English is a necessary report form for businesses operating in an international environment, or needing financial reports to foreign agencies and organizations.

Download the Financial Statement Form in English: here

Financial statement template in EnglishFinancial statement template in English

English-Vietnamese bilingual financial statement template

English-Vietnamese bilingual financial statement template allows businesses to easily convert information from English to Vietnamese or vice versa, helping to create consistency and accuracy in information transmission.

Download the English-Vietnamese Bilingual Financial Statement Form: here

English-Vietnamese bilingual financial statement templateEnglish-Vietnamese bilingual financial statement template

Besides the free financial reporting forms, businesses can refer to the Viindoo Accounting software application to make quick and accurate financial statements.

When using Vindoo Accounting, making financial statements becomes easier than ever because the entire accounting process is automated, and the interface is friendly and easy to use. In addition, the software also provides an overall picture of corporate finance with an intuitive dynamic reporting system, ready to be accessed anytime, anywhere, helping managers easily formulate effective planning strategies.

VIINDOO ACCOUNTING 

FREE use for life!​

TRIAL NOW

FAQ

To begin, access Microsoft Excel Online and launch a new, empty spreadsheet. Recognize the underlying assumptions for the financial statement and generate a designated page for recording transactions. Develop a Profit and Loss statement that provides a concise overview of monthly transactions.

Four main types of financial statements are utilized by for-profit enterprises: the balance sheet, the income statement, the cash flow statement, and the statement of retained earnings.

Function
Description
FV function
Returns the future value of an investment
FVSCHEDULE functionReturns the future value of an initial principal after applying a series of compound interest rates
INTRATE function
Returns the interest rate for a fully invested security

Step 1 – Colgate's Financial Model – Historical.
Step 2 – Ratio Analysis of Colgate Palmolive.
Step 3 – Projecting the Income Statement.
Step 4- Working Capital Forecast.
Step 5 – Depreciation Forecast.
Step 6 – Amortization Forecast.
Step 7 – Other Long Term Forecast.

Hope the financial statement template but Viindoo introduced will become an effective assistant of many businesses in managing and assessing their financial situation. If your business needs more advice on Vindoo Accounting - online accounting software, please contact hotline 02257309838 for quick support.

>>>> Continue With:

Jun Nguyen May 3, 2023

SHARE THIS POST