About using decimal precision of zero in a column or cell

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.

For amounts in a selected column, cell, or group of cells, you may specify the decimal precision using the Number tab of the Format > Cells dialog.

See also: About rounding accounts for financial statements

Row references vs. account references

When using decimal precision of zero in a column or cell, the application rounds amounts to the nearest whole-dollar amount rather than simply truncating the amount. The following example describes how amounts will be presented under different statement configurations with decimal precision of zero. This is relevant only if you are not using the financial statement rounding option as selected from the Statement Properties dialog.

A totals row could produce a different result depending on what is referenced in the Amounts field in the row properties.

  • If a row reference is used in the totals row - for example, Row(5) or Row(5 to 7) - the application derives the total amount by adding together the decimal precision of zero amounts from the individual cells in the referenced row(s).
  • If an account group, storage name, or range of accounts is used in the totals row - for example, Expenses or act(100 to 110) - the application adds together the actual Chart of Accounts amounts for the accounts referenced and presents the decimal precision of zero for the total amount.

Example

Statement line items Amts using decimal precision of 2 Amts using decimal precision of 0 Amts using decimal precision of 0
Totals row references a row Totals row references accts or acct groups
(Row(5)) (Expenses)
Rent
$ 6,500.00
$ 6,500
$ 6,500
Utilities
56.29
56
56
Maintenance & Repairs
947.30
947
947
Total Expenses
$ 7,503.59
$ 7,503
$ 7,504

Notes

  • When using decimal precision of zero and row references, the total amount and the detail above it will foot, but under certain circumstances the balance sheet may not balance correctly.
  • When using decimal precision of zero and account references, the balance sheet will balance but under some circumstances (as shown in the example above), the total amount and the detail above it may not foot.

As noted above, decimal precision of zero is not meant to replace rounding. When using rounding, the total amount and the detail above it will foot and the balance sheet will balance.

Top of page

Rounding for a Trial Balance CS client

Trial Balance CS

Rounding is based on the Report balance for a Trial Balance CS client. If you were to use rounding when reporting on any other type of balance, your statements may not foot correctly.

Top of page

Was this article helpful?

Thank you for the feedback!