# About using decimal precision of zero in a column or cell

Important reminder!

Product support for Engagement CS is ending on September 30, 2020. See Engagement CS license expiration 2020 - frequently asked questions for more information.

Licenses for Payroll CS, Trial Balance CS, and Write-Up CS permanently expired on March 1, 2017.

Some processes documented in the Help & How-To Center are no longer applicable, due to the discontinuation of Creative Solutions Accounting.

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.

## 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. ## 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. 