How Microsoft Dynamics 365 Business Central Calculates COGS Automatically

For any finance or operations team, the Cost of Goods Sold (COGS) is one of the most critical figures on the Profit and Loss statement. It tells you what it cost to generate your revenue, and it is the foundation of your gross profit calculation. Yet in many businesses, this number is only accurate once a month, after an accountant has manually closed the books.

Microsoft Dynamics 365 Business Central changes that entirely.

What Is Cost of Goods Sold (COGS) in Accounting?

COGS represents the direct cost of inventory items sold during a specific period. In its simplest form, it is calculated as:

Opening Stock + Net Purchases + Direct Expenses - Closing Stock = COGS

This figure is then subtracted from net sales to arrive at gross profit or loss. Without an accurate COGS figure, your P&L is incomplete, and any business decision made from it carries risk.

How Tally and Periodic Inventory Systems Handle COGS (And Why It Creates Problems)

Systems like Tally and many smaller ERPs operate on a periodic inventory model. This means inventory values and COGS are not updated automatically with each transaction. Instead, an accountant manually calculates and passes closing entries at the end of a month or financial year.

This creates four compounding problems:

1. When goods are purchased, the system often records them as an immediate expense on the P&L, even if the items are still sitting in the warehouse unsold. The balance sheet therefore fails to reflect inventory as an asset at its correct value.
2. Until the closing entry is passed, the P&L shows full purchase costs against only partial revenue, making gross profit appear significantly worse than it actually is.
3. Manual calculations introduce a higher probability of errors and delays. A mistake in a closing entry can distort reported profit for an entire period.
4. Finance leadership has no reliable gross margin visibility during the month. Decisions on pricing, procurement, and cash flow are made on incomplete data.

How Business Central Calculates COGS in Real Time

Microsoft Dynamics 365 Business Central operates on a perpetual inventory system. Every inventory movement is tracked automatically, and COGS is calculated and posted the moment a transaction occurs, with no manual intervention required. Here is how the accounting entries work at each stage:

At the point of purchase

When a purchase invoice is posted, Business Central records the cost against the inventory account as an asset on the balance sheet. Simultaneously, it uses a Direct Cost Applied account to offset any impact on the P&L. When Automatic Cost Posting is enabled in Inventory Setup, this ensures the P&L remains clean and unaffected until the inventory is actually sold.

At the point of sale

When a sales invoice or shipment is posted, Business Central performs two actions in a single posting: it recognises revenue and immediately records the corresponding COGS entry, reducing the inventory asset on the balance sheet at the same time. There is no lag, no manual step, and no period-end dependency.

How Business Central Reconciles Inventory and COGS Accounts Automatically

Business Central uses intermediate accounts to transfer costs from purchases into inventory and then into COGS. Once cost application routines complete, these accounts net to zero, leaving a clean and accurate gross profit figure in the P&L.

This process is governed by Item Ledger Entries, Value Entries, and General Ledger Entries, which together create a complete and auditable cost trail for every item sold.

Seeing this in action is the fastest way to understand the impact on your business. Book a free Business Central demo with our team and we will walk you through COGS, inventory valuation, and financial reporting live.

What Finance Teams and CFOs Gain from Real-Time COGS in Business Central

For financial controllers and CFOs, the practical difference is significant:

• Your P&L is accurate every single day of the month, not just after month-end close.
• Gross margin is visible in real time, so pricing and procurement decisions are grounded in current data.
• There is no dependency on manual stock counts or physical verification to produce a COGS figure.
• Every cost movement is traceable through automatically generated ledger entries, which supports cleaner audits and faster period-end close.

Businesses migrating from Tally or similar periodic systems consistently report that real-time COGS visibility is one of the most immediate and tangible improvements they see after going live on Business Central.

Business Central COGS: Frequently Asked Questions

1. What is COGS in Microsoft Dynamics 365 Business Central?

COGS in Business Central is the cost automatically recognised against sold inventory at the moment a sales invoice or shipment is posted. The system calculates this in real time using item cost information and posts the corresponding general ledger entries without any manual input from the user.

2. How does Business Central differ from Tally in handling COGS?

Tally uses a periodic inventory system where COGS is calculated manually at period end and requires closing entries to be passed by an accountant. Business Central uses a perpetual inventory system where COGS is calculated and posted automatically with every sales transaction, keeping the P&L accurate at all times.

3. What costing methods does Business Central support?

Business Central supports five inventory costing methods: FIFO (First In, First Out), LIFO (Last In, First Out), Average, Standard, and Specific. Each method determines how the system assigns costs to items when they are sold, and the choice affects how COGS is calculated across different inventory movements. Note that LIFO availability depends on your country or region configuration, as it is not permitted under certain local accounting standards.

4. Does Business Central require manual month-end stock adjustments for COGS?

No. Because Business Central operates on a perpetual inventory system, stock values and COGS are updated with every transaction. The Adjust Cost Item Entries routine can be run at any time to ensure all costs are fully applied, but this is not a manual COGS calculation; it is a cost correction and revaluation process.

5. Is Business Central suitable for businesses currently using Tally?

Yes. Business Central is a common upgrade path for businesses outgrowing Tally, particularly those that need real-time financial reporting, multi-entity support, or integration with Microsoft 365 and Power BI. The transition provides immediate improvements in COGS accuracy, inventory visibility, and audit readiness.

Ready to See Business Central in Action?

If your finance team is waiting until month-end to understand your gross margins, or if your P&L is only accurate after a manual closing entry, Business Central can solve this from day one.

Book a free demo with Buy Business Central and see how perpetual inventory, real-time COGS, and automated financial reporting work together in a live environment built for your business.