cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
dmarques85
Level 1

Importing Transactions that were missing from the auto sync

Hello,

 

My transaction usually sync automatically from my Monzo bank account. However I have noticed that three months are missing in the middle of the year.

 

I have tried exporting these months and importing them but it keeps saying there was an error. I note that it says that the import tool is for "older" transactions that the date of the automated sync - however these missing transactions are after I turned on the automated sync. 

 

Is there a way to import these three months manually?

2 REPLIES 2
Fiat Lux - ASIA
Level 15

Importing Transactions that were missing from the auto sync

Explore one of the converter tools (e.g csv2qbo) as a workaround.

https://www.moneythumb.com/?ref=110

 

LieraMarie_A
QuickBooks Team

Importing Transactions that were missing from the auto sync

Hi there, @dmarques85.

 

It's our goal to ensure that your transactions are up-to-date.

 

Currently, we have an ongoing investigation about this Monzo bank account connection issue in QuickBooks Self-Employed (QBSE). Our engineers are doing their best to fix it as soon as possible. I recommend contacting our Customer Care Support team so you'll be added to the list of affected users. This way, you'll receive email updates on the investigation's status and be notified once it's resolved. 


 Here's how:

 

  1. Select Assistant from the top bar.
  2. Type in "Talk to a human," then press Enter.
  3. Enter a short description of your concern. You can type in the investigation number here.
  4. Select Message an agent or Get a callback.
    Capture.JPG


Also, can you share the error message you're getting when importing bank transactions? To import bank transactions using CSV in QBSE, make sure you've chosen the correct columns in the mapping stage. Otherwise, QuickBooks won't be able to read the data. To make the mapping stage easier, we can do the following:
 

  1. Delete columns you do not need from your CSV to avoid any confusion. The columns that are required by QuickBooks are:
    • Date - Correct and standardise the date format to a single format (for example, dd/mm/yyyy).
    • Description
    • Amount
  2. Change the names of the columns in your CSV to match the titles in QuickBooks

 

When your file is formatted correctly, upload them into QBSE. If you're still getting the same issue, you may have accumulated too much historical data. Whenever you visit a website, it saves some information from the web page in its cache and cookies. These files allow the websites you visit most often to load faster. Not to worry, clearing them will do the trick.

 

First, let's try accessing your account through an incognito window to rule out the possibility of a webpage issue. You can refer to these shortcut keys to open an incognito window in all supported browsers:

 

  • Chrome: Ctrl + Shift + N
  • Firefox: Ctrl + Shift + P
  • Safari: Command + Shift + N

 

If the upload goes through, switch back to your regular browser. Then, clear its cache. This way, you can access QuickBooks with a clean slate. You can also use a different supported one.
 

Finally, review and categorise your downloaded entries to put them in the correct accounts.

 

I'm always here if you need further assistance with classifying your entries. It's my pleasure to help. Have a great day!

Need to get in touch?

Contact us