Seems like you need a portal. I don't play Bingo like this so my ignorance may be showing here, but it looks like your "Payout" record could be treated like a sales invoice with each "strip" a line item that the customer purchased. If so, a portal to "strips sold" could be placed on your payout layout to list all such items and any payouts awarded to them. That would be for data entry or review on the screen. To print out a receipt or other report, you'd create a list view layout based on the "strips" table, but with other fields from the Payout table added to the header and a trailing grand summary (to show the total payout.).
Take a look at this simple Invoices demo created by Comment and just rename the first two tables "payout" and "Strips Purchases" to see if that works for you:
is there a way that I can send you links to see the current excel file screenshots that I am working with. or send you the excel file to look at.
Here are some screeners:
I see very complex layouts in your screen shots, but not being familiar with your business rules/procedures makes it hard to comment much on what I see.
It looks like you sell a variety of Bingo "games" to your customers and need to track both the sale of them and the winners/payouts. To me, the games you sell to your customers are your "products" that may or may not be purchased by a given customer. The games you sell to a specific customer would be itemized in LineItems and the sales transaction itself would be recorded in Invoices. (I'm referring to the demo file to which I posted a download link .)
You could then track winners to different games from a layout based on Line Items. Please note that you may not find it easy or practical to reproduce your excel formats in FileMaker. In Excel, it's easy to add additional columns as needed. It is not nearly so simple to do the same in FileMaker and still be able to work with the results. This often makes different layout formats a better alternative for FileMaker.