How are financial statements prepared?
1. The "Accounts Receivable" item should be based on the total end-of-period debit balances of the detailed accounts to which the "Accounts Receivable" account and the "Accounts Receivable" account belong, minus the relevant accounts receivable calculations in the "Bad Debt Provision" account. Enter the amount after the closing balance of bad debt provision.
2. The "prepayments" item should be based on the total end-of-period debit balances of the detailed accounts to which the "prepayments" account and "accounts payable" account belongs, minus the end-of-period bad debt provisions related to prepayments in the "bad debt provision" account. Enter the amount after the balance.
3. The "Accounts Payable" item should be filled in based on the total end-of-period credit balance of the "Accounts Payable" account and the "Prepaid Accounts" account's subsidiary account.
4. The "Accounts from Advances" item should be filled in based on the total end-of-period credit balance of the "Accounts from Advances" account and the detailed account to which the "Accounts Receivable" account belongs.
5. The items of "notes receivable", "dividends receivable", "interest receivable" and "other receivables" should be based on the ending balance of each corresponding account, minus the amount accrued for each item in the "bad debt provision" account. Enter the amount after the closing balance of bad debt provision.
What elements should be included in small business financial statements?
The financial statements of a small business should include at least the following parts:
Article 79 Financial statements refer to the structural statement of the financial status, operating results and cash flow of a small enterprise. A small business's financial statements should include at least the following components:
(1) Balance sheet;
(2) Income statement;
(3) Cash flow statement;
(4) Notes.
General tips for small business financial statements 1. Quick sum? Use “Alt + =”Excel’s functions are very powerful, and summation should be one of the most commonly used functions. Just press the shortcut keys "alt" and "=" continuously to find the sum of a series of numbers.
2. Quickly select discontinuous cells
Press the key combination "Shift+F8" to activate the "Add Selected" mode. At this time, the words "Add to Selection" will be displayed in the status bar below the worksheet. Then click on discontinuous cells or cells respectively. You can select a grid area without holding down the Ctrl key.
3. Change number format
Excel’s shortcut keys are not chaotic, but follow a certain logic.
For example, if you want to quickly change the format of a number, you can immediately add a dollar sign to the number, because the $ symbol and the number 4 share the same key.
In the same way, "Ctrl+shift+5" can quickly change the number into the form of percentage (%).
4. Display all formulas with one click “CTRL + `”
When you try to check whether there are errors in the data, you can display the formula behind the number with one click.
The "`" key is just to the left of the number 1 key:)
Recommended by the editor of Huajun Software Park
small business financial statementsIt is a very practical form, and most of the forms you fill in are for general purposes. If you happen to need to download small business financial statements, download it quickly. also,Inbound and outbound data statistics table,Employee resignation approval formIt is also a good software. Welcome to click to download and experience it!
it works
it works
it works