Adding Transactions from a Spreadsheet
Class allows you to easily copy and paste bank transactions from a spreadsheet via the Browse Bank Statements screen.
Navigate to Fund Level > Transactions > Browse Bank Statements
- Click +Add menu item in the Bank Statements screen to open the Add New Transactions screen
- Click on Paste from Spreadsheet
- Another pop-up screen called Paste Transactions from Spreadsheet will be opened. In this screen you must paste the text from your spreadsheet.
Data in the columns must be in the order Date > Description > Cash Out > Cash In. From here, highlight the entire area of data in your spreadsheet and right click Copy (Ctrl+C) and then go to Class and Paste (Ctrl+V) the data into the screen
- Click Ok in the bottom left to return to the 'Add New Transactions' screen
- Click Save Transactions
This screen does not refer to the bank account's opening figure and the data may seem out of balance however once you click Save Transactions it will reflect correctly in the Bank Statement screen
Next you will see the following screens and your bank account will be updated
These cash transactions will all appear as unmatched. The next step in the reconciliation process would be to match them off.
Refer to Match transactions for further information.