You can use an Excel CSV file to import the missing transactions in QuickBooks Self-Employed (QBSE). I'm here to share with you the detailed instructions.
Once your bank account is connected to QBSE, the system automatically downloads the recent bank transactions into QuickBooks. If there are missing entries, you can update your bank manually.
Here's how:
Open your QBSE account, then go to the Gear icon.
Select Banking under Transactions.
Tap on Refresh all.
However, for 90 days old or older bank transactions, you need to need to import them manually.
First, export the transactions from your bank.
Sign in to your bank’s website.
Follow your bank’s steps to download your transactions as a CSV file. This is usually a button or link on your account page.
Set the date range for at least one day before the oldest transaction in the account in QuickBooks.
Follow any on-screen instructions to finish the download.
Once done, here's how to import them to QBSE.
Open your QBSE account using a web browser.
Go to the Gear icon, then select Imports.
Select Import older transactions for the account you want to add transactions to.
Tap Browse and find the file you downloaded from your bank. It's usually in your Downloads folder.
Select the file and select Open to start the import.
Review the column headers and data. Make sure the Date, Description, and Amount columns on the CSV match the columns and order in QuickBooks. The other column headers can be in any order.
Click Continue to complete the import.
For additional instructions, I recommend checking out these articles: