Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Thanks for joining the Community, IS43.
Currently, there isn't a process for combining donor and customer details on a statement in QuickBooks Desktop. I can certainly understand how such an option could be useful to yourself/others and have submitted a feature request about it as of today. This ensures that it will be considered in future updates.
As a workaround, you can generate your donor statements separately.
Here's how:
Now that your donor statement's generated, you can create one for customers.
I've included a couple helpful resources about using QuickBooks and submitting product suggestions that may come in handy moving forward:
Please feel more than welcome to send a reply if there's any additional questions. Have a lovely day!
I am sorry, but it seems like you do not even read all the postings before and then just repeat a tired response that does not work. Very frustrating.
Good luck. This has been a problem with QBO for YEARS and they obviously have no intention of solving it. Customer service on this issue is a total waste of time, they give you answers you're not seeking. I believe none of them understand non-profit organizations' needs and don't care to find out and bring solutions to the table. Their "suggestion box" is another waste of time, just designed to make you feel good, but they have no intention of listening.
I had this problem last year when integrating over to QBO from to desktop version. The problem was with HOW "Sales Receipts" were being entered. I am using the nonprofit version, so I go to +New > then under Customers, click Sales Receipt.
The way the previous treasurer was entering donor contributions, I believe, was from the deposit page. While you ARE able to enter the same information and generate reports with the same information, I found that it was omitted from the donor statements when I used the Quickbooks Advisor way (stated many times above).
Unfortunately, I had to manually merge that year. I am doing it for the second time this year and the QB Advisor method now works for me. The only downside is that It doesn't breakdown receipt line items or specific funds, as someone said earlier.
We have over 50, but less than 100 members, so purchasing BRC's plan for more than 10 donor receipts is not worth it for me. If you want to invest in those types of software for years to come, make sure it offers QBO integration and great support. I have yet to fund an inexpensive one or one that will truly do everything I need it to for it to be a value. [If anyone has any ideas, please let me know.]
Some other suggestions, use Microsoft Word to enter bulk information through the Mailer tab. (Google it). Personally, I export a custom report (Sales by Donor Detail) to Excel. I break the master list down by giving each donor their own tab. I have not figured out how to make a standard few lines then customize the rest of the donor statement, but I know this can be done (requires more research/plug in/other software - again, if YOU know, please let ME know!). I do a whole document search and Replace "abcdefg" in the whole document to "abc" to make it esthetically pleasing and more simplified.
If anyone has a better idea for just 30-40 members, please let me know. Thanks! Hope this helps. =)
Thanks for sharing helpful tips to handle donations in QuickBooks Online, TricinaM.
As of now, you'll have to manually enter these details in your sales receipt by exporting them to Excel. Aside from that, you can also integrate a third-party app that'll let you upload your prepared transactions to QuickBooks Online.
Here's how:
Additionally, I've added this article that'll help you personalize and add specific information to your sales forms: Customize Invoices, Estimates, and Sales Receipts in QuickBooks Online.
Feel free to drop a message to this thread if you have more questions. I'll reply as soon as I can.
I tried this and the statement has nothing on it It looks like a balance forward statement
I want a report / statement that shows all activity from the donor.
Not open balances, All donations from the donor.
Using create statements only gives you open balances
How do you get a report with all transactions listed?
You may need an additional app to have many following custom reports
Batch Deposit Report – See batch deposits from your payment processor in a specific date range.
Offline Transaction Report – Get a list of all offline transactions (check, cash, etc.) from a specific date range.
Transactions On and Offline Report – Get a list of all transactions that have been synced or entered into Donation within a specific date range.
SYBUNT Report – See donors who have given in one or more previous years but haven’t yet given this year.
Giving List Report – View all activities taking place between two dates.
LYBUNT Report – See donors who gave the previous year but haven’t yet given this year.
Lapsed Donor Report – See which donors have lapsed in their giving over a period of time.
Fiscal Development Report – Get a quick development report for the fiscal year.
Development Report – Get a quick development report for the calendar year.
Soft Credit Report – Get a list of all soft credit gifts for a specific date range.
Mailing Status Report – Get a report of email sends and opens with a party mailing list app for a specific date range.
Cause Team Report – Create a giving report based on your peer-to-peer Cause, sorting by team and team members.
Year-Over-Year Report – Run a giving report by fiscal year for one or all campaigns.
Hello Anonymous,
I have reviewed the solution you’ve shared and it's correct and accurate. Thank you for sharing your inputs to help address the issue.
We love to see members supporting one another! Have a great day.
so I am new to this thread but not new to Quickbooks
I use QB for MAC desktop but I dont know why this wouldnt work for any version:
all you have to do, and what I have been using for years... is to create a sales receipt template. on my version there is something called "layout designer" so the drop down box on the sales receipt window says template..
hit that and select edit current or create new template.
then you can customize it however you want
I added statements about non profit and tax deduction etc
also added a nice thank you statement ... you can then print it out and mail or even email it to your customer (donor) ...only thing is you have to print one out each time they donate. dont know how to make one for year end though.... good luck
I am having the same problem!
Hello there, @ljenkinswaterville.
Let's create a transaction statement (for QuickBooks Online) or donor statement (for QuickBooks Desktop), so you can provide a record of donation amounts to your clients and manage your transactions accordingly.
If you're using QBO, send transaction statements. They are used for nonprofit organizations and businesses that need to send activity reports to their donors but don't need a running balance or amount due. To do this, here's how:
You can refer to this article for the complete guide, and in case you also need to create multiple transaction statements in QBO: How to create single or multiple transaction statements for donors.
Moreover, you can also opt to utilize a third-party application that uses your QBO data, like the BRC Donor Statements - QB Online mentioned above, to provide donation statements to your clients.
If you're using QBDT, you can generate your donor statements separately, as recommended by my colleague @ZackE above. You can also refer to this article for more details about this: Create statements in QuickBooks Desktop.
Also, you may want to check out any of these articles (based on your product) as your reference to guide you in tracking fund donations you receive in QuickBooks:
Please feel free to leave a comment below if you have other concerns about managing donations and income transactions in QuickBooks. I'm always ready to help. Take care, @ljenkinswaterville.
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 out (preformatted to fit standard #9 double window envelopes). We support many other powerful features as well.
We ourselves are a nonprofit that struggled with this issue for years before finally deciding to build a solution ourselves.
This does NOT work.
Donations are recorded as Sales Receipts - "customer" (church member) by customer.
Then we can make a deposit from these Sales Receipts.
Sales Receipts do NOT show up on statements.
We need to provide church members quarterly and annual statements showing their donations.
We need to print for all members - and this should be a standard report / or statement.
Filtering or doing member by member would be cumbersome. Ridiculous.
Appears that QB Moderator doesn't know what they're talking about and/or are not "listening" to this concern
Your sales receipts are integrated into your customer statement for ease of tracking, TTR_Biz. Let me walk you through how these transactions are processed, so you can seamlessly continue with your business activities.
On the other hand, the sales receipts for each church member will vary based on the type of statement you choose. To ensure you select the correct statement type, please follow the procedure outlined below:
1. Go to + New then select Statement.
2. Under the Statement Type dropdown, choose Transaction Statement.
3. On the Recipient List section, check the box of the Sales receipt created.
4. Then, you can select print or preview to check the Sales Receipt you've made.
5. Click Save and close.
Additionally, visit this article to guide you on the outstanding balances that soon will be overdue: Create and send customer statements in QuickBooks Online.
Moreover, refer to this article on how to record donations depending on their type: How to record donations or charitable contributions in QuickBooks Online.
Please let me know if you have any other concerns about your customer's statement in QuickBooks Online. I'd be pleased to assist you further.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here