Frequently Asked Questions (FAQs) How do I handle unreconciled checks and deposits?

1. Frequently Asked Questions (FAQs) • How do I handle unreconciled checks and deposits? • I can’t get the ACC-9’s pop-up calendar to work? • My ACC-9 won’t balance. Where should I start looking?

2. Unreconciled checks and deposits • As you receive each bank statement during the year, you make sure that you select the reconcile check mark beside each entry in the journals. The ACC-9 automatically calculates the unreconciled items for you • When you start your ACC-9 for the next training year, enter all of the previous years unreconciled checks and deposits to the “Data Set up” worksheet. • DO NOT RE-ENTER THESE CHECKS AND DEPOSITS TO THE JOURNALS. They have already been recorded in the previous year so entering them again would be double-counting them and it will cause your ACC-9 to be unbalanced.

3. Pop-Up Calendar • If you do not have Microsoft Access installed on your computer, you will need to run the pop-up calendar patch available at: http://ottawavalleyacl.com/ovacl/acc-9.php The patch simply installs a couple of files required by the Excel macro to execute the pop-up calendar. Please make sure that macros are enabled on your version of Excel. Instructions on setting macro security are also available at the above mentioned website.

4. Balancing the ACC-9 • Some common mistakes made: • Make sure you have entered all bank charges in the journals • Make sure you haven’t entered the previous year’s unreconciled checks and deposits in the journals. They are entered into the data set up worksheet. • Double check that the Start the Year values for lines 1700, 3100 and 3110 from the previous year’s ACC-9 are correct. • If it still doesn’t work, sometimes it is best to have another set if eyes look at it. Have them double check the bank statements against the journals. Look for numbers incorrectly entered, doubled entries, etc.