Simplifying Your Community Finances with Quicken

Keeping track of your community’s finances can be a chore, especially if you’re using a written checkbook or homebrew Excel sheet. When it comes time to do your STC budget or financial report, guessing at the expenses and income for all the budget categories can be tricky. We recommend you use Quicken to track your community expenses. Quicken is a software application for both the PC and Mac.

What benefits do you get from using Quicken to manage your community finances?

  • Budget categories used to track income and spending.
  • Automatic updates from your bank and PayPal.
  • Reports for budgets and chapter leadership meetings.
  • Mobile app so community leaders can see funds available.
  • Data is automatically backed up.

Budget Categories

Quicken electronically tracks your spending into budget categories that you determine. For STC communities, the annual budget form contains all the budget categories you’ll probably need. In the following images, I illustrate how I’ve configured Quicken to use the same budget categories listed in the STC budget form:

Expense Categories Income Categories

Don’t worry about having to set this up in your own copy of Quicken. I’ve created a blank Quicken database with all of the default STC categories created for you. Download the sample Quicken File, unzip it, and open it in Quicken Deluxe 2016. There is a cheaper version of Quicken available, but it claims that you can’t import files. Now Quicken Basic is probably what your chapter needs, and if you buy that you may have to enter the budget categories yourself.

Whenever you receive income or spend money, you are prompted to associate the transaction with a budget category. At any time you can call up a pre-generated report to see how much has been placed in each category. You can customize the reports to show you monthly income and expenses, so you can see how much individual events has gained or cost your community, for example.

Monthly Expense Report

When it comes time to prepare the STC budget, this reporting feature makes filling in the budget form simple. Generate a report from Quicken, and then copy and paste the numbers into the matching budget categories. With this method you can fully complete a community budget form in under an hour. Maybe even 30 minutes if you’re good with the copy/paste technique.

Automatic Updates

If your bank offers an electronic integration with Quicken, and many banks do, you can download your transactions directly into Quicken. The same goes with PayPal, which does integrate with Quicken. This will simplify tracking your income an expenses as all you will have to do is approve the records as they are imported. No bank or PayPal account is perfect, and sometimes duplicate transactions may be downloaded, so be sure to double-check items before adding them to Quicken.

Mobile App

Quicken offers a free mobile app. Anyone can install it and configure it to point to their community bank records, if they are given access. You must have an Intuit ID and password, and your community Quicken records must be set to sync with the Quicken cloud to do this.

Information is Backed Up

Quicken automatically backs up your database as frequently as you like. Place this backup file in a place where other appropriate community members can access it, such as Google Drive or Dropbox, and never fear about your data walking out when the last treasurer retires.

Conclusion

In order to make best use of your financial tracking, keep your community records organized, and simplify your accounting life, try using Quicken.

  1. Download Quicken Basic or Deluxe from www.quicken.com.
    1. Optional: Download the sample Quicken File as a starting point. It contains the basic budget categories from the STC budget form. It was made in Quicken Deluxe 2016.
  2. Customize the budget categories to meet your community needs. Not hosting a banquet, but instead organizing a conference? Just edit the budget category to say Conference instead of Banquet. (Tools > Category List)
  3. Set up your community checking, savings, and PayPal accounts so they automatically download into Quicken.
  4. Generate the reports to see how your expenses and income are budgeted.
  5. Install the mobile app (optional) so you or other community leaders can see your finances on the go.
  6. Back up your data to your community’s cloud storage, in a restricted treasurer folder.
  7. Complete your community budget and financial reports within an hour.

If you have any questions or comments, let me know.

Add Social Media Icons to Your Website

A popular method of connecting your site to social media is to use social icons. Social icons are icons for various social media sites, such as Facebook, LinkedIn, and Twitter. When a visitor to your site clicks an icon, it links them to the appropriate social media site, highlighting your individual page there.

Some WordPress themes have social icons built in, but not all do. So if you’d like to add them to your website, you can follow these steps. In this example, I will assume you are using WordPress to host your site. However, the code is HTML and can be added to any site. Simply ignore the WordPress-specific steps if you are not using WordPress.

Obtain Icons

Your first step is to obtain social icons. You can do this by looking on the CAC website and right-clicking our social icons so you can save them to your machine. Save each one locally.

Upload Social Icons to Your Website

  1. Go to your WordPress Dashboard.
  2. Click Media > Add New.
  3. Drop the social media icon graphic files in the box, or use the dialogue window to select them.

Create the Icons on Your Website

  1. Go to your WordPress Dashboard.
  2. Click Appearance > Widgets
  3. From the Available Widgets area on the the left, drag a “Text” widget to the appropriate widget area on the right. There are different widget areas, depending on your website. The CAC put theirs in the Primary Widget Area, but other areas may be more appropriate for you, depending on your website layout.
  4. Click the expansion arrow on the text widget that you just placed in a widget area on the right.
  5. Enter a title, such as “Connect with Us”.
  6. In the Content field, you enter HTML. In the sample text below, you will see the file paths for the icon files as they are stored on the CAC website. You will have to change the path and file names to match the files you uploaded.

Sample HTML

Note: You will probably have to customize the red text to match your specific site information.

<a href="https://twitter.com/STCCAC"  target="_blank"><img src="http://www.cac-stc.org/wp-content/uploads/icon-twitter-24.png" alt="@STCCAC on twitter"></a>&nbsp;&nbsp;

<a href="https://www.facebook.com/stccac"  target="_blank"><img src="http://www.cac-stc.org/wp-content/uploads/icon-facebook-24.png" alt="STC-CAC on Facebook"></a>&nbsp;&nbsp;

<a href="https://www.linkedin.com/groups/2926" target="_blank"><img src="http://www.cac-stc.org/wp-content/uploads/icon-linkedin-24.png" alt="STC LinkedIn group"></a>&nbsp;
 
<a href="http://www.stc.org/" target="_blank"><img src="http://www.cac-stc.org/wp-content/uploads/icon-stc-24.png" alt="STC HQ"></a>&nbsp; 

<a href="http://notebook.stc.org/tag/communities/"  target="_blank"><img src="http://www.cac-stc.org/wp-content/uploads/icon-notebook-24.png" alt="STC Notebook"></a>&nbsp;

<a href="http://summit.stc.org/"  target="_blank"><img src="http://www.cac-stc.org/wp-content/uploads/icon-stc-summit-24.gif" alt="STC Summit"></a>

Save the text after you enter it. Afterwards the social icons should be visible on your site.