All accounting software struggles with the problem of rounding. Rounding situations most often occur when calculating taxes on sales, but other transaction can cause rounding issues too. This is a normal occurrence and is the result of fairly complicated rounding rules and the order in which numbers must be rounded. The differences are usually small. Federal and state tax authorities understand the challenge with rounding. In fact, many tax forms do not require than cents be included.
A typical accounting database may contain 500,000 or more numeric amounts. Total Office Manager stores most of these numbers in their actual form – four or more numbers to the right of the decimal point (example: $537.897643). However, most forms and reports necessarily display numbers ROUNDED to only two numbers right of the decimal point (example: $537.90). Generally, the un-rounded numbers are totaled up before being rounded. Other circumstances require that individual numbers be rounded prior to being summed. This concept is known as “ordering” and can be very subjective. The difficulty of rounding becomes more profound when totals must be combined from several different areas of the database and then totaled.
Total Office Manager creates a special account (in Chart of Accounts) called “Rounding”. This is an “Other Expense” account type which, when needed, appears on your Income Statement. This account may have a positive or negative balance. Over time, these slight differences can add up to several dollars or more. At any point, an Adjusting Journal Entry can be used to zero out this amount. Generally speaking, users do not need to do anything.
Rounding Account FAQ
What is this Rounding Account on the Income Statement?
My Income Statement includes an account called Rounding. I did not create it. What is it and what is it used for?
Behind the scenes, Total Office Manager does a lot of rounding to keep forms and reports as accurate as possible. Sometimes the program needs to add or subtract one or more cents to a transaction to get things in balance.
Total Office Manager creates a special account (in Chart of Accounts) called “Rounding”. This is an “Other Expense” account type which appears on your Income Statement when necessary. This account may have a positive or negative balance. Over time, these slight differences can add up to several dollars or more. At any point, you can add an Adjusting Journal Entry to zero out this amount. Generally speaking, users do not need to do anything.
What is this Rounding Adjustment on the Balance Sheet?
My Balance Sheet shows a “Rounding Adjustment”. I did not create it. What is it and why do I have it?
This account is automatically created by Total Office Manager when the Balance Sheet has become out of balance. This is a special account that does not appear on your Chart of Accounts.
Total Office Manager does not let you save transactions that are out of balance. In other words, the balance sheet is self balancing and only becomes out of balance when one or more of the following situations occur.
- The most common reason is rounding due to taxes.
- The program has shut down improperly.
- A power outage interrupted a transaction save.
- The database has become corrupted.
- There have been problems with network connectivity.
- A hard disk drive is starting to develop “bad clusters” which may indicate the drive’s pending need of replacement.
- The data was not properly saved to the database.
Fixing a Large Rounding Account
If the Rounding Adjustment account is less than a few dollars, we would not necessarily recommend that you do anything about it. It is likely a result of rounding – which is normal. However, if the amount is large, your database likely contains corrupted transactions. These transactions are probably either “out of balance” or are missing accounts (their account selections have become “lost”). These should be fixed.
Corrupted transactions can usually be fixed by re-saving them. Here’s how:
- From the main menu, click Tools | Utilities. The Utilities form will appear.
- Double click on Database Checkup. The Database Checkup utility will appear.
- Search for any transactions which are out of balance. In the Scan selection box, select “Out of Balance Transactions” and click the Scan button. If any transactions are listed, follow the on screen instructions. Generally you will need to open each transaction listed and re-save the transaction. The best way to do this is to add something to the form (like a memo – even if just a period or a dash) then immediately remove it. Click the Save & Close button and continue to the next item on the list. Note that when you re-save, the item will not be removed from the list.
- Now search for any transactions which are missing accounts. In the scan selection box choose “Find Missing Accounts” then click the Scan button. If transactions are listed, follow the on screen instructions. Generally you will need to open each transaction and re-save it in the manner described in step 3.
- Recheck the Rounding Adjustment account on your balance sheet. Contact technical support if you still suspect problems.
Occasionally re-saving a transaction will not fix it. In that case, it will need to be deleted and recreated. Be sure you have the proper permissions to delete and add transactions.
- Backup your database (for safety reasons).
- Using the Database Checkup utility, scan for “Out of Balance Transactions” and for “Find Missing Accounts” as outlined above.
- Thoroughly document each transaction to be deleted. Create detailed screenshots of each transaction (Shirt+F1 prints the active window or form; Sift+F2 prints the entire screen). Make notes and print reports as needed. You need to make available all information required to recreate each transaction.
- Delete the transaction from its applicable list. For example, delete a payment from the Payments List, and delete a bill from the Bills List. Now recreate the transaction based on your pre-deletion documentation, making sure to use the exact same dates, amounts, and other information.
- Remember, when deleting transactions the order of your deletions is important. You must start at the “end” of the sequence and work backwards. For example, to delete a bill you must first delete the subsequent check which paid it. ie: start at the end of the chain of events (the check) and work backwards. To delete an invoice you must first delete its subsequent payment. ie: start at the end of the chain of events (the payment) and work backwards. To delete a payment, you must first delete the subsequent deposit. See the help topic “Tips – Deleting – General How To” for more information.
- When a transaction that has been marked as “Reconciled” is deleted and recreated, it will no longer be considered reconciled in the program. You will need to take care of this when you perform your next Bank Reconciliation.