Data

Save yourself some pain: collect Tslip data and secure consent for e-distribution upon contract

One of the most painful parts of Tslip season is tracking down any missing information for recipients (e.g. SIN, address, email address) so that you can submit their tslip to the CRA and distribute their copy by the February 28 deadline. 

This can be particularly difficult with T4A recipients who are engaged on a short-term basis,  or who are living elsewhere and not in regular communication with your organization. Sometimes contract workers don’t file their income taxes on an annual basis, and therefore do not feel the same sense of urgency in regards to receiving their T4A on time… but when they’re ready to catch up, they don’t want to be delayed! 

The best way to avoid the pain is to collect all the necessary data upon engagement of the individual. Consider making full name, SIN, phone number, address, and email address standard fields on a contract, letter of agreement, or other initiating document so that you are ready for T-slip season before you pay the individual. 

And, since e-distribution of T4As, T4ANRs, and T5s (as well as certain T4s - click here for more info) requires consent from the recipient, add another standard field on your contracts to allow each individual to confirm their email address and opt in to receiving their tslip via e-distribution. 

Taking a bit of extra care at the contracting phase will save you a lot of frustration when February rolls around.  
 

Anna Mathew talks to ACCA about the role of the information manager in the arts

Empowering Arts Organizations in an Information Age

By Anna Mathew, Knowledge Associate (Young Associates)
Originally published in the February 2015 ACCA e-bulletin

Technically, I’m a librarian. So why have I joined Arts Consultants Canada?

Well, I work for Young Associates, a team of consultants working primarily with arts organizations in a variety of areas, most significantly financial and data management. I believe the field of library science - now more frequently referred to as information science, information studies, or even just ‘information’, has broad applications to sectors beyond the public, academic, school, and traditional corporate (e.g. legal and medical) settings to which we are accustomed. The information specialist is no longer restricted to within the library walls and now frequently finds him/herself in an embedded role within an organization which has a non-information related mandate but needs someone to perform information retrieval and information management duties to support that mandate. What I’m saying is, in our ‘information age’, a librarian can find him or herself working anywhere.

It’s no surprise that we don’t come across too many arts organizations who can afford to keep a permanent, embedded information specialist on staff. Sure, some of the larger organizations have a researcher or two, but for the most part, arts organizations have too much administrative overload and too many budget constraints to deal with to consider creating a formalized role for an information manager. Enter the arts consultant.

In the Spring 2014 ACCA newsletter, my Young Associates colleague Samantha Zimmerman wrote about how consultants can play a leadership role in getting arts organizations to consider their statistical data as ‘SMART’ data, and to set goals and put systems in place to make data part of a larger picture in preserving and communicating an organization’s story. That sentiment is echoed by Negin Zebarjad, a consultant at Nordicity, a consulting firm that earlier this month hosted a panel for Artscape Launchpad on “The Power of Data on Communicating Your Impact”. Zebarjad focuses on good design and clear goal-setting, and emphasizes that arts organizations need to become aware of what data they are already collecting and think about how it can be threaded into the narrative they want to tell about themselves. During the panel, representatives from major funding bodies stressed the importance of seeing a balance of qualitative and quantitative information from organizations when assessing impact. Smartly organized data - which is collected, preserved, analysed, and presented according to well-designed systems and in support of clearly articulated goals - makes that qualitative-quantitative balance possible; this is becoming more relevant as CADAC is looking for correlations between the financial and the statistical data they receive.

The information specialist’s role in consulting with arts organizations goes beyond accessing and manipulating a client’s database. We can offer arts organizations assistance in understanding how information moves through their organizational ecosystems and how it is affected by software, hardware, and, most importantly, people. By undertaking strategic exercises like organizational data flow visualizations and goal setting, and hands on activities like database design and cleanup, we can increase efficiency and strengthen identity.

A favourite instructor at the University of Toronto’s iSchool said: “A librarian helps people find stuff”. (Full disclosure, he might not have used the word ‘stuff’). Another memorable instructor put forth a ‘cocktail party’ definition for the term information architect (a kind of information specialist) as someone who: “is supposed to make sure that people can find what they’re looking for without getting lost or confused.”

Arts consultants armed with information skills can do both those things by helping organizations become information literate and empowering their stakeholders to use that information to operate efficiently, to advance their mandates, and to extend their reach.

