[Question] Importing GL Accounts from Excel into Pastel 14

[Koot]

Good morning,
I am struggling to import GL accounts into Pastel Partner. I have created a new company with NO GL Accounts.
I have exported my previous GL Accounts from an old back-up and modified it.
I did looked at Neville's file layouts.
I am getting the following errors:
Line 2 Blank Code
Line 3 GAAP category
Line 4 Blank description
Line 5 Blank code
Line 6 Blank code
Line 7 GAAP category
Line 10 Blank description
Line 11 Blank code
It then continue in the same sequence until the end

Could somebody please advice on what I am doing wrong?

Koot

[Neville Bailey]

I suggest that you manually create one GL account and then export it as a CSV file.

You can then compare the layout of that file with your file.

[Koot]

Importing GL Accounts from Excel

I suggest that you manually create one GL account and then export it as a CSV file.

You can then compare the layout of that file with your file.

I tried that, but I cannot even import the exported file! GAAP catagory does not exist - that is without even opening the file - merely imprting the same file which was exported (after deleting the created account). I must be do something wrong!

[Andromeda]

I am not sure if this helps.
"GL Manager

The General Ledger Manager module allows you to make changes to your General Ledger that is not possible to do by editing accounts. You would use the General Ledger Manager to restructure your General Ledger to reflect changes in your business or to correct errors that have been made when creating accounts. For example if you selected the incorrect chart of accounts when creating your company and have then worked in the company, you can adjust the General Ledger using this module.

You will cover the following course objectives :

Renumber General Ledger Accounts.
Delete General Ledger Accounts.
Consolidate General Ledger Accounts.
Change Financial Categories.
Change GAAP Categories.
Print the Audit Trail."

You can find it here:

http://stage.pastel.co.za/Accounting-Software-Training/CourseOutlines/Pastel-Partner-Version-11-Super-User-Module-1-3.asp

[Koot]

Thank you for the assistance, guys.
I managed to get it right - Deleted the headings and matched the mapping.