Skip to main content

QuickBooks Reports of Designated Fund Activity

Question:

The following question rolls out of content provided in a previous post: "Debits and Credits for Designated Gifts."

How do I generate a report in QuickBooks that shows the monthly starting balance, change for the month, and the ending balance for each Equity account relating to Designated Gifts?

Answer:

Our answer here will be consistent with the above cited blog post. In it we discussed simplest approach to handling Designated Funds that we can suggest. 

We will illustrate assuming the use of QuickBooks Desktop. Some of these instructions may be slightly modified for users of QuickBooks Online.

The following are the necessary steps:

1. Select the "Reports" pull-down menu
2. Under "Accountant & Taxes" choose "Trial Balance"
3. Modify the date range to reflect the desired period
4. Double-click on the amount for the Equity account of interest

This will generate a "Transactions by Account" report.

Comments

Popular posts from this blog

Debits and Credits for Designated Gifts

Question:A church is setting up QuickBooks for its accounting, but its personnel have little experience with fund accounting. What are the entries for the receipt and disbursement of designated gifts and the opening balances?Answer:We recommend that most churches that do not need to present financial statements in accordance with Generally Accepted Accounting Principles (GAAP) observe the following steps. Even those churches that do report using GAAP can employ these methods but must make some adjustments when preparing their financial statements.What we will demonstrate relates to what most churches call "designated gifts" (CPAs call these Temporarily Restricted gifts). These are gifts that donors contribute with the intention that the church will spend the funds as they direct. Most churches do not receive "endowment gifts" in which donors prohibit the expenditure of the core gift (CPAs call these Permanently Restricted gifts). Only earnings on the subsequent inv…

Housing Allowance and Form 1099-MISC Reporting

Question:A church provides its minister a housing allowance but believes it must report the full amount of compensation (including the non-taxable housing allowance portion) on Form 1099-MISC in order to demonstrate the full earnings of the minister. (Starting in 2020, Form 1099-MISC is replaced with Form 1099-NEC for non-employee compensation.)If the church reports his compensation, including the housing allowance, on the Form 1099-NEC as taxable income, will he be able to deduct his housing expenses somewhere else on the Form 1040?Answer:This question brings up a couple of issues. First, most ministers are properly classified as employees who receive Form W-2, not as independent contractors who receive Form 1099-NEC. Box 1 on Form W-2 reports taxable compensation. It is reduced to reflect the church's designation of a portion of his pay as non-taxable housing. Then, in Box 14 (Other), Form W-2 typically reports as a memorandum item his additional non-taxable, housing allowance c…

Rental of a Church Parsonage to a Non-Minister

Question:A church owns a parsonage, but the pastor does not use it as he owns his own home. The church rents the parsonage to a tenant other than a minister or employee of the church. Will the church be responsible for paying income tax on these monies as Unrelated Business Income (filing a Form 990-T) even if the money is used to carry on the business of the church? Answer:Whether the money is used for church purposes is irrelevant. IRS Publication 598 states:"If an exempt organization regularly carries on a trade or business not substantially related to its exempt purpose, except that it provides funds to carry out that purpose, the organization is subject to tax on its income from that unrelated trade or business."Fortunately, in the case of rental income from real property, such income is "excluded in computing unrelated business taxable income" (Publication 598). Caution: see content below regarding debt-financed property. However, a second concern not addresse…