All Collections
Tali FAQ Articles
How do I import ParentPay transactions manually?
How do I import ParentPay transactions manually?

Import ParentPay transactions manually

Becky Watson avatar
Written by Becky Watson
Updated over a week ago

Generate a file within ParentPay of transactions you want to import

  1. Within ParentPay, go to Reports > Payments.

  2. Choose Service or All.

  3. Select dates.

  4. Click Advanced Options.

  5. Select Payment status: Processed.
    Choosing Processed will ensure only payments that have settled to a bank account will be included in the report.

  6. Select Payment method: ParentPay online or Paypoint.

  7. Open in Excel.

Note: In order not to import duplicate transactions always select at least the day before the current date as the To date. 

Method

Note: Cash and cheque transactions can be created on a separate comma-separated value (CSV) report and brought into Tali if you wish; if you filtered in ParentPay for online only transactions they should not appear - you will need to create a separate file for these and either join the reports together or import them one at a time. Please ensure you change Means to Type on the CSV and re-save in order to upload successfully, cash and cheque transactions.

Note: Delete the top blank line so your file will import and filter out any unwanted transactions before you save your Report.

  • Save the file to your chosen folder making sure to choose the file type CSV.

Note: It is your responsibility to handle personal data in accordance with Data Protection legislation.

  1. Within Tali, select Transactions> Import Transactions.

  2. Browse and choose file.

  3. Upload file.

  4. Filter in the middle box for Type of transaction and which Description you wish to import first.

  5. By using the Filter button your Pupil Names should appear against the Transactions.

  6. Check that the Account Code is correct and you are using the Settlement Account on the right.

  7. Once you are satisfied that everything matches you can click import on the first page and repeat as necessary.

Note: If the name or account does not appear then you may need to create a new name or account via Manage Names or Manage Accounts in Tali and return to this screen to complete the import process. Tali will remember what you haven’t imported when you return to this page

Note: You will not be allowed to import any transactions that you have not matched or if you have not chosen a Settlement Account to place these in, nor will Tali let you import transactions already imported or out of the Period Date range.

Once you have imported your transactions you will be able to transfer the total Transaction amount from your Statement from the Settlement Account to your chosen Bank Account by doing the following:

  1. Select Bank & Cash > Transfer between Bank Accounts.

  2. Select the Settlement Account to Transfer from.

  3. Select the Bank Account to Transfer to.

  4. Enter the Amount to transfer.

  5. Enter the Date of the transfer.

  6. Click Transfer.

You can then use Transactions > Record Expenditure to record the debited fees (invoices on ParentPay) on your bank account statement to balance.

Did this answer your question?