AR Credits and Refunds in Sage Intacct

Keywords: Refunds, Bills, Account Receivable , Sage

Credit:–  Sage Photo By: FP

Struggling to Keep Your Books in Order? 📊📅

Let us handle the numbers while you focus on growing your business! Get expert bookkeeping support tailored to your needs.

👉 Click Here for a Free Consultation!

It is better accounting practice to make an adjustment than to edit an invoice, so there’s an audit trail of the history. Use adjustments in the event that there’s a balance due you or the customer after an invoice is paid. For example, if the customer received damaged goods, you can make an appropriate adjustment to show the difference that you owe the customer. When the customer applies the adjustment to a future payment, the balance will then be zero. When you create an adjustment in Accounts Receivable, you specify the adjustment type. You can choose either a debit memo or credit memo. Debit memos increase the amount that a customer owes you, while credit memos decrease the amount.

In multi-entity, multi-currency companies

If your company is a multi-entity, multi-currency company, you can make adjustments at the top level or entity level.

  • Top level: When creating a top-level adjustment, you must select the base currency and location.
  • Entity level: When making adjustments at the entity level, Intacct already knows the location and base currency.
  • Foreign currency: Whether working at the entity level or top level, you must select a transaction currency when entering a foreign currency adjustment.

Debit memo adjustments

A debit memo adjustment increases the amount that a customer owes you. After you post the adjustment, the debit is batched in a summary and shows on the customer’s statement. You can then select the customer’s debit memo on the Receive Payments page as a transaction to be paid.

Credit memo adjustments

A credit memo adjustment decreases the amount that a customer owes you. When you create a credit memo adjustment, it appears on the Receive Payments page as a customer credit. You can then apply it to an invoice on the Receive Payments page.

Create an AR adjustment

Enter basic information about the adjustment

  • Go to Accounts Receivable > All > Payments, and select
  • Add
  • next to Adjustments.
  • In Date, leave the current date or select a different date for the adjustment. Any date entered here is automatically populated to GL posting date (and to Exchange rate date, if you’re a multi-currency company). You can change either date as needed, for example, if you want to create the adjustment today, but post it on a different date.
  • Select an existing Customer or add a new customer, as required. The Bill-to and Ship-to fields automatically populate based on the customer record.
  • Enter an Adjustment number that can be used to track the adjustment.
    If you’ve assigned document sequencing in Configure Accounts Receivable, you can let Intacct assign an adjustment number; just leave the autofill text “—New—”.
  • Select Type, and then select the type of adjustment you’re creating:
  • Debit memo: Increases the overall amount that the customer owes you. For instance, if you forgot to charge the customer for shipping or some other service, you can create an adjustment rather than a whole new invoice.
  • Credit memo: decreases the overall amount that the customer owes you. For instance, If a customer makes a return, you create a credit memo for that customer to decrease the amount the customer owes you.
  • To store a digital version of a supporting document, in the dropdown next to Attachment select an attachment, or select Add. Then upload your attachment.
    You can drag and drop your files to add an attachment. To attach a document to multiple journal entries, see Bulk processing.
  • If required, select a Summary to group the adjustment.

What’s a summary?

  • Summaries are collections of the same type of transactions, grouped together for processing. The advantage of using a summary is that the transaction group posts to the GL as one line. From that one line, as needed, you can drill down to any of the individual transactions.
    You can have Sage Intacct create, post, and close summaries automatically at a frequency that you specify by selecting a time interval. Or, you can create, post, and close summaries yourself.
    When you first create a summary, it’s open, and you can enter transactions. After you close a summary, you can’t post transactions to it, which prevents posting transactions to the wrong period. To add or delete transactions from a closed summary, reopen it.
    In multi-entity, multi-currency companies
  • If your company is a multi-entity, multi-currency company, you can make adjustments at the top level or entity level.
  • Top level: When creating a top-level adjustment, you must select the base currency and location.
  • Entity level: When making adjustments at the entity level, Intacct already knows the location and base currency.
  • Foreign currency: Whether working at the entity level or top level, you must select a transaction currency when entering a foreign currency adjustment.
  • In Transaction currency, select the dropdown to select the currency being used.
    If the currency is not your company’s base currency, continue with the next two steps.
  • Select Exchange rate type, and then select an exchange rate type, such as Intacct daily rate.
    (Intacct daily rate is the system-supplied default exchange rate type, unless you’ve defined a different one.)
    If you know what the exchange rate for this transaction is or have contracted with the customer on a set exchange rate, you can enter it in Exchange rate to override system calculations.
  • Type or select a date in Exchange rate date. The default value is the current date, but you can override this. For example, you might want to change it to the date the transaction was issued or the date you intend to pay the transaction. (If you override the Date, the exchange rate date updates automatically.)

