Home Quicken for Mac Download, Add/Update Accounts (Mac)

How do I separate entities into their own files?

I currently lump all my asset/investment accounts together. They actually belong to three different entities (LLC, Trust, etc). How can I separate current data to arrange a separate file for each entity so they have their own income statements/balance sheets and I don't have to do it by hand?

Best Answers

  • John_in_NCJohn_in_NC SuperUser ✭✭✭✭✭
    Accepted Answer
    It can be done, but it will take a little work:
    1. Create a backup of your existing file
    2. File:Export:Quicken Windows Transfer File (QXF) Save this file to the desktop for easy access.
    3. Create a new blank file via File:New. Use the Start from Scratch option.
    4. In the new blank file, File:Import:Quicken Windows file. (Or, simply drag the file from step two to the open Quicken Window or dock icon.
    5. This will reproduce your original file and should be identical to your original.
    6. Delete out all the accounts that do not pertain to Entity 1
    7. Repeat step 3 two more times, with each file only containing the accounts desired for that entity.
    You can use File:Open Recent to jump between files. You can also use File:Rename to give the file unique names for each entity.

    Your original file will also remain untouched, so you can always go back to that.

Answers

  • John_in_NCJohn_in_NC SuperUser ✭✭✭✭✭
    Accepted Answer
    It can be done, but it will take a little work:
    1. Create a backup of your existing file
    2. File:Export:Quicken Windows Transfer File (QXF) Save this file to the desktop for easy access.
    3. Create a new blank file via File:New. Use the Start from Scratch option.
    4. In the new blank file, File:Import:Quicken Windows file. (Or, simply drag the file from step two to the open Quicken Window or dock icon.
    5. This will reproduce your original file and should be identical to your original.
    6. Delete out all the accounts that do not pertain to Entity 1
    7. Repeat step 3 two more times, with each file only containing the accounts desired for that entity.
    You can use File:Open Recent to jump between files. You can also use File:Rename to give the file unique names for each entity.

    Your original file will also remain untouched, so you can always go back to that.
  • FrankxFrankx SuperUser ✭✭✭✭✭
    John,

    There are two potential approaches you could take.

    The easiest approach would be to use tags for each of the different entities (one tag could be "LLC", another "Trust", etc.).  You would continue with the current Quicken file, with the various "accounts together" as you put it, but the tags would allow you to generate reports that would only include data for each entity.  You would, of course need to go back in history (for whatever time period you'd like to have separate information and add the tags).

    The other approach would be to setup three different quicken files - one for each entity.  To do this, you would take your current quicken data file and make two additional copies of it; then rename the files - one for each of the entities.  The next step would be to go into each of the data files - one-at-a time, and purge all accounts (i.e. delete bank accounts, assets, liabilities for example) and transactions that apply to the other two entities.  Depending on how long you've been tracking these entities and the number of accounts and transactions, this may be an onerous task.  It would however, leave you with the "cleanest" set of book for each entity, so to speak.

    Let me know if you have any questions and good luck!

    Frankx


    Quicken H&B-Subscription - Ver. R26.23 - Build 27.1.26.23  - Windows 10 Home - Ver. 1909
                                             - - - - Quicken User since 1984 - - - 
      -  If you find this reply helpful, please click "Like" (below), so others will know! Thank you.  -
  • FrankxFrankx SuperUser ✭✭✭✭✭
    edited January 14
    John2020 (original poster),

    Per Quicken Help:

    • The import and export of investment and business accounts, transactions, budgets, attachments, reports, and application settings is not supported by QXF.  
    Therefore using the "QFX export" approach discussed above will not work for your investment accounts, and likely would not provide you will a full transfer of historical information.  The advice I provided above, will allow you to retain all historical data, including accounts, transactions, settings, etc.


    Quicken H&B-Subscription - Ver. R26.23 - Build 27.1.26.23  - Windows 10 Home - Ver. 1909
                                             - - - - Quicken User since 1984 - - - 
      -  If you find this reply helpful, please click "Like" (below), so others will know! Thank you.  -
  • John_in_NCJohn_in_NC SuperUser ✭✭✭✭✭
    edited January 14
    Frankx said:
    John2020 (original poster),

    Per Quicken Help:

    • The import and export of investment and business accounts, transactions, budgets, attachments, reports, and application settings is not supported by QXF.  
    Therefore using the "QFX export" approach discussed above will not work for your investment accounts, and likely would not provide you will a full transfer of historical information.  The advice I provided above, will allow you to retain all historical data, including accounts, transactions, settings, etc.
    That was referring to Quicken for Windows. Quicken for Mac QXF import/export handles all transactions, including investments.
Sign In or Register to comment.