Warning

Product support for the Creative Solutions Accounting platform ended on September 30, 2020.

Help & How-To Center content for the Creative Solutions Accounting platform may be outdated and is used at your own risk.

This feature enables you to transfer certain types of transactions back to your QuickBooks client to enable them to adjust their data in QuickBooks.

• You can choose to transfer most types of transactions that were originally entered directly into Write-Up CS or Trial Balance CS.
• You can choose to transfer QuickBooks transactions that have been retrieved into CSA (into Write-Up CS via Accountant's Assistant or into Trial Balance CS) and subsequently modified in CSA by any change to the account number, to the amount distribution or total, or to the vendor.

See also

Using the CS QuickBooks Data Utility

Using the Export via the Internet option for QuickBooks

Transaction types available for transfer

The following types of transactions can be transferred back to QuickBooks if they were recorded directly in CSA, or retrieved from QuickBooks and subsequently modified in CSA.

• Regular checks
• Deposits
• Vendor checks
• Regular journal entries
• Adjusting journal entries
• Prior-period and recurring journal entries
  (Recurring journal entries are transferred back to QuickBooks as regular JEs.)
• Payroll information
  (In the Setup > Generate Information dialog, click Summary to specify payroll journal entries for the transfer back to QuickBooks as regular JEs, or click Detail to specify individual checks. Any direct deposit amounts are transmitted in summary JEs.)
• Adjusting or Reclassifying journal entries entered in Trial Balance CS
• Transactions imported from CBS, Peachtree, Microsoft Office Accounting, BusinessWorks, ASCII files, the Payroll Journal Entry XML import process, or other conversions supported by CSA.

Transactions not available for transfer

The following types of transactions cannot be transferred back to QuickBooks.

• Tax Adjustment or Reversing types of journal entries from Write-Up CS
• Any types of journal entries from Trial Balance CS other than Adjusting or Reclassifying
• Transactions retrieved from QuickBooks that have not been modified in CSA
• Converted transactions from The Write-Up Solution II (WS2 for DOS)
• Any transactions that existed in Write-Up CS prior to v.2007.1.x or in Trial Balance CS prior to v.2007.1.3

Transfer procedure

The first few steps differ depending on whether you normally use the full data import (from Accountant's Assistant) or the Account Balances Only import (from Accountant's Assistant or Trial Balance CS).

Initial steps for transfers to QuickBooks Account Balances Only clients (Accountant's Assistant or Trial Balance CS)

Initial steps for transfers to QuickBooks full-data import clients (Accountant's Assistant)

Remaining transfer steps

1. We strongly recommend that you create a backup of the client data before proceeding. Click Yes at the prompt to create the backup.
2. Specify the target folder for the file to be generated and click OK.
3. When prompted to confirm the location of the CSA Information.‹clientid› file, click OK.
4. In the Select Transactions to Generate dialog, select the transactions to transfer by moving them to the right-hand pane of the dialog, and then click the Continue button. Note that you may choose to filter the list of transactions to display by limiting the date range.
5. The Edit Transactions dialog will open automatically in one or more of the following scenarios.
   • A one-to-one match cannot be found between the CSA account used and the stored list of QuickBooks accounts. If a new CSA account has been used and you want to add it to QuickBooks, select the [Add CSA Account to QB] item from the bottom of the drop-down list in the QuickBooks Account field.
   • The CSA payee cannot be matched to the stored Vendor, Customer, Employee, or Other lists from QuickBooks. If a new vendor or employee has been used and you want to add it to QuickBooks, select the appropriate QuickBooks Payee Type from the drop-down list and then select [Add CSA Payee/Description to QB] from the bottom of the drop-down list in the QuickBooks Payee/Description field.
   • An Accounts Payable account is used in a transaction. Select an appropriate QuickBooks vendor from the Customer/Vendor column to assign to the transaction.
   • An Accounts Receivable account is used in a transaction. Select an appropriate QuickBooks customer from the Customer/Vendor column to assign to the transaction.
   • The checkbook account associated with the transaction cannot be matched to a Bank type account in the stored list of QuickBooks accounts.

   Specify the appropriate information where indicated by a blank field and then click OK. The Edit Transaction dialog will appear for each transaction that needs to be amended.

   To populate the drop-down lists in the Edit Transaction dialog, you must retrieve data from your QuickBooks client at least once prior to generating transactions.

6. In the Generate Transactions Options dialog, choose whether to import the transactions directly into QuickBooks or to create a file (QBgenxfer‹clientid›.xml) in the folder location that you specify.
   • The Import transactions directly into QuickBooks option can be used only if the QuickBooks company data resides on a local drive (local hard drive, network drive, etc.) accessible by CSA.

     After you click OK, the application prompts you to select the QuickBooks company file (.QBW) to import into.

   • The Create a generate file with transactions option creates the QBgenxferCSAClientID data time.xml file in the location you specify. You may then transfer this file to your client - by email, by removable media, etc. - to be imported into QuickBooks via the CS QuickBooks Data Utility, v.7.x - v.12.0.

     Click OK to continue.

7. Click OK at the confirmation prompt to complete the procedure.

Additional information

• After transactions have been generated successfully, they are not available again for subsequent transfer to QuickBooks.
• When you use the Import transactions directly into QuickBooks option, the application stores the last five generate files in the QB Generate subfolder of the client's CSA data folder.
• New CSA account numbers containing a colon (:) cannot be imported into QuickBooks.
• Special notes for users of the Microsoft Vista operating system:
  • When using the Import transactions directly into QuickBooks option, be sure to click the Yes, always; allow access to the data even if QuickBooks is not running option on the QuickBooks - Application Certificate dialog for ease of use in subsequent retrievals.
  • When using the CS QuickBooks Data Utility, close the company in QuickBooks before selecting it in the Location and Name of QB Company file field. After making that selection but before you click the Retrieve button, open the company in the QuickBooks application.

Was this article helpful?

Yes No

Submit