Excel is the tool of choice for getting data ready for import. Data is brought into Excel directly from the legacy program, or it is imported as a delimited file created by another application. Once the data is in Excel there are several strategies to prepare it for import. This article shows how easy it is to filter data with just the click of a mouse.
I recently attended a workshop that was so spot-on I’ll even mention the speaker and his company: Kevin Grimes of CFO Leasing. I never met Kevin prior to that workshop but was very impressed with how clearly and succinctly he conveys the pitfalls and nuances of becoming DCAA compliant.
Getting a notice that you are going to be audited by DCAA should not be frightening, but should be a joyful notice. The fact that your company has gotten the attention of DCAA means that you are about to be awarded a large contract or your business has grown so successfully that you are a larger federal contractor; both reasons to be happy, not frightened. However, at this point, you need to understand that: