Skip to main content

Xero Advanced Features

Configure and use the Xero integration's advanced features, including Customer Credit Limits, Payment Received Flag sync, and Tracking Categories.

Heather Worthington avatar
Written by Heather Worthington
Updated this week

The Xero integration in Unleashed offers several advanced features that can enhance your financial management and reporting capabilities. These features provide better visibility into customer finances, streamline payment tracking, and enable more detailed reporting through Xero's tracking categories.


Tutorial Videos

Setting Credit Limits with Xero and Unleashed

Xero Tracking Categories in Unleashed


Customer Credit Limits

The Customer Credit Limits feature automatically syncs outstanding invoice balances from Xero to Unleashed, allowing you to set and monitor credit limits for individual customers. This provides better control over customer debt and helps prevent overextension of credit.

Benefits

  • Risk management: Prevent customers from exceeding predetermined credit thresholds.

  • Real-time visibility: Automatic hourly sync of customer outstanding balances from Xero.

  • Flexible control: Option to override credit limits when necessary.

  • Business protection: Maintain cash flow by controlling customer credit exposure.

Requirements

Before enabling Customer Credit Limits in the Xero integration, ensure:

  • Your Unleashed and Xero accounts use the same base currency.

  • You have a Superuser role, or your user role has the permissions "Override Credit Limits" and "Set Credit Limits", found under the permission menu Sales > Customers, enabled.

Enable and configure

To enable the sync of customer credit limits from Xero:

  1. Navigate to Integration > Integration Store > Xero.

  2. Click the Configuration tab.

  3. Scroll to Advanced Features.

  4. Toggle on "Enable Customer Credit Limits".

  5. Click "Save Configuration".

To apply credit limits to customers:

  1. Open a customer's record.

  2. In the Details tab, toggle on "Apply Credit Limit".

  3. Enter the credit limit amount in "Set Credit Limit"

  4. The "Credit Balance" will automatically sync from Xero every hour with the customer's outstanding invoice balance.

Screen Shot 2023-09-14 at 3.21.08 PM.png

To apply credit limits to multiple customers, use the Import Customers template.

Important: The customer's Credit Balance field will sync only when they have approved invoice(s) in Xero.

Using Customer Credit Limits

Whilst the customer's Credit Balance will automatically sync hourly, you can click on the refresh icon in the customer's record, in the Details tab next to the Credit Balance, to manually refresh it. The manual sync will only refresh once every 15 minutes.

When a Credit Limit has been applied to a customer, and their synced outstanding invoice balance exceeds the limit, you can create and complete Sales Order invoices for the customer, but you cannot complete the Sales Order's shipments.

However, if your user has the "Override Credit Limits" role permission enabled, you can choose to ignore the exceeded credit limit for the customer by ticking the "Ignore Credit Limit" checkbox in their Sales Order. This will allow you to dispatch Shipments and complete Sales Orders for the customer, regardless of their outstanding invoice balance in Xero.

Screen Shot 2023-09-14 at 3.41.52 PM.png

Payment Received Flag Sync

The automatic Payment Received Flag feature in the Xero integration automatically syncs payment information from Xero invoices to your Unleashed Sales Invoices, updating them with a "Payment Received" flag when any payment has been applied in Xero.

Benefits

  • Automated tracking: Eliminates manual checking of payment status.

  • Real-time updates: Hourly synchronization keeps payment status current.

  • Streamlined workflow: Reduces time spent cross-referencing between systems.

  • Better visibility: Quick identification of which invoices have received payments.

Enable and configure

To enable the Payment Received Flag and set its sync rate:

  1. Navigate to Integration > Integration Store > Xero.

  2. Click the Configuration tab.

  3. Scroll to Advanced Features.

  4. Toggle on "Enable Syncing Xero Invoice Payment Details With the Payment Received Flag".

  5. Use the "Polling Frequency" dropdown menu to select one of the following sync rates:

    • Every hour

    • Every 6 hours

    • Daily

  6. Click "Save Configuration".

Using the automatic Payment Received Flag sync

