Client desk: (908) 444-6373 · Text us · booking@mcc-solutionsnj.com Online 7AM–9PM ET daily · Mobile Mon–Sat · ← MCC Solutions home
MCCMCC Solutions Account Buy now, $19

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

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
Trial Balance tab with example data. Made-up numbers.
Statements tab of the Accounting Student Study Workbook, with example data
Statements tab with example data. Made-up numbers.

Get it

Accounting Student Study Workbook

Choose what to get

One-time prices. You pay only for the option you choose.

License

Team and organization licenses let you share the files within your organization. No resale or public posting. The multiple applies to the main product; an add-on or Updates Pass chosen with it keeps its own price. How licenses work.

Gift

14-day full refund. If it is not right for you, email us within 14 days and we refund you in full. Terms

Secure checkout by Stripe · instant download right after payment, link also by email · files: Excel (.xlsx) · one-time price, no subscription · plus sales tax where applicable · made by MCC Solutions in Cranford, NJ

Or pay with PayPal

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

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

Get every update for a year, $29: the Yearly Updates Pass 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

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 Read the first pages free

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 Free books health check

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

Rather have someone do the books?

Get a Bookkeeping QuoteCall (908) 444-6373

Rather talk first? Leave your number and we'll call you.

CallTextBuy $19