COPYING PARENT NAME TO ALL SUB NAMES IN .IFF FORMAT / OR CSV FORMAT

I am creating a QuickBooks Chart of Accounts based on the .IIF format which I need to import from Excel into QuickBooks. Now I have accounts with sub accounts . I need to edit each sub-account to add the parent account. Is there an easier way of adding the parent accounts name / code on all the sub name / codes. Like in this example AGRONOMY WHEAT is the parent Name and I need to add this on all sub names / codes and should be like AGRONOMY WHEAT:Farm inputs Fertilizer

ACCNT

AGRONOMY  WHEAT:

EXP

   

303

ACCNT

AGRONOMY WHEAT:Farm Inputs  seed

EXP

   

303001

ACCNT

Farm inputs Fertilizer

EXP

   

303002

ACCNT

Farm inputs chemicals

EXP

   

303003

ACCNT

Farm Inputs Equipment / Clothing

EXP

   

303004

 

 

Jarvis Kamvabingu

Add comment
Log in or register to post comments
Group: Excel reporting with David Carter
Management reporting with David Carter