How to Map Your Chart of Accounts to the T3010 Return

How to Map Your Chart of Accounts to the T3010 Return
Dov Goldberg

By Suzanne Goldberg, LGC

Every June, somebody at your charity opens the annual return, looks at the revenue section, and realises the ledger cannot answer it. The return asks for splits your chart of accounts does not have, so the numbers get rebuilt by hand from transaction detail. That is not a filing problem. It is a chart of accounts problem, and it is fixable once. If you need the general principles of building a chart of accounts first, start with our guide to setting up a chart of accounts in Canada.

Why does your chart of accounts decide how hard your T3010 is?

Because the return does not ask for "donations." It asks for five different kinds of donation, separately. A chart of accounts with one revenue account called Donations cannot produce that, so somebody produces it manually instead.

The reconstruction is not just slow. It is unreliable, because it depends on somebody's judgment about transactions recorded months earlier by someone else. That is how the same charity reports the same kind of revenue on different lines in consecutive years, which is exactly the inconsistency that draws a second look.

The fix is to build the splits into the accounts so the numbers fall out. Do it once and every subsequent year is an extraction.

Which part of the return do you actually complete?

Check this before you build anything, because the revenue detail required depends on it. Charities complete either the shorter Section D or the more detailed Schedule 6, and the line numbers differ.

You must complete Schedule 6 instead of Section D if any of the following applies: your gross revenue for the fiscal period exceeds $100,000; the value of property you own and did not use in charitable activities or administration exceeds $25,000; or the charity had a still-valid CRA permission to accumulate property during the fiscal period. Otherwise Section D applies.

That last condition is now a legacy one. CRA stopped reviewing and granting accumulation requests as of January 1, 2023, when the accumulation of property provision was repealed. Approvals granted before then remain valid until the approved period expires, and CRA will not extend them. If your charity has never held one, it does not apply to you. Confirm the current conditions against the guide for the version of the return in force for your fiscal period.

The practical consequence is that a small charity on Section D reports Canadian government revenue as one figure, while a charity on Schedule 6 breaks it out by level of government. Build for the one you complete, and build for Schedule 6 if you expect to cross the threshold.

How does the T3010 split revenue?

Into categories defined by who gave the money and whether you receipted it, not by what the money was for. That distinction is why fundraising-oriented account structures do not map.

One caution before the table. Line numbering has changed between versions of the return, and the version you file depends on your fiscal period end. Use the table below to understand the shape of the splits, then confirm each line against the CRA guide for the version in force for your period.

What the return asks for Line The account you need
Total eligible amount of gifts for which official receipts have been or will be issued 4500 Receipted donation revenue, excluding gifts from other registered charities
Total funds and property received from other registered charities 4510 A separate account for charity-to-charity transfers
Total other gifts for which no official receipt was issued, excluding fundraising, Canadian government and foreign revenue 4530 Non-receipted gift revenue
Total revenue from all levels of government in Canada, on Section D 4570 A government funding account
Federal, then provincial or territorial, then municipal or regional, on Schedule 6 4540, 4550, 4560 Government funding split by level
Tax-receipted revenue from sources outside Canada 4571 Foreign revenue, receipted
Non tax-receipted revenue from sources outside Canada 4575 Foreign revenue, non-receipted
Revenue from fundraising for which no receipt was issued 4630 Fundraising revenue, kept separate from non-receipted gifts

The government split is the one most charities miss. A single "Grant Revenue" account cannot tell you which level of government a grant came from, and Schedule 6 wants three separate figures.

Which revenue split causes the most errors?

Receipted against non-receipted, on lines 4500 and 4530. This is the error to design out first.

Line 4500 is the total eligible amount of gifts for which you have issued or will issue an official donation receipt. Line 4530 covers other non-receipted gifts, excluding fundraising, Canadian government and foreign revenue, which each have their own lines.

The classic failure is uncounted cash. A collection box or a bucket at an event produces money that is a gift, but nobody knows who gave it, so no receipt can be issued. Charities routinely put it on line 4500, which reports receipted revenue against duplicate receipts that do not exist. Since you must keep duplicates of every official receipt, that gap is visible to anyone who looks.

Where it actually goes is the part most guidance gets wrong. Line 4530 excludes fundraising revenue, which is reported on line 4630, and also excludes Canadian government revenue and foreign revenue, which each have their own lines. In its current guidance CRA points to collection box money as an example of what belongs at line 4630. So non-receipted cash raised through fundraising activity goes to 4630, while other non-receipted gifts, such as an unreceipted bequest, go to 4530. Build both accounts, keep them apart at the point of coding, and check the current guide, because this wording has changed between versions of the return.

