Xero 

Introduction 

RevRec seamlessly integrates with Xero to sync invoice data from Xero into RevRec or post your journal entries from RevRec into Xero. All you have to do is connect the two systems using the sync interface and configure the connection flow based on your business needs.

Sync Overview 

You can integrate your RevRec site with Xero for two main flows such as:

  • Invoices: Connecting RevRec with Xero for Invoices syncs your billing records from Xero into RevRec.
  • Journal Posting: Connecting RevRec with Xero for journal posting pushes monthly journal entries to the Xero ledger.

Configuring Invoices Flow 

If you are using Xero to send invoices to customers, RevRec can be used to pull invoice data from Xero.

  • RevRec tracks invoices at the customer level. All invoice data from Xero is pulled based on customer name mapping, while sales orders are pulled from the CRM system. It is therefore important that the customer name as specified in Xero matches with that in your CRM system.
  • RevRec also supports pulling invoice data from Xero to create sales order records from the invoices. In this case, RevRec treats each invoice as an independent contract, the terms of which match the terms of the invoice. This means you will see a new sales order in RevRec for each invoice that gets synced.

Connecting RevRec with Xero for Invoices 

Note

Only users with Admin role can connect your RevRec site with Xero.

You can connect your RevRec site directly to Xero. Follow these steps to integrate the two systems:

  1. After logging in to your RevRec site, navigate to the right environment in which you are integrating Xero.

  2. Click Sync > Connect to other systems icon.

  3. On the Connect your data pop-up, select Invoices > Xero.

  4. On the Configure Xero screen, specify the following connection parameters:

    • Invoice Equals Contract: Enable this setting if each invoice corresponds to a contract. Use this setting to pick invoice data from Xero and create sales order records based on that data.
    • Use Customer Name Mapping: Enable this setting to map records based on the Customer Name field. You can use this setting to map the invoice data from Xero using the customer's name with sales order data pulled from CRM.
    • Ignore Items: This field is used to define item records for which invoice data needs to be ignored while pulling data from Xero. You can define a single item or multiple items to be excluded.
      Value for this field needs to be given in format: ProductName1 | ProductName2 | ProductName3
    • Date Format: This field can be used along with the Invoice Equals Contract setting. You can select a particular date format from the drop-down list available for this field. RevRec will pick the data for the Service Start Date and Service End Date fields for sales orders based on the date format selected. RevRec looks for these dates in the description field of Invoices or Credit Memos created in Xero.
    • Currency: This field is used to map currency in which data needs to be picked and processed in RevRec.
    • Reference: You can specify this optionally if you need any data field to be synced from Xero, to capture data on invoices such as customer id or other invoice-related information.
  5. Once you are done, click Connect your data to establish the connection between Xero and RevRec.

  6. You will see a popup window asking for the login credentials of your Xero account to be used for establishing the link.

  7. Once you enter the login credentials, another popup window will open asking you to select the relevant Xero organization (user account) to establish a connection with.

Upon establishing a successful connection with Xero, you will see a success message displayed as follows:

Execution of Invoices Flow 

After establishing the link as described in the previous section, click Xero.

In the Quick Options tab, click Edit schedule to schedule an automated data sync from Xero to RevRec in your preferred frequency. The invoice flow is executed automatically based on the schedule to sync data from Xero.

Click the Run job option to execute the invoice flow that picks data from Xero on-demand.

When you execute the invoice flow, you will see a job created on the Sync UI page in the Recent Jobs tab.

If you have not set any accounting period yet, click the Download file icon to download the file and upload it manually using the Import Data in Bulk option.

