UP↑SCALE › LABS, QUALITY & METROLOGY › AUDITORS & QA TEAMS › 21 CFR PART 11 AUDIT TRAIL

21 CFR Part 11 audit trail and data integrity for your lab balances

An audit trail is a secure, time-stamped record of who created, changed or deleted a record, when and why. An auditor asks three things about a balance: was it fit for use, is the record complete and unchanged, and who did what - and why? UP↑SCALE answers them in the scale itself, with a hash-chained activity log, sealed reports and signatures. Here is every control, mapped to 21 CFR Part 11, EU GMP Annex 11 and ALCOA+ - and what stays your part.

  • Who, when, what and why, kept in the scale
  • A tamper-evident SHA-256 hash chain
  • Mapped to Part 11, Annex 11 and ALCOA+, with the limits
  • Electronic signatures and audit trail reviews

In short

UP↑SCALE is one scale app for the balance you already have, on an RS-232 adapter. With ENTERPRISE & COMPLIANCE the scale keeps a tamper-evident audit trail of who did what, when and why, with signatures and reviews - mapped to 21 CFR Part 11, EU GMP Annex 11 and ALCOA+, with the limits. For regulated labs: 144.00 EUR a year or 599.00 EUR once per scale.

A tamper-evident audit trail in four layers ENTERPRISE

1The audit trail lives in the scale

Users, roles, protections, the test history and the activity log are kept in the scale, the same for every connected computer - not in one browser. Every change (calibration, settings, users, recipes, test results, reports, sales, stock) becomes an entry: who, when, what and - with strict audit - why. Calibration, density and every setting that changes the weight or the records keep the old and the new value. Entries can't be edited or deleted; the last 10,000 are kept.

2A SHA-256 hash chain

Each entry has a running number and contains the fingerprint of the entry before it. Change, remove or insert one entry, and every following fingerprint no longer fits - the check shows it. The sales log is a chain of its own.

3Record files, linked by hash

The app archives new entries while it is connected and saves them as record files (SAVE FOR THE RECORDS) with a printout of the fingerprint. Each file names the one before it - a missing or changed file is found by CHECK EXPORTED ARCHIVE FILES (🗂 RECORDS → ACTIVITY). With strict audit the scale stops changes, programs and sales before an entry would be overwritten unarchived. One archive device (a qualified PC) keeps the whole log and saves a sealed record file once a day by itself into your backed-up records share - only its archive frees entries on the scale, so the complete log is never split over several devices. The background rounds wait while a factory, check-weighing, sorting or fill program runs.

4The UP↑SCALE SEAL

Reports, PDF files, record files and exports are sealed: the UP↑SCALE signs their SHA-256 with its own key (ECDSA P-256), our licence key vouches for that scale, and the seal goes into the activity log. Anybody can check a sealed file on up-scales.com/check - in the browser, nothing is uploaded. Why it is called sealed and not signed: sealed or signed?

And the two points every audit asks about a connected balance - the clock and the storage of the records - are closed with the built-in device qualification.

The audit trail in the app

Every login, check, calibration (with its reason), review and sealed report with user and time - and the check that a sealed file is unchanged.

The activity log of the scale: logins, routine checks, a calibration with its reason, a signed audit-trail review and sealed reports - each with user and time
The activity log: who did what, and when
The check page: seal valid, the file is unchanged since the scale sealed it
Anybody can check it: seal valid, file unchanged

More about the app, with all screenshots →Screenshots of the real app with demo values - a screenshot may show the look of an older app version.

21 CFR Part 11 requirements checklist, point by point

Our reading of the controls of Part 11 and what the balance contributes. No software is "compliant" by itself - your validation and your SOPs decide. ✓ = technical control in place, ◐ = partly / with your procedure, ✍ = your part.

