POS sales by category
Mercado Pago MXN 2,500.00 + cash MXN 2,500.00 + card terminal MXN 700.00 + transfer MXN 300.00 = MXN 6,000.00. Food MXN 3,500.00; drinks MXN 2,500.00.
Fiscal / Accountant demo workspace
A daily close
you can question.
Lia guides you through a fictional report. Choose a figure, open its calculation, and reach the order items behind the ticket. The accountant decides whether each proposed amount is right.
Public demo with invented data. This page does not approve, reconcile or issue invoices.
Guided walkthrough · Lia
Follow the proposed automation.
Choose a step. Listen or read; “View evidence” opens the related record.
Accountant report · fictional sample
POS against every payment source.
Rows are sales categories; columns are payment methods. Each figure opens its contributing transactions and links to the ticket or source report. Source figures are gross, before fees.
Scroll sideways to see every payment method →
| Category | Mercado Pago | Cash | Card terminal | Transfer | Total POS |
|---|---|---|---|---|---|
| Food | MXN 1,500.00 | MXN 1,500.00 | MXN 300.00 | MXN 200.00 | MXN 3,500.00 |
| Drinks | MXN 1,000.00 | MXN 1,000.00 | MXN 400.00 | MXN 100.00 | MXN 2,500.00 |
| POS total | MXN 2,500.00 | MXN 2,500.00 | MXN 700.00 | MXN 300.00 | MXN 6,000.00 |
| Source total (gross) | MXN 2,500.00 | MXN 2,470.00 | MXN 700.00 | MXN 300.00 | MXN 5,970.00 |
| Difference · POS − source | MXN 0.00 | +MXN 30.00 | MXN 0.00 | MXN 0.00 | +MXN 30.00 |
Cash difference · MXN 30.00
POS MXN 2,500.00 − till MXN 2,470.00 = MXN 30.00. The demo threshold is less than MXN 100.00. A waiver is only a proposal for accountant review and keeps both source figures.
Awaiting review. No difference has been waived.
Municipal charge · proveout
4 guests in the proposal i × MXN 11.73 = MXN 46.92 proposed. POS records 5 guests: 4 on tickets over MXN 469.24 and 1 on the MXN 300.00 ticket. Guest-count difference 0. The accountant validates applicability and collection; the charge stays outside sales and the operational waiver.
Estimated included VAT: MXN 827.59, subject to classification review.
Audit trail
From difference to source.
POS less source reports
Collection reports total MXN 5,970.00: MP MXN 2,500.00 + till MXN 2,470.00 + terminal MXN 700.00 + SPEI MXN 300.00. Against POS MXN 6,000.00, the cash shortage is MXN 30.00. Fees are not mixed into this difference.
Proposed VAT and municipal charge
Included VAT, assuming 16% on all four tickets: MXN 344.83 + MXN 344.83 + MXN 96.55 + MXN 41.38 = MXN 827.59. Guest-level municipal charge calculation follows; classification, applicability and collection require validation.
Environmental charge proveout
Independent Los Cabos bar example: 2026 daily UMA MXN 117.31; Article 137 Sexies refers to tickets over 4 daily UMAs (MXN 469.24). The proposed amount per included guest is 10% of the daily UMA: MXN 11.731, rounded to MXN 11.73. POS records 5 guests: 2 + 1 + 1 on tickets above the threshold, and 1 on the MXN 300.00 ticket that this proposal excludes. Control: 4 included + 1 excluded = 5 POS; guest-count difference 0. Proposal: 4 × MXN 11.73 = MXN 46.92. The accountant confirms applicability, other exclusions and collection; this demo records no municipal payment.
| Ticket | Consumption | POS guests | Included | Proposed charge |
|---|---|---|---|---|
| T-260925-01 | MXN 2,500.00 | 2 | 2 | MXN 23.46 |
| T-260925-02 | MXN 2,500.00 | 1 | 1 | MXN 11.73 |
| T-260925-03 | MXN 700.00 | 1 | 1 | MXN 11.73 |
| T-260925-04 | MXN 300.00 | 1 | 0 | MXN 0.00 |
| Total | MXN 6,000.00 | 5 | 4 | MXN 46.92 proposed |
| Control: 4 included + 1 excluded = 5 POS · guest-count difference 0 | ||||
Source-to-bank bridge
September 25 source gross MXN 5,970.00 − MP fee MXN 89.70 − terminal fee MXN 14.00 = bank credits attributable to those sales MXN 5,866.30. MXN 300.00 arrived on the 25th; MXN 4,880.30 on the 26th; MXN 686.00 on the 27th. Open bank bridge difference: MXN 0.00. The MXN 30.00 till shortage remains visible separately.
Period CFDI → reconciliation
With authorized e.firma, the service requests available issued and received XML and compares SAT's reported count with downloaded files. UUID, RFC, date, amount and status can suggest links. In this sample, PR-2081 · MXN 950.00 and TC-0929 · MXN 438.60 still lack verified documents; no real XML was downloaded.
Accountant decision
Four tickets potentially eligible for a global CFDI total MXN 6,000.00, subject to checking individual invoices and exceptions. The MXN 30.00 shortage may be proposed for waiver if policy allows; approval is required and the till figure stays intact. VAT MXN 827.59 and municipal charge MXN 46.92 await validation. This page issues no invoice.
Assumptions: Los Cabos Treasury · INEGI 2026 UMA · SAT CFDI. All tickets and movements here are invented.
Fictional source reports
Open the source behind each column.
September 25 collections
- POS / approved activity
- MXN 2,500.00 / MXN 2,500.00
- Fee
- MXN 89.70
- Net payout
- MXN 2,410.30
September 25 cash
- POS expected
- MXN 2,500.00
- Counted
- MXN 2,470.00
- Shortage
- MXN 30.00
The close retains the difference; September 26 bank deposit MXN 2,470.00 →
September 25 card
- POS / gross batch
- MXN 700.00 / MXN 700.00
- Fee
- MXN 14.00
- Net payout
- MXN 686.00
September 25 transfer
- POS / bank
- MXN 300.00 / MXN 300.00
- Difference
- MXN 0.00
Bank by date: distinguish sale from deposit
The September 25 bank received MXN 2,965.00 from September 24 sales: Mercado Pago gross MXN 1,200.00 − fee MXN 35.00 = MXN 1,165.00, plus till close CJ-260924 MXN 1,800.00. Both prior-day items are closed against their references.
| Bank date | Reference | Sale date | Credit |
|---|---|---|---|
| Sep 25 | MP-LQ-260924 | Sep 24 · MP | MXN 1,165.00 |
| Sep 25 | CJ-260924 | Sep 24 · cash | MXN 1,800.00 |
| Sep 25 | TR-0925 | Sep 25 · transfer | MXN 300.00 |
| Sep 26 | MP-LQ-260925-A | Sep 25 · MP | MXN 2,410.30 |
| Sep 26 | CJ-260925 | Sep 25 · cash | MXN 2,470.00 |
| Sep 27 | TB-0925 | Sep 25 · terminal | MXN 686.00 |
| Sep 25 bank credits · includes Sep 24 | MXN 3,265.00 | ||
| Sep 26 bank credits · Sep 25 sales | MXN 4,880.30 | ||
Bank credits from September 25 sales total MXN 5,866.30 from the 25th through the 27th. Bank date alone does not identify sale date.
Fictional POS tickets
From ticket to order detail.
MP sale
- Food
- MXN 1,500.00
- Drinks
- MXN 1,000.00
- POS total
- MXN 2,500.00
- Guests in proposal
- 2
- Estimated VAT
- MXN 344.83
- Proposed local charge
- MXN 23.46
Cash sale
- Food
- MXN 1,500.00
- Drinks
- MXN 1,000.00
- POS total
- MXN 2,500.00
- Guests in proposal
- 1
- Estimated VAT
- MXN 344.83
- Proposed local charge
- MXN 11.73
Card sale
- Food
- MXN 300.00
- Drinks
- MXN 400.00
- POS total
- MXN 700.00
- Guests in proposal
- 1
- Estimated VAT
- MXN 96.55
- Proposed local charge
- MXN 11.73
SPEI sale
- Food
- MXN 200.00
- Drinks
- MXN 100.00
- POS total
- MXN 300.00
- Guests in proposal
- 0
- Estimated VAT
- MXN 41.38
- Proposed local charge
- MXN 0.00
Supplier transfer
- Bank debit
- MXN 950.00
- Related CFDI
- Unverified
Expense separate from sales. The accountant requests XML or resolves the exception.
Card purchase
- Bank debit
- MXN 438.60
- Ticket or CFDI
- Unverified
The accountant checks evidence and classification before close.
For the accounting firm
From sign-off to the accounting file.
Review before issuance
Receive categories, proposed tax figures, bank differences and ticket links. The accountant validates or corrects amounts before preparing the global CFDI.
Prepare import
We are designing a package with journal entries, accounts and evidence for CONTPAQi import. The firm's product version, layout and account map must be tested before an importable file is supplied.
Grow with your clients
We propose a recurring commission for as long as the referred client stays. The rate and terms are agreed in a call.
Import formats vary by product and version: CONTPAQi Contabiliza · journal import · CONTPAQi Contabilidad Nube · import layout.
Design the close with your firm.
This workspace is public and fictional. We will review categories, rules, export layout and partnership terms together before handling real data.