Profit and loss - actual vs budget report

How to compare your actual profit and loss figures with your budget report in Sage Accounting.

You can match your profit and loss against your budget. This lets you see how your actual financial outcomes compare to what you had budgeted for the same period.

Compare your actual income and spending against your budget. you can then see which areas of your business are over or underperforming. Knowing these differences is crucial for making informed decisions about future budget planning and business strategies.

Run the report

1. Go to Reports, then All reports.
2. Go to the section Financial budget reports.
3. Select Profit and loss - actual vs budget.
4. Choose one of the default views, or customise your view.

---

Report views

This report has two set report views:

• Actual Comparison - Compare your current month and year to date actuals to your budget
• Actual Budget Prior - View current month and year to date totals for your actuals budget and prior year

Select the report view using the dropdown on the top right.

You can also customise your own report views by adding filters, format rows and columns. See more below. 

---

Report settings

If required, you can change report settings to choose how your balances, nominal codes and accounts show.

---

Change date range

1. Select Change date range.
   
2. Select the date range you want to view.
   Choose from the date ranges available.
3. Select Run report.

---

Show accounts

By default, Show accounts is on, so the report shows your ledger accounts.

To change it, you can slide the toggle.

What are the differences between summary view on and off?

• Show accounts ON - Shows every ledger account that you’ve entered a budget figure in any of the months
  
  NOTE:

  Any ledger accounts with a zero figure for every month won't appear.

•  

  Show accounts OFF - Displays the totals by ledger category instead of showing every ledger account

---

Save the current view

If required, you can save your report view to use again.

---

Export

You can export the report in either CSV, PDF or Excel format. 

1. Go to Share.
2. Select Export and choose the format you want. 
3. Depending on your browser, your device will either download the report automatically or prompt you to choose a save location.