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
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.
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 checkPrefer to keep it yourself but want a hand getting started? Book a 45 minute 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
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

