Xero: Reconcile Transactions
Integrating your Unleashed account with Xero enables you to ensure that any transactions performed in Unleashed are sent to your Xero account. But what if there is a variance between the two platforms?
The Reconcile Transactions tool looks for any unexported transactions in Xero and allows you to export them again. It’s a great troubleshooting tool and we’d recommend that you use it often.
Let’s take a look at how.
How to export transactions
First of all, head to your integration store and select the Export Xero Data tab. By default, you’ll see sales order information for the current date range. You can view other transactions as well: including purchase orders, purchase costs, assembly costs, supplier returns and more.
From there, follow these six steps to reconcile your transactions.
- Select a transaction type, then select a date range. We recommend that you run one week at a time, or up to one month as a maximum
- Unleashed will display the total number of variances for the given time period. It’ll also give details on those transactions
- Click the Reconcile Transactions button. The reconciliation will run in the background
- Refresh the page. You should see a notification confirming that the reconciliation has been completed
- Go back to the Export Xero Data tab. Re-enter your date range and reselect your transaction type
- At the top of the screen, the variance count should now be zero
In the individual transactions listed below you should see:
- The same figure in the Total and Xero Total columns
- ‘0.00’ in the Variance column
- ‘Exported’ showing in the Export Status column
- ‘Xero’ displayed in the View column. Click this link to see the transaction in Xero
Please note that it is possible to click Export numerous times. If you are trying to duplicate a sales order, then you’ll get a warning message. Be aware, however, that the system will allow duplicates for purchase orders and credit notes.
What's next
- Implementation
- Ground Training
- Customers
- Inventory
- 2:39 Batch/Serial: Stock Adjustment & Stock Take
- 1:30 Introduction to Batch Tracking
- 1:59 Markup Price Update
- 1:32 Introduction to Serial Number Tracking
- 1:22 Supplier Price Books
- 1:26 Batch Purchase Order & Supplier Return
- 1:29 Serial Purchase Order & Supplier Return
- 2:14 Stock Count
- 1:20 Serial: Sales Order & Credit
- 1:18 Batch Tracking Sales Order & Credit
- 1:44 Stock on Hand vs Available Quantity
- 1:52 Obsoleting Products
- 1:41 Product Measurements
- 2:21 List sellable products
- 3:23 Navigate Unleashed like a Pro
- Production
- Purchasing
- Sales
- 2:16 Quantity Discounts
- 1:15 Accept Sales Quote & Create Order
- 1:17 Batch Complete
- 1:03 Create a Sales Order
- 1:17 Sales Order: Managing Invoices
- 1:11 Sales Order: Managing Shipments
- 1:07 Sales Order Credit
- 1:21 Free Credit
- 1:30 Credit Reasons
- 1:47 Managing your Sales Team
- 2:06 Enhanced reporting with customised sales groups
- 1:55 Sales module: Overview
- 1:34 Using the View Shipment Page
- Setup
- Suppliers
- Take Off
- Integration
- 3:06 Seamless Shipping with Advanced Shipping
- 1:11 Shopify: Locate missing order
- 1:28 Magento: Missing Invoices
- 2:20 Magento: Product Type
- 2:22 Xero: Reconcile Transactions
- 1:52 Integrating Shopify – Shopify as Master
- 1:48 Integrating Shopify – Unleashed as Master
- 2:19 Managing Products with Shopify
- 2:05 Integrating with Amazon
- 2:21 Best practices for your Xero integration
- 2:39 Enable credit limits
- 2:24 Setting up Xero Tracking Categories in Unleashed
- Inventory
- 1:42 Batch Tracking: Update Batch Numbers
- 1:54 Importing Files
- 1:02 Product Attributes Invoices
- 1:44 Product Attributes Setup
- 1:52 Receipting Purchase Order with Barcoded Product
- 1:26 Warehouse Transfers
- 0:50 Batch Tracking: Update batch number expiry date
- 2:33 Creating multi layered Bills of Materials with Sub Assembly
- 3:14 How to do a batch recall in Unleashed
- 4:56 Use disassembly to break down bulk products into small units of measure
- 3:20 Manage consignment inventory
- Reporting
- Sales Orders
- 1:38 Ship From Multiple Warehouses
- 1:30 Backordering: Fulfilling Sales Order Via Purchase Order
- 1:43 Backordering: Split Shipments
- 2:30 How to manage dropshipping orders in Unleashed
- 4:08 View and manage your sales orders in Unleashed
- 3:20 How to create Commercial Invoices
- 4:09 Set up pricing hierarchy in Unleashed
- Settings
- 1:43 Multiple Images
- 1:30 Payment Terms
- 1:31 Roles and Role Permissions
- 3:51 How to set up 2-Step Authentication (2SA)
- 2:12 Complete Transparency with Email Logs
- 2:17 Creating and printing customised product labels
- 1:19 Set a default delivery method
- 2:43 Printing product labels
- 2:26 Add Supplier Quantity Price Breaks
- 3:49 How to set up email templates and automated emails
- B2B Store
- 1:40 Allow guests to access to your B2B Store
- 2:10 B2B Freight
- 2:29 Managing your B2B orders
- 2:05 Get your customer records ready for your B2B store
- 2:58 Update product details for your B2B store
- 1:46 Setting up multi currency sales on your B2B store
- 1:58 Setting up product categories in the B2B store
- 1:53 Acting as a customer in the B2B eCommerce portal
- 2:40 Creating catalogues for your B2B store
- 1:59 Grant multiple admin access on your B2B store
- 1:34 Help B2B customers transact efficiently with Standing Orders
- 1:18 Send personalised B2B Emails
- 1:26 Customise your B2B eCommerce Store with content pages
- 2:35 Create custom homepage on your B2B Store
- 1:50 Place bulk orders on the B2B Store
- 4:54 Set up payments for your B2B Store
- 5:00 How to set up multiple contacts in your B2B Store
- 1:17 B2B Standing Orders
- Business Intelligence
- Integration
- In Orbit
- Inventory Management
- 2:02 Essential Steps for Effective Inventory Stocktaking
- 1:57 Advantages of perpetual inventory systems
- 1:44 Leaving your spreadsheets
- 1:27 Facing Software Change
- 2:23 Inventory Management Systems – What to look for
- 1:04 Tips to get your business ready for moving to an inventory management system
- 1:28 Benefits of integrating with other ecommerce softwares
- 2:20 The Rise of the Component Solution
- 3:22 Tips to help you match your product supply to customer demand
- 1:49 Inventory Management vs Warehouse Management
- 1:56 The importance of customer service
- 1:42 Make the most of an inventory management system with training
- Finance Flavour
- Business Bites
- Partners
- Inventory Management
- Access