ChrisChen/ROLAC
1
0
Fork 0
Code Issues 66 Pull Requests Actions Packages Projects Releases Wiki Activity

[P1][Expense] Monthly reconciliation statement (MonthlyStatement) #29

New Issue
Open
opened 2026-05-26 01:33:05 +00:00 by ChrisChen · 0 comments
ChrisChen commented 2026-05-26 01:33:05 +00:00
Owner
Copy Link
Copy Source

Overview

Month-end financial closure: compare computed book balance (giving minus expenses) against bank statement balance.

Formula

Opening Balance + Total Giving + Other Income - Total Expenses = Calculated Closing vs Bank Statement Balance

Data Model

MonthlyStatement: year, month, opening_balance, total_giving (auto), total_other_income (manual), total_expenses (auto, Paid only), calculated_closing, bank_statement_balance (manual), difference, status (Draft/Reconciled)

Tasks

  • MonthlyStatement table + EF entity
  • Reconciliation UI showing the full formula
  • Difference highlighted red if not zero
  • Lock (Reconciled status) prevents editing after confirmation
  • Audit Log entry on reconciliation

Reference

PLANNING.md Section 3.6d - MonthlyStatement table and formula

## Overview Month-end financial closure: compare computed book balance (giving minus expenses) against bank statement balance. ## Formula Opening Balance + Total Giving + Other Income - Total Expenses = Calculated Closing vs Bank Statement Balance ## Data Model MonthlyStatement: year, month, opening_balance, total_giving (auto), total_other_income (manual), total_expenses (auto, Paid only), calculated_closing, bank_statement_balance (manual), difference, status (Draft/Reconciled) ## Tasks - [ ] MonthlyStatement table + EF entity - [ ] Reconciliation UI showing the full formula - [ ] Difference highlighted red if not zero - [ ] Lock (Reconciled status) prevents editing after confirmation - [ ] Audit Log entry on reconciliation ## Reference PLANNING.md Section 3.6d - MonthlyStatement table and formula
ChrisChen added this to the Phase 1 - MVP milestone 2026-05-26 01:33:05 +00:00
ChrisChen added the module: expense label 2026-05-26 01:33:05 +00:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
module: ai
AI integration (Claude API, Phase 5)
 module: attendance
Sunday attendance tracking
 module: audit-log
Immutable audit log
 module: auth
Authentication, JWT, ASP.NET Identity
 module: cell-groups
Cell groups, meetings, attendance
 module: cms
Public website CMS (rolac.org, bilingual)
 module: devops
Infrastructure, Docker, CI/CD, Jenkins
 module: expense
Expense tracking and reimbursements
 module: giving
Donations, tithing, annual receipts
 module: members
Member CRUD, family units, search
 module: prayer
Prayer requests and visibility scopes
 module: rbac
Roles, permissions, Ministry Scope
 module: reports
Reports and analytics
 module: roster
Service roster and scheduling
No Label module: expense
Milestone
No items
No Milestone Phase 1 - MVP
Projects
Clear projects
No project
Assignees
Clear assignees
ChrisChen
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: ChrisChen/ROLAC#29
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?