Write it Once – The Value of Integration

It’s amazing how much time and energy continues to be spent on duplicate data entry and re-keying information generated by one system into another.  Human-based data entry is prone to errors, takes time, and carries with it the burdens of employee costs and resources.  It is a problem that businesses of all types have battled for years even though enabling solutions have been around for a while. 

Methods of integrating applications and data have existed for quite some time, and in recent years these methods have expanded to include a wide variety of platforms and more open standards-based approaches.  Even in the small business world, business owners using traditionally limited software products can enjoy sophisticated extensions and integration of their applications and business data.

To provide a simple example of the problem: when an individual writes a check, that check must be recorded for several purposes including the recording of the cost or expense as well as the reduction of funds in the bank account.  When a product is sold to a customer, inventory is relieved, sales are increased, accounts receivable or cash is increased, costs of goods sold are experienced, and customer activity is captured.  All of this information must be recorded, and the activity accounted for throughout the financial and operational systems and can represent a tremendous burden if not automated. This also means that data exists in a variety of places, increasing the challenges of information collecting and reporting.

 Cloud-based integration and infrastructure services such as Microsoft Fabric and Azure enable seamless collection, transformation, aggregation and storage of business data. Whether linking accounting with sales CRM or pushing financial and operational data to an Azure data warehouse for analytics, Noobeh helps provide the data engine and the infrastructure to put it all together.

A small business owner’s situation offers a direct illustration. He sells computer parts through an ecommerce website.  Orders from this website are emailed to his order operators, who then turn around and re-key the orders into their accounting system where the inventory is also tracked.  Because of the increasing number of sales orders and product purchase orders to enter on a regular basis, there were three operators working in the department responsible for making sure website orders make it into the accounting system. Orders were frequently missed or misplaced, entry errors caused problems in accounting and product delivery, customer satisfaction went down, and the cost of handling web orders was increasing.

By implementing a single software solution, the company was able to not just address the current problem, but was set up to seamlessly increase business without increasing headcount. The solution was a system which takes transaction data from the ecommerce system and imports it into the accounting/ERP system. This single step allowed the business to reduce and redirect personnel costs, improve accuracy and timeliness of data entry, and increase customer satisfaction as well as overall business performance.

In even a small company, one piece of information may be used in a variety of ways and in a variety of systems. This complexity is found in simple business models as well as larger and more complex enterprises, revealing the value of integration solutions and automation tools at every level of operation.

Mendelson Consulting and Noobeh cloud services recognize that every business needs the right information at the right time to operate effectively. Our expert teams help businesses implement the solutions which bring business data together, empowering workers to be more productive and giving stakeholders the decision-support tools they need.

jm bunny feetMake Sense?

J

PowerBI, Data Warehouses and Combining QuickBooks Enterprise Data with Other Data

Businesses of all types are looking for ways to discover more useful information hidden in their systems. With a desire to implement business intelligence tools such as Microsoft PowerBI, companies need the ability to combine and analyze data coming from a variety of sources. The data can help businesses inform their conclusions rather than leaving it up to “gut”, supporting decision making in all areas of the company.

The tools for exposing and combining data are many. Enterprise ETL (Extract/Transform/Load) products have been available for many years. When it comes to SMBs and the applications they utilize, the options aren’t quite as prevalent nor as powerful. In most cases, businesses are left to working with data exports and a bunch of linked Excel worksheets.

Noobeh understands that businesses need their data available for integration, analysis and reporting. Noobeh are experts in deploying SMB applications such as QuickBooks Enterprise desktop, Acctivate Inventory, Sage ERP, MISys Manufacturing and more, all on the Microsoft Azure platform, positioning the applications and their data perfectly for use in business analytics and data warehouses.

Data warehouses and data lakes are growing in popularity because there is simply too much disparate data present in any growing business to effectively analyze it one data silo at a time. The number and variety of data sources in a single small business can be far larger than the company realizes until it attempts to capture and report on that data.

Any approach to data warehousing should consider the potential number and variety of data sources involved. This is among the reasons for Noobeh electing to work with Microsoft Azure and PowerBI. The Azure platform provides the infrastructure services and platform tools to enable data connections needed, powering the data warehouse and exposing the data to PowerBI and other reporting and analysis tools.

Even QuickBooks Enterprise desktop data can be extracted into its own standalone data warehouse, connected to a broader data warehouse and then combined with other business data. When businesses can combine data from their various solutions, even those which may still be desktop-bound, the power of the information and intelligence contained in it can be revealed.

Whether the purpose is process improvement, performance monitoring, management reporting or combined operational intelligence, collecting and storing the data is the first step. Noobeh is there to help make it happen.

jm bunny feetMake sense?

J

