cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Unlock the full power of QuickBooks with our Training Classes - Discover more
keith72
Level 1

What happened on 23 april

my banking transactions for 23 april 2021 are not recorded, what happened, and how do i sort it?
Solved
Best answer July 21, 2021

Accepted Solutions
Rea_M
Moderator

What happened on 23 april

Thanks for the additional details you've provided above, @keith72. You're already on the right track for uploading a CSV file with your missing transactions in QuickBooks Online (QBO). 

 

For the time being, uploading bank transactions is limited to either QBO and/or CSV file formats. You could just manually enter the transactions if it is a small number of transactions yes.

 

We'll leave some tips here in case you do want to still try and upload via the file you downloaded. Based on the attached file, the pound signs (£) under the Amount column are the reason you're unable to upload your CSV file. With this, I'd recommend removing the signs and save the file as CSV. Then, upload it again to QBO instead of inputting the two missing transactions manually to keep your account updated.

 

To learn more about CSV formats, I encourage you to check out this article: Import bank transactions using Excel CSV files.

 

Once formatted, import the missing transitions by performing these steps:

  1. Go to the Banking menu.
  2. Select the blue tile for the account you want to upload the transactions into.
  3. Click the Link account drop-down and then Upload from file.
  4. Click Browse or select files and then select the file you downloaded from your bank. Then select Next or Continue.
  5. In the QuickBooks account drop-down, select the account you want to upload the transactions into. Then select Next.
  6. Follow the onscreen steps to match the columns on the file with the correct fields in QuickBooks. Then select Next.
  7. Select the transactions you would like to import. Then select Next.
  8. Select Yes.
  9. When you're ready, select Let's go.

 

Once imported, you'll have to review and/or match your transactions to the existing entries in QuickBooks. This is to make sure your data is accurate. For the step-by-step guide, you can refer to this article: Categorise online bank transactions in QuickBooks Online.

 

Also, I encourage you to reconcile your accounts every month. This will effectively monitor your income and expense, and detect any possible errors accordingly. For the detailed steps, check out this article: Reconcile an account in QuickBooks Online.

 

We appreciate your patience regarding this matter. In case you have other inquiries or banking concerns, let me know in the comments below. I’ll be around to back you up. Have a good one and keep safe.

View solution in original post

5 REPLIES 5
Giovann_G
Moderator

What happened on 23 april

Welcome to the Community, keith72.

 

I'm here to help you find and download the missing bank transactions.

 

Can you share with me the name of your financial institution? So we can check if there's some issue with your bank during that time. The connectivity issues, data transmission interruption, and constant security updates are the possible reasons why some transactions are missing.

 

Let's start fixing this. Please log in to your bank account on their website and check if you see the transaction posted. If so, you can manually update your bank account to bring those transactions to QuickBooks. I'll show you how.

 

  1. Go to the Banking or Transaction menu.
  2. Select the Banking tab.
  3. Choose the account you're working on.
  4. Click on the Update button.

 

QuickBooks download the ones that are not on the banking page. If the issue persists, you can download a CSV file from your bank's website. Then, manually upload them in QBO. Please review this guide for more info: Manually upload transactions into QuickBooks Online.

 

Once the transaction is inside QuickBooks, you can start to categorize and match them. Let me add this material for your guide: Categorise and match online bank transactions in QuickBooks Online.

 

You can reply to this post if you need further assistance with banking. I'm always here to back you up.

keith72
Level 1

What happened on 23 april

Hi, thanks for your reply.  I have had several attempts to upload the missing transactions.  Each time I get this error message 

Some info may be missing from your file. Double-check that your file is complete and try uploading again.

I have amended the file several times with no success.  The error message above is not covered in your guide.

https://quickbooks.intuit.com/learn-support/en-uk/bank-transactions/fix-bank-upload-errors-in-quickb...

The current version of the file is attached.

Please can you help.

 

 

EmmaM
QuickBooks Team

What happened on 23 april

Hello Keith, we can't see the attachment, is that a CSV excel file you are uploading with the missing transactions? Have you tried formatting the cells in the columns for date and amount?Thanks

keith72
Level 1

What happened on 23 april

Hi Emma

 

Please see file attached.  Apparently I can't upload a CSV file so I've converted it to PDF.  I've spent about an hour trying different cell formats, column headings, 3 columns, 4 columns etc. etc.  My wife says she can just input the two missing transactions manually without fiddling about with CSV files, is that right?  If so it'll take about 2 minutes.

Rea_M
Moderator

What happened on 23 april

Thanks for the additional details you've provided above, @keith72. You're already on the right track for uploading a CSV file with your missing transactions in QuickBooks Online (QBO). 

 

For the time being, uploading bank transactions is limited to either QBO and/or CSV file formats. You could just manually enter the transactions if it is a small number of transactions yes.

 

We'll leave some tips here in case you do want to still try and upload via the file you downloaded. Based on the attached file, the pound signs (£) under the Amount column are the reason you're unable to upload your CSV file. With this, I'd recommend removing the signs and save the file as CSV. Then, upload it again to QBO instead of inputting the two missing transactions manually to keep your account updated.

 

To learn more about CSV formats, I encourage you to check out this article: Import bank transactions using Excel CSV files.

 

Once formatted, import the missing transitions by performing these steps:

  1. Go to the Banking menu.
  2. Select the blue tile for the account you want to upload the transactions into.
  3. Click the Link account drop-down and then Upload from file.
  4. Click Browse or select files and then select the file you downloaded from your bank. Then select Next or Continue.
  5. In the QuickBooks account drop-down, select the account you want to upload the transactions into. Then select Next.
  6. Follow the onscreen steps to match the columns on the file with the correct fields in QuickBooks. Then select Next.
  7. Select the transactions you would like to import. Then select Next.
  8. Select Yes.
  9. When you're ready, select Let's go.

 

Once imported, you'll have to review and/or match your transactions to the existing entries in QuickBooks. This is to make sure your data is accurate. For the step-by-step guide, you can refer to this article: Categorise online bank transactions in QuickBooks Online.

 

Also, I encourage you to reconcile your accounts every month. This will effectively monitor your income and expense, and detect any possible errors accordingly. For the detailed steps, check out this article: Reconcile an account in QuickBooks Online.

 

We appreciate your patience regarding this matter. In case you have other inquiries or banking concerns, let me know in the comments below. I’ll be around to back you up. Have a good one and keep safe.

Need to get in touch?

Contact us