A second error worth designing out: gifts from other registered charities go on line 4510, and you should not issue an official donation receipt for them. A transfer from a foundation is not an ordinary donation. If your chart of accounts pushes it into general donation revenue, you get both a reporting error and a receipting error from a single coding decision.

There is a public dimension to getting the splits right. Your filed return is published, and anyone can compute your fundraising ratio from it. How revenue is split between accounts changes that ratio. Our guide to the T3010 covers the return itself.

How do you handle the second dimension: funds?

Do not build restrictions into your account numbers. Use the tracking dimension your software already has.

This is where charity charts of accounts most often go wrong structurally. Faced with three restricted grants, the instinct is to duplicate the expense accounts: Program Salaries, Program Salaries (Grant A), Program Salaries (Grant B). Three grants become a hundred and fifty accounts, and the next grant breaks it again.

The account should answer what the money was spent on. A separate dimension should answer whose money it was. QuickBooks Online calls it classes, Xero calls them tracking categories, and dedicated fund accounting software handles funds natively. Our guide to fund accounting for charities covers how the segregation works.

Two dimensions, applied to every transaction, produce both reports: a functional statement for the return and a fund schedule for each funder. One dimension produces neither without manual work.

What about the expenditure side?

Your expense accounts should map to the T3010's functional split, and there are more than three categories. The main three are charitable programs, management and administration, and fundraising. The return also carries separate lines for other activities, for grants to non-qualified donees, and for gifts to qualified donees. Building only three buckets forces the remaining amounts into whichever of the three seems closest, which is how charities end up with program costs that include a grant.

The three-category alignment is covered in our existing guide to setting up a chart of accounts in Canada, which sets out the principle. Two points to add for a charity specifically. Costs that span functions need a documented allocation basis applied consistently, not a judgment made annually. And both gifts to qualified donees and grants to non-qualified donees are reported on their own lines, so each needs its own account rather than sitting inside program costs.

What should you not build accounts for?

Do not mirror every line of the return, and do not restructure the chart every year.

A common overcorrection is creating an account for every single line on the T3010, including ones your charity will never use. That produces a chart nobody can navigate and a coding decision nobody gets right. Build accounts for the splits you actually have.

Stability matters more than granularity. A chart of accounts that gets rebuilt annually makes year-over-year comparison impossible for your board and for anyone reading your filings. Leave gaps in the numbering, add accounts as new revenue types appear, and retire accounts only at year-end.

If you want your chart of accounts rebuilt so the return falls out of it, our charity bookkeeping service page sets out how that works during onboarding. Our general guide to the chart of accounts covers the underlying structure.

Frequently Asked Questions

What is the difference between line 4500 and line 4530 on the T3010?

Line 4500 is the total eligible amount of gifts for which you have issued or will issue an official donation receipt. Line 4530 is other non-receipted gifts, but it excludes fundraising revenue, Canadian government revenue and foreign revenue, which each have their own lines. Money from collection boxes and similar fundraising sources is directed to line 4630 rather than 4530, so check the guide for the version of the return you are filing.

Do we issue a receipt for a gift from another registered charity?

No. Amounts received from other registered charities are reported separately on the return and official donation receipts should not be issued for them. Set up a distinct revenue account so the coding decision is made once rather than case by case.

Should each grant have its own set of expense accounts?

No. Use your software's class or tracking category feature to record which fund bore a cost, and keep the account itself describing what the cost was. Duplicating accounts per grant produces an unmanageable chart within a couple of funding cycles.

Do we complete Section D or Schedule 6?

Schedule 6 applies if your gross revenue exceeds $100,000, if property you own and did not use in charitable activities or administration exceeds $25,000, or if the charity had a still-valid CRA permission to accumulate property during the fiscal period. CRA stopped granting new accumulation approvals as of January 1, 2023, so that last condition only affects charities holding an approval from before then. Otherwise you use Section D. It matters for your chart of accounts because Schedule 6 requires government revenue split by level while Section D asks for a single total.

How many accounts should a small charity have?

Enough to answer the return and your funder reports, and no more. For most small charities that is a few dozen, not a few hundred. Every additional account is another coding decision someone can get wrong.

Can we change our chart of accounts mid-year?

You can, but adding accounts is much safer than restructuring. Additions preserve comparability; renumbering does not. If a rebuild is needed, do it at the start of a fiscal year and keep a mapping document showing where the old accounts went.

This article provides general information about bookkeeping practice and Canadian charity compliance. It is not accounting, tax or legal advice. Confirm T3010 line numbers against the version of the return in force for your fiscal period, and speak with a qualified adviser about your organization's circumstances.