QB memo not bringing in the complete bank transaction description

Howard_B · ‎June 23, 2023

Hello,

QB brought in all of my transactions but the memo shows:

Interac e-Trsf Out #1234678

Interac e-Trsf Out #2346789

and my bank descriptions are:

Interac e-Trsf Out #1234678 Company A

Interac e-Trsf Out #2346789 Company B

I made a rule for Interac e-Trsf Out, but now I see that the company info was never imported. How do I get the complete transaction description to be imported?

Thanks,

Howard

JamesAndrewM · ‎June 23, 2023

I'll share information that could help you upload the complete description of your bank transactions in your QuickBooks Online.

After you export the banking transactions from your bank, you can manually edit the description in the CSV file to correct them and then upload it to your QBO. Follow the steps below:

For accounts connected to online banking

Go to Bookkeeping Transactions, then select Bank Transactions.
Select the blue tile for the account you want to upload the transactions into.
Select the Link account ▼ dropdown and then Upload from a file.
Select Drag and drop or select files and select the file you downloaded from your bank. Then select Continue.
In the QuickBooks account ▼ dropdown, select the account you want to upload the transactions into. Then select Continue.
Follow the onscreen steps to match the columns on the file with the correct fields in QuickBooks. Then select Continue.
Select the transactions you would like to import. Then select Continue.
Click Yes.
When you accept your transactions, select Done.

For accounts not connected to online banking

Go to Bookkeeping then Transactions then select Bank Transactions.
Select Upload transactions.
Select Drag and drop or select files and select the file you downloaded from your bank. Then select Continue.
In the QuickBooks account ▼ dropdown, select the account you want to upload the transactions into. Then select Continue.
Follow the onscreen steps to match the columns on the file with the correct fields in QuickBooks. Then select Continue.
Select the transactions you would like to import. Then select Continue.
Select Yes.
When you accept your transactions, click Done.

For more details, refer to this article: Manually upload transactions into QuickBooks Online.

You can also utilize these articles for future reference:

The Community always welcomes you for further inquiries about transactions. Have a great day ahead!

View solution in original post

ChristineJoieR · ‎June 23, 2023

Thanks for bringing this information to the Community page, @Howard_B. I'll share tips to import the complete description of your banking transactions in QuickBooks Online.

I wonder why how it goes like this. If your banking transaction is based on your bank description, this should flow the same information on the banking section. May I ask if you tried to visit your banking website and verify the description? It would be a great help if you further check them for me to identify if there's an issue.

On the other hand, I want to make sure the columns are added on your banking screen to show all the bank details. Let's see if you can add it by ticking the box from the Gear icon under the Banking section.

Here's how:

From the Banking screen, navigate to the Gear icon.
Looking at the column section, tick the Show Bank Details box.

If the bank description is the same, we can initiate a troubleshooting method to eliminate the error. Considering there are unexpected bugs that can interfere QuickBook's performance.

Here's how:

1. Restart your browser.

2. Log in to your account and try in an incognito or private browser. You can use these keyboard shortcuts to launch a new private window:

Google Chrome: press Ctrl + Shift + N
Microsoft Edge: press Ctrl + Shift + N
Firefox: press Shift + CTRL + P

As a workaround, we can exclude the banking transaction and upload the specific transaction manually to your QuickBooks Online account. Please ensure to check the exact details from your bank institution.

That's it, @Howard_B. I'm glad to have you today.

Howard_B · ‎June 23, 2023

Hi Christine,

Thanks for the reply to my question. The show bank details box was already checked.

I did a little more digging, and I think that the issue is from my bank. I exported the qbo file for my account, and the description in the qbo file is not the complete description that shows in my online account.

Is there a character limit to the <NAME> output in a qbo file? I'm struggling to think of a reason that my bank (credit union) would remove that information.

Thanks,

Howard

jenop2 · ‎June 23, 2023

Thanks for the additional details in your reply, Howard.

Customers, vendors, and other names has a 41 character limit. You can read more details about this and other limitations in this article: Character Limitations for Fields in QuickBooks.

However, all info that you can see in the downloaded transactions are provided by your bank. The Online Banking section only displays the data that's shared by your financial institution.

Having said that, I would recommend reaching to them. They can take a look at this and check the removal of the information is coming from their system.

Let me also share these articles in case you need more guidance when managing bank transactions in QBO:

Don't hesitate to reach out to us again if you have other questions for us. The Community is always here if you need anything else.

Howard_B · ‎June 23, 2023

Thanks for the info jenop.

This is a "bank" problem. They've decided to limit their output to 28 char for qbo output, and they leave off some helpful information (like who the payment is going to). I've contacted them and I'm waiting for a reply, but my guess is that they will not be helpful. I can't be their first client to use QB and my bet is that they've heard this problem before and they didn't do anything about it.

I was able to get full descriptions with a CSV export. Can I use that export to overwrite the useless descriptions? [fingers-crossed]

From what I've read, I don't think that I'll be able to delete the transactions and start over.

thanks,

Howard

JamesAndrewM · ‎June 23, 2023

I'll share information that could help you upload the complete description of your bank transactions in your QuickBooks Online.

After you export the banking transactions from your bank, you can manually edit the description in the CSV file to correct them and then upload it to your QBO. Follow the steps below:

For accounts connected to online banking

Go to Bookkeeping Transactions, then select Bank Transactions.
Select the blue tile for the account you want to upload the transactions into.
Select the Link account ▼ dropdown and then Upload from a file.
Select Drag and drop or select files and select the file you downloaded from your bank. Then select Continue.
In the QuickBooks account ▼ dropdown, select the account you want to upload the transactions into. Then select Continue.
Follow the onscreen steps to match the columns on the file with the correct fields in QuickBooks. Then select Continue.
Select the transactions you would like to import. Then select Continue.
Click Yes.
When you accept your transactions, select Done.

For accounts not connected to online banking

Go to Bookkeeping then Transactions then select Bank Transactions.
Select Upload transactions.
Select Drag and drop or select files and select the file you downloaded from your bank. Then select Continue.
In the QuickBooks account ▼ dropdown, select the account you want to upload the transactions into. Then select Continue.
Follow the onscreen steps to match the columns on the file with the correct fields in QuickBooks. Then select Continue.
Select the transactions you would like to import. Then select Continue.
Select Yes.
When you accept your transactions, click Done.

For more details, refer to this article: Manually upload transactions into QuickBooks Online.

You can also utilize these articles for future reference:

The Community always welcomes you for further inquiries about transactions. Have a great day ahead!

Howard_B · ‎June 25, 2023

Thanks James.

Although it would have been better to have the transactions download automatically from my bank, this method works perfectly.

I'll be using the file import method from here on.

Thanks to the QB community for your help.

Cheers,

Howard

Topics

Training

Community

Resources

QB memo not bringing in the complete bank transaction description