SAP to Sage Fixed Assets Automation

SAP Fixed Assets Tax Depreciation – Theres A Cure

Being in the fixed asset space for more than 16 years, I’ve seen a lot of challenges with fixed assets and how to get integration to just ‘work’ and not break every time there is a new version change to either systems.

In addition, large ERP solutions lack on federal Tax, AMT and State depreciation needs; especially when legislation changes are made.

The Sage Fixed Asset Depreciation (formerly Sage FAS) does a fantastic job at tackling those federal tax calculations as well as other major challenges ERP fixed asset modules lack:

  • Multi-search capabilities – more than just an SAP Main #, but wild card characters, easy queries for every field in Sage FAS
  • Bulk Disposals/Retirements – especially for industries that deal with store closures, refreshes, moves, etc.
  • Cost ADJUSTMENT true-ups – sure you can change the cost, but the system doesn’t true up that calculation leaving your asset either under or over depreciated at the end of its useful life
  • Tax forms and worksheets
  • Mid-quarter testing and calculation switches
  • the list goes on…

Trouble is and has always been – if an organization still insists on using SAP fixed assets for internal GAAP depreciation, getting the data out of SAP and into FAS can be a total nightmare.  Disposals and processing adjustments or 3115 changes can be a manual process and take a lot of time – not to mention room for human error.

Digging in deep and rolling up our sleeves here at FAC, LLC we’ve come up with a handful of utilities to assist with this process.  The best benefits?  Automated. Error proof. Doesn’t break when there are version releases to SAP or Sage Fixed Assets.

Finally a solution for large companies with a lot of fixed assets and a lot of activities.

Inquire at: angie@fixedassetconsulting.com

Sage Fixed Assets v2018

Here is the rundown on the new version release of Sage Fixed Assets, v2018. Scheduled to be available for download to current Sage Business Care customers and new purchases next week (week of Oct. 16th).

There are 4 major product enhancements to the fixed asset modules.  Most of them pertain to the Depreciation module.  One major update affects the Sage Fixed Asset Inventory solution that we have all been waiting for. Yes, it’s pretty darn exciting!

1. Updates to the 168 Allowance for the AMT book.  You don’t have to wait until the new tax release comes out to update your AMT book to take Bonus (where applicable). This means the bulk change through the Section 168 Switch allows you to bulk change the methods on assets in the AMT book.  In addition, the AMT book now follows compliance rules and updates are now defaulting to your new asset entry in the AMT depreciation book after you enter your asset in the Tax book.  This is extremely helpful to those using Sage FAS for their fixed asset Tax, State, and AMT sub-ledger.  Most importantly, if you have a large number of assets.

2. Import Multiple Assets.  Let me point out that this is for the Images tab – you could always import multiple assets into your Sage Fixed Asset solution.  With version 2018 you can now add multi images at once, and link to multiple assets at one time.  Now more simplified.  Much better workflow when ‘attaching’ images and PDF documents into the depreciation system.  In all versions leading up to v2018, you had to attach one at a time and the management was a bit extraneous.  A perfect solution for invoice attachments that have multiple assets on it.

3. Display ‘Depreciation This Run’ information in the Asset List and Asset Detail screens.  This means you don’t have to run the Depreciation Expense report to obtain this information.  Keep in mind, however, this is only for your current reporting period.  Great for time and efficiency when analyzing your data – without having to process a report.

Have you installed v2017.1?  This new enhancement will make much more sense if you have.  In v2017.1 you were given the ability to ‘manage’ your Asset List View by adding book information!  One book at a time, but you have to start somewhere!  This is an INCREDIBLE product enhancement in the Depreciation module.  I myself, use it all the time when processing client data.

4. Sage Fixed Asset Inventory – the use of Mobile Apps technology for bar code scanning!  Can Sage get a hip-hip-hooray!?  This means that you, as a customer, no longer have to purchase expensive and heavy bar code scanning equipment to conduct your physical inventories.  Works with Android tablet or phone ONLY (for now).  No release date for iPhone support, yet. This is critical for those with multi-locations or international locations because transferring of data and equipment to conduct inventories is no longer needed or a challenge!  One other amazing revelation – you no longer have to connect to the laptop to ‘sych’ data when using your Mobile technology!

NOTE: It is recommended that in more rugged environments, you should still utilize the more industrial scanning equipment.  For example, phones break when dropped on a warehouse floor or from 20 feet up.

I give kudos to Sage Software’s Fixed Assets new upcoming release of v2018.  I look forward to the enhancements to come, and their continued efforts to keep one of the best fixed asset management solutions out there alive and current.

More information on the Sage Fixed Asset solutions and services provided, visit us at Fixed Asset Software.


Rolling Out Large Fixed Asset Management Projects