Deadline Approaching for QuickBooks Desktop Users

All QuickBooks Desktop Users Are Required to Upgrade to a Current Subscription Model by Sep 30. Yes, the time has come to buy in to the software subscription model or lose access to your books. But at least you get to keep using QuickBooks desktop software, which is worth a lot of you’re already invested in QuickBooks.

Effective Sep 30, 2024, all existing users of QuickBooks Desktop Pro, Premier, Mac, and Enterprise Solutions v21 (and earlier) must transition to the annual subscription model. For Pro and Premier users, this is a short reprieve. Previously Intuit had announced a July deadline for renewing Pro/Premier licenses. After the now-September deadline, there won’t be any new sales of Pro or Premier licenses. With some of the recent price increases it almost becomes a moot point, as QB Enterprise is now priced similarly (less?) than Premier.

Something notable in all of this is that versions sold under non-subscription one-time licenses will be discontinued entirely. That is just fine for many users, however, as the much older versions don’t “phone home” to authorize the license, so they can keep working. The downside to that is vulnerability. Outdated and unpatched software is more vulnerable to risk than software that is actively updated to protect against various exploits. Best practices demand keeping software updated and patched. Being out of support with your business financial and accounting software is not a position you want to find yourself in.

Starting Oct 1, 2024, QuickBooks Enterprise will be the only QuickBooks Desktop version available for new purchases. For very small businesses, this is going to be a challenge as QB Enterprise is not as affordable as Pro was. These businesses may find that QuickBooks Online works for them, but they will not only miss out on a great deal of QB Desktop functionality that is not present in Online, but they will also be locked into the QuickBooks Online service model of receiving product updates without announcement, not having a backup of your company data, getting bombarded with a revolving door of add-on apps, and having literally no control whatsoever of where your data lives and how Intuit and its companies are accessing it.

If you are using an older version of QuickBooks Desktop, upgrading to the subscription model before the deadline is crucial to avoid any interruption of services.

What does this mean?

  1. Service Discontinuation:
    Failure to upgrade will result in the discontinuation of services such as QuickBooks Desktop Payroll, Payments, Online Backup, online banking, system updates, security patches, and live support. This could potentially disrupt your business operations.
  2. Immediate Action Needed:
    To ensure uninterrupted business operations, we strongly recommend planning your upgrade without delay.
  3. Advantages of Upgrading:
    Intuit encourages existing Desktop subscribers to upgrade to the current version (Desktop 2024) to benefit from the latest features, improvements, security updates, and bug fixes. Updated software also improves compatibility with current versions of Windows, Microsoft Office applications, Gmail services and other solutions that use modern methods of account protection and authentication.

At that time, you may also want to consider your alternatives to how and where you run your QuickBooks Desktop software.

Intuit offers “cloud access” with their QuickBooks Enterprise licensing, but this option is not your only or best option for running your QuickBooks Desktop/Enterprise software in the cloud.

With the bad guys (hackers) and malware being as prevalent as they are, businesses must be vigilant in securing their business and financial information. Shared hosting platforms where service providers allow many users from many businesses to operate on the same servers simply cannot provide the level of security or protection most businesses need.

Noobeh QBonAzure offers some limited shared hosting, but only for customers that have limited requirements and only for a few users. When a company needs more than just “vanilla” hosting for their valuable financial data, we strongly recommend going the private route and having your own cloud server.

Not just a “dedicated” server in a service provider’s network, Noobeh works only in the private Microsoft account of each customer, ensuring that there is absolutely no sharing of any resources with other customers. This allows us to build a system that works specifically for your business, with all the applications and services needed to support all aspects of operation. There aren’t different levels of service or service packages; each system is built and sized for the customer’s unique requirements, and we don’t charge per-application or silly things like that. You need what you need to run your business, and we host that.

Connect with us if you have any questions or need assistance during this transition. We will help you navigate the changes and understand how best to proceed for your business and circumstances, engaging with the right products and services to ensure continuity and set you up for greater future success.

jm bunny feetMake Sense?

J

Enhancing Business Insight: Noobeh Cloud Services and Azure-Based Solutions

Technology is evolving and so are our ways of using it. While the rules of accounting haven’t changed for years, the solutions we use to do the work have changed a lot. Yet there remain many businesses that haven’t yet embraced the idea of fully digital workflows, integrating and automating how data moves through the “system” to provide a comprehensive view of the business and how it is performing.

This is where accountants and bookkeepers can best serve their clients, by helping them implement the platforms and solutions which transform operations and provide greater insight into these areas.

Over 20 years ago, a technology model was developed which allowed businesses and the accounting professionals who serve them to work directly and collaboratively in the clients’ accounting system. By hosting QuickBooks and Sage desktop products on host servers, small business users and their accountants could both access the software and the data in real time.

