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



Solution:

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