Select default information for all line items (optional)

In the Entries section, you can add values directly to each line item, or select Show defaults to define default values to autofill each line item. To set up a value as a default for each existing and new line item, select the dropdown beside the appropriate field and choose a value. You can override any default value on any line item. For example, you can set dimension values for tracking and reporting purposes. After you select the GL account in the Items area, any dimension value that you set as a default is automatically reflected for each line item. In addition, Intacct enables you to define new dimensions to suit your needs. Use these user-defined dimensions to organize and sort categories of data unique to your business. For example, if you’re a software company with multiple product lines, you can create a user-defined dimension called Line of business. Then add the values Direct customers, Channel partner, and OEM.

Dimensions enable you to collect, sort, analyze, and report on data within one category, or between categories, so you can identify key factors such as:

  • Your most profitable or most costly items or customers
  • The return on investment of a project or department
  • Whether and to what degree a new product or product line is successful
  • Which way a particular aspect of your business is trending
  • Intacct dimensions give you fine control over data definition and data hierarchy

With dimensions, you can customize financial reports around specific business activities, get greater visibility into how the business is doing, and make faster, more meaningful business decisions. Think of dimensions as a more powerful alternative to subaccounts. Additional fees can apply for the Project dimension and user-defined dimensions. Contact your account representative for more information.

Remember to select Apply defaults to save your selections.

Enter line items

For the adjustment to be posted, specify at least the account and an amount for each line item. Depending on your company, you might be required to enter other information, such as the department or location. Also, depending on how your company is set up, you can drill down to the detail level in line items to enter additional information.

Enter line item information for each line item in this adjustment:

  • Under Account (or Account label if you have enabled account labels), select the account picklist, then select an account to receive the adjustment.
  • In Amount, type the item amount of the item.
    For companies using multiple currencies, enter the Transaction amount, which is the amount in the transaction currency. Intacct then calculates the Base amount in your company’s base currency according to the exchange rate listed in the header.
    This is a required field. While Intacct allows and totals negative line item entries here, the adjustment’s total is based on whether you select a credit (negative) or debit (positive) memo type. It’s calculated accordingly when you save the adjustment.
  • Enter a Memo for line items that might require explanations at some future date
  • If you use departments or locations and are assigning the expense to them, select the Department or Location.
    The Location is a required dimension If your company is multi-entity and you create the adjustment at the top level. The adjustment is restricted to the entity of the tagged location.
  • If you use additional dimensions, such as customer, employee, or item, and are assigning the adjustment to them, select additional dimensions for the adjustment.
  • When you finish entering the transaction information, save it as a d to save your progress on the transaction, without posting it. Later, you or another user can review and post it.
  • Select Post or Post and new to post the transaction.

Save an adjustment as a draft

Not ready to post that bill, invoice or adjustment? You can save it as a draft without affecting the GL or any subledger. With the ability to save these types of transactions in draft state, you can save your progress. Later on, you or another user can come back and post the transaction. The system validates transactions only when they are posted. For example, required departments or locations are not validated until posting.

Prerequisites: Your ability to add a transaction in draft state or post a transaction depends on your permissions:

  • Add permission enables you to add, edit, delete, and save a transaction as a draft.
  • Add, Edit, and Post permissions enable you to add, edit, delete, and save a transaction as draft, as well as edit and post the transaction when you’re ready.

To save a transaction in draft format:

  • Add a bill, invoice, or adjustment to your company.
  • Save the transaction as a draft by selecting Draft and new or selecting Draft, or Draft and continue from the button dropdown. The system saves the entry, but doesn’t post it.

To find and view items in the draft and posted state

  • Filter for draft or posted transactions on the fly: In the appropriate transaction list view, select either Draft or Posted in the State column.
  • Create a permanent custom view that filters for draft or posted transactions: Create a view, and set the filter to State = Draft or State = Posted. The custom view is available for use whenever you go to the list.

Add similar adjustments quickly

  • Go to Accounts Receivable > All > Payments > Adjustments.
  • Select Edit next to the existing adjustment, and then select Duplicate.
    Intacct displays a new adjustment with fields filled in based on the source adjustment.
  • Edit the adjustment as required.

To change the GL account, or other information, such as dimension selections, select Reclassify. (You see this button only if your company has enabled reclassification, you have permission to reclassify the transaction, and the adjustment has been partially or fully paid.)

