---
title: "Accounting Student Study Workbook (Excel) | MCC Solutions"
description: "Excel workbook for learning accounting: enter journal entries and watch the ledger, trial balance, financial statements and ratios build themselves…"
url: "https://mcc-solutionsnj.com/toolkits/accounting-student-study-workbook"
---

Excel workbook

# Accounting Student Study Workbook: Journal Entries, Trial Balance, Statements and Ratios

Type the entries, see the statements update and check your work against the answer key.

**$19** one time · 14-day full refund · example and blank copies · download link by email

Buy now, $19 Try the free starter

🌙 The desk is asleep. The store never is.

Every kit and ebook downloads the moment you pay, day or night. Questions get answered after we open in the morning.

 [Browse the store](/toolkits)

Who it is for

Students in a first accounting or small-business finance course, and self-learners.

Not the right fit if

You need closing entries or corporate and partnership accounting: this covers a simple sole proprietorship only.

Why it is different

- Everything flows from the journal, so you see how one entry changes every statement.
- Practice problems have an answer key on a separate tab and show which accounts match.
- A filled example for an invented business and a blank copy with all formulas working.

What is inside

- **Start Here.** How to study with it and the debit and credit rule in a few lines.
- **Chart of Accounts.** About forty accounts with type, normal balance and a plain description.
- **Journal.** Up to 200 lines with a check that each entry balances.
- **Ledger.** Totals and ending balance for each account.
- **Trial Balance.** Built from the journal, with a tie-out.
- **Statements.** Income statement, owner's equity and balance sheet.
- **Ratios.** Current ratio, margins, returns and turnover, each with a plain-English explanation.
- **Practice Set.** Three short practice problems with answer boxes.
- **Answer Key.** Correct entries and totals on a separate sheet.
- **Adjusting Entries Guide.** Accruals, prepaid expenses and depreciation with examples.
- **Depreciation.** Straight-line and double-declining schedules with a chart.
- **Cheat Sheet.** A one-page summary of the equation, debit and credit table and ratio formulas.
- **Checks.** Flags entries that do not balance and statements that do not tie.

A look inside

## Example data, real formulas

[![Trial Balance tab of the Accounting Student Study Workbook, with example data](/img/toolkits/accounting-student-study-workbook/a.png)](/img/toolkits/accounting-student-study-workbook/a.png)

Trial Balance tab with example data. Made-up numbers.

[![Statements tab of the Accounting Student Study Workbook, with example data](/img/toolkits/accounting-student-study-workbook/b.png)](/img/toolkits/accounting-student-study-workbook/b.png)

Statements tab with example data. Made-up numbers.

Get it

## Accounting Student Study Workbook

Or pay with PayPal

Uses the email and terms box above. You get the same download link by email.

ZIP code (for sales tax)

Want every toolkit? The [toolkit membership](/membership) includes all of them, with a lower rate if you pay yearly.

Get every update for a year, $29: the [Yearly Updates Pass](/updates-pass?kit=accounting-student-study-workbook) gives you each refreshed edition we release of the kits you own. One payment, no automatic renewal.

Delivered as a zip with a filled example and a blank copy. Built for Excel, tested in LibreOffice; it should open in Google Sheets but not every feature is tested there. For one business, your own use. General information, not accounting, tax or legal advice. A study aid for a simple sole proprietorship; it has no closing entries. It does not replace your textbook or instructor. Rules of thumb for ratios are general guidance and vary by industry. Not tax or accounting advice. Tested by recalculation and by checking sample figures; not opened in every version of Excel. Payment is handled by Stripe. If a file will not open or something looks wrong, reply to your order email and we will make it right.

Ways to get it

## Just this kit, or more

This kit

**$19 one time**

Accounting Student Study Workbook.

Buy this kit

Membership

**$29 a month**

Every kit and document pack in the store, including new ones. Cancel any time.

[See the membership](/membership)

Questions

## Common questions

**What do I get and how is it delivered?**

The Accounting Student Study Workbook as two Excel files in one zip: a filled-in EXAMPLE so you can see every tab working, and a BLANK copy for your own numbers, plus a README. The download link arrives by email after payment.

**Will it open on a Mac, Google Sheets or my phone?**

Built for Excel and tested in LibreOffice, which runs on Mac and Windows; it should open in Google Sheets, but not every feature is tested there. Phone spreadsheet apps are not tested. If a file will not open or something looks wrong, reply to your order email and we will make it right. If it is not right for you, email us within 14 days of buying for a full refund.

**Is this legal or tax advice?**

No, it is not tax or accounting advice.

**Is it the right fit for me?**

It is made for students in a first accounting or small-business finance course, and self-learners. Skip it if you need closing entries or corporate and partnership accounting: this covers a simple sole proprietorship only.

Free starter

### Try a free one-tab version first

A small working Excel file with the same kind of math, filled with made-up example numbers you can type over. We send one confirmation email, and no series follows.

Read the book

### Bookkeeping Fundamentals

A college-level bookkeeping course, without the tuition. By Matthew Colt, $9.99 as an ebook (EPUB and PDF).

[See the book](/toolkits/bookkeeping-fundamentals-ebook) [Read the first pages free](/toolkits/bookkeeping-fundamentals-ebook#free-starter)

Rather hand it off?

### We can keep the books for you each month

If tracking this yourself is more than you want to take on, we do monthly bookkeeping in QuickBooks, Xero or Excel. Tell us what you use and what is behind, and we reply with a written quote after a short review of your books. No obligation.

[Get a bookkeeping quote](/bookkeeping/#interest) [Free books health check](/bookkeeping/health-check)

Prefer to keep it yourself but want a hand getting started? [Book a 45 minute setup session](/workbook-setup-session) ($65).

Also from MCC Solutions

[### Month-End Close Workbook A real month-end close in one Excel file. It tells you when a rec does not tie, which variances still need an answer, and when the period is ready to lock. $19](/toolkits/month-end-close-workbook)[### Sales-Channel Profit Tracker Which channel makes you money, and which one only looks busy? Sales minus cost of goods, shipping, platform and card fees and event costs, by channel, by event and by month. $24](/toolkits/sales-channel-profit-tracker)

## More bookkeeping and business toolkits

- [Administrative and Office Resume Template Pack](/toolkits/administrative-office-resume-template-pack) $15
- [AI Prompt Pack for Bookkeepers and Notaries](/toolkits/ai-prompt-pack-bookkeepers-notaries) $19
- [AI Rules Compliance Organizer for Small Businesses](/toolkits/ai-rules-compliance-organizer) $24
- [AI Workflow Kit for Auto Repair Shops](/toolkits/ai-workflow-kit-auto-repair-shops) $19
- [AI Workflow Kit for Contractors and Home Services](/toolkits/ai-workflow-kit-contractors-home-services) $19
- [AI Workflow Kit for Fitness Studios and Personal Trainers](/toolkits/ai-workflow-kit-fitness-studios-trainers) $19

[See every toolkit and document pack](/toolkits/all)

## Rather have someone do the books?

[Get a Bookkeeping Quote](/bookkeeping/#interest)[Call (908) 444-6373](tel:+19084446373)
