[Admin Tool Feature]: Forecast view for payouts (next 6 months)

[ssandino]

Is there an existing request for this feature?

• [X] I have searched the existing issues

Is your feature request related to a problem? Please describe.

It's currently difficult to assess how many payments are to be made in the coming months and, correspondingly, how much money will be needed. Since there are always some recipients being offboarded and onboarded, this number is constantly changing. However, it's crucial for assessing the required funds in the bank accounts in SL.

Describe the solution/feature

We need to add a new tile/view under the 'finance' tab in the admin tool. This tile should provide an overview of all Social Income payments to recipients for the next six months, resulting in a list with a total of six rows.

Example table with 3 columns (as of January 30th, 2024):

February 2024 / x Recipients / USD x March 2024 / x Recipients / USD x May 2024 / x Recipients / USD x June 2024 / x Recipients / USD x July 2024 / x Recipients / USD x August 2024 / x Recipients / USD x

(if current date is < 15th of the month then show the current month. Payments are always done on 15th.)

Calculations

Recipients x should count all active recipients of the respective month (calculated based on starting month) + all starting next payday (add them in current month if today is < 15th of month, otherwise to next month)

USD x should represent the product of recipients x multiplied by USD 32 (approximately the payout amount). Initially, this approximation should suffice, even though our payout amount is in SLE. We adjust it to USD 32 every few months.

Text for tile:

Describe alternatives you've considered

No response

Criteria for Completion

No response

Anything else?

There are currently two ways to make tables within a view in the admin tool. The standard way based on an existing FB collection (like recipient list) or the more versatile version like in Payments Confirmation. I guess the second makes more sense here, but not a requirement.

Code of Conduct

• [X] I've read the Code of Conduct and understand my responsibilities as a member of the Social Income community