January doesn't have to hurt
Every January, I get the same calls. "Our close is going to take three weeks." "The auditors found something." "Can you help us figure out why the inventory valuation doesn't tie?"
Here's the secret: a painful January is always caused by a sloppy December. Not bad luck. Not the software. Just skipped steps catching up with you all at once.
SAP Business One actually handles year-end well — period-end closing, automatic retained earnings, clean audit trails. The tool isn't the problem. The process around the tool is. So here's the process.
Phase 1: December — reconcile everything (weeks 1-3)
Don't wait until December 31st. Start early in the month.
Bank reconciliations. Every account, current through at least mid-December. If your bank recs are behind in November, you're already in trouble — catch up now, not during close week.
Subledger to GL. AR aging ties to the AR control account. AP aging ties to AP control. Inventory valuation ties to the inventory GL accounts. If any of these are off by even a dollar, stop and find it now. A $0.47 variance in December becomes a $47,000 mystery in February — I've seen it happen.
Open items review. Old unapplied credits. Mysterious journal entries from March that nobody remembers. GRPOs never invoiced. Clean house now while there's still time to research.
Phase 2: The soft close (last week of December)
Run your financials as if the year were over — before it is. This is the single highest-value step and the one most companies skip.
Print the P&L. Print the balance sheet. Read them like an auditor. Does revenue look right? Are expenses in the right periods? Any account with a weird balance? The soft close catches the "oh no" moments while you still have business days left to fix them.
Post your accruals and deferrals now: unbilled expenses, prepaid amortization, bonus accruals. If you wait until January, you're posting into a closed period and creating exactly the mess you're trying to avoid.
Phase 3: Inventory count
SAP B1's inventory audit report is your friend, but only if the count is real. A few rules from painful experience:
- Count everything. Not a sample. Not "the important stuff." Everything. The one bin you skip is the one that's wrong.
- Freeze movement. No receiving, no shipping during the count. I know it's inconvenient. Do it anyway.
- Investigate variances immediately. Don't just post the count and move on. A variance is the system telling you something's wrong with your process. Listen.
Phase 4: 1099s and payroll cleanup
SAP Business One's 1099 reporting works fine if your vendor master data is clean — which, let's be honest, it probably isn't. December is when you find out that three vendors are missing tax IDs and one has been paid under two different vendor codes all year.
Run the 1099 report in mid-December as a discovery exercise. Fix what you find. Your January self will thank you.
Phase 5: Close the period (January)
Now the actual SAP B1 mechanics:
- Post the closing. Use the Period-End Closing function — it handles retained earnings automatically. Don't hand-journal retained earnings like it's 1998.
- Lock it. Set the period status to locked. An unlocked prior year is an invitation for someone to "just post one quick thing" in March that ruins your audit.
- Open the new year. New posting periods, new fiscal year, updated tax tables and 1099 thresholds.
The three things everyone forgets
Document attachments. Those invoice PDFs attached in SAP B1? Make sure your backup includes them. They're part of your audit trail.
User authorizations for the new year. New hires need period access. Departed employees need it removed. January is the natural moment.
The exchange rate table. If you deal in foreign currency, verify your year-end rates are loaded before you close. Reversing a close to fix FX rates is nobody's idea of fun.
Frequently asked questions
How long should a SAP Business One year-end close take?
For a well-prepared SMB: 3-5 business days of focused work. If yours takes three weeks, the problem isn't the close — it's the eleven months before it. This checklist is how you get to 3-5 days.
Can I reopen a closed period in SAP Business One?
Yes, an authorized user can change the period status back. But every reopen should require approval and documentation — otherwise your "closed" periods aren't really closed, and your auditors will notice.
Does SAP Business One handle 1099-NEC and 1099-MISC?
Yes. The 1099 reporting function covers both, pulling from vendor master data and AP transactions. The output quality depends entirely on vendor master cleanliness — garbage in, IRS letter out.
Should we do a hard close on December 31st or allow January adjustments?
Best practice: soft-close December 31st, allow a defined adjustment window (usually 2-3 weeks in January for accruals and audit entries), then hard-lock. Communicate the lock date in advance so nobody's surprised.
