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:
- Go to the Banking menu.
- Select the blue tile for the account you want to upload the transactions into.
- Click the Link account drop-down and then Upload from file.
- Click Browse or select files and then select the file you downloaded from your bank. Then select Next or Continue.
- In the QuickBooks account drop-down, select the account you want to upload the transactions into. Then select Next.
- Follow the onscreen steps to match the columns on the file with the correct fields in QuickBooks. Then select Next.
- Select the transactions you would like to import. Then select Next.
- Select Yes.
- 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
