Maintaining Financial Compliance in a Tribal Gaming Facility

Protect Assets While Complying with NIGC Regulations CFOs and controllers in the tribal gaming space keep a lot of plates spinning. Staying on top of all these tasks is critical, but one spinning plate may require a bit more attention than the others: maintaining financial compliance. According to the NIGC’s Audit Requirements for Gaming Operations, “Failure to obtain an annual audit and submit the required reports to the NIGC is a violation of the law that could subject the tribe to a civil fine of up to $25,000 per violation.” But passing financial audit requirements is, not just possible, but probable when your finance officers understand and comply with all NIGC regulations for tribal gaming. Establishing Internal Accounting Controls The first step toward ensuring compliance with NIGC requirements is establishing internal accounting controls. Investopedia defines these controls as the “mechanisms, rules, and  procedures implemented by a company to ensure the integrity of financial and accounting  information, promote accountability, and prevent fraud.” There are two main types of internal controls: 1. Preventative Internal Controls Preventative internal controls focus on stopping errors and irregularities within accounting and financial teams. Some examples include instituting double-entry accounting to make sure the books are always balanced, controlling access to financial or accounting systems, and dividing duties among different members of the accounting team. 2. Corrective Internal Controls Should preventative internal controls fail and errors occur, the next step is employing corrective internal controls. These are pre-determined procedures that all team members must know and follow. Corrective internal controls may include manually counting money or inventory, standardizing accounting documents, requiring manager approvals for accounting transactions, and performing internal audits. In the tribal gaming context, trained NIGC auditors may conduct an on-site Internal Control Assessment (ICA), which can be either “a comprehensive review of a tribal gaming facility’s entire system of internal controls or a specific examination of a single gaming activity such as Bingo, Table Games, Gaming Machines, among others.” As CFO or controller at a gaming facility, you can request that an ICA be tailored to your Tribal Internal Control Standards (TICS), to Part 543 of the NIGC’s Minimum Internal Control Standards (MICS), or to “any other internal control standards” of your choice. An ICA can be a great benefit to a gaming facility because, after the assessment is complete, the tribe and tribal regulators receive a report detailing the facility’s regulatory compliance or lack thereof. Should onsite training and/or remediation be needed, the NIGC will be there to help. This will improve future compliance and keep your facility on an upward trajectory. Secure Assets with Increased Oversight Preventative and corrective internal controls protect assets significantly, but, on their own, they may not  be enough to prepare for the annual NIGC audit. So, it is vital that a gaming facility appoint a trusted team member to oversee controls and review the financial statements of the gaming operation only. This doesn’t mean that CFOs or controllers should not also oversee other financial aspects of the business, such as accommodations, dining, golf, etc. It means that the financial statements for the gaming operation must be kept and analyzed separately from the statements for the rest of the business. This increased, detailed oversight helps regulate financial reporting and expose any concerning changes  or trends. But the phrase “trusted team member” is critical here. Issues in a gaming environment may result from employee malfeasance, which is a common occurrence in SMBs, according to an article from accounting and business advisory firm Signature Analytics. The article notes that businesses employing fewer “than 100 people must trust their employees with more information compared to businesses with many more workers with the ability to have anti-fraud controls in place.” This concept may easily be generalized to the tribal gaming context. It may be difficult for leaders in tribal gaming facilities to imagine their employees committing fraud against them—particularly because tribal casinos aren’t “business casinos” but “community casinos”, according to Jason Salsman, communications director of the Muscogee Creek Nation. The revenues from tribal gaming facilities “supplement chronically underfunded health and education programs” on Native American land, and it is unpleasant to think about employees stealing money from their communities. Still, this makes it even more important for tribal casinos to have oversight policies and procedures in place—not only to pass NIGC audits, but also to prevent the breach of trust that is employee fraud. Perform Regular Self-Evaluations Finally, performing regular self-evaluations is a big step toward maintaining financial compliance and passing  financial audit reviews. One effective self-evaluation method is to consistently review financial reports. This  gives gaming facilities a firm grasp on their financial data so that, if unusual fluctuations or variances occur,  they’ll be able to notice and address them immediately before falling out of compliance with the NIGC. Transaction tracing is another easy and effective way to perform self-evaluations, monitoring how transactions are being processed company wide. Tracing follows a transaction from start to finish, highlighting any recording errors, lack of disclosure, or noncompliance. The more self-evaluations a tribal gaming facility performs, the more it ensures financial compliance and the better it can keep concerning issues from becoming major, out-of-hand problems. How Acumatica Can Help Internal accounting controls, increased oversight, and regular self-evaluations are all proven methods for maintaining financial compliance, but there’s one more: implementing a comprehensive, adaptable cloud ERP solution, like Acumatica. Resting on a future-proof platform and offering best-in-class business and industry functionality, Acumatica’s cloud ERP software organizes data and automates routine, manual tasks—eliminating human error and providing an audit trail of all transactions. Acumatica is a complete solution that simplifies complex compliance requirements. Acumatica’s Corporate Controller, Hans Huang, addresses the differences between ERP and accounting software, such as QuickBooks, in a recent article. He explains that accounting software is a standalone solution that “allows businesses to handle their accounting transactions, from accounts receivable (AR), accounts payable (AP), and bank management to revenue tracking and financial reporting.” However, he goes on to say that an ERP solution … Read more

