Student billing report

This site is best viewed in a modern browser with JavaScript enabled.

SaschaMa

Hello, probably I'm just blind :-)
When I enter the monthly school fees already in advance, but set the due dates in the future, I have the open but not yet due amounts already calculated on the student's total. This is of course annoying when you just want to see if a student has any outstanding amounts. Or am I doing something wrong?
Thank you!

francoisjacquet

Hello SaschaMa

You are right, the Total fees amount does not take in account the due date.
It is a matter of choice, and I understand in your case this is not what you would expect.
I did not design the original module, but here is how I would understand the logic:
Since the Fee is assigned (see Assigned date), it is due and can be paid, right?
The Due date is only a soft limit, indicating a date after which you are late.
This understanding of the Due date would contradict your view. Am I right?

SaschaMa

Yes, it is actually about finding out (for overdue notices) which students (actually the parents) have not yet paid their bill. This means that all the amounts for which the due date has passed should be added together. On the other hand, all payments of the student would have to be added up. If the amount of the payments exceeds the amount of the due invoices, this would be displayed as a minus amount and a reminder could be sent immediately. Of course, this would be great if you could send reminders with the amount due directly from a module.

SaschaMa

Where are my manners...sorry:

Hello Francoisjacquet!

francoisjacquet

Hello SaschaMa

Sure, you can send Payment reminders using the Email Parents or the Email Students module.

Hirama666

Hello @francoisjacquet , Please, is it available that we admins of the system can set an alarm, daily or weekly by sending Payment reminders within Rosariosis, i mean without using emails, so when the parent open his account he could find a reminder letter ( Notification ).
I heard about like a countdown timer, showed in the main page of the system, so the parent will be aware Whenever you open the system.

Please think bout this development
Thank you

nnmanobala

Hello @francoisjacquet sometimes if a student is unable to pay the entire fees for the specific school year he/she is allowed to make the payment in the subsequent year. How should a rollover be performed to carry forward the pending dues of a student into the next school year?

Thank you.

francoisjacquet

Hello nnmanobala

There is no Rollover yet for the billing fees, but we can think of a new "Student Billing - Balance" checkbox on the form (whether outstanding or not does not matter).
This can be added as part of the Student Billing Premium module.
If you wish to sponsor the development, please contact us at https://www.rosariosis.org/services/

Hirama666

Oh This is really a good idea, and a very useful Update for our lovely system.

nnmanobala

Hello @francoisjacquet I've modified the query at 2 places, by removing the year condition in StudentBalances.php file and it fulfills my business requirement. But thank you for the prompt response, greatly appreciated.

francoisjacquet

nnmanobala thank you for letting me know your solution.

I have added a "Cumulative Balance over school years" checkbox to the Student Balances program that does just that
The enhancement will come in version 10.3, cheers!