Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks. Explore QuickBooks Payroll
goodtimes2day
Level 1

Exporting expenses with the payment account column included

Hi Everyone,

When I go to expenses and include all the columns before exporting to excel, I do not see the Payment Account (that's only available when I click on the expense to open for the detail) as an option.  I'm doing some auditing, so it would be really helpful to not have to click one by one.  Little help?

Thanks!

3 Comments 3
Mark_R
Moderator

Exporting expenses with the payment account column included

It's good to see you here in the Community, @goodtimes2day.

 

I'm here to help export your expense transactions with the payment account column included.

 

Since the payment account column isn't included in the Expenses menu, you can run and customize the Transaction List by Vendor report and export it to an Excel file. Here's how:

 

  1. Sign in to your QuickBooks Online (QBO) account.
  2. Click Reports from the left menu.
  3. Search for the Transaction List by Vendor report.
  4. From the Report period drop-down, select the date range you want to show on the report.
  5. Choose Account from the Group by drop-down.
  6. Click Customize.
  7. Go to the Filter section and choose Expense from the Transaction Type drop-down.
  8. Click Run report.

 

Once done, you'll be able to see your expense transactions with the payment account column. Then, you can now export it by clicking the Export icon and selecting Export to Excel.

 

You might also want to view all your sales transactions in QuickBooks Online. You can go to the Sales menu and choose All sales.

 

Please let me know if you need further help running and exporting the report, or if there's anything else I can do for you. I'll be standing by for your response, @goodtimes2day.

goodtimes2day
Level 1

Exporting expenses with the payment account column included

It worked perfectly!  Thanks!  

LieraMarie_A
QuickBooks Team

Exporting expenses with the payment account column included

Hi there, @goodtimes2day.

 

I'm glad that my colleague was able to help you with your expense transactions. Please know that we're always here if you need more help.

 

Looking forward to be able to help you in the future.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us