TB Import Issue: So I've been importing each month's TB in a new instance of NS, and have the JE import set to reverse the first day of the new month, so that it's a clean slate for the next month's import. That worked until I got to Dec 2015. The reversal entry apparently worked, but balances are showing on the TB for Jan 2016 to the end of 2016. Jan 2016 and forward should be blank on the Trial Balance report, but it's not. Also, I've checked against the Account Registers, and the reversal hit the GL like expected. Why would the TB report suddenly be showing balances like this?

The problem is that NetSuite auto closes for the year.

So for the December import, I should just upload the delta between November and December?

That should work - and then you wouldn't have it reverse.

Awesome! Thanks, Kevin.

Although, I almost always use Net Change for Every month, and I do the gymnastics for year end close in my file before I upload it

Great, thanks!

Hmm... could be even easier - Jan-Nov Reversing TB

I'll give it a try and see what it does to Retained Earnings. If it goes to Crazy Town then I'll just import the deltas.

Yeah, the "non reversing" will goof up your Balance sheet accoutns when you load full january TB

Hey @KevinJ of Kansas, on loading the import for the delta TB amounts, I get the error "The amounts in a journal entry must balance." Any thoughts?

Common mistake is that you have a value in the debit and credit amount columns

So I have all the amounts in the Debit column, with the credits as negatives. I'm loading the amounts that are the net change between current month and prior month, and they don't foot to zero. Is that my whole problem? Check that my deltas are correct because they should foot to zero?

Yeah, your deltas need to come to zero

I got it to work now. Thanks, Kevin!

This makes January a particularly fun month, as your income accounts are the ytd cake from trial balance where as your balance sheets are net change, and unless they book a value to retained earnings manually it shouldn't have a net change loaded

Hey @KevinJ of Kansas, do you know when the best time would be to import the currency exchange rates (Multiple Currencies is enabled) in the TB import process? I suppose I have to walk through the month end close checklist for each month to calculate the Consolidated rates as well, correct?

I don't, fortunately for me as I've never had to, but not for you, since I don't know.

No problem, thanks, though. Good tip! I guess another approach would be to import the consolidated exchange rates so that it will match the old NS instance.