Client desk: (908) 444-6373 · booking@mcc-solutionsnj.com Online 7AM–9PM ET daily · Mobile Mon–Sat · ← MCC Solutions home
MCCMCC Solutions 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 · 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.

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 with example data
Trial Balance tab with example data. Made-up numbers.
Statements tab with example data
Statements tab with example data. Made-up numbers.

Get it

Accounting Student Study Workbook

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

Delivered as a zip of editable Word files and printable PDFs. For one business, your own use. General information and templates, not legal, tax or accounting 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.

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.

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.

Call (908) 444-6373Buy $19