Hi Expert!
I have issues in applying cash advance to expense report
Travel and expense manual describe the applied cash advance to expense report as following:
Cash advances are automatically applied to expense reports. The user does not
have to manually reference the cash advance on the Expense entry form. The
system automatically calculates the balance. If the cash advance is less than the
actual expense incurred, the employee is reimbursed for the balance. If, on the
other hand, the cash advance is more than the actual expense, the employee must
return the excess cash advance to the company. To return the excess amount, the
employee must add a line of the cash advance return category to an expense
report.
unfortunately, when I register an expense report, the system doesn’t credit the cash advance account as mentioned in the previous paragraph. in all cases the system debits the expense account and credit account that assigned to the method of payment and don't take in consideration that the worker already has an advanced payment.
this the steps that I did:
1- cash advance request.
Dr. cash advance account 5000
Cr. Employee account (Ledger or Vendor) 5000
2- Payment
Dr. Employee account (Ledger or vendor). 5000$
Cr. Bank 5000$
3- expense report (this is the issue)
according to the travel and expense manual the system should credit the cash advance account if the expense is less than the cash advance amount and generate the following entire
Dr. Expense Category 4000$
Cr. Cash advance account 4000$
unfortunately, the system generates the following:
Dr. Expense Category 4000$
Cr. Worker account (Ledger or Vendor) 4000$ // this account change depending on the method of payment but on my case I have one method of payment which assigned to worker account..
please advise
*This post is locked for comments