By using this website, you agree to our Terms of Use (click here)
How do I determine which payments make up the balance in a cash clearing account? I tried using the undeposited payments report but that doesn't agree to the balance. Also, the balance continues to rollfoward so it's not clearing in the subsequent months.
It's just a GL Account so you would have to reconcile it outside of the system just like you would do for any Balance Sheet Account unfortunately.
I actually had a customization done for this kind of situation (but it was for inter-company transactions) where you have a bunch of ins and outs that net to zero. You can mark the ins and outs that net to zero in the screen (has to be done manually though), then you know that everything else is the transactions that make up the balance.
I was hoping it wasn’t the worse case scenario to manually match the debits and credits. Which will not match, because the debits are each individual payment and the credits are the batch deposits.
I'd be happy to share the custom screen with you if you want to check it out. It will work as long as the total debit amounts match the total credit amounts.
Yes, please share.
Thanks.
Here you go (rename the file from .xml to .zip):
This Customization Project includes one custom screen called Reconcile Transactions. It's the out-of-the-box Accounts Details screen with some modifications:
Here is a screenshot of the out-of-the-box Accounts Details screen:
And here is a screenshot of the custom Reconcile Transactions screen:
What you do is set the Reconciliation Period in the screenshot above. Then you checkoff the lines that are ins and outs that net to zero. As you checkoff lines, they total up in the Reconciled Balance field in the upper right-hand corner. Currently the screen doesn't enforce this, you have to manually ensure that Reconciled Balance is equal to zero, but that's a feature that could be added. Once you checkoff your lines, you click the PROCESS button on the top which populates the Reconciliation Period value on each individual line with the Reconciliation Period value that is on the top, essentially marking every individual debit and credit with a reconciled period value.
The Reconciliation Period value on each line gets stored in GLTran.UsrReconciliationPeriod in the database.
If you need to clear the GLTran.UsrReconciliationPeriod value, you can change Action in the screenshot above from Reconcile to Unreconcile.
Thanks so much for sharing. I'll let you know how it goes once I get started.
Hi Tim,
I see the GL files, but I don't know how to add them to Acumatica. My user system module access doesn't give me much access options.
You'll want to talk to whoever is managing Acumatica because technically this is a customization and you'll need access to the Customization Projects (SM204505) screen in order to install it.