Skip to content

G-Accon Help Center

G-Accon knowledge base for Xero, QuickBooks, Xero Practice Manager, WorkflowMax, Sage, and FreshBooks integrations.

  • G-Accon Help Center
  • QuickStart Guide for New Users
  • How to Install Add-ons to Domain
  • Xero
    • Accounting Data Export
      • Xero Reports Designer Overview
      • Attachments
      • Accounts
      • Batch Payments
      • Branding Themes
      • Bank Transactions
      • Bank Transfers
      • 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
    • Xero Reports
      • Xero Reports Overview
      • 1099 Report (US)
      • Account Transactions
      • Aged Payables by Contact
      • Aged Payables Detail
      • Aged Payables Detail By Contact Groups
      • 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 Manager
      • Budget Summary
      • Budget Variance
      • Budget Variance by Tracking Category
      • Budget vs Actual
      • Budget vs Actual by Tracking Category
      • 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
      • General Ledger Export
      • GST Audit Report
      • Income by Contacts
      • Income Statement
      • Income Statement Turnover
      • Income Statement Variance
      • Payable Invoice Details
      • Payable Invoice Summary
      • Profit And Loss
      • Profit And Loss Original
      • Profit And Loss Turnover
      • Profit And Loss Variance
      • Purchase Orders
      • Purchase Order Details
      • Purchase Order Summary
      • Quotes Details
      • Quotes Pivot Table
      • Quotes Summary
      • Receivable Invoice Detail
      • Receivable Invoice Summary
      • Sales Tax
      • 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
    • Upload Data to Xero
      • How to Import Data into Xero from Google Sheets
      • Add Contacts to a Contact Group Upload
      • Accounts Upload
      • Bank Transactions Upload
      • Bank Transfers Upload
      • Contacts Upload
      • Contact Groups Upload
      • Credit Notes Upload
      • Credit Note Allocations Upload
      • Credit Note Refunds Upload
      • Invoices Upload
      • Invoice Payments Upload
      • Inventory (Items) Upload
      • Linked Transactions Upload
      • Manual Journals Upload
      • Overpayment Refunds Upload
      • Prepayment Refunds Upload
      • Purchase Orders Upload
      • Quotes Upload
      • Tracking Category Options Upload
    • Consolidated Reports
      • Xero Consolidated Balance Sheet Report
      • Xero Consolidated Cash Summary Report
      • Xero Consolidated Profit & Loss Report
    • Projects Data Export
      • Projects
      • Users
      • Tasks
      • Time
    • Assets Export
      • Assets
      • Asset Type
      • Asset Settings
    • NZ Payroll Export
      • 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
      • Tracking Categories
    • UK Payroll Export
      • 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
    • AU Payroll Export
      • 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
    • Audit Trail Export
      • Bank Transactions
      • Batch Payments
      • Contacts
      • Credit Notes
      • Expense Claims
      • Inventory (Items)
      • Invoices
      • Linked Transactions
      • Manual Journals
      • Overpayments
      • Payments
      • Prepayments
      • Purchase Orders
      • Quotes
      • Repeating Invoices
    • Xero Multi-Currency Converter
  • QuickBooks
    • Accounting Data Export
      • Data Overview
      • Accounts
      • Bills
      • Bill Payments
      • Budget
      • Classes
      • Company Info
      • Company Currency
      • Credit Memos
      • Credit Card Payments
      • 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
    • QuickBooks Reports
      • QuickBooks Reports Overview
      • Account List
      • Actual vs Budget
      • Aged Payables Detail
      • Aged Payables Detail New
      • Aged Payables Detail By Location
      • Aged Payables Detail By Vendor
      • Aged Payables Summary
      • Aged Payables Summary By Location
      • Aged Payables Summary By Vendor
      • Aged Receivable Detail
      • Aged Receivables Detail New
      • Aged Receivables Detail By Customer
      • Aged Receivables Detail By Location
      • Aged Receivables Summary
      • Aged Receivables Summary By Customer
      • Aged Receivables Summary By Location
      • 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 Variance
      • Budget vs Actual
      • 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
      • Journal Report
      • General Ledger
      • General Ledger By Account
      • 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
      • Profit And Loss Variance
      • Purchase Order By Location
      • Purchase Order By Vendor
      • Purchase Order Details
      • 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 Details
      • Trial Balance
      • Trial Balance New
      • Vendor Balance
      • Vendor Balance Detail
      • Vendor Expenses
      • Vendor Expenses By Classes
      • Vendor Expenses By Location
      • Vendor Expenses By Products And Services
    • Upload Data to QuickBooks
      • Accounts Upload
      • Bills Upload
      • Bill Payments Upload
      • Classes Upload
      • Company Currency Upload
      • Credit Memos Upload
      • Customers Upload
      • Deposits Upload
      • Employees Upload
      • Estimates Upload
      • Expenses Upload
      • Invoices Upload
      • Items Upload
      • Journal Codes Upload
      • Journal Entries Upload
      • Locations Upload
      • Payments Upload
      • Payment Methods Upload
      • Terms Upload
      • Purchase Orders Upload
      • Time Activities Upload
      • Refund Receipts Upload
      • Transfers Upload
      • Sales Receipts Upload
      • Vendors Upload
      • Vendor Credits Upload
      • Tax Agencies Upload
    • Consolidated Reports
      • Consolidated Balance Sheet
      • Consolidated Cash Flow Report
      • Consolidated Profit And Loss
  • FreshBooks
    • Reports Designer
      • Accounts
      • Bills
      • Bill Payments
      • Clients
      • Credit Notes
      • Estimates
      • Expenses
      • Expense Categories
      • Expense Summaries
      • Gateways
      • Invoices
      • Invoice Payments
      • Recurring Templates
      • Retainers
      • Items
      • Journal Entry Details
      • Other Incomes
      • Projects
      • Services
      • Staff
      • Taxes
      • Time Entries
      • Vendors
    • FreshBooks Reports
      • Accounts Aging
      • Accounts Payable Aging
      • Balance Sheet
      • Cash Flow
      • Expense Details
      • General Ledger
      • Items Sales
      • Profit And Loss
      • Revenue By Client
      • Trial Balance
    • Upload Data to FreshBooks
      • Bills Upload
      • Bill Payments Upload
      • Clients Upload
      • Credit Notes Upload
      • Estimates Upload
      • Expenses Upload
      • Invoices Upload
      • Invoice Payments Upload
      • Recurring Templates Upload
      • Items Upload
      • Journal Entries Upload
      • Other Income Upload
      • Projects Upload
      • Services Upload
      • Time Entries Upload
      • Taxes Upload
      • Vendors Upload
  • Sage Cloud Accounting
    • Accounting Data Export
      • Sage Data Export Overview
      • Accounts
      • Address Regions
      • Address Types
      • Addresses
      • Artefact Statuses
      • Bank Account Types
      • Bank Accounts
      • Bank Deposits
      • Bank Opening Balances
      • Bank Reconciliations
      • Bank Transfers
      • Business Exchange Rates
      • Business Settings
      • Business Types
      • Businesses
      • Catalog Item Types
      • Contact Allocations
      • Contact Opening Balance Types
      • Contact Opening Balances
      • Contact Payments
      • Contact Person Types
      • Contact Persons
      • Contacts
      • Countries
      • Country Groups
      • Country Of Registrations
      • Currencies
      • EU Goods Services Types
      • EU Sales Descriptions
      • Exchange Rates
      • Financial Settings
      • Hosted Artefact Payment Settings
      • Invoice Settings
      • Journals
      • Ledger Account Classifications
      • Ledger Account Balances
      • Ledger Account Opening Balances
      • Ledger Account Types
      • Ledger Accounts
      • Ledger Entries
      • Live Exchange Rates
      • Opening Balance Journals
      • Other Payments
      • Payment Methods
      • Product Sales Price Types
      • Products
      • Quick Entry Types
      • Sales Credit Notes
      • Sales Estimates
      • Sales Invoices
      • Sales Quick Entries
      • Sales Quotes
      • Service Rate Types
      • Services
      • Stock Items
      • Stock Movements
      • Tax Profiles
      • Tax Rates
      • Tax Types
      • Templates
      • Transaction Types
      • Transactions
      • Trial Balance
      • Unallocated Artefacts
      • User
      • Vendor Credit Notes
      • Vendor Bills
      • Vendor Quick Entries
    • Sage Reports
      • Sage Reports Overview
      • Balance Sheet
      • Cash Flow
      • Cash Summary
      • General Ledger
      • Profit And Loss
      • Transaction List
      • Transaction List Details
      • Trial Balance
    • Upload Data to Sage
  • WorkflowMax/Xero Practice Manager
    • WorkflowMax/XPM Data Export
      • Categories
      • Clients
      • Contacts
      • Costs
      • Custom Field Definitions
      • Documents
      • Groups
      • Invoices
      • Jobs
      • Job Costs
      • Job Tasks
      • Leads
      • Purchase Orders
      • Quotes
      • Staffs
      • Suppliers
      • Tasks
      • Templates
    • WorkflowMax Reports
      • Client Job Report
      • Purchase Order Detail
      • Job Invoice Report
      • Purchase Order Summary
      • Job Purchase Order Report
      • Job Report
      • Job Time Report
      • Staff Current Job Report
      • Specific Job Invoice Report
      • Staff Time Report
      • Quote Detail
      • Quote Summary
      • Receivable Invoice Detail
      • Receivable Invoice Summary
    • Upload Data to WFM/XPM
      • Assign Staffs Upload
      • WorkflowMax Clients Upload
      • WorkflowMax Contacts Upload
      • WorkflowMax Costs Upload
      • Custom Fields Definitions
      • Groups
      • Jobs Upload
      • Job Costs Upload
      • Job Estimates Upload
      • Job Notes
      • Job Quotes
      • Job States
      • Job Tasks
      • Job Tasks Reorder
      • Leads
      • Managing Groups
      • Purchase Orders
      • Staffs
      • Suppliers
      • Timesheet
  • Workflow Automation
    • Automatic Refresh
    • Automatic Refresh Limits
    • Automatic Uploads
    • Emails Management
    • Alerts Generation
    • Automatic Reports Backups
  • Change Template(s) Ownership
  • Save and Share Templates in Cloud
  • Template Settings
  • Group and Domain Licenses
  • Load Cloud Template
    • Cloud Template Library
    • Workspace Cloud Template Library
    • Batch Cloud Template
  • Add/Manage Standard User
  • Add Annotations
  • 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
  • Video Tutorials
  • Common Issues
  • FAQ
  • Subscribe to G-Accon channel
  • Twitter
  • LinkedIn

© 2021 G-Accon. All rights reserved.

Get Projects Data Video

How to get Xero Projects data into Google Sheets and create a template using G-Accon.

https://s3.amazonaws.com/www.accon.services/videos/Get+Projects+Data.mp4

Share this:

  • Twitter
  • Facebook

Like this:

Like Loading...
    • G-Accon Help Center
    • Customize
    • Sign up
    • Log in
    • Copy shortlink
    • Report this content
    • Manage subscriptions
%d bloggers like this: