Online Kardex: What It Is and How a Digital Stock Ledger Works

Online Kardex: What It Is and How a Digital Stock Ledger Works

When someone searches for an online kardex (stock ledger), they usually have a concrete idea in mind: seeing stock from anywhere, without depending on one specific computer or on a file that exists only in one office. The idea is reasonable, but the phrase is used for different things, and that is where the confusion starts. Some people call an online kardex the simple stock card kept in a program, even when that program is installed on a single machine and nobody else can see it. Others use the term when the record of entries, exits and balances lives in a system reached over the internet or over a network, so that several people and several locations read the same up-to-date information.

This article separates those two ideas, explains the technical paths that exist today for keeping a stock ledger with shared or remote access, and above all provides a concrete list of questions to review before deciding. It is not a product comparison or a catalogue: it is a guide so that any business owner, accountant or warehouse manager knows what they are buying, what they are giving up and what they should demand, no matter which provider they choose.

Transparency note: this article is published by the team that develops Kardex Tauro, an inventory and stock ledger program. That is why the explanations about our own product stay within what is documented in its configuration, and the rest of the text applies to any system on the market. If at some point it sounds as though we are describing a feature we do not have, it is best read as a general evaluation criterion and not as a promise.

What carrying the stock ledger online really means

The stock ledger is the stock card for an item: the column where entries, exits and the balance left after each movement are recorded. That card can be kept in many ways, and the word online describes one single thing: where the record lives and who can reach it. A stock ledger is online when the data is not locked inside a file isolated on one computer, but in a system reached over the internet or over the business network. The practical consequence is twofold: several people work on the same information at the same time, and several locations read the same balance without waiting for someone to send a file or dictate a number over the phone.

It is worth clarifying what it is not. It is not a prettier card or a report in a modern format. It is not, by itself, a sign that inventory is well controlled: an online stock ledger can be full of errors while a paper stock ledger is spotless. Nor does it mean the information is public or that anyone can see it; it means it is available to authorized people, from the machines that have a connection. And it does not necessarily mean a web version exists: a program installed on each computer can still be an online stock ledger if its database is shared or hosted so that everyone can reach it.

Paper stock ledger, digital stock ledger and online stock ledger: three different things

These three expressions get mixed up all the time, and confusing them leads to bad purchases. The simplest way to separate them is to ask where the record lives and how it reaches the hands of whoever needs it. A paper stock ledger lives on a physical card or in a notebook. A digital stock ledger lives in a system, even if that system sits on one computer. An online stock ledger is that same digital record placed within reach of several users or locations through a network. They are a staircase, not three separate worlds: you can climb one step without climbing all three.

The table shows something important: the jump from paper to digital improves the speed and accuracy of the calculation, while the jump from digital to online improves reach. They are different benefits and they are paid for in different ways. A small business with a single person in charge can stay perfectly well on the second step. A business with two locations that today passes balances over the phone gains a lot from the third.

The two technical paths that exist on the market

When it comes to keeping a stock ledger with shared or remote access, two paths can be seen on the market. They are not brands or products: they are architectures, and each one imposes its own advantages and its own limits. It is worth understanding them before deciding, because the technical decision is the one that later shapes everything else.

Path one: a program installed on each computer with the database shared or hosted

On this path the program is installed on every computer that will use it, and what is shared is the database. That database can live on the same machine, be shared on the business local network, or be hosted on a web server. The first two forms solve the work inside one location; the third is the one that enables access from any place with internet, because the database is no longer in the office but on a server the programs connect to. This is the path followed by Kardex Tauro and by many businesses with several branches or remote users, and it has a clear advantage: the program runs at full strength on each computer, and when the database is shared on the local network, work inside the location does not depend on the internet. Its limit is that the program must be installed and updated computer by computer, and that the quality of remote access depends on a network configuration done properly.

Path two: an application used inside the browser

On this path nothing is installed on the computers: the program lives on a server and the user signs in with a browser. Any computer with a connection will do, even a borrowed one or a freshly formatted one, and updates arrive on their own because there is a single version on the server. Its limit is complete dependence on the connection: if the internet goes down, there is no stock ledger in sight, unless the provider offers some mechanism for working offline, which is not the usual case. Add to that two questions the user does not control: where their data is and what happens to it if they decide to leave.

Neither path is better in the abstract. The first weighs more on control and on the ability to keep working inside the location; the second weighs more on convenience of access and ease of maintenance. The choice depends on the business, not on fashion.

There is a detail worth keeping in view: on the first path, the cloud is the database, not the program. In other words, the program stays installed on the computers; what sits on a server is the record everyone consults. That distinction matters because it explains how a business can have access from any place with internet without having changed programs. It also explains why the quality of the network and of the configuration weighs so much: if the database is hosted, every query travels to the server and back.

What to check before choosing any online stock ledger

This block is the heart of the article, and it applies to any provider, including Kardex Tauro. Before signing or migrating, it is worth asking these seven questions and keeping the answer in writing. If an answer is vague or dodged, you have already learned something important: the quality of the answer says more than the list of features.

Of those seven, the first deserves a paragraph of its own. The question about export is the one almost nobody asks and the one that costs the most. A stock ledger accumulates years of movements: there lies the real history of the business, the cost of what was sold, the trace of inventory differences. If that data can only be seen inside a platform and cannot be taken out in a format another system understands, the business is tied down. It is not a matter of distrust toward the provider, it is a matter of continuity: any company changes tools at some point, and any provider can change course.

The second question, whether the data belongs to the business, is usually answered just by looking at the first. The third forces a definition of what is written down, where, and how it is loaded afterwards, so that inventory does not end up with a hole. The fourth is the most technical and the most neglected: having backups is worth nothing if a restore has never been tested. The fifth and sixth go together, because permissions and the movement log are two sides of the same control: who may touch and who did touch. And the seventh is the one that decides whether the business can operate on a difficult day.

Security and backups: the minimum to demand

Remote access adds convenience and it also adds surface area for risk. Real problems usually do not come from sophisticated attacks, but from simple, well-known things: weak or shared passwords, connections without encryption, permissions open to everyone, and the absence of a backup held by the business itself. None of those four is solved by buying something; they are solved with concrete decisions taken once and reviewed from time to time.

• One password per person, not a general key that circulates around the counter.
• Encrypted connections, both for access from outside and on the internal network.
• Permissions by role: someone who only consults should not be able to modify, and someone who modifies should not be able to delete without leaving a trace.
• A movement log with user and date, readable by the owner without asking anyone for permission.
• A backup held by the business, in addition to whatever the provider does, stored somewhere other than where the database lives.
• A restore tested at least once, not just a folder of copy files.

The point about your own backup deserves emphasis because it is the most often skipped. When the database is hosted, it is tempting to think the copy is the responsibility of whoever hosts it. It may be, but the backup that saves a business is the one in its own hands and that someone on the team knows how to restore. A backup that was never tested is a promise, not a protection. The useful question is not whether copies exist, but when someone last recovered data from one.

When remote access is worth it and when it is not needed

Remote access is not an ornament every business must have. It is worth it when there are several locations that need to see the same balance, when the owner frequently checks from outside, when the warehouse and the office are separate and today communicate by phone, or when some users work from another place. In those cases the cost of configuration pays for itself: balances dictated over the phone disappear, along with the parallel spreadsheets and the arguments about which number is the true one.

And it is not needed when the business has a single location with a single person in charge, when movement is slow and fits in a well-kept notebook, or when nobody else is going to consult the information from anywhere else. In those cases, adding remote access brings a configuration to maintain and a risk to look after, without solving a problem that exists. A digital stock ledger on one computer, with orderly backups and one responsible person, can be the right answer for that business, and it is worth saying so without embarrassment.

There is an in-between case that shows up often: the business that works well in a single location today but plans to open a second one. There is no need to rush the whole configuration, but it is worth choosing from the start a system that can grow toward shared access without changing tools or losing the history already accumulated. Switching systems halfway usually costs more than having chosen well from the beginning.

Common mistakes when moving the stock ledger online

• Believing an online stock ledger fixes disorder. If the catalogue is badly built and movements are written down late, the online version only spreads the same wrong information faster.
• Migrating without reconciling the opening balance. The system starts with a number that does not match what is in the warehouse and everything after that is crooked.
• Giving the same user to everybody. Without individual users there is no way to know who moved what, and control is lost exactly when it is needed most.
• Confusing having information available with having it under control. Seeing the balance on the owner laptop is not the same as movements being properly recorded.
• Leaving backups in the hands of a single provider and never testing a restore.
• Buying for the flashiest feature instead of for export. The ability to take the data out is what decides how much a wrong choice costs.
• Forgetting the contingency plan for the day without a connection, and ending up with movements written on loose slips that nobody loads afterwards.

An honest closing

An online stock ledger is a way of keeping the record of stock, not a promise of automatic order. Before choosing any system it is worth being clear about three things: who owns the data, how it is taken out if the business changes course, and what is done on the day the connection fails. With those three answers in writing, the decision becomes much simpler, and also much harder to regret later.

About our own case, with the same frankness: Kardex Tauro allows the database to be configured in three ways, on the same computer, shared on the local network or hosted on a web server, and it is that third configuration that enables access from any location with internet, useful for companies with several branches or remote users. The program is installed on the computers; what lives in the cloud is the database, not a web version. If that fits the way your business works, it is worth a look; and if it does not, the questions in this article still serve to evaluate any other option with your own criteria.