Skip to main content
Solved

Ending cash account balance


Forum|alt.badge.img

Can we adjust ending cash account balance in module banking of acumatica

 

Best answer by Laura02

Hello,

I thought of one more idea:  Is this the very-first-ever bank reconciliation statement for the account shown?

When we reconcile for the first time, Acumatica include all prior migrated cash account balances in the reconciliation statement.

There is a trick, to the very first reconciliation, needed because cleared checks are not flowing from Acumatica’s AP for this reconciliation; cleared checks are ‘rolled into’ a GL balance typically migrated via GL. 

For example, if you are trying to reconcile June 30, assemble a list of Un-cleared checks as of June 30. This list will be found in the prior software, the “old system” that was replaced by Acumatica. For each un-cleared check (or deposit) make a Debit and a Credit to the Cash account via GL. Then return to your June 30 Bank Reconciliation STatement and clear the Debit GL entries you made for uncleared checks and clear the Credit GL entry you made to represent uncleared deposits.

The following “trick” will result in a correct bank reconciliation, with outstanding items and a correct ending account balance.

 

If we have not answered your question, please provide more details.  Thank you!

 

Laura 

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

3 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+16

Hi @kevinheng21 

You can not manually change that. It is based on the formulas. The only way to change it would be to do a journal entry. 


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • July 11, 2023

Hello @kevinheng21 ,

There are many ways to adjust Cash via system transactions:

Receivables:  AR Payments increase Cash Balance.  Void AR Payments decreases Cash Balance.

Payables:  Checks and Prepayments decrease Cash Balance, Void Checks Increase Cash Balance.

General Ledger: Journal Entries can both increase and decrease cash, as Kandy mentioned above.

Banking module:  Banking Transactions, Fund Transfers and Bank Deposits screens can both Increase and decrease cash.

If you suspect a system error, and when a Cash Account was set up in Banking module for a GL account that previously contained a non-zero balance, Banking screen Recalculate Account Balances screen can be used to ‘true up’ a bank account’s balance.

If we have not answered your question, please provide more details about what is wrong with your cash balance, what the balance should be, and what steps you have already taken.

Thank you!

 


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • Answer
  • July 13, 2023

Hello,

I thought of one more idea:  Is this the very-first-ever bank reconciliation statement for the account shown?

When we reconcile for the first time, Acumatica include all prior migrated cash account balances in the reconciliation statement.

There is a trick, to the very first reconciliation, needed because cleared checks are not flowing from Acumatica’s AP for this reconciliation; cleared checks are ‘rolled into’ a GL balance typically migrated via GL. 

For example, if you are trying to reconcile June 30, assemble a list of Un-cleared checks as of June 30. This list will be found in the prior software, the “old system” that was replaced by Acumatica. For each un-cleared check (or deposit) make a Debit and a Credit to the Cash account via GL. Then return to your June 30 Bank Reconciliation STatement and clear the Debit GL entries you made for uncleared checks and clear the Credit GL entry you made to represent uncleared deposits.

The following “trick” will result in a correct bank reconciliation, with outstanding items and a correct ending account balance.

 

If we have not answered your question, please provide more details.  Thank you!

 

Laura 


Reply


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