How Operating Expenses is calculated in Aider

Operating Expenses =
Total Operating Expenses, as per the Profit and Loss report

% change =
( selected period - comparison period ) / comparison period x 100%

 


DATA SOURCE - Xero Profit and Loss report:

  • All reconciled Operating Expenses to date including all Overhead and Expense accounts.

Revenue for the selected month / quarter:
OpEx_DataSource-monthly

  Aider amounts Xero data source:
Reports - Profit and Loss
Total for selected month / quarter Amount from Xero
(Box 1)
Date range: Last month / quarter OR Custom date range (selected month / quarter)
% change vs same month / quarter last year Calculated based on Xero amounts.
(Box 1 + Trends paragraph 1)
Compare with: 1 year
% change vs prior month / quarter Calculated based on Xero amounts.
(Trends paragraph 1)
Compare with: 1 month / quarter

Revenue for financial year to the selected month / quarter:
OpEx_DataSource-YTD

  Aider amounts Xero data source:
Reports - Profit and Loss
Total for FY to selected month / quarter Amount from Xero
(Box 2)
Date range: Custom date range
(This financial year > change end date to end of selected month / quarter)
% change vs same period last year Pre-calculated for you based on Xero amounts.
(Box 2 + Trends paragraph 2)
Compare with: 2 years
% change vs same period 2 years ago Pre-calculated for you based on Xero amounts.
(Trends paragraph 2)
Compare with: 2 years

 


FAQ’s:

Q: What is the total Operating Expenses figure made up of? 

A: This is made up of all reconciled transactions from the period that are coded to the account types “Expense” and “Overhead”, per the chart of accounts setup in Xero.
OpEx_ChartOfAccounts

Q: Why doesn’t the data match the client’s Total Operating Expenses?

A: We pull data directly from the monthly and financial year Profit and Loss report and related Operating Expenses account types overnight. If data has just been updated in the Xero file, please resync the client to update the data in Aider by clicking icon_resync_20x20.

Q: Why does the reconciliation status show an Unreconciled alert when the file is up to date?

A: We pull Xero data overnight and if data has been recently reconciled, then please resync the client to update the data in Aider by clicking icon_resync_20x20.

Q: Can I exclude some Overhead and Expense accounts from the total Operating Expenses for a client?

A: Not currently. But this is something we are working on and will build in future.