>> Treasurer's Tools >> CAMS >> Change Log

CAMS Change Log                             
    

Revision Content by Release
Revisions to CAMS are release periodically in response to TCC-directed changes to Society record keeping requirements, as well as treasurer-suggested enhancements for functionality, useability and documentation.  

Treasurers should download the CAMS spreadsheet annually to ensure they are using the latest software release designed to comply with the Society's financial management guidelines.  Treasurers will be notified through TCC if any release / upgrade is mandatory during the year in order to comply with CRA and the Society's reporting requirements.

The following outlines the major changes contained in new releases of CAMS.
(CAMS Version #  is displayed in the Versions Information block, upper right of the CAMS Main sheet, as at right).  







MainMenu_CAMS_snap.JPG

Release
Date
 Changes
11.04 2017/10/08
  • Tax Receipts ~ display donation amount in English text
11.03 2017/03/26
  • Revenues worksheet ~ add Reconciliation flag to ledger display
11.02 2016/10/26
  • Revenues worksheet ~ revise ledger transaction display sequencing.
11.01 2016/03/03
  • Directors worksheet ~ removed from CAMS; this worksheet was informational only and had no direct  involvement with ledgers and bookkeeping processes.
11.00 2016/02/11
  • Tax Receipts ~ revise print area to encompass one page of 3 tax receipts with cutlines at  ⅓ and ⅔ page positions; print process employs spinner control to select first receipt page, with automatic advance to next 3 donors.
  • Tax Receipts ~ use Society Name from Main sheet  initialization area
  • Gift in Kind ~ increase receipting to 400 Gift in Kind receipts; bug fixes for receipt print function and hidden columns anomalies 
  • UnReceipted Gifts in Kind  ~ support tally of unreceipted gifts from parish as well as gifts transferred from another conference
  • BankRec ~ revise Adjustments area to allow selection of revenue or expense designations; revise balance computation to allow for Excel rounding errors
  • Donations sheet ~ show #donations with no donorname and donors with no donations in Receipts Anomalies Information block
  • Tax receipts ~ add "Issued at" location to all receipt types (Cash, Gift-In-Kind, Bequest)
10.00 2013/09/08
  • Internal changes to support worksheet protection in Excel 2013 
  • Main ~ enable selection of correct spelling of Society name as registered with CRA for each conference (Saint / St. Vincent de Paul etc.)
9.00 2013/01/24 Major changes to accounting classifications and treatment of Gifts-In-Kind required by CRA and National Council
  • Revenues sheet ~ addition of account 4640 Sale of Goods & Services 
  • Expenditures sheet ~ addition of accounts: 4810 Travel expense;  4810 Vehicle expense;  4860 Professional & Consulting fees;  4870 Education & Training for staff and volunteers;  4890 Vouchers paid to Particular Council
  • Gifts In Kind Transferred In ~ sheet added to allow for recording Gifts In Kind received via transfer from another conference
  • Annual Financial Statement ~ reflect new Revenue and Expenditure accounts; Revenues and Expenditures revised to include the Fair Market Value of Gifts in Kind received and receipted by the conference, as well as Gifts in Kind transfered to the conference
  • Receipts sheets ~ revise CRA web address to www.cra-arc.gc.ca/charitiesandgiving
  • CAMS Error system ~ error checking for the primary input sheets (Revenue, Expenditures, GiftinKind, Bequests) standardized to display error messages on top row for common error conditions such as missing transaction dates, unbalanced amounts etc. 
  • All sheets ~ revise society name to "Society of Saint Vincent de Paul" (full word spelling of St.) for all reports and receipt types in conformance with TCC name revision
8.00 2012/07/16
  • BankRec sheet ~ added to CAMS to support reconciliation of bookkeeping balance with bank balance
7.00 2012/02/08
  • Main sheet ~ add donor data Import Export buttons to copy last year's donor name and address data into new CAMS spreadsheet
  • All  sheets ~ lock and password protect all worksheets to prevent inadvertent modification
  • Main sheet ~ add President name and conference phone# to initialization information
  • Annual Financial sheet ~  Page 3 T3010 Summary, report Gift-In-Kind Revenues and Gift-In-Kind Expenditures to Charitable Works or Qualified Donees
  • Revenue, Expenditures, Gift-In-Kind, Bequests ~ add Excel data validation for transaction dates
  • ConfBalances ~ add YearToDate display for monthly accounts summary
  • Bequest sheet ~ provide support for 10 Bequests; revise Bequest receipt format
  • Gift-In-Kind sheet ~ provide support for 200 gift in kind receipts using 2-up print format
6.00 2009/12/18
  • Annual Financial Reports ~ add page 3 Summary for T3010 Section D  preparation roll-up
5.00 2009/02/16
  • Revenue sheet ~ automatically apply Sunday collections amounts from Donations sheet as weekly revenue transactions
  • Donations, Income Tax and Labels sheet ~ expand support from 450 to 600 donors.
  • Help system ~ hyperlink worksheets to topic-specific Help section
  • ConfBalances worksheet ~ add monthly summary of Donations and Poor-Box amounts.
4.00 2009/01/21
  • Tax Receipts ~  incorporate new SVDP National logo  
  • Donations ~ assign fixed receipt serial numbers to donor sheet rows value; enable sort by Receipt# 
  • BookBalance sheet ~ produce monthly rollup by account summary for use in conference reporting
  • Documentation ~ Index hyperlinks for topic lookup
3.00
2004/12/31
  • Initial system offering in Toronto Central Council
2.00
2004/08/05
  • Donation sheet ~ add to system 
  • TaxReceipts sheet ~ add to system 
  • Revenue sheet ~ revise to pick-up donations and poorbox from donations sheet
1.00
2004/08/04
  • CAMS initial system ~ Annual Financial statement and Revenue and Expense ledgers.


<top>