Page 1 of 1
Previously Reconciled Cheque Now Appears in Uncleared List
Posted: Wed Sep 11, 2024 3:36 pm
by R.V.Fagan
While reconciling a bank statement dated for June 28th, I discovered a cheque had cleared the bank on June 28th that was actually dated for June 30th inside of PowerChurch. I unselected the “Only show items dated before statement date”, and was able to reconcile that cheque, with the reconcile window then indicating a “To Balance” of zero (I was happy). The printed reconcile report indicates a zero difference, meaning it balanced to the statement balance amount of June 28th.
However, when I reconciled the July bank statement, that June cheque was still in an “Uncleared” state in the reconcile window under “Cheques and Other Subtractions”, and of course it is still there while reconciling August.
Is there an elegant way to now mark that cheque as ‘Cleared’ without now affecting the “To Balance” field?
Re: Previously Reconciled Cheque Now Appears in Uncleared List
Posted: Wed Sep 11, 2024 5:42 pm
by NeilZ
R.V.Fagan wrote: ↑Wed Sep 11, 2024 3:36 pm
While reconciling a bank statement dated for June 28th, I discovered a cheque had cleared the bank on June 28th that was actually dated for June 30th inside of PowerChurch. I unselected the “Only show items dated before statement date”, and was able to reconcile that cheque, with the reconcile window then indicating a “To Balance” of zero (I was happy). The printed reconcile report indicates a zero difference, meaning it balanced to the statement balance amount of June 28th.
However, when I reconciled the July bank statement, that June cheque was still in an “Uncleared” state in the reconcile window under “Cheques and Other Subtractions”, and of course it is still there while reconciling August.
Is there an elegant way to now mark that cheque as ‘Cleared’ without now affecting the “To Balance” field?
If you reconciled the check in June, then it should not be showing up in later posts.
Try this:
1. do a backup ... this is something I will never tire of saying
2. UNDO all the reconciliations back to June
3. Go into Accounts Payable, and find that check by going to the VENDOR record, and checking the history
4. Select the check, click the VOID button, on the next popup window check the REISSUE CHECK box, correct the date, enter the SAME check number in the Check No. box, DO NOT select print. Remember the date as you'll need that next
5. Post ONLY those two transactions to Funds Accounting, it will ask where you want to post, it should show the month the check was written for
6. Do the June reconciliation, it should be zero, then July's, that check should not show up.
Re: Previously Reconciled Cheque Now Appears in Uncleared List
Posted: Wed Sep 11, 2024 6:42 pm
by R.V.Fagan
Neil - Thanks for the prompt response. That was exactly what I was going to do just before I thought I would canvass the usergroup for an elegant way to reach inside the database and just set the "reconciled" tag/field for that cheque book entry.
Re: Previously Reconciled Cheque Now Appears in Uncleared List
Posted: Thu Sep 12, 2024 4:14 am
by NeilZ
R.V.Fagan wrote: ↑Wed Sep 11, 2024 6:42 pm
Neil - Thanks for the prompt response. That was exactly what I was going to do just before I thought I would canvass the usergroup for an elegant way to reach inside the database and just set the "reconciled" tag/field for that cheque book entry.
Always better to do it the programmatic way, rather than fiddle with the data as there are a few tables that need adjusting
