Chapter 6 of 8Page 3 of 4

Close, reconcile and report

Tender settlement

Post cash, card and voucher amounts to their own accounts: per-tender settlement closes each POS invoice with one payment per tender, so deposits reconcile.

updated: applies-to: 1.0.0.141

Per-tender settlement makes every tender on a posted POS document settle into its own account. With it on, Bitta Retail POS posts one applying customer payment per tender slice, so a sale paid partly in cash and partly by card closes its customer ledger entry with two payments: one to the cash drawer account and one to the card clearing or bank account. Split tenders land cent-exact in the right accounts, and the open receivable remains only where it should, such as On Account.

Prerequisites

  • The BAA POS - Admin or BAA POS - Full permission set.
  • G/L accounts that allow direct posting, or bank accounts, for each tender that is paid out of the drawer or by the processor.
  • Tender methods set up. See Tender methods setup.

How it works

Per-Tender Settlement is on POS Setup, in the Daily Operations FastTab, and is on by default. When it is on, the posted document carries no balancing payment method. Instead, posting writes one settlement entry for each tender slice, and the app posts each entry as a separate payment:

  • The decision is taken per sale when the sale completes, together with the settlement account of each tender. Changing the setup or a tender's account later affects new sales only.
  • A slice is one tender method on one document. In a consolidated document, the payments of all its sales are added up per tender method and account.
  • The slices of a document must sum exactly to its total including tax. If they do not, the group does not post and the run reports "Settlement integrity failed". No remainder is moved between tenders.
  • Each payment is posted with the posted document number, against the customer, applied to the posted invoice (a refund applied to the posted credit memo for returns), with the tender's settlement account as the balancing account. The application closes the customer ledger entry.

Payments for pending entries are posted at the end of every End of Day run, which also retries pending entries from earlier runs, and right after a single sale is posted. In order mode the entries wait until you post the order; see Consolidated posting.

Set up settlement accounts

  1. Open POS Setup and check that Per-Tender Settlement is turned on in the Daily Operations FastTab.
  2. Search for POS Tender Methods and open each tender method. In the Settlement FastTab, set Settlement Account Type to G/L Account (the default, for a cash drawer or card clearing account) or Bank Account, then set Settlement Account No. A G/L account must allow direct posting, be a posting account and not be blocked. Changing the type clears the number.
POS Tender Method Card for the CASH tender with the Settlement Account Type and Settlement Account No. fields
Step 2: give each tender method its settlement account.
  1. Leave Settlement Account No. blank for tenders whose settlement is the open receivable, such as On Account, so their share of the invoice stays open in Accounts Receivable.

When a tender has no settlement account, the balancing account of its Business Central payment method is used. Only a tender with no account anywhere stays open in Accounts Receivable.

TIP

Give each card tender its own clearing account and relieve it when the processor deposit lands. Bank reconciliation then matches one deposit against one account.

Review and retry settlement entries

  1. Search for POS Settlement Entries, or choose Settlement Entries in the Payments menu of the Bitta Retail POS Admin role center. From POS Daily Operations Runs, Settlement Entries shows only the entries of the selected run.
POS Settlement Entries per tender after End of Day
Review: one entry per tender slice of each document.
  1. Check Status:
Status Meaning
Pending Waiting for its payment to post, or for an order in order mode to be posted.
Posted The payment is posted; Payment Entry No. holds its customer ledger entry.
Not Applicable The tender has no account, such as On Account; the slice stays open in Accounts Receivable.
Failed The payment could not post. Error Message says why.
Needs Attention The entry needs review before it can post.
Cancelled The entry was cleared, for example when a retained order was cancelled.
  1. Fix the cause of each failure, for example a missing or blocked settlement account, then choose Post Pending Settlements. Failed entries are reset and retried, and entries that are already posted are never touched, so you can run it as often as needed. When the posted document proves a different bill-to customer, Repair Customer Identity corrects that one failed entry and keeps the original customer as evidence.

Amount is positive for a payment and negative for a refund on a return. Daily Operations Run Entry No. links the entry to its End of Day run and is blank for single-sale posting.

Check with the settlement report

The End-of-Day Posting and Settlement report, in the Finance group of the POS Report Center (or under Cash in the action bar), traces each batch from the POS sales through the archive and the posted documents to its settlement entries without changing anything. It is not listed in Tell Me. Its request page has business and posting date ranges, which default to the work date, plus Exceptions Only, Source Documents, Tender Settlement, Tax Controls and Application State, and filters for batch, store, terminal and customer.

Request page of the POS EOD Posting Settlement report with business and posting date ranges and the Tender Settlement option
The End-of-Day Posting and Settlement report from the POS Report Center.

Turn per-tender settlement off

With Per-Tender Settlement off, the whole document settles through the dominant tender's payment method. Sales completed while it was on still settle per tender.

What's next

Read the day with the built-in reports and analytics: POS sales reporting. Every report is listed in All POS reports.

// next step

Ready to try Bitta Retail POS?