This new approach was a boon for accountants, bookkeepers and others working with small business clients as it not only enabled closer work, but also provided those advisors an opportunity to do more – and more complex – work with the client. Yet many platforms and working models created barriers to broadening the scope of service or access to client systems, limiting to just basic accounting products like QuickBooks, and not effectively addressing the rest of the business need.

As technology has evolved, so have these transformations.

More accounting professionals understand the benefits as well as the necessity of moving from analog to digital workflows, removing manual entry and improving efficiency and accuracy of data. Yet this improvement doesn’t require changing accounting software and undoing years of learning and business knowledge. Rather, the platforms and connections must be the primary focus, replacing the manual with automation and smoothing out the bumps where data isn’t flowing at all. If the system isn’t in place to handle the complete flow of the data, there is a break. Like a pipe leaking water, this break results in data loss – which is also loss of business intelligence.

A key to all of this is the consideration of where the data ultimately resides. When business data exists in closed silos – whether web-based software or closed hosting platform – it takes a comprehensive approach to collection, storage and analysis. This is among the benefits to be derived from the modern cloud and Noobeh’s Azure-based hosting approach.

Noobeh’s hosting is not just about the desktop or the applications.

The cloud platform, and Azure in particular, also provides resources for data analysis and business intelligence, workflow and data flow automations, improved security and identity management, IoT and computing on the network edge.

For professionals looking to evolve their practices by helping clients go beyond basic recordkeeping and reporting, it’s time to delve into the operational details, data flows and development of real business intelligence and insight. Noobeh Cloud Services and Mendelson Consulting have the platforms and the supporting services to help bring it all together, improving profitability and performance of their clients through the intelligent application of technology.

jm bunny feetMake Sense?

J

Competitive and Profitable Construction: What’s it take to get there and stay there?

The short answer is… update your operations and transform the business. It’s time to modernize and embrace the cloud.

Construction firms need to be more data-driven, analyzing and responding to conditions revealed by the various systems supporting the business operation. Turning a profit on complex projects means applying automation to manual processes and workflows, introducing more collaborative tools, and delivering real-time data to gain greater insight into the operation’s performance and profitability. The foundation for all of this is the cloud platform, extending connectedness beyond traditional boundaries.

Digital transformation and the adoption of agile and connected cloud platforms can result in productivity gains of 14 to 15 percent and reduce costs from 4 to 6 percent. These improvements are the way to address fading profits even as the pace of business increases. https://www.mckinsey.com/business-functions/operations/our-insights/decoding-digital-transformation-in-construction

There are several factors that typically weigh down the operation and cause profits to fade. Strained IT resources is a big item for most construction companies, where technical people spend far too much time building and maintaining on-premises servers and networks. Maintaining on-premises servers adds up fast. A single IT manager can easily cost around $150,000 per year, and the “cost of cybersecurity compliance raises the price by an additional $200,000.” (5 Reasons Contractors Need to Modernize Their Operations to Stay Competitive and Profitable by Trimble Viewpoint)

Even when you factor in the costs of hardware, software and IT personnel, those costs don’t include the hidden expenses that come with the use of on-premises servers, like disconnected and siloed data that requires manual processes to use, duplicated data entry requirements (increasing the potential for human error) and more costs for labor. When you figure in all the capital costs and expenditures, on-premises solutions can cost up to four times as much as their original purchase price. On the other hand, NOOBEH cloud servers, deployed on the Microsoft Azure platform, offer reliable, cost-effective solutions to support the variety of important business applications and integrations that high-performance operations require.

NOOBEH cloud services focuses on addressing the pain points businesses have with their IT. We help businesses implement services that promote real collaboration for real use-cases, and we look for ways to connect projects and operational data so it can be analyzed to unlock greater value across the entire enterprise.

Disconnects cause inefficiency, delays, errors, and reduced productivity. Lack of insight on the labor and equipment side leads to uncontrolled resource utilization and a lack of predictability. Jobs get delayed and profits fade. Lost productivity due to duplicate entry of information is leveled at 10%-30% (or more), and these rates are not uncommon. https://www.eckerson.com/articles/hidden-costs-of-duplicate-data.

Clearly, automation, connected workflows, cloud platforms and real-time data are essentials in the transformation and improvement effort. Let in-house IT focus on activities that bring value to the business, finding ways to innovate and improve how things get done. Replace cumbersome, manual processes with software and systems that facilitate greater automation and integration, eliminating redundant data entry and improving the quality of information.

Construction projects are becoming larger and more complex, and project owners want the latest technologies, real-time reporting, and comprehensive approaches to compliance. Today, industry-leading contractors are embracing connected cloud technologies so they can scale and future-proof their businesses.

