Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowWe have a system that processes our member payments for dues and events. We export summary GL transactions from that system and import into Quickbooks. Money is debited into Undeposited Funds. Once the money is actually processed by the 3rd party payment processor and hits our checking account, we do a GL transaction to move the money out of Undeposited Funds and into the Checking account. The problem is the actual deposit does not match the export transaction due to cutoff times. So we have hundreds of items in the QB Make Deposits screen.
Example: On 11/4, summary export/import books $500 to undeposited funds. 3rd party processors deposits $400 into our checking account (the remaining $100 was after the 3rd party processor cutoff time so will post the next day).
Make Deposits amounts match the export/import transactions so I have a deposit of $500 in QB which does not match the actual amount.
How do I get rid of that deposit in Make Deposits?? I will have thousands of them that do not match reality!
Hello, lbit.
We can create a Journal Entry to record the balance from the 3rd party processors.
Here's how:
However, for you to be guided correctly in handling your various transactions, I'd recommend reaching out to your accountant. This way, your books will accurate and precise.
Once done, you can refer to these articles on how we can match the transactions:
Let us know how this works for you. We're always around to help in any way we can.
I had a business with the same scenario. I deposited all of the payments from Undeposited Funds and then adjusted only the last day of the period when reconciling. Although the daily deposits were off due to the payment processor cut-off time, the only day that affected the reconciliation period was the last day since all of the other deposits were compensated for on subsequent days. Due to the volume of J/Es, there was no other choice. It would have been too time-prohibitive to reconcile each day. Not sure if that helps.
Yes, that is what we are doing. We created journal entries to move the funds from Undeposited Accounts into the Checking account to match the actual deposit $ from the 3rd party processor. We also include credit card fees in this transaction.
The annoyance is the Make Deposits count and list. QB thinks all the summary transactions we imported are deposits that have not been made yet. We cannot use the make deposits function because, as I stated, the summary imports rarely match the actual bank deposit due to cutoff times.
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