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.
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.
Was this article helpful?
Thank you for the feedback!