YouTube videos and Knowledge Base articles exist regarding the new Admin Portal and Billing Portal for Transaction Pro Online.

Search "Admin Tool" to locate them or email support@transactionpro.com with any questions.

Import Trial Balance into QuickBooks Desktop

QUESTION

How can a Trial Balance be imported into QuickBooks Desktop (QBDT) with Transaction Pro Importer?

RESOLUTION

The best way to import a Trial Balance into QBDT is with the import type Journal Entry.

Two things to consider when importing a Trial Balance as a Journal Entry:

  1. QBDT only allows one Accounts Receivable (AR) OR one Accounts Payable (AP) account per a single Journal Entry. A workaround for these type of accounts on the Trial Balance is to modify the Accounts on these lines so that it posts to a transfer or inter-company Account. Then add additional Journal Entries with two lines each to move the amounts out of the transfer or inter-company Account to the correct AR or AP Account.

  2. If there is a line in the import file that posts to an AR or an AP account, the line must reference a name (Customer or Vendor) and that name must already exist in the QBDT company file.

  • 164
  • 07-Jul-2019
  • 2707 Views