Who owes your marina money

By TidebasePublished Updated 2 min read

How do I see who still owes my marina money, and how much?

List every unpaid invoice with the customer, the amount still open, and how many days it is past due, then group the balances by age: not yet due, 1 to 30, 31 to 60, 61 to 90, and over 90 days. That aging list shows who to call first, because the older a balance gets, the harder it is to collect. It depends where your money is recorded: if invoices live in your marina software and payments land in QuickBooks, Square, or Stripe, you need both to know what is really still open.

Build the aging list

  • Start from invoices, not bookings. A booking is not money owed until it is billed.
  • Take off every payment, credit, and refund applied to each invoice.
  • Count days past the due date, not past the invoice date.
  • Group by customer, so a boater with five small invoices shows as one real balance.

A worked example

Who owes me money, and how much?

$32,400still owed

$7,750 of it is more than 30 days late. Those are the calls that pay off first.

How the number was worked out
Not yet due$18,400
1 to 30 days late$6,250
31 to 60 days late$2,900
61 to 90 days late$1,150
Over 90 days late$3,700
Example numbers. Counted open invoices after payments and credits.

Where balances hide

  • Yard and service work that was finished but never invoiced.
  • Seasonal contracts billed in installments, where a later installment was missed.
  • Payments taken in one system and never matched to the invoice in another, which makes a customer who paid look like they owe.

Common mistakes

  • Chasing the biggest balance instead of the oldest.
  • Trusting an aging list that has not seen this week's card payments.

Ask Tidebase for your own numbers

Add the exports you already download, or connect QuickBooks, Square, or Stripe. Then type or say the question, and get one clear answer with how it was counted.

  • Who owes me money, and how much?
  • Why did less reach the bank than I invoiced in September?
  • Which seasonal contracts end in the next 60 days?
Start your free trial

14 days free · No card needed