Sneak Preview of Acumatica 2022 R1

Acumatica provided a preview of what’s new in the upcoming release of version 2022 R1 at summit last week. The Beta is now available on the Acumatica community site. The upcoming Spring release of 2022 R1 improves the user experience and is intended to increase users production through streamlined work flow engines, continued focus on machine learning and expanding functionality across its industry editions and expanding global markets. Here are some key highlights of 2022 R1. Core Platform Continued direction toward AI/machine learning (G/L anomalies). Global Markets  New localization packet for the U.K and language packets for French Canadian and Spanish. Introduction of Canadian payroll Industry Editions Distribution – managing long-term sales orders / Blanket sales orders Manufacturing – By customer demand role-based out of the box dashboards will be introduced in 2022 R1. The manufacturing edition will have a dashboard for production meeting, production manager, and engineering. Construction and Service– automatic setup of service contracts and renewals where you can copy and print right within Acumatica. Unit billing is also being introduced in 2022 R1. Commerce – Native integration with Amazon that supports both Fulfilled by Amazon (FBA) and Fulfilled by Merchants (FBM).

Enabling Parallel Processing on Acumatica Processing Screens

By Kyle Vanderstoep Acumatica, positioned as a mid-market ERP, can be deployed for a wide variety of companies – large, medium, or small. As companies experience growth, the amount of data it needs to manage grows.  However, in my experience developing custom code on the Acumatica platform, I find a significant number of organizations I work with punching above their weight when it comes to managing and processing data. Acumatica has a wide variety of processing screens to perform various tasks “en masse”, and additionally has a robust yet easy framework to follow for implementing your own processing screens. Out of the box, however, records are processed sequentially (1,2,3 etc.). Fortunately, it is possible to enable parallel processing for clients with large data processing requirements. Parallel processing takes advantage of the fact that applications can utilize more than a single processing thread at once. Think of the days before computers, where clerks manually processed transactions by hand. How did you speed up the number of transactions you can record? Either you search high and low for the wonder clerk who is super-fast, or you simply hire more clerks and split the work evenly amongst them. Acumatica can be configured similarly. To enable Parallel processing, you need to add the following keys to theweb.configfile under the Configuration/Appsettings node: GIST:https://gist.github.com/lekkersolutions/320b32b5eeb15e36ce29957095862b3d To test this, lets add these keys to the web.config file and create a basic processing screen that processes a list of records: GIST: https://gist.github.com/lekker-solutions/46b8a010c4ceae41bea63707b8e9ba22 Even though we have added the keys, the processing screen still returns the entire list of GL Batches when “Process All” is selected. This is due to the keys only setting a global rule on processing. It still needs to be enabled on your custom screen itself. The code below demonstrates how: GIST: https://gist.github.com/lekker-solutions/33552d7e645905d0a995a9df7f56db49 Now let’s try the process the all button: When you look at the result of the processing screen, you can see that all records have been processed even though that thread we caught only saw 10: Here is a diagram illustrating the difference between the two, and where the breakpoint is caught in the code: During sequential processing, the thread (aka the clerk) saw the entire list of items to process. In parallel processing, the thread only saw the max number of items (specified at a max level in the web.config file and additionally in the parallel processing options at the screen level). Parallel processing, while not a silver bullet, can significantly increase the processing capability for Acumatica users working with large amounts of data. With just a few changes to the web.config file, you can easily enable it on both the base ERP code and your custom code. There is no need to manage your own threads and the other complexities that come with it. I hope that this article will help you with the data processing volume that is ever increasing at a faster and faster pace in this digitally transforming world. Happy Coding! —————————————————————————————————————————– This article was penned by Kyle Vanderstoep, Senior Applications Developer at Nims. The article was featured in a recent Acumatica Newsletter.

News from Summit and what to look out for in Acumatica 2021 R2

