Report for Unreconciled Bank Transactions

Expertise Accounting
1

Looking for a report to show any unreconciled transactions from a bank account

2

@567
If you go to Accounting >> Chart/Ledger >> Ledger and select ‘More Options’ :

image
image1015×317 81.1 KB

then filter for your cash/bank account as pictured:

image
image1021×449 93.8 KB

…the listing will show all unreconciled transactions for that cash/bank account.

Let us know if you need anything further on this.

Thank you!
CETEC Customer Support

3

Thank you.

Is there a way to clear out some of the transactions? It seems there are some old ones that are “stuck” even thought the account has been reconciled to 0 since 1/1/2021.

https://567itg.cetecerp.com/ledger/ledger?account_restriction_select=178&amount_abs=1&display_date_from=&display_date_to=2022-11-05&entry_id=&from_amount=&loaded=1&location_id=&name=&object_id=&object_type=&reconcile=no&reloaded=1&show_more=1&tag=&to_amount=&web_grid-ledgerledger_view_all=1&web_grid_page=1&with_object=

4

@567
You’re welcome! It might be a good idea for you to submit a customer support ticket on this as we are working with some other customers having similar issues…typically involving multiple ‘make-payment’/‘cancel pmt’ in rapid succession…could be similar glitchy thing. I will take a look at your link and reply again as to whether these objects look similar…

Thank you,
CETEC ERP Customer Support

5

@567
We have had some similar requests from other customers regarding trailing, unreconciled items continuously showing up on account reconcile reports. I’ve spoken with engineering regarding your particular case, and while they can “clear” a trailing transaction that is the result of a canceled A/P pmt that seems to “stick” on the account reconcile (this is a known issue, though is getting more and more rare, as we trace down the different causes of this issue & clean / prevent them), the types of entries you have showing up is data coming directly from the ledger, rather than the result of an incomplete make payment/cancel payment.
Unfortunately, there is not a proper way to clear out that ledger data from the bank reconciles prior to a certain date. You can actually reconcile all of it on another acct reconcile; from there, your future reconciles would have closer to what you expect needing to be reconciled.
In the case of what is showing in the GL listing for account 10010, YTD, I would recommend the following:

  1. Create a new account reconcile for account 10010, dated 2022-11-01 using ending bal from account reconcile #51 as both beginning and ending balance
  2. Check as reconciled only the checks/payments & deposits with a posting date prior to 2022-10-31; note the totals for each in the upper account reconcile window. Leave the account reconcile ‘Open’
  3. Make an offsetting manual ledger entry posting on 2022-10-31 to account 10010 for the total amounts of the checks/payments & deposits, posting also to a revenue account and an expense account to zero out the ledger entry
  4. go back to the new account reconcile and clear those offsetting DR & CR amounts which should leave you with a delta of -0- and the same cleared balance as the beginning balance from 2022-10-31

Does that make sense? If not let me know and we can try to walk through it.
I do realize that these instructions will drop PY income/expense reversal into current year…but I’m pretty sure this is the only option to get the data off of the account reconciles going forward.

Thank you!
CETEC ERP Customer Support