Calculate exclusive and inclusive 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-included gross is divided by 1+rate before tax is separated.
Calculate exclusive and inclusive tax — complete worked case
Tax-included gross is divided by 1+rate before tax is separated.
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. 2.1 Calculate
Label each amount exclusive/inclusive/exempt before multiplying.
You should see: Price mode remains visible beside each invoice.
2. 2.2 Calculate
Calculate T1 tax 10/gross 110 from its pretax 100.
You should see: Exclusive adds tax.
3. 2.3 Calculate
Divide T3 gross 55 by 1.10 and subtract to isolate tax 5.
You should see: Inclusive contains tax.
4. 2.4 Calculate
Test changed inclusive 88: net 80, tax 8; reconcile gross 88.
You should see: Net plus tax equals the collected gross.
What to finish
A price-mode calculator record and invoice reconciliation.
Watch for this
Multiplying a tax-included gross by the rate as though it were pretax.
How can I tell I understand it?
Verify that your completed price-mode calculator record and invoice reconciliation 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 price-agreement, tax-included notices, mathematical computation and excess collection sections. California source illustrates why current local rules need verification; fictional Town F 10% is not a California rate.
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.