What this guide will cover
Reconciling refers to making sure that transactions you see in MoneyWiz are also present on your banking statement. If there's a mismatch, it might mean that you've made a mistake during your bookkeeping (better scenario) or you've unconsciously been part of a fraud and should seek assistance in reclaiming your money (far worse scenario).
This guide explains how to reconcile your transactions on different platforms.
Table of contents
- Reconciling in MoneyWiz for Desktop
- Reconciling in MoneyWiz for Mobile
Reconciling in MoneyWiz for Desktop
Advanced reconcile using Reconcile Assistant
To enter Advanced reconcile, click on the scales button in the top-right:
Regardless of what view you were in, you'll be switched to Expert spreadsheet mode that features a special bar on top:
As for the fields you see:
- Opening date: in this field you set the start date of your bank statement.
- Closing date: this is where you should enter the end date of your bank statement.
- Opening balance: here you enter the starting balance of your statement.
- Closing balance: is the place for ending balance of your bank statement.
MoneyWiz will try to populate all those fields for you but you can change them at any time. For example, when you enter Reconcile mode MoneyWiz by default sets the Opening date as the date of the last reconciled transaction + 1 day, while the Closing date is 30 days later. This means that if the date of your last reconciled transaction in this account is January 5, MoneyWiz will automatically set the Opening date of reconciling as January 6 (a day after last reconciled transaction) and the Closing date as February 4 (30 days after the last reconciled transaction).
MoneyWiz also tries to identify the correct balances for opening and closing balance. If you are reconciling regularly, this should always be a match. If it's not, you should carefully check what is the reason for the difference.
Please also note that MoneyWiz will show unreconciled transactions from the previous statement periods as you may find it useful to make sure there are no missed transactions between the current and the previous statement.
At the bottom of the box, you have two checkboxes that allow you to control the visibility of transactions of certain types. By default, MoneyWiz will display any transactions within the specified range (Opening date - Closing date) but you can control it here.
Now let's talk about the small progress bar and values around it:
- 0 reconciled: this means that no transactions have been reconciled so far. If I were to reconcile one transaction, this number would change to 1.
- 4 unreconciled: this is how many transactions remain unreconciled within the given period.
- 185,86 EUR left to reconcile: similar to above, this tells me how much money in general I still have to reconcile.
Clicking Done closes Advanced reconcile but it doesn't really save your changes - that's because changes are saved immediately, as you reconcile each transaction.
In order to reconcile, all you need to do is simply place a tick next to transactions that you were able to locate on your bank statement. You'll notice that as you do this, the values change:
I have 1 unreconciled transaction for 100 EUR and MoneyWiz tells me that there is 100 EUR in total left to reconcile. Looks like yet another seamless reconciling session!
It is possible however that at some point you'll see a red "n left to reconcile" label:
This means that there's a problem somewhere. You should begin by double-checking:
- Whether the Opening date is correct.
- Whether the Closing date is correct.
- Whether the Opening balance is correct.
- Whether the Closing balance is correct.
- If the above fails, try un-reconciling all transactions and start again, carefully looking for possible problems within transactions themselves.
In this particular case, Opening balance was off by 0,01 EUR. Ah, silly me! Changing Opening balance back to 6 895,00 EUR fixed the problem. Naturally, it might be worth checking why the Opening balance was incorrect. In this case, I was entering it manually so I assume human error.
Please note that your reconciling Closing balance does not have to be equal to your current account balance. If your reconciling Closing date is today and you have no future transactions in the register then indeed those figures should be equal. But if you're reconciling older transactions month by month then remember that the Closing balance will be automatically set to account balance on the date of Closing date.
Regular reconcile method
We highly recommend using the Advanced Reconcile (Reconcile Assistant) in MoneyWiz for Desktop. However, you might prefer simpler method. To begin, switch to Expert view:
You should see a column with checkboxes on the far left side. If not, try changing your column layout by right-clicking on the column headers and enabling Reconcile column.
To reconcile in this mode, simply put a tick next to transactions you see on your bank statement. There's no period to set and MoneyWiz won't verify the opening or closing statement balance for you.
Reconciling in MoneyWiz for Mobile
MoneyWiz for Mobile does not currently feature Advanced Reconcile that MoneyWiz for Desktop offers. For this reason, you can only reconcile transactions in a similar fashion to Regular reconcile method on MoneyWiz for Desktop (see above).
To begin, tap on the pencil icon in the top-right of your Account register and select Reconcile Mode:
From here you simply tap on transactions that you recognise from the banking statement. You'll know that a transaction has been reconciled thanks to the visual change:
Similarly to regular reconciling method on Desktop, MoneyWiz does not check opening or closing dates or opening and closing balance. You just check transactions you see on your statement, ensuring there are no differences.
You can click on the three-dotted icon to the right of the red bar in order to bring up reconciling menu:
- Exit Reconcile: saves your changes and quits reconcile mode.
- Show reconciled: changes the filter to display only reconciled transactions.
- Show un-reconciled: changes the filter to display only un-reconciled transactions.
- Show All: resets the filter to display all transactions again.
- Set all as Reconciled: reconciles all transactions in your Account register. There is no undo!
When you're done, just select Exit Reconcile.