Skip to main content
Solved

Adjusted Cash balance (for CA module)

  • November 25, 2020
  • 2 replies
  • 236 views

kboyko43
Freshman I
Forum|alt.badge.img

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?

Best answer by vkumar

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
Did this topic help you find an answer to your question?

2 replies

Forum|alt.badge.img+12
  • Acumatica Support Team
  • 866 replies
  • Answer
  • November 25, 2020

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,


kboyko43
Freshman I
Forum|alt.badge.img
  • Author
  • Freshman I
  • 18 replies
  • January 4, 2021

@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


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