The quick & easy way to import into CaseWare

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.

Why?

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.