Tablora · Library
Review a CR-suffixed amount
A trailing CR is read as an explicit positive marker, so 125.00 CR becomes 125.00. Check what credit means in your own export before relying on it.
How the CR suffix is read
Bank statements and ledger exports often print the direction of an entry as letters after the amount: CR for credit and DR for debit. The normalizer supports both. It removes a trailing CR, in upper or lower case and with or without a space, and keeps the amount positive. It does not mark the cell in any other way, so the information that this was a credit lives only in your source or in another column.
That positive reading is a parsing convention, not a statement about money. Whether a credit increases or reduces a balance depends on whose books you are reading: a credit on a bank statement and a credit in your own ledger can point in opposite directions.
Converting 125.00 CR
With Decimal separator set to . and Grouping separator set to comma, the source value 125.00 CR becomes 125.00. The two decimal places are kept as written. If the same column contains 125.00 DR, that one becomes -125.00, so a mixed CR and DR column turns into signed numbers you can add.
Lowercase cr, and a value written as 125.00CR without a space, give the same result.
Checks before you trust the sign
- Read the statement legend or the account type to confirm what CR means for this export.
- Make sure the column shows CR or DR on every row; an amount with no suffix is read as positive, which may not match the document.
- Keep a copy of the original column, because after conversion the CR letters are gone from the output.
- Do not add a minus by hand to a CR value. A value such as -125.00 CR carries two sign markers and is held for review rather than converted.
- If the export puts CR and DR in a separate column instead of after the amount, the normalizer cannot combine the two columns. Apply the sign in your spreadsheet after conversion, using the direction column as the rule.
Suffix handling in the Tablora app
When you read a statement from a PDF, photo or scan in the Tablora app, the XLSX export applies the same convention to columns it treats as numbers: CR is removed with no sign change and DR makes the amount negative. Because a photographed C can be misread, look at any amber cell marked as one to check, compare it with the Source · page view and correct it before you export.
If your reconciliation needs credits as negatives, change the signs in your spreadsheet as a deliberate step after export rather than editing the source text.
Original synthetic example
- Source value
- 125.00 CR
- Decimal separator
- .
- Grouping separator
- ,
- Expected outcome
- Normalized amount: 125.00