Automating quarterly YTD balances for clients

Let me help you with your concern, Jessgp.

You can pull up the Transaction List by Customer/Member report, customize it to show quarterly information, and filter it to one member. Then, memorize the report, and you can set it up for a scheduled email. 

First, pull up the report. Here's how:

1. Click Reports.
2. Enter Transaction List by Customer/Member in the Find report by name field.
3. Click Customize.
4. Go to Filter.
5. Click the Customer or Member drop-down arrow, then select the member.
6. Click Run report. 

Next, change the dates to show quarterly information. Then, click Save customization and fill in the necessary fields.

After creating it, go to the Custom reports tab so you can set up the scheduled report. Here's how:

1. Select the customized report, then click Edit.
2. Turn on the Set email schedule option.
3. Set up the schedule and enter the member's email information.
4. Click Save and close.

You'll have to create a customized report for each member. For more information, you can check this article: Memorize reports in QuickBooks Online.

We're just around to help you. Feel free to visit us again. We're just one post away. 

would that need to be done for each member? If there were only a couple that would not be an issue but if there are a hundred or more then its something else entirely.

Thanks for coming back, jessgp.

It depends on how many members you're trying to run the report. We can choose All, Specified, or manually selecting multiple customers. If you'll need to run a hundred or more members, just choose the Select All option then manually uncheck some customers who are not included in the report.

Here's how:

1. Click Reports on the left side menu.
2. Enter Transaction List by Customer/Member in the Find report by name field.
3. Tap the Customize button. 
4. Select the date in the Report period field. 
5. Go to Filter and choose Customer or Member.
6. Tap the drop-down button and hit the Select All option then uncheck the members not included in the report. 
7. Click Run report. 

See the Customize reports in QuickBooks Online (QBO) article for more detail about modifying your reports. Feel free to visit our Reports page for more insights about creating and managing your financial reports.

I'll be right here to continue helping if you need a hand with running your business in your account. Assistance is just a post away.