This week Acumatica held its first Summit in over a year. After some uncertainty if there would even be a Summit in 2021, Acumatica announced it would hold Summit in Las Vegas in May but was subsequently pushed back to July due to the ongoing global pandemic. During the kickoff keynote on Monday, Acumatica announced a couple of exciting features that will be coming in the Fall 2021 R2 release. Coming in 2021 R2 Acumatica will have direct integration with Microsoft Teams. Acumatica’s development team has been working in collaboration with developers in the Microsoft Teams division to create the integration. Acumatica is collaborating with Adobe to create tighter integration with Acrobat. Coming in 2021 R2 will be a feature that will allow more flexibility with the use of annotations in Acrobat right inside of Acumatica. The 2021 R2 Beta will be available on August 4th. Acumatica also shared exciting news they received from research industry analysts that places Acumatica at the top of customer satisfaction (G2 Grid). Acumatica ranks as the fastest growing ERP company globally outpacing other competitors in this category by a large margin (IDC).

Acumatica Receives High Marks in Latest ERP Data Quadrant Report by Software Reviews

Acumatica was named a gold medalist in the 2021 Software Reviews Enterprise Resource Planning Data Quadrant Awards. The award is based on an annual report released by Software Reviews which is a division of Info-Tech Research Group. product solutions focusing on satisfaction of product features, VAR experience and skills, and likelihood to recommend the software to others. Acumatica placed in the top 4 of the quadrant among other solutions that received composite scores of 8/10. Some of the highlights for Acumatica include ranking first for both business value and usability.

Acumatica 2021 R1 – What’s Behind the New Dashboard Enhancements

In a previous article we explained what the new link and meter tiles are in 2021 R1. The new tiles are intended to make data more visible and accessible. What is behind these tiles are data from other parts of Acumatica. For instance, the information tied to each link are sourced from either workspaces or forms such as reports/generic inquires. With meter tiles / KPI meters you can set the properties by selecting from several pre-defined filter settings. Also, in 2021 R1, Acumatica now lets you sort data using a funnel chart. This is simply achieved by selecting a new chart from the dashboard and choosing the chart type funnel, which is sorted and configured by opening the hood in filter settings.

Acumatica 2021 R1 – New Financial Dashboards

Dashboards are one of the essential usability features in Acumatica. Dashboards give visibility and quick & easy access to important business information to employees across different roles in the organization—i.e., financial, sales, purchasing, operations, customer service etc. Prior to version 2021 R1, dashboards were delivered as a blank canvas. Thus, in order to use the dashboard it would require the employee, application admin or implementation specialist to build out and customize a dashboard. Beginning with the 2021 R1 release, Acumatica now includes an already predefined dashboard for financial personnel. These dashboards are available for: • AR Clerk focusing on customer management sales and credit. • AP Clerk focusing on vendor management and payments. • Controller focusing on financial management and control. Controller Dashboard: AP Clerk Dashboard: AR Clerk Dashboard:

Acumatica 2021 R1 Highlight – New Widgets to Dashboards

Acumatica has now released its first of two bi-annual releases. One of the new usability enhancements in 2021 R1 are new visual tiles to dashboards. The additional tiles are meant to increase the sharing of important business intelligence across an organization.   The new tiles offer a better way of visualizing departmental activities and performance but also to launch into other important daily activities. Acumatica refers to these as “Link Tiles” (see figure 1). Link tiles are intended to help visualize data and provide direct links to important activities and reports right from the dashboard. Another type of link tiles that have been added to dashboards are “meter tiles” (see figure 2). These tiles provide easy to read visuals on gauging how departments are meeting specific deadlines, goals, quotas, etc. Not only can you use an absolute value for setting conditions for the meter tiles you can also use inquiry fields or percent values (see figure 3). In 2021 R1 with the information contained in the meter tiles, you can share it across an organization by simply copying the dashboard tile (See figure 4). The next step is to navigate to another dashboard and simply paste it to other dashboards with one click —i.e., another employee dashboard, management dashboard, executive dashboard etc. (See Figure 5)

Acumatica 2021 R1

Acumatica is scheduled to release the first of two biannual product releases toward the end of February. In 2021 R1 Acumatica continues to focus its pursuit on adding features to improve overall usability. Some of the new features in 2021 R1 include: • Mobile image recognition for business card via CRM • Enhanced side panels with ordering and visibility • New Generic Inquiry features include easy navigation to external URLs and send targeted customer communications through filtered GI results Acumatica is having its virtual launch event for 2021 R1 on February 18th. This event will highlight the new features coming in the 2021 R1 release. Register for the Acumatica Launch Event!