GnuCash
Contact   Instructions
Bug 798144 - Reconciliation uses different number than entered
Summary: Reconciliation uses different number than entered
Status: RESOLVED FIXED
Alias: None
Product: GnuCash
Classification: Unclassified
Component: General (show other bugs)
Version: 4.4
Hardware: PC Mac OS
: Normal normal
Target Milestone: ---
Assignee: general
QA Contact: general
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-03-13 22:26 EST by Ken Williams
Modified: 2021-06-12 20:40 EDT (History)
3 users (show)

See Also:


Attachments
reconcile-setup (118.62 KB, image/png)
2021-03-13 22:26 EST, Ken Williams
no flags Details
reconcile-window (74.72 KB, image/png)
2021-03-13 22:27 EST, Ken Williams
no flags Details

Description Ken Williams 2021-03-13 22:26:01 EST
Created attachment 374014 [details]
reconcile-setup

I'm doing a year-end reconciliation of one of my expense categories.  In the reconcile-setup window, I enter the amount `$36,387.59` for the ending balance:

https://i.stack.imgur.com/MDZbG.png

However, the amount shown in the subsequent reconciliation window is different by several thousand dollars:

https://i.stack.imgur.com/yvI3t.png

How is this "Ending Balance" being determined?  Is this expected behavior and there's something else going into computing this value, or is it a bug?

I'm using GnuCash 4.4-1 on Mac OS X 10.15.7.

(Originally posted at https://money.stackexchange.com/q/137593/93037)
Comment 1 Ken Williams 2021-03-13 22:27:01 EST
Created attachment 374015 [details]
reconcile-window
Comment 2 John Ralls 2021-03-13 23:12:02 EST
The reconcile window's Ending Balance is copied from the last balance on the reconcile date, but you should be able to override it with the reconcile info dialog as you appear to have done in the first screenshot. That's always worked for me, and did again just now with GnuCash 4.4 on macOS 11.3beta.

Does the $32474 Ending balance correspond to the balance on some date in the account you're reconciling?

You can try again to set the ending balance amount by reopening the Reconcile Info Dialog with Reconcile>Reconcile Info in the reconcile window's menu.
Comment 3 Ken Williams 2021-03-14 12:16:38 EDT
Thanks, using Reconcile->Reconcile Info, I just noticed something that helped figure this out: when I hit "OK" in the dialog, the $32,474.31 number flashed there for a fraction of a second before going to the reconcile info.  It turns out I had pasted the "$36,387.59" number from a spreadsheet into the Reconcile Info box, including the "$" and "," characters (which seem to be fine in other contexts, e.g. in a register), and apparently the dialog didn't like that, so it reverted to what was there before.

So I guess the bug is in not allowing those characters, or alternatively the user could be told there was a formatting error rather than continuing with undesired input.
Comment 4 Ken Williams 2021-03-14 13:29:37 EDT
(Also - it would be handy to make a button for the "Reconcile->Reconcile Info" menu item, next to the "Finish"/"Postpone"/"Cancel" items.  I hadn't realized that was available [I didn't notice all the menu items changed], I thought to change the info I had to postpone & hit the "Reconcile" button again.)
Comment 5 John Ralls 2021-06-12 20:40:10 EDT
The paste handling has been fixed in git and will be included in the upcoming 4.6 release.

Note You need to log in before you can comment on or make changes to this bug.