1
async function generarEstadoMensual(orgId, merchantId, accountId, year, month, token) {
2
  // Calcular rango de fechas del mes
3
  const from = `${year}-${String(month).padStart(2, '0')}-01`;
4
  const lastDay = new Date(year, month, 0).getDate();
5
  const to = `${year}-${String(month).padStart(2, '0')}-${lastDay}`;
6
  
7
  console.log(`Generando estado de cuenta para ${from} a ${to}`);
8
  
9
  // Obtener primera página
10
  const response = await axios.get(
11
    `https://api.koywe.com/api/v1/organizations/${orgId}/merchants/${merchantId}/accounts/${accountId}/reports/ledger-statement`,
12
    {
13
      params: {
14
        from,
15
        to,
16
        granularity: 'monthly',
17
        limit: 100
18
      },
19
      headers: { 'Authorization': `Bearer ${token}` }
20
    }
21
  );
22
  
23
  const statement = response.data;
24
  
25
  // Resumen
26
  console.log('='.repeat(50));
27
  console.log('ESTADO DE CUENTA MENSUAL');
28
  console.log('='.repeat(50));
29
  console.log(`Cuenta: ${statement.accountId}`);
30
  console.log(`Moneda: ${statement.currency}`);
31
  console.log(`Período: ${statement.periodStart} a ${statement.periodEnd}`);
32
  console.log('-'.repeat(50));
33
  console.log(`Saldo Inicial: ${statement.openingBalance}`);
34
  console.log(`Saldo Final: ${statement.closingBalance}`);
35
  console.log('-'.repeat(50));
36
  
37
  // Calcular totales
38
  let totalCreditos = 0;
39
  let totalDebitos = 0;
40
  
41
  statement.movements.forEach(m => {
42
    const amount = parseFloat(m.amount);
43
    if (m.type === 'credit') {
44
      totalCreditos += amount;
45
    } else {
46
      totalDebitos += amount;
47
    }
48
    
49
    console.log(`${m.postedAt} | ${m.type.toUpperCase().padEnd(6)} | ${m.amount.padStart(15)} | ${m.category} | ${m.description.substring(0, 30)}`);
50
  });
51
  
52
  console.log('-'.repeat(50));
53
  console.log(`Total Créditos: ${totalCreditos.toFixed(2)}`);
54
  console.log(`Total Débitos: ${totalDebitos.toFixed(2)}`);
55
  console.log(`Cambio Neto: ${(totalCreditos - totalDebitos).toFixed(2)}`);
56
  console.log('='.repeat(50));
57
  
58
  return statement;
59
}
60
61
// Uso: Generar estado de enero 2025
62
const statement = await generarEstadoMensual(
63
  'org3_xxx',
64
  'mrc_xxx',
65
  'acc_xxx',
66
  2025,
67
  1,
68
  token
69
);