Skip to main content
P
PaulBIre
September 12, 2024
Question

Exported Bank Transactions to Excel are missing Payee

  • September 12, 2024
  • 1 reply
  • 0 views

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

1 reply

C
CharleneMaeF
September 12, 2024

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:

 

 

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.

P
PaulBIreAuthor
September 17, 2024

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

Bryan_M
Bryan_M
September 17, 2024

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.

Terms & ConditionsAccessibility statement