Import files are CSV files which are created externally to Tali. For example, within ParentPay, sQuid, SchoolComms, SchoolMoney or ParentMail.
If you are integrating with ParentPay, you can set up ParentPay so that transactions are automatically imported into Tali from ParentPay. For more information, see the Article, Manage ParentPay Integration.
If you are integrating with sQuid, you can set up sQuid so that transactions are automatically imported into Tali from sQuid. For more information, see the Article, Manage sQuid Integration.
To integrate with SchoolComms, SchoolMoney or ParentMail etc, you will need to manually import CSV files using the steps outlined below.
You will need to create a CSV from your online provider that has the following fields to enable the import into Tali;
CSV Column headers;
Forename
Surname
Amount
Date
Description - this is the account to match to in Tali
Type - usually Epayment, however you can import cash and cheques
Optional Column Header;
cost centre - (lowercase) you can include the Account code from Tali (1-7 digits) that matches where you want the funds to import but this is not compulsory as you can map these on the import page.
Note: It is your responsibility to handle personal data in accordance with Data Protection laws
Important! ALWAYS USE CHROME OR FIREFOX TO IMPORT
Select Transactions > Import Transactions.
Click Choose file to select the CSV file to import which you have generated from your payment platform software.
Click Upload. If you have added the cost centre (Account code) to the CSV you can skip to action 7.
Filter in the middle box for Type of transaction and which Description you wish to import, if you have multiple account codes to import.
By using the Filter button your Pupil Names should appear against the Transactions.
Select the Tali Account Code to allocate the transactions against.
If you are importing ePayment transactions, the Settlement Account should be selected automatically for you to allocate the transactions against.
Note: If you don't have a Settlement Account, please contact Pebble Support to create one for you.
If you are importing ePayment transactions, once you have finished importing you will need to transfer the total amount imported from the Settlement Account to your desired bank account. For more information on how to do this, see the Article, Transfer Between Bank Accounts.Work through the list of transactions, selecting/checking and matching To Name from the drop-down list of names, which if you clicked Filter above should be selected automatically.
The closest matching name appears at the top of the drop-down list. If the correct name is not available for you to select, you may need to create a new name, via Administration > Manage Names > Create New Name. For more information, see the Article, Create New Names Manually.You should only import one page at a time, so ensure that you only click Import when you have matched all the transactions to the To Name on each page.
Click Import again to confirm, then once refreshed repeat from the top or Import the next page if you have multiple pages of one Transaction Type.
Continue an import which was interrupted
If you have navigated away from the screen after importing some transactions, don’t click Upload File to import the entire file again, instead you will see any unimported transactions below and you can carry on from where you had left off before.
If you no longer want to import the remaining transactions you can Clear Pending Import to remove these from this screen or 'bin off' selected ones to the right of a transaction.
Transfer total amount from settlement account
Once you have been paid into your bank from the online provider you need to Transfer between Bank Accounts in Bank and Cash to reflect the Gross or Net amounts of money credited to your bank account on the date the money is credited according to your bank statement so you can reconcile.
Go to Bank & Cash > Transfer between Bank Accounts and follow the instructions in the Article, Transfer Between Bank Accounts.