Note: The Payment record will be stored in your QuickBooks® desktop database as a single amount, so the Items will not appear on the Payment record. You are ready to import the file into QuickBooks® desktop. For Save as type, select Text type and ensure that the file name ends with suffix "IIF" (for example: eTapestryExport2-18-14.iif).Ĭonfirm that you want to keep the file in the same format.Ĭlose the file. Consider using a "Find and replace" feature to identify every instance and make mass changes. To modify the export file, use spreadsheet software (such as Microsoft Excel) to open the IIF file.Ĭhange every instance of the phrase “CASH SALE” to “PAYMENT.” This appears in the TRNSTYPE column. When the export is complete, the export file will be in the Intuit® Interchange Format (IIF). Select a distribution memo, such as Export Date.Ĭlick Submit to export the items or click Schedule for Off-Hours to run the export later. Under Customizable Fields, select a transaction name. If you track sales tax in QuickBooks, select Yes. Select whether to create a subtotal by GL account. ![]() ![]() Select whether to export individual transactions. Under Transaction information, select Cash Sale for the QuickBooks® Transaction Type. Select whether to export optional customer fields. Under Customer Information, select whether to export the name or sort name. Select the category and query which identifies the transactions in eTapestry which should be exported. The Launch Quickbooks Desktop Export page appears. Under Accounting Exports, select Quickbooks Desktop Export. For example, you may want to only export pledge transactions for the previous week which were not final ized.įrom the Management, click eTapestry Standard Exports. Limit the transactions to Journal Entry Type Pledge. Then create a query to identify the transactions in eTapestry which should be exported. Export Payments into QuickBooks Desktop as Paymentsīefore you export deposits, ensure that your eTapestry database is set up with correct funds.
0 Comments
Leave a Reply. |
AuthorKatie ArchivesCategories |