nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Quicken Business - how to print customer statement to Excel

ljspublic

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

Find more posts tagged with

Business

Invoices

Accepted answers

jujujuju

I set up a report using Transaction report as a start. Select the invoice account, the customer tag, and the desired date range.

All comments

ljspublic

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 much

jujujuju

I set up a report using Transaction report as a start. Select the invoice account, the customer tag, and the desired date range.

jujujuju

See my comment in the other sub-forum. You really don't need to post in both.

ljspublic

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].