glqsimpt There was an error reading in from the excel file Too many columns found in Master Account worksheet

Description of Issue

When attempting to import the COA into Munis an error is being received

There was an error reading in from the excel file. Too many columns found in 'Master Account' worksheet.  Please fix the error and reimport.

Context
  • Munis
  • glqsimpt
  • COA Builder
  • System Update
  • General Ledger
Cause

Long Account Import was not checked when attempting to import a COA import file that was formatted for Full/Long Account.

Resolution

Within the Chart of Accounts Import Program

  1. Click Ok on the error received
  2. Click Select File
  3. Click on Long Account Import and verify it is checked
  4. Click the Magnifying Glass to import the file
  5. Click Accept
Additional Information