Here's how to import tens of thousands of transactions from QuickBooks into G-Sheets or Excel with LiveFlow.
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.
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.
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.
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.
💡 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:
Learn how to do this step-by-step in the video below 👇