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

CAMS Change Log                             

Revision Content by Release
Revisions to CAMS are released 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 and CRA requirements for registered charities.  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.

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


12.06 2020/07/05
  • Purchased Asset ~ add Annual Non-Cash Asset Summary area 
  • Book Balances ~   add Mth and YTD expenditures to the Acct display area for
    4890 Non-Cash Assets Disbursed and 5050 Non-Cash Assets Disbursed
12.05 2020/03/30
  • Purchased Asset ~ add column for disbursement to 5050 Qualified Donees; tally gift card balance to include disbursements to 5050 Qual Donees 
  • Gift In Kind ~ remove Disp(osition col C); all GIC disbursements (both to NINs and Qual Donees) are to be posted to Purchased Assets worksheet;
12.02 2020/02/27
  • donor namea and address Import / Export enhanced to provide annual donation history in donor Remarks area to assist with identification of inactive donors.
12.01 2020/02/20
  • startup Notice to advise of National Council accounting requirements and Purchased Assets worksheet 
12.00 2020/02/12
  • Purch Assets ~ ledger for purchase and distribution of near-cash assets (gift cards) 
  • BookBalance ~ Balances: add PurchAsset column;  Acctg Summary: add Purch Asset row
  • Annual Financial Stmt ~ Revenue add  line 4650 Gain on Purch Assets
                                               Expense remove 4890 receipted GIK
                                                              remove 4890 UnReceipted GIK
                                                               add     4890 Gift cards expended for Char Works

                                                Balance sheet add line 4170 Gift Cards remaining
11.10 2020/01/03
  • Tax Receipts ~  PDF image copy annotated as Duplicate Copy. 
  • Donations ~ add Search by donor name;
  • Donations ~ add Sort within Collection date
11.09 2019/06/17
  • Regress support for file operations for Mac OSX
    (File Backup, Import / Export, Tax Receipt PDF image file no longer supported). 
11.08 2019/05/10
  • Gift-In-Kind Receipts ~ print receipts with automatic advance to next receipt. 
11.07 2018/12/26
  • Tax Receipts ~ save a PDF image copy while printing  tax receipts 
  • Donations ~add Env# search and hyperlink to donor name
11.06 2018/08/05
  • Donations ~ Sort Curr: sort donors with actual donations currently on file   
                    ~ Sort Mth: sort donors with donation within selected month
11.05 2018/07/29
  • Import / Export ~ optimization of donor name and address import and export functions   
11.04 2018/03/31
  • Tax Receipts ~ revise CRA web address reference to   canada.ca/charities-giving 
  • 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
  • Initial system offering in Toronto Central Council
  • Donation sheet ~ add to system 
  • TaxReceipts sheet ~ add to system 
  • Revenue sheet ~ revise to pick-up donations and poorbox from donations sheet
  • CAMS initial system ~ Annual Financial statement and Revenue and Expense ledgers.