What is bank reconciliation and how do I use it?
System
Posts: 412 admin
What is bank reconciliation and how do I use it?
Use bank reconciliation to ensure that all of the transactions on your bank statement have been entered into Wave and that you don't have duplicate income or expenses transactions showing up anywhe...
0
This discussion has been closed.
Comments
reconciliation is not even displayed on my version of it.
Hi @boston126, my apologies about that. Your version of Wave should be upgraded soon, at which point you will have access to this feature! There is no solid ETA for total migration, but we're hoping for sometime early next year.
I don't see a way to check off items in Wave while I'm reconciling. So I can mark them on printed statement but that doesn't show me items in Wave that shouldn't be there (because they wouldn't be checked at the end of reconciling.) There's the option to check items off in Accounts/transactions page but I no longer see a way to sort that page by account. What's your recommended method for marking items against my statement?
Why would you change a perfectly working system to one that you can not reconcile any longer, and even whatever you had reconciled in the past, is no longer accurate. Horrible!!!!
All the starting balances in my reconciliation are wrong even though all my transactions are correct on the site and my statement. so it shows every month is not reconciled
@HeidiD I spent a lot of time looking into this and their recommended method is completely non-intuitive. Rather than have a reconciliation process where you check off the transactions that appear on your statement to determine if your account balances they want you to set up an additional "Money In Transit" account that correlates to each bank account where you put the checks you have written, when they clear you then create a Journal entry to move the money to your bank account. So how do you know how much money you have available to spend considering uncleared checks written? Well I guess you subtract the balance of your bank account from its associated Money in Transit account. Pretty crazy.
UGH I really want WAVE to work but there are so many issues.
Our bank statements quarterly, and we can only reconcile every third month. Is there an option to set reconciliation periods to greater than one month?
Wave
Can you confirm this Money In Transit account process just to carry out bank reconciliation when you have a transaction straddling the end of month. Seems incredibly complicated
Are you unable to see a starting balance for each month from your quarterly report? Does the bank's report not provide a running balance for you? As of now, the time period isn't flexible, but we are looking to make improvements to reconciliation by the end of Q1 2019. I can have the product team consider the implications of your situation.
You're right that our newer accounting platform's account reconciliation feature is incomplete and puts too much onus on our users to track things manually without the rolling balance and checkmark per transaction to more closely narrow in on mismatches. One of our top priorities later in Q1 is to tackle this head on and make improvements, so we hope to have positive momentum for you soon.
Regarding your comments about Money in Transit, this is a standard practice for checks you've written that haven't yet been deposited, so that you can see this information on your reports. What I understand is that because our reconciliation process is now disconnected from the transactions page and that running balance I mentioned, you aren't able to ignore checks that haven't yet hit your bank account statement as withdrawals. Therefore, it looks like your at a mismatch when in fact you'd like to just ignore this Money in Transit. If I'm understanding you correctly, this is also related to one of the things we'd like to make better in the near future, and I'd like to apologize for it being subpar at this time.
CC: @RHC (see above as it relates to your question) -- for now, the Money in Transit technique is the only workaround, and we hope to make this better for you all soon.
Extremely disappointed... I just spent the last 3 weeks reconciling all of our accounts for previous years as we are behind on taxes and an accountant agreed to work with us... I came in to finish 2017 and start 2018, and ALAS! ALL OF MY ACCOUNTS BALANCES ARE OFF AND SHOW AS UNRECONCILED! I need help. I don't know how, but I need help. Even if it's to get all of our stuff out of here and go to another platform. I cannot explain how I have to try to find statments for the last 3 years to do all over again because there was an update in the accounting system and now everything is screwed up!
I've used Wave for several years and it's always been solid and usable, if occasionally quirky. But now...
One feature that every business, large or small, uses is reconciliation. If the new software doesn't have a properly working, straightforward reconciliation system, picking up the reconciled balances from the previous version, then WHY RELEASE THE UPDATE?
The previous system never worked for me due to transactions that straddled statements, but that was fine as I could just mark individual transactions as reconciled and see the reconciled balance change at the top of the page. When it matched my statement balance, I was done. Now I seem to need to reconcile every statement on every account since 2014 to get my books back in balance.
There's two months until I have to produce my end-of-year accounts. The clock is ticking.
What a nightmare. Why "fix" what ain't broke?!?!
HORRIBLE! So many problems with your new reconciliation system! I want to be able to check off each item as verified, not just look a monthly "report" that may not include a check that was written one month and cashed the next or something that went through on the 1st instead of the 31st because of a holiday or weekend. I believe that issue is what has thrown off all of my previously reconciled accounts - now showing up as "unreconciled." Why can't the monthly report dates be changed? Also, why are my PayPal revenue and payments showing up as Money in Transit? My Paypal account is just like another bank account, not money in transit. So frustrating!
Another issue. When you open the reconciliation report and find something that needs to be added or changed, you go in and make the change but the change doesn't show up on the report, even after you refresh it! So what's the use? The beginning balance is way off anyway because it doesn't recognize that your accounts have been verified and reconciled, even though they have. I also noticed that adding a customer is much harder and after you do it the customer doesn't show up, even after refreshing the page. It was so much easier before. Can't you just "undo" the updated system back to how it was???
How do I change the reconciliation (ending balance) date ? None of my accounts reconcile the last day of each month.
When something is not broken, why fix it? The new version is HORRIBLE. First of all , in the past it was so easy to mark a transfer between accounts. Now with this new convoluted way to do it, sometimes new transaction gets created that mess up the whole account. Secondly, the reconciliation!!!! I've reconciled everything in the past as i verified each transaction in the past, and now all of sudden I have to reconcile everything again for the past 2 years since we opened the business???? it simply doesn't make any sense. I wish we could just roll back to the previous version. It was much more user-friendly.
Sorry guys - I have to agree with all the comments. This is not how you reconcile bank statements.
Go back to your old way - it's been this way for 100's of years and it works!
So; transactions, enter the open and close balances and as you tick off items you get back to 0 difference!
Simple = easy = Works
Please please please use the old way!
BTW I now have 4 years of transactions where the reconciliation is saying it's out of balance - before I had everything reconciled correctly - basically a nightmare! Accountant and I have spent over 2 days trying to sort out this mess and got absolutely no where.
You guys are normally so good at adding brilliant features (Love the system), but on this, you've made a serious mistake, you need to roll back pronto...
Same problem as nampara17. Prior to the upgrade my bank account was fully reconciled on paper. We did not keep paper copies back to 2013 because we didn't think Wave would tamper with 5 year old transactions. Yet the balances in the system since the upgrade do not match the hard copy balances from Wave prior to the change. Part of the problem, we discovered, is that there were bank syncs that never hit the ledger until now. Somehow these synced transactions were pushed out to my GL during the upgrade. Unfortunately, the new system does not show the merge history, so I can't tell what's new and what's old. Customer support suggests that I start by using the brand new reconciliation feature to figure out where Wave altered my historical data. Wave altered my historic data and cannot has yet to respond to my request for a backup of my data prior to the change. Every accountant will tell you the first thing you do before an upgrade is back up your data. This is a train wreck!
We appreciate the strong sentiment here, feel your pain, and changes are coming. We acknowledge that you have questions and are confused about the lack of robustness and ease of reconciliation in the new system. We've missed the mark here for you and have to course correct. Our team is presently designing and user testing a version of reconciliation that we believe will meet and exceed your expectations so that we may win back your trust on this front. For those who've migrated over from the old system, these changes will come in steps as quickly as we can bring them to you.
There are legitimate reasons why only reconciling against verified transactions isn't ideal, and that's a behaviour we enabled in our old system that we're looking to help change in the new system. For example, your reconciled balances could exclude transactions on your ledger that then would show up on your reports. This confused many users that are less experienced with bookkeeping, while also causing more experienced users to have a drift of data that was hard to pinpoint.
That said, we know this change has 1) broken historical reconciliation for some people who left unverified transactions in their system, 2) made it unclear what is or is not reconciled due a switch to month-based reconciliation and 3) is a leap that's hard for you to make given our new workflow isn't good enough to make your life easier than before. Bear with us as we look to remedy this in the coming weeks.
I need to do my taxes. I had a hard time figuring out why reconciling was not working right until I found this article. Do you have an ETA as to when it is safe? I need to redo all of last year before I see my accountant.
As it stand, this tool does not in any way help me to reconcile accounts. I look forward to an update as soon as possible. Thanks.
I'm new to having to manage/account finances in respect to running my own proper business. When trying to decide if Wave is the right tool to help, it's probably most important that :
While I can appreciate the strong sentiment discussed, the responsiveness of Wave appears quite impressive. While I'm no expert, it would seem to me that the shift/change from cash to accrual type accounting really does have end users in mind, for the long run. Short term mistakes/pain seem no problem to me as long as they are corrected, in time.
Can anyone else validate this? Am I correct to assume that all these workarounds/feature gaps are (or have been??) a temporary pain as Wave adapts to enable better feature for end user? Is accrual accounting the best way to start out/learn vs the cash accrual if I had my own best interest in mind and expect a growing business?
Thank you,
Alex
We're not using Wave yet but thinking of switching. This thread is quite alarming given the change seems to have negatively impacted a lot of existing users. I am wondering, however, what problems exist with the new reconciliation module as a new user, since it seems like some of the complaints are around lack of backwards compatibility with previous reconciliation data? @Katie_Silkina can you clarify and also, is it correct that Wave now is only offering Accrual accounting or am I misunderstanding?
@jk108 thanks for checking us out! From experience, the reaction to the new reconciliation tool is a mix of pain points for people moving to a different system, combined with some design choices on our end that we need to address. We're currently revamping the reconciliation workflow, and it's a more intuitive, user-friendly process than the current one (I checked out some design mocks, and it looks really promising). Not sure if that's the colour commentary you're looking for from Katie, but that's my two cents.
As for accrual vs. cash basis accounting, one of our many overarching commitments is to creating a robust accrual accounting platform, so the primary accounting logic and functions are going to be consistent with accrual-based principles. That said, the newest updates include more flexible cash and cash-equivalent filters on reports, as well as a cash-modelled Income by Customer report, which we included based on the feedback we received in the legacy version of Wave. Hope that gives some useful insight!
Any updates on if this has been updated? I am having a nightmare of a time trying to reconcile my accounts. Everything was matched correctly, and now my numbers are all out of whack for tax prep.
Hey @arillera, not yet but it should be released soon, and we will be notifying users via the Community when it is released. Thank you for your patience, and my apologies about the situation!
My Balance End Date is in the middle of the month. I see no way to change this. Am I missing something or will this be addressed in the very anticipated update?
EDIT
I found that I can change the date in a newly updated article. Here's to hoping!