12 Months Cash Flow Statement

November 19th, 2009 admin No comments

One important part of managing company operational activities is managing the cash flow activities where an accountant or any people responsible in financial issue has to make sure that the company manage its cash flow properly and any department have to make sure that the company income and expenses is in balance. This spreadsheet is intend to guide you on this issue.

Opening Day Balance Sheet

November 19th, 2009 admin No comments

A balance sheet shows the financial position of your company at a single moment in time; in this case, it will be as of opening day. You can use your startup expenses to get the basic data for the balance sheet. Here are some accounting rules which will help you construct an accurate balance sheet: Assets are recorded at the lower of cost or current market value. Since your assets will be newly acquired, put them down at cost. If you have donated personal possessions to the business, enter them at market value.

Sales Forecast

November 19th, 2009 admin No comments

Forecasting sales of your product or service is the starting point for the financial projections. The sales forecast is the key to the whole financial plan, so it is important to use realistic estimates. Divide your projected monthly sales into “Categories”, which are natural divisions that make sense for your type of business.

Wedding Guest Tracker

November 18th, 2009 admin No comments

This spreadsheet is created to keep track of your guests’ details, invitations, attendance, gifts and thank you cards.

Manual Gantt Charting

November 18th, 2009 admin No comments

This is a sample or a demo of creating a Gantt Chart as a tool for creating your project schedule using an excel spreadsheet.