Rounding of AP Document Amounts: General Information

Your company policy or local regulations may require the total amounts in AP documents to be rounded. To set up amount rounding in AP documents, you first enable the Invoice Rounding feature on the Enable/Disable Features (CS100000) form. You then specify the settings the system will use to round these totals.

Learning Objectives

In this chapter, you will learn how to do the following:

• Set up the of rounding the amounts of AP documents
• Process an AP bill with a rounded amount and review the generated GL transaction

Applicable Scenarios

You set up the rounding of AP document amounts if your company's policy or external regulations require that you round the amounts in invoices and bills.

Rounding Setup

In MYOB Acumatica, the system rounds AP document totals based on the rounding rule, rounding precision, and rounding limit. You use the following forms to specify the applicable settings:

• Accounts Payable Preferences (AP101000): You use this form to specify the rounding rule and the precision that apply to AP documents. You can specify a separate rule and precision for each of the following types: Bill, Credit Adj., Debit Adj., Prepayment, and Cash Purchase.
• Currencies (CM202000): You use this form to specify the system-wide rounding limit for the base currency. This limit is the maximum rounding difference between the rounded amount and the original document amount.

The system applies rounding rules to documents in all currencies (base and foreign). You specify the rounding limit for only the base currency, but it is applied to documents in foreign currencies as well. The system always recalculates the amounts of a document in a foreign currency to amounts in the base currency of your system, including the rounding difference. The system compares the recalculated rounding difference to the base currency with the rounding limit and issues a warning if the limit is exceeded.

The rounding difference should be recorded to specific rounding gain and loss accounts. Depending on the policies established in your company, you can use a single gain account and a single loss account (and the corresponding subaccounts, if applicable) for all currencies, or you can use different gain and loss accounts (and the corresponding subaccounts) for each currency used by your company.

You use the Currencies form to specify the following:

• The rounding gain and loss accounts (and subaccounts, if they are used in your system) for the base currency
• The gain and loss accounts and subaccounts for each of the foreign currencies used by your vendors

Rounding Rule

To set up rounding for documents, you select the rounding rule and precision in the Data Entry Settings section on the General tab of the Accounts Payable Preferences (AP101000) form. The following rounding rules are available in the Rounding Rule for Bills box:

• Nearest: To round each total amount to the nearest multiple of the smallest unit.
• Up: To round each total amount up to the next multiple of the smallest unit.
• Down: To round each total down to the previous multiple of the smallest unit.
• Use the Currency Precision: To temporarily not use rounding if it is activated in your system. If this option is selected, for each document, the system will round the document total according to the precision specified for the document currency. The precision of the base currency is specified on the Branches (CS201000) form, and the precision of foreign currencies is defined on the Currencies (CM202000) form.

In the Rounding Precision box of the same section of the form, you select the rounding precision—that is, the smallest unit to be used for document amounts. The following options are available:

• 0.1: To round the totals to multiples of 0.10
• 0.5: To round the totals to multiples of 0.5
• 1.0: To round the totals to integers
• 10.0: To round the totals to multiples of 10
• 100.0: To round the totals to multiples of 100

The following table illustrates the results of rounding with different rules and precisions applied to the sample value of $1,734.57.