Standard software failing? Do not hire an IT consultant. Use our C4CAI to process, format, and automate custom data.

# Corrupted Sunday Class Log v0.8
DonorID,Full_Name,Phone,TitheAmt,EventDate,Note
"88231","John & Sarah Miller", "(555) 301-2911", "$150.00", "11/04/23", "Pledge"
"","deacon_robert", "555-8910", "1250", "2023-11-05T00:00", "Missing ID"
"88231","John Miller", "5553012911", "50", "04-11-2023", "DUPLICATE DONOR"
"NULL","Sister Abigail M.", "none", "ten dollars", "Last Sunday", "Cash basket"
"90412","Bro. Marcus Brody", "+1 (555) 441-2900", "$400.00", "11/12/2023", "Building Fund"
"90412","M. Brody", "555.441.2900", "$400.00", "Nov 12 23", "Re-entered row"
            

{
  "$schema": "c4c:universal.giving.v4",
  "batch_id": "bch_8829_validated",
  "records": [
    {
      "donor_uuid": "c4c_usr_88231",
      "display_name": "John & Sarah Miller",
      "phone_e164": "+15553012911",
      "contributions": [
        { "amount_cents": 15000, "date": "2023-11-04T00:00:00Z" },
        { "amount_cents": 5000, "date": "2023-11-04T00:00:00Z" }
      ],
      "reconciled_from": [ "row_1", "row_3" ]
    },
    {
      "donor_uuid": "c4c_usr_90412",
      "display_name": "Marcus Brody",
      "phone_e164": "+15554412900",
      "contributions": [
        { "amount_cents": 40000, "date": "2023-11-12T00:00:00Z" }
      ],
      "dedup_pass": true
    }
  ]
}