A complete set of annual financial statements in Excel for small and medium-sized companies, accountants and bookkeeping firms. The Company Details sheet holds the company name, city, address, phone, company ID number, managing director, preparer, bank, report date and the start and end dates of the reporting period. These details flow automatically into the header and the signature line of every statement. The Balance Sheet presents assets, equity and liabilities in two columns, for the current year and the prior year, with subtotals by group and section. The Income Statement lists expenses and income side by side and calculates operating and finance totals, profit or loss from ordinary activities, accounting profit or loss and the final profit after taxes. The Cash Flow Statement uses the direct method and shows receipts, payments and net flows for operating, investing and financing activities, together with cash at the beginning and end of the period. The Statement of Changes in Equity tracks subscribed capital, share premium, revaluation reserve, the individual reserves, retained earnings, accumulated losses and the result for the year. The Non-Current Assets Schedule shows the gross carrying amount, revaluations and depreciation of each asset group and calculates the carrying amount at the end of the period. A separate Statement Checks sheet compares the statements with each other and flags every difference with a clear message for the current and the prior period. All totals and checks are calculated by formulas, so you only enter the amounts.
Mint Green, Aqua Blue, Sky Blue, Cornflower Blue, Periwinkle, Violet, Royal Purple, Magenta, Crimson, Tangerine, Olive Green, Steel Grey, Graphite, Charcoal, Jet Black
Excel template, printable, Periwinkle, Violet, Magenta, Crimson, Graphite, Charcoal, aqua blue, sky blue, spreadsheet, small business, balance sheet, bookkeeping, fixed assets, accounting, depreciation, accountants, mint green, royal purple, assets and liabilities, cornflower blue, jet black, financial report, automatic calculations, tangerine, olive green, business report, annual financial statements, financial statements, income statement, profit and loss, cash flow statement, direct method, statement of changes in equity, non-current assets schedule, equity, year-end closing, consistency checks, current and prior year, steel grey, yearly flow statement, afs