Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
92coover
Level 1

I am missing Transactions from July 19th 2022 to November 29, 2022. I have updated and checked excluded items. They seam to not exist. How can I find or replace them?

 
3 Comments 3
docsbp29
Level 1

I am missing Transactions from July 19th 2022 to November 29, 2022. I have updated and checked excluded items. They seam to not exist. How can I find or replace them?

You can pull up a audit trail report by going to reports, accountant, audit trail. Select the dates in question and run the report. It'll show what was originally entered and any changes made to those transactions

docsbp29
Level 1

I am missing Transactions from July 19th 2022 to November 29, 2022. I have updated and checked excluded items. They seam to not exist. How can I find or replace them?

Since you're talking about banking transactions get bank statements and reenter whatever you need to.

KlentB
Moderator

I am missing Transactions from July 19th 2022 to November 29, 2022. I have updated and checked excluded items. They seam to not exist. How can I find or replace them?

I can definitely help you with that, 92coover.

 

When you connect your account, the program automatically downloads transactions up to a certain date. Some banks let you bring in the last 90 days worth of data. Others can go back as far as 24 months.

 

In addition to docsbp29 inputs, you may need to manually import the older entries once you've confirmed that they were not downloaded or accidentally deleted. Let's start by logging in to your bank's website, then follow their instructions on how to download them as a CSV, QFX, or QBO file. After that, head back to the Banking page in QuickBooks Online to upload it. 

 

  1. Go to the Banking or Transactions menu.
  2. Click the Banking tab, then select the account you want to upload the transactions into.
  3. For accounts connected to online banking, select Upload from file from the Link account drop-down menu. For accounts that aren't connected, select Upload transactions.
  4. Select Drag and drop or select file, then click Continue.
  5. Choose the account you want to upload the transactions into, then hit Continue.
  6. Follow the onscreen steps to match the columns on the file with the correct fields in QuickBooks.
  7. Select the transactions you would like to import, then click Continue.
  8. Click Yes, then Done.

 

upload transaction.PNG

 

Feel free to check out these articles to be guided in categorizing your online banking transactions to put them into the correct accounts:

 

 

Let me know if that's all the information you need about handling missing data. You can also post more questions if you need anything else from the Community. Have a good one!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us