This function imports your QuickBooks and Return Preparation Payment Information files into Drake Software. Go to Tools > File Maintenance > Import Data.


Before QuickBook files can be imported into Drake, they must be exported from QuickBooks.


Exporting Files From QuickBooks


    1. In QuickBooks, open the customer to or from whom you want to export information.
    2. Select the Reports tab; select Accountant & Taxes option; select Income Tax Summary.
    3. Once the report is on the screen, go to the Modify Report tab. Click Advanced.
    4. Under the Display Rows tab, click All. Click OK.
    5. Select the Print tab above the report.
    6. Click File.
    7. Ensure the selection says ASCII Text File.  Press ENTER.
    8. Input a unique file name, such as ABC TAX SUMMARY.
    9. Save the file. The file is normally saved in the following subdirectory:  C:\Program Files\Intuit\QuickBooks Pro\


Importing QuickBooks Files into Drake Software

IMPORTANT: Always backup the Drake Data files before importing from QuickBooks files.

    1. Select Tools > File Maintenance > Import Data.
    2. Choose QuickBooks Financial and Accounting Software, then click Next.
    3. The Instructions screen appears, click Next. 
    4. Step 1. Import File Name – Use the Browse button to locate the file to be imported. Refer to step 9 above for file name and location.




  

    1. Select the file to be imported, click OK.
    2. Step 2. Enter the SSN/EIN for the client. This number is used in Drake Software to reference the tax return.





    1. Click Next.
    2. Step 3. shows the Business Type. If the business type has multiple options you are presented with drop list. 





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






    1. Review the information in the window. 
    2. Click Back to correct any information or Finish to begin the import process. The import process should occur quickly. When done the data entry screen opens.



Return Preparation Payment Information


    1. Go to Tools > File Maintenance > Import Data.
    2. Choose Return Preparation Payment Information (Excel, CSV, Tab Delimited), then click Next.
    3. The Instructions screen appears showing a sample of an Excel spreadsheet, click Next. 
    4. Step 1. Import File Name – Use the Browse button to locate the file to be imported. 
    5. Step 2. Choose the Starting Row. Notice that Step 1 now shows the name of the spreadsheet that was imported. 





    1. In the example above the data begins at row 2; the first row has the header data. 
    2. Click Next.
    3. Step 3. The file is Ready to Import. 


               



    1. Click Import.
    2. The Payment Import screen indicates the import was successful.  





Return Preparation Payment Information - Manual Entry


    1. Go to Tools > File Maintenance > Data Import.
    2. Choose Return Preparation Payment Information (Manual Entry), then click Next.
    3. The Instructions screen appears, click Next. 
    4. The Apply Payment screen appears.
      1. Type in an SSN/EIN number. (1)
      2. Type in a Description. (2) 
      3. The date automatically is set to the system date. You may change the date. (3)
      4. Type in the amount of the Payment. (4)
      5. Click Save. (5)





      1. Drake Software Alert appears. Choose Yes or No. 





      1. The Apply Payment screen indicating a successful payment.