cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get your business taxes done right with unlimited expert help. Check out QuickBooks Live Expert Tax
JTofu
Level 2

Can I manually add bank transactions, then later, connect the bank feed?

My client has not connected his bank to QBO yet. I want to get started with his books by manually adding the transactions that I've downloaded from his bank. Will there be duplication issues if I manually add January transactions and later, in February, connect his bank to QBO? Just wondering if connecting the bank feed after I've already manually imported them might create duplication issues. 

 

Thanks!

Solved
Best answer a week ago

Best Answers
CamelleT
QuickBooks Team

Can I manually add bank transactions, then later, connect the bank feed?

Yes, you can manually add the transactions. However, doing so will create duplicates once you connect the bank to QuickBooks Online (QBO). Allow me to discuss the details below, JtTofu.

 

When you connect your bank account to QBO, most banks let you download transactions from the past 90 days. This means that if you manually enter transactions for January and then connect your bank account in February, there is a risk of creating duplicate entries. In this case, you need to exclude the January transactions. Here's how:

 

  1. Go to Transactions and select Bank transactions.
    {48D3CACE-1D2B-4B64-9275-49EF0E7F1782}.png
  2. Click the For Review tab.
  3. Tick all the transactions to exclude.
  4. Hit Exclude.

 

Moreover, it's advisable to connect your bank account before adding any entries manually to ensure that duplicate transactions are avoided.

 

Additionally, I'll add this resource to help ensure that transactions are categorized consistently and correctly, minimizing the risk of errors: Set up bank rules to categorize online banking transactions in QuickBooks Online.

Finally, to help you with best practices in handling transactions and making the most out of QBO, consider checking out our QuickBooks Live Expert Assisted team. 

 

If you have other questions about managing bank transactions in QBO, feel free to add a reply. We'll be here to assist you further. 

View solution in original post

3 Comments 3
CamelleT
QuickBooks Team

Can I manually add bank transactions, then later, connect the bank feed?

Yes, you can manually add the transactions. However, doing so will create duplicates once you connect the bank to QuickBooks Online (QBO). Allow me to discuss the details below, JtTofu.

 

When you connect your bank account to QBO, most banks let you download transactions from the past 90 days. This means that if you manually enter transactions for January and then connect your bank account in February, there is a risk of creating duplicate entries. In this case, you need to exclude the January transactions. Here's how:

 

  1. Go to Transactions and select Bank transactions.
    {48D3CACE-1D2B-4B64-9275-49EF0E7F1782}.png
  2. Click the For Review tab.
  3. Tick all the transactions to exclude.
  4. Hit Exclude.

 

Moreover, it's advisable to connect your bank account before adding any entries manually to ensure that duplicate transactions are avoided.

 

Additionally, I'll add this resource to help ensure that transactions are categorized consistently and correctly, minimizing the risk of errors: Set up bank rules to categorize online banking transactions in QuickBooks Online.

Finally, to help you with best practices in handling transactions and making the most out of QBO, consider checking out our QuickBooks Live Expert Assisted team. 

 

If you have other questions about managing bank transactions in QBO, feel free to add a reply. We'll be here to assist you further. 

JTofu
Level 2

Can I manually add bank transactions, then later, connect the bank feed?

Thank you so much! This is exactly what I was looking for : )

GenmarieM
QuickBooks Team

Can I manually add bank transactions, then later, connect the bank feed?

You're very welcome, JTofu!

I'm glad to hear that my colleague @CamelleT was able to provide you with details about adding bank transactions to QuickBooks Online. Your feedback is greatly appreciated, and rest assured that we're always here to help if you encounter any challenges while using QuickBooks.
 

Moreover, you can check out this article for your future use in using bank rules to categorize your bank transactions: Set up bank rules to categorize online banking transactions in QuickBooks Online.

 

We always strive to provide the best solution for your concerns when clarifying anything about bank transactions or if you have other questions with QuickBooks.

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up