Thanks for visiting the Community. I'm here to guide you in uploading your John Lewis bank statement so you can reconcile them with your transactions in your QuickBooks Online (QBO) account.
First off, you'll need to log in to your online banking and download your transactions and save it in a CSV (comma-separated values) file format.
You can now start uploading them into QuickBooks. Here's how:
Go to the Banking menu, then select the Banking tab.
Select Upload transactions.
Click Browse and select the file you downloaded from your bank, then Next.
From the QuickBooksaccount drop-down list, pick the account you want to upload the transactions into, then select Next.
Follow the on-screen instructions to match the columns on the file with the banking fields in QuickBooks, then click Next.
Once done, select Let'sgo. You can can now match and categorize them to make sure they're added in QuickBooks.
For more detailed steps, check out this article: Manually upload transactions into QuickBooks Online. It also includes link with steps to guide you in reconciling your account to make sure they matched to your real-life bank transactions.