Contents x
    How do I change the sign of my revenue or expense account for budget to actual financial reports?
    • 26 Jan 2023
    • Contributors
    • Print
    • Dark
      Light
    • PDF
    Contents

    How do I change the sign of my revenue or expense account for budget to actual financial reports?

    • Updated on 26 Jan 2023
    • Contributors
    • Print
    • Dark
      Light
    • PDF
    Article summary

    My financial reports are showing negative variances when they should be positive (or vice versa).  How do I set it up so that they show properly?

    Answer:

    In a budget to actual report where you utilize a column format formula for ‘variance’ – with the calculation being your budget column variable minus your actual column variable – the resulting variable will show as negative when expenses are higher than budget

    However, when revenues are higher than budget, they also show as negative, To show revenue budgets as positive numbers in reports, enter negative budget figures.

    Was this article helpful?
    What's Next