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.
Open QuickBooks
1. Import “Payment – Income” CSV File
2. Choose which clearing account you want to import the file into:
Suggest to all Centres that you use 2 clearing accounts
- 1. SP Pin Payments Clearing
- 2. SP Other Tenders Clearing
3. Choose format of data. Map columns in spreadsheet to QBO fields
4. For Description – we can choose the column that best suits what the house / centre wants to do. If there is no need for the client or payer name (Column B or H) to be added to QBO then we can use another field as below – such as Details or Booking (Column C or I)
5. The transactions available are listed
5. Import is completed, and transactions now listed in bank feed
6. Allocate transaction as a deposit or Sales Receipt
- Choose a customer name or create a generic name for payments of this activity type
- Select income account (Accounting Code)
- Select GST code
- Select Class (Accounting Code) if using the class feature
Sales Receipt Example:
7. Finished Sales Receipt recorded in QBO
8. How the class (Accounting code in SP) is used in reporting to generate reports on that activity
