Personal balance sheetHow to fill it out?
1. Fill in the data in the "Beginning Amount" column of the balance sheet: The data in the "Beginning Amount" column of the balance sheet should be filled in based on the numbers shown in the "Ending Amount" column of the balance sheet at the end of the previous year. The balance sheet is filled out based on an analysis of the closing balances of the general ledger accounts.
2. Asset items include: net loss of current assets to be disposed and net loss of fixed assets to be disposed, respectively, according to the "Profit Loss and Loss to be Disposed of Current Assets" and "Profit and Loss of Fixed Assets to be Disposed" to which the "Property Loss and Loss to be Disposed" account belongs. Enter the debit balance at the end of the period for the level account. If it is a credit balance, it should be entered as a negative number.
3. Liability items include: Public Welfare Fund, which is filled in based on the ending credit balance of the secondary account of "Public Welfare Fund" (or "Statutory Public Welfare Fund") to which the "Surplus Reserve" account belongs.
4. Monetary fund items in the asset category: Fill in the items based on the closing balances of "cash", "bank deposits", "other monetary funds" and other accounts.
5. Asset-type inventory items: based on "material procurement" (or "materials in transit"), "raw materials", "packaging materials", "low-value consumables", "material cost differences", "entrusted processing materials", The end-of-period balances of "self-made semi-finished products", "finished products", "goods received in installments and shipped", "production costs" and other accounts are combined and filled in.
6. Net fixed asset value items in the asset class: Fill in the net amount based on the debit balance of the "fixed assets" account minus the credit balance of the "accumulated depreciation" account.
First, let’s start with input and adjust the font. You can find the font tool box at the beginning of the toolbar, where you can quickly change the font type, size, color, etc.
2. Insert and delete cells
In the cell tool box, you can quickly insert or delete cells with one click. For example, sometimes when typing, a row of data is missed. Here, click "Insert Row" in "Insert Cell" under "Rows and Columns" and it will be OK.
3. Fill merged cells
As long as the data range is selected, unmerge the cells first. Then press Ctrl+G to locate the null value. Then enter the equal sign, press the up arrow of the direction key, and finally press Ctrl+Enter.
Recommended by the editor of Huajun Software Park
Personal Balance Sheet TemplateIt is a very practical form, and most of the forms you fill in are for general purposes. If you happen to need to download a personal balance sheet template, download it quickly. also,Public area disinfection record form,Holiday employee destination statistics tableIt is also a good software. Welcome to click to download and experience it!
it works
it works
it works