In this article, we show you how to use the Tātou Office Bulk Import feature to quickly import repayment transactions. This is also useful for importing bounced direct debits.
Before You Start
Download a copy of our template spreadsheet file to get started. You can open and edit this file using a spreadsheet program such as Microsoft Excel, or Google Sheets.
Make sure to save your spreadsheet as a .xlsx file or .csv file.
Always double-check your import data is accurate and matches the import template exactly. Bulk importing updates a lot of data at once and cannot be undone.
Step 1: Fill in the Details
Enter the details for your equipment in your spreadsheet. Simply create a new row for each item of equipment, with the appropriate details.
A list of the spreadsheet fields and what they mean can be found below:
|
Field Name |
Description |
Example |
|---|---|---|
|
date (required) |
The date the transaction was made. Must be in the format YYYY-MM-DD |
2026-06-04 |
|
amount (required) |
Dollar amount of the transaction, up to 2 decimal places. |
230.50 |
|
name (required) |
Full name of the employee to link the payment to |
Joe Bloggs |
|
staff_id |
Staff ID of the employee to link the payment to. Optional when name provided, otherwise required. |
JB123 |
|
repayment_type (required) |
The cost type this payment was for. Must be one of
|
weekly |
|
payment_method (required) |
Method of payment. Defaults to
|
0.5 |
|
payment_status |
Status of the payment. Defaults to Must be one of:
|
paid |
|
description |
Free text to describe the payment details. |
Internet banking |
If you are using the Bulk Import feature to update existing transactions, make sure that the date, amount and repayment_type fields match the direct debit date, amount and employee match. Note this is only supported for direct_debit transactions.
Step 2: Import your File
To import your file, open Tātou Office, and find your list of equipment by clicking on Admin and then Repayments. Click on the Import button (top right), and then click the Upload button to select your file.
If a row in your spreadsheet contains a transaction that already exists, this row will be skipped. If you are using the Bulk Import feature to update failed direct debits, click the toggle to change the setting from Skip Existing Rows to Update Existing Rows.
Click Check File. The importer will check the data and report back to you if there are any invalid rows. You will then have the option to Import the valid rows, or Cancel to fix the invalid rows and try again.