1. Go to Main Menu select Reports then click on Income
2 Then select from the Type Filter the payment types and choose a date range using the Date Filter
3. Select the CSV button and download the report
4. and format the date column to DD/MM/YYYY to remove the HH:MM
5. Print out your CSV in a readable format, so that you can refer to the entries if needed.
From the Xero Dashboard
1. Select the 3 dots on the top right of your SP Other Tenders Clearing Account
2. Select Import a Statement, the Import Bank Transactions screen will be displayed
3. Select Browse, and locate your CSV file from the folder you have saved it in, select the file and click Open
4. Select Import
5. The Statement Import Options Screen is displayed the first time you import this file. The mapping selections will be saved. The next time you import the same CSV this step is skipped.
6. Make the required changes to map the columns in the CSV file to the Xero fields.
7. Check your Date format is correct. Select Save to start the import.
8. The Import Results will be displayed:
X statement lines were imported, 0 were duplicates
9. Select OK
10. Your Bank account on the dashboard will now display the number of items to be reconciled. Click on Reconcile items box
You are now ready to create the transactions from your bank feed.
11. It is recommended to set up Bank Rules for your course and materials payments to speed up the process.
12. If you need to add the customer’s name into the Description field then you will need to manually add this by selecting Add Details, click on the ‘Description’ field and type in the name.
13. Save your transaction.