REGEXVAULTv2.0
Finance/Currency & Money
Verified Safe

Accounting Format (Negative in Parentheses) Regex for Python

/^(?:\((?:(?:[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 Python. 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 Python project — whether you're validating in a Django view, a FastAPI endpoint, or a standalone data processing script.

Python Implementation

Python
# Accounting Format (Negative in Parentheses)
# ReDoS-safe | RegexVault — Finance > Currency & Money

import re

accounting_format_negative_in_parentheses_pattern = re.compile(r'^(?:\((?:(?:[1-9][0-9]*(?:,[0-9]{3})*)|0)(?:\.[0-9]{1,2})?\)|(?:(?:[1-9][0-9]*(?:,[0-9]{3})*)|0)(?:\.[0-9]{1,2})?)$')

def validate_accounting_format_negative_in_parentheses(value: str) -> bool:
    return bool(accounting_format_negative_in_parentheses_pattern.fullmatch(value))

# Example
print(validate_accounting_format_negative_in_parentheses("1,234.56"))  # True

Test Cases

Matches (Valid)
Rejects (Invalid)
1,234.56-1,234.56
(1,234.56)()
0(1,234.567)
0.001,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 Python developers because particularly important in Python web servers where CPU-bound regex operations can stall concurrent request handling. 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