Skip to main content
Account Variance

Data Area to help solve account movement Questions

Aaron Wittman avatar
Written by Aaron Wittman
Updated over 3 months ago

Account Variance

Explore the significance of any account. This uses the Profit and Loss Data and calculates the variance between accounts based on each month.

You can use this over the Profit and Loss section to display the exact account that matches the condition.

Profit and Loss should be used to build XBerts on Revenue and Expenses.

The AI will only look back at 12 months' worth of data.
​
​Key Properties:

  1. Account Name: The name representing the financial account in the report. e.g., "Operational Expenses"

  2. Variance Amount: The dollar amount representing the difference between expected and actual figures, identifying discrepancies. e.g., "$2,000 under expected."

  3. Variance Percentage: The percentage that illustrates the relative difference between expected outcomes and actual figures. e.g., "5% over projections."

  4. Account Code: A numeric or alphanumeric code that categorises the financial account. e.g., "502"

  5. Standard Classification Name: The classification type of the account is based on standard accounting practices. e.g., "Revenue"

  6. Amount: The total amount factored into the profit and loss calculation. e.g., "$5,000"

  7. Report Date: The date the report was compiled or to which the data pertains. e.g., "September 30, 2023"

πŸ“ Example Alerts

Setup an alert for account name containing suspense if it is greater than 0 and it is not the current month.
Alert me when rent drops by 30% and is not the current month.
Let me know when any expense account increases by 20%.​
Did this answer your question?