Skip to main content
brunner01
Jul 5, 2021 3:58 PM UTC
Solved

How do I produce a donor statement that includes donations to equity accounts?

Original commenter did not share additional details
    BigRedConsulting
    BigRedConsultingAnswer
    Jan 7, 2022 10:38 PM UTC

    To create proper donor statements using your QuickBooks Online data, use our BRC Donor Statements - QB Online  tool. You can include data that uses most any account. It creates statements that are ready to print and mail, customized for each donor with their name, address, and other donor-specific information. You can also email your statements when the tool is used in conjunction with our BRC Excel Batch-Email Manager.

    View in thread

    5 replies

    Rose-A
    Rose-A
    Jul 5, 2021 6:53 PM UTC

    Good day, brunner01. I'd be happy to assist you today.

     

    Producing donor statement that includes donations to equity accounts is quick and easy. You can follow the steps below to complete the process.

     

    1. Click Sales in the left panel and select the Customers tab.
    2. Find the Donor's name and click Create statements under the Batch actions drop-down.
    3. Choose the Transaction Statement.

     

    This will provide you lists of items you tracked using the Equity Accounts.


     

    In case you need to customize what details to show on your statements, you can always visit this article: Create and send customer statements in QuickBooks Online.

     

    If you have additional questions or further concerns, you can always reach back out. I'm happy to lend a helping hand. Take care!

    brunner01Author
    Jul 5, 2021 10:02 PM UTC

    I just get message that no statement is available.  I notice that I should have said liability accounts, not equity accounts.  Anyway, I entered the info as journal entries.  Debit items went into collected for deposit accounts listed as other current assets.  Credits were to the several revenue sources such as regular offering, special gifts, parking lot contributions, etc. and also to long term liability accounts for special offerings such as One Great Hour of Sharing, Christmas Joy, Pentecost, etc.  Usually there were multiple credit lines for a single debit line.  Donor names were attached to the credit lines.  So the info is in there but I can't get it out.  The closest I can get is a report that shows the revenue items for each donor, but the liability account donations don't show up.  I get the feeling that I should have been using the sales feature to record these donations, but I don't see how I record the revenue or liability account under that format.

    RenjolynC
    RenjolynC
    Jul 5, 2021 11:51 PM UTC

    Thanks for your prompt reply, brunner01.

     

    To post transactions to the revenue or liability account, you'll want to set it up on the items. 

     

    Here's how:

     

    1. Go to Sales > Products and Services.
    2. Find the item and click the Edit link.
    3. Under the Income account field, select the account where you want the transaction to be posted.
    4. Select Save and close.

    Once done, use the item when recording the donation. Then, follow the steps provided by my colleague Rose-A in producing the donor statement.

     

    I'm also adding these articles that you can read as a guide:

     

    For any additional questions or other concerns, please let me know in your reply. We're always around to help you out. Take care!

    BigRedConsulting
    BigRedConsultingAnswer
    Jan 7, 2022 10:38 PM UTC

    To create proper donor statements using your QuickBooks Online data, use our BRC Donor Statements - QB Online  tool. You can include data that uses most any account. It creates statements that are ready to print and mail, customized for each donor with their name, address, and other donor-specific information. You can also email your statements when the tool is used in conjunction with our BRC Excel Batch-Email Manager.

    DonorStatements
    Apr 30, 2024 7:28 PM UTC

    You can use our web app at www.donorstatements.com to generate custom donor statements that are automatically IRS compliant, can be emailed to donor automatically, or easily printed for mailing (preformatted to fit standard #9 double window envelopes). We support many other powerful features as well. We fully support donations made via any method to any account, so your situation will be covered just fine.

     

    Our app also includes many powerful filters so you can target your statements according to many custom criteria.

     

    We ourselves are a nonprofit that struggled with this issue for years before finally deciding to build a solution ourselves.

    Terms & ConditionsAccessibility statement