This header section tells QuickBooks what information is being provided in which column of the import file. What makes its format special is the header records and the record code values that are specified by QuickBooks. The IIF file is really a tab‐delimited text file. The format of the file created by the QuickBooks Desktop Standard Export is called the Intuit Interchange Format (IIF) and is the only format that QuickBooks can recognize to import transaction information. Transferring donation information from eTapestry to QuickBooks is a two step process: Quickbooks Export File FormatĪfter GL accounts on your funds and transactions are ready to export, you can run the QuickBooks desktop export. For more information on how to create these user defined fields, see Add a user defined field and User-Defined Fields for QuickBooks Desktop. Your organ ization will have to set up these user defined fields as they are not part of the standard list of fields. Using the Class scheme example above, to direct a transaction to the Beijing subclass under the China subclass under Asia Relief, the value for Class would be set to “Asia Relief”, Subclass 1 would be set to “China” and Subclass 2 would be set to “Beijing”. These user defined fields are called Class, Subclass 1 and Subclass 2. eTapestry uses three user defined fields to store Class information on atransaction. If you elect to use Class Tracking in QuickBooks, you will also want to capture Class information in eTapestry. QuickBooks allows users to organize your classes by creating subclasses within classes. You can compare the success of the two programs by running the same standard accounting reports for each class. Your organ ization might also want to categorize your contributions based on the programs that you support. For example, if you use the standard Non‐Profit Chart of Accounts, it has accounts that separate Corporate Contributions from Individual Contributions. QuickBooks provides the option of using Class Tracking to classify transactions within or across GL accounts. Use a colon to separate the parent account name from the subaccount name.įor example, we might set up a Membership Dues Fund in eTapestry that has a Cash account of "Checking", a Revenue account of “Program Income:Membership Dues”, and a Receivables account of “Pledged Income”. In the example above, a Pledge Payment will debit the Checking account (since the amount in checking increased) and will credit the Pledged Income account (to reduce the amount of promised income).įor accounts like Membership Dues, which are subaccounts, you must include the name of the parent account as well as the subaccount in the field on the Fund page. The export directs a pledge payment to debit the Cash Account and credit the Receivables Account that have been set up on the Fund. In the example above, a Pledge will debit the Pledged Income account (since the amount of promised money increased as a result of the pledge), and will credit the Membership Dues account.Ī Pledge Payment involves the fulfillment of a promise. The export directs a pledge to debit the Receivables Account and credit the Revenue Account set up on the Fund. In the example above, a Gift will debit the Checking account (since the amount in checking increased as a result of the gift) and will credit the Membership Dues account.Ī Pledge or Upgraded Pledge involves a promise of future cash. The export directs a gift to debit the Cash Account and credit the Revenue Account set up on the Fund. Donation TypeĪ Gift or Recurring Gift involves cash in hand. eTapestry allows you to direct Gifts, Pledges and Pledge Payments to different QuickBooks accounts. Note: If you use Sales Receipts and select the Cash Sale option, you must set up the Cash Account for each of your Funds to point to the QuickBooks® Undeposited Funds account, either by name or by account number.ĭifferent types of donations are treated differently. The simplest way to do that is to enter the account number that you find on the QuickBooks Chart of Accounts for each of these accounts.įor example, a Fund can be set up to direct donations to the Checking account (account number 10000) as the Cash account, the Pledged Income account (account number 12000) as the Receivables account, and the Membership Dues account(account number 47230) as the Revenue account. When we set up a Fund in eTapestry, we tie it to a specific Bank, Income and Accounts Receivable account from the QuickBooks Chart of Accounts. The QuickBooks Desktop Standard Export affects three types of accounts: eTapestry Funds and the QuickBooks Chart of Accounts To take advantage of the QuickBooks Desktop Standard Export, you must first set up your eTapestry database to track the information QuickBooks requires.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |