To view all payments received over a specified period, select "Accounts - Payments".
You can export this data into a spreadsheet by clicking on the "export" button. See screenshots below.
Select your date range and "download"
Similar to the export of invoices issued, column headers have filters pre-added for easily filtering your data to, for example, show only Cash received for the period, or Card transactions, or Bank Transfers only.
Here's how to get a similar export of Invoices issued over a particular period.