Expense Journal

Use the Expense Journal page to create and edit Expense Journal Batches that are specific to expense entry and only include fields needed to enter expenses. You can also import expense entries into the Expense Journals from an Excel file. You also have the option to post manual entries to the GL using Expense Journals.

Create a new Expense Journal Batch manually

Navigate to the Role Center > Journals > Expense Journal.
Select a Time/Exp Journal Template from the ribbon, then complete the fields to create an Expense Entry Journal Batch.

Field Name	Description
Posting Date	Specifies the Posting Date you want to assign to each journal line.
Project No.	Specifies the number of the Project used for the Expense entry.
Project Task No.	Specifies the number of the related Project Task used for the Expense entry.

Caution

When formatting the Project Task No. field in Excel (in preparation for importing), you cannot use a leading zero or a trailing zero if the Task Number is formatted to two decimal places. For example, if your task number is 100.10, and you try to run the import, the file will fail to import and you will receive an error message "The field Job Task No. of table Job Journal contains a value (100.1) that cannot be found in the related table (Job Task). To resolve this, be sure to format the field as Text in Excel by placing an apostrophe at the beginning of the number (i.e., '100.80) so the leading or trailing zero is not deleted by Excel and the file can import successfully.


Location Code	Specifies the code for the Inventory Location where the Item on the Journal Line will be registered.

Note

The following two fields, Shortcut Dimension 1 and Shortcut Dimension 2 are only displayed in this position in the grid if Progressus Multi-Company is activated. For more information, see: MEM and Progressus Multi-Company Integration Documentation


Global Dimension 1	Specifies the code for Shortcut Dimension 1, which is one of two Global Dimension Codes that you set up in General Ledger Setup.
Global Dimension 2	Specifies the code for Shortcut Dimension 2, which is one of two Global Dimension Codes that you set up in General Ledger Setup.
Expense Date	Specifies the date on which the expense transaction occurred.
Document Number	Enter a document number for the journal line.
Expense Document Number	Enter an expense document number for the journal line. An example could be the Vendor's invoice number.
Expense Resource No.	Specifies the expense Resource Number that is related to the expense Vendor.
Expense Type	Specifies how the Number field is chosen and how costing, pricing, and posting fields are determined. Example: Expense or Item.
Expense Payment Type	Specifies the type of expense payment. For more information see: Expense Payment Types
No.	Specifies the value related to the expense type for the Expense Journal line. Example: Hotel, Meals, Mileage).
Description	Specifies the name of the Resource to which this entry applies. You can change the description.
Purpose	Specifies the purpose of the expense and why it is being charged.
Work Type Code	Specifies the work type modifier for Project work types with lookup available. This can be used to modify pricing in the **Price List.
Cost Type	Specifies the Cost Type to be used with this expense. Example: Overhead, Revenue, Labor. For more information see: Setting up Cost Types
Currency Code	Specifies the Project's Currency Code that listed in the Currency Code field in the Project Card. You can only create a Project Journal using this Currency Code.
Credit Card Code	Specifies the type of credit card used for the expense. For more information see: Credit Card Setup
Quantity	Specifies the number of units of the **Project Journal's No. field, which is the value related to the Expense Type that applies. If you later change the value in the No. field, the Quantity field value does not change on the journal line.
Unit of Measure Code	Specifies how each unit of the Item or Resource is measured, such as in pieces or hours. By default, the value in the base unit of measure field on the Item or Resource Card is inserted.
Unit Cost	Specifies the cost of one unit of the Item or Resource on the line.
Unit Cost Incl. Tax	Specifies the cost of one unit including tax in local currency of the Item or Resource on the line.
Total Cost	Specifies the Total Cost for the journal line. The Total Cost is calculated based on the Project Currency, which comes from the Currency Code field on the Project Card.
Total Cost Incl. Tax	Specifies the Total Cost including tax in local currency for the journal line. The Total Cost is calculated based on the Project Currency, which comes from the currency code field on the Project Card.
Credit Card Adj. LCY	Specifies the amount related to credit card adjustments in local currency.
Exp. Amt LCY	Specifies the expected amount in local currency.
Unit Price	Specifies the price of one unit of the Item or Resource. You can enter a price manually or have it entered according to the price/profit calculation field on the related card.
Tax Amount	Specifies the amount of tax for the journal line. The total tax amount is calculated based on the Project Currency, which comes from the Currency Code field on the Project Card.
Tax Difference	Specifies the tax amount difference from the base tax amount to newly entered tax amount.

Note

Edits to the Tax Amount will update the Tax Difference field but will not update Total Cost Incl Tax. The Tax Base Amount and Total Cost will be recalculated to equal (Unit cost * Quantity) - Tax Difference.


