Your Complete Guide to G-Accon

G-Accon Help Center

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.
Wiki Menu

Custom Accounting Reports

Custom Reports let you pull any standard Xero report into Google Sheets and save it as a reusable template. Pick a report, set its options to fit your business, and refresh it whenever you need.

AppG-Accon for Xero
Report groupsAccounting, Financial, Purchase, Sales, Tax
Saved asReusable template
1
Open

Open Custom Reports

  • In Google Sheets, go to Extensions‚Ä∫G-Accon for Xero‚Ä∫Get Accounting Data/Reports‚Ä∫Custom Reports
  • The Get Report from Xero - Create a Template window opens.
2
Report Group

Pick a report

Choose a Report Group to shorten the list, or keep All. Then pick the report in the Select Report dropdown.

Get Report from Xero - Create a Template
Report Group:AllAccountingFinancialPurchaseSalesTax
Select Report
Account TransactionsAged Payables by ContactAged Payables DetailAged Receivables SummaryBalance SheetBank Statement
Browse every Xero reportSearch the full list by group, with a step-by-step guide for each report.
See the report list in G-Accon
Get Report from Xero window with Report Group set to All and the Select Report list open, from Account Transactions to Customer Running Account Summary
Account Transactions to Customer Running Account Summary.
Select Report list scrolled from Customer Invoice Detail to Supplier Invoice
Customer Invoice Detail to Supplier Invoice.
End of the Select Report list, from Statement Of Cash Flows to Trial Balance New
The end of the list.
3
Options

Set the options

Every report uses the same window. Set what you need on each tab:

Tab 1Report ParametersThe date range, dynamic, static or custom, and the report's own filters.
Tab 2Settings / PreviewOptional: new sheet, headers, deep links to Xero, formatting and more. See all settings
Tab 3Multi-Currency ConverterOptional: show the report in another currency.
Each report has its own parameters, some required and some optional. The report's guide lists them all.
4
Run

Click Execute, then reuse it

The report lands in your sheet and is saved as a template, so you can refresh or change it later without setting it up again.

Need help with a report?

Browse the Xero guides, or ask our support team.

© Copyright 2026 G-Accon
crossmenuchevron-down