Skip to content
  • There are no suggestions because the search field is empty.

Guide: Using Xero with Databox

Last updated:

HOW TO

How to connect Xero to Databox

IN THIS SECTION

How to connect Xero to Databox


To connect a Xero Account in Databox, go to   Data Sources > + New connection. Type Xero in the search bar and click on the green Connect button. 

This will open the  Authorization window, which is where you will be prompted to enter your Xero credentials and authorize the Databox app. 

What Xero permissions do you need to connect to Databox?

To connect Xero in Databox, you must have an Invoice only, Standard or Advisor user role in your Xero account. Additionally, Reports must be enabled as an Extra Permission. Learn more about Xero user roles and permissions here.

How much historical data is synced when you first connect Xero to Databox?

When you connect a new Xero Data Source in Databox, 36 months' worth of data is initially available. 

Certain Metrics may have more or less historical data available. For more information about the amount of historical data available for a specific Metric, please contact our Support Team at help@databox.com.

Pro Tip: Once your Xero Data Source is connected and actively syncing data, we store the data that's collected in our own database. This allows us to accumulate more data over time as more data syncs are made so that you can report on more historical Xero data in your Databox reports. Learn more here

What time zone does Xero data sync in?

Xero data is synced in UTC. 

    API Limitations

    If you are tracking data in your Xero Account in multiple currencies, you'll be prompted to select the currency you'd like to report in when connecting Xero to Databox

    When using metrics like ''Outstanding Payments by Contact'' and ''Overdue Payments by Contact'' in Databox, all contacts without their currency returned via API will have the default currency displayed in Databox, even though their actual currency (seen in Xero) could be different. This is due to Xero's API limitations that do not support currency conversions.

    If you'd like to report on Xero data in Databox in multiple currencies, you can use Data Calculations feature to set up a currency conversion. Learn more here.

    If you are tracking data in your Xero Account in a single currency, you won't be asked to select the currency you'd like to report in when connecting Xero to Databox. Metrics in Databox will automatically report in the currency set in your Xero Account.

    Metric Considerations

    As of April 2025, due to architectural and product changes, some dimensional metrics have been restructured and are now available as dimensions within a new placeholder metric. The list of affected metrics is provided below.

    Old Metric Name New Metric New Dimension (Breakdown by)
    Current Property, Plant and Equipment by Asset Total Assets Current Property, Plant and Equipment by Asset
    Current Cash and Cash Equivalents by Asset Total Assets Current Cash and Cash Equivalents by Asset
    Current Non-liabilities by Liability Total Liabilities Non-Liability

    Granularity Restrictions

    • Due to API limitations, Hourly, Daily and Weekly granulations are not supported. This may affect visualization options for Charts in Databox.