BeyondERP.Newsletter
Menu

Setup step on the Default offset accounts for expenses page · Project management and accounting

Set up Default offset accounts for expenses

Use this page to give expense journal lines a default vendor, customer, ledger or bank offset account.

Used by
Project supervisor
Business process
Manage project financials
Menu item
ProjDefaultOffsetSetup
Main table
ProjDefaultOffsetSetup
Data entity
ProjProjectDefaultOffsetAccountEntity
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page where you set the offset account that is suggested on project expense lines, based on the project, category and worker.
What you do hereUse this page to give expense journal lines a default vendor, customer, ledger or bank offset account.
ExampleFor example, BEAT defaults the offset of the category TRAVEL-AIR to the airline's vendor account V-0310 for all workers, and the offset of other travel to each worker's own vendor account, so a 950.00 flight on PRJ-0042 is owed to the airline.
Default offset accounts for expenses page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processManage project financials
Menu pathProject management and accounting › Setup › Posting › Default offset accounts for expenses
Set up firstProject categories Microsoft Learn
Used next byExpense journal Microsoft Learn
Related pagesLedger posting setup Microsoft Learn
In this process Set the ledger dates and layout for Ledger updates - on-account · Set the ledger dates and layout for Ledger updates - payroll allocation
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Step by step, with screenshots

Set up Default offset accounts for expenses1 screen

Use this page to give expense journal lines a default vendor, customer, ledger or bank offset account.

  1. Screen 1

    Set a default offset account for expenses

    Go to Project management and accounting > Setup > Posting > Default offset accounts for expenses

    1. Select New
    2. Choose the worker, category or project the default applies to (leave them blank for every expense)
    3. Select the offset account type
    4. Select the offset account
    5. Select Save
    Set a default offset account for expenses (zoomed on the outlined fields)
    Show the full screenSet a default offset account for expenses
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Project management and accounting > Setup > Posting > Default offset accounts for expenses.
  2. Select New and choose the Resource, Category and Project ID the default applies to, leaving a field empty to cover all.
  3. Select the Offset account type and the Offset account.
  4. Add the more specific rows, such as one category for all workers, before the general row is relied on.
  5. Create an expense journal line for that category and check the offset account it suggests.

Source: Microsoft data model

Fields on the page

FieldWhat it meansExample
ResourceThe worker the default offset applies to, or all workers when left at the general level.Checked in Dynamics 365worker 000245
CategoryThe expense category the default offset applies to.Checked in Dynamics 365TRAVEL-AIR
Project IDThe project the default offset applies to, when it is set for one project only.Checked in Dynamics 365PRJ-0042
Offset account typeThe kind of offset account: Ledger, Customer, Vendor or Bank.Checked in Dynamics 365Vendor
Offset accountThe account that is suggested as the offset on matching expense journal lines.Checked in Dynamics 365V-0310

Common errors and fixes

MessageWhat to do
Expense journal lines get no offset account.No row matches the worker, category and project of the line. Add a row for the category or a general row. Microsoft data model

Test checklist

  1. Create a row for category TRAVEL-AIR with offset vendor V-0310.
  2. Create an expense journal line for TRAVEL-AIR on PRJ-0042.
  3. Check that the offset account is V-0310.
  4. Enter an offset account on the journal header and check it overrides the default.

Source: Microsoft data model

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Default offset accounts for expensesA row per expense category that has a fixed payee (such as the travel agency), plus a worker-level row for out-of-pocket costs that are repaid to the workerThe default offset decides who is owed for an expense line, so the right row saves manual correction and keeps vendor balances right.How should expense journal offsets default?Forgetting that an offset account on the journal header overrides these defaults for the whole journal.Test: Category default offset

Feature management and licence

Licence or add-inOn the live system, Project supervisor maintains this page.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneReversible: Rows only suggest the offset on new lines.
If you change it laterAn offset account entered on a journal header overrides these defaults for that journal. Microsoft Learn
Technical architect

6Technical

Menu itemProjDefaultOffsetSetup Checked in Dynamics 365
FormProjDefaultOffsetSetup Checked in Dynamics 365
TableProjDefaultOffsetSetupShown as “Default offset accounts” in Record infoKey field: ProjId, Resource, Resource_Name, Resource_ResourceId, Resource_ResourceCompanyId, ProjCategoryIdChecked in Dynamics 365
Data entitiesProjProjectDefaultOffsetAccountEntityProject default offset accounts for expenses Microsoft data model
Who can open itPrivilegesMaintain project journal names ProjJournalSetupMaintainView project journal names ProjJournalSetupViewDutiesEnable project accounting process ProjProjectAccountingProcessEnableInquire into project accounting reference data ProjProjectAccountingReferenceDataInqui
1 security roleProject supervisor ProjProjectSupervisor
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itProject supervisor ProjProjectSupervisorGive people one of these roles. On this system, 1 role can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=ProjDefaultOffsetSetup
Integrate withProjProjectDefaultOffsetAccountEntity data entity Microsoft data model
Data migrationProjProjectDefaultOffsetAccountEntity Project default offset accounts for expenses, loaded for each company.Load order: Load default offset accounts after projects, project categories, workers, vendors and main accounts, because each row refers to them.Load first: Projects, Project categories, Vendors, Main accountsMicrosoft Learn
Table definitionProjDefaultOffsetSetup columns and relations Microsoft data model
Everyone

8Sources

To cite this step: PM-SETUP-110, Set up Default offset accounts for expenses. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/PM-SETUP-110