cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about connecting your bank and credit cards in QuickBooks Online
anne-esperehealt
Level 2

Can I produce an Excel format statement of account in QuickBooks online?

Most customers want Monthly Statements of Account in Excel but the New --> Customers --> Statement option sends them a pdf. At the moment I'm running the Accounts receivable ageing detail, filtering it to a specific customer, exporting it to Excel, re-doing the formulae and then sending it as an attachment. I can't do this for the 100 odd customers so I do it for a handful but it's a pain. Is there a way to do this in bulk from QuickBooks?

1 REPLY 1
JamesDuanT
Moderator

Can I produce an Excel format statement of account in QuickBooks online?

Currently, QuickBooks Online only allows customer statements to be generated in PDF format, Anne. I appreciate you using the Accounts Receivable Aging Detail report as a workaround.

 

While filtering the report for a specific customer and exporting it to Excel is an option, it done individually for each customer. To help enhance the functionality of customer statements such as enabling Excel exports, I encourage you to share your feedback with our product development team. This gives them ideas for better customization to suit your business needs. Here's how you can do that:

 

  1. Click the Settings (gear icon) in the upper-right corner.
  2. Under the PROFILE section, select Feedback.
  3. Write your suggestions or requests in the Feedback box.
  4. Click Next to submit your input.

 

On another note, you can check other third-party applications online that can convert PDF to Excel with ease.

 

Please don't hesitate to comment below if you have any additional questions or concerns. We're always here to help.

Need to get in touch?

Contact us