Xero is a robust accounting solution with sophisticated accounting features, ample reports, and 800+ integrations. Integrate OfficeRnD with it to save time and streamline your billing and accounting.
We recommend using only one system to charge clients - either OfficeRnD or Xero / QuickBooks - to prevent potential double-charging.
Summary
We can pull the following data from Xero:
Payments of reconciled invoices (in order to mark the invoices in OfficeRnD as paid as well)
Overpayments
Invoice number template (if enabled)
Invoice document (if enabled)
The integration automates the following procedures:
Generate Invoices - on the billing date you set up in OfficeRnD under Settings > Billing Settings > Billing Rules, the system will generate all invoices.
Sync - the customers' profiles and the generated invoices are synced with Xero. You can choose whether to sync invoices automatically or manually during the integration setup.
Export Invoice Documents - you can configure OfficeRnD not to generate the invoice documents so that Xero can create them for you.
Send - you can configure OfficeRnD to automatically send the synced invoices to the members.
Pull Charges - you can configure OfficeRnD to automatically pull reconciled payments from Xero every 6 hours and mark the invoices as paid on the OfficeRnD side.
Important: The Pull Charges and Pull Overpayments schedules keep the last Pull date, and they will only pull data from the Xero integration that has been added or modified after this date. For example, if you disconnect a company from Xero and then add an overpayment in the accounting integration, the schedule will not take it because it will not find a connection.
Then, if you decide to connect the company to Xero again in a couple of days, the integration will not be able to pull the overpayment because it will only look for charges and overpayments that have been added or modified within the last 6 hours.
Integrate OfficeRnD with Xero
To set up your OfficeRnD and Xero integration, you must first have both OfficeRnD and Xero accounts.
Important: To connect OfficeRnD to a Xero account, the Xero user that connects the integration must have at least Standard user permissions for the Xero organization. Read more about Xero user permissions.
Next, follow these steps:
1. Go to Settings > Integrations.
2. Locate Xero under the Accounting section and click Activate.
3. Click Connect and authorize OfficeRnD to use your Xero account. You can choose to select one shared Xero account for all locations or configure individual Xero accounts for each location you created in OfficeRnD.
4. Click Add and enter the OfficeRnD location(s) that you want to map to the Xero account. You can connect each location created in OfficeRnD to a specific Xero account. This way, you can map the same OfficeRnD billing accounts to different Xero revenue accounts based on the locations of the customers being invoiced. The system will connect the Xero integration with all OfficeRnD locations by default.
5. Click Configure to define the mappings between OfficeRnD and Xero.
Tip: When you connect OfficeRnD to a Xero instance invoicing other products or services outside of what OfficeRnD invoices, we recommend using the Xero numbering to avoid the two systems duplicating invoice numbers. In that case, go to Settings > Billing Settings > Billing Rules and clear Generate invoice numbers in OfficeRnD.
The configuration is like an interpreter between the OfficeRnD and Xero languages. The "conversation" between the two systems revolves around invoices and is driven entirely by OfficeRnD. Depending on how you set up the integration, OfficeRnD will let Xero know when a new invoice is generated and updated.
OfficeRnD can also regularly ask Xero for updated invoice payments. You control whether these "conversations" are automated or manually triggered. Each "conversation" contains information about the invoices and their line items, so you need to configure mappings between the attributes of the invoice line items in OfficeRnD and Xero - tax rates, plans, payment accounts.
Notes
Companies with the same emails will have their invoices synced under the same account in Xero. Please make sure that each company has a unique email address.
The integration syncs both by email and customer name, with the following priority:
1. Match the email. If there’s a match, we’ll sync the invoices under that single account.
2. If we can’t match by email, we’ll attempt to match the name.
General Settings
The general configuration settings are available under the General tab.
Default Status - configure the default status of the invoices created by OfficeRnD in Xero. This status is applied when an invoice is first created after a sync operation between OfficeRnD and Xero.
Note: If the invoice is initially synced with draft status to Xero, then you must approve the invoice in Xero and then sync it.Sync Behavior - configure the sync behavior so that invoices are synced manually or automatically when you create or update them in OfficeRnD.
Pull charges automatically - tell the system if you want it to automatically pull charges from Xero. When that option is enabled, invoices reconciled in Xero will be automatically marked as Paid in OfficeRnD.
Pull overpayments automatically - tell the system if you want it to automatically pull overpayments from Xero.
Reference template - If you want to generate the invoice documents in Xero, you can create a template and use it to populate the invoice Reference property in Xero. You can use the following OfficeRnD placeholders in this template: documentNumber, documentReference, customerName, customerEmail.
Revenue Accounts Mapping
The Revenue Accounts tab is the most important tab for integration. Within it, you "translate" the accounts configured in OfficeRnD under Settings/Billing Settings/Revenue Accounts to accounts you created in Xero. These mappings define how OfficeRnD allocates each invoice line item to an account in Xero.
You find a list of all Accounts configured in OfficeRnD on the left side of the tab. Each one needs to be mapped to an account in Xero. You can map OfficeRnD revenue accounts only to Xero accounts of the Revenue and Liability type. Learn more about accounts in Xero.
Payment Accounts Mapping
Note: If you're going to sync payments from Xero to OfficeRnD, each payment account needs to be mapped to a single account in Xero, otherwise when the system is pulling a payment from Xero it won't allocate it to the correct payment method in OfficeRnD.
The Payment Accounts tab enables you to map every payment option available in OfficeRnD to a payment account in Xero. On the left-hand side, it lists all payment options in OfficeRnD, starting with the manual payment options and listing any options provided by an integrated payment provider.
Cash - map to a Xero payment account to record cash payments manually entered on invoices in OfficeRnD.
Bank Transfer- map to a Xero payment account to record bank transfer payments manually entered on invoices in OfficeRnD.
POS - map to a Xero payment account to record POS payments manually entered on invoices in OfficeRnD.
Cheque - map to a Xero payment account to record cheque payments manually entered on invoices in OfficeRnD.
[Payment provider] Card - this option is only available if you integrated OfficeRnD with a credit card payment provider. Map to a Xero payment account to record credit card payments charged via OfficeRnD.
[Payment provider] [Payment Method]- this option is only available if you integrated OfficeRnD with a payment provider that officers non-credit card transactions such as ACH. Map to a Xero payment account to record the payments charged via OfficeRnD.
Note: Please make sure to map each Payment Account to the corresponding Xero account to ensure your Overpayment documents will be synced. If you have not mapped Cash, for example, and you have an Overpayment created with Payment Method Cash, it will be ignored by Xero, and there will be no sync.
Tax Rates Mapping
The Tax Rates tab enables you to map every tax rate you configured in OfficeRnD under Billing > Tax Rates to a tax rate in Xero. Make sure to map every tax rate, including the 0 tax rate options; otherwise, the integration will yield errors.
Enable Tracking
The Tracking tab won't appear unless you enable tracking in Xero. Click here to learn more.
The Tracking tab allows you to track invoice line items in Xero based on the location of the invoice in Xero.
Within an invoice, you can have line items that have different locations. Each line item is correctly tracked and reported to Xero. If you have identical line items from different locations, they won't be merged but will show up as separate lines on the invoice.
Track location by - select whether you want to use Classes or Locations in Xero to tag the invoices.
[Location Name] - map every OfficeRnD location to a class or location property in Xero so that OfficeRnD knows how to translate the invoice location to Xero. Based on that setting, you will be able to track the revenue streams per location.
Branding Mapping
This option only becomes available when you have created at least one custom branding theme in Xero. Learn more about custom themes here. The Branding tab enables you to map each of your OfficeRnD locations to a branding theme in Xero.
Inventory Mapping
The Inventory tab lets you map the OfficeRnD Billing Plans to inventory items you create in Xero. These mappings must be configured only if you haven't configured Revenue mapping and your accounting works based on inventory rather than accounts.
Note: If you map an OfficeRnD account to a Xero account in the Revenue Account tab, it will take precedence over the inventory items mappings.
You find a list of all Billing Plans configured in OfficeRnD on the left side of the tab. Each one can be mapped to an inventory item in Xero.
Connecting Members and Companies to Xero
After you've successfully set up your integration with Xero, you'll be able to see an Integrations section in the profiles of both individual members and companies.
By default any new member/company is not connected to Xero, however, once an invoice issued to them is synced, they'll be connected.
These changes will be visible in the integrations section with a little status text.
Additionally, there's a link icon, which, when clicked, will open a new tab that will open your Xero account and the profile of the selected member/company.
Depending on whether the company is connected or disconnected, you'll be able to manually disconnect or connect a member/company to Xero. Disconnecting a contact from Xero will break the link between the contact in Xero and the profile in OfficeRnD, but the link will be automatically re-established the next time an invoice is synced.
Choosing to Connect a contact from OfficeRnD to Xero will allow you to pick from a list of contacts in Xero to which to link the profile in OfficeRnD.
Note: The manual connect is unnecessary if you sync an invoice for the company/member. This should only be done for members and companies that haven't issued an invoice to them yet.
Credit Limits
Presently, OfficeRnD Flex does not support or recognize Xero credit limits. Consequently, invoices issued from OfficeRnD Flex and synced with Xero won't adhere to the credit limit invoice status rules.
Even if a credit limit is exceeded in Xero, invoices can still be generated. However, they will either have a “Draft” status or can be sent for approval with the status “Awaiting approval”.