When enabled, the integration will check for invoice payments either hourly, every 6 hours, or once a day, depending on the configuration's "Polling Frequency". When any amount is paid for an invoice in Xero, the integration will update the synced invoice in Unleashed with a "Payment Received" flag. This indicates to you in Unleashed that a payment was received, but it does not specify if the payment is partial or complete.

The Payment Received sync is a one-way sync, meaning Xero will remain your source of truth for payment information. Any manual changes made to an Unleashed Invoice's Payment Received flag will not sync back to Xero, see Marking a Sales Invoice as Payments Received.


Tracking Categories

Tracking Categories enable you to pass additional data from Unleashed to Xero for enhanced reporting and analysis. This eliminates the need for multiple account codes while providing detailed transaction categorization.

Benefits

  • Enhanced reporting: Leverage Xero's advanced reporting with detailed categorization.

  • Better analysis: Track performance by warehouse, salesperson, product group, and more.

  • Streamlined setup: Automatic categorization of transactions.

  • Flexible reporting: Create custom reports based on multiple tracking dimensions.

Supported categories and transactions

The data categories available to track on the transactions exported from Unleashed ot Xero are:

  • Warehouse

  • Sales Person

  • Sales Group

  • Product Group

  • Customer Type

Up to two Tracking Categories can be applied to the following transaction types:

  • Sales invoices

  • Sales journals

  • Purchase orders

  • Credit notes

  • Credit journals

  • Supplier returns

  • Supplier returns journals

  • Stock adjustments

  • Stock takes

Some Tracking Categories may not be available for all exported journals, as the integration doesn't sync with the inventory side of Xero, e.g., sales journals will not export Product Group data.

Enable and configure

To successfully track categories from Unleashed, you must first configure the matching categories in your Xero account. For example, if you are tracking Warehouses, you must add the name of each warehouse in your Xero account's Tracking Categories page.

Important: Tracking Categories are case sensitive. The name of each tracking category added in Xero must identically match in Unleashed, including spaces and special characters.

To configure tracking categories in Xero:

  1. In Xero, go to Accounting > Advanced.

  2. Click "Tracking categories".

  3. Click "Add Tracking Category"

  4. Select your desired category:

    • Warehouse

    • Sales Person

    • Sales Group

    • Product Group

    • Customer Type

  5. Add category options that exactly match your Unleashed names (case-sensitive).

  6. Save the category.

You cannot create, manage, or delete Xero's tracking categories from within Unleashed. You must update both systems manually to apply any changes. For more details on adding Tracking Categories in Xero, see Set up tracking categories.

To enable Tracking Categories for your Xero integration:

  1. Go to Integration > Integration Store > Xero.

  2. Click the Configuration tab.

  3. Scroll to Advanced Features.

  4. Toggle on "Tracking Categories".

  5. Use the "Tracking Category" dropdown menus to select up to 2 categories.

  6. Tick the transaction type checkboxes to select which transactions will include the selected tracking category's data.

  7. Click "Save Configuration".

image (32).png

Using Tracking Categories

Transactions that have already been exported to Xero, before the integration's Tracking Category feature has been enabled or updated, will not update retrospectively to include Tracking Categories.

However, from then on, when the selected transactions export to Xero, the Xero transaction will include the Tracking Category's detail, as selected in the Unleashed transaction. You can then filter your reports in Xero by these tracking categories.

If a tracking category exists in Unleashed but has not been added in Xero, when the category is selected in an Unleashed transaction, when the transaction is completed, it will successfully export to Xero, but its tracking category field will be blank.

πŸ“Œ Note: The Tracking Categories displayed in your Xero Sales invoice and Purchase bill will be the options you have configured in Xero, irrespective of the options you have selected in Unleashed, and will be common for both Sales and Purchases.


Frequently asked questions

Is it possible to generate a report showing each customer's current credit balance?

When the Advanced Feature "Customer Credit Limits" is enabled within your Xero integration, each customer's current Credit Balance will sync from Xero to be displayed in the customer's Details tab.

There is no report or exportable page in Unleashed that will show a comprehensive list of all customers and their current credit balances. Instead, go directly to your Xero account to review a full report for all customer credit balances.

Did this answer your question?