You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close

Schedule QuickBooks Online Trial Balance Exports Using Transaction Pro Exporter

QUESTION

Can a Trial Balance Report export be scheduled with Transaction Pro Exporter for QuickBooks Online?

RESOLUTION

When exporting the Trial Balance Report from QuickBooks Online with Exporter, there is the option to schedule future exports. The schedule can be one time or recurring. This option allows the export schedule to be configured and allows report to be exported on regular intervals without having to initiate them in Exporter.

Below are the steps to set up a scheduled export of the Trial Balance Report.

Step 1: Get Started

To get started, login with your Intuit ID at https://importer.transactionpro.com/TpiPlus/

Step 2: Launch Exporter

Click EXPORT to open the Exporter.

Step 3: Schedule Export

On the right side of Exporter, click SCHEDULE EXPORT.

Step 4: Define Scheduled Export

Click the ADD NEW button to define a new scheduled export. This will open a screen to capture the required export options and export schedule.

Step 5: Set Data Filters

Select TRIAL BALANCE as the Export Type.

Step 6: Select Filters.

The available Filter is Accounting Method: Choose either ACCRUAL or CASH.

Step 7: Configure Schedule

The schedule configuration must be set. The Scheduling Options are:

  • One Time
  • Daily
  • Weekly
  • Monthly

Depending on the Option selected, different variables will be presented to select.

If DAILY is selected, select the Start Date and how many days before the export should recur.
 

For WEEKLY, select the Start Date and the day of the week that it should recur on.
 

For MONTHLY, select the Start Date and the day of the month that it should recur on.

Step 8: Complete Export Schedule Setup

When the scheduled export configuration is completed, click on the SCHEDULE EXPORT button.

Step 9: Export Schedule Setup Completed

The message YOUR EXPORT HAS BEEN SCHEDULED SUCCESSFULLY should appear along the top of the screen.On the scheduled date, the exported data will be received by the user creating the scheduled export via email as an attached .CSV file.

Step 10: Additional Options

If the scheduled export is no longer needed, the option exists to delete the scheduled export or mark it as inactive.

Click on the box beside the export file and select DELETE or MARK AS INACTIVE.

If marked as Inactive, the option is available to MARK IT AS ACTIVE, if needed at a later date. 

  • 524
  • 09-Mar-2022
  • 375 Views