Get a live snapshot view of your business finances

Flash Report Template for Google Sheets and Excel

Flash Reports are used by finance professionals, business owners and C-level executives to quickly grasp the company’s crucial metrics. This template is created by Flash Report by LiveFlow & GrowthLabFinancial.

Compatible with

Excel

Google Sheets

Integrations

QuickBooks

Live data connector

LiveFlow

How to duplicate this template?

1. Go to File

2. Click on Make a copy

Flash Report Template for Google Sheets and Excel
LIVEFLOW ON AIR
Live Icon

Learn how to set up this template in the video below

Arrow down

Why use Monthly Flash Reports?

Bookkeepers, Accountants, CPAs as well as Fractional CFOs become better advisors to their clients and save hours of time of manual work with Flash Reports. C-suite and Business Owners, in their turn, can compare their performance month-to-month, same period last year, or each individual month this year to last year. 

Flash Reports are irreplaceable to spot threats and opportunities for companies of all sizes. It’s is the tool you can use to prevent problems ahead of time and make your company more successful.

Flash Report Template

Below you will find a Flash Report template developed by GrowthLab Financial, a Finance as a Service company that serves Founders and Management Teams with Financial Planning & Analysis, Bookkeeping, Accounting, Virtual CFO, and Tax Advisory & Planning Services. 

This report was first presented by GrowthLab’s Director of Corporate Development & Strategy Korey Cournoyer during The Appy Hour Webinar hosted by certified QuickBooks ProAdvisors Liz Scott and Heather Satterley

What’s included in the monthly flash report?

The Flash report consists of 5 different areas: 

 

Check the webinar with a step-by-step video instruction here starting from 57:28 min.

To create a Flash Report, you will use Profit & Loss, Balance Sheet and Cash Flow reports from QuickBooks Online.

How do I build a Flash Report for myself?

  1. Open this template and make a copy. This is your playground to set up your own Flash Report.
  1. Install LiveFlow Google Sheets Add-on to automatically bring your QuickBooks reports into Google Sheets without any manual work.

  2. Import your Profit & Loss, Balance Sheet and Cash Flow reports to your spreadsheet.


Profit & Loss report instantly imported from QuickBooks Online with LiveFlow
Profit & Loss report instantly imported from QuickBooks Online with LiveFlow 

  1. Now, copy and paste essential Account Names from your Chart of Accounts from Profit & Loss, Balance Sheet and Cash Flow into your own Flash Report tab. Then choose the months you want to compare, for example, March 2022 to March 2021. Paste these months’ names for your reports.

 

  1. Set up the formulas. Click on a numerical value in the original Flash report tab and find the formula in C6 of Balance Sheet. There you will find “Horizontal LOOKUP (=HLOOKUP)”.

= HLOOKUP(search_key, range, index, [is_sorted])

It searches across the first row of a range for a key and returns the value of a specified cell in the column found.

This formula will grab your month as a search_key and then will look at the entire account & month range from the Balance Sheet. Then you need to specify the row index of the value to be returned and set up the [is_sorted] status as FALSE to get an exact match returned. 

You can copy and paste this formula from the template:

 

=HLOOKUP(C$4,'Balance Sheet by Month'!$A$10:$R$28,6,false)

 

  1. Now, replace the value inside the quotation marks identifying your Balance Sheet. 

    In our example, the sheet tab is named Balance Sheet by Month, so all you have to do is to rename those to your own names, and then take the name you added and add replace that in the 'Balance Sheet by Month' string.
  2. Then, do that everywhere you find the Balance Sheet by Month, Profit & Loss by Month and Cash Flow by Month in the formula.

  3. Once done, make sure you change the index to reference the correct row index for your account names.

  4. The final bit is to calculate your Variance Snapshots. Compare your Actuals vs Annual Operation Planning (AOP) and see whether you’re over or under delivering by deducting Actuals from AOP and looking at the percentage value.

Variance Snapshot
Variance Snapshot from Flash Report by GrowthLab Financial 

  1. Once the formulas are set up, double check they are working correctly by cross-referencing the numbers in your Flash Report with the numbers in each of your tabs.

  2. Done! Now, you can invite other people to view and comment on the Flash Report. Or you can publish the Report to web to share it as a live, auto-updated dashboard with necessary stakeholders.

Live Flash report dashboard
Flash Report presented as a live dashboard

 

Need personal help? Book a call with our team here

 

You can find more free templates such as Consolidated P&L, Marketing P&L, Budget vs Actuals, P&L MoM by Class and others in the LiveFlow Template Library.

To create live Flash Reports that will automatically update the Profit and Loss, Balance Sheet and Cash Flow reports, install LiveFlow for free here.

 

Get started in 3 simple steps

Google Sheets Logo

1. Copy the template

Open the template. Click on File, then click Make a copy and save it to your drive.

Open the template
LiveFlow Logo Icon

2. Connect LiveFlow

Connect your spreadsheet to LiveFlow, so you can import live data to your template.

Connect to LiveFlow
Google Sheets Icon

3. Make it truly yours

Personalize the template and connect live data so you don't have to update it manually.

See how

Wasting time on manually importing data?

Join hundreds of accountants and finance teams automating their workflows with LiveFlow and saving hours of work every week

Flash Report

Flash Reports are used by finance professionals, business owners and C-level executives to quickly grasp the company’s crucial metrics. 

Frequently Asked Questions
Is the template free?
FAQ ICON
Who built this template?
FAQ ICON
Can I share this template?
FAQ ICON
Can I get help if I need it?
FAQ ICON