Solved

Adjusted Cash balance (for CA module)

  • 25 November 2020
  • 2 replies
  • 47 views

Is there any way to see the Adjusted Cash balance in Acumatica?  it would essentially be the the value of bank account, plus unreconciled checks, minus unreconciled receipts, plus other adjustments such as reversals?  This is especially valuable when doing cash management exercises for bill payments.   

Maybe this functionality already exists, but we just don’t know about it?

icon

Best answer by vkumar 25 November 2020, 08:14

Hi @kboyko43 

 

Based on your requirement, the Cash Flow forecasting should help. Here is the documentation link:

https://help-2020r2.acumatica.com/(W(9))/Help?ScreenId=ShowWiki&pageid=415c1ecd-615e-4980-96eb-0edc3620a9e1

One can identify unreconciled checks only at the time of reconciliation of the cash account. Hence, I don't see a way to get the unreconciled checks, receipts information on a daily basis and the adjusted cash balance on any other report/Inquiry.

Regards,

View original

2 replies

Userlevel 4
Badge +4

Hi @kboyko43 

 

Based on your requirement, the Cash Flow forecasting should help. Here is the documentation link:

https://help-2020r2.acumatica.com/(W(9))/Help?ScreenId=ShowWiki&pageid=415c1ecd-615e-4980-96eb-0edc3620a9e1

One can identify unreconciled checks only at the time of reconciliation of the cash account. Hence, I don't see a way to get the unreconciled checks, receipts information on a daily basis and the adjusted cash balance on any other report/Inquiry.

Regards,

@vkumar you are right, it’s impossible to recognize the unreconciled checks.  However, it’s perfectly possible to recognized either “matched” checks or “cleared” checks.

 

  • Matched disbursements - those disbursements that have been imported to Acumatica & matched with an AP bill by someone doing the “Processing” workflow.   No one has finished the Processing of the cashflows to move them to the “cleared” state, but the match link has been established.
  • Cleared disbursements - those disbursements that have been imported & processed in Acumatica.

 

Given the above, do you believe it’s possible to enhance the cashflow forecast screen?

 

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 — 2020  Acumatica, Inc. All rights reserved