1. Uploading Template

Navigation: Community Level > Finances > General > Cashbook

The Cashbook Options button and the dropdown list select Upload bank statement. If this is the very first bank statement upload, this is usually indicated by the last upload date stating 1970-01-01. Click on the Cashbook Options button, and the dropdown list select Upload bank statement

If this is the very first bank statement upload select Create New template From This File. Click on the Select Bank Statement file and select the specific CSV bank statement that needs to be uploaded.

Once the file has been uploaded, the button will turn green. This will indicate that the file is now ready to be uploaded. 

2. Create a Template

Once the bank statement has been selected and the upload has been clicked, the following screen will appear

2.1 Naming the Template

• Template name: Create a name for the template. The best practice is to copy and paste the bold section of the Bank Name and Account Number.
• In which cell does the Account number appear:  If the Account number appears in its' own single cell, without any text, specify in which cell it appears. 

• Date format: Choose the date format exactly as it appears on the electronic bank statement file. To see this, refer to the preview screen on the system. The transaction detail within "column A" will show exactly which date format is used in the CSV and thus which format to choose. 
• Zero amounts: Choose if Zero Amounts should be brought in or ignored.

2.2 Selecting Columns

Specify the essential column headers for import. There are only three fields required to create the template.

1. Date

2. Amount

3. Description - There is an option to add a Description 2 should the statement contain a secondary description

Select ignore on columns that do not contain any relevant information. Do not bring in the balance as an amount column as WeconnectU is designed to calculate a balance automatically.

2.3 Selecting Rows

Specify which rows can be classified as Header, Detail, and Footer.

1. Header: All rows above the first transaction line will be HeaderAmount
2. Detail: All transaction lines, must contain a Date, Description and Amount.
3. Footer: All rows beneath the last transaction will be Footer. 

Click on Save Template after all rows and columns have been labelled.

Once the template is saved, the screen will automatically redirect to 

Check through the new transactions and the possible duplicates. The system will pick up duplicate transactions if the date, description, and amount are the same as any transaction that has been uploaded previously.

The system will display a list of all of the transactions that are about to be uploaded under the

1) New Transactions: These are transactions which the system recognises that have not been previously uploaded.

2) Possible Duplicates: here a list will be displayed should the system recognise a transaction line as a duplicate. There is still an option to upload the transaction by selecting the toggle box. 

Once all the transactions that need to be uploaded are selected, click on Confirm Transactions at the bottom of the page. 

3 Manual Transactions

Navigation: Community Level > Finances > General > Cashbook

To manually capture the bank statement, hover over Cashbook Options. Click on Manual Transactions.

The following screen will appear. Manually select the date, description, and amount as well as whether the amount is an income or expense. Click on Add Line if more than one transaction needs to be captured. Once done click on Upload Transactions to add these manual transactions to the cashbook.