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 ...MYOB Acumatica Integration Set Up Guide
Connecting to MYOB Acumatica As of July 2024, MYOB Advanced is rebranded to MYOB Acumatica. Any reference to MYOB Acumatica or MYOB Advanced in this guide can be used interchangeably. There are different versions of MYOB that Lightyear can connect ...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 ...