QuickBooks Interface Overview

Note: if you are using an accounting system other than QuickBooks and you would like to import transactions from ExceedFurther into your system, see the Accounting Export topic.

You can post transactions from ExceedFurther to either QuickBooks Online or QuickBooks desktop products. In both cases the following transactions can be posted:

  1. Gifts - gift transactions are posted as Sales Receipts in QuickBooks. The gift Credit code maps to an Item in QuickBooks, and the gift Fund code maps to a Class. The total amount is debited to undeposited funds in QuickBooks.
  2. Dues - dues transactions are posted as Sales Receipts in QuickBooks. The dues Credit code maps to an Item in QuickBooks, and the dues Fund code maps to a Class. The total amount is debited to undeposited funds in QuickBooks.
  3. Sales - sales transactions that are paid at the time of the sale are posted as Sales Receipts in QuickBooks. The sales Credit code maps to an Item in QuickBooks, and the sales Fund code maps to a Class. The total amount is debited to undeposited funds in QuickBooks.
    1. Sales transactions that are not paid at the time they are entered into ExceedFurther are posted as Invoices in QuickBooks. When the sale is marked as paid, it is posted as a Receive Payment transaction on the corresponding invoice.
  4. Pledges - pledges are posted as Invoices in QuickBooks. The pledge Credit code maps to an Item in QuickBooks, and the pledge Fund code maps to a Class. The total amount is debited to accounts receivable in QuickBooks. You can opt to post certain pledges and leave others unposted. In either case you can post pledge payments, as described below.
  5. Pledge Payments - pledge payments on pledges that have been posted to QuickBooks are posted as Receive Payments transactions on the Invoice created when the pledge was posted.
  6. Pledge payments on pledges that have not been posted to QuickBooks are posted as Sales Receipts. The pledge payment Credit code maps to an Item in QuickBooks, and the Fund code maps to a Class. The total amount is debited to undeposited funds in QuickBooks.
  7. Guest Payments - guest payments are posted to QuickBooks as Sales Receipts. The Paid By code is mapped to a QuickBooks item and the Fund code is mapped to a QuickBooks class.  

Coming soon:

  1. Grants - only outgoing grants from the Grants module are posted to QuickBooks. Incoming grants and payments can be transferred to gifts and posted along with other gift transactions.
    1. Outgoing grants are posted as Bills in QuickBooks. The grant Payment Type code maps to an expense account in QuickBooks to be debited, and the grant payment Fund code maps to a QuickBooks class. A Grants Payable account is credited with the grant amount.
  2. Grant Payments - only outgoing grant payments are posted to QuickBooks. Grant payments create Checks in QuickBooks, and are posted as Bill Payments on the bills that corresponds to the grants being paid.