How to Use Google Sheets Refresh Filter

October 24, 2021

Fixing a robot

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.
More on how to do that here: free Consolidated P&L template.

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’s add-on and pull actuals from QuickBooks in a snap. 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

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. 




Continue reading

Bring financial data into Google Sheets. Fast.

Try out our Google Sheets Add-On and bring your P&L, Balance Sheet and Cash Flow into Google Sheets in no time.

Capterra & LiveFlow
G2 & LiveFlow Reviews
LiveFlow reviews on Product Hunt
Check it out!