Transactions - Tab

The Transactions - Tab Export is a tab delimited text file in the same format as the QuickBooks® Custom Transactions Detail report. It can be used to export transaction data for import into accounting software that supports this format.

1. Select File>Exports>Transactions - Tab.
2. Select the path for the file.
3. Enter a name for the file.
4. Click Save.
5. Select the method of export: Period/Year or Date Range.
   
   • Period/Year—This is the recommended method for monthly processing.  This method allows the client to work a few days into the next month before closing the period (Activities>Send to Accountant>Monthly Close to Accountant). The following transactions will be exported:
     • All transactions from prior periods that have a date that falls within the date range of the period selected. If the client is on a calendar year basis and the selected Period/Year is 6/2012, then all transactions from prior periods with a date between 06/01/2012 and 06/30/2012 will be exported.
     • All transactions made in the period selected will be exported except those with a date that is future to the date range of the selected period. Using the example above, all transactions made in period 6 of 2012 that do not have a date past 06/30/2012 will be exported.
   • Date Range—This method simply exports all transactions that fall within the selected date range regardless of the period or year in which they were created.
6. Enter the Period and Year or the From and To dates.
7. Select options for exporting Payroll Items and Quantity as desired.
8. Open the software where the file will be imported, and follow the instructions for importing the file as a QuickBooks Custom Transactions Detail report, printed to file in tab delimited format.