Today: Nov 28, 2025

Collections & Settlements Overview

Real-time view of today's collections, pending validations, settlements, and risk indicators.

TODAY'S COLLECTIONS
Posted & confirmed
1,254,820
▲ +12.4% vs yesterday 312 transactions
PENDING VALIDATIONS
Online & bank deposits
38
18 beyond 24 hours Target < 12 hrs
UNPOSTED ORS
Printed but not yet synced
12
5 more than 1 day old View list
OVERDUE SETTLEMENTS
Plans past due schedule
64
₱ 842,350 at risk View accounts

Collections by Channel · Today

Distribution of confirmed payments

OTC
Online
Bank
Over-the-Counter ₱ 720,000
Online Gateway ₱ 380,000
Bank Deposit / OTC partner ₱ 154,820
Channel mix vs target: more online collections recommended. Channel breakdown report

Finance Alerts

Issues requiring follow-up

5 open
3 ORs voided without linked reversal
Check OR #2025-1139, 2025-1144, 2025-1150 for proper adjustment.
2 duplicate online transactions detected
Student nos. 23-104532, 24-200118. Tag one as reversal after validation.
Bank credit unmatched
₱ 45,000 in BDO 101-2243-552 not yet linked to a student account.
Go to Exceptions Console →

Recently Posted Payments

Last 10 transactions

Go to Payment Validation →
Time Student Student No. Channel Amount OR No. Cashier
08:21 AM Dela Cruz, Maria 25-101234 OTC - Cash ₱ 18,500.00 2025-11021 Cashier 01
08:30 AM Reyes, John 24-201188 Online Gateway ₱ 12,000.00 2025-11022 Auto-OR
08:44 AM Santos, Liza 23-108765 Bank Deposit ₱ 9,800.00 2025-11023 Cashier 02

Payment Validation Console

Validate student payments from bank, online gateways, and manual uploads before posting to the ledger.

Validation Queue · Double-check details before posting
Selected: 0
Ref No. Student Student No. Channel Date Amount Status Actions
PG-2025-554892 Reyes, Ana 23-104532 Online Gateway 2025-11-28 ₱ 12,000.00 For Validation
BDO-DEP-88921 N/A — Bank Deposit 2025-11-27 ₱ 25,000.00 For Validation
PG-2025-555002 Dela Cruz, Maria 25-101234 Online Gateway 2025-11-27 ₱ 18,000.00 Validated
OTC-2025-1188 Santos, Liza 23-108765 OTC Partner 2025-11-26 ₱ 9,800.00 Rejected

Official Receipts Registry

Track OR issuance, reprinting, voiding, and linkage to student accounts.

OR No. Student Student No. Date Amount Mode Status Actions
2025-11021 Dela Cruz, Maria 25-101234 2025-11-28 ₱ 18,500.00 Cash Posted
2025-11022 Reyes, John 24-201188 2025-11-28 ₱ 12,000.00 Online Posted
2025-11023 Santos, Liza 23-108765 2025-11-27 ₱ 9,800.00 Bank Draft
Showing 1–20 of 240 ORs

Cashiering Logs & Shift Closures

Monitor cashier shifts, over/short tracking, and daily closures

to
Closed Open Issue
Cashier Shift Time In / Time Out Beginning Cash Total Collections Declared Cash Over/Short Status Actions
Cashier 01 - Santos Shift 01 07:00 AM – 03:00 PM ₱ 5,000.00 ₱ 125,000.00 ₱ 125,000.00 ₱ 0.00 Closed
Cashier 02 - Reyes Shift 02 03:00 PM – 11:00 PM ₱ 5,000.00 ₱ 98,500.00 ₱ 98,200.00 -₱ 300.00 Issue
Cashier 03 - Garcia Shift 01 07:00 AM – 03:00 PM ₱ 5,000.00 ₱ 87,250.00 ₱ 87,400.00 +₱ 150.00 Closed
Cashier 01 - Santos Shift 02 03:00 PM – (Open) ₱ 5,000.00 ₱ 45,600.00 – – Open
Cashier 04 - Cruz Shift 01 07:00 AM – 03:00 PM ₱ 5,000.00 ₱ 112,300.00 ₱ 112,300.00 ₱ 0.00 Closed
Showing 1–10 of 85 shifts

Settlements & Promissory Notes

Installment plans, payment commitments, and promissory tracking

