You could build a list with following headers:
Date - Type - In - Out - Total Gross - Total Net

Using SUMIF for example or SUMIFS ( if that exists in Office for Mac), you can extract date for each month and type or, better still using a Pivot Table

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post