Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

About office locations

Bulk Update Office Location

Starting November 14, 2022, the
Office Locations
 page will have 2 new fields: a mandatory
ADDRESS LINE 1
 field and an optional
ADDRESS LINE 2
 field. To calculate sales tax accurately, your firm will need to update the missing information for each required field that is missing. To provide the missing information, firms can either edit office locations on the Office Locations page or they can use the Bulk Update feature to update office locations in bulk.
Bulk Update uses a template file to update all office locations in a single instance. If your firm has many office locations then bulk updating all office locations using a template file may be more convenient than editing each office location field on the
Office Location
 page.

Bulk Update Office Locations

Follow these to bulk update office locations at your firm:
  1. Select
    FileRoom
    ,
    Admin
    ,
    Account Setup
    , then
    Office Location
    .
  2. Select
    Bulk Update
    .
  3. In the
    Bulk Update
     window, select
    Download existing office locations
     to download the template file.
  4. Open the template file, then select
    Enable Editing
    .
  5. Read the instructions.
  6. Locate your existing office locations.
  7. For each office location in the list, enter any missing required information.
    Column name
    Required?
    Description
    Sample
    Firm ID
    YES
    DO NOT MODIFY
    Office Location
    YES
    DO NOT MODIFY
    Address Line1
    YES
    Enter the exact office location address.
    17890 Sky Park Cir
    Address Line2
    NO
    (Optional) If you need more space to enter the address after
    Address Line 1
    .
    N/A
    Country
    YES
    Enter the country's abbreviations only.
    Example: Enter US instead of United States.
    For foreign addresses, use the references on the next sheet tab to get the correct abbreviations.
    US
    StateCode
    (U.S.)
    YES
    Enter the state's abbreviations only.
    Example: Enter CA instead of California.
    Use the references on the next sheet tab to get the correct abbreviations.
    CA
    City
    YES
    Enter the city's name.
    Irvine
    ZipCode
    (U.S.)
    YES
    If the country is US, then the ZIP Code format needs to be 9 digits:
    The initial 5 digits followed by a hyphen (dash) and another 4 digits (for example, 12345-6789).
    92814-400
    Sample:
    The following changes apply to foreign addresses:
    Column name
    Required?
    Description
    Sample
    Country
    YES
    For foreign addresses, use the references on the next sheet tab to get the correct abbreviations.
    GB
    StateCode
    (Foreign/Non U.S.)
    YES
    Enter the full name instead of abbreviations (for example, enter London instead of LDN)
    London
    ZipCode
    (Foreign/Non U.S.)
    YES
    ZIP Codes for foreign addresses can be alphanumeric values (no max limit),
    Enter
    NA
     if the country has no zip codes.
    SW1E 6SH
  8. Save the template file.
  9. In the
    Bulk Update
     window, select
    Browse
    , the updated template file, then
    Upload
    .
  10. Once the template file is uploaded, you will see the total number of office locations that were successfully updated or failed.

Troubleshoot Bulk Update

Some addresses may not bulk update if the information is misspelled/incorrect. To see which office locations failed to update, select
Download
.
After you have identified the issue, download a new copy of the Bulk Update template file and try again. On a subsequent attempt, you will only need to enter information for office locations that failed previously.

This article applies to:

  • PRODUCT: SurePrep

Related Content

Chat now

error-icon

Triva isn't available right now.

Check out the support page for our phone number and hours

error-close