Remittance Adjustment

SOLVED

I submitted a payment to the Receiver General but because I reversed two numbers when writing the check, the payment was $0.72 short of what was actually owed.  The following month I wrote the next check with the additional $0.72 to square everything with the Receiver General, but I don't know how to show this in Sage.  I tried doing a General Ledger entry, but I'm not sure which accounts should be debited and credited.  Right now my Balance Sheet shows a Liability of -.72 for CPP payable (I just stuck it somewhere).

I suspect that, knowing me, this is not correct way to have done it.  I would appreciate any insight on the matter.  Thanks!

  • 0

    Hi Cheryl,

    There is no way to adjust a past remittance, but an entry through the General Journal as of the original cheque date, will show up in the remittance window, and in the Bank Reconciliation window, so you can reverse a remittance error like this:

    Ref:  Cheque 999 remittance written for wrong amount

                    Dr          Cr

    Bank          9,999.28             (actual amount of cheque

    Bank                     10,000    (Amt that chq was recorded at)

    CPP Payable                 .72    (additional amount to pay on next chq)

     

    If you wrote the next cheque for more than the amount showing owed, there would have been an expense adjustment automatically created.  You will also have to enter a journal entry to reverse that portion of the next cheque.

    I hope that helps, please post back!

    Randy

  • 0 in reply to RandyW

    Randy,

    Payroll adjustments were added to the program in SA2012.

    From What's New 2012

    Modify Remittance Transactions with the Proper Audit Trail

    No matter where they are recorded, all transactions that affect remittances are now consistently tracked and reported in the Remittances journal and on the remittance report. The transactions in the Remittances journal can also be adjusted and any errors properly corrected.

  • 0 in reply to Richard S. Ridings
    verified answer

    Sorry, I stand corrected!

    I amend my answer to:

    - first, open the first remittance, and adjust it to match the actual amount on the first cheque

    - Then open the second remittance, and remove any 'payment adjustment' amount.

    And if you can... consider using computer cheques, we found that our bank was mis-coding about every 20th handwritten cheque, which made reconciliations extra fun.

    Also pay remittances online.  The only drawback is that it makes doing payroll remittances even less exciting.

  • 0

    HI Cheryl S.

    If any suggestions provided in this thread are able to help you resolving your issue, would you please click the 'Yes' button to the question - 'Did this answer the question?'  The thread will be marked as answered, which will benefit other users who have the same issue.  Thanks a lot.

  • 0 in reply to RandyW

    There we go!  That did the trick.  I didn't realize it would be so simple.  Thank you!

    I wish I could switch to computer checks and online remittances, but being a church, we've got restrictions on our accounts due to needing multiple signatures.  Just getting to *see* our account online was a nightmare process for me.