The quick & easy way to import into CaseWare

Posted by James Goligher

Topic(s): Tips and Tricks

Read Time: minute(s)

To take full advantage of CaseWare's power to automate your reports, you must first import your data. 

There are numerous accounting software packages that CaseWare imports from directly. Even if your package is supported, however, we do not typically recommend you use the "Accounting Software" method. Instead, we advise using the "Excel File" import feature. 


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.

For more on this topic(s), see: Tips and Tricks

Originally Posted on 09 February, 2017

Replace Excel as your reporting tool. CaseWare is the smart choice

Recent Posts