Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hello,
Every time I use the "export to excel" feature for bank transactions, the payee column is blank. All other data exports correctly. The column "Payee" is present but no information is imported.
Please advise.
Regards,
Paul
I know the reason why the Payee column is blank, Paul.
It's possible that you've exported bank transactions from the Categorized page. It's the reason why the Payee column is empty. We can only export the entries with the payee in the For review tab.
Alternatively, I recommend exporting the transactions from the Bank Account History page. Here's how:
I've added a screenshot below of how the data looks like after exporting:
Aside from your bank transactions, you can also export reports, lists, and other data from your QuickBooks Online account. I've added these resources below for your reference:
The Community team and I are always ready to provide answers if you have additional questions regarding exporting or importing bank data in QBO or categorizing them.
Hi Charlene,
Thanks for your reply.
There seems to be a misunderstanding - I am not trying to import bank transactions into QuickBooks. I am trying to export the bank transactions from QuickBooks to Excel using the bank transactions section on QuickBooks.
Paul
Thanks for clarifying your goal, Paul.
I'll ensure you can include your payee data when you export bank transactions from QuickBooks Online (QBO).
Before anything else, I'd like to know which specific area in QuickBooks you tried to export your bank transactions.
The Payee data won't show if you export the transactions from the Categorised tab. If you perform this from the For Review section, the payee column will include its data.
Also, please ensure that there's an assigned payee to each transaction before exporting.
If it happens from the For Review section, I recommend signing in to a private browser and trying to export your bank transaction there. Feel free to follow these shortcut keys:
If this works, clear the cache of your regular browser to eliminate piled-up data. If the issue persists, you can use another supported browser or device.
If you experience the same issue, you can categorise your transactions into a specific account. Then, go to the Chart of Accounts (COA) and export the transactions to show the payees on your exported file.
Here's how:
Also, I'll share this article if you want to pull up a report that displays transactions by account: Run reports in QuickBooks Online.
If you have any other concerns about exporting bank transactions from QBO, don't hesitate to leave a reply below. We're here, ready to lend a hand. Have a great week ahead, and stay safe.
Hi there, @PaulBIre.
I understand how important it is when the Payee column doesn't export correctly when you're exporting bank transactions from QuickBooks Online (QBO). Rest assured, I'm here to guide you in getting the best help available.
I recommend contacting our QuickBooks Online live support to investigate this case further. They have the right tools to find the root cause of the problem and provide you with updates about the issue.
Here's how:
Additionally, you can also consider categorizing your bank transactions in your QBO account, which could help with organization and tracking.
Please don't hesitate to leave a reply if you have additional concerns besides exporting bank transactions from QBO. I'm always here to ensure your business needs are fulfilled.
Hi Mark,
I contacted the Help team. And they suggested I use the export feature in the Chart of Accounts. Select a custom date for the bank account in question, and export.
Many thanks,
Paul
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here