Payment recognized next day

Questions
1

In transaction report, Square recognised below payment on June 17th but it should be recognised on 16th because customer is in newyork time zone and in new york it was June 16th 11:00 pm when this was created. What is the correct logic to handle this?

{
  "id": "hxyOtbLRUtSz5otKAJTbmhveV",
  "locationId": "3W9ZM7QAVRB2W",
  "tenders": [
   {
    "id": "liu32w31RAikki5qMm7SUlN0uaB",
    "locationId": "3W9ZM7QAVRB2W",
    "transactionId": "hxyOtbLRUtSz5otKAJTbmhveV",
    "createdAt": "2022-06-17T03:00:31Z",
    "amountMoney": {
     "amount": 118650,
     "currency": "CAD"
    },
    "tipMoney": {
     "amount": 0,
     "currency": "CAD"
    },
    "processingFeeMoney": {
     "amount": 3471,
     "currency": "CAD"
    },
    "customerId": "XG48T41YH97FQ9BWXKMTNT16TW",
    "type": "CARD",
    "cardDetails": {
     "status": "CAPTURED",
     "card": {
      "cardBrand": "MASTERCARD",
      "last4": "6503"
     },
     "entryMethod": "KEYED"
    },
    "payment": {
     "id": "liu32w31RAikki5qMm7SUlN0uaB",
     "createdAt": "2022-06-17T03:00:31.509Z",
     "updatedAt": "2022-06-17T03:00:35.604Z",
     "amountMoney": {
      "amount": 118650,
      "currency": "CAD"
     },
     "totalMoney": {
      "amount": 118650,
      "currency": "CAD"
     },
     "approvedMoney": {
      "amount": 118650,
      "currency": "CAD"
     },
     "processingFee": [
      {
       "effectiveAt": "2022-06-17T05:00:32.000Z",
       "type": "INITIAL",
       "amountMoney": {
        "amount": 3471,
        "currency": "CAD"
       }
      }
     ],
     "status": "COMPLETED",
     "sourceType": "CARD",
     "cardDetails": {
      "status": "CAPTURED",
      "card": {
       "cardBrand": "MASTERCARD",
       "last4": "6503",
       "expMonth": 3,
       "expYear": 2026,
       "fingerprint": "sq-1-g9B3q2amshpPtyc2L_HjIJUIrkVH7cDw3qxxNXewOYzqDR9sHUGlI_Vi61j8Ol83Cg",
       "cardType": "CREDIT",
       "prepaidType": "NOT_PREPAID",
       "bin": "557914"
      },
      "entryMethod": "KEYED",
      "cvvStatus": "CVV_ACCEPTED",
      "avsStatus": "AVS_ACCEPTED",
      "authResultCode": "00964X",
      "statementDescription": "SQ *RING COME TRUE",
      "cardPaymentTimeline": {
       "authorizedAt": "2022-06-17T03:00:32.195Z",
       "capturedAt": "2022-06-17T03:00:32.000Z"
      }
     },
     "locationId": "3W9ZM7QAVRB2W",
     "orderId": "hxyOtbLRUtSz5otKAJTbmhveV",
     "employeeId": "3W9ZM7QAVRB2W",
     "teamMemberId": "3W9ZM7QAVRB2W",
     "receiptNumber": "liu3",
     "receiptUrl": "https://squareup.com/receipt/preview/liu32w31RAikki5qMm7SUlN0uaB",
     "applicationDetails": {
      "squareProduct": "INVOICES",
      "applicationId": "sq0idp-Cf85mt46wI4zaxvAs2xIyw"
     },
     "versionToken": "2SAd3H1sAI8UR1eca8H7aby1qw1Ogv20EPqbgDvt7lD6o"
    }
   }
  ],
  "createdAt": "2022-06-17T03:00:31.000Z",
  "updatedAt": "2022-06-17T03:00:31.000Z",
  "state": "OPEN",
  "square_product": [
   "INVOICES"
  ]
 }
2

I’m seeing this payment being reported correctly on the 16th. Where are you seeing it reported on the 17th? Is it the date in the createdAt? If so that’s in UTC time and applying the offset for EST will put the time of payment on the 16th. :slightly_smiling_face:

3

@Bryan-Square I see it in the below screenshot on 17th June. If you see the card payment total is 2130.5.

But on 17th June, only these three payments should have been there. Their total is 934.5

image
image1896×736 70.9 KB

FEDfBDNaW3FztNlxolkMBnqxvaB 847.50
rREJXuJ6qXYiGo2jYBlKJ9KMuaB 56.50 and
FtfskYXa9CviGGrJqtpDot9eV 40.00

In Square’s report above and my sum I see difference of 1186.5. Which is exactly the part of liu32w31RAikki5qMm7SUlN0uaB I reported earlier. Its value is $1186.5 and it belongs to 16th.

There is nothing in payment object except processing fee timestamp to put this payment on 17th June. Can you suggest why Square is doing this?

Please the attached transaction report in the CSV format as exported from Square. (Sign In). It just shows $40. There is discrepancy in the screenshot and what we see in export and API.

Kindly help. If this is a bug on Square side or something else.