
If your Dynamics 365 Business Central profit and loss statement looks wrong, or your trial balance simply will not tally, there is a very good chance that three specific general ledger accounts are either missing from your financial reports or incorrectly configured in your General Posting Setup. These accounts are the Direct Cost Applied account, the COGS account, and the Inventory Adjustment account. Without them, your financials are incomplete by design.
Unlike simpler accounting systems where purchases hit the P&L immediately as expenses, Business Central uses perpetual inventory accounting. This means every purchase and every sale updates both your general ledger and your item ledger in real time. To make this work accurately, BC relies on these three accounts as bridge accounts, ensuring costs are recognised at exactly the right moment, and that every debit has a matching credit.
This guide explains what each account does, shows the journal entries behind them, highlights the common mistakes that result from getting them wrong, and tells you exactly where to configure them in Microsoft Dynamics 365 Business Central.
Account 1: The Direct Cost Applied account and the matching principle
When you post a purchase invoice in Business Central, the system creates four G/L entries, not the two that most accountants expect from a simple purchase. This is because BC separates the purchasing and inventory costing processes into two distinct G/L registers, allowing it to optionally defer inventory posting via the Automatic Cost Posting setting in Inventory Setup. The entries are:
- Purchase register: Purchases account (Debit) / Accounts Payable (Credit)
- Inventory costing register: Inventory account (Debit) / Direct Cost Applied account (Credit)
The Purchases account and the Direct Cost Applied account are both set up in the General Posting Setup page. In many default configurations they point to the same G/L account, which causes them to net to zero and become invisible unless you deliberately separate them for reporting purposes.
The Direct Cost Applied account is typically classified as a Cost of Goods Sold type income statement account. Its role is to act as a credit-side offset so that the inventory debit does not leave an unbalanced entry in the G/L register. It also ensures that the purchase cost does not flow into your P&L as an expense at the point of purchase. Without it, buying stock would immediately reduce your reported profit before a single unit is sold. This directly violates the matching principle, which requires that expenses are recognised in the same period as the revenue they generate.
In practice, the balance in the Direct Cost Applied account should net to near zero over time as the Adjust Cost batch job runs and actual costs are settled. A persistent balance here is a signal worth investigating, often pointing to unprocessed cost adjustments or partial credit memos.
Common mistakes when this account is excluded or incorrectly set up:
Your P&L shows artificially low profit in the period of purchase, even though the goods have not been sold. Gross profit swings between periods depending on when stock is purchased versus when it is sold. The trial balance becomes difficult to reconcile because the two G/L registers no longer balance independently.
Ensure the Direct Cost Applied account is mapped in your General Posting Setup for every active combination of Gen. Business Posting Group and Gen. Product Posting Group that covers purchased inventory items.
Account 2: The COGS account and recognising the real cost of a sale
When a customer order is shipped and invoiced, Business Central posts two sets of entries at the same time. The first records the revenue. The second records the cost of the goods that left your warehouse:
- Revenue entry: Accounts Receivable (Debit) / Sales Revenue (Credit)
- Cost entry: COGS account (Debit) / Inventory account (Credit)
The cost of goods sold posting to the income statement is determined by the combination of the Gen. Business Posting Group and the Gen. Product Posting Group, exactly the same matrix used for the Direct Cost Applied account. This is configured in the General Posting Setup page under the COGS Account column.
The COGS account debit and the Sales Revenue credit appear in the same period, satisfying the matching principle and producing an accurate gross profit figure. This is the correct moment for cost recognition, not when the goods were purchased and not at year end.
If the COGS account is absent from your financial report layout, even if it is correctly configured in the General Posting Setup, your P&L will show the full sales revenue with no corresponding cost. The result is a grossly overstated gross profit. More critically, your trading account will not tally because the debit side of the cost entry exists in the ledger but is not being shown in the report.
Impact on your financial statements:
Gross profit appears far higher than reality, which is misleading for management decisions, tax reporting, and external reporting. The P&L debits and credits do not reconcile to the trial balance. Inventory on the balance sheet decreases without any corresponding expense appearing on the P&L, creating an unexplained gap between the two statements.
Account 3: The Inventory Adjustment account and real-world discrepancies
Physical inventory is rarely a perfect match with what the system holds. Stock counts reveal shrinkage. Goods are damaged in the warehouse. Items are written off. Costs are revalued after the fact. Each time you do an appreciation or write-down of inventory, the Inventory Adjustment account comes into play according to the posting group combination defined in your General Posting Setup.
For example, if a stock count reveals a unit worth £100 is missing, Business Central posts:
Inventory Adjustment account (Debit) / Inventory account (Credit)
The debit to the Inventory Adjustment account is the loss. It appears on your P&L. The credit reduces your inventory balance sheet value to reflect reality. Both sides are essential. If the Inventory Adjustment account is excluded from your financial reports, the inventory value on your balance sheet quietly decreases while the loss never appears on the P&L. Your books are then structurally out of balance.
This account also captures the output of the Adjust Cost Item Entries batch job. When you post inventory transactions such as sales shipments, purchase invoices, or inventory adjustments, the changed item costs are recorded in item value entries, and these costs need to be posted to the related inventory account, adjustment account, and COGS account in the general ledger. Running cost adjustment without this account correctly configured means those corrections disappear from your P&L entirely, leaving your inventory valuation and your G/L out of sync.
Where to configure these three accounts in Business Central
All three accounts are mapped inside the General Posting Setup page. Use the search bar (Alt+Q) and type General Posting Setup. The page displays a matrix of Gen. Business Posting Groups and Gen. Product Posting Groups. For each relevant combination, look for and populate these three columns:
- Direct Cost Applied Account: typically set as a COGS type income statement account, offsetting the inventory debit on the purchase costing register.
- COGS Account: a dedicated P&L expense account that captures the cost of sold goods at the point of sale.
- Inventory Adjustment Account: a clearly labelled P&L account for write-downs, revaluations, and cost corrections from the Adjust Cost batch job.
A common configuration mistake is leaving rows in the General Posting Setup partially complete, particularly for posting groups added after go-live such as a new product category or a new customer segment. Always audit your full posting setup matrix when adding new groups, and confirm that all three accounts are populated for every active combination.
Additionally, check your financial report row definitions (formerly called account schedules in older BC versions). Even if the accounts are correctly configured in the General Posting Setup, they must be included in your financial report layout for the figures to appear on your P&L and balance sheet. Accounts that are posting correctly in the ledger but missing from the report layout are one of the most common causes of unexplained gaps in BC financial statements.
Frequently asked questions
1. What is the Direct Cost Applied account in Business Central?
It is a credit-side account within the inventory costing G/L register that offsets the debit to the Inventory account when a purchase invoice is posted. It is typically classified as a COGS type income statement account and prevents purchase costs from flowing into the P&L before goods are sold, ensuring expenses are matched to the correct revenue period.
2. Why is my Business Central trial balance not tallying?
A common cause is that the COGS or Inventory Adjustment accounts are posting entries in the general ledger but are excluded from your financial report row definitions. The underlying ledger entries exist correctly, they are simply not appearing in the report. Check your financial report layout and confirm these accounts are included as individual rows or within the correct account ranges.
3. What is the difference between the COGS account and the Inventory Adjustment account?
The COGS account captures the cost of goods at the point of a customer sale, a planned and expected transaction. The Inventory Adjustment account captures unplanned changes to inventory value including write-downs, physical count discrepancies, revaluations, and cost corrections generated by the Adjust Cost Item Entries batch job.
4. Where do I find the General Posting Setup in Business Central?
Use the search bar (Alt+Q or the magnifying glass icon) and type General Posting Setup. The page displays a matrix of Gen. Business Posting Groups and Gen. Product Posting Groups. Locate the relevant row and column combination to find or update the three account fields.
5. Can I use the same G/L account for all three of these in Business Central?
The system will allow it in some configurations, but it is inadvisable. Using separate accounts gives you clean, auditable financial reporting. You can see exactly how much cost came from direct purchases, how much from sales, and how much from inventory adjustments. Combining them into a single account makes reconciliation significantly harder and obscures important information for management and audit purposes.
6. Do I need a Business Central specialist to configure these accounts correctly?
For new implementations, or if your current financials are showing unexplained discrepancies, working with a certified Business Central implementation partner is the safest approach. Incorrect posting setup can result in months of misreported financials that are time-consuming and complex to reverse.
Get your Microsoft Dynamics 365 Business Central financials right
Our certified Microsoft Solutions Partner team helps businesses configure, implement, and optimise Dynamics 365 Business Central. Whether you are setting up for the first time or untangling an existing configuration, we can help.
Book a free Business Central consultation and speak with a certified D365 Business Central specialist.
