Solved

What is the process for resolving the undeposited funds account?

  • 30 March 2022
  • 5 replies
  • 369 views

Userlevel 2
Badge

Hello,

I am in the process of setting up several new companies for demos. We would like to set up an undeposited clearing account for AR payments. I am not clear on how this works in Acumatica. I found documentation on how to set up the accounts, but what is the actual processing to resolve the undeposited funds account?

1.How are the funds moved out of the undeposited funds and where to? 2. Is it before or after the bank reconciliation? 3. How are check batches deposited? 4. Which account is actually reconciled with the bank reconciliation?  

Please help me get a clear picture of this process.

 

Thank you,

Barbie Jeter

icon

Best answer by Laura02 31 March 2022, 21:21

View original

5 replies

Userlevel 7
Badge +11

Hi @bjeter94 

Refer to the following documentation which primarily explains the process of creating Bank deposits. This explains how the undeposited payment account or a clearing account is being used. 

https://help-2022r1.acumatica.com/(W(6))/Help?ScreenId=ShowWiki&pageid=323644f1-ea34-4377-92bc-c1fcb4a86d05

Hope this helps.

Regards,

 

Badge +16

Hello,

1.How are the funds moved out of the undeposited funds and where to? Use Deposits screen in Banking module

2. Is it before or after the bank reconciliation? Before

3. How are check batches deposited? Use Deposits screen in Banking module to list the payments that were initially recorded to “Undeposited Funds” account, and move them as a group to the Main Checking account. Your Bank Deposit will appear one lump sum on main checking account in Reconciliation Statement screen in Banking. 

4. Which account is actually reconciled with the bank reconciliation?  The Main Bank account.

You did not ask, but make sure Undeposited Funds account is marked ON, for Clearing account in Banking → Cash Accounts screen.

Make sure Undeposited Funds is connected to Main bank account on the Clearing Accounts tab of Banking → Cash Accounts screen.

Userlevel 2
Badge

Thank you both. You both gave me great information. I think I figured all of it out except the Process Bank Transactions will not let me reconcile to move onto the bank reconciliation. When I click one Match to Multiple payments on the right, the left side will only let me choose 1 box. Am I missing a step or setting?

 

 

Userlevel 2
Badge

The Reconciliation Statements let me process and reconcile the batch deposit, but now the transactions still say unprocessed in the “Process Bank Transactions.” Is there anything else I need to do to clean the accounting up?

 

Thank you,

Barbie

Badge +16

Hi Barbie,

Process Bank Transactions is optional and it actually seems to me from your description, like you’ve finished the Reconciliation Statement (difference is $0, you’ve released?).

I think of the cleared Bank Transaction Import process as optional, “the icing on the cake.” Whether or not import works or transactions match themselves when importing from the bank, we can still move forward to manually complete the rest of the bank statement. 

I don’t know whether you need to clean up other things in the accounting from this post alone…. your bank rec seems completed though!

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved