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

From AutoCount Resource Center

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

IconAcc20.PNG AutoCount Accounting 2.0 & 2.1

IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS

Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations