Overview
A common issue in NetSuite occurs when employee expense reports remain open in the Accounts Payable (A/P) Register even after:
- The expense has been billed to a customer
- The customer invoice has been paid
- The employee has already been reimbursed through payroll
This behavior is expected when expense reports are reimbursed outside of NetSuite’s standard expense payment workflow.
This admin tip explains why it happens and how administrators can properly clear the open balances.
Common Scenario
Employees submit expense reports for items such as:
- Mileage reimbursement
- Per diem
- Airfare
- Hotels
- Printing expenses
These expenses are:
- Charged back to customers through project invoicing
- Reimbursed to employees manually through payroll
However, the expense reports continue to appear as Open in the A/P Register.
Why the Expense Report Remains Open
Expense reports in NetSuite create an employee liability in Accounts Payable.
When an expense report is submitted, NetSuite posts:
- Debit→ Expense Account
- Credit→ Accounts Payable (A/P)
This means the company still owes the employee reimbursement.
The expected next step is to use Make Payment on the expense report, which posts:
- Debit→ Accounts Payable
- Credit→ Bank Account
This clears the liability and closes the expense report.
Why Customer Invoices Do Not Clear Expense Reports
Even if the expense is billed to a customer and the invoice is fully paid, the expense report remains open because customer invoices affect:
- Revenue accounts
- Accounts Receivable (A/R)
They do not impact the Accounts Payable liability created by the employee expense report.
Root Cause
In this scenario, reimbursements are manually included in payroll instead of using NetSuite’s expense payment process.
Because the expense report itself is never paid through NetSuite:
- The A/P liability remains open
- The expense report status remains open in the A/P Register
Recommendation
Clear Existing Open Expense Reports
To properly close the expense reports:
- Open each outstanding expense report
- Use the Make Payment function
- Process the payment to clear the A/P liability
This will:
- Debit A/P
- Credit the selected bank account
- Mark the expense report as paid
Additional Accounting Adjustment
Since employees were already reimbursed through payroll:
- No actual bank payment may occur from Accounts Payable
- A journal entry may be required to offset the bank impact
Administrators should work with the accounting team to:
- Reverse the temporary bank impact
- Reclassify the amount to the appropriate payroll or salary GL account
Important Reminder
If expense reports are not formally paid in NetSuite:
- A/P balances may remain overstated
- Expense reports will continue showing as open
- Duplicate reimbursement impacts may occur between payroll and expenses
Best Practice for NetSuite Administrators
To avoid ongoing reconciliation issues:
- Establish a standardized employee reimbursement workflow
- Use NetSuite expense payments whenever possible
- Coordinate payroll reimbursements with accounting procedures
- Avoid manual reimbursement workarounds unless supported by proper journal entries
Following a consistent process helps maintain:
- Accurate A/P balances
- Cleaner reconciliations
- Proper expense tracking
- Reduced manual corrections
Your thoughts matter to us! Feel free to drop any insights or experiences in the comments or initiate a conversation in the NetSuite Admin Corner. Together, we can keep learning and growing!