Quickbooks Online is pulling the Transaction Date from my Chase bank account, instead of the Posted Date. This is causing end of month reconciliation issues.

From looking at other posts in the community forum, it looks like this issue may have started in July 2023 (or around then).  That seems to line-up with our experience as well.  We did not have these reconciliation issues previously.

I appreciate you providing details of your concern in the Community space, gkoroluk. Let me share some information regarding the transaction dates in QuickBooks Online (QBO).

It is common for the transaction dates to vary since QuickBooks records transactions in real time, but banks may have a different timeline for when they clear transactions. However, it is advisable to use your bank statement as a basis while reconciling your accounts in QuickBooks.

It is important to include transactions in their respective months when reconciling your QuickBooks account. If a transaction is recorded with the previous month's date but falls on the next month, you must include it in the correct month's reconciliation. This way, you can ensure that your reconciliation matches the transactions on your bank statement accurately.

Moreover, you may want to explore this article to learn what to review so you can start reconciling: Fix issues for accounts you've reconciled in the past in QuickBooks Online.
 

Keep me in the loop by leaving a comment below if you need further assistance or have any additional banking questions.

Is there anyway to fix this issue. I spend hours reconciling an account every month with 1500 transactions and there is no science of which days are correct. I end up going through each transaction mannually which takes so much time to find which transactions should not be included in that statement. 

I heard your sentiment, 45256. I'm here to help you resolve this issue on the transaction date of your Chase bank. It sounds like you're facing a significant challenge in reconciling your account in QuickBooks. 

One potential solution to streamline this process is to utilize your bank statement as suggested by my colleague above. It will help you track all your transactions from your bank statement with those in your books, which can significantly reduce the time spent on manual reconciliation and identify any underlying issues causing the discrepancies in your reconciliations. 

Furthermore, one possible reason for discrepancies could be the deletion of transactions from a previous reconciliation or the omission of transactions from the past month during the reconciliation process.

Lastly, ensuring that your bank feed is set up correctly and that your transactions are categorized accurately can also help in reducing the time spent on manual reconciliation. The Community is here for you 24/7 on the clock. If you need to drop your additional comments, notify us below. Keep safe.

This is useless information. I'm having the same issue as listed above. None of this started until later this year. I have used QuickBooks for a year and a half with no issues at all. So either you guys changed something or my bank changed something and since I'm not using the same bank as the ones above I'm thinking you made an addition or subtraction from the program that has caused this discrepancy. It is a royal pain in the butt 

I can confirm that this is happening for transactions that are pulled from bank of america credit card statements as well. QBO is pulling transaction date while bank statement includes the transactions into different statements based on posting date.

Hi there, @anoopjohn.

QBO does not have control on what transactions are downloaded when a bank is connected to it. The program is only dependent on what your financial institution shares with us. If you want to change how entries are downloaded, you can reach out to them to help you update the connection process. 

For more information, read this article: Download the most recent bank and credit card transactions in QuickBooks Online.

When transactions are in, your next step is to match and categorize them to ensure they are allocated to the correct account in QBO. 

Additionally, its best to refer to your bank statement to make sure you add and reconcile the actual transactions you process in real life. 

Please don't hesitate to leave a reply below if you have any other concerns managing your transactions. I'll be here ready to provide additional assistance. Have a good one. 

Are you explaining that the end user should negotiate with the bank on whether they send posted date or transaction date to QuickBooks when QBO pulls data from the bank?

Yes, anoopjohn.

It may be necessary to reach out to your bank regarding the issue with QuickBooks Online (QBO) pulling the transaction date instead of the posted date since QBO relies on the data transmitted by your bank.

I understand it's important to ensure accuracy. You can consider reviewing each transaction and adjusting the date to match the correct posting date from the bank statement. This can take some time, but it helps maintain accurate records.

Then, proceed reconciling your accounts to help maintain financial accuracy, detect fraudulent activities, identify errors, and manage your business's finances effectively.

Additionally, I recommend visiting the following article to resolve problems with reconciling accounts: Fix issues when you're reconciling accounts in QuickBooks Online.

Please don't hesitate to comment below if you need help managing your transactions. I'm here to assist you further. Have a great day!

Have you made any progress on rectifying this issue? We're experiencing the same problem.

Hi I figured out what is happening- chase has an actual transaction and cleared date for all transactions. For some reason QBO normally seems to be pulling the actual date and not when its cleared. I have a workaround for those that have thousands of transactions (or even hundreds) making it difficult to reconile even with a bank statement. This is not a bank issue (from chase) but a QBO issue and they should figure how to fix it. 

The workaround is as follows: disconnect bank feeds (make sure previous month is reconiceld and all trasnactions that are not reconiceld are deleted (as we dont want them to be double imported) 

Then download the transactions mannually from chase as a qbo with those dates, when I pull those dates that I request, Chase only gives me the transactions CLEARED during those dates. then I import it. 

Even though it is mannually I do it twice a month or even once a month if you want to, but its worthwhile for mebecasue it saves me a couple hours mannually checking every one of my 1500 trasnstions when reconcieling. 

Shame on intuit for not fixing this big issue. Chase seems to be giving the correct data when I request it- only things that cleared during a month. 

(For exmaple i have a transation dated 3/31 that qbo imported but it was actually part of the April statement and downloaded when I requested from Chase) 

Hi there, josh. 

I understand the importance of accurate data transmission. However, as mentioned by my colleagues, QuickBooks relies on the data shared by financial institutions. You may want to contact them if you have encountered issues when pulling up your bank transactions. 

In the meantime, you may want to follow the resolutions mentioned by my peers and by 45256 to help you get past this issue. 

After that, we match and categorize to review downloaded bank and credit card transactions. Once done, we can begin the reconciliation process to ensure your real-time accounts and records within the program match. 

You can count on me if you have more inquiries about downloading your bank data to QuickBooks, just comment below. I'll circle back to assist you. Take care!  

I spoke with my bank and they confirmed that they send Quickbooks the transaction date and posting date, so this really is an issue that Quickbooks should be able to fix. User 45256 is stating they are disconnecting the bank feed and manually uploading the transactions. This defeats the purpose of having a bank feed.

I appreciate you for returning to this thread and providing an update about your concern, Josh.

I understand the importance of pulling your posted date transactions in QuickBooks Online (QBO). For now, it's best to contact our support team to further check what's causing this by accessing your account in a secure environment and determine possible solutions to your concerns.

Here's how:

1. Go to Help.
2. Select the Search tab, then choose Contact Us.
3. Type in your issue or concern in the field.
4. Hit Continue.
5. Click the Chat or Callback option.

For reference, check this article: QuickBooks Online Support.

For future reference, you can check this article to guide you in reconciling your accounts so they always match your bank and credit card statements: Reconcile an account.

If you have any questions, feedback, or concerns regarding the issue of pulling your transaction date instead of the posted date, please don't hesitate to come back to the Community, Josh. I'll be here to assist you.