cancel
Showing results for 
Search instead for 
Did you mean: 
kcoromandel
Level 1

Missing transactions

I’m trying to do a bank reconcilation for the first time. As suggested in some of your training posts (videos) I’ve been reconciling from the oldest to newest statement. All have been balanced to a $0 difference. But the last one I have a variance $146.37. Ive noticed that my rec stops at Dec 2018 and starts again in March 2019. I’m missing Jan & Feb transactions. How can i find the missing transactions and balance my rec?
9 Comments 9
Intuit Zac
Content Creator

Missing transactions

Hi Kcoromandel, 

 

Thank you for reaching out on this. 

 

So we can better assist you on this, may I clarify if Jan and Feb transactions are not in your QuickBooks Online file or they are just have not been reconciled, please? In other words, if you go to the account history, do you see any transactions from Jan to Feb?

 

Thank you. 

kcoromandel
Level 1

Missing transactions

Account history is showing there not there. (view attached) But the missing transactions do make up the difference in rec
Intuit Zac
Content Creator

Missing transactions

Thank you for the screen shot, Kcoromandel, 

 

 

Looks like Jan to Feb transactions have not been added to your QuickBooks Online file at all. Do you mind if I ask if there has been any outage with your bank feed? 

 

You can bring back Jan to Feb transactions into your QBO account by exporting the transactions list from your online banking website as a .CSV file and import it to QBO. 

 

Here is an article from our community for your reference:

Import Bank transactions via CSV [VIDEO]

https://quickbooks.intuit.com/community/Banking/Import-Bank-transactions-via-CSV-VIDEO/m-p/263049

 

Please let us know if you require additional assistance. Thank you. 

kcoromandel
Level 2

Missing transactions

I've uploaded the missing transactions as suggested. Do I know review these transactions? Will this throw out my bank balance vs QBO when I do? as it currently matches (see attached) or does this mean there are more errors?
kcoromandel
Level 2

Missing transactions

sorry sent you the wrong attachment before
Intuit Zac
Content Creator

Missing transactions

Hi Kcoromandel, 

 

Thank you for getting back to us on this. Excellent work on bringing in Jan to Feb transactions!

 

You do need to review us as transactions under the "for review" tab are not in your accounting record. If there is a difference between bank balance and QBO balance after doing so, we can troubleshoot further. 

 

Please feel free to reach out again if you need help on this. 

kcoromandel
Level 2

Missing transactions

ok, so I've added in the transactions expect these 2 (attached) as they relate to invoices that are already matched. what do I do here?
Intuit Zac
Content Creator

Missing transactions

Hi Kcoromandel, 

 

Glad to hear you were able to add the transactions into your QBO file. For the remaining 2, if they have already been matched and recorded in your QBO file before, you can exclude the 2 and not bring them in to avoid duplication.

 

You can also do a bank reconciliation for the month to confirm the bank balance and QuickBooks balance is correct. 

kcoromandel
Level 2

Missing transactions

Thank you. this is now fixed and statement reconciled