Compare what was due with what arrived.
Enter the platform, expected payout, and actual bank deposit. The difference formula shows which rows need another look.
Download a free income and expense spreadsheet for one rental and one month. Add up to 12 payouts and 20 expenses. The file checks bank deposits and shows cash left after expenses.
No email · no account · no payment card · no bank connection
| Date | Platform | Expected payout | Bank deposit | Difference |
|---|---|---|---|---|
| Jul 04 | Airbnb | $722.50 | $722.50 | $0.00 |
| Jul 12 | Vrbo | $550.40 | $550.40 | $0.00 |
Sample data only. Replace the blue input cells with your own totals; formulas stay black.
Use the Lite workbook to close one month without building formulas from scratch. It is intentionally limited, so you can test the routine before deciding whether a full-year workbook fits.
Enter the platform, expected payout, and actual bank deposit. The difference formula shows which rows need another look.
Add the date, category, note, amount, and receipt status for up to 20 expenses. Dropdowns keep repeated labels consistent.
The summary adds bank deposits, subtracts expenses, and shows cash left. It does not file taxes or replace a bookkeeper.
The download is a normal `.xlsx` file. Keep it in Excel, or upload it to Google Drive and open it with Google Sheets.
The file downloads immediately. There is no email gate, account, payment card, or newsletter signup.
Type only in the blue cells. Use totals from your platform statement and bank record; leave the formulas alone.
A zero difference means the two totals match. A non-zero result is a prompt to check payout timing, refunds, or adjustments.
Keep private details out of the file. You do not need guest names, bank account numbers, property addresses, tax IDs, or client records. StaySums cannot see what you enter because the workbook stays with you.
If the routine works for you, the paid workbook keeps the same plain-language approach and adds the capacity, reports, and setup help needed for ongoing use.
| What you get | Monthly Close Lite | StaySums |
|---|---|---|
| Properties | 1 | Up to 5 |
| Time period | 1 month | Full year |
| Capacity | 12 payouts + 20 expenses | 400 bookings + 600 expenses |
| Reports | Simple cash summary | Monthly P&L + dashboard + tax summary |
| Extras | Sample rows + dropdowns | Mileage log + setup guide |
| Excel + Google Sheets | Yes | Yes |
| Price | Free | $49 once |
Get the complete workbook immediately after secure Stripe checkout. No subscription, and there is a 30-day full refund if the file does not fit your setup.
The Lite workbook is deliberately simple. These answers explain what it does, what it leaves out, and where your information goes.
Yes. It is a direct `.xlsx` download for one property and one month. There is no email address, account, payment card, or bank connection required.
Yes. Download the file, upload it to Google Drive, and choose Open with Google Sheets. The formulas, dropdowns, and formatting use compatible features.
One property for one month, with up to 12 platform payouts and 20 expenses. It calculates expected payouts, bank differences, total expenses, and cash left after expenses.
No. You enter only the totals you choose. StaySums does not connect to a booking platform, bank, or the workbook on your device.
No. It organizes one month of income and expenses. It does not file a return or provide tax, legal, accounting, or financial advice.
The complete StaySums workbook covers a full year and up to five rentals, with 400 booking rows, 600 expense rows, monthly profit and loss, a dashboard, tax summary, mileage log, and setup guide.