It’s that time of the year again when companies (large and small) are just starting to think about their year-end processes (or just finished with them and their Auditors) when fixed assets come into play.  Property tax season is now coming upon us all and shortly thereafter… tax filing.

When getting ready to prepare for this type of fixed asset management project, people tend to have a mini (or large) freak out.  I want to remind you all that you don’t have to bite off more than you (and your budget) can chew.  Have you ever thought about breaking your project out into prioritized phases?  Below is an example of the kind of a approach you can take to complete your full fixed asset management project.

Real World Example

Background: Company XYZ is a large fortune 500, multi-location, publicly traded company.  They have well over 50,000 assets within the U.S.
Current Issues they are facing:

  1. No automated system to calculate their TAX, State and AMT depreciation calculations = hand calculated (spreadsheet formulas) and delayed filing and delayed provisions. (P.S. they are using an ERP solution)
  2. Inaccurate fixed asset listings – due to never performing a physical asset inventory or reconciliation = leads to inaccurate:
    1. Property Taxes and delayed filing
    2. Improper insurance coverage
    3. Financial reporting
    4. SOX 404 Compliance risk
  3. Multiple locations that need an inventory with bar code tagging = thoughts of many, many dollars run through their minds.
  4. Lack of policy/procedures = lack of maintaining accurate fixed asset records.

Recommendations to perform an ACCURATE and MANAGEABLE fixed asset project.

Priorities for this Client were to get their federal Tax, State and AMT calculations automated.  We based their project off of this high priority.

  1. PHASE ONE: Implement an automated fixed asset accounting solution (Sage FAS 500 Asset Accounting was used).  Finalize this project implementation, work through the data and get it live for use.  Ran their 4562’s, 4797’s, etc.  Receive an immediate return on the software and implementation costs.
  2. PHASE TWO: Start to roll out the physical asset inventory project  through a pilot program.  Starting small — prioritized the PILOT by number of anticipated fixed assets and activity.  Finalize and reconcile this data to observe the findings and obtain an immediate cost recovery on project.
  3. PHASE THREE: Perform the physical inventory on the other locations that were necessary – again, based on priority.  Reconcile results – find and capture the return on investment by property tax savings and insurance premiums.
  4. PHASE FOUR: Implementation of an automated fixed asset inventory solution that supports the use of bar code readers / technology (Sage FAS 500 Asset Inventory was the solution of choice).  Now the Client can maintain the clean database and keep it maintained with annual physical inventory audits, etc.
  5. PHASE FIVE: Consulting on on-going use / maintenance of the fixed asset solutions and complete management.  Set in place policies/procedures and train staff on the workflow and systems where necessary.

Working with a Phase approach to fixed asset management works to keep it manageable.  Not only is it manageable for your staff and your business… it’s also manageable for your budget, as each phase pays for itself at the end.  Every step of success opens doors for more.

Need consulting help with your fixed asset management roll-out?  Call us today at (541) 338-7898.

www.FixedAssetConsulting.com | www.FixedAssetSoftware.com

, , ,

AssetFlow Web Portal For Fixed Asset Accounting

Fixed Asset Consulting, LLC launches new online platform to simplify and centralize fixed asset management for companies with multiple locations or users.


EUGENE, OREGON – September 06, 2017Fixed Asset Consulting, LLC, a firm led by nationally recognized fixed asset expert Angie Chase (formerly Bolton-Lyons), has announced the launch of AssetFlow. AssetFlow is a web portal for companies with multiple offices and users that want to simplify and take control of their fixed asset management process. The web-based platform allows customers to continue using their existing on-premises asset accounting software while leveraging a web portal to view, manage, and consolidate their data in a single, centralized location. The AssetFlow portal is now live and available to customers on a subscription basis.

AssetFlow Web Portal Streamlines Fixed Asset Accounting >>


Critical Field Updater Now Available for Standard (Sybase)

Critical Field Updater: Sybase Version Now Available

After years of internal use and some serious client testing, a new version of FAC’s CFU is available with additional functionality and now includes a Standard (Sybase) version of the Sage Fixed Assets depreciation solution.  This means that clients no longer have to use the Premier SQL version in order to benefit from the CFU.

Added Functionality Includes:

  • Automatic import of your data sheet once selected through the browse function
  • Only assets with ‘errors’ are flagged with in red after validation process
  • Support email link exists for quick support
  • Additional customization is available
  • Ability to edit data within the user interface
  • Updated to work with v2017.1 of the Sage Fixed Asset Depreciation products

This utility allows the end-users the capability to update depreciation fields across all or selected depreciation books, globally.

Contact us for more information or questions @ (541) 338-7898.

NOTE: This product is only supported through Fixed Asset Consulting, Llc; where developed.