Excel format financial statements (balance sheet, income statement, cash flow statement) thank you for your adoption! ! !
Second, find a financial statement (Excel table). Is there a formula to cross-check the three major financial statements?
The amount of monetary fund items in the balance sheet is equal to the ending balance of cash in the cash flow statement. The net profit in the income statement is equal to the undistributed profit items in the balance sheet at the end of the year MINUS the beginning of the year.
Three. The financial statements under the new standards include balance sheet, income statement, cash flow statement and statement of changes in owner's equity.
be in debt
Annual Enterprise of Peasant Association 0 1 Table
Prepared by: 201165438+February 3 1 Date Amount Unit: 10,000 yuan.
Project Line Opening Balance Ending Balance Project Line Opening Balance Ending Balance
Current assets: 1
Monetary fund 2 short-term loans
Delta settlement reserve 3 Delta borrows from the central bank 68
△ Borrowing funds 4△ Absorbing deposits and interbank deposits 69
5△ demolition of transactional financial assets
Notes receivable 6 Trading financial liabilities 7 1
Accounts receivable 7 should be
Advance payment 8 Accounts payable 73
△ Premium Receivable 9 Advance Receipt 74
△ Reinsurance accounts receivable 10△ Selling and repurchasing financial assets 75
△ Reinsurance contract reserve receivable 1 1△ Handling fee and commission payable 76
Interest receivable 12 should be
Dividends receivable 13, in which: wages payable.
Other receivables 14 payables
△ Buy financial assets for resale 15#, of which: employee bonus and welfare fund 80.
Inventory 16 tax payable 8 1
In which: raw materials 17, in which: taxes payable 82.
Inventory goods (finished goods) 18 interest payable 83
Non-profit due within one year 84
Other current assets 20
Total current assets 2 1△ reinsurance accounts payable 86
Non-current assets: 22——△ Insurance contract reserve 8
△ Issuing loans and advances 23△ Acting to buy and sell securities 88
Coupon 89
Held-to-maturity investment 25 Non-current liabilities due within one year 90
Long-term 1
Long-term equity investment 27 Total current liabilities 92
Investment Real Estate 28 Non-current
Original price of fixed assets 29 Long-term loans 94
Less: tired
Net fixed assets 3 1 long-term payables 96
Less: Provision for impairment of fixed assets 32 Special payables 97
Net fixed assets 33 is expected to be negative.
Construction in progress 34 deferred income tax liabilities 99
Engineering materials 35 Other non-current liabilities 100
Liquidation of fixed assets 36, of which: special reserve fund 10 1.
Productive biological assets 3702
Total liabilities of oil and gas assets 38 are 103.
Shareholders' equity): 104-
Development expenditure 40 paid-in capital (share capital) 105
Goodwill 4 1 state-owned assets
Long-term prepaid expenses 42 collective capital 107
Deferred income tax assets 43 company capital 108
Other non-current assets 44 of which: state-owned laws.
Among them: 45 collectives are specially authorized to reserve materials.
Total non-current assets 46.
47 foreign investment 1 12
48# minus: the returned investment is 1 13.
49 paid-in capital (
50 capital reserve 1 15
5 1 minus: inventory 1 16.
52 special reserve 1 17
53 surplus reserve 1 18
54 of which: statutory common reserve fund 1 19.
55 Arbitrary provident fund 120
56# imprest 12 1
57# Enterprise Development Fund 122
58# Profit Return Investment 123
59△ General risk preparation 124
60 Undistributed profit 125
6 1 report conversion difference 126
62 Total owner's equity attributable to parent company 127
63 minority shareholders' rights and interests 128
Total owner's equity 129
Total assets 65 Total liabilities and owners' equity 130
Note: The accounts in the table are special for consolidated accounting statements; Items in italics with △ are special for financial enterprises, and those with # are special for foreign-invested enterprises.
— 1—
4. The latest financial statements are in excel version (balance sheet, income statement and cash flow statement), thank you very much.
The following is the complete set: IRI EXCEL financial report download (with formula)
Including: vouchers, general ledger, ledger, account book, T-account, balance sheet, income statement, cash flow statement, financial statements of assets operation of banks and so on. With a complete set of formulas, as long as the basic data is filled in, summary data and related data will be automatically generated, which will minimize the workload of financial tabulation.
More than 600 watches: /soft/304.htm
Yi Rui Financial Management can also produce perfect statements, and there are two versions for reference:
The simplified version of financial management in Yi Rui is suitable for accountants and businessmen in small and medium-sized companies. Download: /soft/306.htm
Yi Rui Financial Management Professional Edition is suitable for any company, and can make exquisite account books, details, balances, vouchers, statements, multiple sets of general ledgers and complete accounts exceeding 180, so as to realize the automatic processing of payroll settlement, transfer, transactions and loans. The Ministry of Science and Technology awarded the Innovation Achievement Award and guaranteed it for life. Address:/soft/soft/415.htm.