Advances & Loans

Sage 50 Canadian addition Premium Accounting How do I remove Loans YTD figure in employee record, on payroll I cannot reverse the entry as this was set up wrong in 2024 unfortunately it was set up in account 1220 and the loan was 10,000 so unfortunately whenever this person has had an advance etc it has added to the YTD amount which is incorrect, it was set up wrong back in 2024 and I need to remove the YTD amount and set the loan up correctly

Parents
  • +1
    Verified Answer

    Hi  

    Thanks for reaching out. If you are still looking for guidance on how to correct the YTD loan balance that was set up incorrectly, please let us know.

    Before performing these steps, it is highly recommended to create a complete backup of your Sage 50 data.

    To clear the YTD loan amount from the employee record, please follow these steps :

    Part I: Removing the loan from the employee record

    1. Open the Payroll Journal and select the employee.

    2. In the Check Number field, enter a unique identifier (e.g., Write-off + Date).

    3. In the Loans box, enter the amount you wish to zero out as a negative figure (e.g., -10,000.00).

    4. Ensure there are no other deductions or expenditures (Benefits, taxes, etc.) on the check.

    5. Note: The Net Pay will be a negative figure. Select Report > Display Payroll Journal Entry to verify the entry, then Post the paycheck. This successfully removes the loan from the employee's YTD.

    Part II: Adjusting the Bank Account Because posting the negative paycheck effectively puts the money "back" into your bank account in the ledger, you can perform a General Journal entry to finalize the write-off:

    1. Go to the General Journal.

    2. Credit the bank account (to offset the amount put back by the payroll entry).

    3. Debit the account where you want to record the write-off (please consult your accountant for the correct account, such as account 1220 or an expense account).

    Alternatively, you can avoid Part II by creating a non-taxable "Reimbursement" income to offset the negative loan within the payroll check, bringing the Net Pay to $0.00.

    Best regards,

    Dongwoo Chang

  • +1 in reply to dongwoo c

    Thank you so much for your help

Reply Children
No Data