Quicken Business - how to print customer statement to Excel
ljspublic
Member ✭✭
Suspect I'm missing something obvious. Have monthly invoices/payments for several years for some customers. Statement format is fine for print. Need to get this info to Excel. Statements aren't considered reports. Don't see how to do this. What am I missing??? Thanks very much
0
Best Answer
-
I set up a report using Transaction report as a start. Select the invoice account, the customer tag, and the desired date range.2
Answers
-
Hope I'm missing something obvious. Have monthly invoices/payments for several years for some customers. Statement format is fine for print. Need to get this info to Excel. Statements aren't considered Quicken reports. Don't see how to do this. What am I missing??? Thanks very much0
-
I set up a report using Transaction report as a start. Select the invoice account, the customer tag, and the desired date range.2
-
See my comment in the other sub-forum. You really don't need to post in both.0
-
THANK YOU!! This saved me hours. I've customized most reports. Forgot that Quicken uses "payee" for "customer" for "description." As you suggested, I set up rpt with Transactions, A/R, dates. Not sure what how you're thinking about using "customer tag" - like for a sales territory? We carry some specifics in "memo" field [maybe too much for a free-form field]. 1
This discussion has been closed.