Statement date field for cleared transactions

Darrell Burk's Avatar

Darrell Burk

06 Jun, 2018 02:06 AM

For many semi-legitimate reasons, I often have mismatches between the statement reconciliation starting balances as reported in Moneydance vs. the bank statement. I really like to keep things reconciled perfectly, even after I "rewrite" history, and these discrepancies can be very hard to track down.

Here is my suggestion/wish:
1) that there be a place for a "statement date" to be recorded on each transaction (actually, on each credit/debit in an account; i.e. on each side of a transaction)
2) On the start screen for reconciling an account, there be a field for the user to enter the statement date. (The As Of field could be used for this purpose, with a slight change to the UI so that it's obvious that the statement date should be entered there, whether or not the As Of checkbox is checked)
3) In the reconcile window, when a transaction gets marked as "reconciling" and later "cleared", that transaction's statement date gets set to be the statement date provided at the start of the reconciling process.
4) For transactions that are manually marked as "reconciling" or "cleared" in the account registers, the statement date is left empty
5) That there be an account/register view that lists all unique statement dates recorded in that account, along with the total credits and debits and net credit/debit for each statement date. This view would make it very easy to find which statement(s) as recorded in Moneydance do not match their corresponding physical bank statements.
This would help me quickly find which statements I messed up when rewriting history.
This view would also include a summary line for all cleared transactions that don't have a statement date
6) That there be a new search feature, or register view, or something similar that allows the user to display all the transactions in an account that have a specific statement date. In other words, to see the complete list of transactions that are/should be recorded on a specific physical bank statement. This view should also include the usual bank statement summaries of total credits and total debits and net credits/debits.
Once the view in 5) helps me find the messed up statements, I can use this view to compare those statements to the physical bank statement to easily find the discrepancy.
Like 5), this view should also be able to show all the cleared transactions that don't have a statement date.

To me, this seems to be a fairly simple yet powerful change that would take reconciliation to the next level by allowing us to track not only whether a transaction has been reconciled, but also which bank statement it was reconciled against. It will make it much easier to track down and fix reconciliation discrepancies.

  1. System closed this discussion on 05 Sep, 2018 02:10 AM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts


? 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