How to automate Budget vs. Actuals
Import your P&L from QuickBooks and choose Display-by: Month.
Inside the P&L report, create budget columns in between your actuals columns.
Insert your budget values.
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.👇