---
title: "Tips & Tricks #97 - Auto Assign Sales Tax Schedule Based on Zip Code | BCS ProSoft"
description: If you are having trouble getting the proper Sales Tax Schedule associated with customers and ship to addresses, there is a feature in Sales Tax Schedule Maintenance that will allow you to associate a state […]
---
Questions? Give us a a call at [**(855) 982-9336**](https://www.bcsprosoft.com/contact/)
- [Facebook](https://www.facebook.com/bcsprosoft)
- [Linkedin](https://www.linkedin.com/company/bcs-prosoft)
- [Twitter](https://twitter.com/bcsprosoft)
- [Email](https://www.bcsprosoft.com/contact/)
[](https://www.bcsprosoft.com/)
- Products
- Deltek
- [Deltek](https://www.bcsprosoft.com/deltek/)
- [Deltek Vantagepoint](https://www.bcsprosoft.com/deltek/vantagepoint/)
- [Deltek Cloud](https://www.bcsprosoft.com/deltek/cloud/)
- [Deltek PIM](https://www.bcsprosoft.com/deltek/pim/)
- [Deltek CRM](https://www.bcsprosoft.com/deltek/crm/)
- Sage
- [Sage Intacct](https://bcsprosoft.com/sage-intacct/)
- [Sage 100cloud](https://www.bcsprosoft.com/sage-100/cloud/)
- [Sage CRM](https://www.bcsprosoft.com/sage-crm/)
- [Sage HRMS](https://www.bcsprosoft.com/sage-hrms/)
- [NetSuite](https://www.bcsprosoft.com/netsuite/)
- [Automated Rental (ARM)](https://www.armsoftware.com/?utm_source=bcsprosoft.com&utm_medium=referral)
- [Services](https://www.bcsprosoft.com/services/)
- Resources
- Blog
- [Deltek Blog](https://blog.bcsprosoft.com/tag/deltek/)
- [Sage Blog](https://blog.bcsprosoft.com/tag/sage)
- [NetSuite Blog](https://blog.bcsprosoft.com/tag/netsuite)
- Whitepapers
- [Deltek Whitepapers](https://www.bcsprosoft.com/resources/deltek-whitepapers/)
- [Sage Whitepapers](https://www.bcsprosoft.com/resources/sage-whitepapers/)
- [NetSuite Whitepapers](https://www.bcsprosoft.com/resources/netsuite-whitepapers/)
- Product Guides
- [Deltek Product Guides](https://www.bcsprosoft.com/resources/deltek-product-guides/)
- [Sage Product Guides](https://www.bcsprosoft.com/resources/sage-product-guides/)
- [NetSuite Product Guides](https://www.bcsprosoft.com/resources/netsuite-product-guides/)
- Webinars
- [Deltek Webinars](https://www.bcsprosoft.com/resources/deltek-webinars/)
- [Sage Webinars](https://www.bcsprosoft.com/resources/sage-webinars/)
- [NetSuite Webinars](https://www.bcsprosoft.com/resources/netsuite-webinars/)
- Company
- [About Us](https://www.bcsprosoft.com/about/)
- [Industries](https://www.bcsprosoft.com/industries/)
- [Events](https://www.bcsprosoft.com/events/)
- [Careers](https://www.bcsprosoft.com/careers/)
- [Support](https://www.bcsprosoft.com/support/)
- [Referral Program](https://www.bcsprosoft.com/bcs-referral/)
- [Contact Us](https://www.bcsprosoft.com/contact/)
# Tips & Tricks #97 – Auto Assign Sales Tax Schedule Based on Zip Code
By [Ed Paxson](https://blog.bcsprosoft.com/author/ed-paxson) | Aug 9th, 10 | Categories: [Tips & Tricks](https://blog.bcsprosoft.com/tag/tips-tricks), [Pending Update](https://blog.bcsprosoft.com/tag/pending-update)
If you are having trouble getting the proper Sales Tax Schedule associated with customers and ship to addresses, there is a feature in Sales Tax Schedule Maintenance that will allow you to associate a state or range of zip codes to specific schedules. Once this is done, MAS will auto-associate the proper tax schedule with a customer and/or ship to address when the zip code is entered.
- Select Library Master | Setup | Sales Tax Schedule Maintenance.
- Enter a Sales Tax Schedule code or press the lookup icon to view a list of available codes.
- Click on the Zip XRef button to assign a range of zip codes to the schedule.
[](https://blog.bcsprosoft.com/hubfs/Imported_Blog_Media/SalesTax-autoassign.png)
Zip Code Range Cross Reference
- Click Accept to save the Zip XRef data and Click Accept to save and close the Tax Schedule
- In Accounts Receivable Customer Maintenance, add a new customer. When you enter a zip code that is within a Zip XRef range, the tax schedule will automatically be entered for that customer.
- In Ship To Maintenance, when the Zip Code is entered, the associated tax schedule will be automatically entered for that Ship To address.
**Want to view more Tips & Tricks for MAS 90/200? Visit our Tips & Tricks** [**Blog**](http://www.bcsprosoft.com/blog/sage-100/)**.**
## About the Tips & Tricks Series
BCS ProSoft is proud to offer you these Tips & Tricks for MAS 90 and MAS 200. These tips were drawn from our extensive technical support knowledge base as well as from the comprehensive experience or our team. Each tip is outlined in detail, including pictures and or drawings where appropriate. There are a couple of things to note in order to use these tips effectively. All tips are written for Sage MAS 90 and Sage MAS 200 versions 4.1 and higher. Some tips should be used with great care and caution. If you are ever in any doubt as to how to use the information provided, please contact our Award Winning Support Center. [Click here](http://www.bcsprosoft.com/support/) for options on contacting our Support Center.
| [](https://www.bcsprosoft.com/category/rental/) | [View Other Tips & Tricks](http://www.bcsprosoft.com/blog/sage-100/) |  | Follow Us on Twitter |
| --- | --- | --- | --- |
| [](http://www.linkedin.com/ppl/webprofile?vmi=&id=48273840&pvs=pp&authToken=bux9&authType=name&locale=en_US&trk=ppro_viewmore&lnk=vw_pprofile) | [Join us on Linked-In](http://www.linkedin.com/companies/251171) | [](https://blog.bcsprosoft.com/hubfs/Imported_Blog_Media/hatRSS_50X50-May-18-2021-05-47-06-98-PM.png) | [Subscribe to our Feed](http://feeds.feedburner.com/BcsProsoft/Xutx) |
## About the Author
Senior Consultant, Ed Paxson
Ed Paxson, Senior Consultant for BCS ProSoft, has been helping companies streamline their accounting and business management systems since 1979. A graduate from Texas A&M University, Ed began working on business systems as a COBOL programmer and quickly moved into business systems consulting. He has been a member of the BCS staff since 2000.
Ed and his wife, Pam, are empty nesters, having recently graduated their youngest of four children. Together, they enjoy anything that involves the water, but most especially, they enjoys skiing on Canyon Lake aboard Ed’s pride and joy, a 21 foot Caravelle ski boat.
#### Share this post with a friend or coworker!
-
-
-
- [mailto:?subject=Tips%20&%20Tricks%20#97%20–%20Auto%20Assign%20Sales%20Tax%20Schedule%20Based%20on%20Zip%20Code&body=https://blog.bcsprosoft.com/tips-tricks-97-auto-assign-sales-tax-schedule-based-on-zip-code](mailto:?subject=Tips%20&%20Tricks%20#97%20–%20Auto%20Assign%20Sales%20Tax%20Schedule%20Based%20on%20Zip%20Code&body=https://blog.bcsprosoft.com/tips-tricks-97-auto-assign-sales-tax-schedule-based-on-zip-code)
### Related posts
[Extend the Functionality of Your Sage Intacct Solution: Learn More at Wednesday Wisdom](https://blog.bcsprosoft.com/extend-the-functionality-of-your-sage-intacct-solution-learn-more-at-wednesday-wisdom)
Mar 24th, 21
[Services Sales Tax Spreads Through States](https://blog.bcsprosoft.com/services-sales-tax-spreads-states)
Feb 8th, 21
[The Best Thing about Sage Intacct Budgeting and Planning? Saying “Goodbye” to Spreadsheet Headaches and Busy Work!](https://blog.bcsprosoft.com/sage-intacct-budgeting-planning-series)
Nov 19th, 20
[Survey Results, Expert Speakers, and Industry Insights – Sage Intacct Hospitality Hangout Has It All](https://blog.bcsprosoft.com/hospitality-hangout)
Sep 17th, 20
[The Sage Intacct Healthcare Hangout is Back!](https://blog.bcsprosoft.com/healthcare-hangout-2)
Sep 15th, 20
[Hurricane Laura – Is Your Business Prepared?](https://blog.bcsprosoft.com/hurricane-laura-is-your-business-prepared)
Aug 26th, 20
This is a search field with an auto-suggest feature attached.
- There are no suggestions because the search field is empty.
### Recent Posts
### Who is BCS ProSoft?
We’re a business technology provider and consulting firm specializing in NetSuite, Deltek and Sage software systems. We’re a Top 30 VAR and ready to get started on your project. Need help? [Let’s talk.](https://www.bcsprosoft.com/contact/)
BCS ProSoft is a leading business management technology provider and professional services firm specializing in Sage, Deltek, and NetSuite ERP systems. Based out of San Antonio, Texas, BCS ProSoft serves more than 1,500 clients from its offices in Houston, Denver, Honolulu, and Monterrey, Mexico.
### **Products**
- [Deltek](https://www.bcsprosoft.com/deltek/)
- [Sage Intacct](https://www.bcsprosoft.com/sage-intacct-overiew/)
- [Sage 100](https://www.bcsprosoft.com/sage-100/cloud/)
- [NetSuite](https://www.bcsprosoft.com/netsuite/)
- [Automated Rental (ARM)](https://www.armsoftware.com/)
### **Company**
- [About Us](https://www.bcsprosoft.com/about/)
- [Industries](https://www.bcsprosoft.com/industries/)
- [Events](https://www.bcsprosoft.com/events/calendar/)
- [Careers](https://www.bcsprosoft.com/careers/)
- [Support](https://www.bcsprosoft.com/support/)
- [Referral Program](https://www.bcsprosoft.com/resource/bcs-referral/)
© Copyright 2008-2021, BCS ProSoft, LLC. All rights reserved. | [Legal](https://www.bcsprosoft.com/legal) | [Privacy Policy](https://www.bcsprosoft.com/privacy/)
- [Facebook](https://www.facebook.com/bcsprosoft)
- [Linkedin](https://www.linkedin.com/company/bcs-prosoft)
- [Twitter](https://twitter.com/bcsprosoft)
- [Email](https://www.bcsprosoft.com/contact/)