Issue: Processing Credit Card Refunds in Sage Accpac

Posted by EQ Tech on Thu, Dec 17, 2009

Issue:
Accpac Accounts Receivable does not allow negative cash receipts so if your credit card deposit for the day included a customer refund (a negative cash amount), your Receipt batch will not balance to the tape from your credit card machine or online virtual terminal.

Solution:

There are 2 ways to handle the entry for a credit card refund:

Method 1:

Refund when the entire amount is credited: 

  • Process the refund as a Returned Check in Bank Services.
  • This will credit your bank account and debit the A/R customer account, reactivating the invoice for payment.
  • Process a credit note for the merchandise returned in Order Entry (you can process the credit note first, then process the returned check). The drawback in this method is that the system would track this statistically as a returned check, not a refund, and the amount will appear on the returned deposit tab of your bank reconciliation. However, the transactions would be recorded to the proper GL accounts.

Note: This method can only be used provided that the refund was for the exact amount of the original charge.

A partial credit card refund (not the entire invoice balance):

  • Process the refund as an adjustment in AR and Bank Services. This method uses the suspense account as a clearing account to manage the proper GL transactions. It does not record the refund (statistically) as a returned check, nor does it note in any statistical way that the customer received a refund, however, the customer transaction history would show that the adjustment for the refund had occurred.
  • Process a credit note for the merchandise returned in Order Entry (process the credit note first, then process the adjustment).

Note: You must use this method if the refund is not the exact amount of the original charge.

Refund Method 2:
  • If using ACCPAC Order Entry, Process the credit note in Order Entry.
  • Run Day End Processing before you proceed with the remaining steps.
  • Post any resulting AR batches (invoices and receipts if applicable). 
  • In AR, open a new Adjustment batch, giving it an appropriate description in the header (i.e. credit card refunds).
  • In the detail screen, after typing an entry description, choose the adjustment date to be the same as the date of the refund, then enter your customer number.
  • Enter a reference and description that is meaningful.
  • Use the Finder in the Document Number field to choose the credit note that the refund applies to.
  • Leave the Payment Number field as is.
  • Leave the "Dist Code" blank unless you have setup a AR distribution code called REFUND which is coded to a GL suspense account.
  • Enter the GL account number for your Suspense account.
  • The amount is entered as a credit amount, increasing accounts receivable.
  • Save the entry (if you have more than 1 refund, you can enter the next in this batch).
  • After all entries are finished, print the batch listing and verify that all is correct.
  • Post the batch.
  • Print the posting journal.
This entry should debit accounts receivable and credit the suspense account.
  • One time setup:
    • Go to Common Services, Bank Services, Setup, Transaction Types
    • Enter a new transaction type called REFUND.
    • Code it to GL account Suspense.
    • Add
    • Close
  • Under Bank Reconciliation choose Post Entries.
  • Choose the bank the refund was processed through.
  • Use the REFUND Transaction code or a GL account if you skipped the one time setup step.
  • Make sure your entries date matches the adjustment date.
  • The entry will be entered in the credit column (to credit the bank account).
  • Select Post to update the entry in the bank module and the General Ledger.
This entry will debit the Suspense Account and credit the bank account.

Topics: Sage 300 (ACCPAC)

Submit a Comment

Need Help Now?

Request a Call