Skip to main content
Solved

Adjusting Opening Balances in Cash Accounts

  • March 8, 2024
  • 1 reply
  • 119 views

New user here (and new to the company) -- the CPA entered opening Trial Balance balances into Acumatica for the cash accounts as of 1/31/2023.  However, we did not “go live” with Acumatica until 10/1/2023 - still used QB.  How do I adjust those opening TB balances now?  No bank reconciliations have been completed to date.

Best answer by Laura02

Hello @LORETTAH ,

It seems like you have two questions:

  1. How to import previous year GL Trial Balances for months that were skipped, and
  2. How to perform the first bank reconciliation statement in Acumatica.

Correct?

If you’d like to load GL Trial Balances for 02-2023 through 08-2023, Finance → Trial Balance screen.  

When importing Trial Balances in the above screen, you’ll need an Excel sheet containing Account, Subaccount, and YTD Balance (with debits represented as positive numbers and credits represented as negative numbers so that YTD Balance column sums to $0).

In GL Preferences, temporarily set the Sign of the Trial Balance to reversed, load your months in chronological sequence, then set the Sign of the Trial Balance back to Normal.

 

For what period are you planning the first bank reconciliation statement?  If you are planning the first  bank reconciliation statement in Acumatica for 10/31/2023, for example, it’s not a requirement to load all the older general ledger trial balances, in order to balance cash to the bank as long as 9/30/2023 Trial Balance has been loaded.

Reconciling cash instructions are attached.

Laura

View original
Did this topic help you find an answer to your question?

1 reply

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

Hello @LORETTAH ,

It seems like you have two questions:

  1. How to import previous year GL Trial Balances for months that were skipped, and
  2. How to perform the first bank reconciliation statement in Acumatica.

Correct?

If you’d like to load GL Trial Balances for 02-2023 through 08-2023, Finance → Trial Balance screen.  

When importing Trial Balances in the above screen, you’ll need an Excel sheet containing Account, Subaccount, and YTD Balance (with debits represented as positive numbers and credits represented as negative numbers so that YTD Balance column sums to $0).

In GL Preferences, temporarily set the Sign of the Trial Balance to reversed, load your months in chronological sequence, then set the Sign of the Trial Balance back to Normal.

 

For what period are you planning the first bank reconciliation statement?  If you are planning the first  bank reconciliation statement in Acumatica for 10/31/2023, for example, it’s not a requirement to load all the older general ledger trial balances, in order to balance cash to the bank as long as 9/30/2023 Trial Balance has been loaded.

Reconciling cash instructions are attached.

Laura


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