Funds for QuickBooks Desktop

As a general rule, if you do not export items out of eTapestry, then you create a fund for each income account that could be associated with transactions tracked in eTapestry. If you export items and but do note use eTapestry Cart, create a fund for each item. If you track items in the eTapestry Cart, you must associate the item with a fund that has the correct income account associated with that item in QuickBooks desktop.

Donations made to a fund are credited to specific General Ledger (GL) accounts in QuickBooks desktop. Enter the appropriate GL account codes for each of the funds that you have in eTapestry. The GL account codes must be spelled identically in eTapestry and QuickBooks desktop. For information about what GL numbers to include, consult your accountant.

Before you export from etapestry, ensure that your eTapestry database is set up with correct funds. Different types of donations require different types of accounts on the fund. Your funds in eTapestrymust match the QuickBooks® income accounts that you want to import.

• The fund name must be identical to the income account name from your chart of accounts.

• The cash account for each fund, must be the same as your bank account GL account number for your deposited funds account.

• If you track invoices and payments in QuickBooks® desktop, the receivable account must be the same as the accounts receivable account GL account number in QuickBooks® in order to export pledges and payments.

• The revenue account must be the same as the income account GL account number in QuickBooks® desktop.

• If you use QuickBooks Undeposited Funds, then all of your eTapestry funds need Undeposited Funds account number in the Cash Account field.

When required account fields are missing, donations made to that fund may not appear in the export. You can also include the Fund Description field in the export.

For more information about funds, refer to Funds.

Required Account Fields
Type	Credit	Debit	Note
Gift	Revenue	Cash	Most organizations export Gift information.
Pledge	Revenue	Receivable	Many organizations do not export pledge information.
Payment	Receivable	Cash	If you plan to export payments but not pledges, you can enter the same account number for receivable as for revenue. In this way, the import treats gifts and payments for the same fund in the same way.