Connect your books
Reconnect or disconnect Xero, QuickBooks Online or Zoho Books
If an entity shows Reconnect, allow access again and your reports refresh as before. To stop Rows reading an entity's books, delete it in the Rows portal.
Before you reconnect or disconnect
- Your Rows login, with Manage entities switched on for you under Users in the Rows portal.
- To reconnect, a login for the platform that can still reach that entity: a standard or adviser role in Xero, an admin in QuickBooks Online, or any user of the entity in Zoho Books. Rows not in Excel yet? Install the Excel add-in first.
Which one do I need?
Reconnect an entity
From time to time the link between Rows and your books drops. Xero, QuickBooks Online and Zoho Books end connections every so often, and removing Rows on their side does the same. Nothing is lost.
Find the entity in the Rows portal
In your browserOpen Entities. An entity that needs it shows Reconnect on its card, or in the Connection column if you use List view.
Rows portal, Entities Select Reconnect and allow access again
In your browserSelect Reconnect, sign in if your platform asks, and finish as below. The entity shows Connected again.
What to select on each platform
Xero
Log in to Xero if it asks, and select Allow access.
QuickBooks Online
Under Please select your company, choose the entity and select Next.
Zoho Books
Sign in to Zoho if it asks, and select Accept.
Refresh your reports in Excel
In ExcelBack in Excel, refresh a report card in the Rows pane, or select Refresh selected sheets. Your formulas and layout stay as they were.
Rows pane, refresh card
Disconnect an entity
To disconnect an entity, delete it in the Rows portal. Rows keeps its data, so you can connect it again later.
Open the entity's menu
In your browserUnder Entities, select the three dots next to the entity's name and choose Delete entity.
Rows portal, the entity's menu Confirm with Delete entity
In your browserSelect Delete entity again to confirm. The entity leaves your Entities list, Rows stops reading its books and its reports in Excel stop refreshing. You can also delete it in Excel: on Choose your Entity in the Rows pane, the three dots next to an entity offer Star and Delete. Delete there does the same as Delete entity in the portal, straight away, with no window to confirm.
Disconnect from Xero, QuickBooks Online or Zoho Books
You can also cut the connection on the platform's side. The entity then stays in the Rows portal with Reconnect, so delete it there too if you don't want it back.
Xero
In Xero, open Connected apps and remove Rows.
QuickBooks Online
Select the Integrations icon in the top bar, then Manage integrations. Open the menu on the Rows card and select Disconnect.
Zoho Books
In your Zoho account, open Sessions, then Connected Apps, and select Revoke Access next to Rows. Every Zoho Books entity on that Zoho login disconnects at once.
If reconnecting doesn't work
Reconnect doesn't work
Sign in to Xero, QuickBooks Online or Zoho Books with a login that can still reach that entity (see Before you start), then try again. If it still fails, tell us what you see on screen (Talk to a person).
The entity is still listed after I removed Rows in Xero
That's expected. Removing Rows on the platform's side only cuts the connection, so the entity stays under Entities with Reconnect next to it. To take it out of Rows, delete it as in Disconnect an entity above.
Will I lose my workbooks?
No. Reconnecting doesn't touch your workbooks, formulas or figures. Deleting an entity doesn't delete your workbooks either: the figures already in them stay, but they won't refresh.
Can I connect the entity again later?
Yes. Rows keeps its data. Under Entities, select Connect entity as you did the first time (guides below), then refresh: your formulas work again.
Next step
Next guidePull your first report into ExcelRun a profit and loss from the Rows pane and refresh it whenever the books change.Connecting an entity for the first time? Follow Connect Xero to Excel, Connect QuickBooks Online to Excel or Connect Zoho Books to Excel. Looking for something else? Browse every guide in the Help centre.
Talk to a person
Email support
Tell us what you see on screen. We reply within 24 hours on working days.
support@rowsapp.comBook an onboarding call
Free during your trial. We'll connect your entities with you and set up your first live report.
Book a call