Keywords: Customer, Reports, Account Receivable, Sage
Struggling to Keep Your Books in Order? 📊📅
Let us handle the numbers while you focus on growing your business! Get expert bookkeeping support tailored to your needs.
👉 Click Here for a Free Consultation!
Account Receivable
Use the Accounts Receivable application to manage a full Accounts Receivable cycle, including customers, receivables transactions, and generating reports. Use Accounts Receivable to create and send invoices, receive and apply regular and advance payments, apply penalties and adjust accounts, make deposits, and deliver statements. Managers get up-to-the minute reports.
Setup
Before you first use Accounts Receivable, you or your system administrator must subscribe to and configure this application for your company.
- Select the features that you want to appear in the Accounts Receivable menus and pages.
- Assign permissions to users or roles who need to access those features.
For step-by-step instructions on how to configure Accounts Receivable for your company, go to Configure Accounts Receivable.
Manage customers and invoices
Manage customers and customer invoices easily in Accounts Receivable.
- Invoice customers on a recurring basis.
- Print or email customer invoices and statements with custom templates.
- Assign territories to track and categorize sales.
- Import lists of customers, invoices, and adjustments from spreadsheet files.
Process transactions
- Set penalties for past due accounts.
- Receive payments by check, cash, credit card, or funds transfer.
- Receive advance payments anytime and apply them when an invoice is created.
- Make deposits as you normally do.
- Details: As you receive payments, you might accumulate them for later deposit. You can place the funds into an undeposited funds account until you make the deposit. Alternatively, you can make a manual deposit that’s attributed to the customer account but not to a specific invoice. You can also receive non-invoiced payments, such as counter sales, that are not attributed to customers that you track.
- Create custom terms in addition to the default Accounts Receivable terms and aging periods.
- Use manual check entry to write invoices manually, a quick way to enter several invoices per page. You cannot delete nor edit invoices after they are paid, which allows for a high degree of accounting control.
- Retain transaction details forever, providing quick access to customer history. And you can close Accounts Receivable but keep the GL open.
Run reports
- Create and print reports.
- Generate a variety of easily customizable aging and receivables reports and graphs. Reports include the customer list, AR ledger, customer aging reports and graphs, and the sales register. Sales can be analyzed by many criteria, including by territory. Intacct also supplies report data that you can use to calculate commissions.
- Accounts Receivable comes with several standard reports that you can run immediately. See the summary of standard Accounts Receivable reports for details.
Related applications
Accounts Receivable integrates with our online accounting system’s other financial applications for real-time posting of all transactions on a cash or accrual basis. Accounts Receivable synchronizes seamlessly with Order Entry to provide sales staff with sales tools, such as quotes, sales orders, and sales invoices. Order Entry transactions post automatically to both AR and the GL. Additionally, your external applications can be integrated via our XML gateway.
Account Receivable – Customers
You can add any company to which you sell goods or services to your Customers list. Other Sage Intacct applications use the customer information for record-keeping purposes, printing the names and addresses on forms—such as invoices—and for determining the ship-to contact so tax can be computed.
Customer hierarchies
By default, the Customers list uses icons and indentation to show how parent and child customers are related. This hierarchical view is helpful when you have customers that belong to the same parent customer, such as when you are doing business with subsidiaries or divisions of the same company and need to separately track their contact and billing information. For multi-entity shared companies Customers are a master object. Master objects can either be common (meaning, accessible) to all entities or exclusive (private) to a specific entity.
- To add a customer, go to Accounts Receivable > All > Customers and select
- Add
- next to Customers.
View the Customers list
You can find your Customers list on the Accounts Receivable menu. Depending on your company’s subscriptions, you can also find the Customers list in the menus for Order Entry and Projects.
- Go toAccounts Receivable > All > Customers.
From the Customers list, you can add new customers, edit or view existing customers, and import and export customer information. - Do one of the following:
- To add a customer, select Add on the Customers list.
- To edit a customer, select Edit to the left of the customer’s name.
- To view customer details without editing, select View to the left of the customer’s name.
- Other controls on the Customers list let you easily update multiple customers at once. Learn more about importing and exporting customer information.
Add a customer
You can now import information into this area of Sage Intacct with the new import service. The Customer Information page has multiple tabs that contain basic information about the customer, such as company name, address, and phone numbers.
- Go to Accounts Receivable > All > Customers and select
- Add
- next to Customers.
- On the Customer tab, enter basic customer and contact information.
- Name is the name of the company as it will appear on Sage Intacct lists and menus.
- Print as is the name of the main company as it will appear on payments and notices.
When you create a new customer, Intacct automatically creates a related contact record for you. The Print as fields is used in coordination with the Customer ID to create the Suggested contact name. This name is the unique contact ID used throughout Intacct that cannot be edited after creation. It’s also the name that appears in all lists and dropdowns. See Contacts for more detailed information. - To unclutter your customer list by showing only your regularly used customers, select One-time use for customers that you use only once or occasionally. One-time use customers will not appear in the customer list page unless you select Include one-time use at the top of the page.
One-time use customers are included in subledger reports such as the AR aging report when you set the report filters to include them. These customers are not included in Financial reports or General Ledger standard reports. - Duplicate information is shared between the Customer tab and the Contact List tab. If you change information in the Customer tab, the changes occur in the Contact List tab, and vice versa. (Provided you have not selected Exclude company contact list).
- For companies that use a VAT or GST tax solution, enter tax identification information to calculate taxes.
- Select the Additional Information tab and enter accounting details for this customer:
- If this customer account is a subsidiary of another customer, select Parent, and then select the name of the parent company.
- To use an alternative AR account to override the default GL AR account, select it from the AR account. Intacct populates the AR override account that you select here to every invoice or adjustment transaction that includes this customer. See Override the GL account in AR transactions for more information.
- In Accounts Receivable, this feature applies to invoices and adjustments only. It doesn’t apply to recurring invoices, manual deposits, or advances.To use a GL group and GL account other than the defaults, enter them in the GL group and GL account fields respectively.
- (German companies or entities only) Enter a DATEV ID to be used for the DATEV export.
- To add any relevant documents, select or create them in the Attachment field. Learn more about who can add attachments.
You can drag and drop your files to add an attachment. To attach a document to multiple journal entries, see Bulk processing. - To prevent anyone from entering bills for this customer, select On hold.
- To define a credit limit for this customer, in the Credit limit, enter the amount of credit you are willing to extend to the customer.
- Select the Contact List tab, and then enter categories and contacts associated with this customer along with customer contacts for billing and shipping.
- Optionally set up customer payment methods.
If you have Payment Services enabled and an agreement with either PayPal or Authorize.Net, use the Payment Methods tab to automate payments from the customer. These services use credit card charges or ACH debit from the customer’s back account. The customer must provide their credit card or bank information. Refer to Configure Payment Services for details.
Contacts must exist in Intacct before you can select them for customer functions.
Edit a customer
You can edit customers even if they have been used in a transaction. However, transactions that have already been created contain the information for the customer at the time it was posted. Posted transactions will not pick up the changes to the customer, only new transactions and records will refer to the updated information.
- Go to Accounts Receivable > All > Customers.
- Find the customer that you want to edit.
- Select Edit next to the Customer ID.
- Can’t find the customer you want to edit? Be sure to select the Include one-time use and Include inactive checkboxes above the list if you want to make changes to these sorts of customers.Make your changes.
See Field descriptions: Customers for more information about the different fields. - Select Save.
Edit customer contact information in a transaction
If you notice that the customer contact information is incorrect on a transaction, or perhaps the transaction uses the wrong contact entirely, then you can edit or change the contact from the transaction itself.
This is simple to do if you notice the error during the creation of the transaction, but keep in mind that editing customer contact information only affects the current transaction being created and future transactions.
If you already saved and posted the transaction, editing or changing a contact becomes more complicated. Depending on the type of transaction and the state of the transaction, you may have to reverse the transaction before you can make any changes to the transaction record, including changes to the associated contact record that apply to the existing transaction.
Delete or deactivate a customer
If you have not used a customer for any transactions in your company, you can select Delete in the Customers list to remove the customer. Customers that are referenced in a transaction or a record can’t be deleted.
However, you can make that customer inactive, effectively removing the customer from dropdown menus and lists throughout the company. After you’ve deactivated a customer, you can still access the customer’s record by selecting Include inactive at the top of the Customers list.
- Go to Accounts Receivable > All > Customers.
- Find the customer that you want to deactivate.
- Don’t see Include inactive on your page?
- The most common reason that you do not see that this feature is that you’re using a custom view.
When you select a custom view, some options are hidden. Depending on the page you’re on, the Include inactive, Include one-time use, Include private, and Display hierarchy options are not visible. For example, if you’re viewing from a custom view, the Financial Reports list will not provide the Include inactive option.
To see the options again, switch back to View All. See Custom views for more information. - Select Edit to the left of the customer ID.
- On the Customer tab, change the Status for the customer to Inactive.
- Select Save.
You can follow these steps to change a customer back to Active later on.
Remove a duplicate customer
You might have created two customer records for the same customer. While you can’t merge these records, you can deactivate one record and keep the other record active. Wait until all invoices have been paid for the duplicate customer, then deactivate the record. Past transactions are still tied to the inactive customer record. You’ll need to create reports and view the Customer Aging report for both customers (the one you kept and the duplicate) as you can’t merge this data.
- Go to Accounts Receivable > All > Customers.
- Find the duplicate customer.
- Select Edit next to the Customer ID.
- On the Customer tab, select Inactive for Status.
- Select Save.
Add a customer card account
Use the Customer Credit Card Account Information page to:
- Add a new customer credit card account.
- Change or view the information for an existing one.
This service will be retired in November of 2025 and is no longer available to new subscribers.
For Multi-entity shared users: This object is a master object, which can be common to all entities, or exclusive to a specific entity. In shared multi-entity companies with multiple base currencies, you can create credit card accounts at the entity level only. To view credit cards at the top level, select Include private in the Credit Card Accounts list. Enter all credit card transactions at the entity level. When you create a credit card, a location is required. Consequently, in credit card transactions, Intacct knows to use the base currency for the entity associated with that location.
Add a customer credit card account
- Go to Accounts Receivable > Setup > Accounts and select
- Add
- next to Card.
- On the Customer Card Account Information page, enter basic information for a new account.
- Select Save.
To save this record and create another one, select Save and new. Another blank Information page displays for you to enter the name and description of the next record you want to add.
Field descriptions
The following table describes each item in the Customer Credit Card Account Information page.


