The Create Payable from Expense Report function in Accounting Seed allows you to consolidate approved expense reports into accounts payable vouchers.
To create Payables from Expense Reports, the following conditions must be true:
- The Expense Report status must be Approved.
- The Employee Reimburse field on the Expense Report Line must be checked.
Note: With the Hibiscus Fall 2019 release, Expense Reports have been implemented for Multi-currency users.
Create Payables from Approved Expense Reports
Expense Reports can be converted to a Payable from the Unpaid Expense Reports list view on the Expense Reports Tab. To create Payables from expenses:
- Navigate to Accounting Home and under Projects, click Expense Reports.
- Select the Unpaid Expense Reports list view.
- Select the checkbox for one or more Expense Reports to convert to a Payable.
- Click the Create Payables button.
- Review/Edit the Payable Summary screen.
- Issue Date: This will default to today’s date and will flow to the Issue Date field on the Payable. This date will determine the accounting period the Payable will be posted to.
- Due Date: This will default to today’s date plus the Company’s payment term and will flow to the Due Date field on the Payable. This date will determine the payment of the Payable will be made.
- Expense GL Account: This Account is copied from the Expense Report Line, and will flow to the GL Account on the Payable.
If Multi-currency is enabled, then
- The Currency assigned to the Payable is inherited from the Expense Report that it was created from.
- The Currency Conversion Rate used on the Payable is driven by the Issue Date on the Create Payables intermediary screen.
- This Currency Conversion Rate is pulled from the Dated Exchange Rates table. The set up is described in the Add Currencies and Exchange Rates article.
- Payables are aggregated on the Currency Dimension.
- The Ledger assigned is inherited from the Expense Report that it was created from.
- Click the Create button to create the Payable, but not post it to the Ledger. This is beneficial if there is an approval process in place for your Payables before posting to the Ledger.
- Click the Create & Post button to create and post the Payable(s) to the Ledger.
- The message below displays when the Payable is successfully created.
- Expense Reports have been implemented for Multi-currency users. Payables created from Expense Reports will inherit the Currency from the Expense Report they were created from.