Month: January 2025

Posted on

PayPal monthly summary SQL

SELECT 
    substr(Date, 7, 4) || '-' || substr(Date, 1, 2) AS month,
    SUM(gross) AS total_gross,
    SUM(fee) AS total_fee
FROM "PayPal_2024_01_01-2024_12_31_"
WHERE Type = 'Subscription Payment'
GROUP BY month
ORDER BY month;
Posted on

Stripe monthly summary SQL

SELECT 
    strftime('%Y-%m', created_utc) AS month,
    SUM(CASE WHEN gross < 0 THEN gross ELSE 0 END) AS total_recurring_fee,
    SUM(CASE WHEN gross > 0 THEN gross ELSE 0 END) AS total_charged_amount,
    SUM(fee) AS total_merchant_fees
FROM "Stripe_2024_01_01-2024_12_31"
WHERE strftime('%Y', created_utc) = '2024'
GROUP BY month
ORDER BY month;

Posted on

DrBenjaminKang.com

his previous card stolen.

on Jan 3, 2025, Stripe charge failed, and Dr. Benjamin Kang texted me above card for monthly pay (1/3/2035).

Posted on

고객 as of 2025 01 03

PayPal

  • sun jung – NumberOneMoving.net
  • key express Inc – CNJTrucking.com
  • andrews kim – BestApplianceHVAC.com

Zelle

  • YuniHairStudioMD.com

Check mail in

  • WSAWellnessCenter.com
  • PrimaFinancial.com
  • BudgetPawnBrokers.com
  • DrGabrielKang.com

Stripe

  • 24명

3 + 1 + 4 + 24 = 32

34 – 삼보 – CJMovingUS = 32

32개 + RichChicHair.com = 33개 (as of 1/3/2025)

33개 + SalonJackie808.com (1/10) = 34개

  • 우인순 씨, HairStudioPSC.com (1/17)
  • 이가자 Garden Grove, LeekajaHairGardenGrove.com (1/17)
  • HairSketchBeautySalon.com (1/28)
  • SharonMoving24.com (2/14)
  • YuniHairStudioMD.com 소개 케이스 (2/15/2025)
  • RichChicHair.com 소개 케이스
  • Park Jun Hair TX (1/13)
  • WSAWellness 소개 케이스
  • 안세희 사장
  • 모나리자 스킨 케어
  • Hailey Skin Care
  • 4UnailsNJ.com

JSAcu.com cancel as of Jan 2025 request.

naturestouchacupuncture.com cancel

cnjtrucking.com cancel requested on 2/19/2025.

goldstar2424moving.com cancelled on 3/3/2025.

firstfuneralhome.com want to cancel after March 2025 pay.

Yoast

  • 02/22 – SharonMoving.com
  • 05/10 – NCDaeHanExpress.com
  • 01/27 – MooHanMoving.com (Stripe)
  • 03/23 – KoreanExpressGroup.com (Stripe)
  • 05/01 – AsiaExpressMoving.com
  • 07/22 – KindlyTaxi.com (Stripe)
  • 07/23 – WooriTaxiNJ.com
  • 08/05 – MySwiftTaxi.com (Stripe)
  • 09/04 – Goldstar2424Moving.com (Stripe)
  • 09/09 – HappyTaxiNJ.com

blue fonts – cancelled; should cancel upcoming charge.