CleanStack
DashboardNew PipelineTemplates
TemplatesFinance Report Normalizer
Finance77 uses

Finance Report Normalizer

Standardizes bank statement and expense report exports: numeric amounts, datetime transactions, fills uncategorized entries.

Expected Input Schema

date·str
amount·str
account·str
category·str
currency·str
description·str

Transform Rules (5)

1
type castamounttarget_type: float

Financial amounts must be numeric for sum, average, and variance calculations.

2
type castdatetarget_type: datetime

Transaction dates need ISO format for period-over-period comparison.

3
fill nullscategoryvalue: Uncategorized

Missing categories break budget reports — a default keeps rows usable.

4
trim whitespace
description

Bank export descriptions have irregular whitespace from legacy systems.

5
filteramountvalue: 0, operator: neq

Zero-amount transactions are typically system-generated artifacts with no business value.