Edit, view a customer credit card
Use the Customer Credit Card Account Information page to change or view the information for an existing customer credit card. This service will be retired in November of 2025 and is no longer available to new subscribers.
For Multi-entity shared users: This object is a master object, which can be common to all entities, or exclusive to a specific entity. In shared multi-entity companies with multiple base currencies, you can create credit card accounts at the entity level only. To view credit cards at the top level, select Include private in the Credit Card Accounts list. Enter all credit card transactions at the entity level. When you create a credit card, a location is required. Consequently, in credit card transactions, Intacct knows to use the base currency for the entity associated with that location.
View a customer credit card account
You can view details about an account from the Customer Accounts list.
- Go to Accounts Receivable > All or Setup > Accounts > Card.
Only a few of the specific details for a record can be shown in the list columns.
Select View. The record details appear. If the record is complex, the details are categorized into sections and tabs.
Edit a customer credit card account
- Go to Accounts Receivable > Setup > Accounts > Card.
- On the Customer card accounts list, find the account you want to edit, and select Edit.
- Enter changes as needed.
When editing an existing card account, several fields are displayed as read-only. These include Card number, Card type, and Customer ID. - When you finish entering or editing information, select Save to save the account and display the list of accounts.
To save this record and create another one, select Save and new. Another blank Information page displays for you to enter the name and description of the next record you want to add.
Delete or inactivate a customer credit card
You cannot delete credit cards that have been used in transactions. However, you can make them inactive.
To view the Customer card accounts list, go to Accounts Receivable > Setup > Accounts > Card.
This service will be retired in November of 2025 and is no longer available to new subscribers.
Inactivate a customer card account
Inactive credit cards do not appear in the Customer Card Accounts list.
- Go to Accounts Receivable > All/Setup> Accounts > Card.
- Select Edit beside the card that you want to inactivate.
- Change the Status to Inactive.
- Select Save.
Delete a customer card account
If a customer card account hasn’t been used in any transactions, you can delete the record of the credit card account.
- Find the record that you want to remove and select Delete.
Depending on your user preferences, the system may prompt you to confirm the deletion.
Import and export customer information
You can now import information into this area of Sage Intacct with the new import service. Using the import and export features on the Sage Intacct Customers list, you can easily:
- Export your Customers list in a standard file format (CSV, Excel, Word, PDF) so that you can print or use the information in another application.
- Quickly update your Customers list by exporting selected data, making changes, and then importing your changes.
To display the Customers list, go to the Accounts Receivable, Projects, or Order Entry and select Customers.
Use CSV import to update customer information
Update information for multiple customers at once by exporting customer data in CSV for import format, editing the resulting spreadsheet, and then importing your changes.
A CSV import works well for:
- Updating information for multiple customers at once: Using a CSV import, you can update selected data for multiple customers. For example, you can export the Customers list with the email address field included. Then, edit the email addresses in a spreadsheet and import your changes.
- Adding new customers to your existing Customers list: Using a CSV import, you quickly add new customers without having to create the customers one at a time. Any spreadsheet row that contains a unique customer ID will be added as a new customer record, provided that you’ve included all required information.
Do not overwrite existing data with blank data, unless you intend to remove that data from your Customers list. For example, if you export the email address field and then clear the data in the email address column of your spreadsheet. When you import the file, existing customer email addresses will be deleted.
Export the Customers list
Choose what to export from the Customers list, including the fields of data, display and sort order, and the list of customers. To control what gets exported, you can use Manage views to create a custom view of the Customers list. The view allows you to change the list to view just the data you want to see.
- Find the Manage views option at the top of the Customer list, and select Create new view.
- In Step 1 of the Create New View wizard, select the columns of data you want to include.
You can choose from customer name, ID, or type, and use location-based information about a customer. - Make other changes as needed. With the wizard you can:
- Choose the order in which the columns appear.
- Filter the list of customers. For example, filtering for customers who are located in a specific state or territory or customers whose preferred payment method is ACH.
- Choose the sort order for columns; for example, sorting customers by last name.
- Select Export and select the format you want for the exported file.
Update the CSV file
The maximum number of customer records you can import in one CSV file is 25000 records.
- Open the CSV file in a spreadsheet application.
- Update the spreadsheet.
- You can update information for existing customers. For example, you might correct customer addresses or add email addresses for selected customers.
- You can also add new customers. If the customer ID that you specify doesn’t already exist in Intacct, a new customer record will be created.
- When you’re finished, save the spreadsheet in .CSV format.
Import your changes
For more information about importing customer information, see Import new customer information.
- Select the Import button at the top right of the Customers list.
- Find the CSV file that you want to import.
- Be sure to specify the email address where results are sent.
If any records fail to import, you’ll be notified by email. - Select other options as needed.
The maximum number of customer records you can import in one CSV file is 25000 records.

