Overview
Xero provides accounting and payroll software for small business, so you can see your cash flow in real time with online accounting, invoicing, billing, and banking services. Combining Grow’s ability to update data as it changes and Xero’s flexibility with viewing up-to-date information enables you to make powerful and effective financial decisions at a moment’s notice.
How to Connect
Before starting, please collect your Xero account login credentials.
- First, log in to your Grow account and press Add Metric. Select Xero from the list of data sources, then click connect.
- Type in your Xero username and password.
And that's it! You are good to go.
Endpoints
Below is a list of the reports that the Xero integration offers, along with a description of each report.
- Accounts: List of all the bank accounts connected to my Xero account
- Aged Payable by Contact: List of historical transactions paid to provider or supplier with associated details.
- Aged Receivables by Contact: List of historical transactions received by customer with associated details.
- Balance Sheet: Details of Balance Sheet entries for last two years, including the value of assets, liabilities and other categories listed on your account.
- Bank Statement: Charges and deposits for specified bank account.
- Bank Statement (multiple accounts): Opening and closing balance for selected time period and specific transactions for multiple bank accounts allowing for aggregated totals.
- Bank Summary: Opening and closing balance, cash received and spent for specified time period.
- Budget Summary: Monthly budget projections specified in your account.
- Contacts: List of all contacts, activity status and associated ID.
- Executive Summary: List of key values for the last year including profitability, balance sheet, asset positions, cash flow, average debtor days etc.
- Invoices: List of all invoice totals, amount due, paid, and categories.
- Invoice Line Items: List of all invoice line items, amount due, and categories.
- Items: Retrieve inventory information like description, quantity, and price.
- Linked Transactions: List of any transactions linked from a purchase transactions and a customer or sales transaction.
- Profit and Loss: Last 12 months of data including monthly revenue, operating expenses, cost of sales, etc.
- Repeating Invoices: List of any invoices set up to repeat and associated details.
- Tracking Categories: List of all tracking categories and associated details.
- Trial balance: Statement of all debits and credits for account.
FAQs + Tips and Tricks
If you have a lot of data or many datasets from Xero you may run into API limits.
Xero has a daily call cap and per minute cap. If you anticipate you hit the per minute cap of 60 calls in 60 seconds just wait a minute and try again.
Using the Tracking CategoryIDs and OptionIDs with the Profit and Loss report
If you want to limit the information for a profit and loss report using a custom tracking ID that you've created in Xero, you can find the CategoryID and OptionID in the "TrackingCategories" report. Then simply cut and paste those values into the fields in the "Profit and Loss" report.
