← All posts
The Year-End Close in SAP Business One: A Checklist That Saves Your January

The Year-End Close in SAP Business One: A Checklist That Saves Your January

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.

The Year-End Close in SAP Business One: A Checklist That Saves Your January — photo 2

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:

  1. Change the current period status so new postings are blocked. This is your lockdown — no more backdated invoices sneaking in.
  2. 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.
  3. 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.

The Year-End Close in SAP Business One: A Checklist That Saves Your January — photo 3

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.

Share this post X Facebook LinkedIn
David Strausser

Written by David Strausser

David is CEO of Dead Brands, LLC and Head of Sales (contracted) for Quaint Business Solutions — an ERP veteran of over a decade across SAP Business One and Odoo. Ex-General Manager (Northeast) at Vision33 and VP of Business Development at SEIDOR. Dad, guitarist, Eagles fan.

Keep reading

Let's talk about your business

Running on spreadsheets, QuickBooks, or an ERP that fights you? Grab a free 30-minute call — I'll tell you straight whether SAP Business One or Odoo is the right move, and what it really costs.

Book a Meeting with Me

Shop the brand

Take a piece of the bite with you

Don't Tread on Anyone tee — black shirt with a cool porcupine in sunglasses
View all in the store →