ClauseWhat it asks (in short)What UP↑SCALE does
11.10(a)validationbuilt-in validation of the calculations: reference cases from OIML R 76-1 run against the code, IQ/OQ record with code fingerprint; the validation of your system is yours◐
11.10(b)accurate and complete copies, readable and electronicreports as HTML and sealed PDF, record files (JSON), CSV / JSON exports✓
11.10(c)protection of records for their retentionhash chain, linked record files, seal; the storage (read-only, backed up) is yours - the device qualification sends every record there and records it◐
11.10(d)access limited to authorized peopleusers with login on every connection; a closed scale answers nobody else; the user access register (sealed PDF, signed electronically) shows who is authorized, by whom and since when✓
11.10(e)secure, time-stamped audit trail of create / modify / deleteactivity log in the scale with user, time, what and why, old and new value for calibration, density and the settings that change the weight or the records; the time comes from the device - locked and recorded with the device qualification, clock jumps logged by the scale◐
11.10(f)operational checks (order of steps)guided recipes and tests, only approved recipes run (gate), strict audit refuses changes without a reason✓
11.10(g)authority checksroles operator / user / QM / ADMIN; ADMIN gates for deleting and settings✓
11.10(h)device checks (valid source of data)the weight comes from the scale; the seal names the scale; no record from a dead link (the app locks after 1 s without data)✓
11.10(i)-(k)training, written policies, documentation controlthe public manual describes every control; training and SOPs are yours✍
11.50signature shows name, date / time and meaningsignatures with the meaning performed / reviewed / approved, name and time✓
11.70signature linked to its recordthe signature is tied to the hash of the report, checked against the log of the scale and its archive, and sealed✓
11.100signature unique to one person, never reuseda permanent user number per person that the scale never gives twice; the real name and the check of the identity in the user access register are yours, as is the statement to the FDA (11.100(c))◐
11.200two components: ID and passworduser + password, checked by the scale at every signature; passwords encrypted over the air✓
11.300password controlssalted hashes, never sent in plain text; a lock after 5 wrong passwords (logged, unlocked by an ADMIN), an optional maximum age, a password set by an ADMIN is changed at the first login, user numbers never reused (password rules); minimum length and complexity are set by your SOP✓

EU GMP Annex 11 computerised systems - the main points

PointWhat UP↑SCALE does
4 Validationvalidation of the calculations (IQ/OQ record); the system validation is yours◐
5 Datadata from the scale directly - no typing, no copy-paste✓
6 Accuracy checksthe scale checks every sale against its own weight; routine checks and the test suite for the balance✓
7 Data storage, backupsrecord files with fingerprints, CHECK EXPORTED ARCHIVE FILES; the download folder of every device = your WORM / backed-up storage, tested and recorded in the device qualification; the backup routine is yours◐
8 Printoutsnumbered, sealed reports✓
9 Audit trailsactivity log with reason (strict audit), old and new values, chained, archived; the regular review is signed by a QM on the scale (audit trail review)✓
12 Securityusers, roles, gates, encrypted passwords, encrypted Bluetooth link (AES-128, ECDH P-256 with a signed key per connection: nothing can be sniffed over the air), on ENTERPRISE only registered devices if you want; granting, changing and removing access is in the chained log, and the user access register with its signed review is a sealed PDF✓
14 Electronic signaturesignatures with meaning, linked to the record, checked by the scale✓

ALCOA+ principles of data integrity in practice

PrincipleHow
Attributableevery entry carries the logged-in user, and the user number belongs to one person forever (user access register)
Legibleplain reports, PDF and CSV - and the record files in JSON
Contemporaneouswritten when it happens, with the weighing - not typed in later; the clocks of the devices locked and qualified, jumps logged by the scale, optionally checked against the signed exact time
Originalthe weight of the scale; RS-232 EXACT WEIGHT keeps the value of a verified scale unchanged, and 🔏 LEGAL MODE stores every used line of the balance first, with its own number
Accurateroutine check, test suite, validated calculations
Completerunning numbers and the chain show gaps; lost entries are recorded
Consistentone sequence per scale, the same for every connected computer
Enduringrecord files linked by hash - straight to your read-only, backed-up storage (device qualification)
Availableexports any time; anybody can check a sealed file without the app

