Import Journals error- no amount exists for import when all lines show amounts

• Pre-Edit in Import Journals for import using custom template with Gross column populated with non-zero amounts for all lines generates an error for all lines.

• Error: Gross: 0.00: N amount exists for import

• Import spreadsheet has 2 or more tabs with data

Import Journals

Import spreadsheet has 2 or more tabs with data.

• The import spreadsheet needs to have only 1 tab at the bottom.  

• Either delete extra tab(s) if appropriate or copy and paste data to a new spreadsheet with only 1 tab and start the process again with the new or revised file.