Accounting export: QuickBooks, Xero, Tally

// journal.mjs: yesterday's fee receipts as journal lines, for QuickBooks, Xero or Tally import.
import fs from "node:fs/promises"

const headers = { Authorization: `Bearer ${process.env.SCHOOL360_KEY}` }
// School360 payment method → the ledger account the money went into
const DEBIT = { cash: "Cash in Hand", "bank-deposit": "HBL Current A/C", ibft: "HBL Current A/C", jazzcash: "JazzCash Wallet", easypaisa: "Easypaisa Wallet" }
const FEES = "Tuition Fee Income"
const FINES = "Late Fine Income"

const day = new Date(Date.now() - 86_400_000).toLocaleDateString("en-CA", { timeZone: "Asia/Karachi" }) // YYYY-MM-DD
const rows = [["Date", "Journal No", "Account", "Debit", "Credit", "Memo"]]
let cursor = null
do {
  const q = new URLSearchParams({ from: day, to: day, limit: "200", ...(cursor ? { cursor } : {}) })
  const res = await fetch(`https://api.school360.cloud/v1/receipts?${q}`, { headers })
  const page = await res.json()
  if (!res.ok) throw new Error(`${res.status} ${page.error.code}`)
  for (const r of page.data) {
    if (r.cancelled) continue
    const memo = [r.number, r.reference].filter(Boolean).join(" ")
    rows.push([r.receivedOn, r.number, DEBIT[r.method] ?? "Suspense", r.amount, "", memo])
    rows.push([r.receivedOn, r.number, FEES, "", r.amount - r.lateFine, memo])
    if (r.lateFine > 0) rows.push([r.receivedOn, r.number, FINES, "", r.lateFine, memo])
  }
  cursor = page.hasMore ? page.nextCursor : null
} while (cursor)

const csv = rows.map((r) => r.map((v) => (/[",\n]/.test(String(v)) ? `"${String(v).replace(/"/g, '""')}"` : v)).join(",")).join("\n")
await fs.writeFile(`journal-${day}.csv`, csv + "\n")

# journal.py: yesterday's fee receipts as journal lines, for QuickBooks, Xero or Tally import.
import csv, os
from datetime import datetime, timedelta
from zoneinfo import ZoneInfo
import requests

api = requests.Session()
api.headers["Authorization"] = f"Bearer {os.environ['SCHOOL360_KEY']}"
DEBIT = {"cash": "Cash in Hand", "bank-deposit": "HBL Current A/C", "ibft": "HBL Current A/C",
         "jazzcash": "JazzCash Wallet", "easypaisa": "Easypaisa Wallet"}

day = (datetime.now(ZoneInfo("Asia/Karachi")) - timedelta(days=1)).date().isoformat()
with open(f"journal-{day}.csv", "w", newline="") as f:
    out = csv.writer(f)
    out.writerow(["Date", "Journal No", "Account", "Debit", "Credit", "Memo"])
    cursor = None
    while True:
        params = {"from": day, "to": day, "limit": 200, **({"cursor": cursor} if cursor else {})}
        res = api.get("https://api.school360.cloud/v1/receipts", params=params, timeout=30)
        res.raise_for_status()
        page = res.json()
        for r in page["data"]:
            if r["cancelled"]:
                continue
            memo = " ".join(filter(None, [r["number"], r["reference"]]))
            out.writerow([r["receivedOn"], r["number"], DEBIT.get(r["method"], "Suspense"), r["amount"], "", memo])
            out.writerow([r["receivedOn"], r["number"], "Tuition Fee Income", "", r["amount"] - r["lateFine"], memo])
            if r["lateFine"] > 0:
                out.writerow([r["receivedOn"], r["number"], "Late Fine Income", "", r["lateFine"], memo])
        if not page["hasMore"]:
            break
        cursor = page["nextCursor"]