Reconciliation "Check Box"

Hi Again,

I think that this would mainly be for @lubos and also interested to hear any other comments.

When backtracking through transactions trying to sort out problems is there any way that we may be able to get a “Check Box” (or similar) on the transaction screen so that it can be marked to show the transaction has been checked ?

If anyone else has another idea on how transactions can be “marked” on screen, I would love to hear your ideas.

Cheers

Paul

Add a custom field of a convenient type such as list

  • Correct
  • Error
  • Follow up

hmmm, I like your thinking there @Patch! I took the OP’s question to mean something completely different and I want to go down the path I was thinking he meant on the off change it is, and also because if I am on the same page as @scannerangelaust, then perhaps someone can give the pair of us some suggestions.

I manually reconcile, I’m sorry, I realise that’s probably not the norm, but I find it much more in line with how my work flow works best for me.

However, reconciling what’s on my screen in manager vs what appears in my bank account is incredibly hard for various reasons, namely the order is usually the opposite, and items on any given day are usually out of order as well.

I try and look at each day and sometimes by putting fingers on the screen, and other times just repeating the numbers to myself over and over again, I try and virtually (ie in my head) cross off the matched entries.

Given that, the only way I can think of to do it (and I do not do this, I always do it the hard way) is to print both of them out and manually cross off each and every entry that appears on both documents.

You just can’t do that with displays. I wish you could.

The best I have done (and I HAVE done this) is take a screenshot and using paint or a similar tool, I can go through and manually cross off each line item, but then this is limited to the viewing area (which on my 4k monitor is pretty good).

If only the html of my bank’s statement and manager could be manually “highlighted” (aka crossed off) that would solve the issue.

I realise this is definitely out of scope for manager and my bank certainly won’t consider such a tool in the statement, but I’ve often wondered:

if such a plugin for any browser exists that would allow for easily crossing off table rows in a browser window. Does anyone know of any such tool?

If my question is completely off the mark of what the OP was asking, I have no problem with this being split into another thread and I appologis in advance if it has hijacked their question. I just felt this may be what he was asking, and it’s something I have myself considered for quite some time.

@d3mad, you now have control over how many lines appear on a display page. So set the number high enough to show all transactions covered by the statement you are verifying. Drag over and copy the necessary lines and paste into a spreadsheet. Then you have dozens of different tools and methods available for your visual checkoff process.

Or take the easiest route and leave all bank transactions as Pending until you do your verification. Then convert them to Cleared after you have your bank statement available, making sure details are correct as you go, including clearance dates. You can do the clearance in random order in Manager, following down the order of your bank statement. That’s really how the program was designed.

Just import your bank account transactions, daily. weekly. monthly, and then you never have to do a reconciliation again, you just compare the closing balances.

1 Like

I answered @d3mad based on the assumption he wanted to perform a reconciliation.

If you really want the easiest approach, I completely agree with you, @Brucanna. Just look at the balances. I always regarded the reconciliation feature as placating people who cannot separate themselves from paper-based accounting practices. Personally, I think finding a problem through the reconciliation module is more time-consuming than looking at entries, even if you don’t import statements.

As always, I knew that I could rely on the Manager forum to help sort out my problems as I create them
@Tut, @Brucanna, @d3mad and @Patch thanks again for all of your help and support !

It looks as though statement downloading is going to be the way of the future for me !!!

@Patch, With your Custom Field idea, I really like it as it would be great to be able to mark an entry that you need to come back to or that may need special attention.

I did try creating a Custom Field following your suggestion and although a column did appear on the page (screen), I wasn’t able to find a way of entering data or a check mark in the column so would appreciate any advice on what I should have done (or should be doing) to get it right

Thanks again guys !!!

Stay Safe and Keep Smiling

Cheers
Paul

You can only edit a custom field by editing the transaction. So that approach isn’t any faster than the pending/cleared approach. It just lets you display more options.

Now that you point it out, I did do that once when the reconciliation became a real mess and that did work a treat, I had forgotten about that.

I’d never really considered that, I have always just marked them as clear from the start.

I’m the guy that if something can go wrong, it’ll go wrong when I do it. I use to try the automatic import but I was never able to change certain fields or get it into the right accounts. That was a long time ago and probably works better now, but I feel I have much better control and knowledge over my account if I do it myself/manually.

I think one day when I’m feeling more adventurous I may give it another go, I do realise it would probably be easier :stuck_out_tongue:

Bank importing functionality depends on how well you setup your bank rules.

  • Make the rules as specific as possible yet still match the transactions of each type.

  • Expect to need to manually edit some transactions each time.

  • Expect to need to edit some rules

  • Initially check every transaction, then as you gain more confidence less checking is required