Niblin
Month-end close

Month-end close on numbers that tie to the books

Niblin reconciles Shopify, Amazon, wholesale and retail settlements to your general ledger, tracks deductions to resolution, and locks the month with a full audit trail. FP&A reads locked actuals, so the forecast starts from numbers finance has signed off.

See how Niblin models it
Month-end close in Niblin

Reconciliation

Platform-to-ledger reconciliation

Each channel's expected payouts are compared with what the platform settled and what reached the bank, within tolerances you set.

  • Settlements marked matched, short, over or pending
  • Bank deposits matched to payouts by reference, then amount and date
  • Cash with no matching settlement kept and flagged, never dropped
  • GL tie-out per cost head with a tolerance per account type
Platform-to-ledger reconciliation

Deductions

Deductions tracked to resolution

Retailer and marketplace deductions are tied to the invoice or order they came from, coded by reason, and tracked until they are recovered or written off. Our trade spend guide explains how they hit net revenue.

  • Pending, disputed, recovered and written-off states
  • Reason codes in each channel's own language
  • Chargeback and returns provisions from your measured rates
  • Recoveries booked as their own entries, never hidden reversals
Deductions tracked to resolution

Close and lock

A checklist, a lock and an audit trail

A configurable checklist confirms every source has landed and every tie is within tolerance. Then the controller locks the month.

  • Accepted differences stored with a reason and approver
  • Changes after the lock shown as prior-period adjustments
  • Relock and reopen keep every earlier version
  • Accruals tracked from estimate to actual to cash
A checklist, a lock and an audit trail

How it works

  1. 01

    Connect

    Connect Shopify, Amazon Seller Central, SPS Commerce, ShipBob and QuickBooks, Xero or Zoho Books.

  2. 02

    Assign

    Confirm a ledger assignment from each source's cost codes to your chart of accounts.

  3. 03

    Reconcile

    Work the checklist: settlements, bank matches, deductions and GL ties.

  4. 04

    Lock

    Lock the month. Variance, the forecast and the board pack read the locked numbers.

Month-end close in spreadsheets vs in Niblin

Most brands close with the accounting system plus a set of reconciliation sheets. The hard part is settlements, bank deposits and deductions across many channels, and it repeats every month under deadline pressure from the board pack.

Spreadsheet modelNiblin
SettlementsSpreadsheet modelPayout reports ticked off by handNiblinMatched, short, over or pending per settlement
Bank depositsSpreadsheet modelMatched line by lineNiblinMatched to payouts by reference, then amount and date
DeductionsSpreadsheet modelA running list per retailerNiblinTracked to recovery or write-off with reason codes
GL tie-outSpreadsheet modelSpot checksNiblinTie-out per cost head with tolerances
Close statusSpreadsheet modelChecklist in a shared fileNiblinConfigurable checklist, then a lock
After the lockSpreadsheet modelEdits change past numbersNiblinPrior-period adjustments, earlier versions kept

Frequently asked questions

Does Niblin replace our accounting system?+

No. Your books stay in QuickBooks, Xero or Zoho Books. Niblin sits on top: it reconciles channel settlements and deductions to your general ledger, runs the close checklist and locks the month for FP&A. Your controller still posts journals in the accounting system as before.

How are bank deposits matched to payouts?+

Niblin matches each payout to a bank deposit, first by the payout reference in the bank narration, then by payer, amount and date within the channel's settlement window. Anything left is matched by hand, and unmatched items past the window appear on the close checklist.

Can we reopen a closed month?+

Yes, with controller approval. Reopening or relocking creates a new lock record, and earlier locks and their adjustments are never deleted. Changes that arrive after a lock appear as prior-period adjustments in the next variance bridge, so the board sees what changed and why.

How does the close connect to FP&A?+

Variance analysis, the rolling forecast and the board pack all read the locked month. The forecast starts from actuals finance has signed off, and the board pack matches the books. Lines still landing at pack time ship as labelled estimates and true up the following month.

How are retailer deductions handled at close?+

Each deduction is tied to the invoice or order it came from, coded by the channel's own reason codes and tracked as pending, disputed, recovered or written off. Recoveries are booked as their own entries rather than hidden reversals, so every deduction stays visible through the close until it is recovered or written off.

Close on numbers FP&A can trust

See how Niblin reconciles every channel to your books and locks the month for planning.

See how Niblin models it