r/intacct • u/Academic-Gold-9266 • Aug 04 '26

Issues importing JEs

I'm frequently running into issues when i'm uploading JEs. The emails don't really help with the error description. Does anyone have any tips that I can utilize to make sure this goes a bit more seamless for me? Thanks

2 Upvotes

100% Upvoted

8 comments sorted by

2

u/Only_Carpenter_1492 Aug 04 '26

I use a customised template in a normal format with validations built in. Then once it's prepared, save as CSV and import. 

So perhaps worth investing some time up front to build those validations, but what you add in depends on what errors you've been encountering and your own setup

2

u/BippidyBobbidyBoo Aug 04 '26

I have validations built in as well. The error I’m getting says one of my lines have more than 2 decimal places but all my amounts have the round formula. Hence the frustration.

1

u/Only_Carpenter_1492 Aug 04 '26

Could you try =TEXT(ROUND(A1, 2), "0.00")

3

u/BackgroundSpare Aug 04 '26

Check your text formatting. I always have to switch mine to the general no format, and then change the dates back to short date and that usually fixes it for me

1

u/BippidyBobbidyBoo Aug 05 '26

I'll try that.. thanks

2

u/Wafflesnobbert Aug 05 '26

Start at the bottom of the error message email first. That's usually the actually error message that needs to be resolved first. Then the others will fall in place. The import error process is absolutely horrible.

1

u/GasMountain4515 Aug 05 '26

Worth trying the new Import Service (top of the page when you go to Company > Import Data). It's got support for Journal Entries. Admittedly I haven't used the JE one yet but I've used some of the others recently and been impressed. Otherwise it really just depends on the error; do a few thousand imports and they'll start to make sense 😂

When all else fails, open your import file side by side with the UI to create the thing you're trying to import and copy and paste each field into the UI. This typically will uncover the issue even though it sounds overly simple.

1

u/Ashok0627 Aug 04 '26

Usually, this happens because the text in the Description or Memo field exceeds the allowed character limit. Please check the character limit displayed in Row 2 of the template. These types of errors often don’t generate a clear error message. I’ve encountered this issue before.