|
Welcome to BRC! We specialize in MS Excel-based productivity tools, both ready-to-use & custom-built solutions. We also offer consulting services, including tool customization. Our
tools can help you import or convert data to and from accounting packages
such as QuickBooks, Quicken. & MS Money, from external sources into
Excel, and to help you use Excel in new ways such as a bulk email program. New! Package
Deals Here’s a list of our tools,
including a short description for each tool. Click the tool’s name to go to
its home page for more information and to download a free trial: |
||
|
Tools & Services |
||
|
Quick Links
|
|
|
|
Click the tool name below for details or find a tool by task |
||
|
Tools for Quicken & MS Money |
||
|
Tool Name |
Key capabilities |
|
|
·
Convert text files & spreadsheets into
QIF files for import into Quicken, MS Money, and other QIF-enabled
applications. |
||
|
· Convert QIF files into OFX files for import into Quicken & MS Money. ·
Write OFX files based on Excel
spreadsheets for import into Quicken or MS Money. |
||
|
·
Fix QIF files to make them importable into
recent versions of Quicken. |
||
|
Tools for Excel |
||
|
·
Import OFX files into Excel as
worksheets. ·
Support for OFX, QFX, and QBO files for bank,
credit card, and investment account statements. |
||
|
· Email form Excel to worksheet-based address lists. · Each email address receives an individually-addressed email. · Mail merge using data on your worksheet. ·
Both HTML & plain text email for an
optimal experience. |
||
|
Tools for QuickBooks |
||
|
Tool Name |
Key capabilities |
|
|
· Import transactions into QuickBooks from worksheets & text files. · Import downloaded bank & credit card transaction detail into QuickBooks. · Accountants: Use this tool to create periodic adjusting entries from templates & import them into QuickBooks.
|
||
|
· Create statements to send to your donors without data re-entry. ·
Statements are designed to fit directly
into #10 envelopes with no mailing labels required. |
||
|
New! BRC Batch Invoicer |
· Create batch invoices for dues, membership fees, or other similar tasks. · Better than QuickBooks memorized transactions! |
|
|
· Copy data from one QuickBooks company to another. · This tool copies transactions (like invoices & checks) & list records (like customers, vendors, & accounts) between QuickBooks company files. · Accountants: Enter adjusting entries or other transactions in your clients’ files and return them to your clients via email.
|
||
|
· Convert QIF files into OFX/QBO files for import into QuickBooks for reconciliation. · Also, convert text files & Excel spreadsheets into OFX/QBO files.
|
||
|
· Import lists into QuickBooks. This tool is optimized for importing list details. It supports the chart of accounts, employee, customer, vendor, & item lists as well as other minor lists. · You can also import opening balances for lists including accounts, customers, vendors, and inventory items.
|
||
|
· Import QIF files into QuickBooks by converting them into QuickBooks IIF files. · View & edit your QIF files in an excel spreadsheet.
|
||
|
· Batch-create timesheets for your employees. · Record timesheets in Excel & import them into QuickBooks. · Includes customizable timesheet templates. · When integrated with the XL Email Manager, batch email weekly timesheets to your employees. · Also, import time data in row/column table format from an excel spreadsheet.
|
||
|
· Import PayPal transactions into QuickBooks as Invoices, Sales Receipts, or payments. Includes support for shopping cart details without additional data entry. · Import eBay auctions into QuickBooks.
|
||
|
· Pull detailed data from QuickBooks to Excel; read data for custom reporting & analysis. · Retrieves your financial data for a time period you specify. · Powerful, yet easy to use. Simple one-click data retrieval from QuickBooks. · Use formulas & pivot reports in Excel to analyze your data. · Create an ODBC data source for additional reporting options. |
||
|
·
Automatically manage and modify reports
sent from QuickBooks to Excel. · Quickly merge reports, modify reports, change formatting, and take other actions that apply globally to the report. · Merge or delete rows of data. Many other options… |
||
|
Services |
||
|
· I need a custom Excel Add-In or other technical solution.
|
||
MS Excel ™ and MS Money ™ are registered trademarks of Microsoft,
Inc. QuickBooks ™ and Quicken ™ are registered trademarks of Intuit, Inc.