Solved

Recording Opening & Closing Balances

  • 30 September 2023
  • 1 reply
  • 79 views

Userlevel 6
Badge +3

Hello Community,
I wanted to clarify if we can record the opening balance for a particular year manually by creating a GL transaction instead of importing them (in case if someone doesn’t have the previous records to be imported). If yes, then what would be GL entry. Also the same scenario for a closing balance.

Thanks in advance.

icon

Best answer by Laura02 30 September 2023, 13:13

View original

1 reply

Badge +18

Hello @Harshita ,

We can’t import directly to a beginning balance field: the ending balance from a prior field naturally becomes the beginning balance of the next. 

We can import ending balances to each period using Trial Balance screen of Finance module. When you import Trial Balances using ending balances for every period in sequence, Acumatica calculates the period debit/credit and creates a GL batch for each period. The beginning balance is also calculated for you.  There is a related setting in GL Preferences that allows you to choose Normal balances or Reversed, depending on how your client provided their ending balances.  I think Finance - Transactions - Trial Balances  the easiest way to migrate GL.

HTH, 

Laura

 

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