Solved! Go to Solution.
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:
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.
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.
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.
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.
The current version of the file is attached.
Please can you help.
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
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.
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:
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.