In order to integrate SILQ & MYOB we have provided a list of steps to assist you with the export.
In order to integrate SILQ & MYOB we have provided a list of steps to assist you with the export.
How to export from SILQ
1. To begin the export from SILQ to MYOB click on the accounts Tab up the top
2. Click on Chart of Accounts.
3. Click on the Export to MYOB button at the top.
4. You’ll receive an email from SILQ with text files attached to import to MYOB. (please note, this email will be sent to the email address you use to login to SILQ)
5. Save the attachments to your computer to prepare for the import into MYOB.
How to import into MYOB
SILQ recommends that you back up your MYOB software data file before you attempt to import any data that SILQ software has produced. This will allow you to return to the version of the data file prior to import, in the unlikely event that you need to re import for whatever reason.
Once you have backed up MYOB it is then important to remember that the files you have exported from SILQ need to be imported in the order specified below:
To do this:
Importing Customer Cards
1. Make sure the MYOB software data file is open.
2. Click on File Menu > Import Data
3. Choose Cards | Customer Cards
4. Select the following options
5. Import File Format: Tab Delimited
6. First Record is: Header Record
7. Duplicate Records: Update Existing Record
8. Identify Records By: Co./Last Name or Card ID
9. Select “CUSTCARD.TXT” saved from the email earlier.
10. You will now be shown the list of fields. Click on “Match All”
11. Scan the list on the right hand side and make sure that all the fields match and that every field has a matching source field. If this is not the case then you may have posted the data into an incorrect format. If it is correct, then click “Import”
Note: If Record ID is matched click on it to remove the Record ID.
Importing Invoices
Before you import - You must have first imported Customer Cards.
To import invoices do the following
1. Make sure the MYOB software data file is open.
2. Click on File Menu > Import Data
3. Choose Sales | Time Billing Sales
4. Select the following options
5. Import File Format: Tab Delimited
6. First Record is: Header Record
7. Duplicate Records: Reject Them
8. Identify Records By: Co./Last Name or Card ID
9. Select “TBSALE.TXT” saved from the email earlier.
10. You will now be shown the list of fields.
11. Click on “Match All” Scan the list on the right hand side and make sure that all the fields match and that every field has a matching source field. If this is not the case then you may have posted the data into an incorrect format. If it is correct, then click “Import”
Note: If Record ID is matched click on it to remove the Record ID.
Importing Receipts
Before you import - you must first imported Customer Cards & Invoices.
To import receipts do the following
Note: here “Receipts” refers to Receipts for Invoices in SILQ only (and does not includes “Other Income” (eg. dividends and interest)
1. Make sure the MYOB software data file is open.
2. Click on File Menu > Import Data
3. Choose Receipts | Receive Payments
4. Select the following options
5. Import File Format: Tab Delimited
6. First Record is: Header Record
7. Duplicate Records: Reject Them
8. Identify Records By: Co./Last Name or Card ID
9. Select “RECEIVEPAY.TXT” saved from the email earlier.
10. You will now be shown the list of fields.
11. Click on “Match All” Scan the list on the right hand side and make sure that all the fields match and that every field has a matching source field. If this is not the case then you may have posted the data into an incorrect format. If it is correct, then click “Import”
Note: If Record ID is matched click on it to remove the Record ID.
Import Expenses
Before you import - You must have first imported Customer Cards.
To import expenses do the following
1. Make sure the MYOB software data file is open.
2. Click on File Menu > Import Data
3. Choose Disbursements | Spend Money
4. Select the following options
5. Import File Format: Tab Delimited
6. First Record is: Header Record
7. Duplicate Records: Reject Them
8. Identify Records By: Co./Last Name or Card ID
9. Select “SPENDMONEY.TXT” saved from the email earlier.
10. You will now be shown the list of fields.
11. Click on “Match All” Scan the list on the right hand side and make sure that all the fields match and that every field has a matching source field. If this is not the case then you may have posted the data into an incorrect format. If it is correct, then click “Import”
Note: If Record ID is matched click on it to remove the Record ID.
Import Income
Before you import - You must have first imported Customer Cards.
To import income do the following
Note: here “Income” refers to “Other Income” recorded in SILQ; namely, income other than Receipts such as dividends and interest income.
1. Make sure the MYOB software data file is open.
2. Click on File Menu > Import Data
3. Choose Receipts | Receive Money
4. Select the following options
5. Import File Format: Tab Delimited
6. First Record is: Header Record
7. Duplicate Records: Reject Them
8. Identify Records By: Co./Last Name or Card ID
9. Select “Receive Money.TXT” saved from the email earlier.
10. You will now be shown the list of fields.
11. Click on “Match All” Scan the list on the right hand side and make sure that all the fields match and that every field has a matching source field. If this is not the case then you may have posted the data into an incorrect format. If it is correct, then click “Import”
Note: If Record ID is matched click on it to remove the Record ID.
Importing General Journal
Be very careful not to double import General Journal items. MYOB does not insist that General Journal items are unique, and as such will allow you to import the item more than once.
Importing
1. Make sure the MYOB software data file is open.
2. Click on File Menu > Import Data
3. Choose General Journal Items
4. Select the following options
5. Import File Format: Tab Delimited
6. First Record is: Header Record
7. Duplicate Records: Reject Them
8. Identify Records By: Co./Last Name or Card ID
9. Select “GENERAL.TXT” saved from the email earlier.
10. You will now be shown the list of fields.
11. Click on “Match All” Scan the list on the right hand side and make sure that all the fields match and that every field has a matching source field. If this is not the case then you may have posted the data into an incorrect format. If it is correct, then click “Import”
Note: If Record ID is matched click on it to remove the Record ID.