Exporting Assets from BNA Fixed Assets Desktop (based on Tax Year 2005) 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 the BNA program.
    Create the folder on your server if multiple users need to access these files.
  2. Open BNA.
  3. Open a client (click File, Open Company, select the company).
  4. Click on Reports, choose 'Calculation Reports'
  5. Pick 'Book Depreciation Schedule'
  6. At the bottom, click 'Print Report'
  7. A window pops up asking for the Print Destination
  8. Choose 'Print Report to File'
  9. Locate and choose the folder created in Step 1
  10. At the bottom of the window, change 'Type' to 'CSV'.
  11. Save the file (do steps 3-10 for all clients that you want to import into PPP)
  12. Open Personal Property Pro.
  13. Add the client if not already added, saving at least the client corporate and owner name.  Click 'Save & Exit'.
  14. Click on 'Clients', and highlight the client you want to import asset information for
  15. Click on the 'Import Assets' button (upper-right)
  16. Click on the 'Locate the File...' button (must be a file ending in .CSV)
  17. Go to the folder where the file was exported (step 1)
  18. Click on the client file you exported.
  19. Open file.  PPP reads in the file and puts it into a grid of rows and columns.
  20. Setup the fields above the grid in Personal Property Pro
    A. First  1  rows contain column headings
    B. Which column contains the Asset Description? Column  2    
    C. Date Acquired - column   3  
    D. Asset Cost - column   4  
  21. 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 20-21
     
  22. 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).
  23. After making necessary adjustments to any asset categories, click on 'Next Step' at top of screen
  24. Review assets with your prior totals.  Make any changes by clicking on 'Prior Step' and making modifications. Then click 'Next Step'.
  25. Click 'Import Assets', either overwriting all assets, or appending assets to current assets for this client.
  26. 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