Sage 300 Integration Setup Guide
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.
- '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/
- '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.
- 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.
Migrating Software?
Once you select Sage 300 as your software, you won't be able to change it. If you are thinking about changing accountancy software, please reach out to our Support team for guidance on how to do so.
Check out our
to stay up to date
Related Articles
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 ...Sage 200 Integration Setup Guide
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 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 ...AccountsIQ Integration Setup Guide
Connecting to accountsIQ Setting up and connecting Lightyear to accountsIQ is a quick and easy process. From the left hand ribbon, head over to Settings > Accounting Software > Select accountsIQ > Connect. A popup will display asking for a User Key ...Xero Integration Setup Guide
Connecting to Xero Because Xero and Lightyear are both cloud-based, set-up and connectivity between the two systems is seamless. Here's how. From the Navigation Pane, head over to Settings > Accounting Software > select Xero from the dropdown menu > ...