Register now or log in to join your professional community.
QB does not track raise dates. You can either add it in the Notes or create a custom field and add it there. Then run a report to get the information.
Since this question is related to QB.
to track down salary advances, make sure your have added employee name in QB.
then create GL account called Employee Control a/c (Type current assets)
To pass an entry for loan/advances
Debit Employee Control a/c and choose employee name NAME
Credit Bank/Cash A/c
To reconcile, click on Reconcile icon (under Banking group) and choose Employee Control a/c
Screenshot here. http://screenshot.net/znog5fz.jpg
Create a ledger for salary advance ( Under current assets)
On payment
Dr. salary advance ledger xxx
Cr. cash/bank xxx
On recovering
Cr. salary advance xxxx
Dr. Salary expenses xxxx
Same I ll answer, you can use Different Software through which you can keep record of employees and also track their record by their name or codes whatever suitable to you. Or you can make the same in excel through VBA and excel worksheets.
Every organization there should be an adequate loan tracking system.The Advances against any future benefits should be considered as loan (fully recoverable against particular benefit) for the amount which can be settled through benefits, This is because in order to avoid risk of overpaid amount by real calculation in the real due time
you can use different software through which the employee record data is maintained and by applying formulas u can track employee salary advance. MS excel can also do this.