Enter a credit that requires a project invoicing adjustment

If you’re using project accounting, creating a credit memo does not allow you to flag a project for the adjustment. To decrease the overall debt owed by this customer and flag the associated project, create an invoice with a negative transaction instead of a credit memo.

View and print an adjustment

You can view and print adjustment details from the AR Adjustment page. For quick viewing and editing, the most important information appears at the top of the page, adding visibility to important elements, such as adjustment date, adjustment total, amount paid, and amount still available.

View an adjustment

  • Go to Accounts Receivable > All > Payments > Adjustments.
  • Find the adjustment that you want to view.
  • Select View next to the adjustment to open the detail view.

Print a transaction

After creating a transaction, printing a copy of it is just a click away. You can print from the transaction page itself, such as from the Bills or Invoices page, or from the transaction list page, whichever is more convenient.

  • Transaction list page: Find the transaction that you want to print and select Print at the far right.
  • Transaction page: Select Print at the top of the page.

The system generates a PDF of the transaction, which you can view, print, or save to add as an email attachment as needed. When you print an adjustment, the description/memo line comes from the Memo field for each line item in the adjustment.

Example of a printed adjustment

Here is an example of a printed adjustment.

After you apply a credit adjustment to an invoice, it is updated to show that the amount due is reduced by the amount of the credit. However, if you send the customer an updated invoice, it does not show why the amount due was reduced. You can send the customer an AR statement to show which adjustments were applied to which invoices. Learn more about printing or emailing AR statements.

Edit an adjustment

If you entered the credit amount incorrectly, you can edit the credit memo if the following conditions are met:

  • You have not applied the decrease to any invoices.
  • You have not closed the books.

After a credit memo is applied or the books are closed, you cannot edit the credit memo. If you discover an error after you apply a credit memo or close the books, create a new debit or credit memo to adjust the decrease as needed.

  • Go to Accounts Receivable > All > Payments > Adjustments.
  • On the list, find the adjustment you want, and select Edit.
  • Add, modify, or delete information as needed.
    For details, go to field descriptions.
  • Select Post to save your changes.

Editing a date in a bill, invoice, or adjustment associated with a project requires you to:

  • Edit the transaction to remove the project, then post it.
  • Edit the transaction to change the date, then post it.
  • Edit the transaction to add the project back in, then post it.

Reclassify an adjustment—Accounts Receivable

To update an adjustment that is in a Selected, Partially paid, or Paid state, you need to reclassify the transaction. Only authorized users can reclassify a transaction and the option to reclassify must be enabled for your company. Only some fields can be edited when you reclassify a transaction. For example, you can change the account and location dimension for a line item, but you cannot change the amount or add and remove line items.

  • Go to Accounts Receivable > All > Payments > Adjustments.
  • Find the adjustment that you want to reclassify.
  • Select Edit.
  • Select Reclassify.
  • If you do not see the option to Reclassify
  • If you do not see the Reclassify button, it is usually for one of the following reasons:
  • You do not have reclassification enabled in the application configuration.
  • You have not been granted the appropriate permissions to reclassify this transaction type.
  • The transaction is unpaid and you need to edit it instead.
  • The transaction state is Reversed or Reversal and cannot be reclassified.
  • You are trying to reclassify a transaction type that does not support reclassification.
  • Make your changes.

What information can I reclassify?

  • Account number
  • Line item dimensions, such as Location or Department
  • Reference invoice number, Description, Attachments, and Memo fields
  • Custom fields
  • Select Post.

Apply an AR credit to an invoice

After you enter credits to decrease the amount of money a customer owes, you can apply that credit to an invoice or multiple invoices. After you apply credit, you can view the posting details from the adjustment record. Go to the adjustment record and select View details in the summary header. In a multi-entity company, Sage Intacct applies credit to the owning entity first, and then applies credit from the oldest to the newest invoices. If you enable your company to limit credits to the owning entity, then credits are applied to the invoices of the owning entity and no other. Any remaining credit is reserved for other invoices owned by that entity.

