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 - AdminorBAA POS - Fullpermission 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
- Open POS Setup and check that Per-Tender Settlement is turned on in the Daily Operations FastTab.
- 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.
- 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
- 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.
- 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. |
- 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.
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.