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:
The company name
The start date
The end date
Columns to include
Refresh on change ( we recommend setting this to TODAY(). That way you data will automatically be updated daily)