Skip to content

G-Accon Docs

Google Sheets Integrations documentation for Xero, QuickBooks, HubSpot

  • G-Accon User Guide
    • QuickBooks
    • Xero
    • HubSpot
  • Getting Started
    • How to Install Add-ons
      • How to Install Add-ons for Xero and QuickBooks
      • How To Install Add-on for HubSpot
    • How to Install Add-ons to Domain
    • How to Sign In
  • QuickBooks
    • Accounting Data
      • QuickBooks Data Overview
      • Accounts
      • Bills
      • Bill Payments
      • Budgets
      • Classes
      • Company Info
      • Credit Memos
      • Customers
      • Departments
      • Deposits
      • Employees
      • Estimates
      • Invoices
      • Items
      • Journal Codes
      • Journal Entries
      • Payments
      • Payment Methods
      • Preferences
      • Purchases
      • Purchase Orders
      • Refund Receipts
      • Sales Receipts
      • Tax Classification
      • Tax Agencies
      • Tax Codes
      • Tax Rates
      • Terms
      • Time Activities
      • Transfers
      • Vendors
      • Vendor Credits
    • Reports
      • QuickBooks Reports Overview
      • Account List
      • Aged Payables Detail
      • Aged Payables Summary
      • Aged Receivable Detail
      • Aged Receivables Summary
      • Balance Sheet
      • Cash Flow
      • Customer Balance
      • Customer Balance Detail
      • Customer Income
      • General Ledger
      • Journal Report
      • Profit And Loss
      • Profit And Loss Detail
      • Sales By Class
      • Sales By Customer
      • Sales by Department
      • Sales By Product
      • Transaction Detail by Account
      • Transaction List
      • Trial Balance
      • Vendor Balance
      • Vendor Balance Detail
      • Vendor Expenses
  • Xero
    • Accounting Data
      • Accounting Data Overview
      • Accounts
      • Bank Transactions
      • Bank Transfers
      • Batch Payments
      • Branding Themes
      • 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
      • Receipts
      • Repeating Invoices
      • Tax Rates
      • Tracking Categories
      • Users
    • Reports
      • Xero Reports Overview
      • 1099 Report (US)
      • Account Transactions
      • Aged Payables by Contact
      • Aged Payables Detail
      • Aged Payables Summary
      • Aged Receivables By Contact
      • Aged Receivables Detail
      • Aged Receivables Summary
      • Balance Sheet
      • Bank Statement
      • Bank Summary
      • Budget Summary
      • Budget vs Actual
      • 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
      • Payable Invoice Details
      • Payable Invoice Summary
      • Profit And Loss Original
      • Purchase Orders
      • Purchase Order Details
      • Purchase Order Summary
      • Receivable Invoice Detail
      • Receivable Invoice Summary
      • Statement Of Cash Flows
      • Supplier Invoice
      • Trial Balance
      • VAT Audit Report with Supplier’s
      • VAT Registration Number
      • VAT 126
    • Projects Data
      • Projects
      • Users
      • Tasks
      • Time
    • Assets Data
      • 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 Refunds
      • Invoices
      • Invoice Payments
      • Items
      • Linked Transactions
      • Manual Journals
      • Overpayment Refunds
      • Prepayment Refunds
      • Purchase Orders
    • Get NZ Payroll Data
      • 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
      • Reimbursements
      • Statutory Deductions
      • Superannuations
      • Pay Runs
      • Payslips
      • Timesheets
      • Settings
      • TrackingCategories
    • 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
  • HubSpot
    • Get HubSpot Data
      • HubSpot Data Overview
      • Calendar Events
      • Companies
      • Company Properties
      • Contact Properties
      • Contacts
      • Deal Pipelines
      • Deal Properties
      • Deals
      • Email Events
      • Engagements
      • Owners
      • Pages
      • Products
    • HubSpot Videos
  • Automation
    • Data Operations Scheduler
    • Automatic Refresh Limits
    • Emails Management
    • Alerts Generation
    • Automatic Reports Backups
    • Automation Troubleshooting
  • 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
  • FAQ

Follow Us

  • Twitter
  • Facebook
  • LinkedIn

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

Share this:

  • Twitter
  • Facebook

Like this:

Like Loading...
%d bloggers like this: