1
async function generateMonthlyStatement(orgId, merchantId, accountId, year, month, token) {
2
  // Calculate date range for the month
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(`Generating statement for ${from} to ${to}`);
8
  
9
  // Fetch first page
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
  // Summary
26
  console.log('='.repeat(50));
27
  console.log('MONTHLY STATEMENT');
28
  console.log('='.repeat(50));
29
  console.log(`Account: ${statement.accountId}`);
30
  console.log(`Currency: ${statement.currency}`);
31
  console.log(`Period: ${statement.periodStart} to ${statement.periodEnd}`);
32
  console.log('-'.repeat(50));
33
  console.log(`Opening Balance: ${statement.openingBalance}`);
34
  console.log(`Closing Balance: ${statement.closingBalance}`);
35
  console.log('-'.repeat(50));
36
  
37
  // Calculate totals
38
  let totalCredits = 0;
39
  let totalDebits = 0;
40
  
41
  statement.movements.forEach(m => {
42
    const amount = parseFloat(m.amount);
43
    if (m.type === 'credit') {
44
      totalCredits += amount;
45
    } else {
46
      totalDebits += 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 Credits: ${totalCredits.toFixed(2)}`);
54
  console.log(`Total Debits: ${totalDebits.toFixed(2)}`);
55
  console.log(`Net Change: ${(totalCredits - totalDebits).toFixed(2)}`);
56
  console.log('='.repeat(50));
57
  
58
  return statement;
59
}
60
61
// Usage: Generate January 2025 statement
62
const statement = await generateMonthlyStatement(
63
  'org3_xxx',
64
  'mrc_xxx',
65
  'acc_xxx',
66
  2025,
67
  1,
68
  token
69
);