How to Set Up and Use Budget vs. Actual Revenue Reports?
- Anna Branquinho |
- 17 steps |
- 2 minutes
Roomraccoon
1
Click "Finance" module.
2
Click "Revenue Groups" tab.
3
Click "+ ADD »"
4
Give your Revenue Group a name.
5
Click "SAVE"
6
Click "Ledgers" tab.
7
Link your revenue group to an existing ledger or create a new ledger to link the new ledger to a revenue group.
8
9
Click "SAVE"
10
Click "Reports" module.
11
Click "Yearly Metrics" tab.
12
Click "Budget vs Actual revenue" to view your actual revenue performance. This will show you either your total revenue or the revenue according to specified groups.
13
Located on the right of the “actual” revenue amount is an editable box where you can insert budgets or targets for forecasting and measuring your actual revenue.
14
The actual revenue will be measured against the budget and represented as a percentage on the right side of the budget. If the percentage is negative (e.g., 19.9%), the actual revenue has underperformed against the target. If the percentage is positive (e.g., 80%), then the actual revenue has exceeded the budget by that percentage.
Budgets can be edited anytime, and budgets can be set according to the month or revenue group.
How to use and read the Budget vs. Actual revenue report?
15
The year selected to forecast and measure is the existing year (2023). This can be changed in the year selector dropdown situated above the report.
16
The screenshot below shows that the report displays the total revenue, the room revenue (a revenue group), and the beach bar’s (another revenue group) performance over January and February of 2023.
By setting a budget for each month (a target), you can measure the changes in revenue performance over the months of a year.
17
For example, if we look at the total revenue for February 2023, a budget (target) has been set for R323, 950, 40. The “actual” revenue performance was just over R40 million meaning the hotel overperformed by roughly 28 percent.
