Skip to main content
Answer

Allocations - Contra/Offset account based off value of other accounts

  • September 22, 2023
  • 2 replies
  • 220 views

Forum|alt.badge.img

Each month we do an allocation entry where we allocate all of the expenses in our corporate branch to our other branches based off a fixed weighting. The problem is, rather than all of the accounts in our corporate branch being $0 after the allocation, we want the total to be posted to an offset/contra account that would making the overall balance in the corporate branch be $0.

Ideally it would look something like this:

 

Best answer by Laura03

Hello @afranklin ,

Acumatica can allocate with Contra Accounts, leaving the original account balances intact.  Below is a screen shot of Finance → Profiles → GL Allocations screen, a sample from my Demo Database showing the Source Accounts tab where the Contra Account/sub may be entered:

Where to configure contra accounts in Allocations screen

HTH,

Laura

2 replies

Laura03
Captain II
Forum|alt.badge.img+19
  • Captain II
  • Answer
  • September 22, 2023

Hello @afranklin ,

Acumatica can allocate with Contra Accounts, leaving the original account balances intact.  Below is a screen shot of Finance → Profiles → GL Allocations screen, a sample from my Demo Database showing the Source Accounts tab where the Contra Account/sub may be entered:

Where to configure contra accounts in Allocations screen

HTH,

Laura


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • September 25, 2023

Thank you so much Laura, this was greatly helpful!