Key Steps
Step 1: Access Bank Reconciliation Page 0:03
Navigate to the bank reconciliation page in VRTrust.
Click on the blue 'Add Account' button located at the top right corner.
Step 2: Add Trust Account 0:21
Select 'Import Bank Records with CSV'.
Choose 'Bank Account' as the account type.
Enter the account name and the last four digits of the bank account.
Set the bank feed start date to the first day of the Go Live month.
Step 3: Enter Previous Month's Balance 0:35
Input the ending balance from the previous month's bank statement.
Click 'Submit' to finalize the account addition.
Step 4: Add Bank Records 0:48
Open the newly added bank account.
Select 'Add Bank Records' from the ellipses in the top right corner.
Step 5: Download CSV Template 0:56
Download the CSV template file for bank transactions.
Step 6: Fill in Bank Transactions 1:07
Enter the date in the 'Date' column.
Fill in the transaction description in the 'Description' field.
Record deposit amounts as positive numbers and expense amounts as negative numbers.
Step 7: Save and Upload CSV File 1:19
After entering all transactions for the month, select the date format that matches the template (e.g., month, day, year).
Save the file as a CSV.
Upload the template and import the bank records.
Step 8: Verify Imported Transactions 1:31
Go to the bank feed tab on the reconciliation page to check that all transactions have imported correctly.
If any duplicate transactions are found, select the ellipses next to the transaction and choose 'Exclude' to remove the duplicate.
Delete Uploaded CSV Bank Records
Navigate to the Bank Reconciliation Page
Select the bank account where the records were added
Click the Bank Feed tab
Locate a CSV-imported record (cannot be matched)
Click the ellipses (...)
Select Delete
Confirm the action
The reconciliation data refreshes automatically afterward.
Important: Only unlocked records can be deleted. Locked or reconciled records may remain protected from deletion
Cautionary Notes
Ensure that the CSV file format matches the required template to avoid import errors.
Double-check the account name and last four digits for accuracy before submission.
Tips for Efficiency
Use consistent date formats to streamline the import process.
Regularly reconcile bank statements to maintain accurate records.