--- title: "Medical and Dental Practice Bookkeeping Kit (Excel) | MCC" description: "Excel workbook for a small practice: chart of accounts, close checklist, patient, insurance and card deposit reconciliation, A/R aging by payer and owner draws." url: "https://mcc-solutionsnj.com/toolkits/medical-dental-practice-bookkeeping-kit" --- Document pack # Medical and Dental Practice Bookkeeping Kit: Chart of Accounts, Deposit Reconciliation, A/R Aging by Payer and Monthly Close Tie patient payments, insurance remittances and card deposits back to the billing system every month, without putting patient information in the books. **$29** one time · 14-day full refund · Word and PDF · download link by email Buy now, $29 Free sample 🌙 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 Owners, office managers and bookkeepers of small medical, dental and therapy practices that keep their own books alongside a billing system. Not the right fit if You need a billing system, payroll or HIPAA compliance advice, or your books are kept by a firm with its own close process: this works from totals you type each month. Why it is different - Every source says TIES or DOES NOT TIE against the billing system, with card fees and deposits in transit. - Works from totals and payer groups only; a Checks sheet scans references for words like DOB or diagnosis. - Formulas recalculate with zero errors, blank and filled with example figures. What is inside - **Practice bookkeeping workbook (Excel).** Chart of accounts, a dated close checklist, deposit reconciliation by source, A/R aging by payer group, provider production and collections, and owner pay and draws. - **Start here.** How the two money systems fit together, your first hour and how the workbook is laid out. - **Separating patient-pay, insurance and card deposits.** How each stream arrives, clearing accounts, a monthly routine, a worked example and what to check when it doesn't tie. - **Keeping patient information out of the books.** A short HIPAA note: plain do and don't rules for memos, refunds, attachments and access, with HHS's minimum necessary page. - **Monthly close checklist.** 23 steps by business day, printable, with initials and dates. A look inside ## The first pages, as you will get them [![Page 1 of the Start Here (Medical and Dental Practice Bookkeeping Kit)](/img/toolkits/medical-dental-practice-bookkeeping-kit/doc-1.webp)](/img/toolkits/medical-dental-practice-bookkeeping-kit/doc-1.webp) First page of Start Here [![Page 1 of the Separating Patient Insurance and Card Deposits (Medical and Dental Practice Bookkeeping Kit)](/img/toolkits/medical-dental-practice-bookkeeping-kit/doc-2.webp)](/img/toolkits/medical-dental-practice-bookkeeping-kit/doc-2.webp) First page of Separating Patient Insurance and Card Deposits Get it ## Medical and Dental Practice Bookkeeping Kit 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=medical-dental-practice-bookkeeping-kit) gives you each refreshed edition we release of the kits you own. One payment, no automatic renewal. 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. General information, not legal, tax, accounting or HIPAA compliance advice. Ask your CPA how owners should be paid for your entity type, and your compliance advisor about patient privacy. Not a billing or accounting system. 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 **$29 one time** Medical and Dental Practice Bookkeeping Kit. 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's in the download?** An Excel workbook and four Word and PDF documents: start here, a guide to separating patient, insurance and card deposits, a note on keeping patient information out of the books, and a printable monthly close checklist. **Do I have to enter patient information?** No, and you shouldn't. Every sheet works from totals, payer groups, provider names and reference numbers. The Checks sheet scans reference and note columns for words like DOB, diagnosis or SSN. **Does it connect to my billing or accounting software?** No. You type monthly totals from the billing system's reports and your bank and processor statements. It's a reconciliation and review workbook, not a billing or accounting system. **Does it decide how owners should be paid?** No. The owner pay sheet records draws, guaranteed payments, payroll wages, reimbursements and contributions. Which ones apply depends on how the practice is organized; ask your CPA. **Is this HIPAA compliance advice?** No. The HIPAA note is general and links to HHS's minimum necessary guidance. Ask your compliance advisor or attorney about your practice's obligations. Free sample ### Try one page first Get a real page or file from this product by email. We send one confirmation email, and no series follows. 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 - [Medical Bill Help Kit](/toolkits/medical-bill-help-kit) $12 - [Medicare Part D Cost-Cap Tracker](/toolkits/part-d-cost-cap-tracker) $9 - [Michigan Employer Compliance Kit 2027](/toolkits/michigan-employer-compliance-kit-2027) $19 - [Michigan Landlord Compliance Kit](/toolkits/michigan-landlord-compliance-kit) $19 - [Michigan Small Claims Court Kit](/toolkits/michigan-small-claims-court-kit) $19 - [Michigan Unemployment Checklist](/toolkits/michigan-unemployment-checklist) $15 [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)