Create letter-like professional A/R statements – with many options for sales details
Create professional statements directly from your QuickBooks data. No need to reenter any data.
How it works
This Excel add-in pulls QuickBooks A/R transactions and then creates customizable statements in a letter-like format ready to print. You can create one or many statements at a time with no data entry.
The A/R Statements Pro add-in includes options to customize the statements to suit your needs: You can specify opening and closing paragraphs of text, include various ‘mail-merge’ fields, and customize the statements in many other ways.
For example, you can customize the table of account activity to include both standard data fields like date, transaction type, item, description, and class as well as many other fields. You can include many fields not available when using QuickBooks statements, including various customer, item, and transaction fields. Also, custom fields are supported, both from customer & item records and directly from transactions.
Invoices, Payments, Credit Memos, and other A/R transactions are always included, as well as any other transactions that impact A/R such as Checks & General Journals. You can also optionally include Sales Receipts.
Statements can be printed and mailed using #10 windowed envelopes – so there is no need to create address labels. This can reduce labor & will eliminate labeling mistakes. A visual alignment feature makes it easier to create statements that align to your windowed envelopes. You can also print statements in duplex mode to save paper!
There is no special set-up needed in QuickBooks. Just enter your A/R data as normal and all should work.
Batch emailing statements is also an option. The app will attach your statements in several formats as desired. The email feature requires purchase of the BRC XL Email Manager.
Download this add-in for a free trial, which allows you to try before you buy. During the trial the product is limited to creating 15 statements per run. After you purchase there is no limit.
1.58: Refinements for the repeat table titles feature to handle the duplex printing feature option of not repeating the return address section at the top of each statement page.
1.57: Add optional statement title, improve logo auto-fit feature when the logo is positioned in the upper left and the company address is also printed. Add option to omit the Balance Forward line if it is 0.00.
1.56: Add Terms field to returned transactions.
1.55: Updated connection dialog options. Add ability to set the default path for temp files.
1.54: Added error details/reasons to connection error messages.
1.53: Add option to repeat table titles on each page of a multi-page statement when the details table spans pages.
1.52: Add options to exclude customer payments when the open balance is 0.00 and also to exclude sales where the open balance is 0.00. This enables sending statements that include only the remaining open/unpaid transactions that contribute to each customer’s open balance.
1.51: Fix query so that only the desired post-statement transactions are returned from QuickBooks.
1.49: Big update: New option to create balance forward statements even if customers have no current data. Now when using the option to pull older unpaid transactions a statement is created even if customers have no current transactions. When pulling older unpaid transactions, the opening balance date label uses the prior unpaid transactions date.
1.48: Add the ability to subtotal statements by Customer:Job – useful when merging all jobs into one statement. Remove warning message that appeared when the Open Balance column was not used.
1.47: Add a Running Balance column. Standardize subtotaling and generally improve the table layout in several ways.
1.46: Add as of dates to the balance forward and statement balances rows. Make the Net Activity after row appear only if there actually is activity after the statement date. Fix the customizable aging row calculations.
1.45: Changes in formatting tables so that the Description and other long text fields will appear to take up two lines in the final statements – when user forces the column width to be wider in the interview.
1.44: Fix issue where email addresses on customers were not returned from QuickBooks.
1.43: Hide no-account rows like subtotals. Add [Customer Company] auto-replace key word. Improve formatting for Opening Balance lines.
1.42: Fix sorting issue created in 1.41. Add customizable aging block feature to display 0/30/60/90 days due under details table.
1.41: Increased the per-customer detail line limit from 1,000 to 7,500. Added messaging if the limit is exceeded.
1.39: Changes to the custom / duplex print feature. Add option to print page numbers on statements.
1.37: Added Price field and smart formatting for it. Updated table field alignment. Fix display of Qty values.
1.36: Added transaction address fields as optional fields. Updated documentation.
1.35: Regroup and clarify the sales transaction detail detail level settings: Full Detail lines, merged detail lines, or summary lines only.
1.34: New auto-replace keyword fields for our your statement text, updated documentation, and new option to include unpaid activity prior to the statement dates.
1.33: Initial release