ANSWER ID:13159MYOB RetailManager and your MYOB Accounting software can be setup to allow for the complete retail point of sale and business management solution. This support note shows you how to setup MYOB Accounting software (AccountRight v19 and earlier and AccountEdge) to import from RetailManager. Before you begin Make sure you have both your MYOB Accounting Product and RetailManager installed on your computer or within your local network environment. You may want to use this support note in conjunction with the Accounting Integration Guide. Task 1 Setup your Accounting software to allow importing from Retail Manager In your MYOB Accounting software, go to the Setup menu and choose Preferences.
- Click the System tab.
- Select the option I Use RetailManager. This will enable your MYOB Accounting software to automatically detect and import the Retail.txt file (the file exported from RetailManager) located in your MYOB company file folder or directory.
[Australia only]Image Removed
[New Zealand only]Image Removed
Task 2 - Ensure all the accounts specified in the accounting export setup within RetailManager exist in your accounting software If you have specified an account within RetailManager that does not exist in your MYOB Accounting software you are not going to be able to import data to that nominated account. Note that in RetailManager all accounts in the chart of accounts setup menu do not have hyphens whereas they do in your MYOB Accounting software. For example in RetailManager, the account number 11100 corresponds to the account number 1-1100 in your accounting software. It is recommended that you setup your chart of accounts first within your MYOB accounting software before placing these in the chart of accounts setup in RetailManager to ensure consistency. In Retail Manager - Go to the Setup menu and choose Options.
- Click Accounting (from the panel on the left).
- Click the Chart of Accounts tab. Make sure all account numbers entered here exist in your MYOB accounting software. Two examples have been highlighted to show their equivalent in the accounting software.
Image Removed
- To access these accounts in your accounting software, go to the Accounts command centre and click Accounts List.
[Australia only]Image Removed
[New Zealand only]Image Removed
In the above example, notice that the accounts in your accounting software have a hyphen after the first digit, but in RetailManager they do not. Task 3 - Ensure that the account numbers specified in RetailManager for export correspond to Detail accounts and not Header accounts within your accounting software Header accounts are not postable, in other words they cannot have transactions allocated to them. They are merely there to indicate a particular group of accounts or to enable subtotalling for the other accounts which fall under that heading. To check whether your account is a header account, go to the Accounts command centre and click Accounts List. Ensure the accounts are not in bold or click the account's zoom arrow and ensure they are set up as Detail accounts as shown below. [Australia only]Image Removed
[New Zealand only]Image Removed [Australia only]Task 4 - Ensure all relevant tax codes are setup within your accounting software with the relevant linked accounts for tax collected/paid. In your accounting software, go to the Lists menu and choose Tax Codes. Ensure that the tax codes specified in RetailManager (go to the Admin menu and choose Set Tax Codes) exist in your MYOB accounting software. Moreover, ensure that tax codes in RetailManager that have Goods & Services Tax in the tax type column on the Tax Code List screen have an A/C for tax on sales equivalent to the Linked Account for tax collected on the tax code information in your MYOB accounting software. Note: If you have other tax codes such as S0, S12 and S22, you need to create a new liability account named Sales Tax Collected in your MYOB accounting software and link these tax codes to that account. You do not need to link input taxed tax types to a linked account. Image Removed Example: If you opened up a tax code in RetailManager the account for tax on sales should be the same as the linked account for tax collected within your MYOB accounting software for that tax code. In RetailManager, go to the Admin menu and choose Set Tax Codes then double-click the applicable tax code (in this example GST). Image Removed As shown in the example screenshot below, the A/C for tax on sales in RetailManager should equal the Account for Tax Collected in your MYOB accounting software. In your accounting software, go to the Lists menu and choose Tax Codes then double-click the applicable tax code (in this example GST). Image Removed [New Zealand only]Task 4 - Ensure all relevant GST codes are setup within your accounting software with the relevant linked accounts for GST collected/paid. In your accounting software, go to the Lists menu and choose GST Codes. Ensure that the GST codes specified in RetailManager (go to the Admin menu and choose Set Tax Codes) exist in your accounting software. Moreover, ensure that tax codes in RetailManager that have Goods & Services Tax in the tax type column on the Tax Code List screen have an A/C for tax on sales equivalent to the Linked Account for GST collected on the GST code information in your MYOB accounting software. Note: If you have other tax codes such as S0, S12 and S22, you need to create a new liability account named Sales Tax Collected in your MYOB accounting software and link these tax codes to that account. You do not need to link input taxed tax types to a linked account. Image Removed Example: If you opened up a tax code in RetailManager the account for tax on sales should be the same as the linked account for tax collected within your MYOB accounting software for that tax code. In RetailManager, go to the Admin menu and choose Set Tax Codes then double-click the applicable tax code (in this example GST). Image Removed As shown in the example screenshot below, the A/C for tax on sales in RetailManager should equal the Linked Account for GST Collected in your MYOB accounting software. In your accounting software, go to the Lists menu and choose GST Codes then double-click the applicable tax code (in this example S15). Image Removed Task 5 Once all of the above are setup, you are now ready to import into your MYOB Accounting software Your accounting software does not need to have any customers entered in as cards as only the journals are put through. On the other hand, suppliers are created when importing as your accounting software is still used to pay for your bills. For information about performing the export from RetailManager into your accounting software, see the Accounting Integration Guide. We've put together the Accounting Integration Guide to step you through integrating MYOB RetailManager and MYOB accounting software. The Guide includes: - required setup
- the integration process
- troubleshooting integration issues.
|