[coldrick]

When Reconciling a bank account, how do we tell Capital that the account has been reconciled and balances so that it removes the transactions from the Bank Statement tab and greys out the box in the Transactions Tab?

It looks like there is no way to do this and that the system is just supposed to “know” that the current statement has been balanced, but sometimes we come in to do a new reconciliation and the old items are still in the Bank Statement tab, and when we go to the toolbar Reconcile|New Bank Statement it brings up an old statement which is sometimes 2 or 3 statements prior to the current one.

What we are doing is
- Going into the bank account
- Selecting “New Statement”
- Entering the balance details to the window that displays
- Often the dates displayed in the above process are way out, sometimes even showing wrong years.
- Double clicking the item entries to send them to the Bank Statement tab.
- At this point if we need to leave the Transactions screen to go and check on a possible error in another area like Sales Orders or Invoicing, we are sometimes getting strange results when return to the Transactions screen – sometimes the partially reconciled items have been removed and greyed out in the bank statement and we get a message saying that the bank account was out and has been adjusted.
- When we get the account to reconcile we leave the screen

What are we missing in this process? Should there be a step after that last one where we can tell Capital that the account has reconciled and to move all the reconciled items out of the Bank Statement screen?

Rgds

[coldrick]

Another problem in this area are transactions disappearing from the Transactions Screen after being "unreconciled".

I'm e-mailing you some screen dumps to show this.

I had decided to start the reconciliation of one of our bank accounts again and to unreconcile all the transactions back to 1st May, but the display errors are causing all sorts of headaches.

[COBS Tech Support]

While we cannot follow everything you have written here, we think we do understand some of the things you're written and why you may be confused so we'll try to offer some suggestions. You may have come from a system that operated differently from CAPITAL, so you may be having problems "unlearning" your old software perhaps.

The system knows if a page has been reconciled because it then balances. The opening balance + all transactions = closing balance. When this happens the closing balance turns green on the Bank Statement tab.

When a statement is reconciled it does not "disappear". Nor do the transactions that have been reconciled, from the cashbook. Obviously, the transactions still need to be there for reference purposes. You can hide all reconciled transactions by pressing Find and ticking "Unreconciled only".

When you commence a new reconciliation the system takes a guess at what the next statement page number, start, end and opening balances are going to be, based on what's been put in your system. Hence the principle, garbage in, garbage out. The system is only guessing to try to save you some time, but it doesn't know if you intend to reconcile page 231 or page 222 or some other page. Often it will guess wrong, but that's no problem. Just enter your reconciliation details such as start and end date, opening and closing balance.

When you leave the reconciliation and go somewhere else, and then go back into the system, keep in mind that it will not leave the reconciliation you left open. (You might prefer to fire up a second running copy of your software and click between them if you intend to go back and continue your reconciliation.) You may have to specify which page you want to continue working on. Until you do that you might find that the reconciled transactions are ticked grey. This means the transactions have been reconciled but do not belong the currently open reconciliation (if a reconciliation is even open at this point).

[coldrick]

Thanks for that. It's quite easy really when you know how to do it.