Help with Creating a Team Manager Database

Hi.

If I’m not asking too much, could someone help me with the following database?

Here’s the scenario:
I am team manager for two girls soccer teams. Both are the same age group of girls, but one is the A team, the second is the B team. In our club, they are both 08(year they were born) teams and their team IDs are TK and NM.
So the A team is 08 NM
B team is 08 TK

There are approx. 18 girls on each team and for the most part, the 08 NM roster always plays together, and the 08 TK roster plays together. When we play at tournaments, this can change. Some of the 08 NM girls may play for the 08 TK team, and vice versa. Also, we may have guest players.

As a club, each player has club fees, uniform costs, and registration costs that should be the same for each player (but can be different).

Also, every tournament has its costs that players are responsible for. I add all the costs, such as the tournament registration cost for the team and coaches travel expenses together and divide that figure based on the amount of girls going to the tournament. There will always be one registration cost per team for each tournament so that gets divided between the amount of girls in that team. But sometimes if both teams are going to the same tournament, then the coaches travel expenses will be divided by girls from both teams. So, for example, if the 08 NM and the 08 TK team are both going out of town to the same tournament, then we would all split the coaches travel fees. ($400 divided by 18 vs. $400 divided by 36)

I want to be able to record these things:
First, the players info. Name, team they are on, Jersey #, people related to them (I’ll explain why in a minute).

Second, I want to keep track of Costs and Fees. I need to be able to list what fees are charged for each season. Examples: How much registration was, uniform was, etc.
I want to know what tournaments we attended and what the cost was to be in the tournament. I want to be able to show who played at each tournament (that will give me the number to divide the cost by)

Third, and most important, I want to track what each player owes and what each player was a part of. Somewhat an attendance record for each player.

My main goal is to be able to say, Player 1 owes me $X amount of money. This is because Player 1 was in this tournament, which was on this day, and costs this much. I would like to be able to track each time Player 1 makes a payment, how much, for what, and her balance. A register of each players transactions so when a parent asks me “what do I owe” I can answer “you owe this much because of these reasons and you paid me on these dates so far”.

Right now, my method is not great at all of keeping track and I am getting worried I am not going to be able to get on top of this problem if I don’t make a change now. That’s why I am begging for help.

I accept payments from parents mainly through my bank and the parents use zelle. So, this is great because I can go back and look through transaction to see who paid when. But, I do this manually each time a parent asks and it’s so much work. I have to search for their parents name on the bank site( this is why I wanted people to record who is related to each player) so, maybe if was automated this task, I could pick Player 1 to find their payments and automatically it knows to include Player 1’s moms name and dads name into the search.

Is there a way to use a script to automatically retrieve the statements from my bank (my bank allows downloads of statements in a .csv output that I can upload to tapforms.) and have 5he statements refresh and update each players payments log or record?

I’m sure this was a lot to read and maybe too much to ask help with. But, if anybody can help and make my life easier while managing two teams, I know the staff , owner, and dedicated people who monitor these forums are the smartest people ever and can help me.

There’s probably things I missed that may cause confusion, but please ask. I can better describe anything.

Thanks for your time.
Can’t wait to see if someone will help.

Yvette