Entering adjusted memos
The Advanced Accounting Console includes quick access to tools most often needed to maintain your organization's financial transactions. From the Finance section, you can make credit and debit adjustments. The Adjustments section is where pledge credit and debit memos are processed, as well as other types of credit and debit memos. Also from Adjustments, you can easily edit your accrual dues and credit memos.
You can process reversals of an entire pledge, which might contain one or more installment records, on the Enter and edit pledge credit memos window, or you can reverse a single line item.
Credit memos make adjustments that reduce or reverse normal open accounts receivable (AR) items. Use credit memos for the following tasks:
- Writing off an open item that cannot be collected
- Reducing or reverse a line item charge
- Reversing a previously entered transaction
Do the following to apply credit memo adjustments to multiple funds for a split gift:
- In the Advanced Accounting Console, go to Finance > Adjustments > Credit memos.
- Click New.
- Enter the donor ID in the Id field, or click the lookup icon to select a donor ID.
- Enter the transaction number in the Invoice# field and press Tab, or press Ctrl+L to look up a transaction number. The split gifts per fund pertaining to this gift or pledge are displayed.
- Enter the distribution or premium code in the Product field, or click the lookup icon to select a distribution or premium, and press Tab.
- Enter 1 in the Quantity field.
- Enter the credit memo adjustment amount in the Unit Price field.
- (optional) Repeat to apply a credit memo adjustment to additional distributions.
- Click Save.
Note: If more than one distribution is assigned to the same fund, only one line is displayed for the fund, showing the combined charges for these distributions. You must know the distribution or premium code that you want to adjust and its value per the installment invoice.
Do the following to apply debit memo adjustments to multiple funds:
- In the Advanced Accounting Console, go to Finance > Adjustments > Debit memos.
- Click New.
- Enter the donor ID in the Id field, or click the lookup icon to select a donor ID.
- Enter the transaction number in the Invoice# field and press Tab. The split gifts per fund for the transaction are displayed.
- Enter the distribution premium code in the Product field, or click the lookup icon to select a distribution or premium, and press Tab.
- Enter 1 in the Quantity field.
- Enter the debit memo amount in the Unit Price field.
- (optional) Repeat to apply the debit memo to additional distributions.
- Click Save.
Note: If more than one distribution is assigned to the same fund, only one line displays for the fund, showing the combined charges for these distributions. You must know the distribution or premium code that you want to adjust and its value per the installment invoice.
Do the following to enter pledge credit memo adjustments:
- In the Advanced Accounting Console, go to Finance > Adjustments > Pledge credit memos.
- Click New.
- The Date field defaults to:
- The batch date if batch control is enabled. If an active, open batch is not selected, the Open Batches window opens. After selecting or creating a batch, click New on the Pledge credit memos window again.
- The system date if batch control is not enabled. If you override the system date, the new date becomes the default date for new credit memos until the Pledge credit memos window is closed and reopened.
- Enter the donor ID in the ID field, or click the lookup icon to select a donor ID, and press Tab. After the ID field is populated and Tab is pressed, an address block for the customer is displayed, and the Type and Status fields are populated.
- Click Find Pledge to display the Find window.
- Select the pledge to be adjusted and click OK.
- Use one of the following methods to specify the credit memo adjustment:
- Click Adjust All to issue a credit memo against all installments associated with a pledge that has a non-zero balance.
- Select the Credit checkbox to credit specific line items. For example, enable the Credit option for an invoice number, and the full amount is displayed in the Amount Adj field for this invoice number.
- Enter the amount to credit in the Amount Adj field for the line item. For example, enter 25.00 in the Amount Adj field for invoice number R64 and press Tab. This will automatically enable the Credit checkbox for this line item.
- Click Save. The total amount of the credit memo displays in the Total Adjustment field.
Note: Line items that were not adjusted are no longer displayed in the Pledge credit memos window after you click Save.
Debit memos have the opposite effect of credit memos, increasing the balance of open accounts receivable items. Use debit memos for the following tasks:
- Increase or add a line item charge.
- Bring a credit balance to zero due to an overpayment, credit memo, or cancellation transaction.
Do the following to enter a pledge debit memo:
- In the Advanced Accounting Console, go to Finance > Adjustments > Pledge debit memos.
- Click New.
- The Date field defaults to one of the following:
- If batch control is enabled, the Date field defaults to the batch date. If an active, open batch is not selected, the Open Batches window opens. After selecting or creating a batch, click New on the Pledge debit memos window again. You cannot override the date if batch control is enabled.
- If batch control is not enabled, the Date field defaults to the system date. You can override this date. If you override the system date, the new date becomes the default date for new debit memos until the Pledge debit memos window is closed and reopened.
- Enter the donor ID in the ID field, or click the lookup icon to select a donor ID, and press Tab. After the ID field is populated, an address block for the customer displays in the Pledge debit memos window and the Type and Status fields are populated.
- Click Find Pledge (bottom of the Pledge debit memos window) to display the Find window.
- Select the pledge installment for the pledge debit memo adjustment.
- Click OK.
- Use one of the following methods to specify the debit memo adjustment:
- Click Adjust All to select all line items with a balance to debit. The full amount displays in the Amount Adj field for each line item, the Debit checkbox is selected for each line item with a balance, and the total amount of all debit memo adjustments is displayed in the Total Adjustment field. The Adjust All button is only enabled if the total pledge balance is negative.
- Select the Debit checkbox to debit specific line items. For example, enable the Debit checkbox for invoice number R65 and the full amount displays in the Amount Adj field for this invoice number.
- Enter the amount to debit in the Amount Adj field for the line item, and press the Tab key. For example, enter 25.00 in the Amount Adj field for invoice number R64. This will automatically enable the Debit option for this line item.
- Click Save. The total amount of the debit memo displays in the Total Adjustment field.
Note: Line items that were not adjusted are no longer displayed in the Pledge debit memos window after you click Save.
Use credit memos to perform the following tasks:
- Write off an open item that cannot be collected.
- Reduce or reverse a line item charge.
- Reverse a previously entered transaction.
- Record product returns and credit the customer.
You can process reversals of open accrual dues items on a line-by-line basis on the Accrual dues credit memos window (in the Advanced Accounting Console, go to Finance > Adjustments > Accrual dues credit memos). After the credit memo is processed, the balance reduction is reflected appropriately in the various inquiry windows.
For example, if a customer cancels a single line item on a bill and pays for the remaining items, you should reverse the charge of the cancelled item.
Note: Accrual dues credit memos must be processed on the Accrual dues credit memos window under Finance.
The Accrual dues credit memos window adheres to the same authorization level security rules as the Payments window:
- To find and view an existing credit memo, you must have a Dues authorization level of one (1) or greater.
- To enter new accrual dues credit memos, you must have a Dues authorization level of three (3) or greater. A Dues authorization level of three (3) will allow you to edit or delete credit or debit memos you have entered.
- If the View batch by user option is enabled on the AR/Cash Batch Control window (in Advanced Accounting Console, go to Finance > Options > Configure accounting options > Batch Control), to edit or delete another user's accrual dues credit memo, you must have a Dues authorization level of four (4) or greater.
You can process reversals of accrual dues items on a line-by-line basis through the Accrual dues credit memos window. For example, if a customer cancels a single line item, you can reverse that one line.
Note: If your system is licensed for Deferred Income and the product being reversed is normally deferred, iMIS will automatically adjust the deferred income and any income recognized for this product during the GL Interface procedure.
- From the Advanced Accounting Console, go to Finance > Adjustments > Accrual dues credit memos.
- Click New.
- The Date field defaults to:
- Batch date if Batch Control is used.
- If Batch Control is enabled and an active open batch is not selected, the Batch Control List is displayed. Select or create a batch and click New.
- If Batch Control is enabled and an active open batch is selected, the Date field is populated with the date of the batch.
- System date, if Batch Control is not used.
- If the system date is overridden, the new date becomes the default value for inserts until the window is closed and reopened.
- Batch date if Batch Control is used.
- Enter an ID or select the lookup icon to find a customer's record. After the ID field is populated, an address block for the customer displays at the top of the window and the fields labeled Type, Status, Paid Thru, and Category populate. The calculated address block contains a concatenation of the full name, title, company, and full address.
- Tab to the Invoice # field. Enter the accrual billing invoice number and press Enter, or select the lookup icon to select an invoice
- Invoice or reference numbers are validated for the following:
- Invoice.SOURCE_SYSTEM is equal to DUES and at least one Invoice_Lines row is linked to the invoice.
- The Invoice.BT_ID is equal to the ID entered for the credit memo.
- After the invoice number is entered, select from the following options:
- Click Adjust All to select all line items to credit. The balance amount displays in the Amt Adj field and the Credit option is selected for each line item.
- Select the Credit option to credit specific line items. For example, select this option for Line 2. The balance amount displays in the Amt Adj field.
- Enter an amount to credit in a line item's Amt Adj field. For example, enter 100.00 in the Amt Adj field for Line 1. This will automatically enable the Credit option.
- Click Save to update the record.
Note: The CATEGORY field displays prefixed with the label Category if your administrator has enabled the Use Bill Categories option. If this option is not enabled, neither the category value nor the category label will display.
Note: Selecting Adjust All or Credit always zeros out the balance amount. If you do not want to zero out the balance, enter the needed adjustment amount in the Amt Adj field.
Note: The Total Adjustment field displays the total amount of the credit memo. Line items not adjusted are no longer displayed on the window.
- In the Advanced Accounting Console, go to Finance > Adjustments > Accrual dues credit memos.
- Click Find or Open.
- Enter the transaction number and press Enter.
iMIS verifies that the transaction number is the correct type based on whether Trans.SOURCE_SYSTEM is equal to DUES and Trans.JOURNAL_TYPE is equal to CM. If the transaction number is not correct, a message is displayed informing you that the transaction could not be located.
Note: Accrual dues credit memos must be processed on the Accrual dues credit memos window under Finance.
- In the Advanced Accounting Console, go to Finance > Adjustments > Accrual dues credit memos.
- Click Find or Open.
- Tab to the Date field and enter a valid date, for example, 04152001, and press Enter.
iMIS builds a list of potential matches, looking for a match with that date and of the correct type (Trans.SOURCE_SYSTEM is equal to DUES and Trans.JOURNAL_TYPE is equal to CM). If no transactions are found, a message is displayed informing you that no transactions match your criteria.
The most recent transaction to meet the criteria is displayed. If there is more than one transaction that meets the criteria, the most recent transaction is displayed and the Left arrow is activated. After viewing the previous transaction, the Right arrow is activated, allowing you to scroll through all transactions based on the date entered (Trans.SOURCE_SYSTEM equal to DUES and Trans.JOURNAL_TYPE equal to CM).
Note: Accrual dues credit memos must be processed on the Accrual dues credit memos window under Finance.
- In the Advanced Accounting Console, go to Finance > Adjustments > Accrual dues credit memos.
- Click Find or Open.
- Tab to the ID field, enter a valid ID, and press Enter.
iMIS builds a list of potential matches, looking for a match with that ID and of the correct type (Trans.SOURCE_SYSTEM is equal to DUES and Trans.JOURNAL_TYPE is equal to CM). If the ID is not correct, a message is displayed informing you the transaction could not be located.
The most recent transaction to meet the criteria is displayed. If there is more than one transaction that meets the criteria, the most recent transaction is displayed and the Left arrow is activated. After you have viewed the previous transaction, the Right arrow is activated, allowing you to scroll through all valid transactions (Trans.SOURCE_SYSTEM equal to DUES and Trans.JOURNAL_TYPE equal to CM) based on the date entered.
Note: Accrual dues credit memos must be processed on the Accrual dues credit memos window under Finance.
You can edit an accrual dues credit memo only if it has not been exported through a General Ledger interface. After this occurs, Trans.POSTED is equal to 4, and you will not be able to edit the credit memo.
- In the Advanced Accounting Console, go to Finance > Adjustments > Accrual dues credit memos.
- Find an accrual dues credit memo.
- Click Edit.
- Tab to the Amt Adj field to edit the amount.
- Click Save.
Note: If a batch is not selected, iMIS will ensure that the batch containing the credit memo is still in an open state and then open the Batch window.
Note: If a batch is selected, but is not the batch containing the credit memo, a message is displayed asking you to confirm loading a batch other than the one selected. Click No to cancel the edit, or click Yes to proceed. Before changing the batch, iMIS will ensure that the batch is still in an open state. If the batch is not open, a message is displayed informing you that the batch is not open and cannot be edited.
You can cancel an accrual dues credit memo only if it has not been exported through a General Ledger interface. After this occurs and the Trans.POSTED_FLAG is equal to 4, you will not be able to edit the credit memo.
- From the Advanced Accounting Console, go to Finance > Adjustments > Accrual dues credit memos.
- Find an accrual dues credit memo.
- Click Delete.
- If a batch is not selected, iMIS will ensure that the batch containing the credit memo is still in an open state, open the Batch window, and ask you to confirm the deletion. Click Yes to delete the transaction or click No to cancel the deletion.
- If a batch is selected, but is not the batch containing the credit memo, a message is displayed asking you to confirm loading a batch other than the one selected. Click Yes to proceed. Before changing the batch, iMIS will ensure that the batch is in an open state. If the batch is open, a message is displayed asking you to confirm the deletion. Click No to cancel the delete or click Yes to delete the transaction. If the batch is not open, a message is displayed informing you that the batch is not open and cannot be edited.
Use debit memos to perform the following tasks:
- Increase a line item charge
- Bring a credit balance to zero due to an overpayment, credit memo, or cancellation transaction
Note: If your system is licensed for Deferred Income and the product being reversed is normally deferred, iMIS will automatically adjust the deferred income and any income recognized for this product during the GL Interface procedure.
The Accrual dues debit memos window adhere to the same authorization level security rules as the Payments window:
- To find and view an existing debit memo, you must have a Dues authorization level of one (1) or greater.
- To enter new accrual dues debit memos, you must have a Dues authorization level of three (3) or greater. A Dues authorization level of three (3) will allow you to edit or delete credit or debit memos you have entered.
- If the View batch by user option is enabled on the AR/Cash Batch Control window (in Advanced Accounting Console, go to Finance > Options > Configure accounting options > Batch Control), to edit or delete another user's accrual dues debit memo, you must have a Dues authorization level of four (4) or greater.
You can process reversals of accrual dues items with a credit balance on a line-by-line basis through the Accrual dues debit memos window. For example, if a customer overpays an invoice and you do not intend to refund the overpayment, you should process a debit memo for that amount.
Note: If your system is licensed for Deferred Income and the product being reversed is normally deferred, iMIS will automatically adjust the deferred income and any income recognized for this product during the GL Interface procedure. For more information, see Using Deferred Income.
- From the Advanced Accounting Console, go to Finance > Adjustments > Accrual dues debit memos.
- Click New.
- The Date field defaults to:
- Batch date if Batch Control is used.
- If Batch Control is enabled and an active open batch is not selected, the Batch Control List is displayed. Select or create a batch and click New.
- If Batch Control is enabled and an active open batch is selected, the Date field is populated with the date of the batch.
- System date, if Batch Control is not used.
- If the system date is overridden, the new date becomes the default value for inserts until the window is closed and reopened.
- Batch date if Batch Control is used.
- Enter an ID or select the lookup icon to find a customer's record. After the ID field is populated, an address block for the customer displays in the upper right-hand corner and the fields labeled Type, Status, Paid Thru, and Category are populated. The calculated address block contains a concatenation of the full name, title, company, and full address.
- Tab to the Invoice # field. Enter the invoice number and press Enter, or select the lookup icon and select an invoice.
- Invoice or reference numbers are validated for the following:
- Invoice.SOURCE_SYSTEM is equal to DUES and at least one Invoice_Lines row is linked to the invoice.
- The Invoice.BT_ID is equal to the ID entered for the credit memo.
- After the invoice number is entered, select from the following options:
- Select Adjust All to select all line items to debit. The balance amount displays in the Amt Adj field and the Debit option is selected for each line item.
- Select the Debit option to debit specific line items.
- Enter an amount to debit in the line item's Amt Adj field.
Note: Adjust All is available only when the overall balance is negative.
- Click Save to update the record.
- The Total Adjustment field displays the total amount of the debit memo and line items not adjusted are no longer displayed on the window.
- After an accrual dues debit memo is applied to an invoice, the Transaction Ledger displays the detail for each amount adjusted.
Note: The CATEGORY field displays prefixed with the label Category if your administrator has enabled the Use Bill Categories option. If this option is not enabled, neither the category value nor the category label will display..
Selecting Adjust All or Debit always zeros out the balance amount. If you do not want to zero out the balance, enter the needed adjustment amount in the Amt Adj field.