--- title: Tracking Use Tax in Sage 300 description: Tracking Use Tax in Sage 300 (Accpac). What is use tax and what are the methods of tracking in Sage 300? Examples of options with screenshots on setting up use tax tracking in Sage 300 is provided. image: https://www.equationtech.us/hubfs/blog_images/Sales%20Use%20Tax/Picture1.jpg --- [866.436.3530](tel:+8664363530) | [** Customer Portal Login](https://na.myconnectwise.net/support/index.htm?Company=equationtech) [Speak With an Expert](https://www.equationtech.us/speak-with-an-expert) [![Equation Technologies - Sage Business Partner | San Diego](https://www.equationtech.us/hs-fs/hubfs/Redesign_Images/logo.png?width=230&name=logo.png "Equation Technologies - Sage Business Partner | San Diego")](https://www.equationtech.us/) - [Sage Services](https://www.equationtech.us/sage-services) - Products We Support - [Sage 300](https://www.equationtech.us/sage-services/sage-300-cloud) - [Sage Intacct](https://www.equationtech.us/sage-services/sage-intacct/) - [Sage CRM](https://www.equationtech.us/sage-services/sage-crm) - [Sage Payroll](https://www.equationtech.us/sage-services/sage-payroll) - [Sage HCM](https://www.equationtech.us/sage-services/sage-hcm-software) - [Sage FAS](https://www.equationtech.us/sage-services/fixed-assets) - [Sage Intelligence](https://www.equationtech.us/sage-services/sage-intelligence) - [Sage Enterprise Intelligence](https://www.equationtech.us/sage-services/sage-enterprise) - Services We Offer - [Software Selection](https://www.equationtech.us/software-solution-selection) - [Implementation](https://www.equationtech.us/sage-services/erp-implementation) - [Customization](https://www.equationtech.us/sage-services/customization) - [Support](https://www.equationtech.us/sage-services/support) - [Training](https://www.equationtech.us/sage-services/sage-training) - [Sage Cloud](https://www.equationtech.us/sage-services/hosting) - [Upgrades](https://www.equationtech.us/sage-services/upgrades) - [Extend Sage](https://www.equationtech.us/sage-integrations) - [Magento eCommerce](https://www.equationtech.us/sage-integrations#magento) - [ADP](https://www.equationtech.us/en/sage-300-sage-intacct-payroll-powered-by-adp) - [Aloha POS](https://www.equationtech.us/sage-integrations#aloha) - [Salesforce](https://www.equationtech.us/sage-integrations#salesforce) - [TimeClockPlus](https://www.equationtech.us/timeclockplus) - [Other Solutions](https://www.equationtech.us/other-solutions) - Industries - [Distribution](https://www.equationtech.us/distribution-management-software-solution) - [Education Nonprofit](https://www.equationtech.us/education-nonprofit-accounting-software) - [Financial Services](https://www.equationtech.us/financial-services-software) - [Franchise](https://www.equationtech.us/franchise-management-software) - [Healthcare](https://www.equationtech.us/healthcare-finance-software) - [Hospitality](https://www.equationtech.us/hotel-restaurant-accounting-software-solutions) - [Metal Processors & Distributors](https://www.equationtech.us/erp-for-metal-industry-businesses) - [Nonprofit](https://www.equationtech.us/nonprofit-accounting-software) - [Professional Services](https://www.equationtech.us/professional-services-software) - [SaaS & Technology](https://www.equationtech.us/erp-software-for-technology) - [Resources](https://www.equationtech.us/sage-software-resource-library) - [Technology Blog](https://www.equationtech.us/technology-blog) - [Training](https://www.equationtech.us/sage-services/sage-training) - [Online Videos](https://www.equationtech.us/sage-300-erp-accpac-tutorial) - [Case Studies](https://www.equationtech.us/case-studies) - [About](https://www.equationtech.us/about-us) - [Meet The Team](https://www.equationtech.us/management-team) - [Partners](https://www.equationtech.us/partners) - [Careers](https://www.equationtech.us/careers) - [Contact](https://www.equationtech.us/contact) This is a search field with an auto-suggest feature attached. - There are no suggestions because the search field is empty. # Tracking Use Tax in Sage 300 ![technology blog](https://www.equationtech.us/hubfs/blog_images/Sales%20Use%20Tax/Picture1.jpg) **twitter **linkedin **facebook **What is use tax?** When a company purchases goods and or services from an out of state company and the selling company doesn't collect sales tax, then use tax could be due to the purchasing company’s state and/or local taxing authority.[[i]](https://www.equationtech.us/sage-accpac-blog/tracking-use-tax-in-sage-300#_edn1) If the purchase would have been taxed had it been made in their local jurisdiction, then use tax is due. Additional explanation of use tax can be found [here](https://www1.avalara.com/us/en/learn/whitepapers/whats-the-use-of-use-tax.html). # **Methods of Tracking** There are several approaches that Equation recommends to track use tax in Sage 300. # **Create a tax authority and group for use tax** The first option to track use tax in Sage 300 is to set up a separate tax authority and tax group specifically for use tax. This will allow you to create payable invoices utilizing this tax group. Thus, once the invoices are posted, you can use the standard tax reports to see the purchases made using this tax group. It is important to note in this methodology the tax rate is set to 0.00% so that the invoices payables are entered in the amount that are presented by the vendors. The implication of this is that the tax report will show the amount of the invoice but does not commit the potential tax liability to the financial statements. The benefit of this approach is that vendors from whom you routinely purchase goods and/or services where use tax needs to be tracked, their tax group can be set to your use tax group and then all their transactions will automatically be tracked. **Example** The below example is based upon the SAMINC database. Here we create a Tax Authority called USETAX, a single set of Tax Classes, set the Tax Rates to 0% and created a Tax Group also called USETAX. ![Picture1.jpg](https://www.equationtech.us/hs-fs/hubfs/blog_images/Sales%20Use%20Tax/Picture1.jpg?width=640&name=Picture1.jpg) Next, we set a vendor up to always track use tax. ![Picture2.jpg](https://www.equationtech.us/hs-fs/hubfs/blog_images/Sales%20Use%20Tax/Picture2.jpg?width=640&name=Picture2.jpg) When an invoice is generated in AP for this vendor, their tax group now defaults to the use tax group. ![Picture3.jpg](https://www.equationtech.us/hs-fs/hubfs/blog_images/Sales%20Use%20Tax/Picture3.jpg?width=640&name=Picture3.jpg) Similarly, when a purchase order is created, received, and invoiced, it will default to the same tax group. ![Picture4.jpg](https://www.equationtech.us/hs-fs/hubfs/blog_images/Sales%20Use%20Tax/Picture4.jpg?width=640&name=Picture4.jpg) Finally, once the transactions are posted, the Tax Tracking report can be run. ![Picture5.jpg](https://www.equationtech.us/hs-fs/hubfs/blog_images/Sales%20Use%20Tax/Picture5.jpg?width=640&name=Picture5.jpg)  # **Create a tax authority and group for use tax** A second methodology for tracking use tax is to use an optional field. In this methodology, an optional field is configured on an AP Invoice Detail line level. If the optional field is also set up at the General Ledger level, then the optional field can flow to the transaction details and custom reports can be created to report back on this information. When the optional field is set at the detail level, then the invoice can be spilt so that one detail line can be tracked for use tax and another is not tracked. Thus, this option works well when you have a limited number of transactions which need to be track and/or you have vendors where only part of their invoice needs to have use tax tracked on it.** ** **Example** Configure an optional field in Common Services as a Boolean field (Yes/No), then set the optional field up in AP Set Up. If so desired, the optional field at the detail level can be set to Auto Insert (and appear on all line items) and have its default value set to no. Additionally, the optional field could be set up on the vendor and have the value on the invoice details source from the vendor master setup.  ![Picture6.jpg](https://www.equationtech.us/hs-fs/hubfs/blog_images/Sales%20Use%20Tax/Picture6.jpg?width=640&name=Picture6.jpg) On a specific line item, the use tax field can be set. ![Picture7.jpg](https://www.equationtech.us/hs-fs/hubfs/blog_images/Sales%20Use%20Tax/Picture7.jpg?width=640&name=Picture7.jpg)  Once posted, if the optional field is set up in the GL, then you can see the use tax tracking in the GL. ![Picture8.jpg](https://www.equationtech.us/hs-fs/hubfs/blog_images/Sales%20Use%20Tax/Picture8.jpg?width=640&name=Picture8.jpg) **Automate use tax processes** There are options for automating sales and use tax processes that are integrated with Sage 300. The automation tools ensure your tax rates and codes are always up to date as well as provides the tools to generate and file accurate and timely returns.  For more information on how to automate use tax processes, please [contact us](mailto:info@equationtech.us?subject=Automate%20Sales%20Use%20Tax%20Inquiry). **Got Questions?** Does this article spark additional questions about your unique situation? Give us a call at 866.436.3530 and one of our experienced consultants would be happy to conduct a business review to help you understand how to best implement use tax tracking. --- [[i]](https://www.equationtech.us/sage-accpac-blog/tracking-use-tax-in-sage-300#_ednref1) Equation Technologies, Inc. presents this blog post as illustrations of options on how to track use tax within the Sage 300 software and does not provide tax advice on taxation policy. Please consult your trusted tax advisor for specific details on taxation regulations and compliance applicable to your organization. ### Related Articles ##### [Sage 300 & Windows 10 End of Life: What You Need to Know](https://www.equationtech.us/sage-accpac-blog/sage-300-windows-10-end-of-life-what-you-need-to-know) There’s been a lot of conversation lately around Windows 10 end of life and what that means for... ##### [From Start-Up to Quarter Billion – How Sage 300 Scaled Success](https://www.equationtech.us/sage-accpac-blog/from-start-up-to-quarter-billion-how-sage-300-scaled-success) We also have a [video version](https://drive.google.com/file/d/1ssdM9iHt6Wz86A-VDvAER03NdXkAodg9/view?usp=sharing) of this article, where you can hear directly from one of our ERP... ##### [How to Simplify Payroll and Job Costing with Sage 300](https://www.equationtech.us/sage-accpac-blog/how-to-simplify-payroll-and-job-costing-with-sage-300) Getting payroll to play nice with your job costing system is like fitting a square peg into a round... ## Need Help Now? [![Request a Call](https://hubspot-no-cache-na2-prod.s3.amazonaws.com/cta/default/41683/0d27fa16-1614-41b4-9caf-f9597d262c41.png)](https://hubspot-cta-redirect-na2-prod.s3.amazonaws.com/cta/redirect/41683/0d27fa16-1614-41b4-9caf-f9597d262c41) Products We Support - [Sage 300](https://www.equationtech.us/sage-services/sage-300) - [Sage Intacct](https://www.equationtech.us/sage-services/sage-intacct/) - [Sage CRM](https://www.equationtech.us/sage-services/sage-crm) - [Sage HRMS](https://www.equationtech.us/sage-services/sage-hrms) - [Sage FAS](https://www.equationtech.us/sage-services/fixed-assets) - [Sage Intelligence](https://www.equationtech.us/sage-services/sage-intelligence) - [Sage Enterprise Intelligence](https://www.equationtech.us/sage-services/sage-enterprise) - [Sage Financials](https://www.equationtech.us/sage-services/sage-live) Services We Offer - [Software Selection & Licensing](https://www.equationtech.us/sage-services/erp-software-selection) - [Implementation](https://www.equationtech.us/sage-services/erp-implementation) - [Customization](https://www.equationtech.us/sage-services/customization) - [Support](https://www.equationtech.us/sage-services/support) - [Training](https://www.equationtech.us/sage-services/sage-training) - [Hosting](https://www.equationtech.us/sage-services/hosting) - [Upgrades](https://www.equationtech.us/sage-services/upgrades) Resources - [Technology Blog](https://www.equationtech.us/technology-blog) - [Training](https://www.equationtech.us/sage-services/sage-training) - [Sage Software Video Tutorials](https://www.equationtech.us/sage-300-erp-accpac-tutorial) - [Case Studies](https://www.equationtech.us/case-studies) About - [Meet The Team](https://www.equationtech.us/management-team) - [Certifications & Partners](https://www.equationtech.us/partners) - [Careers](https://www.equationtech.us/careers) - [Contact](https://www.equationtech.us/contact) - [San Diego Location](https://www.equationtech.us/sage-300-support-san-diego) - [Orange County Location](https://www.equationtech.us/sage-300-support-orange-county) - [Seattle Location](https://www.equationtech.us/sage-300-support-seattle) [![Equation Technologies - Sage 300 Authorized Partner](https://www.equationtech.us/hs-fs/hubfs/Redesign_Images/logo-footer.png?width=220&name=logo-footer.png "Equation Technologies - Sage 300 Authorized Partner")](https://www.equationtech.us/) **Equation Technologies** United States: 533 2nd Street Encinitas, CA 92024 Canada: #301 - 220 Brew Street Port Moody, BC V3H 0H6 Phone: 866.436.3530  •  E-mail: [info@equationtech.us](mailto:info@equationtech.us) Equation Technologies ©2016 [Contact Us](https://www.equationtech.us/contact)  | [Privacy Policy](https://www.equationtech.us/privacy-policy) ```json { "@context" : "http://schema.org", "@type" : "Article", "author" : { "@type" : "Person", "name" : "EQ Tech" }, "dateModified" : "Wed, Apr 4, 2018", "datePublished" : "Wed, Apr 4, 2018", "description" : "Sage 300 (formerly Sage Accpac) blog with informative articles in reference to financial software processes and procedures including payroll taxes, training, product information, custom development.", "headline" : "Tracking Use Tax in Sage 300", "image" : { "@type" : "ImageObject", "height" : 800, "url" : "https://cdn2.hubspot.net/hubfs/41683/blog_images/Sales%20Use%20Tax/Picture1.jpg", "width" : 800 }, "mainEntityOfPage" : { "@id" : "https://www.equationtech.us/sage-accpac-blog/tracking-use-tax-in-sage-300", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "height" : 60, "url" : "https://www.equationtech.us/hs-fs/hubfs/Redesign_Images/logo.png?t=1474998725496&width=230&name=logo.png", "width" : 600 }, "name" : "Equation Technologies Inc." } } ```