How to Use Google Sheets Refresh Filter

October 24, 2021

How to Use Google Sheets Refresh Filter

Are you wasting hours manually refreshing data in Google Sheets and finding it time-consuming to manually update your financial data in Google Sheets? Good news for you then: It’s all over. 

A few weeks ago, we announced the beta launch of our Google Sheets Add-on, which connects your QuickBooks with your Google Sheet in seconds. 

Today, we are happy to share that we have launched automatic refresh functionality! This means that you can automatically update Google Sheets by pulling any financial report from your QuickBooks, so you don’t have to waste hours manually updating your numbers. 

Here are a few examples of situations where you might find it handy

1) Consolidated Profit & Loss (P&L)

We know how painful it can be to manually prepare and update your Consolidated Profit & Loss report every month. That's why we're here!

With the LiveFlow Add-on, you can import your P&L from unlimited entities to see a Consolidated P&L report that refreshes on your schedule, check an example below.
More on how to do that here: free Consolidated P&L template.

Save hours formatting your next financial spreadsheet!
100+ templates, all free to use.
Free Spreadsheet Templates

2) P&L Budget vs. Actuals

Spending too much time manually updating Actuals? We got you. 

Create your P&L budget in your Google Sheet, exactly as you are used to, or if you want some inspiration, feel free to check out our free P&L Budget vs. Actuals Template here.

Once you have set up your budget, install LiveFlow Google Sheets Add-on and pull actuals from QuickBooks in a snap like in the spreadsheet below. All it takes is a quick connection from Google Sheets to QuickBooks, and you are ready to go.

Need a hand setting up your formulas? Book a free call with us here

Sheets tutorials availalble now in our free certificate program!
Learn basic and intermediate functions with digestible videos and instructions.
Enroll in LiveFlow Academy

Why automating your financial workflows is a must?

There is no doubt that the finance function is rapidly changing. Gone are the days where the finance team was a siloed part in the office corrner that only interfered with the rest of the business when they had to approve budgets or chase employees for missed receipts.

Automation is paving the way for the new modern finance team, where non-value-adding manual work will soon be a thing of the past. Modern finance teams should be crucial business partners, they should understand how a Marketing P&L works, how to manage CAC, LTV, and payback period, and they should spend less time manually pulling together numbers and more time analyzing them and helping the business move forward.

Automating your workflows, especially those tedious, manual spreadsheet tasks that require you to move data back and forth manually, is one of those that should be gone from your task list immediately. 

That way, you’ll have more time to focus on what matters for you and your business.

Learn how LiveFlow can save you hours a month on financial reporting!
Just 30 minutes can change the way your business operates forever.
Book a Demo

The Ultimate Google Sheets Hack... to sync QBO with Sheets.
Seriously, it's game-changing.
Book a demo

Continue reading

Set your financial reporting on autopilot. Goodbye manual work.

Eliminate manual data entry and create customized dashboards with live data.