Ref No. Student Student No. Total Amount Balance Next Due Status Actions
PN-2025-0042 Dela Cruz, Maria 25-101234 ₱ 45,000.00 ₱ 22,500.00 Jun 15, 2025 On Track
PN-2025-0038 Reyes, John Carlo 24-201188 ₱ 38,500.00 ₱ 28,500.00 May 30, 2025 Overdue
PN-2025-0035 Santos, Liza Mae 23-108765 ₱ 52,000.00 ₱ 13,000.00 Jun 01, 2025 On Track
PN-2025-0029 Garcia, Miguel 24-305521 ₱ 28,000.00 ₱ 0.00 – Completed
PN-2025-0025 Torres, Anna 23-207892 ₱ 35,500.00 ₱ 35,500.00 Apr 15, 2025 Defaulted
Showing 1–20 of 156 settlements

Reconciliation & Bank Matching

Bank deposits vs Skolaris collections matching

to

Summary

Bank Skolaris Difference
Total Deposits ₱ 2,450,000.00 ₱ 2,485,000.00 -₱ 35,000.00
Matched ₱ 2,380,000.00 ₱ 2,380,000.00 ₱ 0.00
Unmatched ₱ 70,000.00 ₱ 105,000.00 -₱ 35,000.00
Match Rate 97.1%
Pending Items 12

Unmatched Transactions

Bank
May 28, 2025
Online Transfer - REF#88291
₱ 25,000.00
Bank
May 27, 2025
Cash Deposit
₱ 45,000.00
Skolaris
May 28, 2025
OR-2025-11089 - Cash Payment
₱ 18,500.00
Skolaris
May 27, 2025
OR-2025-11072 - GCash
₱ 12,000.00
Skolaris
May 26, 2025
OR-2025-11065 - Bank Transfer
₱ 35,000.00

Student Ledger Lookup

Account balance, payment history, and statement of account

Dela Cruz, Maria Santos

25-101234

BS Information Technology - 3rd Year

Total Assessment ₱ 52,500.00
Total Paid ₱ 35,000.00
Balance ₱ 17,500.00
Status Good Standing

Account Ledger - 1st Sem 2025-2026

Date Ref # Description Debit Credit Balance
Aug 15, 2025 ASM-001234 Tuition Fee Assessment ₱ 35,000.00 – ₱ 35,000.00
Aug 15, 2025 ASM-001234 Miscellaneous Fees ₱ 12,500.00 – ₱ 47,500.00
Aug 15, 2025 ASM-001234 Laboratory Fee ₱ 5,000.00 – ₱ 52,500.00
Aug 20, 2025 OR-2025-08542 Cash Payment - Enrollment – ₱ 20,000.00 ₱ 32,500.00
Sep 15, 2025 OR-2025-09128 GCash Payment – ₱ 10,000.00 ₱ 22,500.00
Oct 10, 2025 OR-2025-10089 Bank Transfer - BDO – ₱ 5,000.00 ₱ 17,500.00

Exceptions & Discrepancies Console

Payment anomalies, duplicate entries, and finance review queue

3 Critical
8 High
15 Medium
24 Low
Case ID Type Student / Ref Amount Severity Status Owner Actions
EXC-2025-0089 Duplicate Payment Dela Cruz, Maria (25-101234) ₱ 18,500.00 Critical Open Finance Head
EXC-2025-0088 Amount Mismatch OR-2025-11021 ₱ 2,500.00 High In Review Cashier 01
EXC-2025-0085 Missing OR Santos, Liza (23-108765) ₱ 9,800.00 Medium In Review Cashier 02
EXC-2025-0082 Refund Request Reyes, John (24-201188) ₱ 5,000.00 High Escalated Director
EXC-2025-0078 Unposted Payment Garcia, Miguel (24-305521) ₱ 12,000.00 Low Resolved Cashier 01
Showing 1–20 of 50 cases

Accounts & Settlements Center Settings

Configure OR series, payment channels, and validation rules

OR Series & Printers

Current OR Series
2025-00001 to 2025-99999
Last OR Issued
OR-2025-11089
Default Printer
EPSON LQ-310 (Cashier 1)
Auto-Print OR

Payment Channels

Cash Active
Bank Transfer Active
GCash Active
Maya Active
Credit Card Inactive

Validation & Risk Rules

Auto-validate below
₱ 10,000.00
Require approval above
₱ 50,000.00
Duplicate Detection
Amount Variance Alert
± 5%