--- title: "RPA Use Case: Lessening the State Sales Tax Filing Burden" description: RPA can take some of the sting out of filing sales tax. Here’s a great use case of how one of our clients uses KnowledgeLake RPA to do so. image: https://www.resources.knowledgelake.com/hubfs/Imported_Blog_Media/Webp_net-resizeimage-38-1.jpg --- [Skip to content](https://www.resources.knowledgelake.com/blog/rpa-state-sales-tax-filing#main-content) [![knowledgelake-logo](https://www.resources.knowledgelake.com/hubfs/Web%202022/nb-kl-logo.svg) ](https://www.resources.knowledgelake.com/) - [Platform](https://www.knowledgelake.com/platform) - [Industries](https://www.knowledgelake.com/solutions) - [Company](https://www.knowledgelake.com/leadership) - [Resources](https://www.knowledgelake.com/resources) ** [![Contact Us](https://no-cache.hubspot.com/cta/default/5802762/5f620b97-8fa9-46d4-ad80-25f0134602ff.png)](https://cta-redirect.hubspot.com/cta/redirect/5802762/5f620b97-8fa9-46d4-ad80-25f0134602ff) ** - [Platform](https://www.knowledgelake.com/platform) - [Industries](https://www.knowledgelake.com/solutions) - [Company](https://www.knowledgelake.com/leadership) - [Resources](https://www.knowledgelake.com/resources) [![Contact Us](https://no-cache.hubspot.com/cta/default/5802762/5f620b97-8fa9-46d4-ad80-25f0134602ff.png)](https://cta-redirect.hubspot.com/cta/redirect/5802762/5f620b97-8fa9-46d4-ad80-25f0134602ff) ** ** Automation # RPA Use Case: Lessening the State Sales Tax Filing Burden By: [Joe Labbe](https://www.resources.knowledgelake.com/blog/author/joe-labbe) | January 31, 2020 [mailto:?subject=Check%20out%20https://www.resources.knowledgelake.com/blog/rpa-state-sales-tax-filing](mailto:?subject=Check%20out%20https://www.resources.knowledgelake.com/blog/rpa-state-sales-tax-filing) The only guarantees in life are death and taxes. While robots can’t do a whole lot about death (though robotic surgeons may beg to differ), RPA can ease the burden of that other life guarantee. Sorry folks, you still must come up with the cash to pay your taxes. However, RPA can take some of the sting out by helping to file those taxes. Here’s a great use case of how one of our clients uses KnowledgeLake RPA to lessen the burden. We have a client who specializes in providing tax and audit services to franchising organizations. One of the challenges our client has is preparing and filing monthly sales and use taxes for each franchise location within each state of operation. Think about that challenge. Each month, our client must collect operational financial data from hundreds of small businesses, analyze it, generate individual reports for each location, generate consolidated reports for the franchiser, and then file sales taxes with each state where a given franchisee conducts business. To complicate matters, each state has its own regulations, filing periods, and methods. To call this a herculean effort is a gross understatement. Recognizing the repetitive and time-consuming nature of the subprocesses involved, our client elected to use RPA to gather and consolidate the data, generate monthly reports and file state sales taxes. This automation includes performing the following steps: - Downloading a QuickBooks .QBW file from each business location via RDP or VPN - Running memorized reports and exporting the data to a series of spreadsheets where the data is analyzed, and the sales taxes calculated - Filing the calculated sales tax for each franchisee within each applicable state - Capturing the onscreen receipt of filing and sending a notification of filing to all interested parties - Updating the analysis spreadsheets with the filing dates The benefits of RPA automation were immediately obvious to all. For starters, after RPA was implemented, accountants were no longer responsible for performing the mind-numbing task of downloading and marshaling data into spreadsheets. Their role in the new process starts when they receive a notification that the spreadsheet for their location client is ready for review. On average, data collection and marshaling accounted for 60% of the processing time required to prepare each location’s sales taxes. That work has now been ported off to the bots thus freeing up the accountants to perform other tasks that are much more valuable to the firm. > **Click to Tweet:** [Before this firm implemented RPA, data collection/marshaling accounted for about 60% of the processing time needed to prepare each location’s sales taxes. That work has now been ported off to the bots, freeing up accountants to perform other, more valuable tasks. ](https://ctt.ac/Oyk76) But we’re not done. After the taxes are cleared for filing, under the old system, each spreadsheet was forwarded to a tax filing clerk who would then manually enter the sales tax data into the appropriate state filing website and send a receipt of filing back to all interested parties. This process too has been ported to RPA bots. Now, once a spreadsheet is cleared, the accountant saves the document to the firm’s document repository and flags it as “ready for state filing”. Once there, a bot picks up the document and performs the following: - Extracts the filing data from the spreadsheet - Enters the filing data into the appropriate state filing website - Takes a screenshot of the filing receipt and saves it to a file - Updates the original spreadsheet with the filing date - Saves both documents back to the document repository Not only is the process significantly faster, but the error and exception rate has also been cut by 80%. Originally, the RPA bot also generated the filing notifications. However, since the list of notification parties already resided within the document repository, it made more sense to have that system generate the notifications since it has a mechanism that allows users to subscribe to notifications of document status changes. This is a great example where the client had the discipline to let each system handle the tasks it is best equipped to handle and create a clear separation of concerns. So, there you have it. Sales tax filing is made easy through the power of RPA. If you’d like to learn more about this solution or how RPA can help your business become more efficient, [reach out to us.](https://www.knowledgelake.com/contact.html) In the meantime, we’ll see what we can do about getting RPA to help with that other life guarantee. Tag(s): [Automation](https://www.resources.knowledgelake.com/blog/tag/automation) ## Other posts you might be interested in View All Posts [ ** 13 min read ## We Use Robots Every Day in Our Personal Lives. Why Not at Work? July 1, 2019 LinkedIn Twitter Facebook YouTube First, What RPA is Not Robotic process automation (RPA).... Read More ](https://www.resources.knowledgelake.com/blog/we-use-robots-every-day-in-our-personal-lives-why-not-at-work) [ Automation ** 5 min read ## RPA Should Be Called Repetitive Task Automation (RTA) March 3, 2022 Robotic Process Automation , or RPA for short, has caught the market’s imagination over the past few years.... Read More ](https://www.resources.knowledgelake.com/blog/rpa-should-be-called-repetitive-task-automation) [ ** 3 min read ## KnowledgeLake’s New No-Code RPA Design Studio Simplifies Document-Centric Automation May 11, 2022 What if you didn’t need to write a single line of code to automate your document workflows? Think how much... Read More ](https://www.resources.knowledgelake.com/blog/no-code-rpa-design-studio) ## Subscribe to the latest updates from KnowledgeLake - [Platform](https://5802762.hs-sites.com/platform) - [Platform](https://5802762.hs-sites.com/platform) - [Synthetic Labor™](https://5802762.hs-sites.com/synthetic-labor) - [Cloud](https://5802762.hs-sites.com/cloud) - Integrations - [Microsoft 365/SharePoint](https://5802762.hs-sites.com/microsoft-office-sharepoint) - [Microsoft SharePoint Premium and Syntex](https://5802762.hs-sites.com/microsoft-sharepoint-premium-syntex) - Industries - Industries - [FinServ](https://5802762.hs-sites.com/enterprise-automation-financial-services) - [Manufacturing ](https://5802762.hs-sites.com/accounts-receivable-automation) - [Higher Ed](https://5802762.hs-sites.com/university-content-management-system) - [Healthcare](https://5802762.hs-sites.com/healthcare-administration-software) - [Insurance](https://5802762.hs-sites.com/insurance-agency-management-software) - [BPO](https://5802762.hs-sites.com/outsourced-services-bpo) - [Digital Gov](https://5802762.hs-sites.com/digital-government) - [Digital Gov](https://5802762.hs-sites.com/digital-government) - Company - [About Us](https://5802762.hs-sites.com/about-us) - [Our Partners](https://5802762.hs-sites.com/partners) - Resources - [Resource Center](https://www.resources.knowledgelake.com) - [Blog](https://www.resources.knowledgelake.com/blog) - [Webinars](https://5802762.hs-sites.com/webinars) - [Newsroom](https://5802762.hs-sites.com/newsroom) - [Support](https://help.knowledgelake.com/hc/en-us) © 2026 KnowledgeLake [Privacy Policy](https://www.resources.knowledgelake.com/privacy) [Security and Compliance](https://www.resources.knowledgelake.com/security-compliance) [314.898.0500](tel:+13148980500) [**](https://www.youtube.com/c/KnowledgeLake/videos) [**](https://www.linkedin.com/company/knowledgelake/)