Finance

Period close in Business Central: the sequence that takes days, not weeks

Close drags on because of the order of operations, not the volume of work. Here is the sequence that removes the rework.

Why period close drags on

Short answer: not the volume of work, but the order of it. Close consists of procedures that depend on each other. Calculate the financial result before adjusting inventory cost and you will be recalculating everything a second time.

Companies that close in two days rather than two weeks are not doing anything clever. They have a fixed sequence and a checklist before each step. What follows is that sequence.

The close sequence: seven steps

StepWhat happensWhy here and not elsewhere
1. Source documentsEvery document of the period posted, no drafts leftOne unposted document corrupts every calculation after it
2. Bank reconciliationStatements imported and matchedUnmatched payments distort receivables and payables
3. Currency revaluationRevalue foreign currency balances and open entriesMust precede the result calculation
4. Inventory costAdjust cost of item entries, allocate item chargesThe heaviest step: it changes cost of goods sold retroactively
5. DepreciationPost depreciation across all booksPeriod expense must be complete first
6. Financial resultClose income and expense accountsOnly valid after steps 3–5
7. Lock the periodRestrict posting datesSo nobody edits data after the statements are filed

Step four is the one most often skipped. If cost adjustment is configured but never run on a schedule, inventory value and cost of goods sold live in separate realities, and the gap compounds month after month until somebody finally reconciles a stock count.

Worth automating. Business Central can run cost adjustment automatically after posting, but on high-volume systems the batch job scheduled outside working hours is the more predictable option. Either way, it must run before anyone looks at margin.

Costing method: chosen once, lived with forever

The costing method is set per item and is effectively impossible to change retroactively, because it governs how existing entries were valued. That makes it a design decision, not something to revisit during configuration.

MethodSuitsRisk
FIFOPerishables, distributionRequires discipline in document chronology
AverageHomogeneous stock, raw materialsLate documents distort the average
SpecificWhen the individual lot mattersMost precise, but every document must carry lot information
StandardManufacturing with predictable costsNeeds regular revision of standards and variance analysis

A practical test before the first close in a new system: run cost adjustment against last month's data in a sandbox and compare the result with what the old system reported. The difference shows exactly where configuration does not match how goods actually move.

Currency revaluation and import costs

Revaluation covers foreign currency bank balances and outstanding customer and vendor entries. Sequence matters here too: apply payments to invoices first, revalue second. Otherwise the system revalues debt that has already been settled.

Import operations add a separate concern. Customs value, duty and other acquisition costs belong in the item's cost, not in period expense. Post them as item charges and they land where they should. Post them as an expense and margin on imported lines will read high — sometimes for years before anyone questions it.

Control reports before signing off

  • Trial balance. No unusual balances sitting on clearing or suspense accounts.
  • Account analysis on key accounts. A breakdown of any figure that raises a question.
  • Aged receivables and payables. Balances by customer and vendor, matched against expectation.
  • Inventory valuation against quantity. Value and units agree with the warehouse.
  • Gross margin by item group. The simplest test that exists.

That last one deserves emphasis. If margin on a product group suddenly looks atypical, the cause is almost always cost adjustment that was never run, or documents posted with a back-date after the fact. It takes thirty seconds to check and catches errors that a trial balance will happily hide, because a wrong cost still balances.

Why locking the period is not bureaucracy

After the statements are filed, the period is closed to changes. Two settings do this: allowed posting dates at company level, and per-user posting periods for people who need a narrower window.

Without locking, any correction posted "into last month" silently rewrites reporting that has already been submitted. The report you produced yesterday shows different numbers today, and nobody can say why. Once that happens twice, finance stops trusting the system and goes back to keeping its own spreadsheet — which is the real cost of skipping this step.

A workable convention: lock immediately after sign-off, and require a named approver to reopen. Corrections then arrive as documents in the current period, where they belong, rather than as invisible edits to a closed one.

Shortening period close is a common goal of our projects.

Frequently asked questions

How long should a month-end close take in Business Central?

A few days rather than a couple of weeks once the sequence is fixed. Most of the saving comes from automated bank statement matching, scheduled cost adjustment and reports built on account schedules instead of exports.

Why must cost adjustment run before the financial result?

Because adjusting cost changes cost of goods sold retroactively. Calculating the result first means recalculating it afterwards, and any figures circulated in between will be wrong.

Can the costing method be changed later?

Not realistically. The method governs how existing entries were valued, so it has to be settled during design, before any transactions are posted.

In what order should currency revaluation and payment application run?

Apply payments to invoices first, then revalue. Reversing the order revalues debt that has already been settled.

Where should customs duty and freight on imports be posted?

As item charges, so they enter the cost of the goods. Posting them as period expense inflates the margin on imported items and hides it from routine checks.

How do we stop people posting into a closed period?

Through allowed posting dates at company level, with narrower per-user posting periods where needed. Reopening should require a named approver rather than being a routine action.

← All articles

Ready to modernize your business?

Leave your details and we'll send the details of a free process audit. We reply within one business day.

or write directly: info@nbcs365.com · +380 98 107 5878