Search Results for: All Files in Business Analysis Tools Category |
|
|
Your selection returned: 7
items - Displaying Matches 1 thru 7 of 7 Found.
|
| |
Title / Description
|
*Balance Sheet Template*
| | A balance sheet includes your assets and liabilities and tells you your business's net worth. You've probably seen a formal balance sheet for other businesses, or have paid an accountant to do one for yours. If you would like to try preparing a balance sheet for your business, you can use the spreadsheet template, contained in the attached file, as a starting point. Just plug in your account balances and the spreadsheet will automatically compute all the subtotals and totals and tell you if your balance sheet doesn't balance.
Although the template is an example of a balance sheet for a sole proprietorship, you can quickly modify it for a corporation or partnership. You can add or delete account titles, revise the format, or otherwise modify it to suit your needs. |
|
*Bank Reconciliation Template*
| | If you find yourself spending lots of time every month reconciling your bank statement and still aren't able to nail it down to the penny, our specially designed monthly bank reconciliation form contained in the attached file might be able to help you. It can help make the process far less painful and much more accurate, and will even do some of the clerical work for you. Just plug in the account balance shown on your bank statement, your deposits in transit, your outstanding checks, and your account balance according to your books in the spaces provided. The reconciliation will add up all the amounts, and immediately tell you if your books agree with your bank balance. If they don't agree, you can get right to the business of finding your errors (sorry, the spreadsheet can't do that for you)! |
|
*Cash Flow Budget Template*
| | The Cash Flow Budget Worksheet is used to project your business's cash inflows and outflows over a six-month period of time. It has many important uses. It can predict the ability of your business to create the cash necessary for expansion or to support you. It can project your business's cash inflows and outflows and predict your business's cash flow gaps - periods when cash outflows exceed cash inflows. It can also be used to prepare a formal cash flow budget for your lender to help assure the lender that you will have the cash available to pay back the loan. |
|
*Debt Collection Letters*
| | Personal visits, telephone calls, and letters are the three most common collection approaches that small business owners use to collect past due accounts. Since many small business owners simply don't have the time or opportunity for personal visits or telephone calls, a letter is often the method of choice. The attached file contains three sample collection letters, each designed with a different purpose. Each succeeding letter is slightly more strongly worded than the previous one ranging from a friendly reminder to notification that you are turning over the matter to a lawyer or collection agency. You can easily modify any of these letters to fit your situation or your personal style. |
|
*New Business Cash Needs Estimate*
| | This set of worksheets will enable you to compute the amount of cash you will need to start your new business and keep it, as well as your personal expenses, going for the first 90 days. The worksheet is broken down into three parts. The first part computes the amount of cash you will need from day one of planning your business to day one of opening the business for customers. The second part of the worksheet computes the business's cash needs for the first three months. The third part covers your personal living expense cash needs for that same period.
This worksheet set lists all the descriptions of the cash needs of the new business. If you need additional categories of expenses, you can quickly modify it. |
|
*Profit & Loss (Income Statement)*
| | A Profit & Loss Statement (sometimes called an income statement) lists your revenues and expenses, and tells you the profit or loss of your business for a given period of time. You've probably seen a formal income statement for other businesses or have paid your accountant to prepare one for yours. If you would like to try creating an income statement yourself for your business, you can use the spreadsheet template, contained in the attached file, as a starting point. Just plug in your income and expense account balances and the spreadsheet will automatically calculate all the subtotals and totals, and compute your net income. |
|
*Trial Balance*
| | Whatever kind of business you run, you have to close your books at least once a year to prepare an income tax return - or more frequently, if you want to get a better handle on how your business is doing. An important part of closing your books is preparing a trial balance - in other words, a list of all of your bookkeeping accounts and the balance of each at the end of the period - to see if your books are still in balance. If you are already doing this, you know that it is tedious and time-consuming; if your accountant is doing it, you know that it is an added expense.
The trial balance spreadsheet contained in the attached file is designed to save you time and money in preparing the trial balance yourself. The spreadsheet contains over 80 common account titles in a trial balance format. Simply plug in your balance for each account and the spreadsheet will automatically add up the debits and credits, and tell you if your books are out of balance (and by how much). Since it is a spreadsheet template, you can add or delete accounts or otherwise modify it to suit your needs and preferences. |
|
|
Your selection returned: 7
items - Displaying Matches 1 thru 7 of 7 Found.
|
