Differences in net movement (bank reconciliation)

Just an idea for minor improvement with bank reconciliation.

At the top you have closing balances.

At the bottom there is actual transactions and you enter in new closing balances just above that.

It would be handy to have a net difference between the two as a total under the two areas.

It would also be handy to have an indication of which direction the cash flow is, receipt or spend (just to help avoid silly mistakes).

I think this would help when cross checking a date with many transactions, one could just look for that missing transaction in the bank statement.

4 Likes

Obviously I’ve been spending a lot of time in reconciliations over the last few days. Once of my greatest bug bears is the basic screen format:

  • I’d like the top “Net movement” to be right aligned with the bottom “Net movement” so as they flow visually,
  • I’d like the two “Net movement” fields to be summarised in a new table detailing the difference in a single handy spot.
  • A difference/delta calculation would help people like me whose maths isn’t what it use to be.

I often find just seeing the difference value is enough to jolt your memory.

Revisiting this since it’s still a common bug bear of mine, this screen is painful, it would be nice to give it some love :slight_smile:

1 Like

It’s a shame with some of the advancements in bank reconciliations, that the actual reconciliation screen in such a mess.

a) having left aligned tables where the important figures are in the last column would be much benefited by having those tables right aligned. (or all full width). Especially on large monitors, this is a huge design faux par.

b) on the reconciliations tab, IT IS AWESOME that there is now (for some time) a discrepancy amount. That was long overdue. I have wanted this for years, thanks for implementing it. Now that it’s visible somewhere (even if it’s not anywhere useful) is a huge bonus.

c) notwithstanding b), it would be EVEN MORE AWESOME if that discrepancy amount appeared somewhere ON the actual reconciliation screen itself. My current methodology is to add a few entries, jump back out to the main tab, check the discrepancy amount and then move forward making more entries. For the sake of one calculation to have it appear on this screen… Well, I just personally would like to see that :slight_smile: