Exported Bank Transactions to Excel are missing Payee

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:

1. Go to the Gear icon and then select Chart of Accounts.
2. Select the account where the transactions are added.
3. Choose Account history.
4. Filter the correct dates and other details.
5. Once done, hit Export to Excel.

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:

• Export data out of QuickBooks Online
• Export reports, lists, and other data from QuickBooks Online

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: 

• Google Chrome: press Ctrl + Shift + N
• Mozilla Firefox: press Ctrl + Shift + P
• Microsoft Edge: press Ctrl + Shift + N
• Safari: press Command + Shift + N

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:

1. Select Chart of Accounts from the Transactions tab.
2. Find and double-click the account where you placed those transactions.
3. You can filter the date by clicking the Funnel icon.
4. Once done, click the Export to Excel icon.

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 Bryan,

I have tried what you have suggested: I normally use Google Chrome, but opened Edge in Private browser, and ran the same bank export.  The result is the same.  See attached export image from Excel for reference.

Please advise.

Thanks,

Paul

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:

1. Head to this link: Contact Us.
2. Select QuickBooks Online product and click Continue.
3. Select Contact Us and choose a way to connect with us:

• Start a chat with a support expert.
• Get a callback from the next available expert.

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