Using the Reconcile feature in myICLUB.com

While there are steps in FAQ https://www.myiclub.com/faq/article.aspx?id=477 on manually checking through club entries, we also have a built in reconcile tool that can be used to track down missing or improperly entered transactions.

From the main Accounting page, click Wizards in the left hand navigation area, then click Reconcile accounts.

The first step when starting to reconcile your club books, is making a backup. While you can proceed without making a backup, we strongly encourage doing so. The reconcile feature gives you the ability to select multiple transactions at once, as well as deleting those transactions, so having a backup is important in case you accidentally delete more than you meant to!

 

After making a backup, you will be taken to the main Reconcile page, which will look like the example below:

 

The reconcile page has several sections, to help keep (or get) your books in balance.

Near the top, you can select which account you want to work on, and enter the ending balance for that account. The site will default to showing the first account in Alphabetical order, and will show the most recent cash balance for that account. You can select a different account, and enter an ending balance for a different time, if you want. This can be especially useful if you are reconciling several months into the year, and want to reconcile on a month by month basis. This top section will also show a Starting balance; this is the balance from the end of the last month that you reconciled. For example, if you have already reconciled January and February, then when you sit down to work on March, the Starting Balance will be the balance from the end of February. As a note, the recocile assumes that all previous years have already been reconciled, and will not show a previous year unless you change the start date to include it.

 

The next section will show all un-reconciled transactions from the earliest date you specify.

The column on the far left shows a set of check-boxes, where you can select transactions that have happened during the time you are trying to reconcile for. In the above example, transactions are showing for January, February and March. these do not all need to be selected, unless you are trying to reconcile for multiple months at a time.

As well, the reconcile shows a short description of the transaction, and the amount of money it added or subtracted on the club books.

Changing the start date here, and clicking submit will adjust both the Starting Balance (since the site will assume you are OK with the transactions from earlier months) and which transactions are shown.

Once a transaction has been marked as reconciled, it is hidden from the list. If you know a certain transaction or set of transactions in a given time are correct, you can mark them reconciled, allowing you to focus on other transactions during the same time.

 

The next section shows information about the last reconcile date, as well as calculations of account values.

The Last Reconcile date shows the date and time you last completed a reconcile. The Show Reconciled box will reveal any transactions during the time period you are working on, that have already been reconciled. This can be used to double-check your work

Below this, is a display showing calculations to help you determine the exact difference between the (Starting Cash Balance) plus (Selected Transactions), and the Ending Cash Balance. This way, you can easily tell whether everything balances out, or if you need to re-check your club books or the broker statement for any missing or mis-typed transactions.

 

The last section, even though it is just a few buttons, can have a significant impact on the work you have done.

The Select All button will select all of the transactions in the reconcile list, from the start date you have entered, to the latest un-reconciled transaction.

The Delete button will Delete any selected transactions. Be careful ! This will delete the transactions from your club records, not just the reconcile list. Don't use this unless you are certain that the transaction needs to be deleted from the club records.

The Cancel Reconcile will take you out of the Reconcile page, if you want to leave without saving your most recent selections and entries.

The Done button will mark any selected transactions as reconciled. The Done button will not be available unless the Difference line shows 0.00 dollars; the site will not mark transactions reconciled if the starting cash plus selected transactions do not equal the ending balance you have selected.

The Done button also does not cancel or close out the reconcile; this can be useful if you want to reconcile several months in one sitting, or reconcile a handful of transactions at a time.