Nurse Bookkeeping Spreadsheet 2027 | Mrs Tenisha Collins

Nurse Bookkeeping Spreadsheet 2027 | Mrs Tenisha Collins

Sale price  $16.99 USD Regular price  $27.99 USD
Skip to product information
Nurse Bookkeeping Spreadsheet 2027 | Mrs Tenisha Collins

Nurse Bookkeeping Spreadsheet 2027 | Mrs Tenisha Collins

Sale price  $16.99 USD Regular price  $27.99 USD

Simple bookkeeping for nurses, designed by accountant Mrs Tenisha Collins with a nurse administrator. One spreadsheet for every way you work.

Staff job, per diem shifts, a travel contract, 1099 side work, or all of the above? This spreadsheet keeps your W-2 pay, tax-free stipends and 1099 income separate, tracks your work expenses and miles, tells you what to set aside for taxes, and warns you before a license or certification expires. Every report fills in automatically.

WHAT'S INCLUDED (12 tabs)
✔ Start Here + Setup: plain-English steps, ready in 10 minutes
✔ Dashboard: your nursing year at a glance with charts
✔ Monthly Summary: income, taxes withheld, expenses and 1099 profit by month
✔ Jobs & Contracts: staff, PRN, travel assignments and 1099 clients with weeks, weekly gross and contract total
✔ W-2 Paychecks: taxable pay, housing and meal stipends, and withholding in their own columns (200 rows)
✔ 1099 Income: contract, consulting and side-gig payments (200 rows)
✔ Expenses: nurse categories like licenses, BLS/ACLS, CE, scrubs, malpractice insurance and travel (400 rows)
✔ Mileage: work miles at the IRS rate, round trips doubled for you
✔ Tax Set-Aside: what to save for each IRS estimated-tax quarter
✔ Licenses & Certs: days left and red/amber/green renewal alerts
✔ CE Log: contact hours add up under each license
✔ Tax Home Log: monthly record for travel nurses who receive stipends

WHY NURSES LOVE IT
• Works for staff, per diem, travel and 1099 contract nurses, or any mix
• Keeps tax-free stipends out of your taxable pay totals
• Only 1099 work counts toward your tax set-aside, so W-2 nurses aren't told to over-save
• Never miss a renewal: expiring credentials turn amber, expired ones turn red
• Color-coded: white cells are for typing; gray cells calculate for you

WORKS WITH
• Microsoft Excel 2010 or newer (Windows and Mac)
• Google Sheets (free; instructions included)

HOW IT WORKS
1. Purchase and download instantly
2. Open in Excel, or upload to Google Drive and open with Google Sheets
3. Follow the Start Here tab

YOU'LL RECEIVE (one instant-download ZIP)
• Nurse_Bookkeeping_2027.xlsx
• How-To-Use guide (PDF)

PLEASE NOTE
• This is a digital download. Nothing will be shipped.
• Software (Excel or a Google account) is not included.
• This is an organizing tool, not tax or legal advice. Consult a licensed tax professional for your situation.
• Due to the digital nature, all sales are final, but message us anytime and we'll gladly help.
• For personal use. Please don't resell or share.

Created by Mrs Tenisha Collins, Accountant, with nursing guidance from Chris Zeriah Collins, MSN, MPH, BSN, RN, nurse administrator.

You may also like