How are financial statements prepared?
1. The "Accounts Receivable" item should be filled in based on the total end-of-period debit balance of the detailed account to which the "Accounts Receivable" account and the "Accounts Receivable" account belong, minus the ending balance of the bad debt provision for accounts receivable in the "Bad Debt Provision" account.
2. The "prepayment" item should be filled in based on the total end-of-period debit balance of the "prepayment" account and the "accounts payable" account's detailed account, minus the ending balance of the bad debt provision for prepayment in the "bad debt provision" account.
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 filled in based on the ending balance of each corresponding account, minus the ending balance of bad debt provision for the corresponding items in the "bad debt provision" account.
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. You can click on discontinuous cells or cell ranges to select 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. In addition,Inbound and outbound data statistics table,Employee resignation approval formIt is also a good software. Welcome to click to download and experience it!
Useful
Useful
Useful