Explore step-by-step guides, troubleshooting tips, and best practices to make the most of G-Accon. Whether you're setting up integrations, automating reports, or optimizing workflows, our help center has everything you need to succeed.
Click on “Get Accounting Data/Reports” –> “Get Accounting Data“
Select Recurring Invoice
Export Recurring Bills into Google Sheets
How to design a template for the report?
select the object (table) and the fields to get data
Select table
Choose needed attributes based on your preferences/needs
Select All or Unselect All attributes for the chosen table.
Expend All Fields the object’s structure to see all underlining attributes or CollapseAll Fields.
Change Column Order. During the manual or automated refresh, the order will stay as you defined it.
Change Pull Settings
Change Pull Settings refers to a set of operations that can be executed to modify the parameters of data retrieval.
These operations include:
Create a new Google Sheet: Generate a new spreadsheet within Google Sheets.
Enforce pick list values: Ensure that the values retrieved adhere to a predetermined list.
Create a deep link to QuickBooks: Generate a hyperlink that provides direct access to specific content within QuickBooks.
Freeze Data Table Header: Fix the header row of a data table in place for consistent visibility.
Keep Original Formatting: Preserve the original formatting of the data being pulled.
Retrieve Headers: Fetch the headers or column names associated with the data.
Create a Data Table Around Pulled Data: Establish a structured data table based on the retrieved information.
Display Date Range: Specify and showcase a particular range of dates associated with the pulled data.
Ignore Empty Cells in “Filter by IDs”: Disregard any vacant cells within the “Filter by IDs” parameter during the data retrieval process.
Append to the Previous Templates: Add the newly retrieved data to existing templates, ensuring continuity in record-keeping or analysis.
Add Company Name Column: Integrate a column specifically for company names into the data structure.
Highlight Every Other Rows: Apply a formatting style to alternate rows to improve readability.
Exclude from Auto Refresh: The specific templates will remain unchanged and won’t be updated automatically
Specify the start cell, e.g., A11, and enter the template name in the designated field, such as “Template Name #1.” Click the “Execute” button to initiate the process, populating the report directly into the Google Sheet.
Select the field to filter by
Choosing the filtering fields enables you to filter data based on the selected fields/criteria.
Filter By Field. Only rows that meet the filter criteria will display and other rows will be hidden
Filter By IDs. Conditional filtering involves using object/table IDs to filter data
Order Results By
Order Results By filters allows you to order your result by field in the Descending/Ascending order
How to schedule automatic data refresh?
To schedule automatic data refresh, follow these steps:
Create a workflow by selecting the “Automation” menu option –> “Create Workflow” option.
In this workflow, you can set up auto-refresh and notification processes.
Automatic workflows allow you to create various workflows, add specific templates, and set different schedules for each workflow.
You can also notify customers, clients, and team members with various automatic notifications, all within the same spreadsheet.
For more details, refer to the “Create Workflow” documentation here.
How modify your report and update your template?
During the refresh process, if you need to modify your report, follow these steps:
Click on “Extensions” in the menu.
Choose “G-Accon for QuickBooks“
Select “Edit Templates for Current Sheet“
To Refresh and Modify a template there is no need to be signed in into the organization
Select the template, make the necessary changes to it and Update the template or Update and Execute the new query.
To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional
Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes.The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.