Exporting Assets from CCH ProSystem fx Fixed Assets (based on Tax Year 2006) and importing them into Personal Property Pro

Once you've done one client, the rest will be easy.

  1. Create a folder where you want to store asset information files from ProSystem fx Fixed Assets program.
    Create the folder on your server if multiple users need to access these files.
  2. Open ProSystems fx Fixes Assets program
  3. Double-click the client you want to export the asset information
  4. Click on File, the Print, then Reports
  5. Select Asset Reports on the left
  6. Select Asset Information Report
  7. Click Print
  8. Check the 'Print to File' checkbox
  9. Save as CSV file
  10. Choose location of folder created in Step 1 and save (do steps 3-9 for all clients that you want to import into PPP)
    NEW FOR 2006
  11. Open the CSV file in Excel
  12. Delete all columns past EC (verify that EC is your 'Cost' column).
  13. Delete all columns except the Description, Date, and Cost, so that you have only 3 columns in the excel file.
  14. Click 'Save As'
  15. Change the 'Save as type' to 'Text (MS-DOS) (*.txt)'
  16. Click Save and answer YES to saving the file in this format.
  17. Close Excel and say NO to 'changing the saves you made'
     
  18. Open Personal Property Pro
  19. Add the client if not already added, saving at least the client corporate and owner name.  Click 'Save & Exit'.
  20. Click on 'Clients', and highlight the client you want to import asset information for
  21. Click on the 'Import Assets' button (upper-right)
  22. Click on the 'Locate the File...' button (must be the file ending in .TXT)
  23. Go to the folder where the file was exported (step 1)
  24. Click on the client file
  25. Open file.  PPP reads in the file and puts it into a grid of rows and columns.
  26. Setup the fields above the grid in Personal Property Pro
    A. First  0  rows contain column headings
    B. Which column contains the Asset Description? Column  1    
    C. Date Acquired - column   2  
    D. Asset Cost - column   3

    Note: There are 'filter' options in ProSystem fx Fixed Assets program which may let you filter out some of the columns for the report.  PPP only needs 3 columns, the Description, Year Acquired, and Cost.  A 4th column to help assist you in double-checking the categories would be the 'Category' column.  You might play with these settings in ProSystems, and then adjust the columns in PPP accordingly.
     
  27. Click on the 'Reload File' button in upper-right corner, and Personal Property Pro will try to auto-assign the county categories for you.

    ONCE YOU HAVE SET UP YOUR FIRST CLIENT YOU DON'T HAVE TO DO STEPS 26-27
     
  28. Review assets to import, making sure asset categories on the far left are correct.  Re-class the assets that you want to import that say 'unassigned' and the box is unchecked. (Double-click the asset and choose from the drop-down list).
  29. After making necessary adjustments to any asset categories, click on 'Next Step' at top of screen
  30. Review assets with your prior totals.  Make any changes by clicking on 'Prior Step' and making modifications. Then click 'Next Step'.
  31. Click 'Import Assets', either overwriting all assets, or appending assets to current assets for this client.
  32. Close the form and open the client by double-clicking.  Click the 'Assets' tab.  This is the summary screen, and by clicking on any button or column you can add/edit/delete individual assets.

After the 1st year, you can choose to import only the current year assets (or you can key them in manually):
    1) Checking the 'Flag all assets acquired from #### to ####' checkbox
    2) Select just the previous year in both combo boxes (Example: 2006 to 2006). 
If this is checked, Personal Property Pro will read in the entire file, and will automatically check only the assets acquired within the range of years you select.  After you verify the asset category for each checked asset (you can uncheck assets if your county does not include them), you can proceed to import the assets.

You can assign several assets the same category simultaneously.  Click on the '?' button next to 'Assign category to selected asset(s) at the bottom for help.

Back to Asset Import Help