Reports

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

SHARE THIS Article

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.

LiveFlow is an agent of Plaid Financial Ltd. (Company Number: 11103959, Firm Reference Number: 804718), an authorised payment institution regulated by the Financial Conduct Authority under the Payment Services Regulations 2017. Plaid provides you with regulated account information services through LiveFlow as its agent.

© LiveFlow. All rights reserved.

LiveFlow is an agent of Plaid Financial Ltd. (Company Number: 11103959, Firm Reference Number: 804718), an authorised payment institution regulated by the Financial Conduct Authority under the Payment Services Regulations 2017. Plaid provides you with regulated account information services through LiveFlow as its agent.

© LiveFlow. All rights reserved.

LiveFlow is an agent of Plaid Financial Ltd. (Company Number: 11103959, Firm Reference Number: 804718), an authorised payment institution regulated by the Financial Conduct Authority under the Payment Services Regulations 2017. Plaid provides you with regulated account information services through LiveFlow as its agent.

© LiveFlow. All rights reserved.

LiveFlow is an agent of Plaid Financial Ltd. (Company Number: 11103959, Firm Reference Number: 804718), an authorised payment institution regulated by the Financial Conduct Authority under the Payment Services Regulations 2017. Plaid provides you with regulated account information services through LiveFlow as its agent.

© LiveFlow. All rights reserved.