Consistently accurate Uncleared transactions on Bank Reconciliation report

Follow

Rebecca Ralls

• April 11, 2018 04:46

Currently, there is a bit of a loophole with the unreconciled items on the bank reconciliation report.  It is only accurate if it is run before the next reconciliation.  It will only show items as uncleared that have never been reconciled instead of specifically showing items that were not reconciled as of that particular reconciliation.

Example - Cash Disbursement 123 was created in December, but not cashed/cleared until January.  

If you run the reconciliation report for the December period immediately after completing the reconciliation, CD 123 will show up in the uncleared items part of the report.

But if you forgot to run and save the report, and now you've completed the January Reconciliation, but you want to know what was outstanding as of December - if you run the reconciliation report, CD 123 will not show up as an uncleared item - even though it was as of 12/31.

It would be very helpful if the bank reconciliation name and the cleared date, could be written back to the transaction.

Additionally, it would be helpful if the cleared date on the cleared transaction was not allowed to be earlier than the start date of the reconciliation.  i.e. (assuming your statement cycle maps to the calendar month) if I am running the rec for Feb, and I clear a check from December, the default cleared date will be set to the December date on the cash disbursement, even though the cleared date cannot possibly be earlier than 2/1.

1

• 

  Tony

  • April 11, 2018 13:51

  Rebecca, This is a bug. Thanks for the post. We will fix in a Daisy Patch Release or in Fuchsia. Thx. 

  0

  Comment actions Permalink
• 

  Rebecca Ralls

  • July 20, 2020 06:24

  I thought this had been fixed, but I'm having trouble with the uncleared reports in an org again. Seems to be the same issue.  Did something get reverted to an old process?

  0

  Comment actions Permalink
• 

  Nathan

  • August 19, 2020 13:21

  We are also experiencing this issue and it's impacting our team. 

  How/when will this be addressed?
  Is there a patch or back-fix for versions prior to Iris?

  1

  Comment actions Permalink
• 

  Rebecca Ralls

  • August 21, 2020 16:43
  • Edited

  Hi Nathan, I spoke with Accounting Seed directly, and they confirmed that at this time, the only way to get a correct uncleared transaction report from the reconciliation interface is if there are no following reconciliations.  Example - If ther is a reconciliation for February, and you print out an uncleared transaction report for January, it will not include the items that were cleared in February. 

  If you haven't maxed out your cross object references, it's possible to create formula fields on the Transaction object for Cleared Date and Bank Reconcilliation that pulls the value in from all the "clearable" objects into a single field.  (Cash Disbursement, JE Line, Cash Receipt, and Bank Deposit)

  If you have maxed that out, it's also possible to create a Process Builder that writes that information to the transaction when it's updated but PB on the transaction can cause performance issues if you have very high volumes of transactions being created at a time.

  Hopefully AS will fix this is a future release so no work-arounds are necessary.

  If you need help setting this up I can be reached at rebeccaralls (at) gmail.com :-)

  0

  Comment actions Permalink

Please sign in to leave a comment.