Use the Trust Import Template to add many trusts to CAS 360 at once. You fill in the template, then send it to BGL Support in a support call, and Support imports it for you.
You can't upload the template yourself
There's no upload button in CAS 360 for a completed Trust Import Template. Support imports it after you send it in a support call.
Download the template
From the Main toolbar, go to Trust.
- Select Add Trust, then select Download Trust Import Template.
- CAS 360 downloads the template as an Excel (.xlsx) file.
Fill in the template
Don't change the template's format
Support can't import a template whose format has been changed. Don't:
- add or remove columns
- delete or rename sheets
- change or remove headings
- change fonts or text colours (enter details as plain black text).
- Open the Instructions sheet and read the rules for each sheet.
- On the Trust sheet, enter one row per trust. You can enter as many trusts as you need.
- On the Trust Beneficiaries, Trust Unitholders and Trust Relationships sheets, enter the people and entities linked to each trust.
- Check the template against the list in What every trust needs, then save it.
What every trust needs
Support returns the template if any of these are missing:
- Mandatory fields: on the Trust sheet, every field marked in red, including the trust formed date and the full trust address (address, suburb, state and postcode). Enter a country only if it isn't the same as the trust's jurisdiction.
- Trust type: use one of the trust types you can select when you add a trust in CAS 360. Other trust types can't be imported.
- A trustee: every trust must have a trustee on the Trust Relationships sheet. A trust without a trustee can't be added.
- Contact type and address: on the Trust Beneficiaries, Trust Unitholders and Trust Relationships sheets, every contact needs a contact Type and an address.
- Company names: if the contact type is Company or Other Entity, enter the name in the First Name field only.
- Unit details: if you use the Trust Unitholders sheet, fill in the unit type information for every unitholder.
Send the template to Support
- In CAS 360, select Log a support call and attach the saved template. See Log a Support Call, Help and Feedback.
- Support checks the template. If anything is missing, Support replies with what to fix. Correct the same file and reply on the same support call.
- When the import is done, Support replies to confirm, and the trusts appear in the Trust list.
FAQs
Usually because the format was changed or mandatory details are missing. Check that the headings, sheets and text formatting are unchanged, that every field marked in red is filled in, that each trust has a supported trust type and a trustee, and that every contact has a type and an address. See What every trust needs.
No. Send it to Support with Log a support call, and Support imports it for you.
Only the trust types you can select when you add a trust in CAS 360. If a trust's type isn't in that list, change it in the template before you send it.
How do I bulk import trusts into CAS 360? Download the Trust Import Template from Trust > Add Trust > Download Trust Import Template, fill in the Trust sheet and the Trust Relationships sheet (every trust needs a trustee), keep the format unchanged, then send the file to BGL Support with Log a support call. Support imports it for you; there is no upload button in CAS 360.
Why can't my trust import spreadsheet be imported? Support can't import it if the format was changed (columns, sheets, headings, fonts or text colours), if mandatory fields marked in red are missing (such as the trust formed date or the trust address, suburb, state and postcode), if a trust has no trustee on the Trust Relationships sheet, if a contact has no type or address, or if the trust type isn't one you can select when adding a trust in CAS 360.
Which trust types are supported in the trust import? Only the trust types you can select when you add a trust in CAS 360.