Tablora · Library
Review a DR-suffixed amount
A trailing DR is read as a negative marker, so 125.00 DR becomes -125.00. Confirm how your statement uses debit before you reconcile.
How DR becomes a minus
Many bank and ledger exports print entry direction as letters after the amount rather than as a sign. The normalizer supports the DR suffix in upper or lower case, with or without a space before it. It removes the letters and makes the amount negative. Its counterpart CR is removed and leaves the amount positive.
That mapping is a convention of this tool. Statements are written from the bank's point of view, ledgers from yours, and some systems print debits without any letters at all. Before you use the negative numbers in a reconciliation, check that DR really means money leaving the account you are looking at.
Only a suffix at the very end is read. Letters in front of the amount, as in DR 125.00, are not a supported pattern; that value is held for review with its original text.
Working through 125.00 DR
Set Decimal separator to . and Grouping separator to comma, choose the amount column in Number column and press Calculate. The source value 125.00 DR becomes -125.00. Converted cells counts it, and the output keeps two decimal places. A grouped value such as 1,250.00 DR under the same settings would become -1250.00.
Checks for a DR column
- Read the legend on the statement or the column note in the export before converting.
- Look for rows without any suffix: they are read as positive, which may not be what the document intends.
- Watch for values that already carry a minus or parentheses as well as DR. Those have two sign markers and are held for review rather than turned positive.
- Do not infer the type of every account from the letters alone; a DR on a credit card statement and on a current account can mean different things to you.
- Keep the original export, because the DR letters are gone from the converted cells.
Two things to know about the CSV download
Download (CSV) writes the converted table, but every cell that starts with a minus, plus, equals or at sign gets a leading apostrophe so that a spreadsheet will not treat it as a formula. A converted -125.00 therefore appears as '-125.00 in the file. If the receiving sheet needs numbers, remove the apostrophe or convert the column after import as a deliberate step.
In the Tablora app, the XLSX export reads DR the same way in columns it treats as numbers and writes a real negative number. If a DR cell is marked in amber, compare it with the source page first.
Original synthetic example
- Source value
- 125.00 DR
- Decimal separator
- .
- Grouping separator
- ,
- Expected outcome
- Normalized amount: -125.00