Calculate/Estimate Tax on an Opportunity

Important: This article is only applicable for estimating tax on an Opportunity if you have installed the Summer ‘22 R3 (3.124) release (or higher). If you have a release installed that is prior to Summer ‘22 R3 (3.124), refer to one of the following articles based upon your tax method:

• Estimate Tax on an Opportunity with Avalara’s AvaTax
• Estimate Tax on an Opportunity with AS Native Tax

Overview 

The Calculate/Estimate Tax wizard provides the ability to calculate and estimate sales taxes on an Opportunity. The wizard includes a Ledger field, which allows you to select a different Ledger that can include different Tax Settings information. Additionally, the wizard includes a Calculate Tax button to perform the calculation based upon one of the following two sales tax methods:

AvaTax Sales Tax - Avalara’s AvaTax integrates with the Opportunity and allows you to perform an automatic sales tax estimation inside of Accounting Seed. Accounting Seed uses an API (Application Programming Interface) callout to communicate with AvaTax and perform a sales tax estimation. Each time the Calc Tax button is clicked, the sales tax is estimated. Columns on the Calculate/Estimate Tax wizard will display on the data grid based upon Header Level Posting (HLP) or Line Level Posting (LLP) being enabled. 

Note: Currently in Accounting Seed, the United States is the only valid supported country for tax calculation on Billings and Opportunities with Avalara AvaTax. If you are not in the US, Accounting Seed Native Tax can be used for tax calculation.

Accounting Seed Native Tax - Using the wizard to estimate tax on an Opportunity with Accounting Seed (AS) Native Tax is different depending upon whether Header Level Posting (HLP) or Line Level Posting (LLP) is enabled. 

Note: In order to calculate taxes on an Opportunity, it must be associated with an Account and have at least one taxable Product that is associated with the Opportunity. 

Do you want to calculate taxes on an Opportunity using:

• AvaTax with Header Level Posting (HLP)
• AvaTax with Line Level Posting (LLP)
• AS Native Tax with Header Level Posting (HLP)
• AS Native Tax with Line Level Posting (LLP)

Return to top

AvaTax with Header Level Posting (HLP)

Use the steps below to calculate/estimate taxes on an Opportunity for AvaTax with HLP enabled. 

1. Navigate to Accounting Home and click the Create Entries tab. Then, under the Revenues menu, click Opportunities. 
2. Select a list view other than the Recently Viewed list view. 
3. Select the Opportunity for which you want to calculate/estimate taxes. 
   Note: You can also click New to create a new Opportunity. Then, continue with the steps below.
4. Click Calc Tax. The Calculate/Estimate Tax screen displays.
   Note: For AvaTax with Header Level Posting (HLP) enabled, columns on the data grid include: Product, Quantity, Price, Subtotal, Estimated Tax Amount, and Estimated Total.
   
   
   Note: Click here to view the above image in full screen. 
   
   
5. (Optional) The Ledger displays based upon the user’s default Ledger (if assigned) or the default Ledger for the org (organization). Click the X to remove the existing Ledger. Then, click the Lookup icon to search for and select a different Ledger.
   Note: If you select a Ledger that has a different tax method, the columns on the data grid will adjust accordingly based upon the tax method for the selected Ledger. 
6. Click Calculate Tax. A message displays to indicate the estimated tax amount will be shown on the Product(s).
7. Refresh the page or click Refresh on the Product related list to save the new tax amount.
   
   
   Note: Click here to view the above image in full screen. 
   

Return to top

AvaTax with Line Level Posting (LLP)

Use the steps below to calculate/estimate taxes on an Opportunity for AvaTax with LLP enabled. 

1. Navigate to Accounting Home and click the Create Entries tab. Then, under the Revenues menu, click Opportunities. 
2. Select a list view other than the Recently Viewed list view. 
3. Select the Opportunity for which you want to calculate/estimate taxes.
   Note: You can also click New to create a new Opportunity. Then, continue with the steps below. 
