Numerous websites offer sheet templates, either for free download or they charge a small fee. With the free templates, companies or sole proprietors can keep record of more than 1 year. Keep monthly records too. Download balance sheet templates depending upon its features and which operating system it will work with. The templates work with Microsoft Excel and they can be modified according to business demands. Browse through several balance sheet examples to get an idea on how your sheet might turn out and depending on that, choose the sheet template. Alternatively, use online tool Google Docs to upload files and modify it.
Next, how much detail do you need in your cash flow template Excel spreadsheet at the individual line item level? Is cash from financing sufficient or do you need equity financing, debt financing, interest earned, etc. Also how do you intend to handle depreciation and amortization, since these are non_cash items that are typically added back to the income statement entries when determining the cash effect.