Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowI will be creating multiple credit card accounts in QBO for my new job. Transactions from 5/2020-4/2021 will be from Excel. Transactions from 5/2021 to now/onging will be from the bank (ie. Amex). Do I connect the bank first, or put the transactions created in excel in first? The Excel files will also have more categories than the bank will.
Thanks so much in advance,
Newbie Kiwi
Hi @Kiwi2021,
Thank you for dropping by here in the Community.
I recommend connecting your bank first in the Bank Feeds section. When you link an account, some banks let you download the last 90 days of transactions, and others go back as far as 24 months.
Downloaded data from your bank isn't added to the QuickBooks register automatically. We store your transactions in the Review tab from the Banking section for your approval.
From there, you can choose which data you want to include (see screenshot below).
In case you need the steps on how to add transaction from the For review tab, here's how:
Once done, you proceed with importing bank data from your Excel file. For the detailed steps, check out this link: Manually upload transactions into QuickBooks Online.
I've also attached an article you can use to resolve bank errors, as well as how to update your banking info in QuickBooks: What to do if you get a bank error or can't download transactions in QuickBooks Online.
Fill me in if you have more questions about connecting a bank account or importing data to QBO. I'm always here to help. Take care always.
Another option, utilize the trial version of SlickConnect. It is designed to import into any bank or credit card in QuickBooks Online, so there is no specific setting needed.
https://www.moneythumb.com/?ref=110
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.