Get a live snapshot view of your business finances

Premium

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.

>
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form. Please try again!

What are premium templates?

Premium Templates are advanced solutions for complex financial reporting tasks. Unlock a template for a one-time fee, which includes unlimited access and full support for template implementation. Book a demo above to learn more.

Compatible with

Excel

Google Sheets

Integrations

QuickBooks

Live data

LiveFlow

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: 

  • A Balance Sheet snapshot to monitor your assets and liabilities 
  • A summary overview of the Income Statement/P&L to monitor your Revenue, Cost of Goods Sold, Operating Expenses and Net Income or Loss
  • A summary Cash Flow analysis to monitor your Beginning and Ending Cash and Cash Burn
  • A variance snapshop to understand whether you’re on or off plan.

 

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. 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 

Get started in 3 simple steps

Google Sheets Logo

1. Import the template

1. Request access

Insert your email address above to gain access.

Book a demo of the template below to see the magic

See the template in a demoSee the template in a demo
LiveFlow Logo Icon

2. Connect LiveFlow

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

Connect to LiveFlow
Google Sheets Icon

3. Customize it

Customize the template into anything you like.

See how

Give the template superpower with live data from LiveFlow

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
How do I get access to this template?
FAQ ICON
Who built this template?
FAQ ICON
How long can I access the template for?
FAQ ICON
Can I get help if I need it?
FAQ ICON
Frequently Asked Questions
How can I gain access to a premium template?
FAQ ICON
Who built this template?
FAQ ICON
How long can I access premium templates for?
FAQ ICON
Can I get help if I need it?
FAQ ICON