Skip to content

Instantly share code, notes, and snippets.

@sitch
Last active December 10, 2020 14:31
Show Gist options
  • Select an option

  • Save sitch/7bac5408bab09b2d758644e5df362c25 to your computer and use it in GitHub Desktop.

Select an option

Save sitch/7bac5408bab09b2d758644e5df362c25 to your computer and use it in GitHub Desktop.
Sample Json for OCR receipt output (https://www.veryfi.com/receipt-ocr-api/) and Plaid Transaction (https://plaid.com/docs/transactions/)
{
"account_id": "BxBXxLj1m4HMXBm9WZZmCWVbPjX16EHwv99vp",
"amount": 2307.21,
"iso_currency_code": "USD",
"unofficial_currency_code": null,
"category": ["Shops", "Computers and Electronics"],
"category_id": "19013000",
"date": "2017-01-29",
"authorized_date": "2017-01-27",
"location": {
"address": "300 Post St",
"city": "San Francisco",
"region": "CA",
"postal_code": "94108",
"country": "US",
"lat": 40.740352,
"lon": -74.001761,
"store_number": "1235"
},
"name": "Apple Store",
"merchant_name": "Apple",
"payment_meta": {
"by_order_of": null,
"payee": null,
"payer": null,
"payment_method": null,
"payment_processor": null,
"ppd_id": null,
"reason": null,
"reference_number": null
},
"payment_channel": "in store",
"pending": false,
"pending_transaction_id": null,
"account_owner": null,
"transaction_id": "lPNjeW1nR6CDn5okmGQ6hEpMo4lLNoSrzqDje",
"transaction_code": null,
"transaction_type": "place"
}
{
"account_number": "",
"bill_to": {
"address": "",
"name": ""
},
"category": "Job Supplies",
"created_date": "2020-05-22 06:17:50",
"currency_code": "USD",
"date": "2018-10-17 09:03:00",
"discount": 0,
"due_date": "",
"external_id": "",
"id": 29054185,
"img_file_name": "ceb916d3-2ebe-4277-9d47-bc5f1499fcb0.png",
"img_thumbnail_url": "https://cdn.veryfi.com/receipts/ceb916d3-2ebe-4277-9d47-bc5f1499fcb0_2_t.png",
"img_url": "https://cdn.veryfi.com/receipts/ceb916d3-2ebe-4277-9d47-bc5f1499fcb0.png",
"invoice_number": "17717",
"line_items": [
{
"date": "",
"description": "SNIP LEFT <A>\nWISS LEFT-CUT SNIPS",
"discount": 4,
"order": 0,
"price": 0,
"quantity": 1,
"reference": "",
"sku": "037103136480",
"tax": 0,
"tax_rate": 0,
"total": 9.97,
"type": "purchase",
"unit_of_measure": ""
},
{
"date": "",
"description": "MILW5PCKBLDG <A>\nMKE 5PK GENERAL PURPOSE BLADES",
"discount": 0,
"order": 1,
"price": 0,
"quantity": 1,
"reference": "",
"sku": "045242268061",
"tax": 0,
"tax_rate": 0,
"total": 1.18,
"type": "purchase",
"unit_of_measure": ""
},
{
"date": "",
"description": "1LB. SCREW <A>\nEB NEO SELF-DRILLING 12X1",
"discount": 0,
"order": 2,
"price": 0,
"quantity": 1,
"reference": "",
"sku": "038902058966",
"tax": 0,
"tax_rate": 0,
"total": 10.57,
"type": "purchase",
"unit_of_measure": ""
},
{
"date": "",
"description": "1LB. SCREW <A>\nEB NEO SELF-DRILLING 12X3/4",
"discount": 0,
"order": 3,
"price": 0,
"quantity": 1,
"reference": "",
"sku": "038902058959",
"tax": 0,
"tax_rate": 0,
"total": 10.57,
"type": "purchase",
"unit_of_measure": ""
}
],
"ocr_text": "HOME\nTHE\nDEPOT\nMore saving.\n® More doing.\"\n2250 SOUTHGATE RD, COLORADO SPRINGS, CO\nBECKY NATION STOREMANAGER 719-471-0054\n1518 00000 17717 10/17/18 09:03 AM\nSELF CHECK OUT\n037103136480 SNIP LEFT <A>\t9.97\nWISS LEFT-CUT SNIPS\nNLP Savings $4.00\n045242268061 MILW5PCKBLDG <A>\t1.18\nMKE 5PK GENERAL PURPOSE BLADES\n038902058966 1LB. SCREW <A>\t10.57\nEB NEO SELF-DRILLING 12X1\n038902058959 1LB. SCREW <A>\t10.57\nEB NEO SELF-DRILLING 12X3/4\nSUBTOTAL\t32.29\nSALES TAX\t2.66\nTOTAL\t$34.95\nXXXXXXXXXXXX7373 VISA\n\tUSD$ 34.95\nAUTH CODE 025972/8585391\tTA\nAID A0000003131010 43415050544140204F4\nE452050595341\n",
"payment": {
"card_number": "7373",
"display_name": "Visa ***7373",
"type": "visa"
},
"payment_terms": "",
"phone_number": "719-471-0054",
"purchase_order_number": "",
"reference_number": "VBBAF-4185",
"service_end_date": "",
"service_start_date": "",
"ship_to": {
"name": ""
},
"shipping": 0,
"subtotal": 32.29,
"tax": 2.66,
"tax_lines": [
{
"name": "SALES",
"order": 0,
"rate": 0,
"total": 2.66
}
],
"tip": 0,
"total": 34.95,
"vendor": {
"abn_number": "",
"account_number": "",
"address": "2250 Southgate Rd, Colorado Springs, CO 80906",
"bank_name": "",
"bank_number": "",
"fax_number": "",
"iban": "",
"logo": "https://cdn.veryfi.com/logos/us/051435926.jpg",
"map_url": "https://www.google.com/maps/search/?api=1&query=The+Home+Depot+2250+Southgate+Rd,+Colorado+Springs,+CO+80906",
"name": "The Home Depot",
"phone_number": "719-471-0054",
"raw_name": "Home Depot",
"type": [
"nurseries & gardening",
"appliances",
"hardware stores"
]
},
"skip_update": true
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment