G-Accon Help Center

Release updates for G-Accon for Xero/QuickBooks

SECTIONS IN THIS ARTICLE

G-Accon for Xero: Changes and Enhancements released in February, 2024
G-Accon for QuickBooks: Changes and Enhancements released in February, 2024
Watch latest videos in G-Accon Integration channel

G-Accon for Xero: Released Changes and Enhancements

Enhancements in Edit Templates for Current Sheet

1. Edit Template: This option allows users to make modifications to the existing template, such as changing filters, adding or removing attributes, or adjusting layouts.
   
2. Refresh Template: This option updates the template with any changes made to the underlying data or any modifications made to the template itself, ensuring it reflects the most recent/updated information.
   
3. Create Cloud Template: Users can save a template in cloud, which can be shared, accessed and utilized by multiple users or across the team. This promotes collaboration and ensures consistency in templates/workspace settings.
   
4. Duplicate Template: This option creates a copy of the existing template, allowing users to experiment with changes or create variations without altering the original template.
   
5. Delete Template: Users can remove the existing template if it's no longer needed or if they wish to start from scratch. This action permanently deletes the template, so caution should be exercised.
   
   
   
   At the bottom of the "Edit Template for Current Sheet" users will find several options including Close, Refresh Data, and a Blue icon with stripes.
   

Close: This option allows users to exit or close the template editing window "Edit Template for Current Sheet" and return to the regular view.

Refresh Data: Users can use this option to update the data displayed in the template or templates to reflect any changes made to the underlying dataset since the template was last edited or refreshed.

Blue icon with stripes: This icon enables the Sticky Float Side Menu on the right.

G-Accon for QuickBooks: Released Changes and Enhancements

1. New Consolidated Reports by Organizations
   
   In a nutshell, consolidated reports are financial statements that combine the financial information of a parent company with its subsidiaries.

These reports provide a comprehensive view of the financial performance and position of the entire corporate group rather than just individual entities.

Consolidated reports typically include consolidated balance sheets, income statements (profit and loss), and cash flow statements, providing stakeholders with a holistic understanding of the group's financial health and performance.

These reports are important for investors, creditors, regulators, and other stakeholders to assess the overall financial strength and stability of the corporate group.

Consolidated Balance Sheet By Company: This financial statement provides a snapshot of a company's financial position at a specific point in time by consolidating the financial information of the parent company and its subsidiaries. Balance Sheet By Company report includes assets, liabilities, and shareholders' equity, offering a comprehensive view of the group's financial health and you can see it in pivot table with the Companies as columns.

Consolidated Cash Flow By Company: This financial statement tracks the cash inflows and outflows of a company and its subsidiaries over a specified period. It categorizes cash flows into operating, investing, and financing activities, helping stakeholders understand how cash is generated and used within the entire corporate structure.
Again the output will be in a pivot table format with the Companies as columns.

Consolidated Profit and Loss By Company: This financial statement summarizes the revenues, expenses, gains, and losses of a company and its subsidiaries over a specific period. It provides insight into the overall profitability of the group by consolidating the financial performance of all entities under the parent company's control.

2. New "Look and Feel" for "Get Accounting Data"

New Look and Feel has been introduced for all raw data downloads are located under Get Accounting Data

This option is available under Extensions --> G-Accon for QuickBooks --> Get Accounting Data/Reports --> Get Accounting Data

To get Accounting Data from QuickBooks:

• Go to the menu and select "Extensions" -->
• Choose "G-Accon for QuickBooks" -->
• Click on "Get Accounting Data/Reports" --> "Get Accounting Data"
• Select a specific table/object
  
  

How to design a template to get raw accounting data?

select the object (table) and the fields to get data

• Select table, for example, Invoices 
• Choose needed attributes based on your preferences/needs
  

Select All or Unselect All attributes for the chosen table.

Expand All Fields the object’s structure to see all underlining attributes or Collapse All Fields.

Change Column Order. During the manual or automated refresh, the order will stay as you defined it.

Dynamic Date Range: The report data will be calculated based on pre-populated values like This Month, This Quarter, This Year, Last Month, etc.

Static Date Range: Define specific start and end dates.

Custom Date Range: Utilize cell references in your Google Sheet to set custom dates.

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:

1. Create a new Google Sheet: Generate a new spreadsheet within Google Sheets.
2. Enforce pick list values: Ensure that the values retrieved adhere to a predetermined list.
3. Create a deep link to QuickBooks: Generate a hyperlink that provides direct access to specific content within QuickBooks.
4. Freeze Data Table Header: Fix the header row of a data table in place for consistent visibility.
5. Keep Original Formatting: Preserve the original formatting of the data being pulled.
6. Retrieve headers: Fetch the headers or column names associated with the data.
7. Create a Data Table around pulled data: Establish a structured data table based on the retrieved information.
8. Display Date Range: Specify and showcase a particular range of dates associated with the pulled data.
9. Ignore Empty Cells in "Filter by IDs": Disregard any vacant cells within the "Filter by IDs" parameter during the data retrieval process.
10. Highlight Every Other Rows: Apply a formatting style to alternate rows to improve readability.
11. Append to the Previous Templates: Add the newly retrieved data to existing templates, ensuring continuity in record-keeping or analysis.
12. Add Organization Name Column: Integrate a column specifically for company names into the data structure.

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