Have you ever received a vendor refund and weren’t sure how to process it. We will show you how to record that vendor’s refund without leaving any open credits or open invoices related to the refund.

Steps on how to process vendor refunds in Sage BusinessWorks:

Step 1: Enter a credit memo

  • Accounts Payable > Invoices > Credit Memo.

Accounts Payable > Invoices > Credit Memo

  • Select Vendor.

Credit Memo Screen

Credit Memo - Select Vendor

  • Apply to Open Credits.

Credit Memo Screen - Check Open Credits

Note: If the credit memo is being posted to an invoice and a purchase order is associated with the invoice. You can enter the purchase order at this time. If you wish you could also add a credit reference as well.

Credit Memo Screen - PO and Credit Reference

  • Enter Data and the Amount.
  • Enter the distribution account number.

Debit Memo Screen - Date and Amount

When you’re crediting an invoice, the account number is usually the account that was debited when the original invoice was posted. When posting to open credits, and the vendor has a default posting account assigned, that account will automatically populate the field.

  • Post the credit memo.

Post Credit Memo

The credit memo will debit accounts payable and credit the general ledger account you specified.

Step 2: Enter a Debit Memo

  • Accounts Payable > Invoices > Debit Memo.

Accounts Payable > Invoices > Debit Memo

  • Select Vendor.
  • Apply to open credits.

Debit Memo Screen - Select Vendor and Open Credits

Note: Enter a purchase order number if applicable.

  • Add an optional Debit Reference.

Debit Memo Screen - PO and Debit Reference

  • Enter the Date and Amount.
  • In the account number field, you want to enter the cash General Ledger account into which the refund will be deposited.

  • You can then post the debit memo.

Post Debit Memo

The debit memo will credit the accounts payable and debit your cash account. The net effect on the general ledger is an increase in the cash account and a decrease in the general ledger account that you specified with the credit memo.

Step 3: Enter a Bank Transaction (Deposit)

Note: The bank transaction needs to be entered so there will be a reconciling item in your bank reconciliation. If you do not use the Sage BusinessWorks bank reconciliation feature you can skip this step.

  • Cash Management > Transaction > Enter Bank Transactions.

Cash Management > Transaction > Enter Bank Transactions

  • Transaction Type > Deposit.

Bank Transactions Screen > Transaction Type > Deposit

  • Select the same cash account that was used for the debit memo.

Bank Transactions Screen - Cash Account Used for Debit Memo

  • Enter the dollar amount.

Bank Transactions Screen - Dollar Amount

  • A description can be entered.

Bank Transactions Screen - Description

  • Select Date.
  • Most importantly, uncheck the “Post to G/L” checkbox since the debit memo has already posted to your cash account in the General Ledger.
  • Select Post.

Bank Transactions Screen - Date - Uncheck Post to GL - Post

  • Select “Yes” to the message that pops up.

Bank Transactions - Pop up message - Select Yes

The vendor refund is now complete.

Step 4: See how Transactions affect the vendor’s account. 

  • Accounts Payable > Reports > Detail Report.

Accounts Payable > Reports > Detail Report

  • Select the Vendor for whom the refund was processed (uncheck the include all vendor checkbox).

Detail Report - Vendor Refund

  • Select Preview.

Detail Report - Preview

  • On the preview of the detailed report, you can see that the credit and debit memos canceled each other out.

Detail Report

Step 5: See how the General Ledger was affected is your journal report.

  • General Ledger > Reports > Journal Report.

General Ledger > Reports > Journal Report

  • Include what entries you can select your specific posting date range.

Journal Report > Entries Specific Posting Date Range

  • For the journal you can select, to see only the accounts payable.

Journal Report > Accounts Payable

  • Select Preview.

Journal Report > Preview

  • You can see the posted credit memo you did; it credited the account that you specified and debited the accounts payable. Then when we posted the debit memo it debited the cash accounts and credited your accounts payable. The two accounts payable entries have washed each other out.

Journal Report

If you have questions or need assistance with your Sage BusinessWorks software at any time, please contact our BusinessWorks support team at 260.423.2414.

Register for our Sage BusinessWorks newsletter today!

Copyright 2024 DWD Technology Group | All rights reserved. This article content may not be reproduced (in whole or in part), displayed, modified or distributed without express permission from the copyright holder.

About the Author: Mary Hildinger

Mary Hildinger has been with DWD Technology Group since 1996. Mary is a Sage 100 Certified Consultant with over 29 years of experience. She has extensive experience with new software implementations (with a focus on core accounting, distribution and payroll), upgrades, training, and custom Crystal Report writing.

Recent DWD Tech Blog Posts

DWD Tech Blog Categories