Missing transactions

Update: Strangely I just tried to import the missing transactions (by manually downloading them from my bank) and then importing them into quickbooks and it says, "we've filtered out the 7 transactions we already have from your bank account" - but when I double check the 7 transactions do not appear . . . Any ideas?

---

@Lucy Cassidy wrote:
Quick books hasn't imported some of my transactions (Natwest 16/17 July 2019- there's no error message. I find this alarming as I could have easily missed them. Is it assumed that we manually check each statement to check each transaction? If so is there any way to make this process simple? I know how to import the missing transactions manually - I'm just worried it's happened before and will happen again.

---

You're welcome, @Lucy Cassidy.

I'm glad the missing transactions are now showing on your end. You can start reviewing them from the Transactions tab.

Here’s an article for reference: Categorising & editing transactions in the mobile app.

Reach out to the Community again if you need anything else. I’m here ready to help. Have a good one!
 

Hi, I'm glad your issue has sorted itself out. I have realised I have a massive gap between 1 May 19 to October 2019 and no matter how many times I 'refresh all' they never appear.

Can I ask what you did in between to get them to appear?

Thanks for your time

Hello PTing,

When connecting your bank account to QuickBooks Self-Employed, the system downloads 90-days to 24 months worth of historical banking transactions. After that, QuickBooks Self-Employed will download your banking transactions in a regular basis (every 24 hours). Clicking the Refresh all button bypasses the usual system process and downloads again the historical banking transactions.

Though you can refresh the list manually, the downloaded banking transactions still depends  on what your bank shares with us. You can reach out to your bank and verify why the transactions cannot be downloaded in QuickBooks Self-Employed. Aside from that, you can also ask a .CSV file for your banking transactions. Then, you can import it the program:

1. Go to the Settings (⚙) icon in the upper-right corner and select Imports.
2. Look for the connected bank account and click Import older transactions under the ACTION column.
3. Follow the onscreen instructions to finish importing process.
4. Select Import.

Here are some articles that you can use for reference when dealing with downloaded banking transactions:

• Import transactions from other sources

• Add older transactions to QuickBooks Self-Employed

If you still need help in downloading your historical banking transactions, I'd recommend reaching with our Customer Service Team. They can give you more options on how to complete this task. Here's how you can reach them:

1. Go to https://help.quickbooks.intuit.com/en_GB/contact.
2. Select QuickBooks Self-Employed.
3. Fill in the necessary fields such as Your Email, First Name, Last Name, Question, and Phone Number.
4. Click the Ask Your Question button.

While you're at it, you can get back to us if you need more help with this.

CHECK OUR COLUMN ALIGNMENT AND HEADERS: I've been having the same problem, and I was able to find a solution.  For me, I believe that the import utility incorrectly assumed the column headers, and therefore, it was seeing a lot of invalid data (probably blank data or dates) as records that had already been processed. I changed the headers in my csv file to match what it wanted (date, description, debit, credit), and when I tried again, it worked perfectly.  FYI, I don't think that this mattered in the end, but I was also in an incognito tab from when I was troubleshooting the potential cache-related solution hypotheses. Hope this helps a few of you...