SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends June 27

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
gstuessy
Level 1

Report of transactions moved to a different date

In Quickbooks Online, I would like to know how to see a report or list of transactions where the Date field was changed from the date they cleared the bank account. This would include transactions that were manually added to Quickbooks. Is that possible in Quickbooks Online?

Right now the way I get this information is by manually comparing every line in the "Transaction List by Date" report—which has the new dates for transactions, if the date has been changed—with the bank statements or an export from my bank account.

Thank you!

2 Comments 2
LeizylM
QuickBooks Team

Report of transactions moved to a different date

Thanks for posting here, gstuessy.  I want to ensure this will be taken care of. 

 

The option to show the transaction date and the clearing date on the report isn't available in QuickBooks online (QBO). To see the changes, you'll have to manually compare the report with your bank statement. 

 

Having the ability to show the transaction date and clearing date on a report would be a great option. I encourage you to add your vote for this one by sending a feature request in the Feedback section within QuickBooks. Our product development team reviews all the feedback we receive to ensure we’re meeting the needs of our customers.

 

Here's how:
 

  1. Select the Gear icon at the top, then Feedback.
    Capture.JPG
  2. Enter your comments or product suggestions then select Next.
  3. You'll be provided a list of suggested Help articles related to your comment. You can read through them or select Skip and send a message.
  4. From the drop-down, choose the appropriate category, then select Send a message.

 

I've added some additional articles about managing a wide range of reports in QBO:

 

 

Feel free to visit the Community if you have other questions about reports. I'll get back to answer them for you. Enjoy your day and stay safe. 

gstuessy
Level 1

Report of transactions moved to a different date

I figured out a solution to this:

 

  1. From the "Bank transactions" page, export the list of Categorized transactions.
  2. Open it up in Google Sheets.
  3. Each entry (row) has the original/bank date in the Date column and has something like "Added to: Deposit: Split income 04/30/2023 $149.27" in the Assigned To column. The date in that line of text is the revised date. Isolate the revised date by using the "Split text to columns" feature (Data menu) and split by " $" to separate out the amount. Then use the "=RIGHT()" formula to isolate the date to its own column: "=RIGHT(Cell, 10)".
  4. Now you have the Revised date in its own column.
  5. Also check the Excluded transactions in Quickbooks if needed.
Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us