Accounting Format (Negative in Parentheses) Regex for JavaScript
/^(?:\((?:(?:[1-9][0-9]*(?:,[0-9]{3})*)|0)(?:\.[0-9]{1,2})?\)|(?:(?:[1-9][0-9]*(?:,[0-9]{3})*)|0)(?:\.[0-9]{1,2})?)$/What this pattern does
This page provides a comprehensive, battle-tested regular expression for matching accounting format (negative in parentheses), ported and verified for JavaScript. Financial data validation has zero tolerance for false negatives — a missed invalid entry can corrupt downstream calculations. The snippet below is ready to drop into your JavaScript project — whether you're validating in an Express middleware, a Next.js API route, or a client-side form.
Javascript Implementation
// Accounting Format (Negative in Parentheses)
// ReDoS-safe | RegexVault — Finance > Currency & Money
const accountingFormatNegativeInParenthesesRegex = /^(?:\((?:(?:[1-9][0-9]*(?:,[0-9]{3})*)|0)(?:\.[0-9]{1,2})?\)|(?:(?:[1-9][0-9]*(?:,[0-9]{3})*)|0)(?:\.[0-9]{1,2})?)$/;
function validateAccountingFormatNegativeInParentheses(input: string): boolean {
return accountingFormatNegativeInParenthesesRegex.test(input);
}
// Example
console.log(validateAccountingFormatNegativeInParentheses("1,234.56")); // trueTest Cases
Matches (Valid) | Rejects (Invalid) |
|---|---|
1,234.56 | -1,234.56 |
(1,234.56) | () |
0 | (1,234.567) |
0.00 | 1,234.56) |
(500.00) | (1,234.56 |
1000 | ($100) |
When to use this pattern
This pattern is drawn from the Finance > Currency & Money category and carries a ReDoS-safe certification. That matters for JavaScript developers because especially critical in long-running Node.js event loops where a ReDoS vulnerability can block the entire process. RegexVault audits patterns against known backtracking attack vectors, ensuring you have the necessary context before using this regex in a high-stakes production environment.
Common Pitfalls
Not all financial systems use parentheses for negatives. Some use CR/DR suffixes. Confirm the convention before parsing.
Technical Notes
Standard accounting/financial statement format. Parentheses denote debit or loss depending on context. Strip parentheses and negate when converting to numeric type for calculation.
Have a pattern that belongs in the vault?
Submit it for review — community-verified patterns get credited to your GitHub handle. Free submissions join the queue. Priority review available for $15.
Submit a Pattern