Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I've got a way to successfully upload your transactions manually into QuickBooks, Lee.
To import your bank statement into QuickBooks, you'll have to modify the date format of your CSV file to numeric first. You can open the CSV copy of your statement to Excel and edit the format from there.
For this, it's advisable to use the Date/Month/Year format (DD/MM/YYYY): 17/01/2025. You can also check the image I've added below as your guidance:
It's also essential to map your data accurately to upload your transactions seamlessly. See this sample for reference:
For more details about the manual importing process, review this link: Upload bank transactions into QuickBooks Online.
I've also included these resources that can help you classify your data and reconcile your accounts accordingly:
You can always add another post here in the Community if you have more questions about the importing procedure in QuickBooks. Our team is committed to helping you promptly.