Net at Work is hiring!
Grow your career with us.   Apply Now X
Need Help?
  • Application Remote Support
  • Infrastructure Remote Support
  • Sage HRMS Remote Support
  • Helpdesk
  • General Inquiry
1-800-719-3307
Net at Work Net at Work
  • Solutions & Services
    • ERP/Accounting
      Software & Vendor Selection
      ERP Implementation Services
      ERP Migration Services
      Acumatica
      NetSuite
      Sage X3
      Sage Intacct
      SDMO
      Sage 100 ERP
      Sage 300 ERP
      Sage 500 ERP
      CRM
      Strategic Advisory Services
      CRM Training Camp
      Creatio
      Sage CRM
      Employee Experience
      Sage HRMS
      Rippling
      Workforce Go
      Criterion
      Miviva
      Enterprise Content Management
      Imaging / Scanning
      Document Management
      Workflow Automation
      Solutions
      Nonprofit Solutions
      Abila by Community Brands
      NetSuite
      Sage
      Salesforce
      IT and Security Services
      Managed IT Services
      Fractional CIO Services
      Cloud Services
      Cloud at Work Sage Hosting
      DR/Business Continuity Planning
      Compliance & Security
      Storage & Recovery
      Networking
      IT Security Services
      Communications
      Web Solutions
      Services Overview
      B2B Technology Suite
      Magento eCommerce
      WordPress CMS
      Systems Integration
      Website Managed Services
      Online Marketing & SEO
      ERP eCommerce Integration
      Additional Solutions
      Enterprise Business Intelligence
      Avalara Automated Tax Solutions
      Fortis Payments
      Sage Fixed Assets
      Vertex SMB Sales and Use Tax
      Prime Foodservice Software
      Rental 360
  • Industries
    • Industries
      Chemicals
      Construction
      Discrete Manufacturing
      Field Service
      Food & Beverage
      Healthcare
      Industrial Manufacturing & Equipment
      Medical Devices
      Nonprofit
      Private Equity
      Retail
      Wholesale Distribution
  • Learning Center
    • Online Resources
      Recorded Webinars
      Whitepapers
      Ebooks
      Success Stories
      Upcoming Events
      Live Webinars
      Seminars
      Virtual Training Courses
      Training Courses
      View all available training course options
  • Company
    • Why Us
      Who We Are
      Management
      Our Partners
      Locations
      Careers
      News
      Press Releases
      Success Stories
      Net at Work Blog
      Contact Us
      1.800.719.3307
      Email Us
      Programs
      Alliance Partnership Program
      Women at Work
      Diversity and Inclusion
  • Blog
  • Contact Us
  • Contact Us

Home » Newsletters » Sage 100 Newsletter – Q1 2023 » Sage 100, Avalara Avatax and Colorado Retail Delivery Fee

Sage 100

Sage 100 Newsletter – Q1 2023

Keeping You Up-To-Date With Information About Sage 100

Sage 100, Avalara Avatax and Colorado Retail Delivery Fee

By: Christianna Dorsey, Senior Business Analyst

Did you know effective July 1, 2022 the State of Colorado is imposing a ¢0.27 Retail Delivery Fee on all deliveries in Colorado with at least one tangible personal property subject to state sales and use tax?  The Retail Delivery Fee is imposed even when shipping is free.

Below are instructions on how to setup the Colorado Retail Delivery Fee.  However if you would like to automate the process Net at Work has created a VBScript that automatically adds the Miscellaneous Charge / Item to the S/O Sales Order or Invoice when the Ship To State is CO (Colorado), please reach out if you would like additional information.

  1. Schedule the retail delivery fee return.

You will need to create the return in Avalara AvaTax, for the CO DR 1786 (Colorado Retail Delivery fee return)

    • Effective date 7/1/22
    • Your registration ID / account number will be the same as your company’s active sales tax account with ‘RDF’ as the suffix

Find your account number by logging into the Colorado e-filing website and check the details of your state Retail Deliver Fee account.

Example account number: 12345678-123-RDF
Filing frequency will be the same as your company’s active sales tax account

  1. Adopt the Retail Delivery Fee Tax Code
  • If you’re managing your tax code mapping within AvaTax under the “What you sell” area, you will need to follow these steps to set up a new Item and map it to the new Tax Code. See Map the items you sell to Avalara tax codes.
  • If you’re managing your Tax Code Mapping within your integration, you will need to set up a new item and map it to the Colorado Retail Delivery Fee Tax Code

Note: Merchants subject to this fee will need to determine when this fee applies, and add a $0 line item with the OF400000 tax code to any orders that are subject to the retail delivery fee. (If you are unable to add a $0 line item, please see the FAQs below.)

  1. Pass the new Tax Code as a line on applicable transactions
  • When you determine the Retail Delivery Fee should be applied to a Colorado transaction, add a $0 Delivery Fee item as a separate line on the transaction using the new Item you set up in Step 2.
  • AvaTax factors in product taxability and your customer’s exempt status when calculating the fee. If no sales tax is collected because all of the products are non-taxable or your customer is exempt, the fee is not calculated.
  • Depending upon how an integration displays tax amounts on an invoice, your integration technology partner may need to adjust the display to state the fee amount separately from the total tax. Avalara is currently testing and evaluating the impact of this change on supported connectors. We plan to update this help center article as soon as information is available. Please continue to monitor for updates.