Ten Tips for Making Clear Connections Between your Database and Financial Software

What is a database? A database is a means for organizing, storing, managing, and retrieving information. Your fundraising, box office, sales and accounting software are all considered to be types of database software.

Bookkeeping packages (e.g. QuickBooks, Simply Accounting) spreadsheets (e.g. Microsoft Excel) and database software (e.g. Sumac) are electronic tools for delivering a narrative on your operations and programs.  It is essential that you pay attention to the stories they tell;  it is equally important that these different sources communicate effectively with each other in order to deliver a  meaningful tale.

  1. Who’s doing the talking? It is important to be consistent when communicating financial information. Decide which system will do the talking and which will do the listening. Having information flow in one direction will reduce errors, confusion, or missed transactions. Multiple databases in a single organization should be used simultaneously and reconciled to each other on a regular basis. Integrating your databases into your daily routine will help to support sound management.
  2. Speaking the same language. When communicating financial information from one system to another it is important that the allocation is the same in both systems. For example, if you are tracking donations that are associated with a certain project or event in your database software, make sure you make the same allocation in your accounting software. This will help in the future when pulling reports from either system or doing reconciliations.
  3. Doing a little bit at a time. Errors more often happen when you try to condense information. While it might be more efficient to do weekly reports, errors may occur if financial information provided by the database software doesn’t match what is in the bank. For example, if you are doing daily credit card batches, than weekly reports may not catch the information you need. Batch totals and generated reports need to have the same time parameters. Keep things simple and work on a consistent basis. While it might take a little longer initially, it will make it easier to identify errors, saving time in the long run.
  4. Take time for the details. It might be easier to group contact information together when going from one system to another, but it can contribute to errors. Make sure whatever information you are tracking in one system is communicated to the other system. For example, record individual names and donation amounts rather than a batch total.
  5. Keep an eye on things. Try doing regular reconciliations and comparisons between your database software and financial software. Tracking as you go will make doing a year-end reconciliation go smoothly, and will help you know where you are in regards to budget vs. actual.
  6. Remember what you did. You are only as good as your information. (Garbage In/Garbage Out). If your database software gives you the option to record communications, such as emails, memos, or notes, try using the function with regards to financial transactions. If you have special notes relating to a transaction, record it in the communication notes for that contact for easy reference.  Storing important information pertaining to donors or other contacts will contribute to organizational history and make staff transitions easier.
  7. Don’t leave it to the last minute. We are often leaving grant reports and year-end audits until the last minute, when it can be a headache to go back through months of activity to get the information needed for the report. Track as you go in both the database software and financial software. Doing it in both will act as a double check to make sure the numbers are correct, as well as take some of the stress of that last minute report.
  8. It’s okay to anticipate. It is common to anticipate transactions, especially those reflecting revenues (eg. Held tickets, pledges, and confirmed grants). Make sure that if you are entering an anticipated transaction into your database software as a receivable, that you communicate that information to the financial software. Not doing so could result in double counting the revenue when the money does actually arrive. Be sure to compare receivables list from all databases on a regular basis.
  9. Break it down. Most database software packages will allow you to break out details on transactions. Breaking out gross amounts, taxes, and any service fees applicable will help eliminate errors or the need for further calculation when entering data into the financial software. Make sure you have taken full advantage of all the setup features to automate standard charges (eg. service charges and sales taxes).
  10. Where it all belongs. Similar to your financial income statement where revenues are tracked on a yearly basis, it is important to do the same in your database. Most database software doesn’t have the concept of deferred revenue, so you may have to indicate what year funds are allocated to. For example, allocating things like donations, grants, and ticket sales to your 2009-2010 season will make reconciling and reporting easier. It will also help in the budgeting process when you are able to pull up reports with precise data pertaining to certain years.

This tip sheet was created by Samantha Zimmerman of Young Associates. Founded in 1993, Young Associates provides bookkeeping and financial management services in the charitable sector, focused on arts and culture. Young Associates also provides consulting services in the areas of data management, business planning and strategic planning. Heather Young published Finance for the Arts in Canada (2005), a textbook and self-study guide on accounting and financial management for not-for-profit arts organizations.

Disclaimer