Open Thema mit Navigation

Access Accounting import

Accounting Index

Note

• You will be able to import from Access Accounting files only when Working Papers detects that ODBC engine and driver has been installed on your computer. If you do not have the ODBC engine and driver, they can be obtained from the CaseWare website:

  http://www.caseware.com/downloads/wp-downloads/odbcupd.exe.

• Note that in order for the import to work correctly you must run Working Papers as an administrator if you are working on Windows Vista or Windows 7.

To set up the ODBC file:

1. Download and save the file to its own folder.
2. Run odbcupd.exe.

What Access Accounting files are needed:

How to do it:

1. On the File menu, select Import, and then Accounting Software.
2. In the Import From box, select Access Accounting.
3. In the Version box, select the version of Access Accounting you want to import.
4. In the Import Path box, type or select the exact path where the Access Accounting file resides. Use the Browse button to locate the client directory manually.
5. Under Import Components, choose to import either the Trial Balance or the full General Ledger Detail.
6. Select the Import Client Information check box to import engagement properties such as name, address, and contact information from the import file.
7. In the Select Client ID file (.df1) box, select the client file by its identification code (base file name). If this box is blank, check that the import path (entered above) is correct.
8. Select either Import current year or Import prior year as current.
9. To import prior year balances into the Working Papers file, select the Prior Year Data check box. To import budget balances into the Working Papers file, select the Budget Data check box. To import forecast balances into the Working Papers file, select the Forecast Data check box.
10. To import period balances into the Working Papers file, select the Period Balances check box. The program imports period balances based on the period types designated in the original file. If the period type does not exist in the client file, for example, if importing quarterly balances into a client file that does not have quarterly balances set, Working Papers automatically updates the client file for the new balance type.
    
    Imported period balances affect the Working Trial Balance only.
    
    The kind of data that can be added to the file (transactions or period balances) is set in the Engagement Properties Period Balances Tab.
11. Click OK to process the import.

Related Topic

• Importing again