Hi. I want a way of running a custom report on a daily basis, then loading the data into a googlesheets document. Is there a way of doing this, do you know?

Hello there, @caroline-armstro. Thank you for posting here.

You can customize a daily basis in total and make this your own customised report for your business. You can go to Reports on the left panel and search Profit and Loss in the search field.

Once done, continue following the steps below to accomplish the task:

1. In the report, click the Report period drop-down arrow. Then, select Today.
2. Select Customise button in the upper left corner.
3. Choose Cash for Accounting Method.
4. In the Filter section, select Distribution Account. Then, change from All Income/Expense Accounts (default) to All Income Accounts.
5. Go to Header/Footer and change Report Title from Profit and Loss to Daily Income (depending on you).
6. You can make further changes if needed.
7. Click Run Report.

QuickBooks will download reports to Excel (or PDF). Select or Export as Excel or  Export as PDF. Here's a sample screenshot for additional reference:

Another way is by going to the Sales tab. From there, you can view and print your daily income on money received (cash basis).

1. Go to Sales on the left panel.
2. In the All Sales tab, click Filter.
3. Under Type, select Money Received.
4. Under Date, select Today.
5. Click Apply to reflect the changes.
   

Still, it'll be exported to Excel. Also, you'll see the total at the very bottom of the screen below the Total column.

To learn more about recording daily sales in QBO, you can read through this article: Find out how to record your total daily sales in QuickBooks Online using a single sales receipt.

Let me know if you have other questions. I'm always here to continue to help you. Take care always!