Contents Method 1: Personal Balance Sheet 1. Organize your financial information. 2. List your assets. 3. List your liabilities. 4. Subtract total liabilities from total assets to obtain net assets. Method 2: Company balance sheet 1. Understand the basis for preparing the balance sheet. 2. Design the balance sheet layout. 3. Fill in the balance. Method 3: Excel version of balance sheet 1. Download the form template. 2. Open the template in Excel. 3. Fill in the form. The balance sheet is like a snapshot of a company's financial position at the time the statements are prepared. Every company needs to prepare a balance sheet on a regular basis. Although the balance sheet may seem like a bible to those unfamiliar with it, it is actually relatively easy to compile. You can try following the steps below to create a balance sheet for your household budget or business.

Method 1: Personal Balance Sheet

1. Organize your financial information. You'll need records of your assets and liabilities, and remember to keep your bank statements and debt balances up to date.

2. List your assets. Fill in the first column of the form with the name and value of your assets, both financial and tangible. Sum to get total assets. Of course, we all want our assets to keep growing. Key assets include: Cash balance in bank account.

Investments in stocks, real estate, and mutual funds

Resale price of owner-occupied houses

Resale price of cars or other means of transportation

Resale price of personal personal property, including jewelry, furniture, etc.

3. List your liabilities. Fill in all liabilities and their amounts in the second column. Debt will decrease as you pay it off. Common liabilities include: student loans

car loans

credit card overdrafts

home loan balance

4. Subtract from total assets Total liabilities yield net assets. Net worth increases as assets increase and liabilities decrease. Organizing your assets using your personal balance sheet will help increase your net worth. Update and adjust your balance sheet based on your financial goals, and try to update it at least twice a year.

Method 2: Company balance sheet

1. Understand the basis for preparing the balance sheet. The balance sheet must always be balanced, and the principle behind it is the equation: Assets = Liabilities Equity. Convert the formula: Equity = Assets - Liabilities. Equity is a measure of a company's net worth. Assets are the company's resources, including: cash, accounts receivable, inventory, land, buildings, equipment, etc. A classified balance sheet divides assets into the following categories: Current assets, including cash (money in all bank accounts), accounts receivable (money that other people owe you), office supplies, and others that can be used within a year Assets received or consumed.

Fixed assets are mainly physical assets owned by the company, including land, buildings, machinery, equipment and other assets that are expected to be used for more than one year.

Liabilities are the company's debts, which mainly include wages payable, borrowings and accounts payable. They are usually divided into two categories: current liabilities, such as accounts payable, taxes or wages, which are due within one year. .

Long-term liabilities. Including long-term loans, mortgages, rentals, etc.

Equity is the capital invested by business owners or shareholders, including retained earnings and undistributed profits

2. Design the balance sheet layout. Fill in assets in the left column and liabilities in the right column and equity below.

3. Fill in the balance. Fill in the balances of assets, liabilities, and equity respectively, always remembering that the left and right columns of the form must be balanced. That is, assets must equal the sum of liabilities and equity. If the table is unbalanced, it means that the amounts of individual items are incorrectly filled in or the statistics are incorrect.

Method 3: Excel version of balance sheet

1. Download the form template. There are many balance sheet templates available for Excel, download the version that best suits your company. Microsoft provides many free templates for download. See details here.

2. Open the template with Excel.

Click File - Save As to get a copy of the template. Start reporting on the copy so you can continue to use the blank template later.

3. Fill in the form. Usually the summation formula is already added to the template and is automatically calculated after you fill out the form. Some tables also provide other calculations, such as gearing and working capital. Pick a version that suits your company's needs.

Tips: All information must be valid when preparing the report, and the preparation date needs to be written at the top of the report.