Round Bill Amounts and Item Prices

The reports round unpaid bills and item prices up or down to the nearest 5 cents. This enables cash payments to be made when no coin denomination smaller than 5 cents is available.

SEO updates are limited to 10,000 items per day, the full project for your library may require several days to complete.

Round Bill Amounts to the Nearest 5 Cents

For each bill record selected, the report calculates a new bill amount by rounding the unpaid balance up or down to the nearest 5 cents and adjusting the amount accordingly. After the report runs you will receive a spreadsheet containing the items that were updated. The spreadsheet contains a cover sheet named "TOTALS" plus one sheet for each bill library included in the selection.

The TOTALS sheet contains one row for each bill library, with the following data in columns:

1. Library
2. Balance Owed
3. New Balance

Grand totals are included for columns 2 and 3.

Library sheets contain one row for each bill record selected, with the following data in columns:

1. User ID
2. Bill Reason
3. Date Billed
4. Amount Billed
5. New Amount
6. Balance Owing
7. New Balance

Totals are included for columns 4 through 7.

Round Item Prices to the Nearest 5 Cents

For each item record selected, the report calculates a new price by rounding up or down to the nearest 5 cents. After the report runs you will receive a spreadsheet containing the bills that were updated. The spreadsheet contains a cover sheet named "TOTALS" plus one sheet for each item library included in the data.

The TOTALS sheet contains one row for each item library, with the following data in columns:

1. Library
2. Total Value
3. New Value

Grand totals are included for columns 2 and 3.

Library sheets contain one row for each item record selected, with the following data in columns:

1. Author
2. Title
3. Call Number
4. Home Location
5. Item Type
6. Item ID
7. Current Price
8. New Price

Totals are included for columns 7 and 8.

Amounts are rounded up or down as follows:

• 1 and 2 down to 0.
• 3 and 4 up to 5.
• 6 and 7 down to 5.
• 8 and 9 up to the next multiple of 10.