Prefer to watch the video?
Phase 1: Prepare your CSV file
In Tali, go to Transactions > Transaction Import.
Click Download Template CSV.
Add your transactions, placing each transaction on its own row.
Save the completed file in CSV format.
If you have a CSV already, you can skip the above step and move onto Phase 2.
Important information
Required fields: Date, Amount, and Name or Forename and Surname.
Dates: Use DD/MM/YYYY.
Amounts: Use a positive amount for income and a negative amount for expenditure.
Payment methods: A file can contain a mixture of Cash, Cheque, Card, BACS and ePayment transactions.
If you include a Payment Method column, blank or unrecognised methods must be corrected before those rows can be imported. Without this column, every row is treated as an ePayment.
Column headers can use any case and spacing.
The template includes column instructions and example rows. Delete these rows before uploading, or the file will be refused.
Phase 2: Upload your file
Under Upload a file, click Choose file.
Select your completed CSV file.
Click Upload.
Your transactions will appear ready for review.
Phase 3: Choose accounts
Check the accounts under Choose accounts before completing your import.
Default Account: Select an account if you want to apply one to transactions that do not already have an account.
Settlement Account: Check the selected settlement account and change it if required.
Further information
The default account is only used for transactions without an account.
You can assign an individual transaction to an account using its To Account dropdown.
The settlement account is used for imported ePayments, BACS and cheque expenditure. Cheque numbers are allocated from this account.
Phase 4: Review and correct transactions
Part A: Find transactions to review
Check the status counts above the transaction list:
Valid
With warnings
With errors
Without a name chosen
Click a status count to focus on those transactions.
To narrow the list further, use the Transaction type, Description, Account or Name filters, then click Filter.
Read the Message column to understand what needs checking or correcting.
Part B: Correct errors
Edit the relevant fields directly in the transaction row. You can change the date, description, payment type and amount.
Check To Account and select the correct account. Tick Show all accounts if you need a wider selection.
Check To Name and select the correct person. Tick Show all names if required.
If relevant, review any Gift Aid, and correct any related errors.
Check that the transaction’s status updates after making your changes.
Common errors
Missing account: Choose a To Account for the transaction, or select a Default Account above.
Contact not marked for Gift Aid: Untick Gift Aid if it does not apply. If it should apply, check and update the contact’s Gift Aid status before continuing.
No name chosen: Select the correct person from To Name.
Part C: Check warnings
Click With warnings.
Read each warning and check the affected transaction.
Correct the details if needed.
For example, Tali may warn that a date written as 2026-09-15 has been read as 15/09/2026. Confirm that this is the intended date.
Note: Transactions with warnings can still be imported, so review each warning before proceeding.
Removing transactions
Use the bin icon at the end of a row to remove a transaction from the pending import.
Warning: Deleted pending transactions cannot be recovered. You will need to upload them again if you remove them by mistake.
Phase 5: Complete your import
Finish checking the transactions and resolve any remaining errors.
Check the number shown on the Import transaction(s) button. Filters can change this number, so make sure it matches the transactions you intend to import.
Click Import transaction(s).
Look for the success message confirming how many transactions were imported.
Review the Import summary, including the number imported, any remaining transactions, and the totals by payment method and direction.
🎉 Congratulations!
Your transactions have been imported into Tali. To import another CSV file, click Upload another file.