January is the month SAP Business One punishes optimism. Every December I watch the same movie: a controller tells me "we'll close it next week," next week becomes January 6th, and by January 10th someone has posted a vendor invoice into the prior year and the trial balance looks like a crime scene.
The year-end close in B1 isn't complicated. It's just unforgiving. There is no "undo" button on a closed posting period that you reopened wrong. So here's the exact sequence I run for clients, in order, every single December.
Step 1: Reconcile Before You Touch Anything
Before you even think about the posting period screen, run these three reports and make them tie out:
Trial balance (Financials > Financial Reports > Accounting > Trial Balance). If debits don't equal credits, stop. You don't have a closing problem, you have a bookkeeping problem, and closing the period will just embalm it.
A/R and A/P aging. Every open item should have an owner and a story. The invoice from November that "we'll sort out later" is the one that becomes a $4,500 write-off in February because nobody remembers what it was for.
Inventory audit report. Run it by warehouse. If your system quantity and your floor quantity disagree by more than a rounding error, schedule the physical count NOW, not in January when the warehouse crew is on holiday hours.
I had a distribution client — 40 employees, two warehouses — who skipped this step three years running. Year three, the discrepancy was $18,000 in phantom inventory. Their accountant's exact words: "We can't sign this." That phone call cost them more in CPA cleanup fees than the ERP license.

Step 2: Lock the Posting Period (The Right Way)
Here's where B1 is different from QuickBooks, and where people get burned. In SAP Business One, the posting period controls live at Administration > System Initialization > Posting Periods. You don't "close the year" with a single button — you manage period statuses.
The sequence that works:
- Change the current period status so new postings are blocked. This is your lockdown — no more backdated invoices sneaking in.
- Open the first period of the new year so daily operations continue. Your warehouse can still ship on January 2nd; they just can't post into December anymore.
- Only after steps 1-2, finalize the old period.
The gotcha that cost a client real money: they locked the period while open deliveries were still sitting un-invoiced. In B1, a delivery reduces inventory but the revenue recognition happens at invoicing. Close the period with deliveries hanging, and your December P&L shows the cost of goods without the revenue. One client showed a $2,300 margin hole that took their accountant two weeks to unwind — all because five deliveries didn't get their A/R invoices before lockdown.
Rule: no open deliveries, no open returns, no unapplied incoming payments before you lock. Print the open items list, tape it to the wall, work it to zero.

Step 3: 1099s Come From Closed Data
This is the one people argue with me about, and they're wrong every time. Run your 1099s AFTER the period is locked, not before.
Why: the 1099 report in B1 pulls from posted A/P invoices. If you run it December 28th and then someone posts a "quick correction" on January 3rd backdated to December, your 1099s are wrong and you're filing amendments. Amended 1099s are the paperwork equivalent of stepping on a rake.
The 1099 flow: Financials > 1099 > 1099 Forms. Verify your vendor master data has tax IDs populated BEFORE you run it — I once watched a client discover 11 vendors missing EINs on January 28th. The scramble to collect W-9s in 72 hours was not anyone's idea of fun.
Step 4: The Three Gotchas, Priced
Gotcha 1: Exchange-rate differences. If you do business in multiple currencies, run the exchange-rate differences routine (Financials > Exchange Rate Differences) before locking. Currency moved ~1.5% in Q4 last year; on a $200k foreign-currency A/R balance, that's a $3,000 unrealized gain/loss hitting your P&L. Skip it and your balance sheet lies to you all year.
Gotcha 2: Inventory count timing. The physical count has to post into the correct fiscal year. Count on December 30th but post the adjustment January 4th into the new period, and your December inventory valuation is wrong. Decide the count date in November, put it on the calendar, and protect it like a customer meeting.
Gotcha 3: Recurring postings. B1's recurring postings (Administration > System Initialization > Recurring Postings) don't care about your year-end. That monthly rent accrual will happily post into your shiny new January period — or worse, into December if the template dates are stale. Review every recurring template in the first week of January. Five minutes now saves a reversing journal later.
The January Test
Here's how you know you did it right: by January 15th, nobody is talking about December. The books are closed, the 1099s are filed, the accountant isn't calling, and your controller isn't working weekends. A clean close is invisible. A bad close echoes until April.
Print this checklist. Work it top to bottom. And lock the period before someone "just posts one quick thing."
David Strausser, Dead Brands LLC / Quaint Business Solutions Want help with your ERP? Book a call — I do SAP Business One health checks that find the mess before your accountant does. Fresh Dead Brands merch just dropped at deadbrands.co — wear it while you close the books.
Frequently asked questions
What is the very first step of a clean SAP B1 year-end close?
Reconcile before you touch anything. Run the trial balance, the A/R and A/P aging, and the inventory audit report, and make them tie out. If debits do not equal credits, you do not have a closing problem — you have a bookkeeping problem, and locking the period will just embalm it.
Where do I lock the posting period in SAP Business One?
At Administration > System Initialization > Posting Periods. There is no single "close the year" button: you block new postings in the old period, open the first period of the new year so operations continue, and only then finalize the old period.
Should I run 1099s before or after the period is locked?
After. The 1099 report pulls from posted A/P invoices, so any backdated correction posted after you run it makes your filings wrong and buys you amended forms. Lock first, verify vendor tax IDs are populated, then run the 1099s from closed data.
What is the most common year-end mistake in B1?
Locking the period with open deliveries still un-invoiced. A delivery reduces inventory but revenue only lands at invoicing, so your December P&L shows the cost of goods with no matching revenue — a margin hole your accountant gets to unwind in January.





