Reconciliation report
My Cash reconciliation always balances to zero but my reconciliation report always shows a difference because it reflects the current balance as the beginning balance which throws off the target balance, and hence the difference. Is there anyway to reset the beginning balance on the reconciliation report?
Keyboard shortcuts
Generic
| ? | Show this help |
|---|---|
| ESC | Blurs the current field |
Comment Form
| r | Focus the comment reply box |
|---|---|
| ^ + ↩ | Submit the comment |
You can use Command ⌘ instead of Control ^ on Mac
1 Posted by dwg on 30 Sep, 2023 10:31 PM
I'm a fellow user
The beginning balance on the reconciliation report is a calculated number, the calculation that Moneydance performs is:
Initial Balance of the Account + Cleared Deposits - Cleared Payments
So if the beginning balance is not what you expect then it is a problem involving one of these three.
There are a small number of possibilities here, these are:
2 Posted by Peter Poulin on 30 Sep, 2023 11:08 PM
The beginning balance is correct when I do the reconciliation so I don't
want to mess with that. It is incorrect only on the reconciliation report.
On Sat, Sep 30, 2023 at 6:31 PM dwg <[email blocked]> wrote:
3 Posted by dwg on 30 Sep, 2023 11:34 PM
What reconciliation report are you referring to?
There is one that is part of the reconciliation process which you use when marking off entries and there is a standalone reconciliation report.
4 Posted by Peter Poulin on 30 Sep, 2023 11:54 PM
I'm using the standalone report and it is always showing the
beginning balance being the same as the ending balance. What it is doing
is assuming that I'm printing a report for the subsequent month when I
haven't even started another reconciliation. Beginning balance and Current
Balance are always the same with an incorrect target balance and a
difference which is a computed amount based on the above. This is the case
using the current cutoff date of the previous reconciliation. So,
essentially, this report appears useless.
How can I reprint the reconciliation report that comes with the
reconciliation process?
On Sat, Sep 30, 2023 at 7:34 PM dwg <[email blocked]> wrote:
5 Posted by dwg on 01 Oct, 2023 12:12 AM
The only way to get a copy of the report that is part of the reconciliation process is to take a screen shot of it when you are performing the reconciliation of the account and save the resultant image.
The standalone reconciliation report will never be able to create a useful report after the reconciliation has been done. The problem there is that the transactions have no record in them of when they were marked cleared so it is impossible for it to show a true report even if you set the as of date. For this report to work you would have to generate it before the reconciliation and then it should give data approximating the starting position of the reconciliation process.
Another approach you can take to see if it provides a better report for you is to generate a Transaction Report using specific parameters.
Within parameters set:
i. Set the date to range to match the period reconciled. ii. Tick box for using the Cleared field and then select the boxes for "Cleared" and "Uncleared" transactions. iii. Then generate the report.
6 Posted by Peter Poulin on 01 Oct, 2023 12:19 AM
Hmmm.... seems like there should be a way to reprint a reconciliation after
the fact when specifying a cutoff date. I was a Quickbooks advisor and
even in the pro version you could print the prior month's reconciliation.
In the premier version, I could reprint any month. Something to consider
at least for the prior month reconciliation.
Thanks for your help.
On Sat, Sep 30, 2023, 8:12 PM dwg <[email blocked]> wrote:
7 Posted by dwg on 01 Oct, 2023 12:37 AM
That would be something for the developers to consider.
8 Posted by Andrew Hemphill on 28 Oct, 2023 05:53 PM
We are also having this same problem. Please fix.
9 Posted by Peter Poulin on 11 Nov, 2023 01:17 PM
Continuing on this thread.
First, you don't have any cash reconciliation report that is right. Now
that I have a follow up month, I can say that confidently.
Second, This is simply a report formatting error on the part of the report
writer simply not picking up the correct Beginning Balance. This is an
easy fix.
Third, apparently, we can't communicate to the developers. Can you please
present this to them to fix!
Peter Poulin
On Sat, Sep 30, 2023 at 8:37 PM dwg <[email blocked]> wrote:
10 Posted by sth on 11 Nov, 2023 10:06 PM
Ok, this is running the report on the left hand menu under "Reports", right?
You can edit this report to have the correct "ending balance", I think it defaults to zero. But that should be the bank statement "cleared balance". I agree that calculation of the target balance seems to be off from what I would expect. But maybe I am reading it wrong.
Anyway the developers get notified about potential bugs that are mentioned in the forum.
11 Posted by Peter Poulin on 11 Nov, 2023 10:37 PM
It's very simple. Whoever wrote the report used the bank statement "ending
balance" as the "beginning balance" in error on the report. As a result,
the math on the report is wrong, the "Difference" will never be zero or be
reconciled even though the on screen reconciliation shows zero
"difference". Change to field for the beginning balance to the actual
beginning balance and all would be fine. It's not complicated.
On Sat, Nov 11, 2023 at 5:06 PM sth <[email blocked]> wrote: