To take full advantage of CaseWare's power to automate your reports, you must first import your data.
There are two key benefits:
- Consistency. Perhaps you work in an accounting firm and need to import from dozens of different accounting packages. Rather than learn different processes for each, you can learn just one - Excel.
- Data Integrity. Working with Excel you can review data and ensure it balances before you import.
Many folks identify a drawback, however - speed. With Excel, users must specify numerous options before import, which can be both confusing and time-consuming.
If that's your experience, this blog is about to save you that most valuable of assets, time.
Most users don’t know about the ‘Record Layout File’ option. Simply put, it’s a way for you to automatically populate all options in the Excel Import Wizard. Making the import a 4-second process. No more identifying rows to be excluded, no more labeling columns, no more selecting advanced options every time you import. Instead define these criteria a single time, save a record layout file and apply it subsequent imports.
NOTE - to take advantage of this process, you will want to have the Excel file in the same format every time you import it. So, it is best to find the right report in the accounting software, and export that same one every time.
For more information on importing from Excel to CaseWare Working Papers, including a demonstration of how to get from import to draft Financial Statements in under 3-minutes, see our CaseWare Feature Spotlight: Importing Data blog.