Reports

How to automate Budget vs. Actuals

SHARE THIS Article

  1. Import your P&L from QuickBooks and choose Display-by: Month.

  2. Inside the P&L report, create budget columns in between your actuals columns.

  3. Insert your budget values.

  4. Reload your spreadsheet and your actuals will update 100% automatically, in the right cells of course!

We explain it much better in the video below, so go check that out! The magic happens at 2.45 min.👇



Supercharge your financial reporting

LiveFlow is an agent of Plaid Financial Ltd. (Company Number: 11103959, Firm Reference Number: 804718), an authorized 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 authorized 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 authorized 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 authorized 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.