Reflow

Guide to Importing Trial Balance into Go Systems from Xero

Table of Contents

Overview

This guide provides a detailed process for importing a trial balance from Xero into Go Systems. The instructions are tailored to ensure accurate data transfer and integration.

Platforms Involved

  • Go Systems
  • Xero

Workflow

Step 1: Log into Go Systems

  • Begin by logging into your Go Systems application.
    Log into Go Systems

Step 2: Access Xero and Export Trial Balance

  • Log into your Xero account.
    Log into Xero
  • Navigate to Accounting and then Reports. Search for "Trial Balance" and select it.
    Search for Trial Balance
  • Update the columns to include only the necessary data: account, account code, and two-year comparatives.
    Update Columns
  • Export the trial balance to an Excel file.
    Export to Excel

Step 3: Prepare and Format Data

  • Open the exported Excel file and enable editing.
    Enable Editing
  • Download a copy of the TRC template from your Google Drive.
    Download TRC Template
  • Use VLOOKUP to align the data with the TRC template.
    Use VLOOKUP

Step 4: Import into Go Systems

  • Navigate to the Trial Balance section in Go Systems and select Import.
    Import Trial Balance
  • Drag and drop the prepared Excel sheet into the import window and select the TRC Zero template.

Step 5: Finalize and Compute

  • After importing, go to Compute to update the trial balance.
    Compute Trial Balance
  • Review the imported data and ensure all figures are correct. Adjust if necessary.
  • Once verified, update your organizer and hit Compute again to finalize.
    Finalize Data

Change Control Log

  • Version 1.0: Initial creation of the guide.
  • Version 1.1: Added screenshots for better visual guidance.
  • Version 1.2: Updated instructions for clarity and improved accuracy.