We moved!

Help articles have been migrated to the new Help and Support. You can find help for your products and accounts, discover FAQs, explore training, and contact us!

When you transition your clients from Client Bookkeeping Solution (CBS) to Accounting CS Client Access, keep in mind that you cannot convert client data directly from CBS to Accounting CS. You can export the account balances from CBS Accounts Payable, CBS Accounts Receivable, and CBS PayCheck to Creative Solutions Accounting (CSA) using the Export to Accountant feature. When you import the CSA client data into Accounting CS, the same account balances are also transitioned into Accounting CS.

The preferred method for entering open transactions is to enter the open transaction balances directly into Accounting CS via the Beginning Balance dialog (accessed by clicking the Ellipsis  button in the Setup > Vendors > Accounts Payable tab or the Setup > Customers > Accounts Receivable tab.

If you need the detail of historical transactions, you can select Transactions in the Accounting CS spreadsheet import wizard to import several types of transactions. Show me.

Important information about converted account balances

If you convert CBS client data from CSA to Accounting CS using the File > Import > CS Professional Suite Accounting Products Conversion command in Accounting CS, the converted balances include all CBS transactions.

If you subsequently import transactions via the Spreadsheet Import wizard, the application adds the imported payable and invoice amounts to the existing balances, which causes the balances to be incorrect.

• For clients that were set up to use the accrual basis method in CBS, you can correct this in Accounting CS using either of the following methods.
  • Create an adjusting journal entry in the Actions > Enter Transactions screen to reverse the double booking.
  • Delete the transactions that were imported via the spreadsheet from the Actions > Enter Payables screen and the Actions > Enter Invoices screen, and then manually enter only the open transactions in the applicable Beginning Balances dialog.
• For clients that were set up to use the cash basis method in CBS, you will need to reverse any unapplied payments in the Actions > Manage Payments screen and deposits in the Actions > Manage Customer Payments screen.

Exporting CBS transactions to a spreadsheet

You can export transactions data to a spreadsheet in CBS while previewing a report. This example walks you through the process of creating a list of accounts payable transactions, updating the format in the file, and importing it into Accounting CS.

1. In CBS, choose File > Queue Reports and click the Accounts Payable tab.
2. Mark the AP Transactions List checkbox and click the corresponding Options button.
3. In the AP Transaction List dialog, choose Detail - AP acct summarized in the Format group box.
4. In the Activity to include group box, choose the transactions to import.
5. Click OK.
6. In the Queue Reports dialog, click the Print Preview button.
7. In the preview window, click the Export button in the toolbar.
8. In the Format Options dialog, select Excel 8.0 (XLS) (Extended) as the format.
9. Select Disk file as the destination.
10. Click OK.
11. In the Format Options dialog, choose the following options:
    • Column Headings
    • Use worksheet functions to represent subtotal fields in report
    • Column width based on objects in area "Details"
    • Tabular format (Arrange all objects in one area into one row)

    

You will need to reformat the spreadsheet to comply with the format required for import into Accounting CS. For details on formatting the spreadsheet for accounts payable transactions, see Spreadsheet import - AP transactions.

To import CBS Accounts Receivable transactions, repeat these steps and generate the AR Transactions List report in the Accounts Receivable tab of the File > Queue Reports dialog instead of the AP Transactions List report. For details on formatting the spreadsheet for accounts receivable data, see Spreadsheet import - AR transactions.

Before importing spreadsheet data into Accounting CS

Was this article helpful?

Yes No

Submit