PCOV and MYOB
Importing PCOV Account List into MYOB.
OVERVIEW
Step 1: Create a new company file
Step 2: Delete/Amend a small group of MYOB default accounts
Step 3: Import PCOV list of accounts (to download file click here)
Download the .txt file for importing into MYOB by right clicking on this link and select "save link as" from the Context Menu
SPECIFICS
Create a new Company File
Continue through the following screens, entering data as required:
a) Enter Information about your Company
b) Tell us about your accounting Year
c) Please confirm your accounting information
d) Build your accounts list
Choose the 2nd option: "I would like to import a list of accounts provided by my accountant after I've done creating my company file."
Create your company file.
In the Congratulations screen click on COMMAND CENTRE
Click ACCOUNTS
Click ACCOUNTS LIST
Delete duplicate/unnecessary accounts
First select the account you wish to delete, then click on the Edit button, then choose 'Delete Account' from the Edit menu.
Delete: 1-0150
1-0160
2-0300
6-0100
6-0200
Amend existing accounts
First select the account you need to amend, then click on the Edit button, then amend either the account number/account name or both.
Amend (default/existing): To become:
1-0100 Cheque Account 1-1100 General Cheque Account
1-0180 Undeposited Funds 1-1180 Undeposited Funds
1-0190 Electronic Clearing Account 1-1190 Electronic Clearing Account
1-0200 Trade Debtors 1-2500 Trade Debtors
2-0200 Trade Creditors 2-3200 Trade Creditors
3-0800 Retained Earnings 3-8000 Net Assets
3-0900 Current Year Earnings 3-9000 Current Surplus or (Deficit)
3-0999 Historical Balancing 3-9999 Historical Balancing Account
Import PCOV account list
From the File menu choose: Import Data/Accounts/Account Information
Accept all defaults in the first screen:
(i.e.)
Import File Format: Tab Delimited
First Record is: Header Account
Duplicate Records: Reject Them
Click Continue
Open the PCOV account list file: MYOBAccountsImport.txt
Match up the fields to import:
Account Number, Account Name, Header, Account Type & Subtotal Header Accounts (last entry in right hand pane)
(Click on the field on the left hand pane and then click on its match on the right hand pane.)
Click Import
This will import the PCOV list of accounts.