Importing the Chart of Accounts into MoneyWorks
Software: MoneyWorks v7 accounting software
After verified the tax code (GST code) and tax rate (GST rate) are correct, you need to create the accounts in the Chart of Accounts list. If you have a few hundreds or thousands of accounts, the easier way is to import the account list into the MoneyWorks.
Below are a list of required fields, which will help you in preparing the import list file.
Account: Account Code (max 7 characters) Description: Account Name (max 39 characters) Type: Account Type* Group: Department Group Tax Code: GST code Category: Account Category P&L: Retained Earnings.
You can leave the Group and Category field blank if you are not using it. All Profit & Loss accounts are required to have a P&L account code (retained earnings account). All accounts must have a tax code, if you are not a GST register trader, you may use “*” GST code (Please refer to the Tax Code list for a list of Tax Code available in MoneyWorks).
Once the list is prepared, save it as a text file.
From the “File” menu, “Import”, select “Accounts…” to start importing the file. Unlike other list such as a name list or transaction list, it does not have a mapping window when importing the accounts list, hence you need to prepare the list in the below order.
The MoneyWorks import wizard will check for errors, if no error found, follow the instruction and import the accounts.
You can only import base currency account.
If you are using departments, the department code will be after the account code joint by a “-“. Example: Account code 7230, RENT account. If you have two departments, D01 and D02, the account code will be:
*Account Type available in MoneyWorks:
AR: Accounts Receivable AP: Accounts Payable BK: Bank CA: Current Assets CL: Current Liabilities CS: Cost of Sales (Cost of Goods Sold) EX: Expenses FA: Fixed Assets GR: GST Received (Special type of account) GP: GST Paid (Special type of account) IN: Income PL: Profit & Loss (Special type of Account, usually use as a Retained Earnings account) SA: Sales SF: Shareholders Funds (Equity) TA: Term Assets (Other Assets) TL: Term Liabilities (Long Terms Liabilities)
Please refer to the MoneyWorks v7 user guide, page G-363, “Importing the Chart of Account” for more detail.