The future of small business is not dumbed-down big business
Why do Small and Mid-size Enterprises (SMEs) not have access to more efficient and affordable management systems?
Collections of spreadsheets, disconnected apps, and manual processes are wasteful, but upgrading to subscription packages with their endless line-up of modules and user fees can be ruinously expensive.
Big Tech's monopoly on advanced solutions is not inevitable, however. Sumer is a simple and inexpensive alternative designed to
assist managers in applying their existing knowledge to build their own integrated management systems.
SME managers are experts in their field. They model their business with forms and reports, and they can represent their entire business in spreadsheets. Software suppliers that ape big business methods by analyzing data structure and designing new interfaces only duplicate work already done by SME managers.
Sumer lets managers skip the expensive software packages to build their own system, no knowledge of IT required.
Nothing revolutionary here except attitude
Eveyone knows how business works. Activities like
buy something,
produce something,
sell something,
adjust inventory,
post to accounting
have been routine for thousands of years.
So seriously, with all our advances in technology—including now AI—we cannot create a tool to convert these basic patterns into a coordinated management platform?
Of course we can. Big Tech could have delivered something like Sumer 20 years ago.
The essential technology is the relational database*. Programmers know how to build them, SME managers don't. The inequality creates a cartel forcing managers to buy back their own systems that they created in the first place.
SME managers could build a complete management system for themselves—if they had a tool like Sumer.
* What is a relational database?
Relational databases are essential, but unless you are a programmer the details are not important. 'Relational database' just means a way to store data as a collection of data tables—price lists, inventory, sales invoices, accounting, etc.—all logically 'related' or linked.
Modular business packages are based on typical relational database schemes plus forms and reports standardized by type of business. SME subscribers need to fit their business into one of the packages available.
When you purchase a new module you are at the least buying new forms and reports that tap into existing tables, and you are possibly also adding new tables and links to the database.
But surprisingly, SME managers already have a relational database; it is virtual and intuitive and it is in their head. Managers already know how their data fits together; these are the 'relations' or links needed for a relational database.
With that information, Sumer can build a physical relational database automatically based on managers' spreadsheets, no need for IT experts to get involved.
The Big Tech promise... 'never do simple again'
Over-complication is a business tactic.
When Microsoft realized in the 1990s that they had made a terrible mistake with Excel and Word by improving them to the point that customers no longer needed yearly upgrades, they converted Office 365 into a subscription service. The modern Big Tech strategy was born, and no one would ever do simple again.
From social media to business management programs, high-tech solutions are designed to
- push subscription and advertising revenue,
- split off features into up-sale modules, extensions, and pay walls,
- ensure customers stay dependent on the software provider,
- keep customers' hands off the controls.
High Tech enjoys astonishing profits by adding extravagant subscription, module, and user fees.
Business data is low tech, however. In fact that is why this is called 'Sumer', because the Sumerians were doing it 6000 years ago.
The problem with a low-tech solution in a high-tech world is that it violates the goals of Big Tech, but if you don't have an issue with that, you should look at Sumer.
Simple is still here
Sumer is based on templates. Comparing templates with standard subscription modules, why buy modules if templates are free?
Modules are a marketing, not a technical, invention. The data underneath doesn't change, but modules are intended to split and repackage your data as forms and reports to sell back to you separately.
Sumer allows managers to create their own forms and reports. Spreadsheet-style setups are intuitive, and Sumer's library of existing templates can be easily customized.
How it works
The template behind this Price List is almost self-explanatory.
- Column names across the top, parameters down the left side. You probably recognize most of them.
- Add new columns—anything you want—with the 'AddColumn' button.
- Set DataType, Width, Alignment and so on. You can even add Filters and Formulas.
This price list can be recalled and used automatically in sales entry forms and reports.
Other forms for purchasing, production, sales, scheduling, and more have additional parameters, but all work the same way.
Linking is easy
Linking is the whole point of relational databases. This Cafe Sales Invoice demonstrates how easily Sumer links and posts data.
- All the columns are created with 'AddColumn' in the template.
- Columns with working information can be set to Hide, just as in spreadsheets.
- Columns 'Item' and 'Pcs' are set to 'AllowEdit'. All other columns come from the Price List or Expressions.
- The Expressions row can include formulas.
- The 'Item' column links the Popup row to 'Item', which is the name of the Price List we created earlier. This all it takes to tell Sumer to look up 'ItemName' and 'Price' from Price List.
- The FootRows set up Sub, Tax, and Total with formulas. The columns 'Dr' and 'Cr' instruct Sumer to post these totals to accounts 40100, 33300, and 12000 in the Sales Journal. If you don't yet have a Sales Journal, leave it off; you can add it later.
- The button 'Form Head' opens up the header panel for editing where we can link another Popup for 'Customer'.
Basically, that is it.
Hundreds of templates like this are already available in the Library so you can pull them into your business—free—and customize them however you like.