Ottawa Valley Air Cadet League

Over the last several months, we have been working on the ACC-9 and advancing many of its features. The new version, in both French and English, is available from either the Ottawa Valley Coordinator or from the National Website.  The new version has the following new features added in:

  • Monthly Report
  • Claims Tracker
  • Budget Tracker
  • Budget Estimator (for the next year’s budget)
  • CRA charity report financials (T3010)

ACC-9 Pre-Requisites

Pop-Up Calendar: One of the new features in the ACC-9 is a pop-up calendar that makes entering dates very simple. This pop-up calendar requires some files normally installed with Microsoft Access. So your computer will require either Microsoft Access loaded or you can install one of these patch files (French or English).  

 Pop-up Calendar Patch - English        Pop-up Calendar Patch - Francais

Macro Security:  In order for the new ACC-9 to operate properly or for the pop-up calendar to function correctly, macro security must be set to either allow macros to run automatically or allow the user to enable them.  If you have problems using the pop-up calendar or find that the ACC-9 does not work properly, follow the links below to change the macro security level to an acceptable level:

Setting Macro Security in Excel 2003
Setting Macro Security in Excel 2007  
Setting Macro Security in Excel 2010

Below is the training package, various reference files and links, and the newest ACC-9 presented during the recent training session. 

If you require any additional information, please feel free to email me:  Ottawa Valley Coordinator

Newest ACC-9 (version 14 single account)
     - ACC-9 Categories Reference Document

Finance Training Presentation

CDT-135 --> RCSU Claim Form

Links to Canadian Revenue Agency (CRA) Files:
T3010-1 --> Registered Charity Information Return
GST-66 --> GST Rebate Initial Application
RC7066 --> Provincial Tax Rebate

The following video clips are tutorials on how to use the various worksheets in the ACC-9.

Here are a few pointers to help you with completing your ACC-9 at the end of the fiscal year.

Double-check that you have reviewed all of your bank statements and all unreconciled cheques and deposits are listed on the data setup worksheet. Unreconciled cheques can go back many months so don't assume that only June cheques will not be reconciled.

Make sure you do not re-enter cheques and deposits that were not reconciled from the previous year into the expense and revenue journals. That is actually double-counting money. Our new local version of the ACC-9 has a section on the data setup worksheet for previous year's unreconciled cheques and deposits.

Use the Inventory worksheet for listing your inventory. The information from this sheet automatically updates the balance sheet. If you overwrite this information on the balance sheet, there should only be a nominal value of $8 or less for inventory. Do not try to use this number to make your ACC-9 balance.

If you use a petty cash, make sure you list petty cash items in the appropriate columns in the revenue and expense journals. If it isn't a deposit or expense from the bank account, make sure it is in the petty cash column.

Don't waste a lot of time trying to get the ACC-9 to balance. Ask for help. Sometimes a fresh set of eyes can find the problem quickly.

When your ACC-9 is balanced and ready for printing, print out 4 copies of the pages marked 1 through 5 (red worksheets) and sign each copy. The copies are distributed as follows:

  • Copy 1 - Keep for your files.

  • Copy 2 through 4 - Submit to the Regional Coordinator (along with a copy of your June bank statement).

If possible, also submit 3 completed copies of your T3010B to the Regional Coordinator at the same time. The Regional Coordinator will do the folowing:

  • Submit a copy of your ACC-9 and T3010B to the Provincial Office
  • Submit your T3010B with a copy of your ACC-9 to CRA.

All ACC-9 and T3010B submissions will be sent "en masse" from our Region.