All Collections
Tali
Tali - Import Bromcom Transactions
Tali - Import Bromcom Transactions

How to import transactions from third party software in Tali - Bromcom

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

Import files are CSV files which are created externally to Tali. For example, within Bromcom's online payment platform.

To import transactions from Bromcom you will need to manually import CSV files using the steps outlined below.

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

Firstly you need to create a csv file from your Bromcom transactions with the following column headings;

This must be saved as a CSV(comma delimited) file type.

You can import individual transactions to individual pupil names in Tali or use the Bromcom Reports to produce a CSV with just the totals of each account and import to a generic name, for example, 1A Pupil.

Important! ALWAYS USE CHROME OR FIREFOX TO IMPORT

Import your file to the Settlement Bank Account in Tali - Usually the Bromcom Settlement Bank Account

  1. Select Transactions > Import Transactions.

  2. Click Choose file to select the CSV file to import which you have generated from your payment platform software.

  3. Click Upload.

  4. Filter in the middle box for Type of transaction and which Description you wish to import, if you have multiple account codes to import.

  5. By using the Filter button your Pupil Names (or single bulk upload name) should appear against the Transactions.

  6. Select the Tali Account Code to allocate the transactions against.

  7. If you are importing ePayment transactions, the Bromcom Settlement Bank 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 Bromcom Settlement Bank Account to your desired bank account. For more information on how to do this, see the Article, Transfer Between Bank Accounts.

  8. 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.
    If importing individual transactions, 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.

  9. 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, but you can extend the records to display in the bottom right hand corner of the page.

  10. 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 net amount from the 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 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 these amounts.

Go to Bank & Cash > Transfer between Bank Accounts and follow the instructions in the Article, Transfer Between Bank Accounts.

Process your Fees Invoices

You can then process the Bromcom transaction fees invoices which you can find on Bromcom in

Tali>Transactions>Record Expenditure, against the BROMC>Bromcom transaction fees account. The fees are the funds left in your Bromcom Settlement Bank Statement once you have 'Transferred between Bank Accounts'

Fill out the transaction details as follows:

  1. The type must be a Direct Debit

  2. The bank must be the 'Bromcom Settlement' account

  3. The name is usually 'Bromcom'

  4. Select 'Save' and then you can split the fees against the different account codes if you wish to

Did this answer your question?