Skip to main content

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

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
gstuessy
February 7, 2023
Question

Report of transactions moved to a different date

  • February 7, 2023
  • 2 replies
  • 68 views

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 replies

LeizylMQuickBooks Team
QuickBooks Team
February 8, 2023

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.
  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. 

gstuessyAuthor
May 11, 2023

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.
Terms & ConditionsAccessibility statement