How to enter ACH deposits which were not synced to Quickbooks from the Bank?

Mark_NOVA · ‎January 04, 2023

We normally receive weekly ACH deposits into our bank account from a vendor who processes credit cards for us. We have set up our Bank to Quickbooks sync and these ACH payments normally appear in Quickbooks and on our bank statements.

However in May and June last year, 4 of these ACH payments were not synced to Quickbooks, although they were correctly deposited in our bank. Re-doing the bank sync does not get these into QB.

Do you have suggestions on how we should enter these ACH payments in Quickbooks? We also wish to match several existing sales receipts (which comprise these deposits) in QB with these "missing" ACH deposits through the "For Review" tab of the Undeposited Funds/Payments to Deposit in banking.

I think we need to enter a Sales Receipt for the missing deposit into QB.

Thank you.

Candice C · ‎January 04, 2023

Greetings, @Mark_NOVA.

Congrats on making your first post here in the Community. I appreciate you coming here with your question about entering ACH deposits that were not synced with QuickBooks Online.

The best route to get these added to your QuickBooks Online account would be to import these deposits manually. Here's how:

Go to the Gear (Settings) icon in the top right-hand corner.
Under the "Tools" column, choose Import data.
Select the Bank Data option.
Follow the rest of the on-screen instructions.

It's that easy!

Keep us updated on if this works in your favor or if I need to do some more digging on my side to find the right solution for your business. I'll be just around the corner when you're ready!

Mark_NOVA · ‎January 06, 2023

Candice C, thank you for your reply.

I was able to add these 4 missing bank deposits by using the QB import CSV file method. I formatted a CSV file with one line for each of the missing bank deposits and imported that.

This is the article I referred to.

Candice C · ‎January 06, 2023

Good morning, @Mark_NOVA.

Thanks for coming back on this thread and letting us know what you did to add the four missing bank deposits to your QuickBooks Online account.

I'm glad that you were able to get these into your account once and for all.

If you have any other questions or concerns, don't hesitate to reach back out. I'm only a post away if you need me. Happy Friday!

Topics

Training

Community

Resources

How to enter ACH deposits which were not synced to Quickbooks from the Bank?