End of Day and Reports in Business Central

The till and the books agree. Here's the proof. Last time, the shift closed and the drawer matched to the cent. Now it's your turn, in the back office. One job is left: post the day to Business Central, with every dollar in the right account.

Start with two settings in POS Setup. End of Day is set to block while any drawer is still open, so a live till is never posted by mistake. And per-tender settlement is on, so cash and card each land in their own account. On your role center, the backlog tile counts the sales that are complete but not yet posted. Open End of Day. The posting date is today, and this run posts invoices, not orders. Before anything is written, you get a preview. It shows the sales in scope, how they'll be grouped, the store and register, and the return. A sale with no customer, or an item that isn't mapped, would be named right here, with the reason. Everything is clean. Choose yes.

The result tells you exactly what posted. End of Day posts through Business Central's own sales posting. No side ledger, no export, no import. Instead of one invoice per receipt, sales are grouped by customer, store, register and payment method. So the walk-in cash sales share one invoice, the card sales share another, and the hiking club gets its own. A return is never netted against a sale. It posts as its own credit memo. On the POS sales list, every sale now reads Posted, next to the invoice that covers it. Each register line is copied one to one onto the invoice, so any receipt traces straight to the books. The daily archive keeps one summary row per batch, with its totals, tax and registers. Run End of Day again for the same date, and nothing posts twice.

Now the money. Take the sale that was paid part cash, part card. Per-tender settlement writes one entry for each payment method on the posted invoice. Cash settles to the drawer account. Card settles to card clearing, ready to match the processor's deposit. Each entry posts a payment against the invoice, and closes it. On account is different. It has no settlement account, on purpose, so it stays open for the club to pay later. The return settles as a refund, with a negative amount. The slices must add up to the invoice total, to the cent. If they don't, nothing settles, and the entry says why. Anything that fails waits here, and one action tries it again, safely. Today, nothing is waiting.

Now look at the books the way your accountant will. Posted sales invoices. Standard Business Central documents, numbered in your own series. Open one. The items, quantities, prices and sales tax are exactly what rang up at the counter. The customer ledger tells the rest. The cash and card invoices are closed by their payments. The club's invoice stays open, for exactly what it charged to its account. And the credit memo for the return sits beside them, refunded and closed.

For the manager, the checks for the day live in one place: the POS Report Center. It's a full Report Center, grouped into sales, finance, operations and audit. Start with Daily Reconciliation. Pick the date, show it by shift, and include settlement. Each document total appears once, even when it was split across tenders. The shift shows its float, expected cash, counted cash, and no variance. The tax summary is built from the tax stored on each sale, so a later rate change never restates a finished day. The settlement report traces each batch from the register, to the posted invoice, to every tender payment. Returns and refunds get their own report. The discount audit shows every override, and who approved it.

When you just want to see how the store did, open POS Analytics. Live, inside Business Central, with nothing to export. Pick a period. Up top: completed sales, gross sales, average basket and returns. Tender mix shows how customers paid. Top items shows what sold. The cashier leaderboard shows who sold it. Cash variance lists every closed shift, expected against counted. And margin uses the actual cost from the posted entries, not an estimate. So, back to tonight. The drawer was counted, and the day is posted as standard invoices. Every tender is settled to its own account, and the only open balance is the one that should be. The till and the books agree. Now you can prove it. Next, the full demo, from install to the books.