Drake Tax - Importing Data from QuickBooks

Article #: 12048

Last Updated: December 05, 2024

 


Tags: Drake Tax

Drake Tax logo

You can import tax information from QuickBooks into Drake Tax by first exporting the file from QuickBooks, and then importing the file into Drake Tax. We recommend that you always make a backup of your Drake Tax files and the QuickBooks files prior to continuing with this process.

Important  This process is not available if using the online version of QuickBooks.

See Drake Tax - Data Imported to Drake Tax from QuickBooks for the list of data that is imported.

Export

  1. In QuickBooks, open the client from whom you want to export information.

  2. Select the Reports tab > Accountant & Taxes > Income Tax Summary.

  3. Once the report is on the screen, go to the Modify Report tab. Click Advanced.

  4. Under Display Rows, select All.

  5. Click OK.

  6. Select the Print tab above the report.

  7. Click File.

  8. Ensure the selection says ASCII Text File.

  9. Press Enter.

  10. Enter a unique file name, such as ABC Tax Summary.

  11. Save the file, noting the location so that you can browse to it later.

    Tip  The file is normally saved in the following sub-directory: C:\Program Files\Intuit\QuickBooks Pro\

Import

  1. Select Tools > File Maintenance > Import Data.

  2. Select QuickBooks Financial and Accounting Software.

  3. Click Next.

  4. The Instructions screen appears, click Next.

  5. Step 1. Import File Name – Use the Browse button to locate the file to be imported. Refer to steps above for file name and location.

  6. Select the file to be imported, click OK.

  7. Step 2. Enter the SSN/EIN for the client. This number is used in Drake Software to reference the tax return.

  8. Click Next.

  9. Step 3. shows the Business Type. If the business type has multiple options, you are presented with a drop list.

  10. Click Yes. The QuickBooks Import – Step 4. window appears.

  11. Review the information in the window.

  12. Click Back to correct any information or Finish to begin the import process.

  13. The import process will occur quickly. When done the data entry screen opens.