QuickBooks for Realtors

The Realtor version of the QuickBooks export allows certain charge codes to be excluded from a general QuickBooks export. This is particularly useful for those charge codes where an association is collecting the money but distributing it through the NRDS ecommerce bank IDs to NAR and the state association.

To use the Realtor version of the QuickBooks export, the Batchexportformat system option must be set to QuickbooksRealtor.

Setting this value for this system option enables excluding charge codes selected from a QuickBooks export.

To use the QuickBooks for Realtors feature:

  1. Set the BatchExportFormat system option value to QuickBooksRealtor.
  2. Hover over the Modules tab located along the top navigation bar and click Accounting to open the Accounting Overview page.
  3. Click the Setup hyperlink to open the Accounting Setup page.

  1. Expand the Charge Codes child form and locate the first charge code you wish to exclude from your GL export.
  2. Click the Edit icon next to that charge code to open the Charge Code Information pop-up window.
  3. Click the Exclude from GL Export? check box.

  1. Click the Save button. Going forward, this charge code will be excluded from all GL Exports, however it will still exist in the netFORUM Pro ledger history on the batch profile.
  2. To view the ledger history, open a batch profile and expand the General Ledger Details child form which is nested under the GL Details tab.

Those charge codes that have been excluded from the GL Export will have Excluded listed in the far-right column on the General Ledger Details child form.

To include those charge codes in the GL Export that have previously been excluded, simply edit that charge code (following the steps listed above) and deselect the Exclude from GL Export? check box.  This will include that charge code in the next GL Export as well as remove the Excluded tag from its line item on the General Ledger Details child form.

Quickbooks for Realtors works for both manual and automatic batches, however the batch must be processed first.