Child pages
  • Reversing transactions in RetailManager


 

 

RetailManager

ANSWER ID:9376

We've provided steps below to reverse different transaction types in RetailManager.

 

To reverse a cash sale, good received, account sale or debtor payment

Reversing a cash sale

  1. Go to the Transaction menu and choose Sales.
  2. Enter your Staff number and Customer number.
  3. Enter the barcode of the product that was sold.
  4. Enter the negative quantity of the item that was sold.
  5. Apply the amount against the same payment type as that used in the original sale.
  6. Click Commit.

This transaction will add the item to your inventory and refund the cash received. You can then record the correct sale for the item.

Reversing a goods received

  1. Go to the Transactions menu and choose ReturnedGoods.
  2. Enter your Staff number and Supplier number.
  3. Enter the barcode of the product that was purchased.
  4. Select the GoodsReceived that you want to reverse in the Invoice field.
  5. Enter the quantity you want to return.
  6. Click Commit.

This transaction will reduce your inventory quantity for that item by the amount you have entered. If you use the Accounting Export utility in RetailManager, a 'Returned Goods' will be converted to a 'Settle Returns and Debits' amount when imported into your MYOB Accounting software. You can then apply this amount against another purchase or receive a refund.

Reversing an account sale

  1. Go to the Transaction menu and choose Sales.
  2. Enter your Staff number and Customer number.
  3. Enter the barcode of the product that was sold.
  4. Enter the negative quantity of the item that was sold.
  5. Apply the amount against the Account payment type.
  6. Click Commit

Reversing a Debtor Payment

  1. Go to the Admin menu and choose Reverse Debtor Payments.
  2. Enter your Staff number and Customer number. The customer's payments will appear.
  3. Select the debtor payment you want to reverse and enter a Comment for the reversal.
  4. Click Commit
To reverse a gift voucher, credit note or deposit

There are two ways to cancel a gift voucher, credit note or deposit.

In the below examples, we will be reversing a gift voucher. The same steps can be used to reverse a credit note or deposit. 

The first way is to cancel the gift voucher and reimburse the customer with cash/eftpost etc.

  1. Go to the Transactions menu and choose Sales.
  2. Enter your Staff number and Customer number.
  3. Skip the Code field and tab down to the Payment Details section.
  4. Choose the method of payment originally used to create the Gift Voucher, and enter in a negative amount in the Paying field, in other words -$100, then click Add.
  5. Choose the Gift Voucher payment type. $100 should automatically appear in the Paying field. Click Add.
  6. A window will appear asking you to select the outstanding Gift Vouchers. Select the appropriate gift voucher and click Commit. See our example below.
    Image
  7. A message will appear asking you if you want to commit the transaction. Click Yes or press Enter.

If you use the Accounting Export feature to link RetailManager to MYOB AccountRight or AccountEdge, the relevant journal entries will be created to reverse the transaction.

The second way is to cancel the gift voucher and retain the money that was originally paid. This situation may arise where the customer has not returned to redeem their gift voucher for a given amount of time and the business has decided to retain their money.

  1. Go to the Setup menu and choose Options then click Payment Type.
  2. Create a new payment type called XL Gift Voucher (Cancelled Gift Voucher). For further information on creating payment types, please refer to your RetailManager user guide.
  3. If you use the Accounting Export, go to the Setup menu and choose Options then click Accounting. Click the Banking Export tab. Create an Export Group to link XL Gift Voucher payment type to a miscellaneous income account. For further information on creating Banking Export Groups, please refer to your RetailManager user guide. Note: If you do not have a miscellaneous income account set up in your accounting software, we recommend consulting your accountant or book keeper before creating this account.
  4. Go to the Transactions menu and choose Sales.
  5. Enter your Staff number and Customer number.
  6. Skip the Code field and tab down to the Payment Details section.
  7. Choose the XL Gift Voucher payment type and enter in a negative amount in the Paying field, in other words -$100.
  8. Click Add.
  9. Choose the Gift Voucher payment type. $100 should automatically appear in the Paying field.
  10. Click Add. A window will appear asking you to select the outstanding Gift Vouchers.
  11. Select the appropriate gift voucher and click Commit. See our example below.
    Image
  12. A message will appear asking you if you want to commit the transaction. Click Yes or press Enter.
  13. If you use the Accounting Export feature to link RetailManager to MYOB Accounting, Accounting Plus, Premier, AccountEdge, or AccountRight, the relevant journal entries will be created to reverse the transaction.

By following the above steps, the Gift Voucher will be cancelled and the appropriate adjustment will be sent via the accounting export to all the relevant accounts in your MYOB accounting software.

The amount of the Credit Note has been debited from the Credit Notes Liability account and credited to the Miscellaneous Income account.

To reverse a lay-by and keeping the deposit amount

Before refunding a lay-by transaction and retaining the deposit, you first need to ensure that a specific payment type has been created with which to allocate the amount of the deposit. To do this, follow the below steps:

  1. Go to the Setup menu and choose Options then click Payment Type.
  2. Click Create.
  3. Enter an appropriate name for this payment type, such as Deposits Kept.
  4. Click OK.
  5. Click Apply.

If you are using the Accounting Export feature of RetailManager, you also need to create a Banking Group for this new payment type to be exported to. For instructions on setting up a banking export group, please see your RetailManager user guide. This export group should be set up to export to a holding account in your accounting software.

Once RetailManager has been properly configured, you can refund the lay-by. This is done as follows:

  1. Go to the Transaction menu and choose Lay-by Payments.
  2. Enter your Staff number and Customer number.
  3. Select the correct lay-by from the list of available Lay-bys.
  4. Once the lay-by appears on the screen, click Refund. The Lay-by Refund window is displayed.
  5. Select your newly created Deposits Kept payment type from the list of available Payment types. The amount already paid for the lay-by will appear in the Paying field. This is the amount you will be retaining.
  6. Click Add to commit the refund.

Once you have cashed up the session and performed the Accounting Export, the amount entered in the Paying field above will appear in your holding account mentioned previously. You can make a journal entry in your accounting program to transfer this amount to an income account.

Any money kept that was paid as a deposit may need to be tracked as income in your accounting package. Please consultant your Accountant for further details.

  FAQs


I reversed an account sale, now I have a positive and negative invoice in my Debtor Payments window. How should I remove them?

If you reverse an account sale, and now you have a positive and negative invoice in your Debtor Payments window, you can remove them by paying the total positive amount off the original sale.

To do this, complete the following steps:

  1. Go to the Transaction menu and choose Debtors Payments.
  2. Enter the Staff number and Customer number. The customer's outstanding invoices will appear.
  3. One invoice is for the original sale and the other is for the reversal. Pay the total positive amount off the original sale and the total negative amount off the reversal of the sale. The box next to the Commit button will turn green.
  4. Click Commit. See our example below.
    Image 

If the Numeric Value Expected message is displayed when you click Commit, you'll need to change your Windows currency settings.

  1. Click the Windows Start button and choose Settings then choose Control Panel.
  2. Double-click Regional Settings.
  3. Click Currency.
  4. Make sure that the Negative Number Format is set to "-1".
  5. Click OK.
 
Related topics