Validating Data

After each Automatic Sync and Process, the Consolidated XL Chart of accounts is checked against the Xero, QuickBooks or Sage Accounting Trail Balance. If any significant errors are found our support department will be notified for investigation.

Manualy checking the Trail Balance

To check your trial balance, follow these steps: Click on the Settings menu button and select "Sync With Accounts". A new window will open up. Here, you need to tick the "Check Trial Balance" option. On the next page, you can select the company/companies that you want to check the trial balance for. Once you've made your selection, your trial balance will be sent to you via email, along with an attachment containing a detailed TB for each company selected.

View Last Trail Balance

A summary of the trail balances performed after the last sync can be viewed by selecting the Settings menu button and selecting "View Last Trail Balances".

Trail Balance Errors Explained

It is possible for Consolidated XL Trail Balance not to agree with your accounts package.

The following explains these:

Several reasons could cause Errors

• A transaction being posted during the sync process - It's a small window of opportunity, but it could happen.

Xero Specific reasons

• Currency Rates - If Currency is enabled, the Hourly updated CXL Currency Rates may slightly differ from your account package.
• Cash Accounting and Stock - Currently we have no way of knowing the amount of stock moving out of the door. Hence, the "Stock Inventory" will not agree with Xero if asked to report using 'Cash Accounting' reporting method, but fine with "Accrual" accounting method.

QuickBooks Specific reasons

Work in progress...