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

      ERP Services
      Acumatica
      NetSuite
      Sage X3
      Sage Intacct
      Sage 100 ERP
      Sage 300 ERP
      Sage 500 ERP

      CRM

      Strategic Advisory Services
      Digital Marketing Solutions
      CRM Training Camp
      Salesforce
      Microsoft Dynamics 365 CRM
      Sage CRM
      Infor CRM (formerly Saleslogix)

      Employee Experience

      Sage HRMS
      Rippling
      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
      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
      LeaseQuery Lease Accounting
      Sage Fixed Assets
      Vertex SMB Sales and Use Tax
  • Industries
    • Industries

      Chemicals
      Food & Beverage
      Healthcare
      Industrial Manufacturing & Equipment
      Medical Devices
      Nonprofit
      Wholesale Distribution
  • Learning Center
    • Online Resources

      Recorded Webinars
      Whitepapers
      Ebooks

      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 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

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

    Chart Your Course to Better Performance in Sage ERP
    June 8 | 2pm ET
    Register Here

    Next Generation Microsoft 365 Email Protection: Putting Cybercriminals Out of Business
    June 15 | 2pm ET
    Register Here

    What’s New in Sage 100 v2023
    June 20 | 2pm ET
    Register Here

    Scaling Up CRM From Disparate Workflows to a Single, No-Code Platform
    June 27 | 2pm ET
    Register Here

    Popular Recorded Webinars

    Key HR Performance Indicators (KPIs) – How to Measure & Drive Employee Engagement

    Convincing Your CFO You NEED to Automate AP

    Five Ways Your Aging Accounting System is Holding Your Organization Back

    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
    • ERP/Accounting
    • 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

    • Overview
    • Solutions
    • Managed IT Services
    • Fractional CIO & Advisory Services
    • Cloud Services
    • Cloud at Work
    • Compliance & Security
    • DR/Business Continuity

    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

    Industries

    • Chemicals
    • Healthcare
    • Food & Beverage
    • Industrial Manufacturing & Equipment
    • Medical Devices
    • Nonprofit
    • 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