Why Monetary Values Need a Currency Field, Not Text

Using a currency field rather than a text field is not a formatting preference. Formulas and automations cannot sum text, so a value stored as text is a value you cannot calculate with.

The mistake that breaks reporting later

Typing an amount with its symbol into a text field looks fine on screen and fails everywhere else.

Totals that cannot be calculated across records
Automations unable to compare an amount to a threshold
Approval routing by value impossible to configure
Inconsistent symbols and separators across records

Currency, number, or text

Field type	Calculable	Notes
Text	No	Cannot be summed or compared numerically
Number	Yes	Calculable, but the currency symbol is not standardized
Currency	Yes	Calculable, with a standard symbol across every record

How to configure it in Jestor

Add a column in Jestor and search for the currency field type.
Name the field — value, for example, on an accounts payable table.
Select the currency symbol that will apply to every record on that field.
Add a date field for the due date; plain date is usually better than date-and-time for payments.
Let OCR read the attached invoice and fill the value field automatically.

Why choose Jestor for financial data?

Jestor standardizes the symbol at field level, so every record in the table displays consistently without anyone typing it — and every value stays available to formulas and automations.

That consistency is what makes value-based approval thresholds work: a rule comparing an amount to a limit needs a real number behind it.

Frequently Asked Questions

Why not use a number field?

It calculates, but the currency symbol is not standardized across records.

Should due dates include a time?

Usually not — a plain date is enough for a payment. See jestor.com.

Can OCR fill the value field?

Yes, reading it from the attached invoice.

Video Tutorial: Step by Step

Check out other practical tutorials on the Jestor YouTube channel.

Get to know Jestor

With Jestor, you can automate workflows, connect teams, and build internal systems your way — all without code and powered by AI. Discover Jestor at jestor.com and see how to take your company's operations to a new level of efficiency and control.

How do you choose an AI tool for professional services operations teams in SMBs?

To choose an AI tool for professional services operations teams in SMBs, look for a platform that combines no-code tables for clients, engagements, and documents with AI features that answer messages, read documents, and summarize data, while keeping professionals in control of advice. In Jestor, these pieces work together,

How do you build a business continuity plan for a services firm?

To build a business continuity plan for a services firm, list critical processes and deadlines, identify risks such as system outages or key person absence, define backup options, assign roles, and test the plan. In Jestor, processes, risks, and actions are connected, so the firm keeps serving clients during disruptions.

What is the best way to run IT security awareness training for staff in a services firm?

A practical way to run IT security awareness training for staff in a services firm is to define short training modules, assign them to all staff, track completion, run simulated phishing tests, and schedule refreshers. In Jestor, staff, modules, and results are connected, so security habits become part of the

How do you route website lead forms to the right team in a services firm?

To route website lead forms to the right team in a services firm, ask for the service and company size in the form, route leads automatically to the right team, set response time targets, record follow-ups, and track conversion by source. In Jestor, forms, leads, and teams are connected,