We'll need to exclude the transaction and upload it manually using a CSV file to assign it to the correct date, Marie.
Once a bank transaction is downloaded into QuickBooks Online (QBO), the transaction dates cannot be edited because they are pulled directly from your bank statement.
Since it has incorrect dates, we can resolve this issue by excluding the bank transaction.
Here's how:
Go to Transactions, then select Banktransactions.
Choose a transaction in the For Review tab.
Choose the checkbox of the transactions to exclude.
Click Exclude.
Next, create a transaction in your Excel file and manually upload it using the correct CSV format. Additionally, ensure to save the file as a CSV.
To upload, follow the steps below:
Click the Link account dropdown, then choose Upload from file.
Choose the saved CSV file and click on Continue.
Select an account from the QuickBooks Account dropdown, then click the Continue button.
Enter the exact date from the Date Format dropdown and click Continue.
Choose the transaction by clicking the Tick Boxes and click onContinue.
Wait for the system to complete the importing process and click Done.
Drop your comment below for more QBO-related concerns.
Need QuickBooks guidance?
Log in to access expert advice and community support instantly.