Hello,
Is a way to post an entry directly into the Cash account without it impacting the account reconcile module? We’re trying to determine if there’s a method to handle certain entries in cash while leaving reconciliation unaffected.
Thanks in advance!
Hello,
Any system or manual ledger entry that posts to a Cash account will show up on the account reconcile for that Cash account. If you can elaborate a bit further about what exactly you are trying to post and why you do not want to see it available to clear on the account reconcile, perhaps we can help you with a workaround? Maybe is there a ‘closed’ account reconcile involved?
Happy to watch for your reply and determine if we can assist you further!
Best,
CETEC ERP Customer Support
Hello:
The bank recs have had a number of issues in prior years. We have begun to properly reconcile them this year. However in order to close year-ends and true up the GL Acct 111000 (Cash) to the bank, we have had to enter a number of journal entries which are now sitting in the bank reconciliation module.
As at September 30, 2025 the entries we need removed from the reconciliation (NOT THE GL) are as follows:
2023-12-31 GL Entry 86262 -$3,754.42
2023-12-31 GL Entry 86274 $57.97
2022-12-31 GL Entry 86275 -$97,606.58
2023-12-31 GL Entry 86315 $97,858.71
2023-12-31 GL Entry 86320 -$84.51
2024-12-31 GL Entry 86321 $221.48
2025-06-25 GL Entry 88144 $-926.57
We only require these to be deleted from the unreconciled list. We do not need them deleted as actual entries in the GL. Is this something you can help with?
Cam,
I am looking into your question…not sure we support what you are asking for or if perhaps there is another solution the system supports as an alternative.
A couple of things we need to know are what GL accounts were the other side of the entries you list. We can view those manual ledger entries in production environment to see that. Then if what you are requesting is not supported, we can maybe make a suggestion based on what CETEC accounting support has seen is the remedy for your situation for other customers. We think we know just what that alternative is, but want to look further into the entries first prior to offering that solution.
We will get back to you on Monday after consulting with other accounting support staff.
Thank you for your patience.
Best,
CETEC ERP Customer Support
Sounds good, thanks for your help with this! Standing by.
Cam,
So, while we do not support removing the list of splits posting to the 110000 Cash account reconcile (unable to do so without removing from the ledger…), we can explain how year end adjustments typically are handled to get this resolved for you with your October 2025 account reconcile for that account. When the entries were originally made, it seems likely that the DR’s and CR’s to 110000 Cash for 2022, 2023, 2024 and 2025 were not expected to actually clear the bank, but rather were an effort to clean up other GL account activity using 110000 Cash as a clearing account? Usually an external accountant/tax firm would post those adjustments to a Misc Admin GL account or Other/Income Expense rather than 110000 Cash as an offset, on year end date, documenting the reason(s) for the adjustments and possibly (not always) with a reversing entry on the 1st of the following year.
So the entry I am suggesting at this stage (screenshot below) is the sum of the entries need to be reversed in the current year/month via a manual ledger entry to correct 110000 Cash account reconcile. That entry and all prior “trailing” entries can then be cleared in current year/month on the October 2025 110000 Cash account reconcile, checking reconcile box on all entries you listed plus the new DR for the net amount to 110000 Cash. In fact, when you start Oct ‘25 acct reconcile, check the reconcile box on the entries in your list and the new manual ledger entry first, before you clear anything else to be sure clearing those entries nets to -0- in delta field…then continue on clearing Oct ‘25 entries as you would per usual. This will result in the 2022-2025 no longer appearing on subsequent account reconciles.
You might consider exporting pdf of each of the ledger entries and saving to tax files for documentation/explanation as to why the older entries and current entry were/are necessary, and discuss with external/tax accountant as to the trailing unreconciled transactions accumulating that affect 110000 Cash ledger balance and proper account reconcile.
Suggested net two-line entry in box here with entries to clear against each other in Oct ‘25 acct reconcile shaded in green:
Let us know if you have further questions or need additional assistance on this ticket issue.
Best,
CETEC ERP Customer Support
Thank you for this. I will forward this to our accounting team and follow-up if there are questions.
Have a nice day.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
