Add client addresses to invoices
Table of contents
Invoices show your client’s account name and email, plus any account custom fields you turn on in the invoice settings . To print a client’s mailing address on invoices, store it in account custom fields once—after that, every invoice for that client shows it.
Step 1: Create address fields
Create two account custom fields so the address prints on two lines, in mailing format:
| Field name | Example value |
|---|---|
| Street address | 123 Main Street |
| City, State ZIP | Claremore, OK 74017 |
To create the fields:
-
Go to Templates > Custom fields from the left menu bar.
-
On the Account tab, click New field.
-
Enter Street address as the field name, keep the Text field type, then click Save.
-
Repeat for City, State ZIP.
-
Drag Street address above City, State ZIP using the six-dot icon.
Note
On the invoice, each field shows only its value, on a separate line. The values appear in the same order as the fields on the Custom fields page, and new fields are added at the top of that list.You can also create the fields during the import in Step 4 .
Step 2: Show the address on invoices
To turn the fields on for invoices:
-
Go to Settings > Billing from the left menu bar and switch to the Invoices tab.
-
In the Custom fields section, toggle on Street address and City, State ZIP.
Step 3: Prepare an import file
Pick the option that matches where your addresses are today:
- Your clients are in TaxDome, and their addresses are on their contacts: copy the addresses from contacts . This is the most common case—for example, if you imported your clients when you moved to TaxDome.
- Your addresses are in another spreadsheet, such as an export from your previous software: use that spreadsheet .
Copy addresses from contacts
Your contacts already have addresses, but invoices read from accounts. To turn a contact export into an import file:
-
Go to Clients > Contacts from the left menu bar, then click Export contacts. You’ll receive an email with a download link that works for 24 hours. The file includes each contact’s address columns and a Linked account column for every account the contact belongs to— more on contact exports .
-
Add a column named City, State ZIP. In the first cell under the column name, paste this formula:
=D2&", "&E2&" "&F2. The formula assumes city is in column D, state in column E and zip code in column F—change the letters if your file is different. Copy the formula down the whole column, then paste the column back as values. -
Rename the Linked account #1 column to Account name, and make sure the street address column is named Street address.
-
Make sure there’s one row per account:
- An account with several contacts, such as a married couple: keep the row with the address you want on the invoice and delete the others
- A contact linked to several accounts, such as a person and their business: the other accounts are in Linked account #2, #3 and so on. Copy the row once for each of them and put that account’s name in Account name
- A contact with no address: delete the row
-
Delete every column except Account name, Street address and City, State ZIP, then save the file as CSV.
The result looks like this:
| Account name | Street address | City, State ZIP |
|---|---|---|
| Smith Family | 123 Main Street | Claremore, OK 74017 |
Use another spreadsheet
If your addresses are in a file from outside TaxDome, edit it so it has the same three columns: Account name, Street address and City, State ZIP. Each account name must match the account name in TaxDome exactly, including spelling and spacing.
Step 4: Import the addresses
The import matches rows to existing accounts by name and fills in only the fields you map. To import the file:
-
Go to Clients > Accounts from the left menu bar, click Import, then upload your CSV file.
-
On the Map accounts step, select Ignore for Account type so that it isn’t updated.
-
In the Map account fields section, check that Street address and City, State ZIP show Sync field in the Action column and are matched to your custom fields in the TaxDome column. If you skipped Step 1, select Sync field in the Action column, then select New field from the TaxDome drop-down menu, enter the field name, keep the Text field type and click Save.
-
Click Continue through the Settings step.
-
On the Map contacts step, select Ignore in the Action column for every row, then click Continue.
- On the Preview step, click Start import.
Important
On the Map contacts step, TaxDome may match your Street address column to the contact’s Street Address field automatically. Set it to Ignore so that your contacts’ addresses aren’t changed.The Preview step may count the rows as new accounts and contacts. After the import finishes, the summary shows them as updated accounts.
If you created the fields during the import, turn them on for invoices . Find out more about updating account info in bulk .
Verify the address on an invoice
To check that the address prints:
- Open a client account and go to the Info tab. The address appears in the Details & custom fields section.
- Open an invoice for that client or create a draft, then click Preview to see how the address prints.
Add addresses for new clients
The import updates the clients you have today. For clients who join later:
- Onboarding organizer: in your onboarding organizer template, open the settings of each address question, toggle on Sync to CRM, then select Street address or City, State ZIP marked Account field. After a client submits the organizer, sync their answers to the account
- Client imports: include both columns in your import file and map them to the same fields
When a client moves, update the address fields on their account—they’re separate from the address on the contact.
Show other client information on invoices
The same steps work for any other detail you want on invoices, such as a client’s tax ID or business number. For example, firms in Australia may need the client’s ABN on larger invoices.
For a detail about your firm that isn’t one of the Firm info options (address, website, email and phone), such as your GST/HST number in Canada, create an account custom field and import the same value for every account.
Was this article helpful?
Table of contents