Setting up Sage 300 in Lightyear

Setting up Sage 300 in Lightyear

Lightyear allows you to export your bills in a pre-set CSV format, which can then be uploaded directly to Sage 300.  

To get started, head to the Accountancy tab in Lightyear > Under Accountancy Software, select Sage 300.  

Once done, you'll need to start importing your settings from Sage. Let's look at these individually

Software Settings

Departments:  You may use departments within Sage to help track of your bills, you may not. if you do, select Yes. This will add the Departments section to the Accounting Software screen where you can upload you departments.  You can then apply departments on a line by line level in Lightyear and set rules to automatically assign Departments.  

Details Setting :   Within Lightyear, you have 3 options related to what is populated in the 'details' field. 
  1. 'Use Nominal Description' -  If you select this option, Lightyear will populate the details section of each individual line with the Description of the relevant account code that applies to that line.  This is the Default setting/
  2. 'Do not populate' - This option will leave the Details field empty when you export.  Use this option if you do not want any details information or if you prefer to manually add the details within the CSV export.   
  3. The third option is available in the in-tray.  You will notice a 'details' option in Panel 2.  If you enter text into this field in panel 2, that text will populate on all the lines for the CSV export.

Sage 300 Suppliers

These are your Suppliers within Sage, and are used so Lightyear knows which supplier to associate any given bill with. To set up a Supplier, you'll be asked for a Supplier Name and an Account Reference. The Supplier Name is just used as an identifier in Lightyear, but the Account Reference would need to be the 3 digit Account Reference code for that supplier within Sage. 

You can edit any of the Suppliers by clicking on the Green pencil

You can bulk upload your supplier Accounts via the 'Upload CSV File' Option located above the supplier table.  

Chart of Accounts

These are your Account Codes within Sage. Lightyear requires the 3 digit Account Code and a description or label to go along with these.

Tax Rates

While you can add as many tax rates to Lightyear as you wish, please note that you will only have one default taxed and one default tax free rate. Enter your Tax Code from Sage (TXX), a description and the rate. Super Simple. The In Use box will be checked by default, so it's ready to use as soon as it's created.

Please note that all the above can be added quickly and easily using Bulk Upload.

And with that, the setup is done! You can now start exporting bills to Sage.


    Check out our
    to stay up to date

      • Related Articles

      • Setting up Sage 200 in Lightyear

        Sage 200 Setup Please note - CSV Templates are attached to this article. Please use them when importing information to your Lightyear Account from Sage. Lightyear allows you to export your bills in a pre-set CSV format, which can then be uploaded ...
      • Sage Intacct Integration Setup Guide

        Connecting to Sage Intacct As Sage Intacct and Lightyear are both cloud-based, set up and connectivity between the systems is seamless. Here's how! Prerequisites Subscribe to Web Services You will need to add your Company's Sender ID to the Sage ...
      • Exporting from Lightyear to Sage Intacct

        Prior to export, please ensure you have your Rounding Account Code (Accountancy > Chart of Accounts) and Default Tax/Tax Free Codes (Accountancy > Tax Codes) set. From the Signed Off tab in Lightyear, select the invoices you want to export and press ...
      • Adept Middleware for Sage 50 advanced import

        Why Should I Use Adept? 1) Import line item detail into Sage 50 2) View currency conversion rates of foreign currency invoices 3) Create new suppliers, when new invoice data is imported 4) Multi company auto recognition upon import Adept is an ...
      • Sage Business Cloud Integration Setup Guide

        Connecting to Sage Business Cloud As Sage Business Cloud and Lightyear are both cloud-based, set up and connectivity between the systems is seamless. Here's how! Please Note: Our Sage Business Cloud integration only works via the Northern Hemisphere ...