This add-in uses your QuickBooks Online donation transactions to create customizable donor statements in a letter-like format that are ready to print and mail. You can create one or many statements in a batch.
The Donor Statements – QB Online Excel add-in includes options to customize your statements to suit your non-profit: You can specify opening and closing text paragraphs, include various ‘mail-merge’ fields, and include the details of each donor’s giving history. Options let you choose between two donation table types and choose the data columns you want to show – such as date, item, description, class, and amount.
It includes support for donation transactions entered as Invoices/Pledges & Payments for them, Sales Receipts, and even Deposit line items. You can mix and match between these transaction types, all of which can be included in your statements.
When printing statements, if you use #10 windowed envelopes, then there is no need to create address labels. This will reduce labor and eliminate labeling mistakes. A visual alignment feature makes it easier to create statements that align to your windowed envelopes.
There is no special set-up needed in QuickBooks. If you’ve entered your donations using your donor’s names, they’ll probably work with this app.
You can also email your donor statements! The email feature requires purchase of our Excel Email Manager.
Download this add-in for a free trial, which allows you to try before you buy. During the trial the tool is limited to creating 15 statements per run. After you purchase there is no limit to the number of statements you can create.
3.88: Now allow for multiple email recipient addresses when sending email using the BRC Batch-Email Manager. Build 2.51 of the Batch-Email Manager is now required. Make sure the date changes in build 3.87 don’t cause the dates to print as ###### when scaling impacts the column.
3.87: Improvements to auto-fitting the statements for printing.
3.86: Add error-checking to fields used when emailing statements. Also, for emailing, add a warning if there are no file types selected for statement attachments (but you can still continue if you don’t want to send attachments.)
3.85: Update interface for emailing statements when used with the BRC Excel Batch-Email Manager. Update fields on the Email tab of the Create Statements window to match.
3.84: New option to create statements for donors that have unpaid balances (pledges) but no donations for the period.
3.83: Add support for QB Online reports exported to old-style XLS files (in addition to XLSX files) because under some circumstances QB Online writes files in the older format.
3.82: Remove references to donation tables from the mail merge feature, because they’re not included in the QBO version.
3.81: Fix a runtime error introduced in 3.79 (Oops!)
3.79: Fix an issue where the customer balance amount wasn’t captured from the (optional) customer balance report and so wouldn’t appear on statements.
3.78: Now include Refund Receipt transactions on statements if they are included on the transaction report.
3.77: New filter to exclude customers who are not on the Customer Contact List. Automatically clean up customer names, removing leading and trailing spaces. Better formatting for the salutation when using first and last name fields and one or the other is blank. Change customer “Sub-Type” labels to “Type” to match the QuickBooks interface. Update documentation to match.
3.76: Updates to how Credit Memos are matched with the invoices they pay off.
3.75: Refinements to code that matches invoices/donations to payments.
3.74: Fix issue where special calculated columns on the Data worksheet weren’t saved.
3.73: Fixed a compile error caused by changes in 3.72.
3.72: More updates to logic that associates payments to invoices. Un-applied Payments are now reported in addition to applied payments that are linked to invoices that use selected donation accounts.
3.71: Improve logic that finds invoice/pledge to payment associations, especially in the cases of prepayments and multiple payment from a donor with identical amounts. Improve code that launches the documentation from the Ribbon.
3.69: Improve error checking when processing QuickBooks reports. Now check for all required columns, allowing for non-profit SKU and QuickBooks Canada. Update instructions for creating reports for clarity. Improve logic for the [Salutation] auto-replace field and update the documentation to match. When importing QuickBooks reports, always create a new workbook even if the current workbook is a statement workbook. Format dates in the details table, footer, and message fields using the specified statement date format. Improve help text on the notice displayed when no matching donors are found.
3.68: Add new feature to merge donation details across donations based on the columns selected to display on the detailed donation table. Fix warning saying the folder selected to save statements for emailing was not a folder. Improvements to code when subtotaling donation details on payment number, payment method, and account.
3.67: Add support for QB Online Canada, which has similar data but different report titles for address fields.
3.66: Add <usefirst> feature to the custom text fields used on statements, which selects the first of multiple auto-replace key words that has a value and discards the rest. Rewrite the documentation for clarity and to cover newer features.
3.65: Address case where welcome window appears on every launch on some computers. Improve logo placement when center or right aligned. Fix an issue where, if emailing statements, the wrong email text was sometime sent (though the right donor statement was attached.)
3.64: Better messaging around product key entry and deletion.
3.63: Add option to filter based on whether or not the donor has Invoices/Pledges in the data from QuickBooks.
3.62: Make sure ZIP codes with leading zeros are formatted properly.
3.61: Changes to About & Purchase dialog and key validation.
3.59: Change to ensure if the company name is the same as either the FML name or the transaction name, it will not be added to the statement address. Hide the utility comments added to the statements for the custom printing features.
3.58: Handle duplicate fields for Payment Method when found on both transaction and donor list reports. Add progress messages to the Excel status bar as files are being imported and processed. Double check and save file names selected for the QB Online reports. When processing transaction details, only include transactions that have a customer/donor name, since they are the only ones that can be used on donor statements. Performances improvements when importing large data from QB Online.
3.56: Update code that auto-adds table titles on each new page when tables split across pages to prevent an extra nearly-blank page from being created.
3.55: Update code that finds payment/invoice relationships. Include Credit Memos if they’re included on the transaction detail report.
3.54: Add company name to address when the first line of the address is the donor first last name.
3.53: Changes to eliminate a potential Excel message at shutdown asking to save the the app file.
3.52: Add enhances formatting for tables and option to repeat table titles on each new statement page, where a donor’s statement uses more than one page.
3.51: Now use up to three Transaction Detail reports as your data source for statements to handle larger company files where QB Online can’t included all donation data for the donation period on one report.
3.49: Set and correctly display good through date in About dialog for certain upgrade paths.
3.45: Refine table formatting when using larger fonts. Handle multi-line donor street addresses.
3.44: Add option to include page numbers when emailing statements & when printing one statement per worksheet. Minor updates to the About & Purchase dialog.
3.42: Clean up report selection dialog messaging, tab order, and some logic. Display full file name in tool-tip for each field.
3.41: For the mail merge feature, add second street value back to address field, add a column for it, and remove carriage returns from fields for the merge tables for better formatting.
3.39: Add conditional text feature to text message fields which was previously added to the Desktop version of this app.
3.38: Clarify the use of the [Total Open Balance] field used in conjunction with the optional Customer Balance report.
3.37: Now properly find account types when account numbers are enabled. Now find payment numbers for payments against invoices and pledges. Now optionally include Journals on statements.
3.36: Fix issue with footer height. Make Qty and Rate fields optional. Improve missing column warning message to state exactly which columns are missing from a QBO report.
3.34: Big change to support donor/customer balances. Now you can include the keyword [Customer Account Balance] in statement text to remind donors of their outstanding balance.
3.33: Changes to About & Purchase dialog to handle more than one product key. Fix for Excel 2016 to resolve issue where app would not load properly.
3.31: Fixed several issues: a) Footer margin was sometimes set to less than 0″ and so would not print. b) Accounts were not recognized when account numbering enabled. c) Account types not listed properly. d) Transaction types were not recognized in some cases.
3.12: Fixed logic error to that caused no data to appear when columns in source data report were in an unexpected order.