Revenues and Expenses

Either your business will use to Revenue and Expense Journal or a Ledger to keep track of how much money is going out, where, it is going, and What is coming in. A Revenue and Expense Journal MOST is Used by Small Businesses and is single-entry accounting – recording receipts and Expenditures only. Double entry accounting ledger and by involving Each activity necessitate That Be Recorded as a debit and a credit on your books. In the past Thought That It Was All Business Needed to use the more cumbersome method of double-entry, But The single entry system is now Used for Many small business owners. Single-entry accounting Can Be Kept on paper or computer. Programs That Perform single-entry accounting include Quicken by Intuit and Microsoft Money Among Many Others.

A ledger is Used to record Twice Every transaction based on the idea That Each transaction has two halves That Affect Your Business. For example, if you sell an item, your books Would Reflect a DECREASE in inventory (a credit) and the inflow of payment (debit). If you use double-entry accounting you May want to use a computer program or a Bookkeeper to keep your ledger up to date. If you allow Anyone else to keep your books Be sure you review Them Regularly. Programs That do double-entry bookkeeping include: MYOB by Teleware, Peachtree Accounting by Peachtree Software, and Quickbooks by Intuit. Your accountant dog Advise you on Which type of recordkeeping Should you choose. Also consult your tax advisor about whether you Should use a cash or accrual-based bookkeeping system.

Cash Flow Sensitivity Analysis Worksheet
Provided by Business Owner’s Toolkit , Content Partner for the SME Toolkit

Benefits: This worksheet is set-up to be Used for forecasting changes file in your Receipts and Disbursements and the effects the changes file on your cash Will Have Requirements of your start-up new business. This worksheet will show you to What Will Happen When your cash flow forecast is your off by 5 percent. We’ve formatted the worksheet and put in MOST of the inflows (income) and outflows (Disbursements) categories for you. All You Have to do is put in your numbers and print it. This worksheet lists all the descriptions of the cash inflows and outflows of the new business. If You Need Additional categories of Expenses You Can Quickly modify it. Just plug in your Amounts Automatically and the spreadsheet will compute the totals.

File Description: The file is a Microsoft Excel (version 5.0 or later) spreadsheet template. Once you’ve downloaded the file, you must-copy it to your EXCEL \ XLSTART directory in order to use it.

Special Features:

Download this spreadsheet template just eleven, and Be Able to use it over and over again.
The spreadsheet contains the formatting for a cash flow sensitivity analysis.
The spreadsheet Can Be Completely Customized – You Can Quickly add or delete items or revise the format to Meet your needs.
The spreadsheet is easy to use. Just plug in your inflows (income) and outflows (Disbursements) Automatically and it will show you What Will Happen to your current cash flow results when to What You Are Not expected.
The spreadsheet shows What Will Happen When Your results cash 5 Percent Are Better Than What You expected.
Also The spreadsheet will show you What Will Happen to your cash when to SALES ARE 5 Percent Less Than What You forecaster and outflows (Disbursements) 5 Percent Are More Than What You Forecaster.

Corporate accounting practices have made great progress through technology. The same has happened with spreadsheets, these tools of financial analysis and monitoring with you wholeheartedly in the modern era.

Whether your company uses spreadsheets to track expenses, cash flow and inventory, provisions for tax and capital or to discuss the purchase and leasing options, the latest features offered in Microsoft Office Excel can save you time. And as you know any person who performs accounting tasks in a small business, time is money.

Share and compare
In many situations, the financial information included in the spreadsheet is used by people from very different profile. The sales representative shows his expense report to the head of sales. The sales manager who forwards it to the accounting, in turn, submits it to the owner of the company. Excel offers several features that improve the opportunities for sharing and comparing books: Smart Documents extend the functionality of a book to respond dynamically to the context of user actions.

The forms and templates are used particularly well as smart documents. The same is true of books that are part of a process. Suppose that your company follows a process to enter the annual costs of employees based on an Excel template. If you convert that template into a smart document, you can connect to a database that automatically enters some of the necessary data. When done, you can click a button and the document is routed to the person in charge of the next step in the process. Such documents saves time. For example, who is responsible for billing you can copy text reusable when preparing monthly statements.

