Skip to contentXero video guides
Watch RachelsTools work in Xero.
Short, practical guides to the Xero shortcuts already available in RachelsTools. Each video links back to the features it demonstrates.
Published tutorials
11 videos for Xero
Xero video guide
Xero – Add transaction line subtotals
Add clear section subtotals to Xero transaction lines for labour, materials and other groups.
Video chapters
- 00:00 Introduction: Transaction Subtotals
- 00:21 Creating Subtotal Rows
- 00:39 Enabling and Applying Subtotals
- 01:23 Recalculating After Changes
Xero video guide
Xero – Freeze headings on long transaction lists
Keep Xero column headings and the customer or supplier column visible while scrolling long lists.
Video chapters
- 00:00 Keep Xero Column Headings Visible While Scrolling
Xero video guide
Xero – Review outstanding balances
Review outstanding customer or supplier balances and transactions from one place.
Video chapters
- 00:00 Introduction: Outstanding Balances
- 00:17 Customer Notes and Balances
- 00:27 Opening Outstanding Transactions
- 00:37 Red Pop-up Note Reminders
Xero video guide
Xero – Import journals from a spreadsheet
Import journal lines into Xero from a spreadsheet for review before posting.
Video chapters
- 00:00 Introduction
- 00:14 Exporting a Known Journal
- 00:42 Spreadsheet Headers and Journal Lines
- 01:40 Exporting Nominal Account Codes
- 02:13 Formulas, Tracking and Reusable Journals
- 02:40 Copying and Importing Journal Lines
- 03:18 Reviewing Tax and Importing Data
- 03:50 Checking the Imported Journal
Xero video guide
Xero – Import invoices from a spreadsheet
Import invoice lines into Xero from a spreadsheet for review before saving.
Video chapters
- 00:00 Introduction
- 00:18 Copying Tables from Notes or Spreadsheets
- 00:59 Exporting an Invoice and Reference Codes
- 01:35 Pasting into Excel or Google Sheets
- 02:09 Choosing Which Header Fields to Import
- 02:29 Editing Quantities and Optional Columns
- 03:16 Creating a New Sales Invoice
- 03:28 Reviewing and Importing the Data
- 03:44 Recalculating Subtotals and Copying Tables
Xero video guide
Xero – Export reports to a spreadsheet
Export a Xero report to the clipboard and paste it into a spreadsheet.
Video chapters
- 00:00 Introduction
- 00:20 Copying a Report to the Clipboard
- 00:33 Pasting into Excel or Google Sheets
Xero video guide
Xero – Export transaction lists
Export selected or complete Xero transaction lists to a spreadsheet or email.
Video chapters
- 00:00 Introduction
- 00:19 Selecting Transactions with Enhanced Copy
- 00:31 Adding a Comment Column
- 00:41 Pasting the Table into an Email
Xero video guide
Xero – Colour-code organisations
Colour-code each Xero organisation so the active company is easy to identify.
Video chapters
- 00:00 Introduction
- 00:23 Opening Company Colour Settings
- 00:35 Recognising the Company with a Colour Haze
- 00:51 Choosing a Colour and Corner Dot
Xero video guide
Xero & QuickBooks – Open external customer links
Open an external website from a Xero or QuickBooks customer record using a configurable link.
Video chapters
- 00:00 Introduction
- 00:13 Linking Customers to an External Website
- 00:32 Passing a Customer Name in the URL
- 01:10 Enabling and Configuring the Link
- 01:39 Using Xero Account Details
- 01:58 Understanding the QuickBooks Customer ID
Xero video guide
Xero & QuickBooks – Sync settings across computers
Synchronise RachelsTools settings and supported recent lists across computers.
Video chapters
- 00:00 Synchronising RachelsTools across computers
- 00:23 Settings, recent contacts and transactions
- 00:43 Data storage and opt-in synchronisation
- 00:58 Opening Settings and Sync
- 01:10 Choosing what to synchronise
- 01:35 Free and Pro limits and recent-list settings