Guidelines for updating customers
The important thing to remember when updating customer records through CSV import is that the changes you make in the spreadsheet will affect your customer records.
- If you update spreadsheet data for a customer, the information you specify will overwrite the data in the existing customer record.
- If you remove data from the spreadsheet, the corresponding information will be removed from the customer record.
Do not overwrite existing data with blank data, unless you intend to remove that data from your Customers list. For example, if you export the email address field and then clear the data in the email address column of your spreadsheet. When you import the file, existing customer email addresses will be deleted.
Recommended precautions:
- Make a backup of your customer information before you make changes. Save a copy of the CSV for Import spreadsheet so that you have a record of the Customers list before the update process.
- Before making large-scale changes, test the update process. Try creating a few test customers and then update just those customer records.
Tips for adding new customers
When you’re adding new customers, you must include at least the following columns:
- Customer ID: Be sure to enter a unique customer ID that hasn’t already been used in Intacct.
- Customer name: Enter the customer’s name.
- Print as: Enter the customer’s name as it appears on payments and reports.
- Required custom fields: If you’ve created any custom fields that are required, you must also include these columns.
Recommended fields for new customers
It’s also recommended that you include the following columns:
- Customer account number
- Contact information
- First name
- Last name
- Phone
- URL
- Address
- City
- State or territory
- ZIP or post code
- Country
Create a customer hierarchy
Some lists, such as customers, vendors, and projects, can display a hierarchical structure of parent-child relationships using icons and indentations.
For example, you might want to view a list that displays customers as subsidiaries of the same parent company. Or, you might purchase goods or services from subsidiaries or divisions of the same company and need to track their contact and payment information separately. Or, you might want to see an inventory item, including all its subcomponents, at a glance.
Parent items can have an unlimited number of child items, allowing you to view and act on the items as needed. You can still sort and search for items as you would in any view. If the parent isn’t visible because of permission restrictions, or if you filtered the list in a way that the parent isn’t visible, Intacct still shows that the child as indented and colored, to indicate that it is a child in a relationship.
To toggle between a flat and hierarchical view of a list:
The default for a list that has hierarchical items is to display the hierarchical view.
- To switch to a flat view, clear the Display hierarchy checkbox above the list. When the checkbox is clear, all items are displayed by their unique ID, whether or not they have relationships to other items. To return to the hierarchical view, select Display hierarchy.
Don’t see Display hierarchy on your page?
- The most common reason that you do not see that this feature is that you’re using a custom view.
When you select a custom view, some options are hidden. Depending on the page you’re on, the Include inactive, Include one-time use, Include private, and Display hierarchy options are not visible. For example, if you’re viewing from a custom view, the Financial Reports list will not provide the Include inactive option.
To see the options again, switch back to View All. See Custom views for more information.
Make a customer a child of another customer:
You can organize your customers hierarchically by selecting the parent for each customer in the customer page.
- Go to Accounts Receivable > All > Customers.
- Find the customer that you want to make a child customer.
- Select Edit to the left of the customer ID.
- On the Additional Information tab, select the parent customer from the Parent dropdown field.
- Select Save.
Set up customers in a multi-entity shared company
In multi-entity shared companies, the customers that you see in the Customers list depend on whether you’re at the top level or an entity. In this type of company structure, customers can be shared among all entities, restricted to the top level, or restricted to particular entities.
Set up customers at the top level vs. at the entity level
Often, it’s simplest to set up a shared customer list at the top level and then specify which entities can view each customer. You also have the option to set up customers directly at the entity level. In this case, when you display the Customers list from the top level, you’ll see only customers that were created at the top level. To see items created in the entities, select the Include private checkbox.
Don’t see Include private on your page?
The most common reason that you do not see that this feature is that you’re using a custom view.
When you select a custom view, some options are hidden. Depending on the page you’re on, the Include inactive, Include one-time use, Include private, and Display hierarchy options are not visible. For example, if you’re viewing from a custom view, the Financial Reports list will not provide the Include inactive option.
To see the options again, switch back to View All. See Custom views for more information.
Restrict visibility for customers
In a multi-entity shared company, use the Restrictions tab to select which entities can view each customer. Choose from the following options:
- Unrestricted customer: Visible to all entities at all levels.
- Restricted to top level only: Visible only to the top level entity.
- Restricted customer: Enables Location/Location group and Department/department group selection boxes. Locations or departments added to the right-hand box will be able to view this customer. Move a location or department by selecting it in the left-hand box then selecting the right-facing arrow to move it to the right-hand box. Conversely, use the left-facing arrow to remove locations or departments.
When setting up location groups or department groups, keep in mind that restrictions can be based on groups that contain specific locations or departments, but can’t be based on groups that filter dynamically based on the value of certain fields (such as locations where the status equals “Active”). Location groups and department groups that contain dynamic filtering will not appear on the Restrictions tab for you to select.
Multi-entity customer restriction.
The Customer Visibility page enables you to view, edit, mass update, and manage multi-entity restrictions for customers. Make sure that customer restrictions are enabled in Multi-Entity Management configuration in order to use restrictions. In addition, to updating customer restrictions individually, you can use the import and export features on the Customer Visibility page too easily:
- Export your customer restrictions list in a standard file format (CSV, Excel, Word, PDF) so that you can print or use the information in another application.
- Quickly update your customer restrictions list by exporting selected data, making changes, and then importing your changes.
To display the Customer Visibility list, go to the Accounts Receivable > Setup > Customer Visibility.
Export customer restrictions
You can export anything that you can display in the Customer Visibility list. This option allows you to control what gets exported, including the columns of data, display and sort order, and the list of customer restrictions assigned.
Create a list view that includes the data you want to export
To control what gets exported, you can create a custom view of the Customer Visibility list that includes just the data you want to see.
- Find the Options dropdown at the top of the Customer Visibility list, and select Create new view.
- On Step 1 of the Create New View wizard, select the columns of data you want to include.
You can choose from standard customer fields (such as name and ID), and any custom fields that you’ve created for your company. - Make other changes as needed.
Using the wizard, you can: - Choose the order in which the columns appear.
- Filter the list of customer restrictions, such as filtering for customers who are unrestricted, or customers who can be viewed by top level only.
- Choose the sort order for columns; for example, sorting customers by ID or Visibility.
Export the customer restrictions list
- If you have not already done so, choose the list view that includes the data you want to export.
- At the top of the Customer Visibility list, select the All dropdown and then choose the name of the view that you previously created.
- If you do not select a view before exporting the Customer Visibility list, your export file will include the current list of customers and columns.
- Export the list by choosing an export format from the Export dropdown at the top of the Customer Visibility list.
Changes to Microsoft security can cause issues when exporting to Excel. See Can’t export a report to Excel for details.
Edit customer restrictions individually
If you need to update or add restrictions for one or two customers, the quickest way is to edit the customer record in the Customer Visibility page.
- Go to Accounts Receivable > Setup > Customers > Visibility.
- Find the customer you want to update.
- Select Edit next to the Customer ID.
This opens the customer record on the Restrictions tab. - In the Visibility section, select one of the following to specify who can view and post transactions to this customer:
- Unrestricted customer: The top level and all entities within the multi-entity structure.
- Restricted to top level only: Only the top level of the multi-entity structure.
- Restricted customer: Only the chosen locations, location groups, departments, or department groups within the multi-entity structure.
- When you restrict a vendor to the top level, their transactions appear on the aging report only if the report is not filtered by location.
- If you selected Restricted customer, select the restrictions as follows:
- Select inside the first empty row under either Restricted locations or Restricted departments, as applies to the restriction you want to set.
- Select a location or department from the dropdown list.
- To add another restriction, select inside the next empty row and select a restriction from the dropdown list.
If you select an entity as the location, you need to select the locations associated with that entity, also. - Select Save.
Use CSV import to mass update customer restrictions
Update restrictions for multiple customers at once by exporting customer data in CSV for import format, editing the resulting spreadsheet, then importing your changes. Do not overwrite existing data with blank data, unless you intend to remove that data from your Customer Visibility list. For example, if you export a number of customer restrictions that include a location, and then clear the data in the associated location column of your spreadsheet. When you import the file, those existing location restrictions will be deleted.
Export the customers restrictions list in “CSV for Import” format
Before you start, create a custom view of your Customer Visibility list that includes the customers and columns you want to update. That way, when you export the Customers list, you’ll have a spreadsheet that’s tailored to the information you want to change.
- If you have not already done so, select the list view that includes the data you want to export.
- At the top of the Customers list, select the All dropdown menu and then choose the name of the view that you previously created.
- If you do not select a view before exporting the Customers list, your export file will include the current list of customers and columns.
- If the view contains fields that cannot be updated through the import process, those fields will not be included in the export file.
- Export the Customers list in CSV for import format.
Intacct exports the data to a predefined .csv import template, which you can then open and update.
Update the .csv template file
- Open the .csv file in a spreadsheet application.
- Update the spreadsheet.
- You can update restrictions for existing customers as follows:
- Unrestricted customer: Including the top level, all entities within the multi-entity structure can view this customer and post transactions to it.
- Restricted to top level only: Only the top level of the multi-entity structure can view this customer and post transactions to it.
- Restricted customer: Only the chosen locations, location groups, departments, or department groups within the multi-entity structure can view this customer and post transactions to it.
- You can change which locations or departments within the multi-entity structure can view selected customers.
- You can add as many columns for locations and departments as needed.
- When you’re finished, save the spreadsheet in .csv format.
Import your changes
- Select Import at the top right of the Customers list.
- Find the CSV file that you want to import.
- Be sure to specify the email address where results are sent. If any records fail to import, you’ll be notified by email.
- Select other options as needed.
Guidelines for updating customer restrictions
Remember that when updating customer restriction records through CSV import, the changes you make will affect your customer restriction records.
- If you update spreadsheet data for a customer restriction, the information you specify will overwrite the data in the existing customer restriction record.
- If you remove data from the spreadsheet, the corresponding information will be removed from the customer restriction record.
Do not overwrite existing data with blank data, unless you intend to remove that data from your Customer Visibility list. For example, if you export a number of customer restrictions that include a location, then clear the data in the location column of your spreadsheet. When you import the file, those existing location restrictions will be deleted.
Recommended precautions:
- Make a backup of your customer restriction information before you make changes. Save a copy of the CSV for import spreadsheet so that you have a record of the Customer Visibility list before you update it.
- Before making large-scale changes, test the update process. Try changing a few test customer restrictions and then update just those customer records.
Required fields for new customer restrictions
When you’re adding new customers, at least the following columns are required:
- Customer ID: The identifier field for all other values
- Visibility: The type of restriction: Unrestricted, Root only, or Restricted
- Required custom fields: If you’ve created any custom fields that are required, you must also include these columns.
Check out our Free Additional Articles

