Skip to content

G-Accon Docs

Google Sheets Integrations documentation for Xero, QuickBooks, HubSpot

  • G-Accon User Guide
    • Xero
    • QuickBooks
    • WorkflowMax
  • Getting Started
    • How to Install Add-ons
      • How to Install Add-on for Xero
      • How to Install Add-on for QuickBooks
      • How to Install Add-on for WorkflowMax
    • How to Sign In
      • How to Install Add-ons to Domain
  • Xero
    • Reports Designer
      • Reports Designer Overview
      • Accounts
      • Attachments
      • Bank Transactions
      • Bank Transfers
      • Batch Payments
      • Branding Themes
      • Budgets
      • Contacts
      • Contact Groups
      • Credit Notes
      • Currencies
      • Employees
      • Expense Claims
      • Inventory (Items)
      • Invoices
      • Invoice Reminders
      • Journals
      • Linked Transactions
      • Manual Journals
      • Organisation
      • Overpayments
      • Payments
      • Prepayments
      • Purchase Orders
      • Quotes
      • Receipts
      • Repeating Invoices
      • Tax Rates
      • Tracking Categories
      • Users
    • Standard Reports
      • Xero Reports Overview
      • 1099 Report (US)
      • Account Transactions
      • Aged Payables by Contact
      • Aged Payables Detail by Contact Groups
      • Aged Payables Detail
      • Aged Payables Summary
      • Aged Payables Summary by Contact Groups
      • Aged Receivables By Contact
      • Aged Receivables Detail
      • Aged Receivables Detail by Contact Groups
      • Aged Receivables Summary
      • Aged Receivables Summary by Contact Groups
      • Balance Sheet
      • Bank Statement
      • Bank Summary
      • Budget Summary
      • Budget vs Actual
      • Budget By Tracking Category
      • Budget By Tracking Category
      • Budget Variance
      • Budget Variance
      • Cash Summary
      • Custom Date Range Balance Sheet
      • Customer Invoice
      • Customer Invoice Detail
      • Customer Running Account Details
      • Customer Running Account Summary
      • Detailed Account Transactions
      • Executive Summary
      • GL Export
      • Income by Contacts
      • Income Statement
      • Income Statement Turnover
      • Payable Invoice Details
      • Payable Invoice Summary
      • Profit And Loss
      • Profit And Loss Original
      • Profit And Loss Turnover
      • Purchase Orders
      • Purchase Order Details
      • Purchase Order Summary
      • Quotes Details
      • Quotes Pivot Table
      • Quotes Summary
      • Receivable Invoice Detail
      • Receivable Invoice Summary
      • Statement Of Cash Flows
      • Supplier Invoice
      • Tracking Summary
      • Trial Balance
      • Trial Balance Net Movement
      • Trial Balance New
      • VAT Audit Report with Supplier’s
      • VAT Registration Number
      • VAT 126
    • Design Projects Reports
      • Projects
      • Users
      • Tasks
      • Time
    • Design Assets Reports
      • Assets
      • Asset Type
      • Asset Settings
    • Upload
      • How to upload data into Xero
      • Add Contacts to a Contact Group
      • Accounts
      • Bank Transactions
      • Bank Transfers
      • Contacts
      • Contact Groups
      • Credit Notes
      • Credit Note Allocations
      • Credit Note Refunds
      • Invoices
      • Invoice Payments
      • Inventory (Items)
      • Linked Transactions
      • Manual Journals
      • Overpayment Refunds
      • Prepayment Refunds
      • Purchase Orders
      • Quotes
      • Tracking Category Options
    • Design NZ Payroll Reports
      • Employees
      • Employees Tax
      • Employees Leave
      • Employees Leave Balances
      • Employees Payment Methods
      • Employees Salary and Wages
      • Employees Opening Balances
      • Employees Leave Periods
      • Employees Leave Types
      • Pay Run Calendars
      • Earnings Rates
      • Deductions
      • Leave Types
      • Settings
      • Reimbursements
      • Statutory Deductions
      • Superannuations
      • Pay Runs
      • Payslips
      • Timesheets
      • TrackingCategories
    • Design UK Payroll Reports
      • Employees
      • Employees Tax
      • Employees Opening Balances
      • Employees Leave
      • Employees Statutory Leave Balances
      • Employee Statutory Leaves Summary
      • Employee Statutory Sick Leave
      • Employees Leave Periods
      • Employees Leave Types
      • Employee Pay Templates
      • Employer Pensions
      • Deductions
      • Earnings Orders
      • Earnings Rates
      • Leave Types
      • Payment Methods
      • Pay Run Calendars
      • Pay Runs
      • Payslips
      • Reimbursements
      • Salary and Wages
      • Settings
      • Timesheets
    • Design AU Payroll Reports
      • Employees
      • Employees Opening Balances
      • Employees Pay Template
      • Leave Applications
      • Pay Items Earnings Rates
      • Pay Items Deduction Types
      • Pay Items Reimbursement Types
      • Pay Items Leave Types
      • Pay Runs
      • Payroll Calendars
      • Payslips
      • Settings
      • Settings Tracking Categories
      • Super Fund Products
      • Super Funds
      • Timesheets
    • Multi-Currency Converter
    • Audit Trail: History/Notes
      • Bank Transactions
      • Batch Payments
      • Contacts
      • Credit Notes
      • Expense Claims
      • Inventory (Items)
      • Invoices
      • Linked Transactions
      • Manual Journals
      • Overpayments
      • Payments
      • Prepayments
      • Purchase Orders
      • Quotes
      • Repeating Invoices
    • Videos
      • Purchase Orders Export Video
      • Account Transactions Report Video
      • Aged Reports Video
      • Purchase Orders Reports Video
      • Bi-Directional Bills Sync Video
      • How to Schedule Auto-Refresh Video
      • Get Assets Data Video
      • Get Projects Data Video
  • WorkflowMax
    • Design WorkflowMax Reports
      • Categories
      • Clients
      • Contacts
      • Costs
      • Custom Field Definitions
      • Documents
      • Groups
      • Invoices
      • Jobs
      • Job Costs
      • Job Tasks
      • Leads
      • Purchase Orders
      • Quotes
      • Staffs
      • Suppliers
      • Tasks
      • Templates
    • Get WorkflowMax Reports
      • Purchase Order Detail
      • Purchase Order Summary
      • Quote Detail
      • Quote Summary
      • Receivable Invoice Detail
      • Receivable Invoice Summary
    • Uploads
      • Assign Staffs
      • Clients
      • Contacts
      • Costs
      • Custom Fields Definitions
      • Groups
      • Jobs
      • Job Costs
      • Job Estimates
      • Job Notes
      • Job Quotes
      • Job States
      • Job Tasks
      • Job Tasks Reorder
      • Leads
      • Managing Groups
      • Purchase Orders
      • Staffs
      • Suppliers
      • Timesheet
  • QuickBooks
    • Design Accounting Reports
      • QuickBooks Data Overview
      • Accounts
      • Bills
      • Bill Payments
      • Budget
      • Classes
      • Company Info
      • Company Currency
      • Credit Memos
      • Credit Card Payment
      • Customers
      • Customer Types
      • Deposits
      • Employees
      • Estimates
      • Exchange Rates
      • Expenses
      • Invoices
      • Items
      • Journal Codes
      • Journal Entries
      • Locations
      • Payments
      • Payment Methods
      • Preferences
      • Purchase Orders
      • Refund Receipts
      • Reimburse Charge
      • Sales Receipts
      • Tax Agencies
      • Tax Codes
      • Tax Rates
      • Terms
      • Time Activities
      • Transfers
      • Vendors
      • Vendor Credits
    • Standard Accounting Reports
      • QuickBooks Reports Overview
      • Account List
      • Actual vs Budget
      • Aged Payables Detail
      • Aged Payables Summary
      • Aged Receivable Detail
      • Aged Receivables Summary
      • Balance Sheet
      • Balance Sheet By Classes
      • Balance Sheet By Customer
      • Balance Sheet By Location
      • Balance Sheet By Product And Services
      • Balance Sheet By Vendor
      • Budget vs Actual
      • Budget Variance
      • Cash Flow
      • Cash Flow By Classes
      • Cash Flow By Customer
      • Cash Flow By Location
      • Cash Flow By Products And Services
      • Cash Flow By Vendor
      • Customer Balance
      • Customer Balance Detail
      • Customer Income
      • Detailed Transactions
      • Inventory Valuation Summary
      • General Ledger
      • Journal Report
      • Profit And Loss
      • Profit And Loss By Classes
      • Profit And Loss By Customer
      • Profit And Loss By Location
      • Profit And Loss By Products And Services
      • Profit And Loss By Vendor
      • Profit And Loss Detail
      • Sales By Classes
      • Sales By Customer
      • Sales By Location
      • Sales By Products And Services
      • Transaction List
      • Transaction List By Customer
      • Transaction List by Vendor
      • Transaction List by Vendor
      • Trial Balance
      • Vendor Balance
      • Vendor Balance Detail
      • Vendor Expenses
      • Vendor Expenses By Classes
      • Vendor Expenses By Location
      • Vendor Expenses By Products And Services
    • Upload
      • Accounts
      • Bills
      • Bill Payments
      • Classes
      • Company Currency
      • Credit Memos
      • Customers
      • Deposits
      • Employees
      • Estimates
      • Expenses
      • Invoices
      • Items
      • Journal Codes
      • Journal Entries
      • Locations
      • Payments
      • Payment Methods
      • Purchase Orders
      • Refund Receipts
      • Sales Receipts
      • Tax Agencies
      • Terms
      • Time Activities
      • Transfers
      • Vendors
      • Vendor Credits
  • Automation
    • Automatic Workflow
    • Data Operations Scheduler (Deprecated)
    • Automatic Refresh Limits
    • Automatic Uploads
    • Emails Management
    • Alerts Generation
    • Automatic Reports Backups
    • Automation Troubleshooting
  • Change Template(s) Ownership
  • Save and Share Templates in Cloud
  • Refresh/Refresh All
  • AWS
    • How to sign into AWS
    • How to execute report in AWS
    • How to sign out from AWS
    • Automatic refresh
  • Tableau
    • How to Install Tableau
    • Connect to G-Accon Google Sheets from Tableau
    • G-Accon Google Sheets in Tableau example
    • Data limit in Google Drive
  • Google Charts
    • How to Automatically Generate Chart
    • Publish Chart in Web
  • Google Data Studio
    • How to Add Chart
    • Publish Chart in Web
  • Power BI
  • FAQ
  • Release Notes
    • Xero
      • August 5, 2020
      • October 14, 2020
      • November 4, 2020
    • QuickBooks
      • June 3, 2020
      • September 9, 2020
      • October 28, 2020

Follow Us

  • Twitter
  • Facebook
  • LinkedIn

Xero

  • Getting Started
  • Accounting Data
  • Audit Trail: History/Notes
  • Reports
  • Audit Trail
  • Projects Data
  • Assets Data
  • Upload
  • Multi-Currency Converter
  • Get NZ Payroll Data
  • Get UK Payroll Data
  • Get AU Payroll Data
  • Save & Share Templates in Cloud
  • Videos
  • Refresh/Refresh All
  • Automation

Share this:

  • Twitter
  • Facebook

Like this:

Like Loading...
%d bloggers like this: