정산 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,remittance_reference,book_fx_rate,krw_amount,exception_note
2026-08,txn_01,sub_01,ord_01,ws_01,KR,kakao_pay,KRW,29000,2636,1450,0,24914,REM-2026-08-001,1,24914,

remittance_reference,balance_movement_date,balance_movement_type,balance_currency,balance_movement_in_balance_currency,remittance_amount,bank_received_amount,bank_fee,matched,exception_note
REM-2026-08-001,2026-08-12,transaction,USD,7835.00,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
  remittance_reference,
  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 remittance_reference
having abs(sum(net_amount) - max(bank_received_amount)) > :tolerance;