Skip to main content
Answer

Quickbooks and subaccount functionality

  • May 12, 2025
  • 1 reply
  • 52 views

Hello,

As anyone overcome the challenge of Quickbooks’ subaccount functionality when converting to Acumatica?  Within QB, when one or more accounts is made a subaccount of another(i.e. parent) account then the balances of the subaccounts will roll up into the balance of the parent.  Many users of QB leverage this functionality for fund accounting especially with cash assets where they have a single interest bearing account at the bank but need to maintain separation for earmarks (e.g. restricted, capital projects, special events, etc).  The problem is not setting up the separate accounts in Acumatica or reporting but with reconciling to the bank statement.  From what I can tell, Acumatica only offers a one-to-relationship between a cash account and a GL account and therefore have not found a way to link the transactions in the fund accounts to the cash account.

 

  

Best answer by aaghaei

@ggraham96 That is not true. You can map each back account that you have to a single GL account and a corresponding Subaccount for your bank account. So, one GL and multiple sub/cash account that each sub and cash account have one-2-one relationship

1 reply

aaghaei
Captain II
Forum|alt.badge.img+10
  • Captain II
  • Answer
  • May 14, 2025

@ggraham96 That is not true. You can map each back account that you have to a single GL account and a corresponding Subaccount for your bank account. So, one GL and multiple sub/cash account that each sub and cash account have one-2-one relationship