Compared with the usual ways

Balance + paper logbookBalance + PC softwareUP↑SCALE
Who / when / whysignature on paperyes, on the PCin the scale, for every connected device
Changes visiblecrossed outdepends on the vendorhash chain + seal, checkable by anybody
A PC at the balancenoyes, with its own validationno - phone, tablet or any computer
Coststimelicences per seat, often a yearly fee144.00 EUR a year or 599.00 EUR once per scale

What it saves in hours and subscriptions for a whole lab: the cost table of the QA guide.

Complete on the product side

Everything an audit can expect from a balance and its software is built in. These are the technical controls:

  • Audit trail in the scale: who, when, what and why, with the old and the new value, hash-chained, for every connected device (21 CFR Part 11 §11.10(e), Annex 11 §9).
  • Access: users with permanent numbers and roles, lockout after wrong passwords, password age, and QM-signed reviews of the access and of the audit trail (§11.10(d), (g), §11.300, Annex 11 §12).
  • Electronic signatures: name, date and meaning, checked by the scale and linked to the record (§11.50, §11.70).
  • Sealed records: reports, PDFs, record files and exports, which anybody can check on up-scales.com/check (§11.10(b), (c)).
  • Time and storage: the device qualification for the clock and the WORM storage, plus the clock guard of the scale with the signed exact time from up-scales.com as its reference.
  • Tests and maths: the test suite along OIML R 76-1, the routine check, and the validation of the calculations (IQ/OQ record).

What stays with you is what no product can do for you: your validation, your SOPs, training, checking who your users are, and the storage and time servers that your IT runs. The app brings the forms and templates for these too.

How it saves time:

  • For QA: the documents for the binder come out of the app, filled in by the app, sealed and with signature lines: device records, the user access register, the device register, test records, routine check logs, review records and the IQ/OQ record. You need no consultant for the paperwork, no extra validation package and no subscription.
  • For the auditor: checking a file takes a minute on the public check page, without an account or an upload. The reviews, the signatures and the log entry of every seal are in the records, so an auditor asks for a certain entry instead of leafing through paper logbooks.

Built to the expectations of 21 CFR Part 11, EU GMP Annex 11, ISO/IEC 17025, GLP and ALCOA+. No software is compliant by itself: compliance comes from your validated system together with your procedures. This is not a certification.

The limits - for your validation

  • Tamper-evident, not WORM: the memory of the scale and files on a disk can still be overwritten or deleted - but not unnoticed. The WORM part is your storage: the device qualification sends every record there and records it; keep the printed fingerprint of the newest file apart.
  • The log keeps the last 10,000 entries. With strict audit it is no rolling buffer: before an entry that no app has archived would be overwritten, the scale stops new sales, programs and changes until the app has archived the log - no entry is lost. Without strict audit older unarchived ones are overwritten (the lost numbers are recorded and shown).
  • An RS-232 adapter on several scales has one log for all of them. Each entry and each sale is assigned to the scale it was made on, and you choose this scale or everything of the adapter for lists, exports and reports; an extract of one scale goes to an auditor, the complete files stay the evidence for the chain. How it works.
  • The old and the new value are logged for the weight unit, the filters, zero tracking, the stable lock, d and the ranges, the RS-232 setup, the tare guard, the creep compensation, the environment filter, the heartbeat lock, the protections and the password rules; for the other settings (e.g. language, display, connections) only which one was changed, by whom, when and why.
  • The time comes from the device that runs the app - lock it to a time server and record it with the device qualification; the UP↑SCALE logs jumps of more than 2 minutes, not small ones. With one click it also takes the exact time signed by up-scales.com and checks the devices against it.
  • The seal does not prove unchanged firmware. A seal made outside the scale has no entry in your archived log - keep the archive.
  • Signatures are not qualified electronic signatures (no trust-service certificate) - sign the PDF with your own qualified tool if you need one.
  • Recipe approval covers recipes only, not THINGS or settings.

UP↑SCALE gives you technical controls and records - it makes no claim that you comply with a rule or that an auditor accepts them; this is not a certification. All details: for regulated laboratories. The page for laboratories →

Audit trail and data integrity: questions and answers

What is an audit trail in pharma and GMP laboratories?

A record, kept by the system itself, of who did what, when - and why - so every change to a record can be traced. For a balance with UP↑SCALE it is the activity log in the scale: every login, calibration, setting, user change, test result, report, sale and stock booking becomes an entry with user and time, and with strict audit the reason. Entries can not be edited or deleted on the scale.

What must an audit trail record according to 21 CFR Part 11?

In short (11.10(e)): a secure, time-stamped record of the actions that create, modify or delete electronic records. In UP↑SCALE every entry carries the user, the time and what was done; with strict audit a change without a reason is refused, and calibration, density and the settings that change the weight or the records keep the old and the new value. The time comes from the connected device, locked with the device qualification, and a SHA-256 hash chain shows any change to the trail itself.

Is the balance audit trail 21 CFR Part 11 compliant?

No software is compliant by itself - compliance comes from your validated system together with your SOPs. UP↑SCALE brings the technical controls Part 11 asks for: an audit trail in the scale with user, time, reason and the old and new value, access control with roles, electronic signatures linked to their record, and sealed copies. The table above maps them clause by clause.

What does ALCOA+ mean for a balance?

Attributable, legible, contemporaneous, original, accurate - plus complete, consistent, enduring and available. For a balance: every entry carries the user, is written with the weighing, keeps the weight of the scale, has a running number in one chain and goes into record files you can check without the app.

How does a hash chain show that a record was changed?

Each entry contains the SHA-256 fingerprint of the entry before it. Change, remove or insert one entry, and every following fingerprint no longer fits - the check shows where the chain breaks.

What is a tamper-evident audit trail?

One in which a changed, removed or inserted entry can not go unnoticed, even where the change itself can not be prevented. UP↑SCALE does it with running numbers and a SHA-256 hash chain in the scale, record files linked by hash and the UP↑SCALE SEAL, which anybody can check on up-scales.com/check. Tamper-evident is not WORM: write-once is a feature of your storage.

How is an audit trail review done?

A QM opens the audit trail review on the RECORDS page, reads the entries since the last review (changes with old and new values, refusals, logins, wrong passwords, clock jumps, device events), signs with the password and sets the next due date (1, 3, 6 or 12 months). The scale checks the password and writes the review into the hash-chained activity log with the number of the last reviewed entry; an overdue review is shown in red. ENTERPRISE.

What are the 21 CFR Part 11 requirements for electronic signatures?

In short: a signature shows the name, date and time and its meaning (11.50), is linked to its record (11.70), belongs to one person and is never reused (11.100), and has two components such as ID and password (11.200) with password controls (11.300). In UP↑SCALE a signature carries the meaning performed / reviewed / approved, the scale checks the password every time, ties the signature to the hash of the report and never gives a user number twice. They are not qualified electronic signatures.

How many entries does the audit trail keep?

The last 10,000 in the scale. With strict audit it is no rolling buffer: before an entry that no app has archived would be overwritten, the scale stops new sales, programs and changes until the app has archived the log.

Are the electronic signatures qualified signatures?

No. They carry name, time and meaning, the scale checks the password at every signature and links it to the record, but there is no certificate of a trust service. Sign the PDF with your own qualified tool if you need one.

Which changes are logged with the old and the new value?

