How can I combine my 5 existing files into a single file?

English
1

Hello,

I currently have 5 files in PP:

  • Stock market assets ;
  • Financial assets in real estate ;
  • Financial assets in renewable energies;
  • Life insurance ;
  • Regulated savings (Livret A, LDDS, etc.).

I’d like to group them together in a single file, but without re-entering everything and therefore using the PP functions, which I obviously don’t master.

Have any of you already done this?

At the moment, I’ve used drag and drop to transfer all the securities from the 5 existing files, then I’ve created the corresponding securities accounts and cash accounts and I was thinking of exporting CSV files to import them into my consolidation file, but it’s a bit of a pain. I’m not sure this is the right method.

I’m looking forward to your possible solutions.

Thank you very much.

2

The search would have answered this questions.

for instance:

Thread in German for a possible workaround:

3

Thank you Sn1kk3r5 for your feedback.
I did do a search but the language barrier didn’t allow me to find the links you’re pointing out.
I’m going to have a look at them, especially the one in German which seems to be the most detailed…

4

Hello,

If it’s any help, I’ll tell you how I went about combining my old files (see above) into a single one.

1° Create a new file. In this new file I created all the accounts (deposit, cash and securities) that existed in the old files. No particular problem at this stage;

2° Creating all the securities in the old files by drag and drop. Left-click on the tab for the new file, drag down, right, left and your screen is split in two, either vertically or horizontally. Choose the configuration that suits you best. Then, one by one, open the old files normally located on the left, go to ‘All titles’, select them and, once done, drag the block of titles to ‘All titles’ of the new file. If you’re in the wrong position, you’ll see a little one-way icon. When you are correctly positioned on the ‘All titles’ line, let go and the titles will be copied. Repeat as many times as necessary.

3° Exporting ‘All transactions’ from each of the old files. There are no particular difficulties for old files that only have a securities account and a cash account. On the other hand, for files with more than 2 accounts, operations are a little trickier and you need to proceed gradually and calmly. As far as I was concerned, this concerned the stock market file, which has 5 accounts. 1 deposit account (BoursoBank), 1 PEA securities account, 1 PEA cash account, 1 ordinary securities account (CTO) and 1 CTO cash account. For this file, display ‘All transactions’ and sort on one or other of the last 2 columns (clearing account, cash account, etc.), select the lines corresponding to identical movements (e.g. PEA cash and PEA securities, etc.) and create a specific file for each block of transactions.

4° Importing the CSV data. Before carrying out this operation, I put the tab for the new file back where it belongs (left-click on the tab and position it on the tab bar for the old files). Position yourself on the tab for the new file and start with the simplest CSV data (just 2 accounts). Click on Import>CSV file, select your CSV file, a window opens with the same error (?) ‘Mandatory field not assigned: Value’. Find the right column, normally ‘Amount’ or ‘Net value of the transaction’, double-click where indicated, a window opens and you select ‘Value’. If it’s OK, the next button becomes active, you click on it and a final window opens. Check at the top of the window that the title account and species account displayed correspond to the transactions to be imported.If everything is OK, each line will have a green tick.Click on ‘Finish’ and you’re done for this file.For other files with 2 accounts, the procedure is the same.For my file with 5 accounts, I proceeded in the same way but paid particular attention to transactions involving 3 accounts.
When this is the case, the last window that opens (see above) shows the securities account, the cash account and also the words ‘Transfer to …’. Think about it and click on ‘Finish’ when you are sure.

In the end, you are not taking any risks because your old files are still active. In any event, the deposit account balances must be identical to the old files and the characteristics of the securities accounts (securities, share, amount, …) must also be identical.
Good luck!

3 Likes