The principle of this exercise is broken down into 3 stages:
>Generating the correct file within WisePay of all the online transactions that you want to Import
>Checking the file so the data is correct if necessary
>Importing the file into Tali
It is important to note that this process can be used for importing online ePayment 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 WisePay of all the Transactions that you want to Import
Within WisePay - Click on >Income Manager;
Search by Bank / Order References / Batch Reconciliation
Click on >10. Transactions sorted by bank account and date range
NB: to search transactions up to 23:59 of a given date, you will need to enter the following days’ date to ensure all transactions are captured for the previous day
Click>Generate WisePay transaction report
Click> Export to Tali, found at the bottom of the WisePay Transaction report alongside export to Excel and print version of this page
NB. You may need to change the page results to more than 150 if you have more than this amount of transactions to export
Save as> the CSV to your computer or one drive before accessing Tali in order to import the transaction from the WisePay export.
2. Check the file to ensure the data and columns are in line. If there are any columns out of sync this may mean you have included commas in the title of the WisePay product and consequently, this separates the title into two csv, therefore, throwing the report columns out of sync.
You can check the csv if you wish, open it up in excel to ensure you have all the data you need for the import - this will not be necessary once you do regular exports if you only export what you need to import into Tali.
The 'Cost Centre' code should match your WisePay product id, this will ensure that these transactions are imported to the corresponding Tali Account automatically when you import them.
Open the csv from the downloaded location if you need to remove any transactions that you do not wish to import.
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 or have not added any commas into titles, you do not need to review the file each time.
If you make amends to the file>Re-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 Transactions.
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 at the top;
A list of all the Transactions that you have Imported should appear below.
You should not need to use the Filter section (Transaction type/Description) as your Product ID/Account/Cost Centre in WisePay should map onto this section automatically if your Accounts in Tali match your Product ID/Accounts/Cost Centres in WisePay, however you may need to match the account Account or Settlement Account to place these against if your csv does not match with Tali exactly;
The Names should match left to right automatically 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, or extend the fields to display at the bottom of the screen on the right - from 20>100 for example.
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’.
4. To Reconcile your Bank Statement to your WisePay transactions
Once you have Imported your Transactions you will be able to Transfer the total Transaction Amounts you see on your Bank Statements, as either daily, weekly or fortnightly settled amounts from the Settlement Account to your chosen Bank Account by doing the following so you can reconcile these against your physical bank statement;
Go to > Bank & Cash
> Transfer between Bank Accounts
Transfer from > Settlement Account
Transfer to > Chosen Bank Account
> Enter amount
> Enter date
> Transfer - Repeat this until you have all your settled amounts in Tali ready to reconcile in Bank and Cash>Reconcile a Bank Statement
Cash and cheques that have been imported via your csv will need to be 'Paid In' in the normal way as if they have been entered manually via Transactions>Enter Income.
> Please pay these in, matching your physical paying in slip by using>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 using your WisePay invoices.
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 to continue importing (you might have needed to add an additional cost centre/account code), go back to the import screen and the pending transactions not already imported will be there waiting for you.
Click>Cancel Pending Import to cancel and start again.