HST Estimation Template
PLEASE READ THE INSTRUCTIONS COMPLETELY BEFORE YOU ATTEMPT TO COMPLETE THIS EXCEL
TEMPLATE. THIS DOCUMENT DOES NOT REPLACE ADVICE FROM YOUR TAX ADVISOR, OR FROM THE
CANADA REVENUE AGENCY (CRA). IT IS OFFERED AS A TOOL TO PROVIDE A GENERAL INDICATION
OF THE LIKELY IMPACT OF HST ON YOUR ORGANIZATION, AND IS BASED ON GOVERNMENT
INFORMATION CURRENT AS OF FEBRUARY 2010.
Recommendation for using this template
* Print this document
* Read it to orient yourself to GST, PST and the new HST, and to the template
* Save a blank copy of the template before you start entering your data
* Enter your data
* Check out the blue columns (S, T and U) to learn the estimated impact of HST implementation on your
GST and PST basics
Federal Goods and Services Tax applies to most goods and services purchased by Canadians. The current rate
on most items in Ontario is 5%. You charge GST only if you have registered with the Canada Revenue Agency.
GST provisions allow organizations to claim rebates or refunds of GST paid, under certain circumstances.
Refunds are also known as input tax credits (ITCs); they get you back 100% of what you paid. A rebate is a
partial refund; the rebate rate for charities and qualifying not-for-profits is 50%.
To use this template, you need to know your GST status.
* You may be a non-registrant (i.e. you don't charge GST on anything). Non-registrant charities and qualifying
NPOs are entitled to claim a 50% rebate on all GST paid on purchases. A "qualifying NPO" is a not-for-profit
organization that receives 40% or more of its revenues from government grants.
* As a registrant, you could be filing using the charities method (the default for charities), or the general
method (for commercial organizations and others that qualify to use this method). Rules for claiming a 50%
rebate or a 100% refund of GST paid on purchases are not detailed in this document.
General filers can qualify for a 100% refund of GST/HST paid -- i.e. the tax flows through your books and there is
no net expense to you. If you are a commercial company, you are probably entitled to the 100% GST refund on
all lines. If you are a charity using the general method, you may claim the 100% on the costs of producing taxable
goods and services. You should be claiming back only a 50% rebate on fundraising purchases and any other
costs that help your organization generate non-taxable revenue.
For more information, visit www.cra.gc.ca.
Page 1 of 15
Ontario Provincial Sales Tax (also known as Retail Sales Tax) applies to tangible goods, with a few exceptions.
For instance, insurance premiums and parking are services that attract PST. The current rate for most items is
8%. You charge PST only if you have registered with the provincial Ministry of Revenue. Businesses are exempt
from paying PST if they have a purchase exemption certificate stating that they are purchasing the goods for
resale. (They have to pay PST on goods bought for administration.) Other PST provisions, outlined in RST Guide
806, allow charities to claim tax refunds under certain circumstances.
For more information, visit www.rev.gov.on.ca/en/tax/rst/index.html.
Page 2 of 15
HST transition in brief
In March 2009, the Government of Ontario announced its intention to harmonize the administration of PST with
that of the federal GST as of July 1, 2010. A task force made up of 10 arts service organizations came together
to examine the potential impact on arts organizations, and identify advocacy issues. A key element of the process
was to collect data from a representative sample of arts organizations, and to prepare a sales tax analysis
template to be distributed to their memberships, so that you can analyse your own situation.
This Excel template is based on tax information available as of February 2010. Overall, the government has
stated that the HST will operate like the GST. That is, in cases where the PST rules differ from those for GST,
the GST rules will be used. Some exceptions have been announced -- and it is possible that others will be
granted. For instance, books, magazines and newspapers will be exempt from the provincial portion of the HST.
That is, retailers will charge 5% HST on these items (not 13%) and the buyer thereby receives an 8% point-of-
The government has released transitional rules that address transactions that straddle HST implementation.
Consider: completing a transaction could include a number of steps, from receiving an order to creating the
goods to shipping the goods, sending an invoice and receiving payment. The transitional rules are intended to tax
all transactions fairly -- and to prevent taxpayers from evading the tax by pre-paying for goods and services
before July 1.
14-Oct-09 Transitional rules come into force
1-May-10 Vendors must start to charge HST on goods to be delivered & services to be rendered after July
1-Jul-10 HST implementation date
23-Nov-10 Filing deadline for final RST rebate claims (and RST payable)
Briefly, if you are pre-paying for goods/services that you will not receive until after July 1, 2010, you must pay
HST on those goods/services. If the vendor prepares the invoice after May 1, 2010, they must charge you HST. If
the vendor prepares the invoice April 30 or earlier, you may be obliged to self-assess HST. If a purchaser
receives ITCs, they are generally exempt from self-assessing. If a purchaser is a rebate claimant, generally they
must self-assess -- that is, the government receives their share of the tax, and the purchaser receives their
The transitional rules document is available on the CRA website at
As of February 26, 2010, the government released detailed place of supply rules. These cover inter-provincial
transactions between harmonized and non-harmonized provinces. Most of the Maritime provinces (NS, NB and
NL) presently have harmonized sales tax. On July 1, Ontario and BC join this group. Quebec has partially
harmonized its sales tax with GST. However, PEI, Manitoba and Saskatchewan continue to manage their own
provincial sales tax. Alberta has no provincial sales tax.
Briefly, HST will apply to goods delivered or made available in a harmonized province. It will also apply to
services where 90% or more of the service is performed in a harmonized province, or negotiation for the services
takes place in the province and more than 10% of the service is performed there.
The place of supply rules document is available on the CRA website at
Page 3 of 15
You must understand the rules as they apply to your organization. Besides reviewing the relevant documents,
you may consider it prudent to seek additional training, plus professional advice tailored to your particular
The government has indicated that it will provide a Small Business Transition Credit of up to $1,000, for
businesses with less than $2 million in taxable sales. Advocacy efforts are underway to make the same
assistance available to charities and not-for-profits.
Findings to date about bottom-line impact
The "beta testers" of this template found that, on the whole, they will be better off in terms of bottom-line sales tax
impact under the proposed HST. It remains to be seen how the new tax will affect consumer spending, and
hence ticket sales and individual donations.
The reason is that, under the current regime, PST is a largely non-recoverable expense. Under the HST, the
great majority of arts and culture organizations will be able to claim a rebate or refund of PST paid.
Your bookkeeper will still need to track, in effect, GST Paid on Purchases and PST Paid on Purchases -- i.e. the
federal and provincial components of HST paid. The federal portion will continue to operate under the current
50% rebate and 100% ITC refund rules. The provincial portion will be fully refundable for general filers as an ITC,
and will have a rebate rate of 82% for charities and qualifying NPOs.
It is true that we will have to start to pay PST on items that are currently not taxed, such as artist fees, accounting
fees, office rent, advertising purchases, and other services. However, according to the figures supplied by the
beta testing group, the recovery of PST on tangible goods will more than offset the new tax in a wide variety of
Indeed, paying more tax on services may not be quite as bad as it sounds. Remember, if you are currently a
general filer, you will receive all of the provincial portion back as an input tax credit. If you are currently a
qualifying non-registrant or a charities filer, 82% of that additional tax will come back to you as a rebate -- so
you're not taking an 8% hit! As the following calculation demonstrates, the hit will be only 1.44%:
Page 4 of 15
Fees for services, currently not PST'ed $100.00
8% tax on these services $8.00 < you already pay 5% GST; this picks up the difference to
Rebate of 82% of the 8% tax -$6.56 the 13% HST
Net additional cost to you $1.44
That net additional cost as a % of the fee 1.44%
This calculation is built into the template. If you want to learn specifically how much more (for instance) you will
be paying for advertising or artist fees or rent, you can multiply your current cost times 1.44.
Note on cashflow impact
There may be a significant cashflow impact from the tax, in that you will be paying out (and collecting) more HST -
- so you will be that much more out-of-pocket while you wait to get your rebate or refund.
Note that charities that are registered to charge GST can select ANY filing period -- annually, quarterly or
monthly. You should consider filing GST20, Election for GST/HST Reporting Period, and file returns more often
in order to get your rebates or refunds more quickly.
Organizations that are not registered to charge GST can file rebate claims every six months, maximum.
Basic structure of the template
The task force secured permission from CADAC (Canadian Arts Database, the new digital grant application
format) to model this HST template on the CADAC form. This will make the template easier to use for
organizations that use CADAC.
You will enter your revenues and expenses in Column C.
Be careful! This form is not identical to CADAC. Copying and pasting your grant application data won't work
precisely. You'll probably find it easier to print off your CADAC form and retype the information into the template.
The main difference is that insurance premiums will be taxed differently from everything else, so the consultants
have inserted two rows to capture them. (The assumption is that most companies would record premiums under
Facility and/or Administration expenses.) When you're entering your data, you'll need to subtract premium
expense from your CADAC line, and type it on an Insurance Premium line.
If you're a non-CADAC user, we're asking you to bear with these categories. You will need to take your revenues
and expenses, in whatever format you've organized them, and plug them into CADAC's categories. They actually
work very well to separate items made up mainly/entirely of services (e.g. salaries and fees) from items capturing
goods, or a mix of goods and services. This made it considerably easier to construct the sales tax formulas.
In Columns E through H, you will enter instructions about your company's sales tax status, and the nature of what
you buy and sell. This defines the tax treatment, line by line. The sections below explain in detail how to use
Columns J onward contain tax calculation formulas, and have been LOCKED to prevent finger-slips. If you want
to learn more about locking cells, hit F1 to bring up the Help menu. In the "Search For" box, type "About
worksheet and workbook protection." If you really want to get at the formulas, here's how. Under the Tools menu,
choose Protection, then Unprotect Sheet. The password is "lock," all lowercase.
Page 5 of 15
Here and there, you will find cells with little red triangles in the top right-hand corner. This indicates that there is a
cell comment. Float your mouse pointer over the cell and a box will appear containing useful information and
What the template can tell you
Based on the GST status that you enter into the template, Column M estimates your current sales tax cost:
* On the revenue side, how much revenue you're making from GST. This will apply only to charities filers.
Under the charities filing method you keep 40% of GST charged as revenue. If you are not a charities filer, all
the GST you collect is owed to the government: you are handling tax dollars in trust.
* On the expense side, how much the GST & PST are currently costing you
Remember, this is an estimate! You should check the validity of your results by looking at your past year of
GST/PST sales tax rebate claims or returns. If the spreadsheet template differs significantly from what you filed,
revise the criteria you entered in Columns E through H. The underlying assumption is that if your GST/PST
picture is accurate, the HST picture will also be valid.
Columns O, P and Q estimate the future effects of the HST , using your current financial data and the
government information currently available.
A particular note on arithmetic : Constructing the formulas was challenging. At the end of the day, the
consultants acknowledge that they are not perfect. The intention is to yield a reasonable estimate for decision-
making. For further comment, see the comment on cell K8.
What to enter in cell C9
At the top left of the template, cell C9 has been highlighted in bright yellow: SELECT FILING METHOD. Please
use the down-arrow to select from the list. The formulas require an exact match to specific words.
This step is important! For clarity: click on the bright yellow cell (C9). A down arrow will appear to the right. Click
on the down arrow. A list will appear. Select your filing method from this list by clicking on it.
What to enter in Column E
In Column E, you need to enter the tax treatment for each line. That is, you need to tell the template how items
on this line would normally be taxed.
To help you out, the consultants have set up the template to automatically enter the categories they believe will
be accurate in most circumstances, according to your declared filing method. For instance, items that are exempt
or zero-rated (e.g. donations and grants) have been marked as such. (Exempt and zero-rated are explained in
more detail in a later section; read on…) You still need to review these choices! Cell notes have been created to
provide additional information about tax treatment, to help you edit the template for your particular circumstances.
The spreadsheet works by a series of Excel IF calculations: if the user says "x-category" calculate it this way;
otherwise, calculate it another way. Have a look at the "tax legend" worksheet, which explains tax treatments 1
through 8. The formulas follow these descriptions.
Page 6 of 15
* If you're a qualifying non-registrant, most lines will be 1 (GST only) or 2 (GST and PST). Your bottom-line
shows no GST "revenue" and a non-recoverable tax expense of 50% of GST paid and all PST paid.
* If you're a charities filer, most lines will be 3 (GST only) or 4 (GST and PST). Your bottom line shows GST
revenue of 40% of the tax you collected, and a non-recoverable tax expense of 50% of GST paid and all PST
* If you're a general filer, most lines will be 5 (GST only) or 6 (GST and PST). Your bottom line shows no GST
"revenue" and a non-recoverable tax expense of all PST paid, except as noted below (NB).
* Items that are GST exempt or zero-rated -- i.e. no tax is charged on these items -- will be 7 (no GST, no
PST) or 8 (no GST, attracts PST).
* PST: The two insurance rows contain "PST" as the tax category. Under HST, we will continue to pay 8%
sales tax, completely non-recoverable, on insurance premiums.
NB: If you use the general method and your organization is a registered charity, your fundraising expense lines
(and possibly others, depending on your activities) should be coded 3 or 4, so that you're calculating only the 50%
rebate on costs associated with non-taxable revenues. (This is also how you should be reporting GST presently.)
What to enter in Columns F & G
Column E provides the basic information about tax treatment. However, it doesn't get at cases where a line could
contain a mix of taxed transactions, plus transactions from suppliers who are not registered and thus don't
charge you any tax.
A typical example would be Artists' and Professional Fees, line 5105. Individual artists can register for GST, but
not all of them do. They would not register for PST, because services generally are not PST-able. The correct tax
treatment in Column E could be 1, 3 or 5 depending on how your organization is registered. But how do you
account for some artists charging GST and others not?
You need to identify the sales tax "content" of each line item. That is, what % of the dollar value is taxable for
GST (Column F)? And what % is taxable for PST (Column G)?
Until you fine-tune Columns F & G, the template makes all-or-nothing assumptions that will likely misrepresent
your company's tax situation. For instance, on 5105, Artists' and Professional Fees, the consultants have
assumed that 100% of the fees you pay will be GST-ed and 0% will be PST-ed. You need to look at who you paid
last year, total dollars spent, and what % of those dollars were taxed.
For many organizations in the arts, PST is completely non-recoverable. This isn't true, though, for organizations
that run gift shops and other retail activities. Goods bought for resale are exempt from the PST. The template can
accommodate this. On the expense line where you record inventory costs, think carefully about what percentage
of this line is PST-able. If, for instance, you capture your inventory costs on 5215 General Facility Expenses, the
percentage in column G should under 100%, by whatever portion of the line is exempt from PST.
So, what items attract GST and PST?
Page 7 of 15
Remember: this document does not constitute legal advice! It provides a general overview only. For detailed,
accurate advice, you need to consult the CRA or the provincial Ministry of Revenue. The rules differ for
commercial organizations, charities and not-for-profits.
That said, here's a crash course. It will not cover all cases, but it should help you to make a reasonable estimate
of sales tax for your organization.
As we've covered, suppliers can charge PST and/or GST only if they're registered to collect it. So, how much tax
you pay doesn't just depend on the sort of things that you're buying: it also depends on whether the seller has
registered with the tax authorities.
GST applies to most goods and services. However, some items are exempt or zero-rated. In these cases, no tax
What's the difference? The buyer sees no difference: either way, they don't have to pay the tax. Exempt vs. zero-
rated makes a difference to the seller, however. If you are selling zero-rated goods or services, you are selling
items that are taxed, but at a rate of 0%, so you may be entitled to claim input tax credits on costs incurred to
produce those goods and services. If you are selling exempt items, you may be entitled to claim back a 50%
rebate only, under the rules for charities and qualifying not-for-profits.
Arts organizations typically sell few things that are zero-rated. International touring shows are one of the few
things that fit this category.
For charities, the rule of thumb is that the sale of tangible goods is taxable, but the sale of services is exempt.
Space rentals, for example, are exempt when offered by a charity. Theatre tickets are an exception to the rule:
admissions to a place of entertainment are taxable at the normal rate, just as for commercial companies.
PST applies to tangible goods, with a few exceptions -- e.g. parking, insurance premiums, hotel rooms, labour
charges for repair to tangible goods.
Ontario's retail sales tax has a number of special elements. For instance, there is an entertainment tax of 8%.
Back in the 1980s, the theatre community won a concession: tickets to shows in venues of 3200 seats or less
were exempted from paying the entertainment tax. There is also an exemption for shows where 90% or more of
the performers are permanent residents of Canada. (RST Guide 303.) Arts service organizations have lobbied
unsuccessfully to retain this exemption: ticket sales will be taxed at13% HST.
Getting back to 5105, Artists' and Professional Fees… You now know that there won't be any PST on this line,
because we're talking about services. Should you assume that 100% of your cost in this area is GST-ed? Well, it
depends on who you hire. If they're all registered to charge the tax, then yes. However, if you hire a blend of GST
registrants and non-registrants, you will need to "tweak" the % to match your own circumstances. This thinking
applies to all expense lines on the template.
To add a revenue example to the mix, let's talk about Line 4135, Fees & Guarantees. Organizations that sell
performances, especially to schools, are likely to have encountered exceptions to the GST-on-ticket-sales rule.
Basically, if the buyer of your performance is a non-registrant, or does not charge admission, then you do not
charge GST on your performance fee. If your organization sells shows to both registrants and non-registrants,
you will need to "tweak" the % on that line to match your tax circumstances. You need to apply this thinking to all
sales revenue lines on the template.
Page 8 of 15
We realize that this could be a painstaking task, given the number of line items. However, it makes the template
completely adaptable to individual situations. You'll know that your work is more or less correct if the total in cell
J146 (total GST expense) more or less matches the GST paid that you reported on your returns over the last
year. (Unfortunately, we were unable to build in a comparable test for GST charged.)
What to enter in Column H
This Column captures the anticipated sales tax "content" under HST -- same idea as columns F & G.
Remember: the government has announced that, in cases where the PST and GST rules differ, the GST rules
Thus, to estimate the impact of HST, just copying your GST percentages from column F should work, barring any
tax exemptions that affect your organization.
The calculation columns (locked!)
Columns J & K -- These estimate the bottom-line cost to you of GST and PST. As noted, charity filers will have
GST revenue: the 40% of GST charged that they are allowed to keep.
Column M -- Totals the impacts of GST plus PST. Read down to the bottom, cell M147. This is the estimated
bottom-line effect of the current tax regime.
Columns O, P & Q -- Show the anticipated impact of HST on your organization under 3 scenarios: general filer,
charities filer or qualifying non-registrant. How are you currently registered? Compare Column M to your current
filing method under HST. Then compare it to the other two methods.
Columns S, T & U -- Here is your result! These columns show the estimated difference between the current tax
regime (Column M) and the HST (Columns O, P & Q).
NB: a positive difference means a positive result for your company (less tax). A negative difference means a
negative result for your company (more tax).
Hidden Columns W onward -- Contain various subsidiary calculations that made the formulas easier to manage.
Once you see the estimated effects of the HST, you may decide that you want to change your filing method (if
you have the choice). This template can help you make that decision.
You may have options for electing the general method, or the charities method, or being a non-registrant. The
"tax legend" sheet in this workbook indicates what each means. The CRA website provides information about
who's eligible for what method (www.cra-arc.gc.ca/tx/bsnss/tpcs/gst-tps/menu-eng.html).
You can compare your current tax situation to the estimated effect of HST under the same filing method -- and
under the other options. We hope this will help you evaluate whether to elect any changes.
If you wish to change your filing method, you need to research your options. You need to learn whether you are
eligible to elect a different treatment, and what paperwork you would need to file with the CRA. The CRA website
can help -- see address above -- or phone the Business Window at 1-800-959-5525.
Page 9 of 15
Participants in this research project
Arts service organizations: Finance specialists:
CAPACOA Lindy Cowan, Canadian Opera Company
Community Cultural Impresarios John Goddard, Theatre Ontario
Dance Ontario Lisa Hamel, Toronto Symphony
Dance Canada Craig Morash, Lorraine Kimsa Theatre for
Ontario Association of Art Galleries Young People
Orchestras Canada Consultants:
Professional Association of Cdn Theatres Michael Herrera, CA
Theatre Ontario Heather Young
Toronto Alliance for Performing Arts
Special thanks to Ernst & Young for reviewing this template and making helpful suggestions.
Page 10 of 15
The template refers to the tax rates below. These rates are correct as of February 2010, but are subject to change by the government. Pleas
GST Rate 5%
PST Rate 8%
HST Rate 13%
Charity Method revenue 40%
Charity Method remittance 60%
HST - federal rebate* 50%
HST - provincial rebate* 82%
COLUMN E ON DRAFT TEMPLATE: FILL IN CORRECT # FOR YOUR CIRCUMSTANCES
Note: You will find Column E set up with what the consultants believe are the correct tax treatments for a charity filer.
Category # GST Filing Method
1 Non-Registrant Charity or Qualifying NPO for GST
2 Non-Registrant Charity or Qualifying NPO for GST
3 Charities Filers for GST
4 Charities Filers for GST
5 General Filers for GST
6 General Filers for GST
7 GST Exempt/Zero Rated
8 GST Exempt/Zero Rated
PST This applies ONLY to lines for INSURANCE. We will continue to pay 8% sales tax, completely non
* A NOTE ON TAX REBATES & BOOKKEEPING
The customer at your counter will see a blended 13% tax. And, when you purchase supplies for your company, you will see a blended 13% t
To our understanding, the HST Charged on Sales will go into one liability account.
However, the HST Paid on Purchases is more complicated. Your bookkeeper still needs to track 5% federal component and 8% provincial co
your bookkeeper will need to manage two accounts: Federal HST Paid on Purchases and Provincial HST Paid on Purchases.
The government has not yet released the return & rebate application forms, so we do not yet know how they will require organizations to repo
y 2010, but are subject to change by the government. Please review them before you use this workbook.
< as a charity filer, you keep this % as revenue
< as a charity filer, you remit this % to CRA
< half of the old GST; the rebate rate for non-registrants & charities filers
< a % of the old PST. Different for municipalities & other institutions.
rect tax treatments for a charity filer.
GST Charged on Sales GST Paid on Purchases PST Status
None; non-registrant Claim 50% rebate No PST
None; non-registrant Claim 50% rebate Attracts PST
Charge GST; keep 40% of it Claim 50% rebate No PST
Charge GST; keep 40% of it Claim 50% rebate Attracts PST
Charge GST; remit 100% Claim 100% input tax credit No PST
Charge GST; remit 100% Claim 100% input tax credit Attracts PST
None; exempt/zero-rated None; exempt/zero-rated No PST
None; exempt/zero-rated None; exempt/zero-rated Attracts PST
CE. We will continue to pay 8% sales tax, completely non-recoverable, on insurance premiums.
ase supplies for your company, you will see a blended 13% tax.
ll needs to track 5% federal component and 8% provincial component, because the announced rebate rules treat the two taxes differently. Therefore, to ou
ases and Provincial HST Paid on Purchases.
we do not yet know how they will require organizations to report taxes.
Notes on template formulas
Assume expense # contains 50% non-refundable GST
expense + PST expense
Ditto, and assume revenue # contains the 40% GST
companies are allowed to keep
Assume expense # contains PST expense
reat the two taxes differently. Therefore, to our understanding,
HST Estimation Template
PLEASE READ THE INSTRUCTIONS COMPLETELY BEFORE YOU ATTEMPT TO COMPLETE THIS TEMPLATE. (INSTRUCTIONS APPEAR ON THE 1ST SHEET IN THIS
WORKBOOK.) THIS DOCUMENT DOES NOT REPLACE ADVICE FROM YOUR TAX ADVISOR OR FROM THE CANADA REVENUE AGENCY (CRA). IT IS OFFERED AS A
GENERAL INDICATION OF THE LIKELY IMPACT OF HST ON YOUR ORGANIZATION, AND IS BASED ON GOVERNMENT INFORMATION CURRENT AS OF JANUARY 2010.
In these sections: check HST effect based on your current method, and evaluate possible change to
another method if you're eligible. Visit www.cra.gc.ca for criteria.
SELECT FILING Estimated Estimated HST Effect under Estimated HST Impact - i.e. Difference from
ORGANIZATION: METHOD: Tax Treatment of Items on this Line Current Tax Situation Estimated ALL THREE Methods Your GST/PST Filing Method
GST: what % of PST: what % of HST: what % of Effect of GST
item is GST- item is PST- this item is HST- & PST on Your
Category # able? able? able? GST PST Organization General Filer Charities Filer Non-Registrant General Filer Charities Filer Non-Registrant
Last Year Actuals
4100 Earned Revenue
Producing admissions & box office from subscriptions / admissions
membership or group admissions 5 100% 0% 100% - - - - - - - - -
4110 Producing admissions & box office from single ticket sales 5 100% 0% 100% - - - - - - - - -
4115 Co-production 5 100% 0% 100% - - - - - - - - -
4120 Touring revenue / exhibition rental 5 100% 0% 100% - - - - - - - - -
4125 Presenting / hosting admissions & box office 5 100% 0% 100% - - - - - - - - -
4130 Distribution revenue (media arts) 5 100% 0% 100% - - - - - - - - -
4135 Fees - guarantees (local market) 5 100% 0% 100% - - - - - - - - -
4140 Other artistic revenues & fees 5 100% 0% 100% - - - - - - - - -
Fees from workshops / classes / conferences / annual meetings / seminars /
colloquia 7 0% 0% 0% - - - - - - - - -
4150 Revenue from associated school (gross) 5 0% 0% 0% - - - - - - - - -
4155 Membership dues or fees (not eligible for a tax receipt) 7 0% 0% 0% - - - - - - - - -
4160 Sales, commissions & broadcasting (gross) 5 100% 0% 100% - - - - - - - - -
4165 Facilities & equipment rental, sale of works of art 7 0% 0% 0% - - - - - - - - -
4170 Other earned revenues 5 100% 0% 100% - - - - - - - - -
4175 Total Earned Revenue 0
4200 Net Investment Income
4205 Trust, endowment & investment revenue (net) 7 0% 0% 0% - - - - - - - - -
4210 Total Net Investment Income 0
4300 Private Sector Revenue
4305 Individual donations 7 0% 0% 0% - - - - - - - - -
4310 Corporate donations 7 0% 0% 0% - - - - - - - - -
4315 General corporate sponsorships (cash) 7 0% 0% 0% - - - - - - - - -
4320 Specific corporate sponsorships (cash) 7 0% 0% 0% - - - - - - - - -
4325 Foundation grants & donations 7 0% 0% 0% - - - - - - - - -
4330 Fundraising events (gross) 7 0% 0% 0% - - - - - - - - -
4335 In-kind goods & services revenues from private sector (audited) 7 0% 0% 0% - - - - - - - - -
4340 Other private sector revenues 7 0% 0% 0% - - - - - - - - -
4345 Total Private Sector Revenue 0
4400 Public Sector Revenue
4405 Federal public revenues
4410 Canada Council for the Arts
4415 * Operating grants 7 0% 0% 0% - - - - - - - - -
4420 * Project grants 7 0% 0% 0% - - - - - - - - -
4425 * Other Canada Council grants 7 0% 0% 0% - - - - - - - - -
4430 Department of Canadian Heritage 7 0% 0% 0% - - - - - - - - -
4435 Other federal 7 0% 0% 0% - - - - - - - - -
4440 Total federal public revenues 0
4445 Provincial revenues
4450 Ontario Arts Council
4455 * Operating grants 7 0% 0% 0% - - - - - - - - -
4460 * Project Grants 7 0% 0% 0% - - - - - - - - -
4465 * Other provincial arts council grants 7 0% 0% 0% - - - - - - - - -
4470 Ministry of Culture
4475 * Operating grants 7 0% 0% 0% - - - - - - - - -
4480 * Project grants 7 0% 0% 0% - - - - - - - - -
4485 Ontario Trillium Foundation 7 0% 0% 0% - - - - - - - - -
4490 Provincial employment programs 7 0% 0% 0% - - - - - - - - -
4495 Other provincial 7 0% 0% 0% - - - - - - - - -
4500 Total provincial public revenues 0
4505 Municipal or regional revenues
4510 Municipal or regional arts council / board
4515 * Operating grants 7 0% 0% 0% - - - - - - - - -
4520 * Project grants 7 0% 0% 0% - - - - - - - - -
4525 Other municipal or regional - Operating 7 0% 0% 0% - - - - - - - - -
4530 Other municipal or regional - Project 7 0% 0% 0% - - - - - - - - -
4535 Total municipal or regional public revenues 0
4540 Other public sector revenues 7 0% 0% 0% - - - - - - - - -
4545 In-kind goods & services revenues from public sector (audited) 7 0% 0% 0% - - - - - - - - -
4550 Total Public Sector Revenues 0
Page 14 of 15
4600 Other Revenues
4605 Parent organization contribution 7 0% 0% 0% - - - - - - - - -
4610 Stabilization organization contribution 7 0% 0% 0% - - - - - - - - -
4615 Total Other Revenues 0
4700 TOTAL REVENUES (A) 0 - - - - - - - - -
5100 Artistic Expenses, Including Exhibition, Production, Technical, Programming & Services
5105 Artists' & professional fees 5 100% 0% 100% - - - - - - - - -
5110 Artistic salaries - permanent & temporary employees 7 0% 0% 0% - - - - - - - - -
5115 Copyright payments & royalties 5 100% 0% 100% - - - - - - - - -
5120 Production / technical salaries & fees
5125 Production / technical salaries - permanent & temporary employees 7 0% 0% 0% - - - - - - - - -
5130 Production / technical services professional fees 5 100% 0% 100% - - - - - - - - -
5135 Programming expenses
Exhibition / programming / production / distribution (media arts) / special
projects expenses 6 100% 100% 100% - - - - - - - - -
5145 Loan & acquisition of works of art / performance 6 100% 100% 100% - - - - - - - - -
5150 Touring / circulation expenses 6 100% 100% 100% - - - - - - - - -
5155 Professional development programming for arts community 6 100% 100% 100% - - - - - - - - -
5160 Expenses of associated school (gross) 6 100% 100% 100% - - - - - - - - -
5165 Catalogue / documentation / publications 6 100% 100% 100% - - - - - - - - -
5170 Collections management 6 100% 100% 100% - - - - - - - - -
5175 Education, audience development & outreach 6 100% 100% 100% - - - - - - - - -
5180 Advocacy (arts service organizations only) 6 100% 100% 100% - - - - - - - - -
5185 Member communications (arts service organizations only) 6 100% 100% 100% - - - - - - - - -
5190 Other artistic program & services expenses 6 100% 100% 100% - - - - - - - - -
5195 Total Artistic Expenses 0
5200 Facility Operating Expenses
5205 Facility operating salaries - permanent & temporary employees 7 0% 0% 0% - - - - - - - - -
5210 Facility operating professional fees 5 100% 0% 100% - - - - - - - - -
5215 General facility expenses EXCEPT INSURANCE PREMIUM(S)! 6 100% 100% 100% - - - - - - - - -
INSURANCE PREMIUM (S) PST 0% 100% PST - - - - - - - - -
5220 Permanent collection storage fees 5 100% 0% 100% - - - - - - - - -
5225 Rent or mortgage interest 5 100% 0% 100% - - - - - - - - -
5230 Other facility expenses 6 100% 100% 100% - - - - - - - - -
5235 Total Facility Operating Expenses 0
5300 Marketing & Communications Expenses
5305 Marketing & communications salaries - permanent & temporary employees 7 0% 0% 0% - - - - - - - - -
5310 Marketing & communications professional fees 5 100% 0% 100% - - - - - - - - -
5315 Marketing production fees 6 100% 100% 100% - - - - - - - - -
5320 Advertising purchases 5 100% 0% 100% - - - - - - - - -
5325 Other marketing & communications expenses 6 100% 100% 100% - - - - - - - - -
5330 Total Marketing & Communications Expenses 0
5400 Fundraising Expenses
5405 Fundraising salaries - permanent & temporary employees 7 0% 0% 0% - - - - - - - - -
5410 Fundraising professional fees 3 100% 0% 100% - - - - - - - - -
5415 Fundraising events (gross) 4 100% 100% 100% - - - - - - - - -
5420 Other fundraising expenses 4 100% 100% 100% - - - - - - - - -
5425 Total Fundraising Expenses 0
5500 Administration Expenses
5505 Administrative salaries - permanent & temporary employees 7 0% 0% 0% - - - - - - - - -
5510 Administrative professional fees 5 100% 0% 100% - - - - - - - - -
5515 Rent or mortgage for administrative space 5 100% 0% 100% - - - - - - - - -
5520 Other administrative expenses EXCEPT INSURANCE PREMIUM(S) 6 100% 100% 100% - - - - - - - - -
INSURANCE PREMIUM (S) PST 0% 100% PST - - - - - - - - -
5525 Total Administration Expenses 0
5600 TOTAL EXPENSES (B) 0 - - - - - - - - -
6000 SURPLUS OR (DEFICIT) Cell M 147, Surplus or (Deficit): - - - - - - -
Negative result = a loss for your organization; your net
6100 Total revenue (A) 0 - - -
estimated tax expense
6105 Total expenses (B) 0 Positive result = you are estimated to be "making Cells O147, P147, Q147, Surplus or (Deficit):
money" on the current GST + PST Negative result = a loss for your organization; your Cells S147, T147, U147, Variance to current
6110 Surplus or (deficit) for the year (A-B) 0
net estimated tax expense method:
Positive result = you are estimated to be "making Negative result = an additional cost for your
money" on the current GST + PST organization; HST will cost more than GST + PST
Positive result = reduced cost for your organization;
HST will cost less than GST + PST
Page 15 of 15