TabloraKeep three different data types distinct
An amount is a number, an account code is usually an identifier, and a date needs a calendar interpretation. An identifier such as 00125 should not become 125 merely because the spreadsheet decides it looks numeric.
Likewise, a blank amount is not automatically zero. It might mean missing, inapplicable or an empty printed cell. Preserve that distinction until you understand the document's convention.
Check locale and sign conventions
A source can use 1,234.56 or 1.234,56 for the same amount. A lone 1.234 is ambiguous without context. Compare column labels, nearby examples and the source's convention before deciding what it represents.
Parentheses can indicate a negative amount in some statements. A percentage displayed as 12% may be stored as 0.12 with percentage formatting. Check how your target application treats it rather than changing the appearance alone.
Use totals as a cross-check, then inspect rows
If the source provides a meaningful total, compare it with the extracted values using the same scope. Exclude subtotals or carry-forward rows when the document's structure requires that. Matching totals are useful, but two offsetting errors can still cancel.
Tablora understands several number conventions and lets you edit extracted cells. Use the original page beside the preview, check uncertain readings and inspect the XLSX or CSV after export. Extraction does not prove that an original invoice or statement was correct.
- Compare complete records, including their identifiers.
- Check dates around month/day ambiguities.
- Keep a record of material corrections.
- Test a small import before moving a large dataset.