Total Price	Specifies the total price in the Project Currency on the journal line.
Chargeable	Specifies if the Expense Journal line is chargeable.
Line Discount %	Specifies the line discount percentage.
Line Discount Amount	Specifies the discount amount that is granted for the expense.
Line Amount	Specifies the amount that will be posted to the Project Ledger.
Expense Vendor No.	Specifies the vendor related to the Expense Journal line.

Note

NOTE: The following two fields Global Dimension 1, Global Dimension 2 are displayed in this position in the grid if Progressus Multi-Company is not activated. For more information, see:MEM and Progressus Multi-Company Integration Documentation


Global Dimension 1	Specifies the code for Shortcut Dimension 1, which is one of two Global Dimension Codes that you set up in General Ledger Setup.
Global Dimension 2	Specifies the code for Shortcut Dimension 2, which is one of two Global Dimension Codes that you set up in General Ledger Setup.
Profit %	Specifies the profit percentage for the Expense Journal line.
G/L Account No.	Specifies the General Ledger Account to which this entry will be posted.
Bal. Account No.	Specifies the offsetting General Ledger Account to which this entry will be posted.
Project Manager Code	Specifies the Project Manager assigned to the Project or Project Task.
Post Project Entry Only	Specifies if the line should be posted to the Project entry only.
Approved By	Specifies the user who approved the Expense Journal line.
Approved Date	Specifies the date the Expense Journal line was approved.
Attachments	Import attachments in PDF, JPEG, and other formats. To add an attachment to the line:
	1. select the No. text.
	2. The Edit Attached Documents page opens.
	3. Select the Select File link.
	4. In the Attach a Document page, select Choose to navigate to the file you wish to attach to the line
	5. Select Close to finish attaching the document to the line. The No in the line will change to Yes to indicate there is an attachment on that line.
Location Code	specifies the code for the inventory location where the Item on the journal line will be registered. Bin Code specifies the bin where the Items are picked or put away.
	IMPORTANT: Location Code and Bin Code fields are available to be added to enter an Item with a Location/Bin No. in the Expense Journal. Use personalization to make these fields visible if you wish to use these fields.

Create a new Expense Journal batch by Importing Values

Expense Integration - Setup to Import Expenses (i.e., Concur Import)

Concur imported entries may have unique Document Numbers. To post the entries to the General Ledger, it is necessary that the Batch being used is not assigned a No. Series. If the user does not need or want a unique number for each imported record, then it is not necessary to remove the No. Series.

Setup a Project Journal Batch by navigating to the Role Center > Setup > Journal Batches Setup > Project Journal Batches.
Select the Journal Template to use for the import batch.
Add a new batch for the Imports or select the batch previously created.

Important

A separate batch for the import entries is suggested. The system will default the No. Series on a new batch.
Remove the No. Series for the Import batch.
- Click Edit List, highlight the No. Series, click Delete and tab to Posting No. Series and click Delete.
The System does not change the Document No. when posting imported entries to the General Ledger.
After deleting the No. Series and Posting No. Series, the screen will look like the following (note that the No. Series value is removed for the IMPORT line):

Sample data for Concur import

Sample Expense Import Template

Project Expense Journal Entries of Sample Data

Imported Project Journal Entries

Importing a Data File

Create Import Template

Navigate to Journals > Expense Journals > Home > Create Import Template.
An Excel file is downloaded to the Downloads folder of the local machine. The export file does not create sample data but contains the Header description of each column and the correct order to format the imported data.

Import Expenses

Prepare an Excel file with one line for each transaction to import into the Expense Journal, using the appropriate values based on field descriptions: Create a new Expense Journal Batch Manually

Tip

For more information about importing data from Excel, see: Import Business Data from Other Finance Systems.
Navigate to Journals > Expense Journal
Navigate to Home > Import Expenses
In the Import Expense Journal page that opens, complete the following:

Field Name	Description
Project Task No.	Specify the value of the Project Task No. field. This value will be applied to any lines with a blank Project Task No. in the import file.
Expense Journal Template	Select the Expense Journal Template to use for the lines to be imported.
Expense Journal Batch	Specifies the value of the Expense Journal batch field for the lines to be imported.
Type	Specifies the type of import. Options are Expense or Item.
Chargeable	Specifies the value of the Chargeable field. This value will be applied to any lines with a blank Chargeable value.
Select File	Click on the ellipsis and select Choose to navigate to the file to be imported.

Select OK to begin import.
You will receive a message upon successful completion of import "Import Completed". Select OK.
You can review the imported file and when ready, select Post/Print > Post to post the batch to the Project Ledger, or Post/Print > Test Report to preview and print a report of the batch.

Tip

If Project Setup > Time and Expense Registry FastTab > Post When Approving Expenses is selected, the Expense Journal will be bypassed, and the Expenses posted to the Project Ledger.