Reconcile collected and remitted tax
See this course’s project requirements
A fictional sales-tax register with taxable/exempt classification, inclusive/exclusive prices, returns, remittance reconciliation and verification questions.
Keep your working files in your own notebook or software. Save a private description, checklist, and work link in My Proof.
What to include
- A transaction-rule and exemption-evidence register.
- A price-mode calculator record and invoice reconciliation.
- A revenue-versus-tax collection journal.
- A source-linked return and revenue/tax refund bridge.
- A tax payable roll-forward with remittance evidence.
- A fictional transaction-tax handoff with supported totals and verification questions.
Review and revise
Use these criteria to check your work and choose what to improve.
- Rules: transaction modes and support are correct.
- Arithmetic: inclusive/exclusive/return amounts reconcile.
- Liability: opening/current/paid/closing roll forward.
- Handoff: practice scope and real verification questions remain explicit.
Want more background?
The idea in everyday life
Original fictional practice. All money is USD. No account, payment, personal record or outside participation is required. Fictional Town F exercise rule only: printed goods taxable 10%; editing service exempt; resale goods exempt only with the supplied valid practice certificate. Round tax per invoice to cents. T1 printed goods 100 before tax (cash 110); T2 editing 40 exempt (cash 40); T3 printed goods 55 tax-included; T4 resale print goods 80 with valid certificate (cash 80). R1 is a same-period return of 20 pretax from T1 plus its 2 tax refund. Opening tax payable 7; remitted 12 during the period. These are invented rates/exemptions/return rules, not California law. Supplied synthetic support records: CERT-T4 is certificate RES-F-204 for customer Practice Reseller R-4, permitted goods resale under Town F’s invented rule, status valid on the practice sale date 2026-04-14. Opening record TAX-OPEN-7 is the reviewer-approved prior-period liability reconciliation dated 2026-03-31, carrying 7 into April. Payment record PAY-APR-12 dated 2026-04-20 records authorized remittance 12, cash-ledger reference CASH-P12 and matching synthetic bank debit BANK-P12, status settled. These original record labels establish exercise matching only, not actual legal certification or a real payment.
Tax liability balance follows obligations, not one period’s sales total alone.
Reconcile collected and remitted tax — complete worked case
Tax liability balance follows obligations, not one period’s sales total alone.
Fictional Town F exercise rule only: printed goods taxable 10%; editing service exempt; resale goods exempt only with the supplied valid practice certificate. Round tax per invoice to cents. T1 printed goods 100 before tax (cash 110); T2 editing 40 exempt (cash 40); T3 printed goods 55 tax-included; T4 resale print goods 80 with valid certificate (cash 80). R1 is a same-period return of 20 pretax from T1 plus its 2 tax refund. Opening tax payable 7; remitted 12 during the period. These are invented rates/exemptions/return rules, not California law. Supplied synthetic support records: CERT-T4 is certificate RES-F-204 for customer Practice Reseller R-4, permitted goods resale under Town F’s invented rule, status valid on the practice sale date 2026-04-14. Opening record TAX-OPEN-7 is the reviewer-approved prior-period liability reconciliation dated 2026-03-31, carrying 7 into April. Payment record PAY-APR-12 dated 2026-04-20 records authorized remittance 12, cash-ledger reference CASH-P12 and matching synthetic bank debit BANK-P12, status settled. These original record labels establish exercise matching only, not actual legal certification or a real payment.
Original invoice/return register
Paste at A1.
| AID | BItem | CPrice mode | DAmount | ESupport |
|---|---|---|---|---|
| T1 | Exclusive | 100 | Taxable | |
| T2 | Editing | Exempt | 40 | Fictional rule |
| T3 | Inclusive | 55 | Taxable | |
| T4 | Print for resale | Exempt | 80 | Valid practice certificate |
| R1 | T1 return | Pretax | 20 | Refund 2 tax |
Copy as plain text
1. 5.1 Reconcile
Copy opening liability with its prior reconciliation reference.
You should see: Opening 7 is preserved.
2. 5.2 Reconcile
Bring current net register additions 13 from invoice/return schedule.
You should see: Current net 13 reconciled.
3. 5.3 Reconcile
Match remitted 12 to its payment evidence and reduce the payable.
You should see: Closing 7+13−12=8.
4. 5.4 Reconcile
Change remittance to 15 and recompute closing 5 without changing this period’s earned revenue.
You should see: Settlement changes payable/cash, not sales.
What to finish
A tax payable roll-forward with remittance evidence.
Watch for this
Equating net collection 13 with the ending balance while ignoring opening/remitted amounts.
How can I tell I understand it?
Verify that your completed tax payable roll-forward with remittance evidence meets the three lesson-specific checks and retains the supporting original records.
Quick knowledge check
Answer all 3 questions. Get at least 2 right and the lesson completes automatically.
You’ll get an explanation for each answer. Signed in? Your results save to your account.
Pass the check. We’ll save the progress.
Answer all 3 questions above and get at least 2 right. You can review the explanations and try again.
Go to the knowledge checkTools, templates, and lesson sources
Tools and templates
Tools open in a new tab so you can keep your place here.
Sources and further reading
Explore the references behind this lesson.
Source & access notes · checked 2026-10-01
Read actual public records/audit guidance. All transactions are fictional; record examples do not assert retention rules for every jurisdiction.
Access: Public primary page body opened and relevant sections read through the web reader on 2026-10-01; no account required for reading.
Reuse: Original Life Starter cases, datasets and questions; no source exercise or worked dataset reproduced. Links support further reading.
Source & access notes · checked 2026-10-01
Read total sales, tax included, deductions and returned-merchandise period distinctions. Course does not submit a return or generalize California deductions.
Access: Public primary page body opened and relevant sections read through the web reader on 2026-10-01; no account required for reading.
Reuse: Original Life Starter cases, datasets and questions; no source exercise or worked dataset reproduced. Links support further reading.
Report a problem with this lesson
Tell us what went wrong. Please leave out personal information and private project contents.