AutoCount Import UBS Accounting Data Plug-in

Home » AutoCount Created Plug-ins » AutoCount Import UBS Accounting Data Plug-in
AutoCount Created Plug-ins No Comments

Introduction

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.

Download Link

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.

Installation

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.

Licensing

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.

Click the Create Account Book button to start the Account Book creation

Click the Create Account Book button to start the Account Book creation

Step 2: Enter the Basic Information as well as the Database Server Location infotmation.

Enter the Basic Information

Enter the Basic Information

Step 3: You can either modify or use the default setting for the Start Date, System Currency Setting and Goods & Services Tax information.

iu_create_03

Step 4: You can either modify or use the default setting for the Main Package.

iu_create_04

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.

User must choose the Blank Account Book option

User must choose the Blank Account Book option

After creating the empty account book, simply install the plug-in into the account book, before beginning to use the plug-in.

Usage

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.

The Import UBS Accounting Data before import is started

The Import UBS Accounting Data before import is started

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.

The Year To Date Balance Maintenance window showing all the previous balances are added together and placed on the last month before the Actual Data Start Date

The Year To Date Balance Maintenance window showing all the previous balances are added together and placed on the last month before the Actual Data Start Date

The Outstanding A/R Invoice document imported in

The Outstanding A/R Invoice document imported in

The Outstanding A/P Invoice document imported in

The Outstanding A/P Invoice document imported in

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.

What’s new?

Version 1.0.1

  1. Change the UI to Wizard form.
  2. Add the ability for users to check the Fixed Asset Accounts before import in.