All Collections
What are LiveFlow database reports?
What are LiveFlow database reports?

Database reports allow you to import reports with up to 100,000 rows in Google Sheets.

Lasse Kalkar avatar
Written by Lasse Kalkar
Updated over a week ago

Database reports work just like any other LiveFlow report, with two major differences:

  1. They support reports with up to 100,000 rows *

  2. In any of your own columns, your formulas will be automatically copied from the first cell to all other rows of the report – no more copy/pasting when new rows are added!

* QuickBooks itself caps reports at a total of 400,000 cells, so a report with 100,000 rows implies that it has four columns: a report with eight columns would allow 50,000 rows, etc.

When should I use them?

  • If you work with large reports from QuickBooks, and you use those reports primarily as a "database", i.e., you are mostly interested in deriving data from these reports quickly and reliably

  • If you find yourself repeatedly copying formulas to new rows, or often reaching for ARRAYFORMULA

  • If you are using our Live Functions to load transaction data, you should try these instead

  • If you have been loading large reports (1,000+ rows) using LiveFlow, but you've been frustrated with the speed or reliability of refreshing those reports, you should try enabling this option

What are the drawbacks?

  • You should not insert your own rows in these reports, because all rows are cleared and replaced during refresh

  • These reports don't include links back to QuickBooks online, so they won't support Drill Down

  • We don't apply padding for indentation in the first column, and we don't automatically assign collapsible row groups either

How can I use them?

  • The option will be enabled by default for new detailed reports like General Ledger, Transaction Detail and Profit and Loss Detail

  • You can toggle the option from the Advanced settings on both new and existing reports

  • You can spot a report where the option is enabled from the blue column headers

Did this answer your question?