All Collections
Reports
How to Automate Budget vs. Actuals
How to Automate Budget vs. Actuals

How to get live Actuals into your Google Sheet

Sahaj Singh avatar
Written by Sahaj Singh
Updated over a week ago

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.πŸ‘‡

Did this answer your question?