About

Thanks so much for building this tool and making it available so economically - all users (small business or otherwise) can and should benefit from using this tool!

I am struggling with one thing though: I manage several farms for my family. As part of that work we pre-pay anticipated expenses for tax reasons in the year prior to using the service, then sometimes get a refund of unused prepay in the year after that year. For example, I might prepay $5000 for to Midwest Electric in Dec 2024 to cover usage in 2025, then get a refund for $500 in early 2026 if (say) we only used $4500 of power in 2025.

I enter those as two transactions, both to Midwest Electric and categorized as Expense, but one with a $5000 debit and the other with a $500 credit. I expected the spreadsheet to give me the net of $4500, but instead it gave me $5500 ... seems like the "expense" entry dominates and the absolute values get added together rather than SUM(Debits) - SUM(Credits).

I got around it by creating a new "Return of Prepay" entry that shows as Income, but then I largely lose the connection to Midwest Electric (and similarly for all the other providers I use).

Is that expected behavior, or am I doing something wrong?

Also, is there somewhere else I should be asking these sorts of questions?

Thank you!!

I am enjoying the updated spreadsheet!

I've been trying to find something simple yet powerful enough to run a smaller farming operation and found this very easy to use and even reports on expenses. I tried using QuickBooks but can't really afford that and its way too much for a small operation.

I'd love to see a Balance Sheet but thanks for a fantastic product!

Hey there, We just downloaded your excel sheet. I can't tell you how much I love it. Its amazing. We have a pretty big sized business that we use quickbooks for. And we found this to use for our rental properties! Its amazing and I love it. My question is.... So the tenants pay a security deposit. How would I categorize that in this system? I know its not income... Its not really an expense. Help!

Thank you for the note! I would propose using a separate register worksheet to track those security deposits. And you might consider either not categorizing them at all, or add a new entry in the category list for Security Deposit but don't give it a Category Type.

If I could reach through this internet connection I’d kiss you right on the lips! I have been looking desperately for an easy to use checkbook program for a small group that wouldn’t break the bank AND that a novice Excel user could relate to. I did try to get fancy one time and wiped out part of my page, but with a small nudge from my Excel expert kids, everything is now back to rights.

I absolutely recommend this product, especially for those old folks like me that need an easy to use, but very useful, checking accounting program. 5 Stars!