Variance Reports and Trends for Cash Flow Statements and Income Statements
1. Introduction to Variance Reports
- A variance report is an accounting report that compares actual and budgeted figures, highlighting variances (differences between the actual and budgeted amounts).
- Variance reports are prepared once the actual figures are available, but before the next budget.
- Variance reports are also known as performance reports, as they assess the firm’s performance in meeting its budget.
- This comparison is facilitated by the preparation of a variance report, an Accounting report that compares actual and budgeted figures, highlighting variances (differences between the actual and budgeted amounts) so that problems can be identified and corrected.
KEY TAKEAWAY: Variance reports are crucial for assessing a business’s performance against its budget and identifying areas needing improvement.
2. Cash Flow Statement Variance Report
- A Cash Flow Statement Variance Report compares actual and budgeted cash flows.
- It is similar in appearance to a Budgeted Cash Flow Statement, but with additional columns for actual figures and the calculation of the variance.
2.1 Structure of a Cash Flow Statement Variance Report
The report typically includes the following columns:
- Budget: The originally budgeted cash flow figures.
- Actual: The actual cash flow figures.
- Variance: The difference between the budgeted and actual figures (Actual - Budget).
- F/U: Indicates whether the variance is Favourable (F) or Unfavourable (U).
2.2 Determining Favourable vs. Unfavourable Variances
- A variance is favourable (F) if it means cash will be higher than expected in the budget.
- A variance is unfavourable (U) if it means cash will be lower than expected in the budget.
2.3 Example Cash Flow Statement Variance Report
| Item |
Budget |
Actual |
Variance |
F/U |
| CASH FLOWS FROM OPERATIONS |
|
|
|
|
| Cash Sales |
\$24,000 |
\$29,000 |
\$5,000 |
F |
| Receipts from Accounts Receivable |
\$11,000 |
\$8,000 |
(\$3,000) |
U |
| GST Received |
\$2,400 |
\$2,900 |
\$500 |
F |
| Payments to Accounts Payable |
(\$32,000) |
(\$30,000) |
\$2,000 |
F |
| Wages |
(\$8,000) |
(\$8,600) |
(\$600) |
U |
| Advertising |
(\$1,300) |
(\$1,100) |
\$200 |
F |
| GST Paid |
(\$1,530) |
(\$1,610) |
(\$80) |
U |
| Net Cash Flows from Operations |
(\$14,430) |
(\$10,410) |
\$4,020 |
F |
| CASH FLOWS FROM INVESTING ACTIVITIES |
|
|
|
|
| Office Equipment |
(\$5,000) |
(\$5,000) |
\$0 |
- |
| Net Cash Flows from Investing Activities |
(\$5,000) |
(\$5,000) |
\$0 |
- |
2.4 Uses of the Cash Flow Statement Variance Report
- Identifies areas where cash flow management is deviating from the budget.
- Helps determine if variances are due to poor budgeting or operational issues.
- Provides insights for making informed decisions to improve cash flow management.
- Facilitates better control over cash inflows and outflows.
EXAM TIP: When analyzing a Cash Flow Statement Variance Report, focus on the significant variances and explain the potential reasons behind them.
3. Income Statement Variance Report
- An Income Statement Variance Report compares actual and budgeted revenues and expenses.
3.1 Structure of an Income Statement Variance Report
The report includes:
- Budget: The originally budgeted revenue and expense figures.
- Actual: The actual revenue and expense figures.
- Variance: The difference between actual and budgeted figures (Actual - Budget).
- F/U: Indicates whether the variance is Favourable (F) or Unfavourable (U), based on its impact on profit.
3.2 Determining Favourable vs. Unfavourable Variances
- A variance is favourable (F) if it means profit will be higher than expected in the budget.
- A variance is unfavourable (U) if it means profit will be lower than expected in the budget.
3.3 Example Income Statement Variance Report
| Item |
Budget |
Actual |
Variance |
F/U |
| Sales Revenue |
\$100,000 |
\$110,000 |
\$10,000 |
F |
| Cost of Goods Sold |
(\$60,000) |
(\$65,000) |
(\$5,000) |
U |
| Wages Expense |
(\$20,000) |
(\$18,000) |
\$2,000 |
F |
| Rent Expense |
(\$5,000) |
(\$5,000) |
\$0 |
- |
| Net Profit |
\$15,000 |
\$22,000 |
\$7,000 |
F |
3.4 Uses of the Income Statement Variance Report
- Identifies areas of revenue and expense that deviate from the budget.
- Helps in understanding the reasons behind profit variances.
- Aids in making decisions to improve profitability.
- Useful in assessing the effectiveness of cost control measures.
COMMON MISTAKE: Students often confuse the classification of variances as favourable or unfavourable. Remember, it depends on the impact on cash flow (for Cash Flow Statement) or profit (for Income Statement).
4. Analyzing Trends
- Analyzing trends in variance reports involves examining variance reports over multiple periods to identify patterns and potential issues.
- Trends can highlight consistent overspending, declining sales revenue, or other significant changes in financial performance.
- This analysis helps in making more informed decisions and implementing proactive measures.
4.1 Identifying Trends
- Consistent Favourable Variances: Indicate areas of strong performance. Need to understand why, and whether the budget should be adjusted.
- Consistent Unfavourable Variances: Highlight areas needing attention and corrective action.
- Fluctuating Variances: May indicate instability or external factors affecting the business.
4.2 Example Trend Analysis
| Period |
Sales Revenue Variance |
Wages Expense Variance |
Net Profit Variance |
| Q1 |
\$2,000 (F) |
(\$500) (U) |
\$1,500 (F) |
| Q2 |
\$3,000 (F) |
(\$600) (U) |
\$2,400 (F) |
| Q3 |
\$4,000 (F) |
(\$700) (U) |
\$3,300 (F) |
- Trend: Sales revenue is consistently exceeding budget (favourable), while wages expense is consistently exceeding budget (unfavourable). Net profit is increasing.
- Implication: The business is generating more revenue, but wages are increasing. This requires further investigation to determine if the increased wages are justified by the increased revenue.
STUDY HINT: Create a table summarizing the variances across multiple periods to easily identify trends.
5. Ethical Considerations
- Budget Manipulation: Intentionally distorting budget figures to achieve targets or misrepresent performance is unethical.
- Misleading Variance Reports: Presenting variance reports in a way that conceals unfavourable variances or exaggerates favourable ones is unethical.
- Impact on Stakeholders: Unethical budgeting practices can negatively impact employees, suppliers, and other stakeholders.
VCAA FOCUS: VCAA exams often include questions that require students to analyze variance reports and suggest strategies to improve business performance, considering ethical implications.
- Cost Control: Implement measures to reduce costs in areas with unfavourable expense variances.
- Revenue Enhancement: Develop strategies to increase revenue in areas with unfavourable revenue variances.
- Budget Revision: Review and revise the budget based on actual performance and changing business conditions.
- Operational Efficiency: Improve operational efficiency to reduce costs and increase productivity.
REMEMBER: Accurately interpreting and acting upon variance reports is crucial for effective business management and decision-making.