I am setting Quickbooks up for the first time and have accidently downloaded my bank transactions from the wrong date. I wanted them for a date earlier. How do I amend it please.
Solved! Go to Solution.
I've got your back, @Sonya Immanuel. I'd be happy to help you bring your earlier transactions to your QuickBooks Online (QBO) account.
Since you've set up your banking account in QBO, I'd recommend importing your transactions from your bank's website manually through .CSV file.
Let's first exclude the uploaded transaction with an incorrect date to avoid duplicates. Follow these steps to proceed:
Then, we can proceed with taking note of the earliest transaction date you've imported on your QBO Banking page. Then, go to your bank's website and get the transactions.
Let's say if you had December 1 as your earliest transaction in QBO, you may import the earlier transactions before December 1 from your bank to avoid getting duplicate transactions after the process.
Here's how to import the bank transactions into QBO:
You also have the option to edit the date of the transactions in the .CSV file using Excel before uploading them manually.
I'd also suggest reaching out to your accountant for additional guidance in dealing with this.
In case you need to correct your opening balance, please refer to this article for detailed steps on editing an incorrect opening balance.
Additionally, consider checking out this article to learn more about categorising and matching your transactions.
If you have any further questions about your bank transactions in QBO, please let me know and I’ll do everything I can to help here in the Community. Have a great day!
I've got your back, @Sonya Immanuel. I'd be happy to help you bring your earlier transactions to your QuickBooks Online (QBO) account.
Since you've set up your banking account in QBO, I'd recommend importing your transactions from your bank's website manually through .CSV file.
Let's first exclude the uploaded transaction with an incorrect date to avoid duplicates. Follow these steps to proceed:
Then, we can proceed with taking note of the earliest transaction date you've imported on your QBO Banking page. Then, go to your bank's website and get the transactions.
Let's say if you had December 1 as your earliest transaction in QBO, you may import the earlier transactions before December 1 from your bank to avoid getting duplicate transactions after the process.
Here's how to import the bank transactions into QBO:
You also have the option to edit the date of the transactions in the .CSV file using Excel before uploading them manually.
I'd also suggest reaching out to your accountant for additional guidance in dealing with this.
In case you need to correct your opening balance, please refer to this article for detailed steps on editing an incorrect opening balance.
Additionally, consider checking out this article to learn more about categorising and matching your transactions.
If you have any further questions about your bank transactions in QBO, please let me know and I’ll do everything I can to help here in the Community. Have a great day!
Thanks Kevin - you are a star!!!!!!! Great help and advice - got me out of a big hole!!!! I am no longer in the doghouse at work!!!!
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.