Skip to main content

How RentalTide and Xero Work Together: Product Sync, Inventory, and Accounting Guide

Updated over 2 weeks ago

Here is a clear, structured Help Center article you can publish as is. It is written in a neutral documentation voice, avoids any informal phrasing, and explains exactly how RentalTide and Xero work together.


How RentalTide and Xero Work Together: Product Sync, Inventory, and Accounting Guide

This guide explains how RentalTide and Xero integrate for products, inventory, pricing, and POS accounting. It defines which system is the source of truth for each type of data, how syncing works, and what to expect during setup and daily use.


1. Overview

RentalTide integrates with Xero to manage revenue, inventory movement, and cost of goods sold (COGS). Each system has fields and functions the other does not, so the integration follows a clear “source of truth” model:

  • Xero controls product, cost, and inventory data.

  • RentalTide controls POS layout, tags, and all staff-facing display settings.

This model keeps accounting accurate while allowing full flexibility in the POS.


2. What Xero Controls (Source of Truth)

Xero is the master for all accounting-critical fields. When importing from Xero into RentalTide, these values are always respected and updated.

Xero owns:

  • SKU (ItemCode)

  • Item Name and Description (used on invoices)

  • Sales Price

  • Cost Price

  • Quantity on Hand

  • Sales Account (Revenue GL)

  • Inventory Asset Account

  • Cost of Goods Sold Account

  • Tax Rate

Any change made to these fields in Xero can be synced into RentalTide through the “Import from Xero” function.


3. What RentalTide Controls (Source of Truth)

RentalTide is the master for all POS-specific or staff-facing elements. These do not overwrite Xero, and Xero does not store these fields.

RentalTide owns:

  • POS categories

  • POS folders

  • POS layout and tiles

  • Tags

  • Staff-facing product labels

  • Images

  • Location and kiosk assignment

  • Price groups and dynamic price rules

  • Variant IDs (internal system references)

These fields only affect how staff interact with products inside RentalTide. They do not affect accounting records.


4. How Product Import and Syncing Works

4.1 Uploading Products Into Xero

To set up products for syncing, items must first exist in Xero. Upload them using Xero’s item import template, including:

  • ItemCode (SKU)

  • Name

  • Description

  • Sales Price

  • Cost Price

  • Sales Account

  • Inventory Asset Account

  • COGS Account

  • Tax Rate

Once accepted by Xero, this becomes your master item list.

4.2 Importing Products From Xero into RentalTide

In RentalTide, go to:

POS → Import → Import from Xero

RentalTide will display all Xero products. For each item:

  • If it does not exist in RentalTide, it will be created using Xero’s data.

  • If it already exists, RentalTide updates only the Xero-owned fields:

    • Price

    • Cost

    • Quantity on hand

    • Active status

  • RentalTide-specific fields remain unchanged.

This ensures financial data matches Xero, while your POS layout remains intact.


5. How Inventory Quantities Sync

RentalTide does not generate inventory quantities itself. All quantities come from Xero.

When you sell an item in RentalTide:

  1. The sale is included in the daily settlement.

  2. Settlement creates an invoice in Xero.

  3. Xero reduces the quantity on hand.

  4. Xero posts the COGS entry.

Because Xero handles all stock tracking, the quantity will always match the accounting inventory.

If you adjust stock manually in Xero or update via purchase orders, importing again into RentalTide will bring the updated quantity in.


6. How Cost of Goods Sold Is Calculated

RentalTide does not calculate COGS. All COGS activity happens inside Xero:

  • When a purchase bill or purchase order is approved, Xero debits Inventory Asset.

  • When an item is sold (from the RentalTide invoice), Xero posts:

    • Dr Cost of Goods Sold

    • Cr Inventory Asset

This ensures accurate stock valuation and avoids double posting.


7. How Daily Sales Post to Xero

7.1 Settlement Process

RentalTide uses a daily settlement model. At till closing:

  • All POS activity for the day is summarized.

  • Payments (cash, card, account charges) are grouped.

  • A single invoice or journal is sent to Xero.

7.2 What Xero Receives

Xero receives:

  • A summary invoice with all items sold that day

  • Quantities and prices from RentalTide (matching Xero items)

  • Payment information for cash and card transactions

  • GST based on Xero’s tax settings

7.3 Inventory and COGS

When Xero receives the invoice:

  • Inventory quantity decreases

  • COGS is posted automatically

The POS never posts COGS, so double counting cannot occur.


8. Handling Differences in Columns Between Systems

RentalTide and Xero have different datasets because they serve different purposes.

Xero tracks:

  • Financial fields

  • Tracking flags

  • Asset and liability movements

RentalTide tracks:

  • POS visuals

  • Staff workflows

  • Price groups

  • Kiosk assignment

During import or export:

  • Xero-only fields stay in Xero

  • RentalTide-only fields stay in RentalTide

  • Shared fields are synchronized where applicable

There is no requirement for both systems to have identical column sets. Instead, each system maintains the fields it owns and syncs only where appropriate.


9. Recommended Setup Approach

Step 1: Build your product list in Xero

Use the provided template or Xero’s CSV upload.

Step 2: Sync into RentalTide

Use the “Import from Xero” function to pull in all items.

Step 3: Configure POS layout

Tags, folders, and kiosk assignments are done in RentalTide.

Step 4: Operate using daily settlement

All sales flow into Xero as daily summaries rather than individual entries.

Step 5: Use clearing accounts for testing (optional)

This allows full end-to-end testing without affecting live GL accounts.


10. Key Principles to Remember

  • Xero owns all accounting data.

  • RentalTide owns all presentation and workflow data.

  • Daily settlement ensures clean accounting entries.

  • Inventory and COGS logic lives entirely in Xero.

  • Product imports are one-directional for master data: Xero → RentalTide.

  • POS mapping remains simple: one revenue GL per item.

Did this answer your question?