4. Click Calc Tax. The Calculate/Estimate Tax screen displays.
   Note: For AvaTax with Line Level Posting (LLP) enabled, columns on the data grid include: Avalara Tax Product and Estimated Tax Amount.
   
   
   Note: Click here to view the above image in full screen. 
   
   
5. (Optional) The Ledger displays based upon the user’s default Ledger (if assigned) or the default Ledger for the org (organization). Click the X to remove the existing Ledger. Then, click the Lookup icon to search for and select a different Ledger.
   Note: If you select a Ledger that has a different tax method, the columns on the data grid will adjust accordingly based upon the tax method for the selected Ledger. 
6. Click Calculate Tax. A message displays to indicate the estimated tax amount will be shown on the Product(s).
7. Refresh the page or click Refresh on the Product related list to save the new tax amount.
   
   
   Note: Click here to view the above image in full screen. 
   

Return to top

AS Native Tax with Header Level Posting (HLP)

Use the steps below to calculate/estimate taxes on an Opportunity for AS Native Tax with HLP enabled. 

1. Navigate to Accounting Home and click the Create Entries tab. Then, under the Revenues menu, click Opportunities. 
2. Select a list view other than the Recently Viewed list view. 
3. Select the Opportunity for which you want to calculate/estimate taxes. 
   Note: You can also click New to create a new Opportunity. Then, continue with the steps below.
4. Click Calc Tax. The Calculate/Estimate Tax screen displays.
   Note: For AS Native Tax with Header Level Posting (HLP) enabled, columns on the data grid include: Product, Quantity, Price, Subtotal, Tax Group, Estimated Tax Amount, and Estimated Total.
   
   
   Note: Click here to view the above image in full screen. 
   
5. (Optional) The Ledger displays based upon the user’s default Ledger (if assigned) or the default Ledger for the org (organization). Click the X to remove the existing Ledger. Then, click the Lookup icon to search for and select a different Ledger.
   Note: If you select a Ledger that has a different tax method, the columns on the data grid will adjust accordingly based upon the tax method for the selected Ledger. 
6. (Optional) The Tax Group defaults from the Product. However, you can change it, if necessary. Click the X to remove the existing Tax Group. Then, click the Lookup icon to search for and select a Tax Group.
   Note: Tax Inclusive Tax Groups are not currently supported when calculating tax on an Opportunity. These Tax Groups will be supported in a future release.
7. Click Calculate Tax. A message displays to indicate the estimated tax amount will be shown on the Product(s).
8. Refresh the page or click Refresh on the Product related list to save the new tax amount.
   
   
   Note: Click here to view the above image in full screen. 
   

AS Native Tax with Line Level Posting (LLP)

Use the steps below to calculate/estimate taxes on an Opportunity for AS Native Tax with LLP enabled. 

1. Navigate to Accounting Home and click the Create Entries tab. Then, under the Revenues menu, click Opportunities. 
2. Select a list view other than the Recently Viewed list view. 
3. Select the Opportunity for which you want to calculate/estimate taxes.
   Note: You can also click New to create a new Opportunity. Then, continue with the steps below. 
4.  Click Calc Tax. The Calculate/Estimate Tax screen displays.
   Note: For AS Native Tax with Line Level Posting (LLP) enabled, columns on the data grid include: Tax Rate Name, Product, Subtotal, Tax Rate %, and Estimated Tax Amount.
   
   
   Note: Click here to view the above image in full screen. 
   
5. (Optional) The Ledger displays based upon the user’s default Ledger (if assigned) or the default Ledger for the org (organization). Click the X to remove the existing Ledger. Then, click the Lookup icon to search for and select a different Ledger.
   Note: If you select a Ledger that has a different tax method, the columns on the data grid will adjust accordingly based upon the tax method for the selected Ledger.
6. Click Calculate Tax. A message displays to indicate the estimated tax amount will be shown on the Product(s).
   Refresh the page or click Refresh on the Product related list to save the new tax amount.
   
   
   Note: Click here to view the above image in full screen. 
   

Return to top