Setting up Caliq in Lightyear

Setting up Caliq in Lightyear

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

To get started, head to the Accounting Software section of Lightyear and select Caliq from the dropdown.



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

Accountancy Software Settings

  • Automatically apply Categories on line item level? By default, Lightyear will automatically apply Categories at a line item level based on various rules. You can choose for this feature to be disabled by selecting No.
  • Automatically apply GL Codes on line item level? By default, Lightyear will automatically apply GLs at a line item level based on various rules. You can choose for this feature to be disabled by selecting No.
  • Group Line Item Data? Turning this on will allow you to export Grouped GL data, rather than line item data. For the full article on this, click here.

Supplier Accounts

These are your Suppliers within Caliq, and are used so Lightyear knows which supplier to associate any given bill with. To set up a Supplier Card, you'll be asked for a Supplier Name and an Card ID.

You can edit any of the Supplier Cards by clicking on the Green pencil

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



Nominal Codes

These are your Nominal Codes, or Nominal Account References, within Caliq. Lightyear requires the 3 digit Nominal 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 Caliq, 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 Caliq.



      

    Check out release notes for Q2 2021



      • Related Articles

      • 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 ...
      • Setting up Sage 50 in Lightyear

        Sage 50 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 ...
      • 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 ...
      • Setting your Adept Company Code in Lightyear

        Adept Accountancy Software Settings To connect Lightyear requires a 2 letter Company Code so your bill data can be exported to Adept. From the Navigation Pane, head over to Settings > Accounting Software > select Adept > Accountancy Settings. In the ...
      • Exporting from Lightyear to Xero

        From the Signed Off tab in Lightyear,  choose which invoices to export by selecting or deselecting under the tickbox column or individuals, then click the Export to Xero button.   At the end of the export process, you will get a confirmation on ...