Hi AnitaSkinner
I don't think you have thought this through. How are you going to apply the payment to the invoice when it is deducted from their pay so you can then send them this statement?
You would need to have the deduction going to some kind of clearing account and then you would need to go and receive payment to the invoice and have that being deposited to that clearing account. You would then need to reconcile that clearing account to zero before sending statements so you make sure you have recorded all the deductions/repayments.
What you could do is set up a Header Account in your assets called Employee Training Loans, then set up an Employee Training Loan- John Brown etc etc etc for each employee as they get their loan. When you send them this loan the allocation account would be each person's Loan account.
Then you would make Separate Deduction categories for each employee. ie EMT repayment -J.Brown the linked payable account will be the Asset account you just set up. Okay any warning. Reporting category is not reportable.
At the end of each month, or whenever you want, go to reports>accounts>general ledger detail.filter date from and to, drop down the accounts and choose the Loan account, display. When doing this for a client I would go to the insert/modify tab and hide ID No., src, job no. & net activity, then send it to PDF and email to who was to receive it.
When I had a few to do, once i had sent the first I would stay on the screen drop down accounts again, scroll down and untick the one i had just done and tick the next person on the list, refresh and then email that.
This would save time rather than closing out of the window and choosing the next on the list and having to hide certain columns again.
