All Collections
QuickBooks
How do I extract all transactions from a particular General Ledger or General Ledger Type?
How do I extract all transactions from a particular General Ledger or General Ledger Type?

Import large volumes of data in Google Sheets with Live Functions

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

When importing a General Ledger from QuickBooks into Google Sheets, most times, it is a large volume of data.

LiveFlow has built a custom function in Google Sheets called Live Functions, that allows you to load live data in just a few clicks.

To import your General Ledger, use the formula below:

=LF_QUICKBOOKS_GENERAL_LEDGER_TRANSACTIONS(company_name, start_date, end_date, columns_to_include, refresh_on_change)


The General Ledger report is grouped by account, so the results will be ordered by account, and then by date. We leave our the group headers and subtotals though, so you'll just get the transactions.

How do I use these Live Functions?

In order to use these Live Functions with your chosen company in a given spreadsheet, you must first import a report for that company in the same spreadsheet.

The function arguments include:

  1. The company name

  2. The start date

  3. The end date

  4. Columns to include

  5. Refresh on change ( we recommend setting this to TODAY(). That way you data will automatically be updated daily)


โ€‹

Did this answer your question?