We are pleased to announce the introduction of the Transaction Import feature within WealthWorks+. This functionality enables you to import all current transaction types, including:

  • Bank Payments

  • Bank Receipts

  • Bank Interest

  • Multi-sided Journals

  • Foreign Exchange Journals


From the Import screen, you can download a template CSV file, open it in Microsoft Excel or any other CSV editor, and populate it with your data. Once the file is ready, upload it by selecting the file or dragging and dropping it onto the Import screen. The import process will start automatically, and you can monitor its progress in real time. 


After validation, WealthWorks+ will confirm that your transactions are ready to be imported. At that point, you can either import them immediately for instant processing or schedule the import for a later time, which is especially helpful when managing large volumes of transactions. 

 

Take care when saving CSV files in Microsoft Excel as additional rows and columns can easily be added in error. Using a free application such as Notepad+ is more reliable for working with CSV files.



Requirements to Import the CSV file:

  1. For this import file format you can choose to leave the header row in the file, however you must leave the exact column headings in row 1 exactly as they are. Alternatively, delete row one from the template.  
  2. The Entity Reference in the CSV must match an existing entity in the database. The users must have the entity in their Contact Security Group to be able to import a transaction to it.
  3. Use the date format DD/MM/YYYY for the transaction and value dates.
  4. Transaction Types must be MSJ, PAY, REC, INT or FEX.
  5. Currency codes used must exist in the database.
  6. The rows belonging to a transaction are identified by having the same value in the TransRef1 field.  All the entity references and fund references for that transaction must be the same.  
  7. The entity defined on each row must have an entity reporting currency set, the valid sub fund and accounting period.
  8. The transaction doesn't need to balance at this stage, but should balance to post to the nominal ledgers.


Tutorial Transcript


To import transactions into WealthWorks+ you will need to go to Finances > Transaction Import.


[00:24] The import template can be downloaded by clicking on the 'Import Template' button on screen. 


[00:33] To upload a file, either click on highlighted area 
on screen to launch file explorer and search for 
your file, Or, drag and drop your file on the import screen. 
The upload will begin automatically. Progress of the import will appear at the top of 
your page. If you have alerts enabled, you will also see the 
progress of the import with these. 


[01:16] Once the import has been successful, you can see the transactions which are pending import, in the 'Pending Transaction' Tab. If you import is not the most recent, select the relevant import from the drop-down menu. If the upload is ready to post, the status field will 
appear green. If any errors are present, click the 
red ‘Error’ status to view the details.


[01:58] Click on 'Post All', you can then select whether you would like the transactions to post now, or for larger uploads, choose ‘Post Later’. 
WealthWorks+ will automatically schedule them 
at 00:00, reducing impact on other users. Progress of the import will appear at the top of your page, as well as the Alerts, if enabled will update.


[02:23] Once successfully uploaded, you can view the entries on your Entity. Within 'Finances', 'Transaction List', if you filter the page by Entry Date you will the records added 'Today.’   Within 'Finances', 'Transaction List', if you filter the page by Entry Date you will the records added 'Today.’   


 This tutorial is confirmed to be applicable from WealthWorks+ release 4.16