Frequently asked questions (Trial Balance CS)

Show expandable text

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.

Balances

Yes. Choose Utilities > Create Rounding Journal Entry to create a (reclassifying) adjusting journal entry that rounds the year-to-date Chart of Accounts balances. In the Rounding dialog, specify the appropriate rounding accounts for Assets, Liabilities, Income Statement, and Retained Earnings and then click OK to initiate the creation of the rounding adjusting journal entry.

The reclassifying adjustment is reflected on reports, workpapers, and financial statements when the Report basis is selected for display.

In the Setup > Chart of Accounts window, choose Force Balance Recalculation from the Edit menu or from the F3 or right-click context menu.

To recalculate the balances in the grid, you need to repost from the Tasks > Adjusting Journal Entries window; choose Post Adjusting Journal Entries from the F3 or right-click context menu, and then verify that the balances in the Trial Balance grid are correct.

The application allows you to enter balances into the Unadjusted Balance column of the Tasks > Trial Balance window only if the General Ledger module is not enabled for the client. If you have turned off GL for the client but still cannot enter unadjusted balances, the client may have been set up for interim processing.

Re-add the General Ledger module for the client and, in the General Ledger tab of the File > Client Properties dialog, change the selection in the Periods group box to Annual. You will then be able to remove the GL module and enter balances into the Unadjusted Balance column of the Trial Balance grid.

To process the client with both the General Ledger module of Write-Up CS and Trial Balance CS in CSA, you need to enter unadjusted balances in the Tasks > Transaction Entry window (not the Trial Balance window).

You can record current-year unadjusted balances in any of three ways:

  • For a non-GL client, you can enter balances in the Unadjusted Balance column in the Trial Balance grid. From the CSA main window, choose Tasks > Trial Balance.
  • From the CSA main window, choose Setup > Chart of Accounts, highlight the account, click the Edit button, and enter the unadjusted balance amount in the field for the current year.
  • Import the current-year unadjusted balances using theUtilities > Import > Spreadsheet command.

You can record prior-year balances in any of three ways:

  • From the CSA main window, choose Setup > Chart of Accounts, highlight the account, click the Edit button, and enter the balance amount in the field for the prior year. (To make the appropriate balance column appear in the Chart of Accounts grid, you may need to modify the settings in the Edit > Options dialog.)
  • Move the client in the prior year, enter the balances in the Unadjusted Balance column of the grid in the Tasks > Trial Balance window, and then roll the client forward to the new year.
  • Import the prior-year balances using the Utilities > Import > Spreadsheet command.

Import and export

Only the Net changes of accounts are imported from QuickBooks Pro when you choose this command. QuickBooks Pro does not store beginning balances. To get the correct balance you will need to carry forward the prior year's ending balance. If this is the first year that the client is processed using Trial Balance CS, you need to set up the client in the prior year and to enter the ending balances. Next, close the year and carry forward the balance sheet account balances.

The tax exports require additional licensing to be added to your applications. To obtain a license for the export that you need, please contact our Customer Service Department at 800.968.0600.

Interim clients

Trial Balance CS is designed for year-end processing and allows for annual processing only. You can process the client with interim processing periods if you are also licensed for Write-Up CS and process the client using the General Ledger module and/or if you are also licensed for Engagement CS. To add the General Ledger module or Engagement CS for processing the client, choose File > Client Properties and click the Add/Remove Module(s) button. Mark the checkbox for the General Ledger module and/or Engagement CS, and click OK.

Rounding

Trial Balance CS rounding is based on the report balance. If you are reporting on any other type of balance and rounding, your statement may not foot correctly. To use the report balance, highlight the columns in the financial statement and select Report in the Basis field of the Cell Properties group box.

To define the report balance to include the desired Entry types, choose Setup > Balance Definitions.

See Changing the report balance definition to effect rounding in Trial Balance CS.

Grouping schedule codes and subcodes

Journal entries

You will need to repost in the Adjusting Journal Entries window to recalculate the balances. Choose Tasks > Adjusting Journal Entries, In the Adjusting Journal Entries window, press the F5 key to repost the amounts for your accounts, and verify that the new amounts are correct.

Was this article helpful?

Thank you for the feedback!