Configuring your WorkGuru and Xero integration

WorkGuru is designed to seamlessly push your invoices, purchases orders, Stock on Hand and Cost of Goods sold through to your Xero account.

  1. To connect to Xero, go to the Accounting -> Xero dashboard, and click the Connect to Xero button.
  2. Click the Connect to Xero button.   If you are planning on sending timesheets to Xero, ensure that you select the Connect to Xero Payroll? option. Note: if you select this option, the Xero user MUST have the Payroll Admin privilege (in Xero), otherwise you encounter errors trying to export timesheet data.
  3. Xero will prompt you to securely login in and connect to your Xero file.  Select the required organisation (Note: if you have access to multiple Xero files, ensure that you are selecting the correct organisation in the list) and click Allow Access.Xero will return to your Xero dashboard and WorkGuru now has access to your Xero organisation.  
  4. The next step is to sync  your Tax Rates, and Chart of Accounts from Xero into WorkGuru so we can set up default accounts. In the "Before You Start" Section. Click on the following and wait for the page to reload. This will load the relevant information into the WorkGuru database.
    1. Get Tax Rates - Import the tax rates setup in the connected Xero organisation.
    2. Get Chart of Accounts - Import the current chart of accounts setup in the connected Xero organisation.
    3. Set Defaults - Map the accounts in Xero for WorkGuru to pre-code when sending transactions to Xero. If the required GL accounts are not dsiplaying correctly in the dropdowns, ensure that the Get Chart of Accounts function has been run correct, or you may need to create the accounts in Xero for use with WorkGuru.
      1. Accounting Integration - Defaults to Xero.
      2. DefaultSalesAccount - default income account. Recommended Xero Account Type: Revenue.
      3. DefaultExpensesAccount - default expense account for non-stock (not FIFO) products or project disbursement purchase orders.  Recommended Xero Account Type: Expense.
      4. DefaultInventoryAccount - default stock on hand account. Note: You may not use Xero's built in Inventory account for your Stock on Hand. Create a separate Current Asset account type for SOH value. 
      5. CostofGoodsSoldAccount - default COGS account for cost of sale, stocktake and stock adjustment journals.  Recommended Xero Account Type: Direct Cost
      6. DefaultSalesTax - default sales tax to be used.  Usually GST on Income.
      7. DefaultPurchaseTax - default purchase tax to be used.  Usually GST on Expenses.
      8. DefaultCurrency - default currency, use IBAN ISO currency codes (AUD etc).   Must match your default Xero currency.
      9. AlternateCurrencies - alternate currencies to be used for multi currency purchasing, use IBAN ISO currency codes (USD, EUR, NZD etc).
    4. Click Save to confirm the default general ledger mappings.   You can edit these in the future from the same link in your Xero dashboard Accounting -> Xero ->  Set Defaults
  5. Your connection to Xero is complete