LiveFlow raises $13.5 million Series A led by New York-based Valar Ventures and launches LiveFlow Next to revolutionize finance!
Read More
Arrow
Back to guides
Reports

How to Show Accounts with Zero Values/Activity in LiveFlow

Here's how you can show accounts with zero values/activity in your live report from QuickBooks with LiveFlow.

  1. Import your report from QuickBooks to Google Sheets with LiveFlow
  2. This can often be your Profit and Loss report
  3. Create a separate sheet and copy/paste all of your accounts from your Profit & Loss
  4. Add the accounts that are not showing up by creating additional rows in your new sheet
  5. Now, use the Index/Match formula to automatically pull in accounts from your underlying Profit and Loss report
  6. When your Profit and Loss report from QuickBooks updates and those accounts that previously had zero values now has values, those will automatically be pulled into your dashboard.

We explain it step-by-step in the video below!

Learn how to do this step-by-step in the video below 👇

Automate financial reporting with LiveFlow

Cta Photo

Want to eliminate manual updates of your Excel & Google Sheets models?

Yes, show me how!

Get personal help

We guarantee you personal help on chat or Zoom within maximum 6 hours between 9am and 10pm EST.
Blue Tick
Email us at: help@liveflow.io

Liked this article? Then you'll love the ones below

No items found.

Supercharge your financial reporting today

See LiveFlow in action and discover how to streamline your workflows.

Book a demo