Note: Some home rule cities have decided to treat the $0.27 retail delivery fee as taxable. For example, a city with a 3.7% sales tax rate would calculate $0.01 in sales tax on the fee. As of November 1, 2022, AvaTax will calculate sales tax on the Retail Delivery Fee in applicable cities and local jurisdictions.

  1. Verify the Retail Delivery Fee Calculation
  • When the Retail Delivery Fee Tax Code is passed, you can verify it is working by looking for a $0.27 fee that is calculated on the line item with the retail delivery fee tax code OF400000.
  • If applicable, you can test transactions in your Sandbox account on June 18, 2022 using the new Retail Delivery Code.
  • On June 28, 2022, at 10:30 a.m., you can begin entering transactions for the July 2022 period.

Note: The Colorado retail delivery fee must be separately stated on invoices. Customers will need to configure this themselves within their integration, or work with their integration partner to have it configured to be separately stated.

  1. File your Delivery Fee Return

At the end of every filing cycle, you will need to file your Colorado Delivery Fee Tax Return. If you are a Returns customer, Avalara can file the return on your behalf. If you are not a Returns customer, you will be able to download a report in AvaTax to assist with filing the Colorado Delivery Fee Tax Return.

Click here for additional information on the Colorado Retail Delivery Fee, including Who is impacted, What transactions are subject to the retail delivery fee, and the State Registration requirements.

« Return to Newsletter
  • This field is for validation purposes and should be left unchanged.
In This Issue
  • From the Desk of the Sage 100 Consulting Manager, Lisa Margolies
  • Sage 100, Avalara Avatax and Colorado Retail Delivery Fee
  • Why Don’t SMBs Hit Growth Projections (and How Can You Get Back on Track)?
  • 5 Impactful Elements That Promote IT and Business Alignment
  • Artistic Tile Lays Foundation for Growth with Migration from Legacy Accounting Software to Next Generation ERP
  • Featured Consultant Shelley Arnold, Sage 100 Business Analyst / Consultant
  • Sage 100 Support

    Helpdesk:
    P: 888.494.9479
    E: helpdesk@netatwork.com

    Ready to Upgrade Your
    Sage 100?
    Fill out this form and get your free quote
    Request Upgrade Quote

    Request Sage 100
    Consulting Services

    Get Help From Our Sage 100 Consultants
    Request Services

    Sage 100 Live Webinars

    Supercharge Sage 100 with Fortis Payments
    October 8 | 2pm ET
    Register Here

    Year End CRM Evaluation: 2025 Platform Comparison Guide
    October 8 | 2pm ET
    Register Here

    Stop Microsoft 365 Attacks Before They Hit
    October 14 | 2pm ET
    Register Here

    Popular Recorded Webinars

    The Case for Hosting Sage 100 in the Cloud

    What’s New in Sage 100 v2025

    Unified Employee Self-Service Portal, Integrated Seamlessly with Sage 100

    Actionable Tips to Improve AP & AR Process for Sage 100

    Sage 100 – Live Online Training Courses

    Wide range of class topics! Browse the course calendar & register.

    Sage 100 Webinar Archive

    View our library of on-demand recorded webinars.

    Refer a friend, get a $100 Gift Card!

    Submit a Referral / Learn More!
    Do you have a friend or colleague whose company might benefit from utilizing a Net at Work service or solution? If so, refer them to us below and receive a $100 gift card or donation to your charity of choice!

    Connect With Us

    Business Applications

    • Overview
    • Software & Vendor Selection
    • ERP Implementation Services
    • ERP Migration Services
    • Cloud ERP
    • CRM
    • Employee Experience
    • ECM
    • Nonprofit Solutions

    Learning Center

    • White Papers & Guides
    • Ebooks
    • Training Courses
    • Virtual Training Courses
    • Success Stories
    • Live Webinars
    • Recorded Webinars
    • Trials

    Infrastructure Solutions

    • Managed IT Services
    • Fractional CIO & Advisory Services
    • Cloud Services
    • Cloud at Work Sage Hosting

    Support

    • Application Remote Support
    • Infrastructure Remote Support
    • Sage HRMS Remote Support
    • General Inquiry
    • Helpdesk

    Web Development

    • Services Overview
    • Magento eCommerce
    • WordPress CMS
    • Systems Integration
    • Website Managed Services
    • ERP eCommerce Integration

    Company Information

    • Why Us
    • Alliance Partnership Program
    • Women at Work
    • Diversity and Inclusion
    • Partners
    • Careers
    • News
    • Blog
    • Privacy Policy
    • Contact Us

    Additional Solutions

    • Enterprise Business Intelligence
    • Avalara Automated Tax Solutions
    • Fortis Payments
    • LeaseQuery Lease Accounting
    • Sage Fixed Assets (Sage FAS)
    • Vertex SMB Sales and Use Tax
    • Prime Foodservice Software
    • Rental 360
    • SDMO

    Industries

    • Chemicals
    • Construction
    • Discrete Manufacturing
    • Field Service
    • Food & Beverage
    • Healthcare
    • Industrial Manufacturing & Equipment
    • Medical Devices
    • Nonprofit
    • Private Equity
    • Wholesale Distribution
    Net at Work
    Net at Work (HQ)
    575 8th Ave
    New York, NY 10018

    P: (800) 719-3307
    info@netatwork.com
    Locations Across North America »
    Visit our sister companies:
    Cloud at Work - Sage Application Hosting
    Pixafy - An eCommerce Agency
    Docutrend
    WordPress Image Lightbox Plugin


    Our website uses cookies to ensure you get the best experience. Learn more.

    I Understand