Tali - SchoolMoney

CSV importing from SchoolMoney software

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

The principle of this exercise is broken down into 3 stages:

>Generating a file within SchoolMoney of all the online transactions that you want to Import

>Checking the file so the data is correct

>Importing the file into Tali

It is important to note that this process can be used for importing online ePayment and PayPoint as well as Cash and Cheque Transactions. If you intend to import cash and cheques please remember that if you enter the same transactions into Tali manually via Transactions>Enter Income you will duplicate these transactions when you import them as well.

If you have any Transactions in the csv file that should not be Imported use the guidelines in stage 2 to remove these Transactions, i.e. Dinner Money that doesn’t belong in School Fund.

1. Generating a file within SchoolMoney of all the Transactions that you want to Import

Within a SchoolMoney go to basket>Money Received

Choose>Reports

***NB> Tick the ‘Show transaction breakdown’ box then,

Click>Filter at the bottom

The screen should look like this - choose your dates to import;

Click>OK

Click>Export

Choose>Pebble from the dropdown, which will only appear if you have clicked the ‘Show transaction breakdown’ as above**

Choose>Bank Account if you have more than one

Choose>Export to your pc - this report will save as a csv

2. Checking the file so the data and column headers are correct

Open the csv from the downloaded location if you need to remove any transactions that you do not wish to import. Otherwise, you can import it directly into Tali.

NB - To remove rows of data you can use the filter option or by selecting the row(s) and right-clicking the mouse to select ‘Delete’

If you do not need to delete any transactions you do not need to review the file each time.

Save the csv with a name that reflects the dates you are importing to a location you can find easily for the next step.

3. Importing the file into Tali

Within Tali go to Transactions > Import ePayments.

NB - If you have any transactions that you did not import previously, import these first or 'Clear Pending Import' if they do not need importing.

Upload the CSV file you have just saved by choosing the file and clicking the Upload button.

A list of all the Transactions that you have Imported should appear.

In the Filters section - Choose the Transaction Type - you can leave it as 'All' if you want to import ePayment, cash and cheques

Decription>Choose the first description type to import

Click>Filter

The Names should match left to right and you can then Click>Import.

Then>Confirm Import

NB: if the Account does not appear then you may need to Create a New Account via Manage Accounts in Tali and then return to this screen

Wait for the page to refresh and confirm your imports at the top and then if there is more than one page for this mapping you can click>Import again until you have finished all the pages for this description and account.

NB: You will not be allowed to Import any Transactions that you have not matched or if you have not chosen an Account or Settlement Account to place these against

You can view your Imported online ePayments via Transactions > Search Transactions, choosing the ePayment option under ‘Type’.

Once you have Imported your Transactions you will be able to Transfer the total Transaction Amounts you see on your Bank Statements from the Settlement Account to your chosen Bank Account by doing the following;

Go to > Bank & Cash

> Transfer between Bank Accounts

Transfer from > Settlement Account

Transfer to > Chosen Bank Account

> Enter amount

> Enter date

> Transfer

Cash and cheques that have been imported will need to be 'Paid In' in the normal way, as if they have been entered manually via Transactions>Enter Income. Please pay to bank via Bank and Cash>Pay Income to Bank

You can then ‘Record a Payment’ for any Transaction fees in the normal way via Transactions > Record a Payment.

IMPORTANT: If you have already imported a file and have had to navigate away to another screen within Tali do not re-import the file if you wish to return to the import screen. Click View Pending Import and continue from where you left off.

Did this answer your question?