Mapping QB Items to MMS G/L Accounts

September 28, 2016

  1. Member Dues
  2. Event Registrations

  1. Member Dues
    • New Member Dues
    • Renewals
    • Credits
  2. Event Registrations
    • You can create a separate item for each Event that you hold.
  3. Online Store.

Mapping QuickBooks Items (Products/Services) to MMS G/L Accounts

  1. Go into the "Membership Billing" menu.
  2. Under the "Data Export" subheading, click the "Edit General Ledger Accounts" link.
  3. If you do not see the GL account you need in the list on this page, click the "Add New GL Account" link at the bottom of this page.
  4. Select the QB Item that you want to send transactions to from the "QB Item" drop-down.  Type in a name for that item in the "Description" field.
    • We recommend typing in the name of the QB Item for the Description, so that it appears the same in both systems.  You can give it a different description, however.
    • The "Account Number" field is optional.  If you do use it, you must enter a number.
  5. Click the "Submit" button.

Mapping MMS Transactions to MMS G/L Accounts

  1. Near the top, you will see a link to "Select GL Accounts for Membership Invoices".  Click this.
  2. In the dropdown menu for "Gen Ledger Account - New Members Invoices:", select the G/L account that you set up for new members' dues.  (This might be a general dues G/L account, depending on your accounting preferences.)
  3. In the dropdown menu for "Gen Ledger Account - Renewal Invoices:", select the G/L account that you set up for renewal dues.  (Again, this might be a general dues G/L account, depending on your accounting preferences.)
  4. If you have set up a separate G/L Account for credits, select this on the dropdown for "Gen Ledger Account - Credits".  (This is optional.)

  1. From the Main Menu, under Event Management, click the "Event Registration" link.
  2. Click the "change" link next to the event whose transactions you want to map to QuickBooks.
  3. About one third of the way from the bottom of this page, you will see a dropdown for General Ledger Account.  Select the G/L account that you created to send transactions for this event to.
  4. Click the "Continue >>" button at the bottom of the page.