Troubleshooting: Import journal entry error - Column ‘TaxableAmt’ does not belong to table

Question: When import Journal Entry from excel, error message prompted ‘Column ‘TaxableAmt’ does not belong to table’. What should I do?

Version: 1.8 / 1.9 / 2.0

Import jv1.png

Possible Reason:

There is an empty row in between the transaction. Empty row in between the transaction will cause the import error.

Import jv2.png


Remove the empty space or row in between the transaction.

Import jv3.png

Import the excel template again and you will not be getting error now.

by Azirah 180112, KM 180122, P180130

Go to menu

  AutoCount Accounting 2.0

  AutoCount Accounting 1.8 / 1.9
  AutoCount Payroll
  AutoCount POS

  AutoCount On The Go
  AutoCount Accounting Plug-In Documentations