Importing tax codes from MYOB Desktop

Importing Tax Codes from MYOB Desktop

Adding Tax Rates to Lightyear

Before a bill can be exported from Lightyear, we will need to know what Tax Rates you use in your MYOB Company File. This can be achieved by exporting your Tax Rates from MYOB and then uploading them into Lightyear.

Once your Tax Rates have been captured in Lightyear you will need to select a Default Tax Rate for taxable items, and a default Tax Rate for non-taxable items.

Importing Tax Rates into Lightyear

The process to export your data will depend upon which version of MYOB you are using :

Exporting Tax Rates from AccountRight Standard Edition

  • click on File, then Import/Export Assistant
  • select Export Data and click Next >
  • select Tax Code List, then Non-Consolidated Codes and click Next >
  • select Tabs, then tick the box labelled Include field headers in file and click Next >
  • use the Add > button to move the Tax Code, Description and Rate to the Fields to Export,
  • Click Export and save the export file to your PC or Mac – remember where you saved the file because you will need it in the next step

Exporting Tax Rates from AccountRight Plus Edition

  • click on File, then Export Data, then Tax Code List, then Non-Consolidated Code
  • select Tab-delimited, then Header Record and click Continue
  • in the table labelled AccountRight Plus fields, click on Tax Code, then Description, then Rate
  • click Export and save the export file to your PC or Mac – remember where you saved the file because you will need it in the next step
  • click on the Browse button and locate the file you created above
  • click on the Upload button
  • click on "Yes" when asked if your file contains a header row


In Lightyear

click on the Browse button and locate the file you created above
click on the Upload button




Ensure your file has been set up in the correct format as per the tip provided above. 

Follow the prompts as it will ask you: 
  • Does the uploaded file contain a Header row? Yes / No to a header row
  • Select the File Format and then Confirm

Once the upload is complete you will see a summary table displayed. Your tax rates have now been successfully uploaded into Lightyear.




      

    Check out our
    to stay up to date

      • Related Articles

      • Exporting from Lightyear to MYOB

        Once some bills have been approved, go to the Signed Off tab in Lightyear and select the invoices you wish to export and click the Export to MYOB button. At the end of the export process, you will get a confirmation on screen that the export has been ...
      • MYOB integration set up guide (Essentials & AccountRight)

        Connecting to MYOB (Essentials & AccountRight) There are different versions of MYOB that Lightyear can connect to. Please follow the below steps to connect to both MYOB Essentials and MYOB AccountRight. Some notes will be version specific, so please ...
      • Exporting to QuickBooks Desktop

        If QuickBooks Desktop is you accounting software of choice, you can still use Lightyear to help automate your business processes! As standard out of the box, QuickBooks Desktop does not support uploading invoices/transactions in bulk, however there ...
      • How does my data appear in MYOB?

        Where to find your bills in MYOB  Once you've exported your bills from Lightyear into MYOB, head over to your Purchases > Purchases Register to bring up the list of bill records.  Here, you'll be able to search or click onto the bill/s you're looking ...
      • Import GL Codes from MYOB Desktop

        In MYOB 1 - File > Export Data 2 - Choose Accounts from the drop-down list, then Account Information. 3 - Choose the most up to date period from the options presented, then click Next 4 - Choose to separate the data using Tabs, and also tick the ...