The weight unit, the filters, zero tracking, the stable lock, d and the ranges, the RS-232 setup, the tare guard, the creep compensation, the environment filter, the heartbeat lock, the protections, the password rules - and calibration and density. Other settings (language, display, connections) are logged as which one changed, by whom, when and why.

Can the audit trail be deleted?

Entries can not be edited or deleted on the scale. It is tamper-evident, not WORM: the memory of the scale and files on a disk can still be overwritten or deleted, but not unnoticed. Keep the record files on write-protected storage - the device qualification records it.

What does balance software with an audit trail cost?

ENTERPRISE & COMPLIANCE costs 144.00 EUR a year or 599.00 EUR once per scale, with no fee per seat and no PC at the balance. Every scale can try it for 14 days for free.

Who else uses it

Auditors & QA teams

Labs, quality & metrology

Check the records of many scales in minutes instead of days: every file checks itself, the reviews and signatures are in the records, and the documents for the binder come out of the app.

Read →

Business & production

Business & production

Weighing scale software for shops, packers, kitchens and workshops: weigh, price, label, count, check and book on the scale you have - pay once.

Read →

Food producers & packers

Business & production

Fill, check and label your packs on the scale you already have - with the statistics and the ℮ lot report the inspector wants to see.

Read →

Manufacturers & workshops

Business & production

Count parts on several scales, sort by weight, fill molds and drive your filling machine with a cut-off that learns.

Read →

Shops, market stalls & farm shops

Business & production

Weigh, price, label and book in one step. The sales log lives on the scale - by day, product and user.

Read →

Owners of verified trade scales

Business & production

Keep your legal-for-trade scale exactly as it is - and add everything it never had. The adapter shows the exact weight of your scale and sends only what its keys do (tare, print) - or nothing at all.

Read →

Entrepreneurs & start-ups

Business & production

One device for 40+ jobs, start for under 15 EUR, pay once when it pays off - and grow to more scales and more phones without a new system.

Read →

Cannabis social clubs (Germany)

Business & production

The KCanG documentation, done while you weigh: harvest, drying, dispensing and destruction on one lot, with member ID and THC / CBD.

Read →

Cannabis shops, edibles kitchens & small sellers

Business & production

Jars with a QR code, the exact price of every gram taken out, labels for the bag, an inventory that shows what "evaporated" - and the dose of every edible.

Read →

Laboratories & pharmacies

Labs, quality & metrology

The compounding assistant from master formula to signed batch record, routine checks before use, a full test suite and records you can prove: users, roles, reasons, a hash-chained audit trail and sealed reports.

Read →

Compounding assistant

Labs, quality & metrology

The formula step by step on your balance: every component within its tolerance, the container checked, signed records.

Read →

Sealed records & checks

Labs, quality & metrology

The seal of the scale, signatures, the hash chain, what auditors check and the validated calculations - in one place.

Read →

Sealed or signed?

Labs, quality & metrology

The seal of the scale and the signature of a person: what each one says and how anybody checks it.

Read →

Tamper-evident records

Labs, quality & metrology

Audit trail, hash chain, numbered records, the LEGAL MODE store - and the controls an audit expects.

Read →

LIMS, ELN & sensors

Labs, quality & metrology

Every weighing to your LIMS or ELN, room values next to it, air buoyancy corrected.

Read →

Records & validation: more pages

The same app, for other work

Every function is in the same app - at home, in business and in the lab. All functions at a glance.

Last updated · by Johann Anderson, FARM 23 SL

READY TO UP↑SCALE YOUR SCALE?

Start with the free version - the board costs under 15 EUR and you may never need more. If you do, unlock PRO from 4.43 EUR a month, 46.90 EUR a year or once for 119.90 EUR incl. VAT - or ENTERPRISE & COMPLIANCE from 13.00 EUR a month (once: 599.00 EUR). The lifetime licences are once and forever, no subscription needed; no advertisements, everything works offline, updates stay free.