How to process a refund check from a vendor of services

SUGGESTED

I know accounting pretty well and have used QuickBooks extensively.  But the below baffles me in Business Works.  We are using version 2013 SP8.

My problem is how to process a check received from a vendor as a refund.  That is, accept the cash and lower the net amount of the expense item involved.  In my current problem, an insurance company refunded part of the premium. 

In simple accounting I would just debit cash (checking account) and credit the expense item which was overpaid (and for which I now have a partial refund).

I apparently cannot just make a deposit and tell Business Works that I was the offsetting credit to be whatever expense is involved. insurance in this case.
I apparently cannot go to vendors, reduce the amount owed and use the checking account as the offset.

All of this seems complicated by the fact that reconciling bank statements had its own oddities, including the fact that just a straight journal entry to cash does not show up in the bank reconciliation process.  Thus, taking away the simple solution of making a simple general journal entry.

I have the manuals that came with the program, but they seem to be useless in looking this up, as does the help menu in the program.

In order to just make the deposit, I included the refund check as an "other" deposit item, which the program accepted.  But that has also created problems I am not sure how to correct.

If anyone knows this program well enough to help me, I would sure appreciate it.

I would like to start with how I should have processed the refund check. 

Thank you.

Robert

  • 0
    SUGGESTED

    Hi Robert,

    Carol Albaugh posted this in a blog earlier:

    Your vendor sent you a refund check and now you need to record this in your Sage BusinessWorks.

    Option 1:  When your vendor issues you a refund check after an open credit has already been posted:

    1.Post a debit memo using AP, Invoices, Debit Memos and apply it to 'Open Credits'

    2.Distribute to the general ledger cash account that the vendor's check will be deposited into (See step #3 below)

    3.Deposit the refund check using CM, Transactions, Enter Bank Transactions for the amount of the vendors check and deselect 'Post to GL'

    Option 2:  When your vendor issues you a refund check and the credit was entered as a negative invoice instead of an open credit:

    1.Post a debit memo using AP, Invoices, Debit Memos and apply to 'Invoices'.  Select the negative invoice from the lookup.

    2.Distribute to the general ledger cash account that the vendor's check will be deposited into (See step #3 below)

    3.Deposit the refund check using CM, Transactions, Enter Bank Transactions for the amount of the vendors check and deselect 'Post to GL'

    NOTE:  When the debit memo is distributed to the general ledger cash account the GL cash account will be debited and the GL accounts payable will be credited. It will also decrease the vendor's open credits.

    A tutorial is available with step by step instructions on the Sage YouTube Channel  How to process a vendor refund check

    Regards,

    Janice