Skip to main content
Solved

Match a Single Bank Transaction to Multiple Business Accounts in Acumatica

  • December 10, 2024
  • 1 reply
  • 33 views
N
Jr Varsity II
Forum|alt.badge.img

Hi everyone,

I’m working on reconciling a bank transaction in Acumatica and encountered a scenario I’m not sure how to handle. I have a single bank deposit (e.g., $96) that needs to be matched to payments or invoices across multiple Business Accounts (customers).

Currently, the Match to Multiple Documents functionality seems to only work within one Business Account. However, in this case, the deposit covers payments for multiple Business Accounts, and I need to reconcile this in the Process Bank Transactions screen.

Is there a way to adjust the settings or configure Acumatica to allow this kind of matching? Alternatively, is there a workaround or best practice to handle this scenario? Any insights or suggestions would be greatly appreciated!

Thanks in advance!

Best answer by Laura02

Hello,

Typically a Cash Clearing or Un-deposited Funds account connected to the main bank account is used to group individual deposits:

  1. AR Payments are received into a clearing account called Cash Clearing or Un-deposited Funds.
  2. Later, individual customer payments are grouped for deposit in Banking → Deposits screen. 
  3. When the Deposit is released, the payments are “swept” out of the clearing account and into the main Bank Account as a grouped deposit whose totals will match the bank transactions.

In the meantime, just skip the un-matched transactions in Process Bank Transactions screen.  Un-matched transactions may be manually cleared line by line in Reconciliation Statements screen. 

Laura

View original
    Laura02
    1 person likes this
    • Laura02
      Laura02
    Did this topic help you find an answer to your question?

    1 reply

    Laura02
    Captain II
    Forum|alt.badge.img+19
    • Laura02
    • Captain II
    • 3132 replies
    • Answer
    • December 10, 2024

    Hello,

    Typically a Cash Clearing or Un-deposited Funds account connected to the main bank account is used to group individual deposits:

    1. AR Payments are received into a clearing account called Cash Clearing or Un-deposited Funds.
    2. Later, individual customer payments are grouped for deposit in Banking → Deposits screen. 
    3. When the Deposit is released, the payments are “swept” out of the clearing account and into the main Bank Account as a grouped deposit whose totals will match the bank transactions.

    In the meantime, just skip the un-matched transactions in Process Bank Transactions screen.  Un-matched transactions may be manually cleared line by line in Reconciliation Statements screen. 

    Laura

    Laura ~ Klear Systems, Inc. Irvine, CA. ~ Click my logo to Follow me ~
    Chris Hackett
    1 person likes this
    • Chris Hackett
      Chris Hackett

    Reply


    Most helpful members this week

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings
    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