Take the following steps to reconcile online credit card payments from Social Planet into Xero
1. Go to Main Menu select Payments then click on Charges
2 Selected the Completed tab, all the funds that have been transferred from PinPayments into your bank account can be downloaded. Select Download CSV
3. Open the CSV and format the date column to DD/MM/YYYY to remove the HH:MM
4. From the Xero Dashboard, then
5. Select the 3 dots on the top right of your SP Pin Payments Clearing Account
6. Select Import a Statement
7. The Import Bank Transactions screen will be displayed
8. Select Browse, and locate your CSV file from the folder you have saved it in, select the file and click Open
9. Select Import
10. 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.
11. Make the required changes to map the columns in the CSV file to the Xero fields.
12. Check your Date format is correct.
13. Select Save to start the import. The Import Results will be displayed: X statement lines were imported, 0 were duplicates
14. Select OK
15. 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.
TIP - It is recommended to set up bank Rules for your course payments to speed up the process.
16. 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. Save your transaction.