In an effort to improve the current AutoCount Import UBS Accounting function as well as provide a way to test the improved versions of the function, Auto Count Sdn Bhd has created a plug-in named AutoCount Import UBS Accounting Data.
Please click on the following link to obtain the plug-in:
Main Link: AutoCount Import UBS Accounting Data
Mirror Link: AutoCount Import UBS Accounting Data
Latest file: 23/07/2015. To check if the version you have is the newest, click on the View Info in the Plugin Manager and check the What’s New box and compare the latest date in it to the date shown here. This can also be done when installing the plugin.
The installation of the plug-in is simple. Simply navigate to the AutoCount Accounting Plug-In Manager (located in the Tools menu) and use the Install button before selecting the AutoCount Import UBS Accounting Data .app file to install. This plug-in is compatible for AutoCount Accounting version 1.8.15 and above.
This plug-in is set to Free License as it is used for testing as well as collecting feedback on the new improvements to the current AutoCount Import UBS Accounting function.
How to use
Setup the Account Book
Before using this plug-in, please ensure that the account book you wish to import data in must not contain any data in it. To create an empty account book, please follow the following steps:
Step 1: From a current account book, use the Manage Account Book function under the File menu. Click on the Create Account Book.
Step 2: Enter the Basic Information as well as the Database Server Location infotmation.
Step 3: You can either modify or use the default setting for the Start Date, System Currency Setting and Goods & Services Tax information.
Step 4: You can either modify or use the default setting for the Main Package.
Step 5: You can either modify or use the default setting for the Account Code. However for the Sample Chart of Accounts, you must select the option Blank Account Book. Click Finish to complete the process.
After creating the empty account book, simply install the plug-in into the account book, before beginning to use the plug-in.
Similarly to the current AutoCount Import UBS Accounting function in the AutoCount Management Studio, the AutoCount Import UBS Accounting Data plug-in has the same usage flow with one exception. After selecting the source folder for the data, the type of data being imported in, the account code separator option, the control account as well as the data encoding options, the user has to select the Import Opening Balance Options.
The Import Opening Balance Options is critical if the user wishes to import in the Opening Balance from the UBS data. The first information that is needed to be filled is the Fiscal Year Start Date in UBS. This is the start date of the current fiscal year used in UBS. This information is important as the fiscal year date in AutoCount will be modified to follow this information. If you do not change this information from the default value shown, it will use the fiscal year date that you have set during the account book setup.
The second information that is needed to be filled is the YTD Period information. For this field, the user can select the value of 0 till 18. The value 0 means that only the Opening Balance information will be imported in. If the user wishes to import the period balance as well as the Outstanding ARAP Invoice up till the period of their choice, they will have to select the value between 1 and 18.
For example, if the user wishes to import all the balances up till the month of June 2015, the user will have to make sure that the Fiscal Year Start Date in UBS field is set to 01/2015 and select the value 6 for the YTD Period field. This will cause the import function to modify the Actual Data Start Date for AutoCount to the month of July 2015 and all outstanding ARAP invoices up till the 30th of June 2015 be imported in, as shown below.
Note: After doing the import via this plug-in, you may need to re-login into the account book again to access the Year-To-Date Balance Maintenance function as it may not show up immediately after import. The function menu will be available after re-login.
- Change the UI to Wizard form.
- Add the ability for users to check the Fixed Asset Accounts before import in.