Have a Question?

If you have any question you can ask below or enter what you are looking for!

Import data into Million Accounting Software

Account Settings Description

For Branch code is to different multiple branch transaction. (Only 1 branch, you can ignore to set and use default value).
Cash Sales/Credit Note account settings description

* GL - General Ledger

NameDescriptionRemark
Sales/Credit SalesThis is a GL code, you obtain the account details from the list option in the Million accounting software GL Accounts. 
Customer CodeThis is the Debtor's, You can get from Million accounting software Debtor Master file. 
Payment TypeDisplays the type of payment type used by the customer (Cash, Credit Card, Coupon, etc.). Payment entries can also be found in the GL Accounts list. 
RoundingSets the rounding adjustment for the indicated values (up to the selected values).Not Necessary
Service ChargeSets the service charge, based upon the account code.Not Necessary
ShortDisplays the outstanding payment remaining in the account. 
OverDisplays the amount overpaid in the account. 
GST SettingsDisplays the GST Tax Codes (Both Input / Output). Can also be found in the Tax Code list option. 

Account Payable account Settings description.

* Set in Vendor Masterfile

NameDescriptionRemark
Account Payable (Purchase)This is a GL code, you obtain the account details from the list option in the Million accounting software GL Accounts. 
Vendor CodeThis is the Creditors, You can get from Million accounting software Creditors Master file. 

1. Refer to the ARMS system user guide list below for instructions on how to export data.

million.png

2. Click on General menu and Batch.

million_batch1.png

3. Click on Add button.

4. Select month and year you would like to generate.

5. Click on Generate button.

million_menu.png

6. Click on System menu and Administrative Tools.

million2.png

7. Select Import/Export Data and click on OK.

million3.png

8. Select Import Transaction to Accounting and click on OK.

million4.png

9. Click on Preview button.

million_csv.png

10. Select Files of type with *.csv.

million5.png

11. Select csv file which export from ARMS GO/Premium Export Account module.

million6.png

12. Click on Import button.

million7.png

13. Key in data date range which export from ARMS GO/Premium Export Account module.

14. Select Import to Batch Group and click on OK.

million8.png

15. Click on Yes.

million9.png

16. Once system successful insert data, it will prompt message and click on OK.

million10.png

* You can GL Transaction which under General menu to view sales/purchase, you has import with select the Batch No and click on Refresh.