They can also interact with other Office applications. You can use it to send emails with Outlook without leaving the book in which you are and without starting Outlook.

Shortcuts
Below are other quick tips that can help: AutoFilter. Suppose you have 2 thousand customers in a book and need to identify those who have purchased a product. Filtering lets you see only the data you want, the rest are hidden. Unlike the role of management, the filtering does not change or reorganize the data. When you remove the filter, all data appear before applying. Consolidating data from various origins in a book can be a nightmare at times of payment of taxes, end of fiscal accounting and other milestones. You can take a long time to rewrite or copy and paste a large number of columns of data from different sources. The Excel import feature simplifies the task.

Locating discrepancies in long lists can be a very laborious process to examine whether there is line by line. But with Excel you can identify inconsistencies automatically. With some advanced configuration options (for example, choose or create a list in each field that is unique and comparable) that Excel can locate only data contained in a list. Custom templates can help you quickly complete routine tasks. Instead of creating or purchasing forms to track financial data, download free templates for Excel pregeneradas customize according to your specific needs. You can access these templates from Office Online website.

While many businesses assume that accountants are bound by generally accepted accounting practices and that these are inviolate, nothing could be further from the truth. Everything is subject to interpretation, and GAAP is no different. For one thing, GAAP themselves permit alternative accounting methods to be used for certain expenses and for revenue in certain specialized types of businesses. For another, GAAP methods require that decisions be made about the timing for recording revenue and expenses, or they require that key factors be quantified. Deciding on the timing of revenue and expenses and putting definite values on these factors require judgments, estimates and interpretations.

The mission of GAAP over the years has been to standardize accounting methods in order to bring about uniformity across all businesses. But alternative methods are still permitted for certain basic business expenses. No tests are required to determine whether one method is more preferable than another. A business is free to select whichever method it wants. But it must choose which cost of good sold expense method to use and which depreciation expense method to use.

For other expenses and for sales revenue, one general accounting method has been established; there are no alternative methods. However, a business has a fair amount of latitude in actually implementing the methods. One business applies the accounting methods in a conservative manner, and another business applies the methods in a more liberal manner. The end result is more diversity between businesses in their profit measure and financial statements than one might expect, considering that GAAP have been evolving since 1930.

The pronouncement on GAAP prepared by the Financial Accounting Standards Board (FASB) is now more than 1000 pages long. And that doesn’t even include the rules and regulations issued by the federal regulatory agency that jurisdiction over the financial reporting and accounting methods of publicly owned businesses – the Securities and Exchange Commission (SEC).

It might seem obvious, but in managing a business, it’s important to understand how the business makes a profit. A company needs a good business model and a good profit model. A business sells products or services and earns a certain amount of margin on each unit sold. The number of units sold is the sales volume during the reporting period. The business subtracts the amount of fixed expenses for the period, which gives them the operating profit before interest and income tax.

It’s important not to confuse profit with cash flow. Profit equals sales revenue minus expenses. A business manager shouldn’t assume that sales revenue equals cash inflow and that expenses equal cash outflows. In recording sales revenue, cash or another asset is increased. The asset accounts receivable is increased in recording revenue for sales made on credit. Many expenses are recorded by decreasing an asset other than cash. For example, cost of goods sold is recorded with a decrease to the inventory asset and depreciation expense is recorded with a decrease to the book value of fixed assets. Also, some expenses are recorded with an increase in the accounts payable liability or an increase in the accrued expenses payable liability.

Remember that some budgeting is better than none. Budgeting provides important advantages, like understanding the profit dynamics and the financial structure of the business. It also helps for planning for changes in the upcoming reporting period. Budgeting forces a business manager to focus on the factors that need to be improved to increase profit. A well-designed management profit and loss report provides the essential framework for budgeting profit. It’s always a good idea to look ahead to the coming year. If nothing else, at least plug the numbers in your profit report for sales volume, sales prices, product costs and other expense and see how your projected profit looks for the coming year.