Advances & Loans Receivable is general ledger (GL) link account balance (setup, settings, payroll, link account, income, advance & loan)

Advances & Loans Paid is Sub ledger (SL) value from paycheque you post that have vacation earned (or if historical balance when you enter at history mode).

You can generate a GL report VS employee detail report compare with Advances & Loans paid column and see which does not match 

in the end , you might have to unlink advance & loan account , post a general journal of the 412.61 then re-link it, so GL match SL

(it also depends on if GL is correct or SL is correct, if GL is correct then after general journal fix to match, you have to check outstanding advance & loan see which is wrong fix it in paycheque)

Related knowledge-base article 10222

Thank you for looking into this Jason. My GL account was not linked until I discovered this issue. I now have it linked to Advances Receivable. This GL account then should be zero correct and the sub ledger should have the 412.61?

I have run the payroll sub ledger report for 2015-2017 and Advances Paid and Loans Paid are all zero for all employees.

But I did finally find the amount in the Year to date column on an employee's cheque. So this amount would have been entered before 2015 and my sub ledger report will not let me go back that far.

In order to clear this balance in the sub ledger what type of entry should I do? This employee no longer works for the company.

You would have to post a paycheque to update the sub ledger that is the only way (unless you in history mode and amount is in historical opening balance)

then you have to unlink GL link account and write it off to adjusting account (through a General journal ) then link it back , then you would have GL and SL both at zero

Thanks Jason! I had a discrepancy with my Loans & Advances from 2015, before I started doing this company's books. Both staff had long since left without paying back their loans and the amount was just being carried forward for years. I used your "fix" and it worked. Happy Friday!! Thank you.