You can apply credits to invoices for the same customer. However, you cannot apply credits from one customer to the invoices of another customer, even if they are in a parent-child relationship.

  • Go to Accounts Receivable > All > Invoices, and then select
  • Add
  • next to Receive payments – New!.
  • To receive a payment in addition to applying credits, enter the Payment amount.
  • To apply credits without recording a payment receipt, verify that the Payment amount is 0.00.
  • Select the customer and select Show invoices.
  • Select the invoices or memos that you want to apply credit to.
  • Select Add and close.
  • Do one of the following:
  • View available credits: Select the Credits available amount to view the list of available credits. Any credit you select from here is applied in full.
  • Apply credit to an invoice: Enter the credit amount in the Credits to apply column of the Receive payment page.
  • Apply credit by line item: Select Line details to drill down to the line items of a specific invoice and apply credits by line item.
  • Apply credit to multiple invoices: Select invoices and select Apply credits on the Receive payments page to apply credits in bulk across multiple invoices or memos.
  • Select Post.
    After you apply credit, you can view the posting details from the adjustment record. Go to the adjustment record and select View details in the summary header.

After you apply a credit adjustment to an invoice, it is updated to show that the amount due is reduced by the amount of the credit. However, if you send the customer an updated invoice, it does not show why the amount due was reduced. You can send the customer an AR statement to show which adjustments were applied to which invoices.

Change the amount credited after applying it

You can’t change the credited amount after you apply and save it. You can reverse the credit under the following conditions:

  • If you recorded a payment and applied for an AR credit, you can reverse the payment. The credit is also reversed and available again.
  • If you simply applied for an AR credit, you can apply for the credit from the Posted Payments list. After you apply for credit, it is available again.
  • If the credit came from an Order Entry transaction, you can’t reverse it. To resolve this issue, create a new transaction (a debit memo from AR, a sales debit memo, or even an invoice, depending on what’s affected). For example, inventory or quantities require a sales debit memo.

Import customer payments and applied credits

Import large batches of customer payments into Intacct, which is faster than inputting each payment manually. You can import Accounts Receivable payments and applied credits by uploading a CSV file.

Prepare a CSV file for import

When you download a template from the Company Setup Checklist or an object list page, the correct headers are in the template already. All you have to do is fill in the columns with your data, save it as a CSV file, and upload the file. The header titles in the template you download correlate to fields in Intacct. Incorrect header titles will cause an upload error. For more information about the CSV upload process, including best practices, common errors, and how to upload your CSV file, see Prepare your CSV file for import.

Download a new blank template whenever you import information into Sage Intacct. Using a new template is important because:

  • Templates are automatically customized based on your company configuration, including any dimensions and custom fields you created.
  • Templates can be updated by Intacct at any time, especially when a new version of Intacct is released. When templates are updated, an older template might not work.

About importing payments

There are several things to consider when you import customer payments into Intacct:

  • Imported payments post directly to the General Ledger based on the bank account, undeposited funds account, or payment summary that you specify.
  • Make sure that the amount received equals the amount to apply.
  • If there’s an overpayment balance after the payment amount is applied to the invoice or adjustment, the overpayment amount and overpayment location are required fields. Amount received = Payment amount to apply + Overpayment balance.
  • Verify import data before you upload to Intacct. Bulk reversal is unavailable. If you must delete customer payments that have already been imported, ask your designated support user to contact Support. For more information about contacting support, see The Sage Intacct Community.
  • Maximum of 1,000 invoices for a payment and 5,000 lines per file.
  • You can import payments for unique invoice number or adjustment number transactions only. If there are multiple invoices or adjustments with the same reference number, the import will be unsuccessful.

Best practice: Upload a single payment first to test your import data. That way, you can make data corrections as needed before importing multiple payments.

Supported payments

Use the following table to see which payment use cases are supported. Exceptions are not supported for import at this time.

How to format payments for import

Use row numbers

When importing bills or invoices, if errors are found during upload, the entire CSV file is rejected. You can more easily find the errors in the file if you use row numbers in the Do Not Import column (1). If your CSV file is rejected because errors are found, the error file contains the original row number, allowing you to quickly pinpoint where to make changes (2).

How to format an inline credit.

How to format a payment with an inline credit.

How to format an adjustment credit.

How to format a payment with an adjustment credit.

How to format a negative invoice credit.

How to format a payment with a negative invoice credit.

How to import payments and applied credits

  • Go to Accounts Receivable > All > Receive payments: New!.
  • Select Import.
  • In the window that appears, select the Download template.
    Populate the template with payment data and save it as a CSV file.
  • Return to the import window and select Choose file.
    Select the saved payment import file in the file explorer that appears.
  • Select a Date format that matches the date format in the file.
  • Select a File encoding option and Process offline.

Best practice: When importing payments in bulk, select Process offline to make sure that the import is successful regardless of how much data is imported for processing.

  • Enter an email address for results.
  • Select Import.

Results: You receive an email after the import is complete. If there are any errors, they appear in the email that you receive.

Delete an adjustment

