Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Let me help you import these transactions into QuickBooks Online (QBO), @nolanneal.
When you the CSV file to manually upload your bank transactions, you'll have to make sure that its data is in correct format. This way, you can import them successfully into your bank register.
There are two ways on how you can properly format your transactions when you create them in your Excel file. First, you can use the 3 column format. This will show the date on the first column, description on the next column, and amount on the last column.
The other option is the 4 column format. This format has a Date, Description, Credit, and Debit column. You can check out this article for more information and review the format of the CSV file you got from your bank: Format CSV files in Excel to get bank transactions into QuickBooks.
In addition, you'll have make to sure that you're using an correct bank account when uploading these transactions. This way, they will be reported into your books once you're done reconciling them.
Once your transactions are in QuickBooks, it’s time to match and categorize them. They will go into your accounts after you review them.
The Community always has your back, so please let me know if you have more questions.
NO. I will not do that. If Quickbooks online can get data from Paypal from a year back and I don't have to edit do anything - then WHY IN THE WORLD do I have to do so much work if I want to go back farther??? That's ludicrous.
You may utilize a 3rd party app to do so.
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.
For more information visit our Security Center or to report suspicious websites you can contact us here