ExceltoCI with Accum Depr
I am trying to convert a small number of assets using the ExceltoCI process. I can find no real helpful documentation on it, but through trial and error, I was able to load the assets and get the accumulated depreciation in the right period and the assets depreciate correctly for their remaining useful lives. But, for some reason, when I create the accounting entries, I am getting an extra line for the accumulated depreciation amount, resulting in an unbalanced journal.
In the DIST_LN table, the create accounting entries process is creating lines for Accumulated Depr, Depr Expense, and Contra Asset. All these lines use the ADD journal template. See the attached spreadsheet.