You can delete a credit memo if it has not yet been applied to an invoice.

  • Go to Accounts Receivable > All > Payments > Adjustments.
  • Select the Delete checkbox on the right side of the appropriate credit memo, and select Delete.
    If you see a Reverse link instead, the credit memo has been applied to one or more invoices and can only be reversed.
  • Confirm that you want to delete the credit memo.

The credit memo is removed from the list and from the system. No record of it remains.

Reverse or Unapply an AR adjustment

You cannot delete a credit memo if you’ve applied any of the available adjustments to one or more invoices. However, you can reverse or apply it to clear the adjustment as follows:

  • If you’ve applied no payment on the adjustment against the customer, such as a check or ACH, you can simply reverse the credit memo.
  • If you’ve applied a payment on the adjustment, you can apply or reverse the credit payment from the Posted Payments list.

Reverse a credit memo that has no associated customer payment

  • Go to Accounts Receivable > All > Payments > Adjustments.
  • Find the transaction that you want to reverse.
  • Select Reverse on the right side of the row.
    The Transaction Reversal Date page appears.
    If you see a Delete link instead of Reverse, the credit memo hasn’t been applied to one or more invoices, and you can delete it. The credit memo is cleared from Intacct.
  • Select the date for reversing the transaction.
    This date is usually the original transaction date or a later date.
  • Optionally, if you want to reverse one or more invoices associated with the adjustment at the same time, select the checkbox for each invoice under Reverse.
    The option to reverse associated invoices is not always available when you are reversing the adjustment.
  • Select Submit.
    The credit memo is cleared from Intacct. If you also reversed related invoices, those transactions are also cleared from Intacct. The AR Adjustments list and the invoices list display a reversal on two rows. The two rows show the original transaction and a negative balancing that brings the net amount to zero.

Unapply or reverse a credit memo that has an associated customer payment

If you’ve recorded a customer payment associated with a credit memo, you can unapply or reverse the payment in a couple of ways. You can reverse or unapply the payment from the Posted Payments page or reverse it from the Receipts Register.

Unapply or reverse a credit payment from the Posted Payments list

When only credits were applied to an invoice with no other payment method, you’ll unapply the credits from the invoice. If another payment method was also used to pay the invoice, reverse the payment. In either case, the adjustment becomes available for use again.

  • Go to Accounts Receivable > All > Payments > Posted payments.
  • Find the credit payment and select Unapply or Reverse.
    The Transaction Reversal Date page appears with a default of today’s date, which you can change as needed.
  • Enter a Transaction reversal date and the amount to unapply from the invoice.
  • To unapply the payment, select Submit.
    The invoice goes back to Receive payments and the credit becomes available again for future use.

If your company uses Cash books, a reversal entry posts to the GL to negate the payment.

Reverse a payment from Receipts Register

  • Go to Accounts Receivable > All > Reports > Registers > Receipts.
  • In the Receipts Register, enter or select the Customer, and then select View to see the list of payments made.
  • Select Reverse beside the payment associated with the customer credit.
    The Transaction Reversal Date page appears with a default of today’s date.
  • To reverse the entry in the register, select Submit.
    The payment is cleared from Intacct. The Register payments list displays the reversal on two rows to show the balancing transactions for removing the payment from Intacct.
  • Now that there’s no associated payment, you can reverse the credit memo.

How do I refund a credit memo?

If a customer has a credit and prefers to have the money refunded instead of applying the credit to another invoice, see refund a customer.

Refund a customer

The process to issue a refund to a customer depends on whether you are refunding a credit on a customer account or refunding a paid invoice.

Scenarios where you might need to issue a refund include:

  • A customer has a negative balance as the result of overpaying an invoice
  • A customer returned goods that they received and paid for
  • A customer received a credit that was never used

If you do not plan to create another invoice for the customer, or the customer would like their money back, you can issue a refund. Issuing a refund requires coordination with Accounts Payable.

  • Create an adjustment (debit memo) that adjusts the customer balance to zero.
  • Go to the Receive payments page (Accounts Receivable > All > Invoices and select
  • Add (circle)
  • next to Receive payments-New!) and apply the adjustment against the customer transaction.
    Unless you apply the debit memo, open transactions and the adjustment will continue to display on your aging report.
  • In Accounts Payable, create the customer as a one-time vendor.
    Learn more about creating vendors.
  • Refund the money owed to the customer by creating a bill.
  • Designate the new vendor as the payee.
  • As a line item, designate the same account used in the original credit or payment that you are refunding.
  • Pay the bill.

Check out our Free Additional Articles