Arrow left
Back to guides
Reports

How To Add a Variance Column in a P&L report?

Here's how to add a variance column to your Profit & Loss report in a snap:

  1. Import a Profit & Loss report to your Google Sheet
  2. Add a Budget column inside of your Profit & Loss report (it will not break when you refresh your data)
  3. Add a variance column inside of your Profit & Loss report (it will not break when you refresh your data)
  4. Add a variance column inside of your Profit & Loss report (it will not break when you refresh your data)
  5. Add your variance formula (budget - actuals)

Done!

Remember that you can add any columns and rows directly inside your live reports with LiveFlow giving you full flexibility over your reports and your live data.

Learn how to do this step-by-step in the video below 👇

Automate financial reporting with LiveFlow

Want to eliminate manual updates of your Excel & Google Sheets models?

Yes, show me how

Need help?

Our team is here to help you any time between 9am and 10pm EST.
Check Icon
Email us at: help@liveflow.io

Liked this article? Then you'll love the ones below

No items found.