Skip to main content
Solved

Adjusted Cash balance (for CA module)

  • 25 November 2020
  • 2 replies
  • 227 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?

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


Terms & ConditionsCookie settings