Exports¶
Detailed XLSX downloads for record-keeping, transition meetings, or audits. Both commands return ephemeral file attachments — only you see them in the channel.
/export_dues¶
Multi-sheet workbook covering one semester's dues activity.
Usage: /export_dues [semester_id]
| Argument | Required | Description |
|---|---|---|
semester_id |
no | Semester to export (e.g. spring-2026); defaults to current |
Sheets in the workbook:
| Sheet | Contents |
|---|---|
| Summary | One row per brother — name, room + share %, total owed, paid, deducted, remaining, # payments, # deductions, last payment date, status |
| Payments | Every payment row — ID, brother, amount, method, memo, receipt path, logged at, logged by, status, fulfilled-promise link |
| Deductions | ID, brother, amount, memo (the why), receipt, linked Slash txn, logged at, logged by, status |
| Promises | All statuses — ID, brother, amount, due date, status, note, reminder flags, linked payment, fulfilled at |
| Donations | ID, donor, amount, purpose, receipt, linked Slash txn |
| Rooms | Room → price → occupants → share % → their share $ → notes |
| Audit | Last 500 officer actions — time, actor, action, target, details |
Money columns are formatted as currency in the workbook so sums and filters work natively in Excel/Google Sheets.
/export_bank¶
Multi-sheet workbook of Slash transactions for a date window.
Usage: /export_bank [window]
| Argument | Required | Description |
|---|---|---|
window |
no | Past 7 days / Past 30 days / Current semester (default) / Year to date / All time (5y) |
Sheets:
| Sheet | Contents |
|---|---|
| Summary | Window dates, total transactions, inflows $, outflows $, net change, # with receipts, # missing receipts |
| Transactions | Every Slash txn — ID, posted date, description, merchant, amount, direction, status, MCC + category, Slash memo, our memo, purchased by, receipt path, card label + holder, account, location |
| By Category | MCC category → outflows → inflows → count, sorted by total |
| By Card | Card label → holder → total spend → count |
| By Merchant | Top 50 merchants by spend → count → category |
Run /sync before /export_bank
The bank export reads from the local Mongo mirror. To make sure it has the freshest data, run /sync before exporting if you want to be certain nothing's missing (e.g. if the webhook had a recent delivery hiccup).
File handling¶
Both commands stream the workbook directly to Discord — no temp files on the server. Discord's normal file size limit is 25 MB, which fits years of fraternity-scale data with room to spare.