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

Import large amounts of QuickBooks transactions to G-Sheets with Live Functions

Here's how to import tens of thousands of transactions from QuickBooks into G-Sheets or Excel with LiveFlow.

Live Functions in LiveFlow

What are Live Functions all about?

Live Functions are custom-built Google Sheets functions, managed by LiveFlow, that give your spreadsheet superpowers. You can use Live Functions just like you use any other functions in your Google Sheets formulas, but, while most functions just let you manipulate data already in your sheet, Live Functions allow you to load live data (tons of it!) right from QuickBooks, in just a few keystrokes.

Which Live Functions can I use today?

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

This function does exactly what it says on the tin: it allows you to load all of a company’s transactions within a given date range.

Under the hood, it uses the Transaction Detail report (without any grouping), so you can expect to see the transactions ordered by date.

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

This function works in the same way as LF_QUICKBOOKS_TRANSACTIONS, but uses the Transaction List with Splits report (without any grouping) under the hood, so you can expect to see the transactions ordered by date.

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

This function works in the same way as LF_QUICKBOOKS_TRANSACTIONS, but uses the General Ledger report under the hood.

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

How do I use these Live Functions?

💡 NOTE: 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: in the below example this is “Demo Acme‘‘
  2. The start date: in the below example, this is “1/23/2021‘‘
  3. The end date: in the below example, this is “4/5/2021‘‘
  4. Columns to include: In this argument you specify which columns to include, for instance “Date, Name, Account, Amount‘‘
  5. Refresh on change: This argument determines when to refresh your data. We recommend setting this to TODAY(). That way your data will automatically be updated daily.

Live Functions in LiveFlow

Try Live Functions with our template

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.