Banking: Import a Bank Statement

Banking: Import a Bank Statement

You have two options to import transactions into PropWorx: using the bank statement import or manually entering the transactions (see article: Banking: Load Manual Transactions). 

1. Click on Accounting on the Main Menu.


2. Click on Banking



3. On the main ribbon bar, select the New Transactions.



4.  New Transaction screen will open. 

5. Select the Cashbook (or the Bank) from the drop-down menu



6. Click on Import Bank Statement button.



7. Click on browse to search and select the saved bank statement. Click on Save.



8. Transactions will be imported and appear on the bank statement table. 



9. If required: Allocate transactions, split transaction and create transaction rules.
10: When ready, proceed with processing the transactions.  Optional: type in the bank closing balance.



11. Select the transaction rows by ticking them.
12. Initiate the processing by clicking the Process button.


Note: If the closing balance is filled in, PropWorx will perform an auto bank reconciling.


13. The transaction will be processed and recorded in the designated file.

Allocate unallocated transactions.

1.  Click on “not allocated…(select file)” on the transaction row.



2.  Search and select file by clicking on the file name.



3. The transaction will be assigned to the chosen file.



Split a Transaction

1.  Click the action icon () on the transaction row and select “Split Transaction” from the menu.



2.  Manage Split Transaction screen will open. Under the Split Transaction section, select the file on the split row. 



3. Search and select file by clicking on the file name.


4. The file will be assigned to the split row. 
5. Type in the Description and Amount. 
6. If required: Add the VAT and tick to show in tenant statement.


7. Click on the Add button () to load the split row. Repeat step 2 until all split's rows are added. To modify any rows, click the remove button () to remove the split row. 



8. Once the Remaining Balance reaches zero, click Save Split to record the split transactions.



9. The split will be saved, and on the main screen, the original transaction will disappear and only display the split transaction in green.



10. Optional: To modify the transactions, click the action icon () on the transaction row:
  1. To Edit split click on “Edit Split Transaction”.
  2. To delete the split group and restore the original transaction, choose “Delete Split Group.”

Delete Transactions

1.  Enable the Turn on Delete mode from the main heading.



2.  Select the transaction rows by ticking them and click on Delete button.



3. Selected transactions will be deleted from the bank import screen. 


Create Import Rule


1.  To create Import rule, click on Import Rules Button from the main heading.



2.  Click Add () button. Fill in the required details:



3. Click Update () button to create the rule. 
4. Close rule screen.
5. If required: Click on Run Rules button. Rules will run and allocate transactions. 





    • Related Articles

    • Banking: Load Manual Transactions

      You have two options to import transactions into PropWorx: using the bank statement import (see article: Banking: Import Bank Statement) or manually entering the transactions. 1. Click on Accounting on the Main Menu. 2. Click on Banking 3. On the ...

    • Import a Netcash Statement

      You have two options to import Netcash transactions into PropWorx: using the auto bank statement feed or manually import the transactions 1. Click on Accounting on the Main Menu. 2. Click on Banking 3. On the main ribbon bar, select the New ...

    • Banking: Split Transactions on Bank Import Screen

      1. Click the action icon () on the transaction row and select "Split Transaction" from the menu. 2. Manage Split Transaction screen will open. Under the Split Transaction section, select the file on the split row. 3. Search and select file by ...

    • Bank Import: Split a Transaction

      1. Click the action icon () on the transaction row and select “Split Transaction” from the menu. 2. Manage Split Transaction screen will open. Under the Split Transaction section, select the file on the split row. 3. Search and select file by ...

    • Perform a Bank Reconciliation

      Bank Reconciliation is the process of checking differences between the transactions loaded on the PropWorx and the transaction on the bank statement. You can use the bank reconcile to match the bank transactions imported with those on the statement ...