If you have already scheduled the automated sync, any jobs getting created will load the data automatically and you don't have to load the data manually. You can still download the data file created for a specific job by clicking the Download file icon.

  • If you are using the 'Use Customer Name Mapping' setting, the downloaded excel file will contain the following tabs:

    • BillingSchedule: Displays all data pulled for invoices, and credit notes.
    • Product: showing product data picked from Xero.
    • PendingData: This tab will only show up if there are some invoices or credit notes created for a customer whose name doesn't match with any Customer records in CRM.
    • ReconDetails_Invoice: This tab shows a reconciliation between data pulled from Xero and data that is loaded in RevRec for each period on a customer-by-customer basis.
    • ReconSummary_Invoice: This tab shows a reconciliation between data pulled from Xero and data that is loaded in RevRec grouped on a period-by-period basis.
  • The downloaded excel file if you are using the 'Invoice Equals Contract' setting will contain the below tabs:

    • OrderDetails: Displays all sales order records created using the invoice data from Xero.
    • BillingSchedule: Displays all data pulled for invoices, and credit memos.
    • Product: Displays product data picked from Xero.
    • Customer: Displays a list of contacts from Xero as customers to whom sales invoices have been sent.
    • ReconDetails_Invoice: This tab shows a reconciliation between data pulled from Xero and data that is loaded in RevRec for each period on a customer-by-customer basis.
    • ReconSummary_Invoice: This tab shows a reconciliation between data pulled from Xero and data that is loaded in RevRec grouped on a period-by-period basis.
Note

Contact RevRec Support for any sync failures due to recon errors.

Pending Data

Any invoice or credit memo created for a customer record, wherein the customer name doesn't match with records picked from other CRM systems like Salesforce or HubSpot, RevRec displays them as Pending Data.

Pending data can be cleared once you add/update the relevant customer record in Xero to match with the customer data in CRM. The next Invoice job executed in RevRec will automatically remove the respective updated records from the Pending Data list.

Use Cases Supported 

RevRec supports the below use cases for pulling data related to Invoices, Credit Notes, and Adjustments from Xero:

Invoice

  • All sales invoice data gets pulled whether paid, partially paid, or unpaid.
  • Invoices in Draft or Awaiting Approval status in Xero are not pulled.
  • Void sales invoice data are pulled.
  • Deleted sales invoice data are not picked.
  • Changes made to prior period or current period sales invoices are also picked.

Credit Memo

  • All sales credit memo data gets pulled whether created directly as a sales credit memo or through converting a sales invoice to a credit memo.
  • Credit Memos in Draft or Awaiting Approval status is not pulled.
  • Deleted sales credit memos are not picked.
  • Changes made to the prior period or current period sales credit memos are also picked.

Configuring Journal Posting Flow 

You can configure the journal posting flow to post your journal entries automatically to Xero when you close an accounting period. Ensure that you configure your journal account mapping before posting your journal entries.

Connecting RevRec with Xero for Journal Posting 

Note

Only users with Admin role can connect your RevRec site with Xero.

You can connect your RevRec site directly to Xero from within RevRec. Follow these steps to integrate the two systems:

  1. After logging in to your RevRec site, navigate to the right environment in which you are integrating Xero and click Accounting.

  2. On the Accounting page, click the Connect icon.

  3. On the Connect your data popup, select Journal Posting.

  4. The Journal Posting popup displays all the available accounting systems for integration. Click Xero.

  5. On the Connect Xero screen, specify the connection parameters.

    If you want to publish journal entries based on custom fields, you can optionally map the CustomField names defined in Xero with those created in RevRec. Let's say you have defined a custom field by name of Region in Xero, and the same is defined as Location in RevRec. In order to map these fields with each other, simply specify Region under the Location field. Map other fields as required.

  6. Click Connect your data and provide login details for your Xero account. Select a relevant organization to which you want to publish your journal entries from Revrec.

Once connected, RevRec will publish the Journal Entries created when you close the accounting period.

Execution of Journal Posting 

A message gets displayed on the Home page at the accounting period close for the initiation of the Journal Entries posting.

Once the posting flow is completed, you can check the journal entries posted in your Xero system by accessing the Journal Report.

Publishing Journal Entries Using Custom Fields 

RevRec supports publishing journal entries to Xero based on custom fields defined. In Xero, custom fields are referred to as Tracking Categories. You can configure RevRec to create and publish Journal Entries based on Tracking Categories like Location, Department, Class, and so on.

Contact our implementation team to set up custom fields that you want to use for Journal Entries posting.

Was this article helpful?
Loading…