Font Size
   

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.