Free Manual D Calculation

Manual Debtor Tracking Without the Software License

I've been doing this for fifteen years across several industries. The short version: Free Manual D Calculation is essentially what every small business does when they can't afford QuickBooks or just prefer paper and spreadsheets. It's tracking who owes you money, when they owe it, and how old the debt is, all by hand. The D stands for debtor. In accounting terms, it's the left side of your ledger. You're calculating three things: the total amount owed by each customer, the age of each invoice (current, 30 days, 60 days, 90+ days), and the projected cash flow from collections over a set period. That's it. No fancy algorithms. Just arithmetic and a well-organized spreadsheet or notebook. Most people complicate this more than it needs to be because they're trying to replicate what commercial software handles automatically. Don't. Start simpler.

Setting Up Your Manual System

Create columns for: Invoice Number, Customer Name, Invoice Date, Due Date, Original Amount, Amount Paid, Balance Due, Days Past Due, and Aging Bucket. That's eleven columns. Not eleven sheets. Eleven columns in one workbook. Enter data weekly. I know people want to enter daily, but for small operations, weekly is the sweet spot. Daily entry becomes administrative overhead that eats into actual collection work. Weekly gives you enough recency to catch issues without drowning in data. Use absolute references in your formulas. If you're building this in Google Sheets or Excel, your Days Past Due formula should lock the invoice date cell with $ signs. Otherwise, dragging the formula down will break your references and you'll spend an hour chasing mismatches. I learned that the hard way on a client's February statement. Three hours I didn't get back.

Calculating the Aging Buckets Manually

Here's where most beginners mess up. The aging bucket is not just "how many days old is this invoice?" It's "how many days past the due date is this invoice?" An invoice issued January 1st with terms Net 30 is not overdue until February 1st. Calculate the difference between today's date and the due date, not the invoice date. This changes everything about how you read your own data. Once you have the days past due, assign buckets:

• 0-30 days past due: Current
• 31-60 days past due: Early delinquent
• 61-90 days past due: Serious
• 91+ days past due: Collections territory

Sum each bucket by customer. Sum by total. This gives you your debtor profile in five minutes. Partial payments. A customer pays half of a $10,000 invoice after 45 days. Your spreadsheet now has a balance of $5,000 and the aging is still pulling from the original invoice date. That's wrong. The remaining $5,000 should effectively reset its aging clock from the payment date, because the customer has demonstrated willingness to pay. Keeping the original due date inflates your delinquent numbers and skews your cash flow projections. My workaround: add a second row for each invoice that receives a partial payment. Label it "Payment Received - [Date]" and calculate the remaining balance with a new effective due date. Yes, it doubles your rows for split payments. No, it isn't worth the headache of trying to force it into one row. I tried that once for six months. It was worse.

Collectibility Estimation

This is the part most free manual systems skip, and it's the part that makes the difference between a tracking tool and a decision-making tool. Assign a collectibility percentage to each aging bucket: Multiply each balance by its percentage. The result is your estimated collectible amount. This is rough. It's not precise. But it's faster and more honest than pretending every invoice in the Current bucket will be paid next week. I've seen businesses miss cash crunches because their manual system showed $200,000 in receivables and they acted like all $200,000 was coming in. It wasn't. Half of it was 90-day overdue by the time they noticed. Multi-currency invoicing. If you issue invoices in three different currencies and your customers pay in a fourth, manual calculations become a spreadsheet nightmare within a month. Get software for that.

High transaction volume. More than 200 outstanding invoices at any given time and the manual process slows down to the point of being useless. You're spending more time updating the sheet than actually collecting. Automated reminders. Manual systems don't send follow-up emails. Someone has to read the aging report and decide who to call. That someone is you, every Friday afternoon.

A Practical Workflow

Every Monday, pull your current invoice list. Update payments received over the weekend. Recalculate aging buckets. Review the 61+ day column. Call those customers. Document the conversation in a notes column. Repeat every week. The cycle takes about 45 minutes for a typical small business with under 100 active invoices. If it's taking longer, your spreadsheet structure is wrong and you need to simplify it, not add more columns. The system works because it's transparent. You see every number. You understand every formula. When something looks wrong, you can trace it back in thirty seconds. Software sometimes hides that visibility behind dashboards and summaries that make it harder to verify accuracy. That's the real advantage. Not cost. Simplicity. Cost is a factor, sure. But the real reason this survives is that you actually know your data instead of trusting a black box to summarize it correctly.