G-Accon Help Center

Generate Multi-Entity and Multi-CurrencyBalance Sheet with Intercompany Eliminations with Intercompany Eliminations from QuickBooks into Google Sheets

SECTIONS IN THIS ARTICLE

✅ Design Template
✅ Schedule Automatic Refresh
✅ Modify Template
✅ YouTube Videos

Generating Consolidated Profit And Loss Report:

• Go to the menu and select "Extensions"
• Choose "G-Accon for QuickBooks".
• Click on "Get Accounting Data/Reports"
• Select "Consolidated Reports"

How to design a template for the report?

• Select "Consolidated Reports"

• Select the required QuickBooks Organizations/Entities

• Choose "Balance Sheet with Intercompany Eliminations" report from dropdown box.

SELECT PARAMETERS

There are required and optional attributes for the Balance Sheet with Intercompany Eliminations report.

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.

REQUIRED ATTRIBUTES

Compare To (required)

To Compare with (###) previous periods — specify the number of prior periods to include as comparison columns.

Sort Previous Periods — choose how to sort prior period data in the report.

Report Layout (Traditional/Historical) — The Historical layout option converts your data report into a flat file suitable for any BI software such as Looker, MS Power BI, Tableau, etc.

Traditional Layout

A standard Profit And Loss format that presents revenue, costs, and expenses over a specific period to show net profit or loss. It summarizes key financial performance metrics, enabling businesses to evaluate profitability and operational efficiency.

Historical Layout

The Historical Profit And Loss format is structured to support trend analysis and multiple-period comparisons, making it particularly useful for financial planning and analysis (FP&A) as well as Business Intelligence (BI). Each line item includes columns for individual periods, typically presented quarterly or annually, to allow for easy comparison across time.

Elimination Set

An Elimination Set needs to be created under G-Accon for QuickBooks in the Tools → Intercompany Eliminations section in order to be used when generating consolidated reports.

Elimination Settings

The Elimination Settings options are:

• Exclude Eliminated Transactions: This option excludes transactions that have been eliminated from the dataset and identify in the Elimination Set
• Only Eliminated Transactions: This option includes only transactions that have been eliminated from the dataset and define in the Elimination Set
• Exclude Eliminated Transactions (Separate Column): This setting excludes transactions that have been eliminated from the dataset, define in the Elimination Set, and presents them in a separate column for clarity or further analysis.
• Include Eliminated Transactions (Separate Column): This setting includes transactions that have been eliminated from the dataset, define in the Elimination Set, and presents them in a separate column for clarity or further analysis.

SETTINGS / PREVIEW

The Settings/Preview tab gives you fine-grained control over how report data is presented in your Google Sheet. All settings are optional and can be combined to suit your reporting workflow:

• Create a New Google Sheet — output the report into a new tab rather than the current sheet.
• Display Report Title — include the report name as a header row in the spreadsheet.
• Retrieve Headers — display column titles above your data.
• Display Only Account Codes — show account codes in place of full account names.
• Freeze Data Table Header — lock the header row so it remains visible when scrolling through large datasets.
• Create a Data Table Around Pulled Data — wrap the output in a structured Google Sheets table for easier filtering and sorting.
• Keep Original Formatting — preserve the formatting applied in QuickBooks rather than using G-Accon's default style.
• Remove Empty Dividing Rows — strip out blank rows that QuickBooks uses as section separators, giving a cleaner output.
• Display Fully Qualified Names — show complete account or item names including parent hierarchy.
• Only Data Rows — exclude subtotal and summary rows, returning only raw line-item data.
• Only Report Summaries — show only subtotal and summary rows, hiding individual line items.
• Create Deep Links to QuickBooks — add clickable links in the sheet that open the corresponding transaction or account directly in QuickBooks.
• Highlight Every Other Row — apply alternating row shading to improve readability across wide reports.
• Append to the Previous Template — add new data below an existing report rather than overwriting it.
• Add Company Name Column — prepend a column with the company name, useful for multi-entity reporting.

You can also specify a Start Cell (e.g. A1) to control exactly where in the sheet the report is placed, and assign a Template Name (e.g. Template Name #1) to identify the report when managing multiple templates in the same spreadsheet.

MULTI-CURRENCY CONVERTER

If you need to generate your Profit & Loss report in a currency other than your QuickBooks base currency, the Multi-Currency Converter tab lets you select a target currency and choose how exchange rates are applied.

Three options are available:

Use Latest Rates

Select your target currency (e.g. EUR) and choose Use Latest Rates. Each time the report is refreshed, G-Accon will automatically fetch the most current exchange rate from its provider and apply it to all values in the report. No manual rate input is required.

Use Custom Rates

Choose Use Custom Rates to manually specify an exchange rate for a particular date. You can either enter the rate directly in the converter panel, or create a dedicated tab in your Google Sheet containing custom rates — useful when you need to lock in a specific rate for audit or compliance purposes.

Use Custom Rates for Periods

For reports spanning multiple periods, Use Custom Rates for Periods lets you assign a different exchange rate to each period in the report. This is essential for accurate multi-period comparisons where exchange rates fluctuated significantly — for example, in monthly or quarterly P&L reports covering a full financial year. Rates can be entered in the converter panel or managed in a dedicated Google Sheet tab.

Once your currency settings are configured, click Execute to generate the report. The converted figures will appear directly in your Google Sheet in the selected currency.

How to Schedule Automatic Data Refresh

G-Accon's Automation feature lets you schedule your Profit & Loss report to refresh automatically — no manual intervention needed. You can also configure notifications to alert team members, clients, or stakeholders when a refresh completes.

To set up an automated refresh:

• Go to Extensions → G-Accon for QuickBooks → Automation → Create Workflow.
• Add the Profit & Loss template to the workflow and set your preferred refresh schedule (e.g. daily, weekly, or monthly).
• Optionally configure email notifications to be sent automatically when the refresh completes.
• Multiple templates can be included in a single workflow, each with its own schedule.

For full details on workflow configuration, refer to the Create Workflow documentation.

How to Modify Your Report and Update Your Template

If you need to change the parameters of an existing report — for example to adjust the date range, add a comparison period, or change filters — you can edit the template directly without needing to rebuild it from scratch. You also do not need to be signed in to your QuickBooks organisation to modify or refresh a template.

• Go to Extensions → G-Accon for QuickBooks → Edit Templates for Current Sheet.
• Select the template you want to modify from the list.
• Make your changes in the Edit Template panel.
• Click Update to save the changes without re-running the report, or Update and Execute to save and immediately refresh the data.