Adjusting Customer Accounts without Affecting Sales

 

This job aid describes how to adjust an accounts receivable balance without affecting taxable/non-taxable sales. The account balance can be a credit or debit balance.

 

1

Adjusting a credit balance

  1. From the Eagle Browser, click Applications, then click Accounts Receivable Menu.

  2. From the list that displays, click Customer Maintenance.

  3. Display the customer.

  4. Click GoTo and Select Open Item Maintenance. Verify that the correct customer information displays.

  5. From the Document Type pull-down list, select I - Invoice.

  6. In the Amt Tendered box, type the amount of the adjustment, including the minus sign. For example, if the running balance is – 23.78 (a credit of 23 dollars and 78 cents), enter – 23.78 in this field. Include the minus sign in front of the amount.

  7. Click Add.

  8. Check the Bal Method field below the customer name, if the balance method is O (for Open Item), then you must apply this invoice to the unapplied credits or payments that make up the credit balance. Do this in Received on Account (ROA) as you normally would.

If the Bal Method field is B (for Balance Forward), you are done writing-off the transaction, you do not have to apply the invoice.

 

 

How General Ledger is updated

If you adjust a credit balance using the procedure described in section 1, then General Ledger is updated with a credit to the Cash account and a debit to the Accounts Receivable account.

 

DEBIT

CREDIT

CASH

 

23.78

ACCOUNTS
RECEIVABLE

23.78

 

 

 

2

Adjusting a debit balance

  1. From the Eagle Browser, click Applications, then click Accounts Receivable Menu.

  2. From the list that displays, click Customer Maintenance.

  3. Display the customer.

  4. Click GoTo and Select Open Item Maintenance. Verify that the correct customer information displays.

  5. From the Document Type pull-down list, select C - Credit.

  6. In the Amt Tendered box, type the amount of the adjustment, including a minus sign. For example, if the running balance is 19.78 (an outstanding balance of 19 dollars and 78 cents), enter – 19.78 in this field. Include the minus sign in front of the amount.

  7. Click Add.

  8. Check the Bal Method field below the customer name, if the balance method is O (for Open Item), then you must apply this credit to the unapplied invoices that make up the debit balance. Do this in Received on Account (ROA) as you normally would. The credit must first be finalized by the Daily Journal (RDJ) report before you can apply it in ROA. You can wait for the end-of-day RDJ to finalize the credit or you can run the RDJ now, from and to this customer only, with Options FB (Finalize, Backoffice Transactions Only).

If the Bal Method field is B (for Balance Forward), you are done writing-off the transaction, you do not have to apply the credit.

 

 

How General Ledger is updated

If you adjust a debit balance using the procedure described in section 2, then General Ledger is updated with a debit to the Cash account and a credit to the Accounts Receivable account.

 

DEBIT

CREDIT

CASH

19.78

 

ACCOUNTS
RECEIVABLE

 

19.78