정산 CSV·전표 템플릿

month,paddle_transaction_id,paddle_subscription_id,internal_order_id,workspace_id,customer_country,payment_method_type,payment_currency,gross_amount,tax_amount,paddle_fee,refund_amount,net_amount,payout_id,book_fx_rate,krw_amount,exception_note
2026-05,txn_01,sub_01,ord_01,ws_01,KR,kakao_pay,KRW,29000,2636,1450,0,24914,po_01,1,24914,

payout_id,payout_date,balance_currency,payout_currency,paddle_net_amount,bank_received_amount,bank_fee,fx_margin_note,matched,exception_note
po_01,2026-05-31,USD,USD,7835.00,7820.00,15.00,,true,

-- Paddle transaction과 내부 주문 미매칭
select
  p.paddle_transaction_id,
  p.paddle_subscription_id,
  p.net_amount,
  p.payment_currency
from finance_paddle_transactions p
left join orders o on o.paddle_transaction_id = p.paddle_transaction_id
where p.month = :month
  and o.id is null;

-- payout별 합계와 은행 입금 대조
select
  payout_id,
  sum(net_amount) as transaction_net_sum,
  max(bank_received_amount) as bank_received_amount,
  sum(net_amount) - max(bank_received_amount) as diff
from finance_reconciliation
where month = :month
group by payout_id
having abs(sum(net_amount) - max(bank_received_amount)) > :tolerance;