Tracking IB Changes in Assets

Hi All-

I suspect we're one of many companies facing this issue and I'm hoping somebody can point me to a white paper or suggest potential strategies for what I suspect is a common problem:

Each month, our asset accountants pull a list of IB items that have changed and then use a pivot table to identify the corresponding assets and then manually adjust those assets. From speaking with a couple colleagues at other companies, this type of manual process is normal. Does anyone have any experience with automated solutions that might either update corresponding assets when an IB item is updated or any other best practice for reconciling the two systems?