To fix - remove the beginning date and accum from the spreadsheet.

Both 179 and 168 (taken in that order) are reductions of the Depreciable Basis of an asset. If the Depreciable Basis is zero, then there can be no accumulate depreciation.

Kody,

I tried to simulate what you were doing but did not get the error you did.

My import map included the key info that you provided in your post:

• Acquisition Value (Tax) = $826.70
• Depr Method (Tax) = MA
• Declining Balance % (Tax) = 200
• 168 Allowance % (Tax) = 30%
• Beg Date (Tax) = 12/2019
• Beg Accum (Tax) = $578.69

And when I validated the data, I got no errors.  I completed the import and created the asset with the following tax book:

You may need to call tech support and review the information in your spreadsheet cells from which you are trying to perform your import.

I have a similar question. I am working on my initial import and I am getting the "Beginning Accumulation must not exceed depreciable basis" error in my tax and AMT book. My asset is fully depreciated. The acquired value is 826.70, the bonus amount is 30% or 248.01, my beginning accumulated depreciation is 578.69. They both add up to the depreciable basis, not exceeding it. I have 12/31/19 as my begin date. The asset was added in 2003 and has a method of MA for tax and AMT. I am getting the error on several other assets that do not have 100% bonus. Why is it not working?

Hello bdok.

I just did a quick test Import, an asset PIS in 2001, value of $7,000, MA200, 30% and 5 year life with the beginning date in 2006 and the beginning accum set to $4,900 and it imported without an issue.

~Delray

Having the same exact issue.  Was this ever resolved?

O' the old, 179/Bonus field. That Bonus is actually a 179 rule for GAAP methods. Truth be told, I do not even know if that rule still exists for the Internal books, but it did back when 30% 168 was a thing.

~Delray

Thanks for sharing...as an example, I have an asset that was 7,000 with 30% bonus (2,100).  I show beg Accum Depr of 4,900, but the system thinks that is too much.  What am I missing?

Thanks guys...knew it had to work.  I mistakenly put bonus and 179 in the same column...import field says "Sec 179/Bonus Amt (Tax)", but it does not really want the Bonus amount.

Our old system counted the bonus as part of the Accum. Depr. In Sage you need to remove the Bonus from the Accum Depr. If an asset has 100% bonus the Accum Depr. should be blank and if the Accum Depr is blank the Begin Date should be blank.

Hope this helps.

It should work, unless your rounding is causing it to be off. Sage calculates based off the 30% bonus and the Accum Depr amount. Maybe try plugging it in manually to see how it calculates the bonus amount. If that doesn't work you might have to call Sage for help.