The modern contractor takes advantage of connected platforms, automation and real-time data that feeds data analysis and business intelligence… innovations only available with the cloud. That’s what NOOBEH delivers.

jm bunny feetMake Sense?

J

Love It or Leave It? QuickBooks Desktop Needs Internet Explorer 11 and Microsoft Uninstalls It.

We all know that software companies recommend running current versions of their frameworks and applications. Often for security reasons, software developers regularly update their products to make them more capable of avoiding or fending off attack of various kinds. New feature and integration delivery and updated compatibility requirements are also big drivers of software updates. Especially as online threats increase and attack potential skyrockets, businesses need to keep their systems updated and secure, and a regular cadence of updates and upgrades makes good sense… but only when the potential impacts of the upgrade have been thoroughly explored. With Windows 10 and 11 and the improved Edge browser (improved over IE), users are loving the enhancements and features. QuickBooks desktop users, on the other hand, might have preferred that Microsoft just leave Windows browsers alone.

The Internet Explorer 11 desktop application will be retired and go out of support on June 15, 2022

Microsoft is removing Internet Explorer 11 on some Windows 10 computers, and it doesn’t come with Windows 11. According to Microsoft:

The future of Internet Explorer (“IE”) on Windows 10 is in Microsoft Edge. What does this mean for commercial organizations, IT admins, developers, and end users? Microsoft Edge brings you a faster, more secure, and more modern web experience than Internet Explorer. Also, Microsoft Edge with Internet Explorer mode (“IE mode”), is the only browser with built-in compatibility for legacy IE-based sites and apps.

As announced today, Microsoft Edge with IE mode is officially replacing the Internet Explorer 11 desktop application on Windows 10. As a result, the Internet Explorer 11 desktop application will go out of support and be retired on June 15, 2022 for certain versions of Windows 10.

Internet Explorer 11 has been an old technology browser for many years now, so it isn’t surprising that Microsoft is moving ahead with Edge. Browsers are used for far more than just viewing static web pages or bulletin-board chat rooms, so they have grown into frameworks that support a wide variety of processes and procedures. As browsers go, IE11 just doesn’t cut it any longer. But there is a hitch that can really mess up the (literally) millions of QuickBooks desktop users out there who innocently update their computers when Microsoft pushes it via Windows update.

IE11 gets removed from the machine, but QuickBooks desktop 2021 and earlier are dependent on IE11 to run

A little dependency is unavoidable in any good relationship where cooperation and compromise are involved. But being a little too dependent on another can be unhealthy and put a lot of stress on the relationship. Dependencies are among the things to consider any time a software update or upgrade is about to be installed. What relationship does the software about to be updated have to other applications or services installed? Is the new version going to get along with the other applications on the system, or will it even run on the current system? These are the things which should be closely looked at to avoid problems post-update.

Many users are already reporting problems opening their QuickBooks desktop software due to IE being removed from their Windows 10 computers. Microsoft has announced the retirement of IE11, but most users either don’t pay attention to those notices or they don’t really understand the implications. These are among the things that Mendelson Consulting and the NOOBEH cloud services teams pay attention to for you, so that we can help you avoid the things that keep your business from doing business.

If you find that your QuickBooks desktop software will no longer run due to IE having been disabled or removed on your computer, you can link here to find instructions on how to disable and enable Internet Explorer on Windows 10. This will get IE re-installed on your computer so that you can make your QuickBooks desktop software work again.

QuickBooks Desktop 2022 versions are compatible with Windows 11 and Edge browser

QuickBooks Desktop 2022 versions, including Pro, Premier and Enterprise editions, are certified as fully compatible with Windows 11 64-bit, but only if you have installed R3 or later. Other year versions of QuickBooks (and QB 2022 desktop running a prior update release level) may experience unexpected issues including problems with browser compatibility.

What’s the benefit of modernizing if it breaks your business?

Updating application software often means also updating your operating platforms. To keep your business running smoothly, you need to make sure to keep your computers and your application software up to date. It makes no sense to fix a vulnerability in one place but leave another open. Yet sometimes your software vendors don’t do things in an order that works for you, and you end up breaking something that the business depends on. This is where companies find additional value in what Mendelson Consulting and NOOBEH cloud services offer.

For customers running their QuickBooks desktop applications on the Microsoft cloud with NOOBEH, we got you covered. Among the many benefits of working with Mendelson Consulting and NOOBEH cloud services is that we help keep your business software and systems working for you, not against you. We stay up to date with the latest changes to platforms and software systems to ensure that compatibility and performance isn’t compromised. We help businesses leave their old systems and migrate to modern, agile cloud platforms that businesses love.

jm bunny feetMake Sense?

J