In your downloaded payout statement (see how), you'll be able to use the Donation ID column as the common link between that statement and the relevant downloaded donation statement. (Use the Donation Date to guide you for downloading the correct month's donation statement (see how).)
When your payout statement(s) and donation statement(s) are downloaded and opened, you'll be able to match these by using a VLOOKUP formula.
Open a new Google sheet, then copy and paste the payout statement data in Sheet1 tab. Paste the donation statement data in Sheet2 tab.
In Sheet2, remove all columns not required (NB: keep column A), then copy the remaining column titles you wish to use, e.g. Donor First Name, Donor Last Name etc. to column I1 of Sheet1.
In column I2 of Sheet1, below Donor First Name, use this formula:
=arrayformula(vlookup(lookup_value,SheetName!range,{col_index_num},false)
- lookup_value: The cell in Sheet1 with the value you want to search for (should be A2).
- SheetName!: The exact name of your second tab, e.g. Sheet2, followed by an exclamation mark.
- range: The extent of the columns and rows to consider on Sheet2, e.g. A:Y.
- col_index_num: The column numbers in Sheet2's range containing the answer you want to pull back, e.g. column D will be 4, column E will be 5 etc. (The range of numbers will depend on the number of columns you kept in Sheet2).
- false: Forces an exact match.
So your formula should look like this:
=arrayformula(vlookup(A2,Sheet2!A:Y,{4,5,6,7,8,9,10,11,12,13},false))
It should now populate the data from Sheet2 on Sheet 1 in Row2. Drag the formula down to the rows below it on Sheet1, to populate those rows as well.