Take the following steps to reconcile online credit card payments from Social Planet into QuickBooks
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. Open QuickBooks and select the file
5. Choose which clearing account you want to import the file into. Suggest to all Houses / Centres to use 2 clearing accounts
1. SP Pin Payments Clearing
2. SP Other Tenders Clearing
6. Choose format of data and map columns in spreadsheet to QBO fields
7. For Description – we can choose the column that best suits what the house want to do.
If there is no need for the client name (Column B) to be added to QBO then we can use another field as below – such as Detail (Column D)
8. The transactions available are listed, tick the radio box to select all or individual transactions
9. Import is completed, and transactions now listed in bank feed
