Results 1 to 5 of 5

Thread: Importing GL Accounts from Excel into Pastel 14

  1. #1
    New Member
    Join Date
    Jul 2015
    Location
    Walvis Bay, Namibia
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Importing GL Accounts from Excel into Pastel 14

    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

  2. #2
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    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.
    Neville Bailey - Sage Pastel Accounting Consultant
    www.accountingsoftwaresupport.co.za
    neville@accountingsoftwaresupport.co.za
    IronTree Online Solutions

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

  3. #3
    New Member
    Join Date
    Jul 2015
    Location
    Walvis Bay, Namibia
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Importing GL Accounts from Excel

    Quote Originally Posted by Neville Bailey View Post
    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!

  4. #4
    Gold Member
    Join Date
    Feb 2016
    Location
    Johannesburg
    Posts
    713
    Thanks
    74
    Thanked 199 Times in 178 Posts
    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...Module-1-3.asp

  5. #5
    New Member
    Join Date
    Jul 2015
    Location
    Walvis Bay, Namibia
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thank you for the assistance, guys.
    I managed to get it right - Deleted the headings and matched the mapping.

Similar Threads

  1. Import excel into Pastel
    By nikkidv in forum Accounting Forum
    Replies: 5
    Last Post: 20-Jul-17, 01:34 PM
  2. [Question] Importing Cash Book CSV files into Pastel Excel 2013
    By Rodthebod in forum Accounting Forum
    Replies: 3
    Last Post: 21-May-16, 06:24 PM
  3. [Question] Importing Excel files to Pastel for invoicing purposes
    By JacoDif in forum Accounting Forum
    Replies: 0
    Last Post: 27-Jan-16, 10:38 AM
  4. Exporting from Pastel V12 to excel
    By Tat in forum Accounting Forum
    Replies: 2
    Last Post: 18-Feb-14, 08:26 AM

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •