CMS - Bulk Banking Guide: FNB 3PIM

Created by Mienette van Heerden, Modified on Thu, 9 Jul at 9:47 AM by Mienette van Heerden

The Bulk banking function enables a single bulk banking file to be imported for multiple communities at once. The Solution automatically separates the transactions into the relevant communities based on the account numbers, saving time by removing the need to import each community's bank statement individually.


To be able to use the Bulk Banking Function, the following steps need to be done:



1. Setup


1.1. Get into contact with FNB 3PIM


FNB 3PIM

e: 3PIM@fnb.co.za


1.2. Setup all FNB 3PIM accounts


FNB 3PIM then guides the migration process or the setup of the necessary FNB accounts.


1.3. WeconnectU Cashbook Setup


Once the accounts have been migrated to FNB 3PIM, the bank accounts/ cashbooks on the Solution needs to be setup to enable the FNB 3PIM Bulk Banking Integration.


Navigation: Community Level > Finance > Setup - Financial


Click on the dropdown list of Bank Integration and select the FNB 3PIM integration per the bank setup in use.





Note: This process must be completed for all FNB accounts across all Communities




2. Uploading Cashbooks


2.1. Retrieving Bulk Cashbook via Email


FNB 3PIM will send the bulk statement daily. The statement contains transaction data that is two days old. The automated delivery of these statements is configured and managed by FNB 3PIM.



2.2. Upload Cashbook on WeconnectU

Navigation: Global Overview > Finance > Cashbook


On the Cashbook landing page, select Cashbook Option located on the far right of the screen.



  • From the drop-down menu, click on Upload Cashbook, and select the FNB 3PIM option.



  • Upload the file received from FNB. 
  • Lastly, check for duplicates, and click on Submit.



3. Export Supplier Payments


Supplier invoices must first be created within the Solution and authorised by the relevant Business User or Trustees/Directors before processing can continue. Click here to view the how to guide on Supplier Invoices.


3.1. Export Function

Navigation: Global Overview > Finance > Payments


On the Payment landing page, select Export Payments located at the top right of the page.



  • A list of all authorised Payments will be displayed, from which the required Payments can be selected for export and processing.




Note: An Excel file containing all authorised and selected payments will be downloaded, which can then be uploaded to ABSA Bank for processing.




3.2. Upload to FNB 3PIM

Navigation: FNB Login > Payments > 3PIM


On the Payments 3PIM page, click on Add, and select Add Batch.





Click on Import and complete the following steps:




  • Give payment file a name.




  • Select the export file to upload, and click Continue.





  • Lastly, Click Finish, and Submit payments.






Resources:


CMS - Bulk Banking How to Article

Read Here



Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article