Can we adjust ending cash account balance in module banking of acumatica
Best answer by Laura02
View original
Userlevel 7
+16
Hi
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.
+18
Hello
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!
+18
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.