Back to guides

How to automate Budget vs. Actuals

  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.👇

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

Automate financial reporting with LiveFlow

Cta Photo

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:

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

No items found.