Sync Xero data in Google Sheets

Last updated on December 13, 2021

 

Overview

All our features are interconnected, giving you easy access to all your Reports and Models. You can easily sync the following reports with Google Sheets via our add-on.

 
  • Profit and loss
  • Balance sheet
  • Aged receivables
  • Aged payables
  • Account transactions
  • Executive summary
  • Payables invoices summary
  • Receivables invoices summary
 
💡
You can download this add-on via our web app.
 
 
 

Installing gini

On our web app, navigate to "Sync Xero data in Google Sheets" → click "Learn more"

Notion image
 
 

click "Install add-on"

Notion image
 
 

You will be taken to our app listing on Google Workspace Marketplace. Click "Install"

Notion image
 
 

A message will pop up, it will remind you that you are connecting your Google data to our add-on for your Xero organisation. Click "CONTINUE" to continue the installation of gini.

Notion image
 

Your installation will take a few seconds to complete. You should receive a message like so:

 
Notion image
 
 
 

Connecting Xero

To connect your Xero account to our Google Sheets add-on, navigate to the toolbar, click "Extensions" → "gini: Sync Xero data with a sheet" → "Sync data".

 
Notion image
 

A sidebar will pop up, click "Create a connection".

 
Notion image
 

A window will pop up to prompt you to connect your Xero account to our Google Sheets add-on. Log in with your email and password to start the connection process.

 
Notion image
 

There will be a 2 Factor Authentication prompt, this is a security measure, accept the notification to continue the connection process.

Notion image
 
 

Our add-on will request access to your Xero account. Select a Xero organisation to continue the connection process.

Notion image
 

Click "Allow access". Your Xero organisation should be successfully connected

 
Notion image
 
 
 

Syncing your Xero data

If you have not yet connected your Xero organisation to our add-on, click here for instructions on connecting your Xero account and then return to this page to know how to sync your data.

 

To connect your Xero account to our Google Sheets add-on, navigate to the toolbar, click "Extensions" → "gini: Sync Xero data with a sheet" → "Sync data".

 
Notion image
 

A sidebar will pop up, click "Create a connection".

 
Notion image
 

You will be then asked to select one of your connected Xero organisation(s).

Notion image
 

Then you will be asked to choose a report to sync to the sheet. You can choose from a wide array of important financial reports. Select a report of your choice and then select the relevant date range

Notion image
Notion image
 

Select the period scale for the report. You can choose between Monthly, Quarterly or Yearly reporting periods.

 
Notion image
 
 

Auto syncing your reports

Once you have selected the report and the period scale for the report, you can now choose to have that report auto-synced at a frequency of your choosing. First, check the box "Turn on auto sync" , select the sync frequency and then select the sync date

Notion image
Notion image
 

The data will be synced onto a new tab within the same Google Sheet document, you may rename the tab if desired. Type in the desired name of the tab in the text box under "Sheet Name".

💡
If the name of the tab is already taken, an error message "This name is being used by another sheet" will appear in red
 
Notion image

Now that you have selected the report, reporting period, auto sync and sync frequency, sit back relax and let gini handle it from there. You never have to import a report again.

 
 
 

Troubleshooting

 

Network error

Please try refreshing your browser and trying again.

 
 

Google error

Our server had a problem when talking to Google's servers.

This may be because you’ve recently installed and enabled the add-on, and Google hasn’t recognised that you’ve enabled it yet.

Please refresh your browser tab and try again in a minute.

 
 

Server error 500: <...error message...>

Something went wrong on our server. Please try again in a minute, or contact predict.help@gini.co and provide us with the error message.

 
 
 
 
Did this answer your question?
😞
😐
🤩