Report Designer: Rounding on reports and financial statements

Alerts and notices
Leave feedback

Internal Employees: Submit feedback

Contact information (optional):

Leave this blank:

Please tell us how we can make this information more helpful.


Characters left:

Change to CS Support service hours

Our Support department is closed on Friday, April 28th for a company event. However, limited Accounting CS phone support is available on that date from 9 AM - 5 PM ET due to the approaching deadline for quarterly payroll tax forms.

Links to our most popular payroll tax processing topics are available in the Alerts and notices section on the right side of most pages.

Accounting CS allows you to have certain balance types be automatically rounded for reporting purposes. Use the following information to troubleshoot why rounded reports and financial statements may display as out of balance and how to correct this.

Report displays "out of balance"

When you preview a report or financial statement, you may see text displayed saying *OUT OF BALANCE*. Use the following information to resolve this message.

Setting up rounded amounts on reports and financial statements

Use the following steps to set up rounded balances for a client.

  1. Choose Setup > Clients and click the Accounting Information tab.
  2. Click the Edit button next to the Balance definitions field.
  3. Mark the checkboxes in the Round Balances column for any balance type that you want to display rounded amounts, such as the Report balance type.
  4. Assign the rounding accounts in the General Ledger Accounts section.
  5. Click OK and Enter to save your changes.

You do not need to modify the financial statements to use a different balance basis. Use the following steps instead.

  1. Choose File > Print Reports and select the financial statement.
  2. In the Balance Basis section on the right, select the basis that you set up for rounding above. Show me.
    Selecting the appropriate balance basis option for the financial statement

Reports that are not considered financial statements do need to be modified in the Report Designer to use a different balance basis.

  1. Choose File > Report Designer and then double-click the report you are modifying.
  2. Click the column letter heading to select the entire column that contains amounts.
  3. In the Column Properties, select the appropriate balance basis in the Basis field.
  4. Choose File > Save to save your changes.

How does Accounting CS calculate rounded balances?

The debit and credit balances for each period are rounded individually and then combined together. These balances are NOT summed together to get the total balances (i.e. year to date or current year balances). The total balances are rounded separately as their own numbers.

This means that the rounded period balances won't always agree with the rounded current year balances (because they are looked at separately).

For example, let's say your report or financial statement is out of balance by $1 or $2 and your client is a monthly client in the last period in the year that does NOT carry beginning balances. Instead of using the Period indicator CY in the amount cell, you can use [(C1) + (C2) + (C3) + (C4) + (C5) + (C6) + (C7) + (C8) + (C9) + (C10) + (C11) + (C12)] for the CY cell.

Related topics

Using rounding accounts and rounded amounts in statements

Setting up balance definitions

Share This