Financial Accounts allow you to categorize expenses.
You can enter them manually or import them via csv file (see below).
Financial Account Details
The name is usually displayed whereas the code is used for export.
In order to use the account for expenses, select the field T&E Report in the Financial Account.
You can also create financial accounts with fixed amounts, where the user then enters the quantity. The primary example is Mileage. You would enter the amount per mile here and the user would just enter the quantity. Note that the Fixed Amount is usually in the Currency of the Organization.
The amount (e.g. 0.57) would apply to all users.
In the Expense Table entry, you then just enter the quantity instead of the amount:
After saving a quantity line in the Expense table, the amount is displayed. Also, if you hover over the TE Item link in the Expense table line, the amount is displayed.
Per Diem amounts are fixed amounts which you could use in the normal Expense entry. Accorto also allows to enter Per Diems directly in the Timesheet. For that, select the Per Diem Field.
User Specific Fixed Amounts
The fixed amount defined in the Financial Account applies to all users.
You can define User (Resource) specific amounts, also for different currencies, in the Resource Price.
Navigate to the Resource Record and the Resource Prices related list.
Here, add a record with the fixed amount, optionally restricting it to a specific project, account, etc.
- Cost Rate/h = Employee Expense Amount (reimbursed)
- Billing Rate = Invoiced Expense Amount
Importing Financial Accounts
You can manually enter the financial accounts or use the Salesforce
- Data Loader or
- Data Import Wizard.
An additional option is to import financial accounts from the Welcome tab in the Accountant section:
We provide an example which you can view, download, update and upload. The upload file needs to be a plain comma separated file (csv).
Here is an example import file.
Click on the Browse button and select the csv file - then click Import Accounts.