This issue occurs when donation records are imported using a CSV/TSV file that includes comma separators in numeric fields. Apsona processes import files using standard CSV rules, where commas represent column breaks.
When a value such as 1,000 is included in the amount column, Apsona interprets the comma as a delimiter rather than part of the number. For example:
1,000 is read as 1 (amount) and 000 (a new field)
20,000 becomes 20 with the remaining digits shifted or ignored
Because of this implicit split, the donation amount becomes truncated and imports incorrectly—even though no validation or mapping errors appear.
How to resolve the issue:
Remove commas from numeric fields before starting the import. Valid formats include:
1000
1000.00
25000
25000.00
Once formatting is corrected, Apsona will import the full donation amount as expected.
Best practices to avoid this issue:
Ensure amount fields contain plain numbers only (no commas or currency symbols)
In the Import Wizard, verify values in Step 2 to confirm correct formatting before running the import
Review the file in a text editor if numbers appear differently than expected in Excel
Key takeaway:
Large donation amounts are truncated because commas are treated as column separators in CSV data. Removing commas before upload ensures accurate import results and eliminates the need for manual entry of high-value donations.