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.

  • Less than 1 minute
  • Xero, QuickBooks Online and Zoho Books
  • Excel for Windows and Mac
What you'll end up with
On this page
  1. Before you start
  2. Which one do I need?
  3. Reconnect
    1. 1. Find the entity in the Rows portal
    2. 2. Select Reconnect and allow access again
    3. 3. Refresh your reports in Excel
  4. Disconnect
    1. 1. Open the entity's menu
    2. 2. Confirm with Delete entity
  5. From Xero, QuickBooks Online or Zoho Books
  6. If something goes wrong
  7. Talk to a person

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.

  1. Find the entity in the Rows portal

    In your browser

    Open Entities. An entity that needs it shows Reconnect on its card, or in the Connection column if you use List view.

    Rows portal, Entities
  2. Select Reconnect and allow access again

    In your browser

    Select 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.

  1. Refresh your reports in Excel

    In Excel

    Back 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.

  1. Open the entity's menu

    In your browser

    Under Entities, select the three dots next to the entity's name and choose Delete entity.

    Rows portal, the entity's menu
  2. Confirm with Delete entity

    In your browser

    Select 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.com

Book an onboarding call

Free during your trial. We'll connect your entities with you and set up your first live report.

Book a call

Log in to your account

Change your plan, add users or manage entities in the Rows portal.

Log in